VRM_SOURCE_DOC_SUB_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
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_SUB_LINE_ID | NUMBER | 18 | Yes | Source document sub line unique identifier. Examples of source document sub line include invoice line salescredits, contingencies, and project accounting distributions. | |
| DOCUMENT_LINE_ID | NUMBER | 18 | Source document line unique 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 sub line. Foreign key to DOCUMENT_ID in VRM_SOURCE_DOCUMENTS. | ||
| 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. | ||
| SATISFACTION_MEASUREMENT_DATE | DATE | The date on which the satisfaction is measured. | |||
| SATISFACTION_EVENT_QUANTITY | NUMBER | Used to derive the quantity of a satisfaction event when the satisfaction measurement model is Measure Quantity Satisfied. | |||
| SATISFACTION_EVENT_PERCENT | NUMBER | Used to derive the percent of a satisfaction event when the satisfaction measurement model is Measure Percentage Satisfied. | |||
| DOC_SUB_LINE_TYPE | VARCHAR2 | 30 | Document sub line type. Possible values are DISTRIBUTIONS, SALESCREDITS, and CONTINGENCIES. | ||
| DOC_SUB_LINE_LEVEL | VARCHAR2 | 1 | Level of document sub line. Possible values are H for header, and L for line. | ||
| SOURCE_SYSTEM | VARCHAR2 | 120 | Source application of document data to identify source document sub 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 as defined in Manage Revenue Compliance Source Document Types. Foreign key to DOCUMENT_TYPE_ID in the VRM_SOURCE_DOC_TYPES_B table. | ||
| DOC_SUB_LINE_ID_INT_1 | NUMBER | First numeric column of the key that identifies source document sub line in source application. | |||
| DOC_SUB_LINE_ID_INT_2 | NUMBER | Second numeric column of the key that identifies source document sub line in source application. | |||
| DOC_SUB_LINE_ID_INT_3 | NUMBER | Third numeric column of the key that identifies source document sub line in source application. | |||
| DOC_SUB_LINE_ID_INT_4 | NUMBER | Fourth numeric column of the key that identifies source document sub line in source application. | |||
| DOC_SUB_LINE_ID_INT_5 | NUMBER | Fifth numeric column of the key that identifies source document sub line in source application. | |||
| DOC_SUB_LINE_ID_CHAR_1 | VARCHAR2 | 30 | First character column of the key that identifies source document sub line in source application. | ||
| DOC_SUB_LINE_ID_CHAR_2 | VARCHAR2 | 30 | Second character column of the key that identifies source document sub line in source application. | ||
| DOC_SUB_LINE_ID_CHAR_3 | VARCHAR2 | 30 | Third character column of the key that identifies source document sub line in source application. | ||
| DOC_SUB_LINE_ID_CHAR_4 | VARCHAR2 | 30 | Fourth character column of the key that identifies source document sub line in source application. | ||
| DOC_SUB_LINE_ID_CHAR_5 | VARCHAR2 | 30 | Fifth character column of the key that identifies source document sub line in source application. | ||
| 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. | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifier of source document. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
| DATA_TRANSFORMATION_STATUS | VARCHAR2 | 30 | Oracle internal use only. | ||
| PERIOD_ACTION_CODE | VARCHAR2 | 30 | Action type for period satisfaction events. This attribute is required if the subline type is Period. Valid values are from the lookup type ORA_VRM_PERIOD_SUBLINE_ACTION. Reverse indicates that Revenue Management will not recognize revenue from the period satisfaction event effective date to the plan end date. Revenue, if recognized will be reversed during this period. Reinstate indicates that Revenue Management will start recognizing revenue from the period satisfaction event effective date to the effective plan end date. The effective plan end date is calculated as the actual plan end date plus the number of days that revenue was recognized. | ||
| PERIOD_ACTION_EVENT_DATE | DATE | Effective date for the period satisfaction event action. | |||
| PREV_DOCUMENT_SUB_LINE_ID | NUMBER | 18 | Source document subline identifier of the earlier period type subline. When a reinstated subline is received after a reversed subline, this attribute is populated on the reinstated subline. | ||
| ASE_ENTERED_CUR_REVENUE_AMOUNT | NUMBER | Fulfillment amount of the primary satisfaction event in the entered currency. | |||
| ASE_CONT_CUR_ALLOC_REV_AMOUNT | NUMBER | Allocated amount equivalent to the fulfillment amount of the primary satisfaction event in the contract currency. |