VRM_SOURCE_DOC_SUB_LINES
This object stores document data from the upstream applications, which is at a sub level to either document header or document line.
Details
-
Schema: FUSION
-
Object owner: VRM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
VRM_SOURCE_DOC_SUB_LINES_PK |
DOCUMENT_SUB_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOCUMENT_SUB_LINE_ID | NUMBER | 18 | Yes | System-generated unique key for source document sub line. Examples of source document sub line include invoice line salescredits, contingencies, and project accounting distributions. | |
| DOCUMENT_LINE_ID | NUMBER | 18 | System-generated unique key for source document line. 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. 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. | ||
| 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_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. | ||
| 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. | ||
| LINE_NUMBER | NUMBER | 18 | Source document sub line number, based on a running sequence. Internal use only. | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| LEDGER_ID | NUMBER | 18 | Ledger identifier of source document. | ||
| SUB_LINE_CREATION_DATE | TIMESTAMP | Yes | Date and time of the creation of document sub line in source application. | ||
| SUB_LINE_LAST_UPDATE_DATE | TIMESTAMP | Yes | Date and time of the last update of document sub line in source application before extraction to Revenue Management. | ||
| ACCOUNT_CLASS | VARCHAR2 | 20 | Account class of source document sub line. Value is REV for sub line type DISTRIBUTIONS. | ||
| AMOUNT | NUMBER | Revenue amount on source document sub line in entered currency. This column is valid for sub line type DISTRIBUTIONS. | |||
| ACCTD_AMOUNT | NUMBER | Revenue amount on source document sub line in ledger currency. This column is valid for sub line type DISTRIBUTIONS. | |||
| ACCOUNTING_DATE | DATE | Accounting date on which the source document sub line is posted in source application. This column is valid for sub line type DISTRIBUTIONS. | |||
| SLA_POSTED_FLAG | VARCHAR2 | 1 | Indicates whether the current source document sub line is posted in source application Possible values are Y and N. This column is valid for sub line type DISTRIBUTIONS. | ||
| SLA_POSTED_DATE | DATE | Posted date of current source document sub line in source application. This column is value for sub line type DISTRIBUTIONS. | |||
| SOURCE_ACCOUNT_CCID | NUMBER | 18 | Oracle internal use only. | ||
| SOURCE_SALESREP_NAME | VARCHAR2 | 80 | Oracle internal use only. | ||
| SOURCE_CONTINGENCY_NAME | VARCHAR2 | 360 | Oracle internal use only. | ||
| DATA_TRANSFORMATION_STATUS | VARCHAR2 | 30 | Oracle Internal use only. | ||
| DATA_TRANS_ERROR_MESSAGE | VARCHAR2 | 1000 | Oracle Internal use only. | ||
| EVENT_ID | NUMBER | 18 | Subledger accounting event identifier for posting source document sub line in source application. This column is valid for sub line type DISTRIBUTIONS. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | Revenue account combination identifier on source document sub line. This column is derived from account segment values on the sub line. This column is valid for sub line type DISTRIBUTIONS. | ||
| SALESREP_ID | NUMBER | 18 | Oracle internal use only. | ||
| SALESREP_NAME | VARCHAR2 | 360 | Salesperson name on source document sub line. This column is used for information only within MEA. For revenue assignments to salespersons, specify the information in SP_FIRST_NAME, SP_LAST_NAME and SP_MIDDLE_NAME columns. | ||
| REVENUE_AMOUNT_SPLIT | NUMBER | Revenue split amount of source document sub line. This column is valid for sub line type SALESCREDITS and when REVENUE_PERCENT_SPLIT is not used. | |||
| REVENUE_PERCENT_SPLIT | NUMBER | Revenue split percent of source document sub line. This column is valid for sub line type SALESCREDITS and when REVENUE_AMOUNT_SPLIT is not used. | |||
| CONTINGENCY_CODE | VARCHAR2 | 30 | Oracle internal use only. | ||
| CONTINGENCY_NAME | VARCHAR2 | 320 | Revenue contingency name on source document sub line. This column is valid for sub line type CONTINGENCIES. | ||
| CONTINGENCY_ID | NUMBER | 18 | Revenue contingency identifier on source document sub line. This column is valid for sub line type CONTINGENCIES. | ||
| EXPIRATION_DATE | DATE | Date on which revenue contingency expires on source document sub line. This column is valid for sub line type CONTINGENCIES. | |||
| EXPIRATION_DAYS | NUMBER | Number of days until contingency expiration for source document sub line. This column is valid for sub line type CONTINGENCIES. | |||
| EXPIRED_FLAG | VARCHAR2 | 1 | Indicates whether the contingency has expired on source document sub line. Possible values are Y and N. This column is valid for sub line type CONTINGENCIES. | ||
| EXPIRATION_EVENT_DATE | DATE | Date on which contingency automatically or manually expires on source document sub line. This column is valid for sub line type CONTINGENCIES. | |||
| EXPIRED_BY | VARCHAR2 | 64 | User who expired the contingency for source document sub line. This column is valid for sub line type CONTINGENCIES. | ||
| COMMENTS | VARCHAR2 | 240 | Oracle internal use only. | ||
| ACCOUNT_CODE_SEGMENT1 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT2 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT3 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT4 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT5 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT6 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT7 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT8 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT9 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT10 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT11 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT12 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT13 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT14 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT15 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT16 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT17 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT18 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT19 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT20 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT21 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT22 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT23 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT24 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT25 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT26 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT27 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT28 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT29 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| ACCOUNT_CODE_SEGMENT30 | VARCHAR2 | 100 | Key Flexfield: segment of the key flexfield. | ||
| SRC_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR21 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR22 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR23 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR24 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR25 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR26 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR27 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR28 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR29 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR30 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR31 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR32 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR33 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR34 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR35 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR36 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR37 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR38 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR39 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR40 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR41 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR42 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR43 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR44 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR45 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR46 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR47 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR48 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR49 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR50 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR51 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR52 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR53 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR54 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR55 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR56 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR57 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR58 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR59 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_CHAR60 | VARCHAR2 | 150 | Oracle internal use only. | ||
| SRC_ATTRIBUTE_NUMBER1 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER2 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER3 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER4 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER5 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER6 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER7 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER8 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER9 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER10 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER11 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER12 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER13 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER14 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER15 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER16 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER17 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER18 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER19 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_NUMBER20 | NUMBER | Oracle internal use only. | |||
| SRC_ATTRIBUTE_DATE1 | DATE | Oracle internal use only. | |||
| SRC_ATTRIBUTE_DATE2 | DATE | Oracle internal use only. | |||
| SRC_ATTRIBUTE_DATE3 | DATE | Oracle internal use only. | |||
| SRC_ATTRIBUTE_DATE4 | DATE | Oracle internal use only. | |||
| SRC_ATTRIBUTE_DATE5 | DATE | Oracle internal use only. | |||
| SRC_ATTRIBUTE_DATE6 | DATE | Oracle internal use only. | |||
| SRC_ATTRIBUTE_DATE7 | DATE | Oracle internal use only. | |||
| SRC_ATTRIBUTE_DATE8 | DATE | Oracle internal use only. | |||
| SRC_ATTRIBUTE_DATE9 | DATE | Oracle internal use only. | |||
| SRC_ATTRIBUTE_DATE10 | DATE | Oracle internal use only. | |||
| SOURCE_ORG_ID | NUMBER | 18 | Business unit identifier in source application. This column is used to correct data transformation errors. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or 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. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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. | |||
| SOURCE_ACCOUNT_CODE | VARCHAR2 | 960 | Account combination from source application. This column is used to correct data transformation errors. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
| 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. | ||
| SP_FIRST_NAME | VARCHAR2 | 360 | First name of salesperson. This column is valid for sub line type SALESCREDITS. | ||
| SP_MIDDLE_NAME | VARCHAR2 | 80 | Middle name of salesperson. This column is valid for sub line type SALESCREDITS. | ||
| SP_LAST_NAME | VARCHAR2 | 150 | Last name of salesperson. This column is valid for sub line type SALESCREDITS. | ||
| PARENT_DOCUMENT_LINE_ID | NUMBER | 18 | Oracle internal use only. | ||
| SATISFACTION_MEASUREMENT_DATE | DATE | Satisfaction measurement date. | |||
| 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. | |||
| DOCUMENT_TYPE_CODE | VARCHAR2 | 30 | Code of the source document type. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| VRM_SOURCE_DOC_SUB_LINES | vrm_source_doc_lines | DOCUMENT_LINE_ID |
| VRM_SOURCE_DOC_SUB_LINES | vrm_source_documents | DOCUMENT_ID |
| VRM_SOURCE_DOC_SUB_LINES | vrm_source_doc_types_b | DOCUMENT_TYPE_ID |
| VRM_SOURCE_DOC_SUB_LINES | vrm_source_documents | PARENT_DOCUMENT_LINE_ID |
| vrm_perf_obligation_lin_splits | vrm_source_doc_sub_lines | DOCUMENT_SUB_LINE_ID |
| vrm_revenue_doc_lines_all | vrm_source_doc_sub_lines | DOCUMENT_SUB_LINE_ID |
| vrm_extract_lines | vrm_source_doc_sub_lines | DOCUMENT_SUB_LINE_ID |
| vrm_pol_satisfaction_events | vrm_source_doc_sub_lines | DOCUMENT_SUB_LINE_ID |
| vrm_rev_doc_line_schedules_all | vrm_source_doc_sub_lines | DOCUMENT_SUB_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| VRM_SOURCE_DOC_SUB_LINES_N1 | Non Unique | Default | APPLICATION_ID, DOCUMENT_ID, DOCUMENT_LINE_ID |
| VRM_SOURCE_DOC_SUB_LINES_N2 | Non Unique | Default | DOCUMENT_LINE_ID, DOC_SUB_LINE_TYPE, DOC_SUB_LINE_LEVEL |
| VRM_SOURCE_DOC_SUB_LINES_N3 | Non Unique | Default | DATA_TRANSFORMATION_STATUS |
| VRM_SOURCE_DOC_SUB_LINES_N4 | Non Unique | Default | DOCUMENT_ID, DOC_SUB_LINE_TYPE, DOC_SUB_LINE_LEVEL |
| VRM_SOURCE_DOC_SUB_LINES_N5 | Non Unique | Default | NVL("DOC_ID_INT_1",(-1)), NVL("DOC_ID_INT_2",(-1)), NVL("DOC_ID_INT_3",(-1)), NVL("DOC_ID_INT_4",(-1)), NVL("DOC_ID_INT_5",(-1)), NVL("DOC_ID_CHAR_1",'X'), NVL("DOC_ID_CHAR_2",'X'), NVL("DOC_ID_CHAR_3",'X'), NVL("DOC_ID_CHAR_4",'X'), NVL("DOC_ID_CHAR_5",'X'), DOCUMENT_TYPE_ID, SOURCE_SYSTEM |
| VRM_SOURCE_DOC_SUB_LINES_N6 | Non Unique | Default | NVL("DOC_LINE_ID_INT_1",(-1)), NVL("DOC_LINE_ID_INT_2",(-1)), NVL("DOC_LINE_ID_INT_3",(-1)), NVL("DOC_LINE_ID_INT_4",(-1)), NVL("DOC_LINE_ID_INT_5",(-1)), NVL("DOC_LINE_ID_CHAR_1",'X'), NVL("DOC_LINE_ID_CHAR_2",'X'), NVL("DOC_LINE_ID_CHAR_3",'X'), NVL("DOC_LINE_ID_CHAR_4",'X'), NVL("DOC_LINE_ID_CHAR_5",'X'), DOCUMENT_TYPE_ID, SOURCE_SYSTEM |
| VRM_SOURCE_DOC_SUB_LINES_N7 | Non Unique | Default | PARENT_DOCUMENT_LINE_ID |
| VRM_SOURCE_DOC_SUB_LINES_N8 | Non Unique | Default | NVL("DOC_SUB_LINE_ID_INT_1",(-1)), NVL("DOC_SUB_LINE_ID_INT_2",(-1)), NVL("DOC_SUB_LINE_ID_INT_3",(-1)), NVL("DOC_SUB_LINE_ID_INT_4",(-1)), NVL("DOC_SUB_LINE_ID_INT_5",(-1)), NVL("DOC_SUB_LINE_ID_CHAR_1",'X'), NVL("DOC_SUB_LINE_ID_CHAR_2",'X'), NVL("DOC_SUB_LINE_ID_CHAR_3",'X'), NVL("DOC_SUB_LINE_ID_CHAR_4",'X'), NVL("DOC_SUB_LINE_ID_CHAR_5",'X'), DOCUMENT_TYPE_ID, SOURCE_SYSTEM |
| VRM_SOURCE_DOC_SUB_LINES_U1 | Unique | Default | DOCUMENT_SUB_LINE_ID |