1. Tables and Views for Financials
  2. VRM_REVENUE_DOC_LINES_GT

VRM_REVENUE_DOC_LINES_GT

VRM_REVENUE_DOC_LINES_GT contains information about revenue lines during the revenue document processing.

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

VRM_REVENUE_DOC_LINES_GT_PK

REVENUE_DOCUMENT_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
REVENUE_DOCUMENT_LINE_ID NUMBER 18 Yes Internal identifier of revenue document line. Active
DOCUMENT_LINE_ID NUMBER 18 Internal unique identifier of a source document line. Active
LINE_NUMBER VARCHAR2 30 Yes Sequence number of a revenue document line. Active
LINE_TYPE VARCHAR2 20 Code name of the document line type. Active
UNIT_REVENUE_PRICE NUMBER Unit revenue price of a line to be recognized by a revenue recognition process. Active
EXTENDED_UNIT_PRICE_AMOUNT NUMBER Extended selling amount is calculated from unit selling price times quantity. Active
EXTENDED_REVENUE_PRICE_AMOUNT NUMBER Extended revenue amount is calculated from unit revenue price times quantity. Active
EXTENDED_CARVED_OUT_AMOUNT NUMBER Carve out amount of a MEA line.
REVENUE_RULE_ID NUMBER 18 Unique identifier or a revenue scheduling rule. Active
REVENUE_RULE_NAME VARCHAR2 30 Name of a revenue scheduling rule. Active
RULE_DURATION NUMBER Duration for the revenue schedules when using a Variable Schedule rule type. Number of periods to recognize revenue. Active
RULE_START_DATE DATE Start Date for revenue recognition when utilizing the Daily Revenue Rate, All Periods or Daily Revenue Rate, Partial Periods revenue rule types. Active
RULE_END_DATE DATE End Date for revenue recognition when utilizing the Daily Revenue Rate, All Periods or Daily Revenue Rate, Partial Periods revenue rule types. Active
REVENUE_DOCUMENT_ID NUMBER 18 Yes Unique identifier of a revenue document. Active
QUANTITY_CREDITED NUMBER Quantity that has been credited. Active
QUANTITY_INVOICED NUMBER Quantity that has been invoiced. Active
PREV_REVENUE_DOCUMENT_LINE_ID NUMBER 18 Unique identifier of a line of a previous revenue document. Active
DOCUMENT_ID NUMBER 18 Unique identifier of a source document. Active
SCHEDULED_AMOUNT NUMBER Amount of revenue that has been scheduled. Active
UNSCHEDULED_AMOUNT NUMBER The amount of unscheduled revenue. Active
PAYMENT_AMOUNT NUMBER Payment amount of a source document line. Active
CONTINGENCY_COUNT NUMBER 18 Number of contingencies applied to the line. Active
REQUIRES_MANUAL_SCHEDULING VARCHAR2 1 Flag that indicates if manual revenue scheduling is required to the document. Active
MEA_NUMBER NUMBER 18 Unique number of a MEA transaction. Active
LINK_TO_REV_DOC_LINE_ID NUMBER 18 Unique identifier of a revenue document. Active
ORG_ID NUMBER 18 Indicates the identifier of the business unit associated to the row. Active
PREV_REVENUE_DOCUMENT_ID NUMBER 18 Unique identifier of a previous revenue document. Active
AUTORULE_COMPLETE_FLAG VARCHAR2 1 A Yes or No flag that indicates if the revenue scheduling rule is completed. Active
RULE_DURATION_PROCESSED NUMBER Determines the duration of the accounting rule processed. Active
PROGRAM_ID NUMBER 18 Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). Active
PROGRAM_APPLICATION_ID NUMBER 18 Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). Active
PROGRAM_UPDATE_DATE DATE Concurrent Program who column - date when a program last updated this row). Active
SET_OF_BOOKS_ID NUMBER 18 Unique identifier of a ledger. 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
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. 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
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
OVERRIDE_AUTO_ACCOUNTING_FLAG VARCHAR2 1 Provided by the source system indicating that the distribution account should not be overridden. Possible values are Yes or No.
WAREHOUSE_ID NUMBER 18 Warehouse unique identifier.
LAST_PERIOD_TO_CREDIT NUMBER For the credit lines that have the credit method as Unit, specifies the accounting period from which to begin crediting the revenue and work backwards till the entire credit amount is exhausted.
LINE_STATUS VARCHAR2 60 Status of a revenue document line to indicate whether line is processed or not.
ITEM_ID NUMBER 18 Inventory item unique identifier.
UOM_CODE VARCHAR2 3 Unit of measure code.
INVENTORY_ORG_ID NUMBER 18 Item inventory organization unique identifier.
MEMO_LINE_SEQ_ID NUMBER 18 Memo line sequence identifier.
BILL_TO_CUSTOMER_ID NUMBER 18 Bill-to customer unique identifier.
BILL_TO_CUSTOMER_SITE_ID NUMBER 18 Bill-to customer site unique identifier.
ZERO_AMOUNT_FLAG VARCHAR2 1 Indicates whether current revenue document line is having zero extended revenue amount. Possible values are Yes or No.
SHIP_TO_CUSTOMER_ID NUMBER 18 Ship-to customer unique identifier.
SHIP_TO_CUSTOMER_SITE_ID NUMBER 18 Ship-to customer site unique identifier.
PAYMENT_TERM_ID NUMBER 18 Payment term unique identifier.
SHIP_CONFIRM_DATE DATE Date the item was ship confirmed.

Indexes

Index Uniqueness Columns Status
VRM_REVENUE_DOC_LINES_GT_N1 Non Unique DOCUMENT_LINE_ID Active
VRM_REVENUE_DOC_LINES_GT_N2 Non Unique REVENUE_DOCUMENT_ID Active
VRM_REVENUE_DOC_LINES_GT_N3 Non Unique DOCUMENT_ID Active
VRM_REVENUE_DOC_LINES_GT_N4 Non Unique PREV_REVENUE_DOCUMENT_ID
VRM_REVENUE_DOC_LINES_GT_N5 Non Unique PREV_REVENUE_DOCUMENT_LINE_ID
VRM_REVENUE_DOC_LINES_GT_N6 Non Unique LINE_STATUS
VRM_REVENUE_DOC_LINES_GT_U1 Unique REVENUE_DOCUMENT_LINE_ID Active