VRM_SOURCE_DOC_LINE_GT
Oracle internal use only. This global temporary table is used in validate customer contracts source data job during internal processing.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
VRM_SOURCE_DOC_LINE_GT_PK |
DOCUMENT_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_LINE_ID | NUMBER | 18 | Yes | Source document line internal identifer. Examples of source document line include sales order line, invoice line, project line, and service contract line. | |
| DOCUMENT_ID | NUMBER | 18 | Source document identifier of line. | ||
| APPLICATION_ID | NUMBER | 18 | Oracle Application identifier of source document. Foreign key to FND applications table. For example, 222 for Receivables invoices, or users can optionally use -1. | ||
| SOURCE_SYSTEM | VARCHAR2 | 120 | Source application of document data to identify source document line. Each integrating application has a unique value, such as EBIZ. | ||
| DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Code of the source document type. | ||
| DOCUMENT_TYPE_ID | NUMBER | 18 | Source document type identifier of various source systems which integrate with revenue management. | ||
| DOC_LINE_ID_INT_1 | NUMBER | First numeric column of the key that identifies source document line in source application. | |||
| DOC_LINE_ID_INT_2 | NUMBER | Second numeric column of the key that identifies source document line in source application. | |||
| DOC_LINE_ID_INT_3 | NUMBER | Third numeric column of the key that identifies source document line in source application. | |||
| DOC_LINE_ID_INT_4 | NUMBER | Fourth numeric column of the key that identifies source document line in source application. | |||
| DOC_LINE_ID_INT_5 | NUMBER | Fifth numeric column of the key that identifies source document line in source application. | |||
| DOC_LINE_ID_CHAR_1 | VARCHAR2 | 30 | First character column of the key that identifies source document line in source application. | ||
| DOC_LINE_ID_CHAR_2 | VARCHAR2 | 30 | Second character column of the key that identifies source document line in source application. | ||
| DOC_LINE_ID_CHAR_3 | VARCHAR2 | 30 | Third character column of the key that identifies source document line in source application. | ||
| DOC_LINE_ID_CHAR_4 | VARCHAR2 | 30 | Fourth character column of the key that identifies source document line in source application. | ||
| DOC_LINE_ID_CHAR_5 | VARCHAR2 | 30 | Fifth character column of the key that identifies source document line in source application. | ||
| DOC_ID_INT_1 | NUMBER | First numeric column of the key that identifies source document in source application. | |||
| DOC_ID_INT_2 | NUMBER | Second numeric column of the key that identifies source document in source application. | |||
| DOC_ID_INT_3 | NUMBER | Third numeric column of the key that identifies source document in source application. | |||
| DOC_ID_INT_4 | NUMBER | Fourth numeric column of the key that identifies source document in source application. | |||
| DOC_ID_INT_5 | NUMBER | Fifth numeric column of the key that identifies source document in source application. | |||
| DOC_ID_CHAR_1 | VARCHAR2 | 30 | First character column of the key that identifies source document in source application. | ||
| DOC_ID_CHAR_2 | VARCHAR2 | 30 | Second character column of the key that identifies source document in source application. | ||
| DOC_ID_CHAR_3 | VARCHAR2 | 30 | Third character column of the key that identifies source document in source application. | ||
| DOC_ID_CHAR_4 | VARCHAR2 | 30 | Fourth character column of the key that identifies source document in source application. | ||
| DOC_ID_CHAR_5 | VARCHAR2 | 30 | Fifth character column of the key that identifies source document in source application. | ||
| DISPLAY_FLAG | VARCHAR2 | 1 | Indicates whether source document line is eligible to be part of customer contract or not. | ||
| DIMENSION_FLAG | VARCHAR2 | 1 | Indicates whether pricing combination is successfully derived for the given document line or not. | ||
| DOCUMENT_DATE | DATE | Date of source document, such as book date for sales order, or invoice date for invoice. | |||
| SATISFACTION_MEASUREMENT_MODEL | VARCHAR2 | 30 | Specifies how satisfaction will be measured and recorded for a performance obligation line. Values are from the lookup type ORA_VRM_SATIS_MEAS_MODEL. | ||
| DEFAULT_SATIS_MEASURE_MODEL | VARCHAR2 | 30 | Default satisfaction measurement model to be used when the revenue rule is not provided from the source product. | ||
| LINE_TYPE | VARCHAR2 | 30 | Source document line type for a project line. Possible values are ORIGINAL for initial baselined approved version, and REVISION for subsequent changes including changes to the revenue budget or for project status changed to closed. | ||
| LINE_NUM | VARCHAR2 | 30 | Source document line number in source application. | ||
| INVENTORY_ORG_CODE | VARCHAR2 | 18 | Item inventory organization code of inventory item on source document line. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Item inventory organization identifier of inventory item on source document line. | ||
| SOURCE_ITEM_NUMBER | VARCHAR2 | 300 | Inventory item number in source application. This column is used to correct data transformation errors. | ||
| ITEM_ID | NUMBER | 18 | Inventory item identifier on source document line. For a single source line, pass values in either ITEM_ID or MEMO_LINE_SEQ_ID columns, but not both. | ||
| ITEM_NUMBER | VARCHAR2 | 300 | Inventory item numeric identifier on source document line. | ||
| ITEM_DESCRIPTION | VARCHAR2 | 240 | Description of inventory item on source document line. | ||
| MEMO_LINE_NAME | VARCHAR2 | 50 | Memo line name of source document line. | ||
| MEMO_LINE_SEQ_ID | NUMBER | 18 | Memo line identifier on source document line. | ||
| ITEM_GROUP_ID | NUMBER | 18 | Item group internal identifier. | ||
| ITEM_TYPE | VARCHAR2 | 10 | Indicates the type of a source document items. Possible values are ITEM, MEMO_LINE and ITEM_GROUP. | ||
| ITEM_TYPE_ID | NUMBER | 18 | Item type unique identifier. Value populated in this column is related to the primary key of the entity provided in ITEM_TYPE. | ||
| TEMPLATE_ID | NUMBER | 18 | Revenue price profile internal identifier | ||
| TEMPLATE_ASSIGNMENT_ID | NUMBER | 18 | Unique identifier of a template assignment. | ||
| TEMPLATE_IN_USE_FLAG | VARCHAR2 | 1 | Indicates whether the template is in-used and cannot be deleted. Possible values are Yes or No. | ||
| TEMPLATE_ASSIGN_IN_USE_FLAG | VARCHAR2 | 1 | Indicates whether the template assignment is in-used and cannot be deleted. Possible values are Yes or No. | ||
| FMV_REPRESENTATION_TYPE | VARCHAR2 | 30 | FMV price representation type. The value is derived from VRM_FMV_REPRESENTATIONS lookup type. | ||
| ELEMENT_TYPE | VARCHAR2 | 30 | Element is a deliverable or separate unit of accounting. Used to group element types for FMV sets. Values are from the lookup VRM_ELEMENT_TYPE. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code of source document. This value must match currency codes in Oracle Fusion General Ledger. | ||
| UOM_CODE | VARCHAR2 | 200 | Unit of measure of inventory item or memo line on source document line. | ||
| QUANTITY | NUMBER | Quantity of inventory item or memo line on source document line. | |||
| UNIT_SELLING_PRICE | NUMBER | Selling price per unit of measure of the inventory item or memo line. | |||
| UNIT_LIST_PRICE | NUMBER | List price per unit of measure of the inventory item or memo line. | |||
| LINE_AMOUNT | NUMBER | Extended line amount on source document line. | |||
| DISCOUNT_AMOUNT | NUMBER | Discount amount of the source document line. | |||
| DISCOUNT_PERCENTAGE | NUMBER | Percentage discount of unit selling price of inventory item or memo line on source document line. This column is used in FMV calculations and compliance processing. | |||
| UNIT_SELLING_PCT_BASE_PRICE | NUMBER | Selling price per unit of measure of the inventory item or memo line as percentage of base price. | |||
| UNIT_LIST_PCT_BASE_PRICE | NUMBER | List price per unit of measure of the inventory item or memo line as percentage of base price. | |||
| BASE_PRICE | NUMBER | Base price per unit of measure of the inventory item or memo line. | |||
| COST_AMOUNT | NUMBER | Cost of inventory item or memo line. This column is used to calculate gross margin percent. | |||
| GROSS_MARGIN_PERCENT | NUMBER | Gross margin percentage for a source line. This column is used in fair market value computation for gross margin percent FMV representation type. | |||
| REVISED_UOM_CODE | VARCHAR2 | 200 | Revised unit of measure code of inventory item or memo line on source document line. | ||
| NET_QUANTITY | NUMBER | Net quantity of source document line. | |||
| NET_UNIT_SALES_PRICE | NUMBER | Unit selling price of the source document line after adjusting return amount. | |||
| NET_UNIT_LIST_PRICE | NUMBER | Net unit list price discount used to validate VSOE value of a MEA line. | |||
| NET_LINE_AMOUNT | NUMBER | Line amount after adjusting return amount. | |||
| NET_DISCOUNT_AMOUNT | NUMBER | Net discount amount of the original line. | |||
| NET_DISCOUNT_PERCENT | NUMBER | Discount percentage after adjusting return amount. | |||
| NET_UNIT_SALES_PCT_BASE_PRICE | NUMBER | Unit sales percent base price after adjusting return amount. | |||
| NET_BASE_PRICE | NUMBER | Net base price after adjusting return amount. | |||
| REVISED_COST | NUMBER | Adjusted cost of sale after the document is revised. | |||
| REVISED_GROSS_MARGIN_PERCENT | NUMBER | Adjusted gross margin of sales after the document is revised. | |||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifier of source document. | ||
| ACCOUNTING_RULE_NAME | VARCHAR2 | 30 | Accounting rule name on the source document line. | ||
| ACCOUNTING_RULE_ID | NUMBER | 18 | Revenue scheduling rule identifier on source document line. Revenue scheduling rule determines the timing of revenue recognition. | ||
| DEFAULT_REVENUE_RULE_ID | NUMBER | 18 | Unique identifier of the revenue scheduling rule. This rule needs to be defaulted on the performance obligation line if no rule is provided by the source application. | ||
| RULE_START_DATE | DATE | Revenue recoginition start date for revenue rule types, such as daily revenue rate, all periods or daily revenue rate, and partial periods. | |||
| ACCOUNTING_RULE_DURATION | NUMBER | Number of periods in which revenue of this performance obligation line is to be recognized. | |||
| RULE_END_DATE | DATE | Revenue recoginition end date for revenue rule types, such as daily revenue rate, all periods or daily revenue rate, and partial periods. | |||
| ORIG_SYS_BILL_TO_CUST_REF | VARCHAR2 | 255 | Original application bill-to customer reference on source document line. | ||
| ORIG_SYS_BILL_TO_CUST_SITE_REF | VARCHAR2 | 255 | Original application bill-to customer site reference on source document line. | ||
| BILL_TO_CUSTOMER_PARTY_ID | NUMBER | 18 | Party identifier of bill-to customer on source document line. | ||
| BILL_TO_CUSTOMER_PARTY_NUM | VARCHAR2 | 30 | Party name of bill-to customer on source document line. | ||
| BILL_TO_CUSTOMER_PARTY_NAME | VARCHAR2 | 360 | Party number of bill-to customer line. | ||
| BILL_TO_CUSTOMER_ID | NUMBER | 18 | Account identifier of bill-to customer on source document line. | ||
| BILL_TO_CUSTOMER_NUM | VARCHAR2 | 30 | Account number of bill-to customer on source document line. | ||
| BILL_TO_CUST_CLASSIFICATION | VARCHAR2 | 60 | Customer classification of bill-to customer on source document line. Values are from the lookup CUSTOMER_CLASS. Value at source document line level takes precedence over value at source document level. | ||
| BILL_TO_CUSTOMER_SITE_ID | NUMBER | 18 | Site identifier of bill-to customer on source document line. | ||
| BILL_TO_CUSTOMER_STATE | VARCHAR2 | 60 | State code of bill-to customer on source document line. | ||
| BILL_TO_CUSTOMER_COUNTY | VARCHAR2 | 60 | County of bill-to customer on source document line. | ||
| BILL_TO_CUSTOMER_CITY | VARCHAR2 | 60 | City of bill-to customer on source document line. | ||
| BILL_TO_CUSTOMER_POSTAL_CODE | VARCHAR2 | 60 | Postal code of bill-to customer on source document line. | ||
| BILL_TO_COUNTRY | VARCHAR2 | 60 | Country code of bill-to customer on source document line. | ||
| ORIG_SYS_SHIP_TO_CUST_REF | VARCHAR2 | 255 | Original application ship-to customer reference on source document line. | ||
| ORIG_SYS_SHIP_TO_CUST_SITE_REF | VARCHAR2 | 255 | Original application ship-to customer site reference on source document line. | ||
| SHIP_TO_CUSTOMER_ID | NUMBER | 18 | Account identifier of ship-to customer on source document line. | ||
| SHIP_TO_CUSTOMER_NUM | VARCHAR2 | 30 | Account number of ship-to customer on source document line. | ||
| SHIP_TO_CUSTOMER_SITE_ID | NUMBER | 18 | Name of ship-to customer on source document line. | ||
| PREV_DOCUMENT_LINE_ID | NUMBER | 18 | Reference document line internal identifier. | ||
| REFERENCE_SOURCE_SYSTEM | VARCHAR2 | 120 | Source instance of reference document line. For example, the reference key linking a credit memo line to the original invoice line | ||
| REFERENCE_DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Document type code of the reference source document. | ||
| REFERENCE_DOCUMENT_TYPE_ID | NUMBER | 18 | Document type identifier of reference document line. For example, the reference key linking a credit memo line to the original invoice line. | ||
| REF_DOC_LINE_ID_INT_1 | NUMBER | First character column of reference key that identifies parent source document line in source application for a return or revision line. For example, the reference key linking a credit memo line to the original invoice line. | |||
| REF_DOC_LINE_ID_INT_2 | NUMBER | Second character column of reference key that identifies parent source document line in source application for a return or revision line. For example, the reference key linking a credit memo line to the original invoice line. | |||
| REF_DOC_LINE_ID_INT_3 | NUMBER | Third character column of reference key that identifies parent source document line in source application for a return or revision line. For example, the reference key linking a credit memo line to the original invoice line. | |||
| REF_DOC_LINE_ID_INT_4 | NUMBER | Fourth character column of reference key that identifies parent source document line in source application for a return or revision line. For example, the reference key linking a credit memo line to the original invoice line. | |||
| REF_DOC_LINE_ID_INT_5 | NUMBER | Fifth character column of reference key that identifies parent source document line in source application for a return or revision line. For example, the reference key linking a credit memo line to the original invoice line. | |||
| REF_DOC_LINE_ID_CHAR_1 | VARCHAR2 | 30 | First numeric column of reference key that identifies parent source document line in source application for a return or revision line. For example, the reference key linking a credit memo line to the original invoice line. | ||
| REF_DOC_LINE_ID_CHAR_2 | VARCHAR2 | 30 | Second numeric column of reference key that identifies parent source document line in source application for a return or revision line. For example, the reference key linking a credit memo line to the original invoice line. | ||
| REF_DOC_LINE_ID_CHAR_3 | VARCHAR2 | 30 | Third numeric column of reference key that identifies parent source document line in source application for a return or revision line. For example, the reference key linking a credit memo line to the original invoice line. | ||
| REF_DOC_LINE_ID_CHAR_4 | VARCHAR2 | 30 | Fourth numeric column of reference key that identifies parent source document line in source application for a return or revision line. For example, the reference key linking a credit memo line to the original invoice line. | ||
| REF_DOC_LINE_ID_CHAR_5 | VARCHAR2 | 30 | Fifth numeric column of reference key that identifies parent source document line in source application for a return or revision line. For example, the reference key linking a credit memo line to the original invoice line. | ||
| REVENUE_REVERSAL_METHOD | VARCHAR2 | 30 | Revenue reversal method used to reverse the revenue. | ||
| VERSION_NUMBER | NUMBER | 9 | Source document line version when document versioning is supported. For example, original is 1 and revisions are 2 or more. VERSION_FLAG must be populated when version number is greater than 1. | ||
| VERSION_FLAG | VARCHAR2 | 1 | Indicates whether the current source product line is a version line. Possible values are Y and N. | ||
| LAST_VERSION_FLAG | VARCHAR2 | 1 | Indicates whether the current source product line is latest version line. Possible values are Y and N. | ||
| LAST_PERIOD_TO_CREDIT | NUMBER | Latest source document line version when document versioning is supported. For example, original is 1 and revisions are 2 or more. | |||
| ADD_TO_CONTRACT_FLAG | VARCHAR2 | 1 | Indicates whether a new line from the source system should be added to an existing contract. Blank is equivalent to N. | ||
| ADD_TO_CONTRACT_ACTION_CODE | VARCHAR2 | 30 | Specifies how a new line from the source system should be processed. Values are derived from the lookup type ORA_ADD_TO_CONTRACT_ACTION. Blank is equivalent to ORA_ADD_TO_EXISTING_PO. | ||
| INITIAL_DOCUMENT_LINE_ID | NUMBER | 18 | Reference key that identifies the parent source document line for the current line. | ||
| INITIAL_SOURCE_SYSTEM | VARCHAR2 | 120 | Source system code of the parent document line for the current line. | ||
| INITIAL_DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Document type code of the parent source document line for the current line. | ||
| INITIAL_DOCUMENT_TYPE_ID | NUMBER | 18 | Document type identifier of the parent source document line for the current line. | ||
| INITIAL_DOC_LINE_ID_INT_1 | NUMBER | First character column of the reference key that identifies the parent source document line in the source application for the current line. | |||
| INITIAL_DOC_LINE_ID_INT_2 | NUMBER | Second character column of the reference key that identifies the parent source document line in the source application for the current line. | |||
| INITIAL_DOC_LINE_ID_INT_3 | NUMBER | Third character column of the reference key that identifies the parent source document line in the source application for the current line. | |||
| INITIAL_DOC_LINE_ID_INT_4 | NUMBER | Fourth character column of the reference key that identifies the parent source document line in the source application for the current line. | |||
| INITIAL_DOC_LINE_ID_INT_5 | NUMBER | Fifth character column of the reference key that identifies the parent source document line in the source application for the current line. | |||
| INITIAL_DOC_LINE_ID_CHAR_1 | VARCHAR2 | 30 | First numeric column of the reference key that identifies the parent source document line in the source application for the current line. | ||
| INITIAL_DOC_LINE_ID_CHAR_2 | VARCHAR2 | 30 | Second numeric column of the reference key that identifies the parent source document line in the source application for the current line. | ||
| INITIAL_DOC_LINE_ID_CHAR_3 | VARCHAR2 | 30 | Third numeric column of the reference key that identifies the parent source document line in the source application for the current line. | ||
| INITIAL_DOC_LINE_ID_CHAR_4 | VARCHAR2 | 30 | Fourth numeric column of the reference key that identifies the parent source document line in the source application for the current line. | ||
| INITIAL_DOC_LINE_ID_CHAR_5 | VARCHAR2 | 30 | Fifth numeric column of the reference key that identifies the parent source document line in the source application for the current line. | ||
| MANUAL_REVIEW_REQUIRED_FLAG | VARCHAR2 | 1 | Indicates if contract review should be queued for manual review. Possible values are Y and N. | ||
| REVISION_INTENT_TYPE_CODE | VARCHAR2 | 30 | Revision intent for the source document revision line. Values are from the lookup type ORA_VRM_REVISION_INTENT_TYPE. | ||
| DEFAULT_REVISION_INTENT_CODE | VARCHAR2 | 30 | Default revision intent for the source document type. Values are from the lookup type ORA_VRM_REVISION_INTENT_TYPE. | ||
| PARENT_DOCUMENT_LINE_ID | NUMBER | 18 | Reference key that identifies the top most parent document line for the current line. | ||
| TOP_PARENT_FLAG | VARCHAR2 | 1 | Indicates if the parent is a root node. Y means that the parent in the relationship is at the root node. N means that the parent is not at the root node. | ||
| PARENT_DOCUMENT_LINE_TYPE_CODE | VARCHAR2 | 30 | Specifies the type of top most parent document line sent from the source system. Values are derived from the lookup type ORA_VRM_DOCUMENT_LINE_TYPE. Blank is equivalent to ORA_NEW_LINE. | ||
| DOCUMENT_LINE_TYPE_CODE | VARCHAR2 | 30 | Specifies the type of line sent from the source system. Values are derived from the lookup type ORA_VRM_DOCUMENT_LINE_TYPE. Blank is equivalent to ORA_NEW_LINE. | ||
| MESSAGE_NAME | VARCHAR2 | 30 | Specifies message name for warning line. | ||
| LINE_CREATION_DATE | TIMESTAMP | Who column: indicates the date and time when the source document line was created. | |||
| LINE_LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time when the source document line was created. | |||
| REV_REC_STATUS | VARCHAR2 | 60 | Status of a document line to indicate whether line is processed by revenue. | ||
| SRC_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| DATA_TRANSFORMATION_STATUS | VARCHAR2 | 30 | Oracle internal use only. | ||
| BATCH_NUMBER | NUMBER | 18 | Oracle internal use only. | ||
| CONTRACT_HASH_CODE | VARCHAR2 | 100 | Contract processing unique identifier. | ||
| RECURRING_FLAG | VARCHAR2 | 1 | Indicates whether the line will recur on the line's satisfaction plan end date. Valid values are from the lookup type VRM_YES/NO. | ||
| RECURRING_FREQUENCY | NUMBER | Frequency number of the recurring pattern. | |||
| RECURRING_PATTERN_CODE | VARCHAR2 | 30 | Recurring frequency of the line. Valid values are from the lookup type VRM_RECUR_PATTERN_CODE. | ||
| RECURRING_AMOUNT | NUMBER | Selling amount per frequency for the recurring line. | |||
| TERMINATION_DATE | DATE | Date the line was terminated and will no longer recur automatically. | |||
| IMMATERIAL_CHANGE_CODE | VARCHAR2 | 30 | Immaterial change type for this line. Valid values are from the lookup type ORA_IMMATERIAL_CHANGE_TYPE. | ||
| CONTRACT_MODIFICATION_DATE | DATE | Date on which the revenue contract was modified. | |||
| LATEST_IMMATERIAL_CHANGE_CODE | VARCHAR2 | 30 | Latest immaterial change type for this line. Valid values are from the lookup type ORA_IMMATERIAL_CHANGE_TYPE. | ||
| LATEST_CONTRACT_MOD_DATE | DATE | Latest date on which the revenue contract was modified. | |||
| DEFAULT_IMMATERIAL_CHANGE_CODE | VARCHAR2 | 30 | Default immaterial change type for the source document type. Valid values are from the lookup type ORA_IMMATERIAL_CHANGE_TYPE. | ||
| CONTRACT_RULE_ID | NUMBER | 18 | Internal identifier of the customer contract identification rule. | ||
| CONTRACT_REFERENCE | VARCHAR2 | 1000 | User entered contract reference or grouping attribute values used to identify the contract as derived by enabling the Copy to Reference option in the Contract Identification rule. | ||
| CONTRACT_TYPE | VARCHAR2 | 30 | Oracle internal use only. | ||
| CONTRACT_CLASSIFICATION_CODE | VARCHAR2 | 30 | Classification code of a contract. Values are derived from lookup type ORA_VRM_CONTRACT_CLASSIF_CODE. | ||
| RECUR_LINE_COPY_NUM | NUMBER | 18 | Sequence number of the recurring source document line. | ||
| RECUR_HEADER_COPY_NUM | NUMBER | 18 | Number of times the recurring source document header was copied. | ||
| ORIGINAL_DOCUMENT_LINE_ID | NUMBER | 18 | Original source document line identifier used to create the recurring source document line. | ||
| REVISED_RECURRING_FLAG | VARCHAR2 | 1 | Revised indicator of whether the line will recur on the line's satisfaction plan end date. Valid values are from the lookup type VRM_YES/NO. | ||
| REVISED_RECURRING_FREQUENCY | NUMBER | Revised frequency number of the recurring pattern. | |||
| REVISED_RECUR_PATTERN_CODE | VARCHAR2 | 30 | Revised recurring frequency of the line. Valid values are from the lookup type VRM_RECUR_PATTERN_CODE. | ||
| REVISED_TERMINATION_DATE | DATE | Revised termination date, which is the date the line was terminated and will no longer recur automatically. | |||
| REVISED_RECURRING_AMOUNT | NUMBER | Revised selling amount per frequency for the recurring line. | |||
| REVISED_RULE_END_DATE | DATE | Revised revenue recoginition end date for the revenue scheduling rule. | |||
| REVISED_RULE_START_DATE | DATE | Revised revenue recoginition start date for the revenue scheduling rule. | |||
| REVISED_ACCOUNTING_RULE_ID | NUMBER | 18 | Revised revenue scheduling rule identifier. | ||
| ORIGINAL_DOCUMENT_ID | NUMBER | 18 | Original source document identifier used to create the recurring source document. | ||
| APPLIED_BILL_ENTERED_AMT | NUMBER | Bill line amount applied in entered currency. | |||
| UNIT_SSP | NUMBER | Unit standalone selling price of the item or memo line. | |||
| NET_UNIT_SSP | NUMBER | Net unit standalone selling price of the item or memo line. | |||
| CUSTOMER_CONTRACT_FREEZE_DATE | DATE | The date on which the contract will be frozen for automatic inclusion of new lines by the Identify Customer Contracts program. The value will be defaulted by adding the freeze period defined in the contract identification rule to the contract date. | |||
| RESIDUAL_APPROACH_FLAG | VARCHAR2 | 1 | Indicates the pricing for the goods or services for the line is variable or missing and the standalone selling price for the resulting performance obligation is estimated using the residual approach. Valid values are from the lookup type VRM_YES/NO. | ||
| LIST_PRICE_AMOUNT | NUMBER | List proce amount of the item or memo line | |||
| SERVICE_UOM | VARCHAR2 | 200 | Unit of measure of the service item on the source document line. Valid values are from the Price Periodicity UOM Class defined in Oracle Fusion Pricing. | ||
| REVISED_SERVICE_UOM | VARCHAR2 | 200 | Revised unit of measure of the service item on the source document line. Valid values are from the Price Periodicity UOM Class defined in Oracle Fusion Pricing. | ||
| SERVICE_DURATION | NUMBER | Duration of the service item in terms of the service unit of measure. | |||
| REVISED_SERVICE_DURATION | NUMBER | Revised duration of the service item in terms of the service unit of measure. | |||
| BILL_REF_DOC_LINE_ID_INT_1 | NUMBER | Oracle internal use only. | |||
| BILL_REF_DOC_LINE_ID_INT_2 | NUMBER | Oracle internal use only. | |||
| BILL_REF_DOC_LINE_ID_INT_3 | NUMBER | Oracle internal use only. | |||
| BILL_REF_DOC_LINE_ID_INT_4 | NUMBER | Oracle internal use only. | |||
| BILL_REF_DOC_LINE_ID_INT_5 | NUMBER | Oracle internal use only. | |||
| BILL_REF_DOC_LINE_ID_CHAR_1 | VARCHAR2 | 30 | Oracle internal use only. | ||
| BILL_REF_DOC_LINE_ID_CHAR_2 | VARCHAR2 | 30 | Oracle internal use only. | ||
| BILL_REF_DOC_LINE_ID_CHAR_3 | VARCHAR2 | 30 | Oracle internal use only. | ||
| BILL_REF_DOC_LINE_ID_CHAR_4 | VARCHAR2 | 30 | Oracle internal use only. | ||
| BILL_REF_DOC_LINE_ID_CHAR_5 | VARCHAR2 | 30 | Oracle internal use only. | ||
| BILL_REF_SOURCE_SYSTEM | VARCHAR2 | 120 | Oracle internal use only. | ||
| BILL_REF_DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| BILL_REF_DOCUMENT_TYPE_ID | NUMBER | 18 | Oracle internal use only. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_SOURCE_DOC_LINE_GT_N1 | Non Unique | DATA_TRANSFORMATION_STATUS, DOCUMENT_LINE_TYPE_CODE, TEMPLATE_ASSIGN_IN_USE_FLAG, TEMPLATE_IN_USE_FLAG |
| VRM_SOURCE_DOC_LINE_GT_N2 | Non Unique | BATCH_NUMBER |
| VRM_SOURCE_DOC_LINE_GT_N3 | Non Unique | PARENT_DOCUMENT_LINE_ID |
| VRM_SOURCE_DOC_LINE_GT_U1 | Unique | DOCUMENT_LINE_ID |