1. Tables and Views for SCM
  2. CML_TO_LANDED_COST_CHARGES

CML_TO_LANDED_COST_CHARGES

Landed cost reporting object to store transfer order receipt charges for analytics and review.

Details

  • Schema: FUSION

  • Object owner: CML

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CML_TO_LANDED_COST_CHARGES_PK

TO_LANDED_COST_CHARGE_ID

Columns

Name Datatype Length Precision Not-null Comments
TO_LANDED_COST_CHARGE_ID NUMBER 18 Yes Surrogate key that identifies a record in this table.
DESTINATION_BUSINESS_UNIT_ID NUMBER 18 Yes Surrogate key that identifies the profit center business unit of the receiving organization.
SHIPPING_BUSINESS_UNIT_ID NUMBER 18 Yes Surrogate key that identifies the profit center business unit of the shipping organization.
TO_ORGANIZATION_ID NUMBER 18 Yes Surrogate key that identifies the Receiving Organization.
FROM_ORGANIZATION_ID NUMBER 18 Yes Surrogate key that identifies the Shipping Organization.
CMR_RCV_TRANSACTION_ID NUMBER 18 Yes Surrogate key that identifies a transfer order receipt in Costing.
RECEIPT_DATE DATE Yes The date on which receipt is created.
TRADE_OPERATION_ID NUMBER 18 Yes Surrogate key that identifies a Trade Operation.
TRADE_OPERATION_STATUS_CODE VARCHAR2 30 Yes Code indicating the status of trade operation.
TRADE_OPERATION_ROUTE_ID NUMBER 18 Route associated to the trade operation.
CHARGE_ID NUMBER 18 Yes Surrogate key that identifies a Landed Cost Charge.
TROP_CHARGE_LINE_ID NUMBER 18 Yes Surrogate key that identifies a Trade Operation Charge line.
VENDOR_ID NUMBER 18 Yes The supplier rendering the service.
VENDOR_SITE_ID NUMBER 18 Yes The supplier site rendering the service.
CHARGE_BU_ID NUMBER 18 Yes Surrogate key that identifies a Charge BU.
SHIPMENT_LINE_ID NUMBER 18 Yes Surrogate key that identifies a shipment line.
SHIPPED_QTY_IN_TO_UOM NUMBER Yes This column stores the quantity shipped for the transfer order shipment line.
TO_UOM_CODE VARCHAR2 3 Yes Transfer order shipment line UOM code.
SHIPPED_QTY NUMBER Yes Transfer order shipment line quantity.
SHIPMENT_UOM_CODE VARCHAR2 3 Yes UOM of the transfer order shipment line quantity.
RECEIPT_QTY_IN_PRIMARY_UOM NUMBER Yes Quantity received in primary UOM code.
PRIMARY_UOM_CODE VARCHAR2 25 Yes Item's primary unit of measure in the receiving organization of the transfer order shipment.
RECEIPT_QTY_IN_TO_UOM NUMBER Yes Quantity received in transfer order shipment line UOM code.
ITEM_CATEGORY_ID NUMBER 18 Yes Surrogate identifying the item category.
INVENTORY_ITEM_ID NUMBER 18 Yes Surrogate identifying the inventory item.
ESTIMATED_TRANSFER_PRICE NUMBER Indicates the estimated transfer price returned by pricing.
CURRENCY_CODE VARCHAR2 15 Functional currency of the BU corresponding to receiving organization.
CHARGE_CURRENCY_CODE VARCHAR2 15 Currency in which the charge amount is entered.
MAT_PC_BU_FUNC_CURRENCY_CODE VARCHAR2 15 Yes Currency in the primary ledger of Material Profit Center BU.
CHARGE_BU_FUNC_CURRENCY_CODE VARCHAR2 15 Yes Currency in the primary ledger of Charge BU.
INVOICE_CURRENCY_CODE VARCHAR2 15 Currency code in which invoice is created.
INVOICE_ID NUMBER 18 Surrogate key that identifies an invoice.
INVOICE_LINE_NUMBER NUMBER 18 Uniquely identifies the line within an invoice.
EST_UNIT_AMT_IN_CHARGE_CURR NUMBER Per Unit estimated amount in Charge currency.
EST_UNIT_TAX_IN_CHARGE_CURR NUMBER Per Unit estimated tax in Charge currency.
EST_UNIT_AMT_IN_MAT_PC_BU_CURR NUMBER Per Unit estimated amount in Material Profit Center BU Functional currency.
EST_UNIT_TAX_IN_MAT_PC_BU_CURR NUMBER Per Unit estimated tax in Material Profit Center BU Functional currency.
EST_UNIT_AMT_IN_CHARGE_BU_CURR NUMBER Per Unit estimated amount in Charge BU Functional currency.
EST_UNIT_TAX_IN_CHARGE_BU_CURR NUMBER Per Unit estimated tax in Charge BU Functional currency.
ACT_UNIT_AMT_IN_INVOICE_CURR NUMBER Per Unit actual amount in Invoice currency.
ACT_UNIT_TAX_IN_INVOICE_CURR NUMBER Per Unit actual tax in Invoice currency.
ACT_UNIT_AMT_IN_MAT_PC_BU_CURR NUMBER Per Unit actual amount in Material Profit Center BU Functional currency.
ACT_UNIT_TAX_IN_MAT_PC_BU_CURR NUMBER Per Unit actual tax in Material Profit Center BU Functional currency.
ACT_UNIT_AMT_IN_CHARGE_BU_CURR NUMBER Per Unit actual amount in Charge BU Functional currency.
ACT_UNIT_TAX_IN_CHARGE_BU_CURR NUMBER Per Unit actual tax in Charge BU Functional currency.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
TORECEIPT_CHARGE_ESTIMATE_ID NUMBER 18 Surrogate ID that identifies the record in CML_TORECEIPT_CHARGE_ESTIMATES table used to populate the data in this table.
TORECEIPT_CHARGE_ACTUAL_ID NUMBER 18 Surrogate ID that identifies the record in CML_TORECEIPT_CHARGE_ACTUALS table used to populate the data in this table.

Indexes

Index Uniqueness Tablespace Columns
CML_TO_LANDED_COST_CHARGES_N1 Non Unique DEFAULT SHIPMENT_LINE_ID
CML_TO_LANDED_COST_CHARGES_U1 Unique Default TO_LANDED_COST_CHARGE_ID
CML_TO_LANDED_COST_CHARGES_U2 Unique Default CMR_RCV_TRANSACTION_ID, TROP_CHARGE_LINE_ID, INVOICE_ID, INVOICE_LINE_NUMBER