Oracle Fusion · Data dictionary
VRM_FMV_DATA_SET_USAGES
SharedUsed in 1 subject areas20 reporting columns
Revenue Management (VRM).
Primary key: not yet catalogued for VRM_FMV_DATA_SET_USAGES, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| BASE_PRICE | ● | Base price. | |
| COMMENTS | ● | Comments. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DATA_SET_TYPE | ● | Type of data set. | |
| DOCUMENT_LINE_ID | ● | Identifier for the document line. | |
| EXCLUDED_BY | ● | Excluded by. | |
| EXCLUSION_REASON_CODE | ● | Code identifying the exclusion reason. | |
| EXCLUSION_STATUS | ● | Status of the exclusion. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| NET_DISCOUNT_AMOUNT | ● | Net discount amount. | |
| NET_DISCOUNT_PERCENT | ● | Net discount percentage. | |
| NET_LINE_AMOUNT | ● | Net line amount. | |
| NET_QUANTITY | ● | Net quantity. | |
| NET_UNIT_SALES_PCT_BASE_PRICE | ● | Net unit sales percent base price. | |
| NET_UNIT_SALES_PRICE | ● | Net unit sales price. | |
| REVISED_COST | ● | Revised cost. | |
| REVISED_GROSS_MARGIN_PERCENT | ● | Revised gross margin percentage. | |
| REVISED_UOM | ● | Revised unit of measure. |
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.
Need the extract + dbt staging for VRM_FMV_DATA_SET_USAGES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table