Oracle Fusion · Data dictionary
VRM_REVENUE_DOC_LINES_ALL
SharedUsed in 2 subject areas37 reporting columns
Revenue Management (VRM), line table, one row per line item under the header.
Likely primary key: REVENUE_DOC_HEADER_ID, LINE_NUMBER (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): CODE_COMBINATION_ID → GL_CODE_COMBINATIONS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTUAL_SHIPMENT_DATE | ● | Actual shipment date. | |
| CODE_COMBINATION_ID | ● | Identifier for the code combination. | |
| CONTINGENCY_COUNT | ● | Contingency count. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CUST_PO_NUMBER | ● | Customer purchase order number. | |
| EXTENDED_CARVED_OUT_AMOUNT | ● | Extended carved out amount. | |
| EXTENDED_REVENUE_PRICE_AMOUNT | ● | Extended revenue price amount. | |
| EXTENDED_UNIT_PRICE_AMOUNT | ● | Extended unit price amount. | |
| FREIGHT_TERMS_CODE | ● | Code identifying the freight terms. | |
| FULFILLMENT_DATE | ● | Fulfillment date. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LINE_NUMBER | PK? | ● | Line number. |
| MEA_NUMBER | ● | Mea number. | |
| ORIG_QUANTITY | ● | Orig quantity. | |
| ORIG_RULE_DURATION | ● | Orig rule duration. | |
| ORIG_RULE_END_DATE | ● | Orig rule end date. | |
| ORIG_RULE_START_DATE | ● | Orig rule start date. | |
| ORIG_UNIT_SELLING_PRICE | ● | Orig unit selling price. | |
| PAYMENT_AMOUNT | ● | Payment amount. | |
| QUANTITY | ● | Quantity. | |
| QUANTITY_CREDITED | ● | Quantity credited. | |
| QUANTITY_INVOICED | ● | Quantity invoiced. | |
| REQUIRES_MANUAL_SCHEDULING | ● | Requires manual scheduling. | |
| REVENUE_DOC_HEADER_ID | PK? | ○ | Identifier for the revenue doc header. |
| REVENUE_RULE_NAME | ● | Name of the revenue rule. | |
| RULE_DURATION | ● | Rule duration. | |
| RULE_DURATION_PROCESSED | ● | Rule duration processed. | |
| RULE_END_DATE | ● | Rule end date. | |
| RULE_START_DATE | ● | Rule start date. | |
| SCHEDULED_AMOUNT | ● | Scheduled amount. | |
| SHIP_CONFIRM_DATE | ● | Shipment confirm date. | |
| SOURCE_DOCUMENT_LINE_NUMBER | ● | Source document line number. | |
| UNIT_CARVE_OUT_PRICE | ● | Unit carve out price. | |
| UNIT_REVENUE_PRICE | ● | Unit revenue price. | |
| UNIT_SELLING_PRICE | ● | Unit selling price. | |
| UNSCHEDULED_AMOUNT | ● | Unscheduled amount. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Revenue Management - Revenue Compliance MEA Carve-out Real Time
- Revenue Management - Revenue Recognition Real Time
Need the extract + dbt staging for VRM_REVENUE_DOC_LINES_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table