Module: Work Asset Analytics
Type: Dimension
STOCK_ITEM_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| STOCK_ITEM_ID | VARCHAR2 | 12 | True | Stock Item | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| ACCEPT_ON_RCPT_FLG | VARCHAR2 | 38 | Accept on Receipt | ||||
| ALLOWED_ON_BOM_ASBMLY_FLG | VARCHAR2 | 38 | Allowed on BOM Assembly | ||||
| CAPITAL_SPARE_FLG | VARCHAR2 | 38 | Capital Spare | ||||
| CMDTY_CAT_CD | VARCHAR2 | 38 | Commodity Category | ||||
| CMDTY_NAME_CD | VARCHAR2 | 38 | Commodity Name | ||||
| CMDTY_TYPE_CD | VARCHAR2 | 38 | Commodity Type | ||||
| DESCR100 | VARCHAR2 | 100 | Description | ||||
| DESCRLONG | VARCHAR2 | 4000 | Detailed Description | ||||
| DO_NOT_SUB_FLG | VARCHAR2 | 38 | Allow Substitutes | ||||
| HAZARDOUS_FLG | VARCHAR2 | 38 | Hazardous | ||||
| HAZARD_TYPE_FLG | VARCHAR2 | 38 | Hazardous Type | ||||
| INVENTORY_EXPENSE_CD | VARCHAR2 | 38 | Inventory Expense | ||||
| LOT_MANAGED_FLG | VARCHAR2 | 38 | Lot Managed | ||||
| PURCHASE_CMDTY_CD | VARCHAR2 | 38 | Purchase Commodity | ||||
| REPAIRABLE_FLG | VARCHAR2 | 38 | Repairable | ||||
| SHELF_LIFE | NUMBER | 6 | 0 | Shelf Life | |||
| STOCK_CAT_FLG | VARCHAR2 | 38 | Stock Item Category | ||||
| STOCK_INFORMATION | VARCHAR2 | 163 | Stock Item Information | ||||
| STOCK_ITEM_CODE | VARCHAR2 | 60 | Stock Item Code | ||||
| STOCK_ITEM_STATUS_CD | VARCHAR2 | 38 | Stock Item Status | ||||
| TRACKABLE_FLG | VARCHAR2 | 38 | Trackable | ||||
| TRUCK_STOCK_FLG | VARCHAR2 | 38 | Truck Stock | ||||
| UNIT_PRICE | NUMBER | 18 | 7 | Unit Price | |||
| USAGE_EXPENSE_CD | VARCHAR2 | 38 | Usage Expense Code | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |