VRM_SOURCE_DOC_ADDL_SLINES_GT
Oracle internal use only. This global temporary table is used in an internal process which validates the additional satisfaction events.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_ADDITIONAL_SLINE_ID | NUMBER | 18 | Yes | Unique key generated by the application for an additional subline of a source document. | |
| DOCUMENT_LINE_ID | NUMBER | 18 | Unique key generated by the application for a source document line. Examples of source document lines include sales order lines, invoice lines, project lines, and service contract lines. | ||
| DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | The source document type code from which the source data is imported. | ||
| DOCUMENT_TYPE_ID | NUMBER | 18 | Source document type identifier of various source applications that integrate with Revenue Management. | ||
| DOC_ADDITIONAL_SLINE_ID_INT_1 | NUMBER | First numeric column of the key that identifies the source document additional subline in the source application. | |||
| DOC_ADDITIONAL_SLINE_ID_INT_2 | NUMBER | Second numeric column of the key that identifies the source document additional subline in the source application. | |||
| DOC_ADDITIONAL_SLINE_ID_INT_3 | NUMBER | Third numeric column of the key that identifies the source document additional subline in the source application. | |||
| DOC_ADDITIONAL_SLINE_ID_INT_4 | NUMBER | Fourth numeric column of the key that identifies the source document additional subline in the source application. | |||
| DOC_ADDITIONAL_SLINE_ID_INT_5 | NUMBER | Fifth numeric column of the key that identifies the source document additional subline in the source application. | |||
| DOC_ADDITIONAL_SLINE_ID_CHAR_1 | VARCHAR2 | 30 | First character column of the key that identifies the source document additional subline in the source application. | ||
| DOC_ADDITIONAL_SLINE_ID_CHAR_2 | VARCHAR2 | 30 | Second character column of the key that identifies the source document additional subline in the source application. | ||
| DOC_ADDITIONAL_SLINE_ID_CHAR_3 | VARCHAR2 | 30 | Third character column of the key that identifies the source document additional subline in the source application. | ||
| DOC_ADDITIONAL_SLINE_ID_CHAR_4 | VARCHAR2 | 30 | Fourth character column of the key that identifies the source document additional subline in the source application. | ||
| DOC_ADDITIONAL_SLINE_ID_CHAR_5 | VARCHAR2 | 30 | Fifth character column of the key that identifies the source document additional subline in the source application. | ||
| 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. | ||
| 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. | ||
| ADDITIONAL_SE_TYPE_CODE | VARCHAR2 | 30 | Additional satisfaction event stamped on the revenue line. Valid values are from the lookup type ORA_VRM_ADDL_SATIS_EVENTS. | ||
| ADDITIONAL_SE_FULFILLMENT_DATE | DATE | Fulfillment date of the additional satisfaction event. | |||
| ADDITIONAL_SE_QUANTITY | NUMBER | The quantity for which the additional satisfaction event is fulfilled when the satisfaction measurement model is Quantity. | |||
| ADDITIONAL_SE_PERCENT | NUMBER | The percentage for which the additional satisfaction event is fulfilled when the satisfaction measurement model is Percentage. | |||
| AMOUNT_APPLIED | NUMBER | Amount of receipt applied to the invoice. | |||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifier of source document. | ||
| DATA_TRANSFORMATION_STATUS | VARCHAR2 | 30 | This attribute is for oracle Internal use only. | ||
| ASE_ENTERED_CUR_REVENUE_AMOUNT | NUMBER | Fulfillment amount of the additional satisfaction event in the entered currency. | |||
| ASE_CONT_CUR_ALLOC_REV_AMOUNT | NUMBER | Allocated amount equivalent to the fulfillment amount of the additional satisfaction event in the contract currency. | |||
| ASE_ELIGIBLE_DATE | DATE | Eligible fulfillment date of the additional satisfaction event. | |||
| ASE_PROCESS_ORDER | NUMBER | 6 | Order in which the additional sublines are processed. These lines are processed in the ascending order of the fulfillment dates. | ||
| DOCUMENT_ID | NUMBER | 18 | Unique key generated by the application for a source document. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: Indicates the request ID of the interface load job that created the row. | ||
| ELIGIBLE_ASE_VALUE | NUMBER | Value of the fulfillment of the additional satisfaction event according to the satisfaction measurement model. The value is either the satisfied quantity, satisfied percent, or period equivalent amount. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| VRM_SRC_DOC_ADDL_SLINES_GT_N1 | Non Unique | DOCUMENT_ADDITIONAL_SLINE_ID, ASE_PROCESS_ORDER |
| VRM_SRC_DOC_ADDL_SLINES_GT_N2 | Non Unique | DOCUMENT_LINE_ID |