VRM_SOURCE_DOC_ADDL_SUBLINES
This table contains the fulfillment details of additional satisfaction events details of each promised detail.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
VRM_SOURCE_DOC_ADDL_SLINES_PK |
DOCUMENT_ADDITIONAL_SLINE_ID |
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_ID | NUMBER | 18 | Unique key generated by the application for a source document. | ||
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. | ||
APPLICATION_ID | NUMBER | 18 | Unique identifier of the application that is associated with the source document additional subline. For example, 222 indicates that the transaction is from Receivables. | ||
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 the 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 the related source document. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
CREATED_FROM_CODE | VARCHAR2 | 30 | The process or user interface from which this row is created. | ||
LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
DATA_TRANSFORMATION_STATUS | VARCHAR2 | 30 | 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. | ||
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 | Tablespace | Columns |
---|---|---|---|
VRM_SOURCE_DOC_ADDL_SLINES_N1 | Non Unique | FUSION_TS_TX_DATA | NVL("DOC_ADDITIONAL_SLINE_ID_INT_1",(-1)), NVL("DOC_ADDITIONAL_SLINE_ID_INT_2",(-1)), NVL("DOC_ADDITIONAL_SLINE_ID_INT_3",(-1)), NVL("DOC_ADDITIONAL_SLINE_ID_INT_4",(-1)), NVL("DOC_ADDITIONAL_SLINE_ID_INT_5",(-1)), NVL("DOC_ADDITIONAL_SLINE_ID_CHAR_1",'X'), NVL("DOC_ADDITIONAL_SLINE_ID_CHAR_2",'X'), NVL("DOC_ADDITIONAL_SLINE_ID_CHAR_3",'X'), NVL("DOC_ADDITIONAL_SLINE_ID_CHAR_4",'X'), NVL("DOC_ADDITIONAL_SLINE_ID_CHAR_5",'X'), DOCUMENT_TYPE_ID, SOURCE_SYSTEM |
VRM_SOURCE_DOC_ADDL_SLINES_N2 | Non Unique | FUSION_TS_TX_DATA | DOCUMENT_LINE_ID |
VRM_SOURCE_DOC_ADDL_SLINES_N3 | Non Unique | FUSION_TS_TX_DATA | DATA_TRANSFORMATION_STATUS |
VRM_SOURCE_DOC_ADDL_SLINES_U1 | Unique | FUSION_TS_TX_DATA | DOCUMENT_ADDITIONAL_SLINE_ID |