CST_COSTED_ITEM_COSTS_DAILY

This table contains datewise snapshots of costed Inventory items at cost element level within a valuation unit. Purpose of this data is to provide the information using BI reports or analytical dashboards.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CST_COSTED_ITEM_COSTS_DAI_PK

COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, VAL_UNIT_ID, COST_ELEMENT_ID, SNAPSHOT_DATE

Columns

Name Datatype Length Precision Not-null Comments
COST_ORG_ID NUMBER 18 Yes Single column FK: Identifies the Cost Organization associated with the inventory organization.
COST_BOOK_ID NUMBER 18 Yes Single column FK: Identifies the Cost Book assigned to the Cost Organization.
INVENTORY_ITEM_ID NUMBER 18 Yes Inventory Item Identifier
MASTER_ORGANIZATION_ID NUMBER 18 MASTER_ORGANIZATION_ID
VAL_UNIT_ID NUMBER 18 Yes Valuation unit identifier
COST_ELEMENT_ID NUMBER 18 Yes Cost element corresponding to the cost of the transaction.
COST_METHOD_CODE VARCHAR2 30 The cost method code like PERPETUAL AVERAGE, FIFO etc. Value comes from lookup_type CST_COST_METHODS
SNAPSHOT_DATE DATE Yes Cost in Costing Snapshot Date
EFF_TO_DATE DATE Identifies the date effectivity. The information in the row is valid upto this date.
UNIT_COST NUMBER Unit cost, after currency conversion
CURRENCY_CODE VARCHAR2 30 Yes Identifies the currency of the transaction / cost.
UOM_CODE VARCHAR2 30 Yes Unit of Measure
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.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Indexes

Index Uniqueness Tablespace Columns
CST_COSTED_ITEM_COSTS_DAILY_PK Unique FUSION_TS_TX_DATA COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, VAL_UNIT_ID, COST_ELEMENT_ID, SNAPSHOT_DATE
CST_COSTED_ITEM_COSTS_DLY_N1 Non Unique Default LAST_UPDATE_DATE