CML_LANDED_COST_CHARGES
Landed Cost Reporting Object 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 |