Oracle Fusion · Data dictionary
CMR_PURCHASE_ORDER_DTLS
SharedUsed in 2 subject areas22 reporting columns
Channel Management / Rebates (CMR).
Primary key: not yet catalogued for CMR_PURCHASE_ORDER_DTLS, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CURRENCY_CODE | ● | Code identifying the currency. | |
| CURRENCY_CONVERSION_DATE | ● | Currency conversion date. | |
| CURRENCY_CONVERSION_RATE | ● | Currency conversion rate. | |
| CURRENCY_CONVERSION_TYPE | ● | Type of currency conversion. | |
| DESTINATION_TYPE_CODE | ● | Code identifying the destination type. | |
| DISTRIBUTION_NUMBER | ● | Distribution number. | |
| EVENT_DATE | ● | Event date. | |
| LINE_NUMBER | ● | Line number. | |
| MATCHING_BASIS | ● | Matching basis. | |
| MATCH_OPTION | ● | Match option. | |
| NEED_BY_DATE | ● | Need by date. | |
| NONRECOVERABLE_INCLUSIVE_TAX | ● | Nonrecoverable inclusive tax. | |
| NONRECOVERABLE_TAX | ● | Nonrecoverable tax. | |
| PO_NUMBER | ● | Purchase order number. | |
| PRICE | ● | Price. | |
| PROMISED_DATE | ● | Promised date. | |
| PURCHASE_BASIS | ● | Purchase basis. | |
| QUANTITY_ORDERED | ● | Quantity ordered. | |
| SHIPMENT_NUMBER | ● | Shipment number. | |
| SUPPLIER_ITEM | ● | Supplier item. | |
| TAX_EXCLUSIVE_PRICE | ● | Tax exclusive price. | |
| UOM_CODE | ● | Code identifying the 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. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
Need the extract + dbt staging for CMR_PURCHASE_ORDER_DTLS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table