Module: Work Asset Analytics
Type: Dimension
RESRC_TYPE_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| RESRC_TYPE_ID | VARCHAR2 | 12 | True | Resource Type | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| ACPT_ON_RCPT_FLG | VARCHAR2 | 38 | Accept On Receipt | ||||
| ADD_TO_BOM_FLG | VARCHAR2 | 38 | Add to BOM on Material Issue | ||||
| BO_STATUS_CD | VARCHAR2 | 38 | Status | ||||
| CAPITAL_SPARE_FLG | VARCHAR2 | 38 | Capital Spare | ||||
| CMDTY_CAT_CD | VARCHAR2 | 38 | Commodity Category | ||||
| CMDTY_CMP_CD | VARCHAR2 | 38 | Commodity Composition | ||||
| CMDTY_NAME_CD | VARCHAR2 | 38 | Commodity Name | ||||
| CMDTY_SIZE | VARCHAR2 | 60 | Commodity Size | ||||
| CMDTY_TYPE_CD | VARCHAR2 | 38 | Commodity Type | ||||
| DEFAULT_VAL_ACT_FLG | VARCHAR2 | 38 | Default Values to Activity | ||||
| DO_NOT_SUB_FLG | VARCHAR2 | 38 | Allow Substitutes | ||||
| HAZARDOUS_FLG | VARCHAR2 | 38 | Hazardous | ||||
| HAZARD_TYPE_FLG | VARCHAR2 | 38 | Hazardous Type | ||||
| LOT_MANAGED_FLG | VARCHAR2 | 38 | Lot Managed | ||||
| PI_RATIO | NUMBER | 8 | 0 | Purchase to Issue Ratio | |||
| REPAIRABLE_FLG | VARCHAR2 | 38 | Repairable | ||||
| RESRC_SRC_FLG | VARCHAR2 | 38 | Resource Source | ||||
| SCHEDULE_PRIORITY | NUMBER | 3 | 0 | Schedule Priority | |||
| SHELF_LIFE | NUMBER | 6 | 0 | Shelf Life | |||
| STOCK_CAT_FLG | VARCHAR2 | 38 | Stock Item Category | ||||
| TRACKABLE_FLG | VARCHAR2 | 38 | Trackable | ||||
| TRUCK_STOCK_FLG | VARCHAR2 | 38 | Truck Stock | ||||
| UNIT_PRICE | NUMBER | 18 | 7 | Unit Price | |||
| W1_RESRC_CLASS_FLG | VARCHAR2 | 4 | Resource Class | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |