Oracle Fusion · Data dictionary
VRM_MEA_DOC_CARVEOUT_LINES
SharedUsed in 2 subject areas33 reporting columns
Revenue Management (VRM), line table, one row per line item under the header.
Likely primary key: MEA_DOC_CARVEOUT_HEADER_ID, LINE_NUMBER (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADJUSTMENT_ACTION | ● | Adjustment action. | |
| ADJUSTMENT_DATE | ● | Adjustment date. | |
| ADJUSTMENT_REASON | ● | Adjustment reason. | |
| ADJ_GROSS_MARGIN_PERCENT | ● | Adj gross margin percentage. | |
| ADJ_REV_BASE_PRICE_PERCENT | ● | Adj rev base price percentage. | |
| ADJ_REV_LINE_AMOUNT | ● | Adj rev line amount. | |
| ADJ_REV_UNIT_LIST_PRICE_DISC | ● | Adj rev unit list price disc. | |
| ADJ_REV_UNIT_PRICE | ● | Adj rev unit price. | |
| CARVEOUT_AMOUNT | ● | Carveout amount. | |
| CARVEOUT_PERCENTAGE | ● | Carveout percentage. | |
| COMMENTS | ● | Comments. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DELIVERY_DATE | ● | Delivery date. | |
| DELIVERY_STATUS | ● | Status of the delivery. | |
| DISPLAY_FLAG | ● | Indicator (Y/N) for the display. | |
| FMV_REPRESENTATION_TYPE | ● | Type of fmv representation. | |
| FMV_TOLERANCE_CODE | ● | Code identifying the fmv tolerance. | |
| FULFILLMENT_STATUS | ● | Status of the fulfillment. | |
| 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_DOC_CARVEOUT_HEADER_ID | PK? | ○ | Identifier for the mea doc carveout header. |
| NET_BASE_PRICE_PERCENT | ● | Net base price percentage. | |
| NET_COST_AMOUNT | ● | Net cost amount. | |
| NET_GROSS_MARGIN_PERCENT | ● | Net gross margin percentage. | |
| NET_UNIT_LIST_PRICE_DISC | ● | Net unit list price disc. | |
| NET_UNIT_PRICE | ● | Net unit price. | |
| PROCESSED_DATE | ● | Processed date. | |
| REVERSED_FLAG | ● | Indicator (Y/N) for the reversed. | |
| STATUS | ● | Status. | |
| SUGGESTED_CARVEOUT_AMOUNT | ● | Suggested carveout amount. | |
| SUGGESTED_CARVEOUT_PERCENTAGE | ● | Suggested carveout percentage. | |
| TOTAL_FMV_AMOUNT | ● | Total fmv amount. | |
| TOTAL_LINE_AMOUNT | ● | Total line 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_MEA_DOC_CARVEOUT_LINES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table