Oracle Fusion · Data dictionary
CML_LANDED_COST_CHARGES
CostingUsed in 1 subject areas29 reporting columns
Source object in the Oracle Fusion data model.
Likely primary key: LANDED_COST_CHARGE_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACT_UNIT_AMT_IN_CHARGE_BU_CURR | ● | Act unit amount in charge business unit currency. | |
| ACT_UNIT_AMT_IN_INVOICE_CURR | ● | Act unit amount in invoice currency. | |
| ACT_UNIT_AMT_IN_MAT_PC_BU_CURR | ● | Act unit amount in mat pc business unit currency. | |
| ACT_UNIT_TAX_IN_CHARGE_BU_CURR | ● | Act unit tax in charge business unit currency. | |
| ACT_UNIT_TAX_IN_INVOICE_CURR | ● | Act unit tax in invoice currency. | |
| ACT_UNIT_TAX_IN_MAT_PC_BU_CURR | ● | Act unit tax in mat pc business unit currency. | |
| CHARGE_BU_FUNC_CURRENCY_CODE | ● | Currency code for the charge business unit func. | |
| CHARGE_CURRENCY_CODE | ● | Currency code for the charge. | |
| CMR_RCV_TRANSACTION_ID | ● | Identifier for the cmr receiving transaction. | |
| EST_UNIT_AMT_IN_CHARGE_BU_CURR | ● | Est unit amount in charge business unit currency. | |
| EST_UNIT_AMT_IN_CHARGE_CURR | ● | Est unit amount in charge currency. | |
| EST_UNIT_AMT_IN_MAT_PC_BU_CURR | ● | Est unit amount in mat pc business unit currency. | |
| EST_UNIT_TAX_IN_CHARGE_BU_CURR | ● | Est unit tax in charge business unit currency. | |
| EST_UNIT_TAX_IN_CHARGE_CURR | ● | Est unit tax in charge currency. | |
| EST_UNIT_TAX_IN_MAT_PC_BU_CURR | ● | Est unit tax in mat pc business unit currency. | |
| INVOICE_CURRENCY_CODE | ● | Currency code for the invoice. | |
| LANDED_COST_CHARGE_ID | PK? | ● | Identifier for the landed cost charge. |
| MAT_PC_BU_FUNC_CURRENCY_CODE | ● | Currency code for the mat pc business unit func. | |
| ORDERED_QTY | ● | Ordered quantity. | |
| PO_ITEM_PRICE | ● | Purchase order item price. | |
| PO_NONRECOVERABLE_TAX | ● | Purchase order nonrecoverable tax. | |
| PO_UOM_CODE | ● | Code identifying the purchase order unit of measure. | |
| PRIMARY_UOM_CODE | ● | Code identifying the primary unit of measure. | |
| RECEIPT_DATE | ● | Receipt date. | |
| RECEIPT_QTY_IN_PO_UOM | ● | Receipt quantity in purchase order unit of measure. | |
| RECEIPT_QTY_IN_PRIMARY_UOM | ● | Receipt quantity in primary unit of measure. | |
| TRACKED_QTY | ● | Tracked quantity. | |
| TRADE_OPERATION_STATUS_CODE | ● | Code identifying the trade operation status. | |
| TRANSACTION_TYPE_CODE | ● | Code identifying the transaction type. |
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 CML_LANDED_COST_CHARGES?
We ship parameterized SQL, BICC config, and dbt models you own.