Stock Transactions
Module: Work Asset Analytics
Type: Fact
STOCK_TRANS_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| STOCK_TRANS_ID | VARCHAR2 | 14 | True | Stock Transaction | |||
| SOURCE_RECORD_ID | VARCHAR2 | 14 | Source Record Id | ||||
| ACCEPT_LINE_ID | VARCHAR2 | 14 | Accept Line | DW_EWWA_X_EWDI_WACS_W1_ACPT_LINE_D | ACPT_LINE_ID | ||
| INITIATED_BY_MO_CD | VARCHAR2 | 12 | Initiated By | DW_EWWA_X_EWDI_WACS_CI_MD_MO | MAINT_OBJ_CD | ||
| INV_ADJ_ID | VARCHAR2 | 14 | Inventory Adjustment | DW_EWWA_X_EWDI_WACS_W1_INV_ADJ_D | INV_ADJ_ID | ||
| MAT_ISSUE_LINE_ID | VARCHAR2 | 14 | Material Issue Line | DW_EWWA_X_EWDI_WACS_W1_MAT_ISS_LINE_D | MAT_ISS_LINE_ID | ||
| MAT_RET_LINE_ID | VARCHAR2 | 14 | Material Return Line | DW_EWWA_X_EWDI_WACS_W1_MAT_RET_LINE_D | MAT_RET_LINE_ID | ||
| OWNING_ACCESS_GRP_CD | VARCHAR2 | 38 | Owning Organization | ||||
| PI_CNT_LINE_ID | VARCHAR2 | 14 | Physical Inventory Count Line | DW_EWWA_X_EWDI_WACS_W1_PI_CNT_LINE_D | PI_CNT_LINE_ID | ||
| PO_LINE_ID | VARCHAR2 | 14 | Purchase Order Line | DW_EWWA_X_EWDI_WACS_W1_PO_LINE_D | PO_LINE_ID | ||
| REQUESTED_BY_MO_CD | VARCHAR2 | 12 | Created By | ||||
| RTN_LINE_ID | VARCHAR2 | 14 | Return Line | DW_EWWA_X_EWDI_WACS_W1_RTN_LINE_D | RTN_LINE_ID | ||
| 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 | ||
| STOCK_TRANS_CNT | NUMBER | 38 | 0 | Stock Transaction Count | |||
| STOREROOM | VARCHAR2 | 38 | Storeroom | DW_EWWA_X_EWDI_WACS_W1_BI_STOREROOM_D | STOREROOM | ||
| TOTAL_INVENTORY_COST | NUMBER | 38 | 7 | Inventory Value | |||
| TOTAL_INVENTORY_ON_HAND_QTY | NUMBER | 38 | 5 | Inventory on Hand | |||
| TOTAL_IN_RECEIPT_QTY | NUMBER | 13 | 5 | Inventory In Receipt | |||
| TOTAL_IN_TRANSFER_QTY | NUMBER | 13 | 5 | Inventory In Transfer | |||
| TOTAL_ON_DEMAND_QTY | NUMBER | 13 | 5 | Inventory On Demand | |||
| TOTAL_ON_ORDER_QTY | NUMBER | 13 | 5 | Inventory On Order | |||
| TOTAL_RESERVED_QTY | NUMBER | 13 | 5 | Inventory In Reserve | |||
| UNIT_PRICE | NUMBER | 18 | 7 | Unit Price | |||
| W1_TRANS_DT | NUMBER | 38 | 0 | Transaction Date | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |