CST_ACCT_ITEM_COSTS_DAILY
This table contains datewise snapshots of cost of inventory items at cost element level across Inventory locations in cost organizations. 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_ACCT_ITEM_COSTS_DAILY_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 | |
| VAL_UNIT_ID | NUMBER | 18 | Yes | Valuation unit identifier | |
| COST_ELEMENT_ID | NUMBER | 18 | Yes | Cost element corresponding to the cost of the transaction. | |
| SNAPSHOT_DATE | DATE | Yes | Cost in GL 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_ACCT_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 |