1. Tables and Views for SCM
  2. CML_LANDED_COST_CHARGES

CML_LANDED_COST_CHARGES

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

Details

  • Schema: FUSION

  • Object owner: FUSION

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CML_LANDED_COST_CHARGES_PK

LANDED_COST_CHARGE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
LANDED_COST_CHARGE_ID NUMBER 18 Yes Surrogate key that identifies a record in this table.
CUBE_LOAD_REQUIRED_FLAG VARCHAR2 1 Flag to identify if this record has to be picked up by the Essbase cube loader. Default value is 'Y'. Obsolete
CHARGE_BU_FUNC_CURRENCY_DOCE VARCHAR2 15 Yes Currency in the primary ledger of Charge BU. Obsolete
MATERIAL_PC_BU_ID NUMBER 18 Yes Surrogate key that identifies a Material Profit Center BU.
INVENTORY_ORG_ID NUMBER 18 Yes Surrogate key that identifies the Deliver to Inventory Organization.
CMR_RCV_TRANSACTION_ID NUMBER 18 Yes Surrogate key that identifies a 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.
TRANSACTION_TYPE_CODE VARCHAR2 30 Yes Trade Operation Transaction type.
PROCUREMENT_BU_ID NUMBER 18 Yes Surrogate identifying the procurement business unit.
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.
CMR_PO_LINE_LOCATION_ID NUMBER 18 Yes The CMR Purchase order line location identifier.
ORDERED_QTY NUMBER Yes The quantity of a good or service ordered.
PO_UOM_CODE VARCHAR2 3 Yes The unit of measure code for the purchase order source quantity.
TRACKED_QTY NUMBER Yes Tracked quantity, defaulted from the PO ordered quantity.
RECEIPT_QTY_IN_PO_UOM NUMBER Yes Quantity received in the receipt in PO UOM.
PRIMARY_UOM_CODE VARCHAR2 3 Yes Indicates the primary unit of measure.
RECEIPT_QTY_IN_PRIMARY_UOM NUMBER Yes Quantity received in the receipt in Item's primary UOM.
MATERIAL_VENDOR_ID NUMBER 18 Yes Surrogate identifying the material vendor.
MATERIAL_VENDOR_SITE_ID NUMBER 18 Yes Material Supplier Site Identifier.
ITEM_CATEGORY_ID NUMBER 18 Yes Surrogate identifying the item category.
INVENTORY_ITEM_ID NUMBER 18 Yes Surrogate identifying the inventory item.
PO_ITEM_PRICE NUMBER Yes Indicates the item price of a purchase order.
PO_NONRECOVERABLE_TAX NUMBER Nonrecoverable tax on the purchase order.
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.
RECORD_UPDATE_DATE TIMESTAMP Yes Indicates the date and time of the last update of the row. Used to identify if this record has to be picked up by the Essbase Cube loader.
VERSION_ID NUMBER 18 Yes Indicates the version of the estimate or actual for a receipt and trade operation charge line. Version numbers start from 1.
ACTIVE_FLAG VARCHAR2 1 Yes Indicates whether there is more recent information for this receipt and trade operation charge line. Only the most recent record will have this flag set to Y.

Indexes

Index Uniqueness Tablespace Columns
CML_LANDED_COST_CHARGES_U1 Unique Default LANDED_COST_CHARGE_ID
CML_LANDED_COST_CHARGES_U2 Unique Default CMR_RCV_TRANSACTION_ID, TROP_CHARGE_LINE_ID, INVOICE_ID, INVOICE_LINE_NUMBER, VENDOR_ID, TRADE_OPERATION_ROUTE_ID, CHARGE_CURRENCY_CODE