1. Tables and Views for Financials
  2. VRM_REV_DOC_LINE_SPLITS_ALL

VRM_REV_DOC_LINE_SPLITS_ALL

VRM_REV_DOC_LINE_SPLITS_ALL contains revenue split information, which allows users to distribute revenue line amounts into multiple lines. For example, user may want to split the revenue line amount by salesperson or other attributes (example, cost center). The information is used as an input for SLA's accounting creation process.

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

VRM_REV_DOC_LINE_SPLITS_ALL_PK

REVENUE_LINE_SPLIT_ID

Columns

Name Datatype Length Precision Not-null Comments Status
REVENUE_LINE_SPLIT_ID NUMBER 18 Yes Unique identifier for the revenue split line. Active
REVENUE_DOCUMENT_LINE_ID NUMBER 18 Yes Internal identifier of revenue document line. Active
SPLIT_DATE DATE Date when the split of revenue document lines are created. Active
ACCOUNTING_DATE DATE Accounting date that will be used for revenue split. Active
SPLIT_BASIS VARCHAR2 30 Reasons for the revenue line split. Two seeded values are Salesperson and Manual. Active
SPLIT_AMOUNT NUMBER Amount of the revenue line for this split line. Active
SPLIT_PERCENT NUMBER Percentage of the revenue line amount for this split line. Active
SPLIT_LINE_NUMBER NUMBER 18 Revenue split line number.
CODE_COMBINATION_ID NUMBER 18 A combination of a distribution flexfield. Active
SALESREP_ID NUMBER 18 Unique identifier of a salesperson. Active
SALESREP_NAME VARCHAR2 360 Salesperson name. Active
REVENUE_DOCUMENT_ID NUMBER 18 Unique identifier of a revenue document. Active
PREV_REVENUE_LINE_SPLIT_ID NUMBER 18 Unique identifier of a credited salesperson. Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
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. Active
NON_REVENUE_SPLIT_AMOUNT NUMBER The amount of non revenue credit for this salesperson.
NON_REVENUE_SPLIT_PERCENT NUMBER The percent of non revenue credit for this salesperson.
NON_REVENUE_SALESGROUP_ID NUMBER Internal identifier of the non revenue sales group.
REVENUE_ADJUSTMENT_ID NUMBER 18 Revenue adjustment unique identifier.
SALESGROUP_ID NUMBER Sales organization unique identifier.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
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.
COMMENTS VARCHAR2 1000 Manually entered comment for the revenue line split.
CREATED_FROM VARCHAR2 30 Indicates if the splits were provided by the upstream source system or created from UI.

Foreign Keys

Table Foreign Table Foreign Key Column
vrm_rev_doc_line_schedules_all vrm_rev_doc_line_splits_all REVENUE_LINE_SPLIT_ID

Indexes

Index Uniqueness Tablespace Columns Status
VRM_REV_DOC_LINE_SPLITS_ALL_N1 Non Unique FUSION_TS_TX_IDX REVENUE_DOCUMENT_LINE_ID Active
VRM_REV_DOC_LINE_SPLITS_ALL_N2 Non Unique FUSION_TS_TX_IDX REVENUE_DOCUMENT_ID Active
VRM_REV_DOC_LINE_SPLITS_ALL_N3 Non Unique FUSION_TS_TX_IDX PREV_REVENUE_LINE_SPLIT_ID Active
VRM_REV_DOC_LINE_SPLITS_U1 Unique FUSION_TS_TX_IDX REVENUE_LINE_SPLIT_ID Active