Oracle Fusion · Data dictionary
CML_TO_LANDED_COST_CHARGES
CostingUsed in 1 subject areas28 reporting columns
Source object in the Oracle Fusion data model.
Likely primary key: TO_LANDED_COST_CHARGE_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): INVOICE_ID → AP_INVOICES_ALL
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. | |
| CMR_RCV_TRANSACTION_ID | ● | Identifier for the cmr receiving transaction. | |
| ESTIMATED_TRANSFER_PRICE | ● | Estimated transfer price. | |
| 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_ID | ● | Identifier for the invoice. | |
| INVOICE_LINE_NUMBER | ● | Invoice line number. | |
| MAT_PC_BU_FUNC_CURRENCY_CODE | ● | Currency code for the mat pc business unit func. | |
| PRIMARY_UOM_CODE | ● | Code identifying the primary unit of measure. | |
| RECEIPT_DATE | ● | Receipt date. | |
| RECEIPT_QTY_IN_PRIMARY_UOM | ● | Receipt quantity in primary unit of measure. | |
| RECEIPT_QTY_IN_TO_UOM | ● | Receipt quantity in to unit of measure. | |
| SHIPPED_QTY | ● | Shipped quantity. | |
| SHIPPED_QTY_IN_TO_UOM | ● | Shipped quantity in to unit of measure. | |
| TORECEIPT_CHARGE_ACTUAL_ID | ● | Identifier for the toreceipt charge actual. | |
| TORECEIPT_CHARGE_ESTIMATE_ID | ● | Identifier for the toreceipt charge estimate. | |
| TO_LANDED_COST_CHARGE_ID | PK? | ● | Identifier for the to landed cost charge. |
| TROP_CHARGE_LINE_ID | ● | Identifier for the trop charge line. |
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 CML_TO_LANDED_COST_CHARGES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table