Module: Work Asset Analytics
Type: Dimension
INV_ADJ_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| INV_ADJ_ID | VARCHAR2 | 14 | True | Inventory Adjustment | |||
| SOURCE_RECORD_ID | VARCHAR2 | 14 | Source Record Id | ||||
| INV_ADJ_STATUS_CD | VARCHAR2 | 38 | Inventory Adjustment Status | ||||
| NEW_QTY | NUMBER | 13 | 5 | New Quantity | |||
| NEW_UNIT_PRICE | NUMBER | 18 | 7 | New Average Unit Price | |||
| OLD_QTY | NUMBER | 13 | 5 | Old Quantity | |||
| OLD_UNIT_PRICE | NUMBER | 18 | 7 | Old Average Unit Price | |||
| REASON_CD_FLG | VARCHAR2 | 38 | Reason | ||||
| TYPE_OF_INV_ADJ_FLG | VARCHAR2 | 4 | Type of Inventory Adjustment | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |