VRM_REVIEWED_LINES_GT

VRM_REVIEWED_LINES_GT contains the revenue original, recognized and pending for a revenue document line.

Details

• Schema: FUSION

• Object owner: VRM

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Columns

Name	Datatype	Length	Precision	Comments	Status
REVENUE_DOCUMENT_LINE_ID	NUMBER		18	Revenue document line unique identifier.	Active
REVENUE_DOCUMENT_ID	NUMBER		18	Revenue document unique identifier.	Active
AMOUNT_DUE_ORIGINAL	NUMBER			Original amount due in transaction currency.	Active
ACCTD_AMOUNT_DUE_ORIGINAL	NUMBER			Original amount due in functional Currency.	Active
AMOUNT_RECOGNIZED	NUMBER			Amount of recognized revenue on the line.	Active
ACCTD_AMOUNT_RECOGNIZED	NUMBER			Amount recognized in functional currency.	Active
AMOUNT_PENDING	NUMBER			Amount pending in transaction currency.	Active
ACCTD_AMOUNT_PENDING	NUMBER			Amount pending in functional currency.	Active
LINE_TYPE	VARCHAR2	30		Type of revenue document line.	Active
SO_LINE_ID	VARCHAR2	30		Oracle internal use only.	Active
REQUEST_ID	NUMBER		18	Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
EXPIRATION_DATE	DATE			Date the contingency expires.	Active