Stock Item Details
Module: Work Asset Analytics
Type: Fact
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| STOCK_ITEM_DTL_ID | VARCHAR2 | 12 | Stock Item Detail | DW_EWWA_X_EWDI_WACS_W1_BI_STOCK_ITEM_DTL_D | STOCK_ITEM_DTL_ID | ||
| STOCK_ITEM_ID | VARCHAR2 | 38 | Stock Item | DW_EWWA_X_EWDI_WACS_W1_BI_STOCK_ITEM_D | STOCK_ITEM_ID | ||
| SOURCE_RECORD_ID | VARCHAR2 | 51 | Source Record Id | ||||
| OWNING_ACCESS_GRP_CD | VARCHAR2 | 38 | Owning Organization | ||||
| SI_BELOW_MIN_QTY_CNT | NUMBER | 38 | 0 | Stock Item Below Minimum Quantity | |||
| SI_BELOW_REORDER_PT_CNT | NUMBER | 38 | 0 | Stock Item Below Reorder Point | |||
| SI_BELOW_SAFETY_STOCK_CNT | NUMBER | 38 | 0 | Stock Item Below Safety Stock | |||
| STOCK_ITEM_DTL_CNT | NUMBER | 38 | 0 | Stock Item Details Count | |||
| STOREROOM | VARCHAR2 | 38 | Storeroom | DW_EWWA_X_EWDI_WACS_W1_BI_STOREROOM_D | STOREROOM | ||
| TOTAL_INVENTORY_AVAILABLE_QTY | NUMBER | 38 | 5 | Inventory Available | |||
| TOTAL_INVENTORY_COST | NUMBER | Inventory Value | |||||
| TOTAL_INVENTORY_ON_HAND_QTY | NUMBER | 38 | 5 | Inventory on Hand | |||
| TOTAL_INV_OUT_STOCK_CNT | NUMBER | 38 | 0 | Inventory Out of Stock | |||
| TOTAL_IN_RECEIPT_QTY | NUMBER | 38 | 5 | Inventory In Receipt | |||
| TOTAL_IN_TRANSFER_QTY | NUMBER | Inventory In Transfer | |||||
| TOTAL_ON_DEMAND_QTY | NUMBER | 38 | 5 | Inventory On Demand | |||
| TOTAL_ON_ORDER_QTY | NUMBER | 38 | 5 | Inventory On Order | |||
| TOTAL_PEND_RET_QTY | NUMBER | Inventory Pending Return | |||||
| TOTAL_RESERVED_QTY | NUMBER | 38 | 5 | Inventory In Reserve | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |