1. Tables and Views for Financials
  2. VRM_REVENUE_DOC_LINES_ALL

VRM_REVENUE_DOC_LINES_ALL

VRM_REVENUE_DOC_LINES_ALL contains all revenue lines to be recognized.

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

VRM_REVENUE_DOC_LINES_ALL_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
SOURCE_DOCUMENT_LINE_NUMBER VARCHAR2 30 Sequence number of a source document line. Active
INVENTORY_ORG_ID NUMBER 18 Unique identifier of an item inventory organization. Active
ITEM_ID NUMBER 18 Unique identifier of an inventory item. Active
ITEM_NUMBER VARCHAR2 300 Inventory item number. Active
ITEM_DESCRIPTION VARCHAR2 240 Description of an inventory item. Active
MEMO_LINE_SEQ_ID NUMBER 18 Unique identifier of a memo line. Active
UOM_CODE VARCHAR2 200 Yes Code name of the unit of measure. Active
QUANTITY NUMBER Yes Quantity of a revenue line. Active
QUANTITY_INVOICED NUMBER Quantity that has been invoiced. Active
QUANTITY_CREDITED NUMBER Quantity that has been credited. Active
UNIT_SELLING_PRICE NUMBER Unit selling price of the source document. 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
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
RULE_DURATION_PROCESSED NUMBER Determines the duration of the accounting rule processed. Active
AUTORULE_COMPLETE_FLAG VARCHAR2 1 A Yes or No flag that indicates if the revenue scheduling rule is completed. Active
REVENUE_RELEASE_DATE DATE Date when the revenue is released either by advance revenue recognition job or contingency expiration or manual scheduling for fixed immediate revenue rule.
REVENUE_DOCUMENT_ID NUMBER 18 Yes Unique identifier of a 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
UNIT_CARVE_OUT_PRICE NUMBER Carve-out amount per unit. Active
EXTENDED_CARVED_OUT_AMOUNT NUMBER Carve out line amount of a MEA line. Active
CONTINGENCY_COUNT NUMBER 18 Number of contingencies applied to the line. Active
CODE_COMBINATION_ID NUMBER 18 Oracle internal use only. Active
MEA_NUMBER NUMBER 18 Unique number of a MEA transaction. Active
PREV_REVENUE_DOCUMENT_LINE_ID NUMBER 18 Unique identifier of a line of a previous revenue document. Active
PREV_REVENUE_DOCUMENT_ID NUMBER 18 Unique identifier of a previous revenue document. Active
REQUIRES_MANUAL_SCHEDULING VARCHAR2 1 Flag that indicates if manual revenue scheduling is required to the document. Active
LINK_TO_REV_DOC_LINE_ID NUMBER 18 Unique identifier of a revenue document. Active
LINE_TYPE VARCHAR2 20 Type of a revenue document line. 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
SET_OF_BOOKS_ID NUMBER 18 Unique identifier of a ledger. 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_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_UPDATE_DATE DATE Concurrent Program who column - date when a program last updated this row). Active
FOB_POINT_CODE VARCHAR2 120 Freight on board code. Identifies where the responsibility of goods is transferred.
FREIGHT_TERMS_CODE VARCHAR2 120 Freight Terms code specifying the responsibility for freight charges.
SOURCE_LINE_REVENUE_DATE DATE Indicates the date the revenue was recognized in the source product.
SOURCE_LINE_ACCOUNTED_DATE DATE Date the revenue line was accounted in the source product.
CUST_PO_NUMBER VARCHAR2 200 Purchase order unique reference number.
SHIP_CONFIRM_DATE DATE Date the item was ship confirmed.
PROOF_OF_DELIVERY_DATE DATE Date for proof of delivery of an item.
FULFILLMENT_DATE DATE Date the item was fulfilled.
DEFAULT_CARVE_OUT_ADJ_PERCENT NUMBER Used to calculate the fair market value revenue price for project elements of fixed fee type.
DOCUMENT_SUB_LINE_ID NUMBER 18 Internal identifier of the source document sub line generated in the Revenue Management application.
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
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.
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.
DESCRIPTION VARCHAR2 240 Description of a revenue document line.
ACTUAL_SHIPMENT_DATE DATE Date when the order was shipped.
ORIG_UNIT_SELLING_PRICE NUMBER Unit selling price of the source document.
ORIG_QUANTITY NUMBER Quantity of a revenue line.
ORIG_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.
ORIG_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.
ORIG_REVENUE_RULE_ID NUMBER 18 Revenue scheduling rule unique identifier.
ORIG_RULE_DURATION NUMBER Duration for the revenue schedules when using a Variable Schedule rule type. Number of periods to recognize revenue.
BILL_TO_CUSTOMER_ID NUMBER 18 Bill-to customer unique identifier.
BILL_TO_CUSTOMER_SITE_ID NUMBER 18 Bill-to customer site unique identifier.

Foreign Keys

Table Foreign Table Foreign Key Column
VRM_REVENUE_DOC_LINES_ALL vrm_source_doc_lines DOCUMENT_LINE_ID
VRM_REVENUE_DOC_LINES_ALL vrm_revenue_documents_all REVENUE_DOCUMENT_ID
VRM_REVENUE_DOC_LINES_ALL vrm_source_documents DOCUMENT_ID
VRM_REVENUE_DOC_LINES_ALL vrm_revenue_rules REVENUE_RULE_ID
VRM_REVENUE_DOC_LINES_ALL vrm_source_doc_sub_lines DOCUMENT_SUB_LINE_ID
VRM_REVENUE_DOC_LINES_ALL hz_cust_accounts BILL_TO_CUSTOMER_ID
VRM_REVENUE_DOC_LINES_ALL hz_cust_acct_sites_all BILL_TO_CUSTOMER_SITE_ID
VRM_REVENUE_DOC_LINES_ALL hz_cust_accounts BILL_TO_CUSTOMER_ID
VRM_REVENUE_DOC_LINES_ALL hz_cust_acct_sites_all BILL_TO_CUSTOMER_SITE_ID
vrm_rev_line_conts_all vrm_revenue_doc_lines_all REVENUE_DOCUMENT_LINE_ID
vrm_revision_line_amounts vrm_revenue_doc_lines_all REVENUE_DOCUMENT_LINE_ID
vrm_revenue_adjustments_all vrm_revenue_doc_lines_all FROM_REV_DOC_LINE_ID
vrm_revenue_adjustments_all vrm_revenue_doc_lines_all TO_REV_DOC_LINE_ID
vrm_deferred_rev_lines_all vrm_revenue_doc_lines_all REVENUE_DOCUMENT_LINE_ID
vrm_rev_doc_line_schedules_all vrm_revenue_doc_lines_all REVENUE_DOCUMENT_LINE_ID

Indexes

Index Uniqueness Tablespace Columns Status
VRM_REVENUE_DOC_LINES_ALL_N1 Non Unique FUSION_TS_TX_IDX DOCUMENT_LINE_ID Active
VRM_REVENUE_DOC_LINES_ALL_N2 Non Unique FUSION_TS_TX_IDX REVENUE_DOCUMENT_ID Active
VRM_REVENUE_DOC_LINES_ALL_N3 Non Unique FUSION_TS_TX_IDX DOCUMENT_ID Active
VRM_REVENUE_DOC_LINES_ALL_N4 Non Unique Default DOCUMENT_SUB_LINE_ID
VRM_REVENUE_DOC_LINES_N5 Non Unique Default PROGRAM_ID
VRM_REVENUE_DOC_LINES_U1 Unique FUSION_TS_TX_IDX REVENUE_DOCUMENT_LINE_ID Active