1. Tables and Views for Financials
  2. VRM_REV_DOC_LINE_SCHEDULES_GT

VRM_REV_DOC_LINE_SCHEDULES_GT

VRM_REV_DOC_LINE_SCHEDULES_GT contains information about revenue scheduling during the revenue document processing.

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

VRM_REV_DOC_LINE_SCHED_GT_PK

REVENUE_DOC_LINE_SCHEDULE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
REVENUE_DOC_LINE_SCHEDULE_ID NUMBER 18 Yes Internal identifier of revenue line schedule. Active
REVENUE_DOCUMENT_LINE_ID NUMBER 18 Internal identifier of revenue document line. Active
SCHEDULE_LINE_NUMBER NUMBER 18 Unique identifier that represents the schedule line. Active
REVENUE_LINE_SPLIT_ID NUMBER 18 Unique identifier for the revenue split line. Active
ACCOUNTING_DATE DATE Accounting date of the revenue document. Active
SCHEDULE_EVENT VARCHAR2 30 System derived event that results in a revenue schedule line (example, creation, adjustment). Active
SCHEDULED_AMOUNT NUMBER Amount of revenue that has been scheduled. Active
UNSCHEDULED_AMOUNT NUMBER The amount of unscheduled revenue. Active
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_LINE_ID NUMBER 18 Internal unique identifier of a source document line. Active
DOCUMENT_SUB_LINE_ID NUMBER 18 Internal identifier of the source document subline generated in the Revenue Management application.
POSTED_TO_SLA_FLAG VARCHAR2 30 Flag that indicates if a revenue line is posted to SLA. Active
CODE_COMBINATION_ID NUMBER 18 A combination of a distribution flexfield. Active
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to 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
ORIGINAL_ACCOUNTING_DATE DATE Accounting date of the source document. Active
ACCOUNT_CLASS VARCHAR2 30 Account class associated with the distribution record. Active
ACCOUNT_SET_FLAG VARCHAR2 1 A yes or no flag that indicates if the line is set to account record. Active
SET_OF_BOOKS_ID NUMBER 18 Unique identifier of a ledger. Active
PERCENT NUMBER Percentage of the line amount represented by this revenue document. Active
SCHEDULED_ACCTD_AMOUNT NUMBER Scheduled amount of this record in functional currency. Active
CONCATENATED_SEGMENTS VARCHAR2 240 An identifier of the accounting flexfield for the revenue distribution. Active
POSTING_CONTROL_ID NUMBER 18 Posting batch identifier : -3 for not posted. Active
GL_POSTED_DATE DATE Date when the revenue is posted to the general ledger. Active
LATEST_REC_FLAG VARCHAR2 1 A Yes or No flag that indicates the latest record with an ACCOUNT_CLASS of REC, Y indicates the latest REC record and exists for each CUSTOMER_TRX_ID. N or Null does not indicates the latest REC record. Active
REC_OFFSET_FLAG VARCHAR2 1 Flag that indicates if the record is an UNBILL or UNLEARN line paired with the transaction REC line when the value is Y. N or NULL indicates another type of line or an UNBILL or UNEARN line paired with the transaction REV line. Active
COLLECTED_TAX_CCID NUMBER 18 Transaction distribution of a collected tax account class. This attribute is only used for deferred tax. Active
REVENUE_ADJUSTMENT_ID NUMBER 18 Unique identifier of a revenue adjustment. Active
COMPLIANCE_ADJUSTMENT_ID NUMBER 18 Revenue carve-out adjustment identifier.
TERMINATION_ADJUSTMENT_ID NUMBER 18 The adjustment reversal identifier generated by the changes in revenue rule related attributes in version lines.
TERMINATED_FLAG VARCHAR2 1 Indicates whether the schedules are to be used for future processing. Possible values are Yes or No.
POST_REQUEST_ID NUMBER 18 Unique identifier of a journal entry posting to the general ledger. Active
RA_POST_LOOP_NUMBER NUMBER 18 No longer used. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. 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
COMMENTS VARCHAR2 240 Comment about the distribution record. Active
USER_GENERATED_FLAG VARCHAR2 1 Flag that indicates the user has created the entry manually. Active
EVENT_ID NUMBER 18 Unique identifier of an SLA event. Active
ROUNDING_CORRECTION_FLAG VARCHAR2 1 Flag that indicates if there is a rounding correction. 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
UNSCHEDULED_ACCTD_AMOUNT NUMBER Unscheduled amount of this record in functional currency.
AMOUNT NUMBER Revenue amount in transaction currency.
ACCTD_AMOUNT NUMBER Revenue amount in functional currency.
OFFSET_LINE_TYPE VARCHAR2 30 Offset line type code for the revenue or unearned revenue schedule line.
OFFSET_LINE_ACCOUNT_CCID NUMBER 18 Offset account code identifier for the revenue or unearned revenue schedule line.

Indexes

Index Uniqueness Columns Status
VRM_REV_DOC_LINE_SCHED_GT_N1 Non Unique REVENUE_DOCUMENT_LINE_ID, ACCOUNT_CLASS, TERMINATED_FLAG, ACCOUNT_SET_FLAG Active
VRM_REV_DOC_LINE_SCHED_GT_N2 Non Unique REVENUE_LINE_SPLIT_ID Active
VRM_REV_DOC_LINE_SCHED_GT_N3 Non Unique DOCUMENT_LINE_ID Active
VRM_REV_DOC_LINE_SCHED_GT_N4 Non Unique DOCUMENT_ID Active
VRM_REV_DOC_LINE_SCHED_GT_U1 Unique REVENUE_DOC_LINE_SCHEDULE_ID Active
VRM_REV_DOC_LIN_SCHED_GT_N5 Non Unique REVENUE_DOCUMENT_ID, LATEST_REC_FLAG
VRM_REV_DOC_LIN_SCHED_GT_N6 Non Unique REQUEST_ID