1. Tables and Views for Financials
  2. VRM_REVENUE_DOCUMENTS_GT

VRM_REVENUE_DOCUMENTS_GT

VRM_REVENUE_DOCUMENTS_GT contains all revenue documents during the revenue document and recognition processing.

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

VRM_REVENUE_DOCUMENTS_GT_PK

REVENUE_DOCUMENT_ID

Columns

Name Datatype Length Precision Not-null Comments Status
REVENUE_DOCUMENT_ID NUMBER 18 Yes Unique identifier of a revenue document. Active
DOCUMENT_ID NUMBER 18 Unique identifier of a source document. Active
DOCUMENT_NUMBER VARCHAR2 30 Yes Document number of a source document. Active
LEGAL_ENTITY_ID NUMBER 18 Unique identifier of a legal entity. Active
ORG_ID NUMBER 18 Indicates the identifier of the business unit associated to the row. Active
SOURCE VARCHAR2 30 Source Application (example, Order Management, Contracts). Active
SOURCE_DOCUMENT_NUMBER VARCHAR2 30 Document number of the source transaction. Active
TRX_CLASS VARCHAR2 20 Transaction Class associated with the transaction. Active
DOCUMENT_TYPE VARCHAR2 30 Document type of the source document. Active
STATUS VARCHAR2 30 Flag to indicate if a revenue document is complete or incomplete. It determines what can or cannot be updated on the document. Active
DOCUMENT_DATE DATE Yes The date on which the revenue document is created. Active
ACCOUNTING_DATE DATE Accounting date of the revenue document. Active
BILL_TO_CUSTOMER_ID NUMBER 18 A Unique identifier of a bill to customer. Active
COMPLETE_FLAG VARCHAR2 1 Yes A flag that indicates if a revenue document is completed. Active
PAYMENT_TERM_ID NUMBER 18 Unique payment terms identifier. Active
CURRENCY_CODE VARCHAR2 15 Yes Currency code of the revenue document. Active
EXCHANGE_RATE NUMBER Conversion rate of the document. Active
EXCHANGE_RATE_TYPE VARCHAR2 30 Conversion rate type of the document. Active
EXCHANGE_RATE_DATE DATE Conversion rate date of the document. Active
REVENUE_TOTAL_AMOUNT NUMBER Total revenue amount for the document. Summary of all the revenue line amount. Active
REVENUE_TOTAL_ADJ_AMOUNT NUMBER Total amount of adjusted revenue. Active
PAYMENT_AMOUNT NUMBER Payment amount of a source document line. Active
DOCUMENT_RULE_ID NUMBER 18 Unique identifier of a revenue scheduling rule. Active
DOCUMENT_TYPE_SEQ_ID NUMBER 18 Sequence identifier of a source document type. Active
ORIG_REVENUE_DOCUMENT_NUMBER VARCHAR2 30 Captures the original revenue document number in the case of a reversal. 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
CREATED_FROM VARCHAR2 30 Who Column: indicates the module who created the document. Active
SET_OF_BOOKS_ID NUMBER 18 Yes 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
BILL_TO_CUSTOMER_SITE_ID NUMBER 18 Bill-to customer site unique identifier.
SHIP_TO_CUSTOMER_ID NUMBER 18 Ship-to customer unique identifier.
SHIP_TO_CUSTOMER_SITE_ID NUMBER 18 Ship-to customer site unique identifier.
DOCUMENT_TYPE_ID NUMBER 18 Source document type unique identifier.
ACCOUNTING_EFFECT_FLAG VARCHAR2 1 Indicates the source product accounting is complete. Possible values are Yes or No.
SOURCE_SYSTEM VARCHAR2 120 The source system sending the document data.

Indexes

Index Uniqueness Columns Status
VRM_REVENUE_DOCUMENTS_GT_N1 Non Unique DOCUMENT_ID Active
VRM_REVENUE_DOCUMENTS_GT_N2 Non Unique REQUEST_ID Active
VRM_REVENUE_DOCUMENTS_GT_U2 Unique REVENUE_DOCUMENT_ID Active