CST_ACCT_ONHAND_DAILY
This table contains datewise snapshots of inventory item valuation 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_ONHAND_DAILY_PK |
PK_INDEX |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PK_INDEX | VARCHAR2 | 256 | Yes | PK_INDEX | |
| 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. | |
| VAL_UNIT_ID | NUMBER | 18 | Yes | Valuation unit identifier | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory Item | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Yes | Business Unit Id of the Inventory Organization. | |
| SNAPSHOT_DATE | DATE | Yes | Identifies the date of snapshot of On-hand Inventory taken for OBIA/OTBI usage | ||
| EFF_TO_DATE | DATE | Identifies the date effectivity. The information in the row is valid upto this date. | |||
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Indicates The Inventory Org To Which The Item Belongs | |
| SUBINVENTORY_CODE | VARCHAR2 | 10 | The subinventory code where the item is stored | ||
| LOCATOR_ID | NUMBER | 18 | Inventory locator identifier | ||
| QUANTITY | NUMBER | Quantity Onhand. | |||
| UOM_CODE | VARCHAR2 | 3 | Unit of Measure | ||
| AMOUNT | NUMBER | AMOUNT | |||
| CURRENCY_CODE | VARCHAR2 | 30 | Yes | Identifies the currency of the transaction / cost. | |
| VAL_STRUCTURE_TYPE_CODE | VARCHAR2 | 30 | Valuation Structure Type. | ||
| 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_ONHAND_DAILY_PK | Unique | FUSION_TS_TX_DATA | PK_INDEX |
| CST_ACCT_ONHAND_DAILY_U1 | Unique | FUSION_TS_TX_DATA | COST_ORG_ID, COST_BOOK_ID, VAL_UNIT_ID, INVENTORY_ITEM_ID, SNAPSHOT_DATE, INVENTORY_ORG_ID, SUBINVENTORY_CODE, LOCATOR_ID |