Oracle Fusion · Data dictionary
VRM_SOURCE_DOC_LINES
SharedUsed in 4 subject areas32 reporting columns
Revenue Management (VRM), line table, one row per line item under the header.
Likely primary key: SOURCE_DOC_HEADER_ID, LINE_NUM (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNTING_RULE_NAME | ● | Name of the accounting rule. | |
| ACTUAL_ARRIVAL_DATE | ● | Actual arrival date. | |
| ACTUAL_SHIPMENT_DATE | ● | Actual shipment date. | |
| BASE_PRICE | ● | Base price. | |
| COMMENTS | ● | Comments. | |
| COST_AMOUNT | ● | Cost amount. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DELIVERY_DATE | ● | Delivery date. | |
| DELIVERY_STATUS | ● | Status of the delivery. | |
| DISCOUNT_AMOUNT | ● | Discount amount. | |
| DISCOUNT_PERCENTAGE | ● | Discount percentage. | |
| DOCUMENT_DATE | ● | Document date. | |
| DOCUMENT_LINE_ID | ● | Identifier for the document line. | |
| GROSS_MARGIN_PERCENT | ● | Gross margin percentage. | |
| LAST_PERIOD_TO_CREDIT | ● | Last period to credit. | |
| LINE_AMOUNT | ● | Line amount. | |
| LINE_NUM | PK? | ● | Line number. |
| LINE_TYPE | ● | Type of line. | |
| MEMO_LINE_NAME | ● | Name of the memo line. | |
| PAYMENT_TERM_NAME | ● | Name of the payment term. | |
| QUANTITY | ● | Quantity. | |
| QUANTITY_CANCELLED | ● | Quantity cancelled. | |
| QUANTITY_FULFILLED | ● | Quantity fulfilled. | |
| QUANTITY_ORDERED | ● | Quantity ordered. | |
| QUANTITY_SHIPPED | ● | Quantity shipped. | |
| REVENUE_REVERSAL_METHOD | ● | Revenue reversal method. | |
| SOURCE_DOC_HEADER_ID | PK? | ○ | Identifier for the source doc header. |
| UNIT_LIST_PCT_BASE_PRICE | ● | Unit list percent base price. | |
| UNIT_LIST_PRICE | ● | Unit list price. | |
| UNIT_SELLING_PCT_BASE_PRICE | ● | Unit selling percent base price. | |
| UNIT_SELLING_PRICE | ● | Unit selling price. | |
| VERSION_FLAG | ● | Indicator (Y/N) for the version. | |
| VERSION_NUMBER | ● | Version number. |
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 Fair Market Value Real Time
- Revenue Management - Revenue Compliance MEA Carve-out Real Time
- Revenue Management - Revenue Recognition Real Time
- Revenue Management - Source Documents Real Time
Need the extract + dbt staging for VRM_SOURCE_DOC_LINES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table