Table_Name | Column_Name | Data Type | Data Length |
---|---|---|---|
W1_ASSET | CST_SCORE* | NUMBER | 22 |
W1_ASSET | CST_SCR_DTTM* | DATE | 7 |
W1_AST_DERMS_EVTCTL_CSTHIST | ASSET_ID* | CHAR | 48 |
W1_AST_DERMS_EVTCTL_CSTHIST | CST_SCORE* | NUMBER | 22 |
W1_AST_DERMS_EVTCTL_CSTHIST | VERSION* | NUMBER | 22 |
W1_AST_DERMS_EVTCTL_CSTHIST | W1_DYN_OPT_EVENT_ID* | CHAR | 56 |
W1_DESIGN_ELEMENT | ACT_TYPE_CD | VARCHAR2 | 120 |
W1_DESIGN_ELEMENT | PLANNER_CD | VARCHAR2 | 120 |
W1_DESIGN_ELEMENT | SERVICE_CLASS_CD | VARCHAR2 | 120 |
W1_DESIGN_ELEMENT | W1_CREW_ID | CHAR | 48 |
W1_DESIGN_ELEMENT | WORK_CATEGORY_CD | VARCHAR2 | 120 |
W1_DESIGN_ELEMENT | WORK_CLASS_CD | VARCHAR2 | 120 |
W1_DESIGN_ELEMENT | WORK_PRIORITY_FLG | CHAR | 16 |
W1_DESIGN_ELEMENT_CHKLST_TYP | CHECKLIST_TYPE_CD | VARCHAR2 | 120 |
W1_DESIGN_ELEMENT_CHKLST_TYP | DESIGN_ELEMENT_ID | CHAR | 48 |
W1_DESIGN_ELEMENT_CHKLST_TYP | VERSION | NUMBER | 22 |
W1_DESIGN_ELEMENT_DEP | DESIGN_ELEMENT_ID | CHAR | 48 |
W1_DESIGN_ELEMENT_DEP | PRED_DESIGN_ELEMENT_ID | CHAR | 48 |
W1_DESIGN_ELEMENT_DEP | RESOURCE_OPTION_FLG | CHAR | 16 |
W1_DESIGN_ELEMENT_DEP | TIMING_OPTION_FLG | CHAR | 16 |
W1_DESIGN_ELEMENT_DEP | VERSION | NUMBER | 22 |
W1_DESIGN_ELEMENT_DEP | W1_MAX_OFFSET | NUMBER | 22 |
W1_DESIGN_ELEMENT_DEP | W1_MIN_OFFSET | NUMBER | 22 |
W1_STOCK_ITEM_DTL | ORDER_ON_DEMAND_FLG | CHAR | 16 |
W1_SVC_HIST | W1_DYN_OPT_EVENT_ID* | CHAR | 56 |
W1_WORK_DESIGN | W1_CREW_ID | CHAR | 48 |
W1_WORK_DESIGN | WD_SUBCLASS_FLG | CHAR | 16 |
W1_WORK_DESIGN | WORK_CATEGORY_CD | VARCHAR2 | 120 |
W1_WORK_DESIGN | WORK_CLASS_CD | VARCHAR2 | 120 |
W1_WORK_DESIGN | WORK_PRIORITY_FLG | CHAR | 16 |
W1_WORK_DESIGN | WO_BUS_OBJ_CD | VARCHAR2 | 120 |
W1_ACTIVITY | ACT_DURATION | NUMBER | 22 |
W1_ACTIVITY | UOT_FLG | CHAR | 4 |
W1_ACTIVITY_TYPE | ACT_DURATION | NUMBER | 22 |
W1_ACTIVITY_TYPE | UOT_FLG | CHAR | 4 |
W1_ASSET | ASSET_AVAILABILITY_FLG* | CHAR | 1 |
W1_AST_DERMS_EVTCTL_CSTHIST | ASSET_AVAILABILITY_FLG* | CHAR | 1 |
W1_CU_CU_USAGE | CU_ID | CHAR | 12 |
W1_CU_CU_USAGE | CU_USAGE_CD | VARCHAR2 | 30 |
W1_CU_CU_USAGE | VERSION | NUMBER | 22 |
W1_OVERHEAD | ADJUSTMENT_TYPE_CD | VARCHAR2 | 30 |
W1_OVERHEAD_RESRC | ADJUSTMENT_TYPE_CD | VARCHAR2 | 30 |
W1_TMPL_ACT | ACT_DURATION | NUMBER | 22 |
W1_TMPL_ACT | UOT_FLG | CHAR | 4 |
W1_ACT_RECON_PROP_UNIT | CU_ID | CHAR | 48 |
W1_ASSET | FIXED_ASSET_NUM | VARCHAR2 | 240 |
W1_CU | FIXED_ASSET_NUM | VARCHAR2 | 240 |
W1_PROJECT | ERP_CAPITAL_PRJ_FLG | CHAR | 16 |
W1_TMPL_WO_DOCUMENT | ATTACHMENT_ID | CHAR | 56 |
W1_TMPL_WO_DOCUMENT | CRE_DTTM | DATE | 7 |
W1_TMPL_WO_DOCUMENT | DOCUMENT_ID | CHAR | 48 |
W1_TMPL_WO_DOCUMENT | TMPL_WO_ID | CHAR | 48 |
W1_TMPL_WO_DOCUMENT | USER_ID | CHAR | 32 |
W1_TMPL_WO_DOCUMENT | VERSION | NUMBER | 22 |
W1_WORK_LOC | CITY | VARCHAR2 | 360 |
W1_WORK_LOC | W1_CITY_UPR | VARCHAR2 | 360 |
W1_WORK_REQ | CITY | VARCHAR2 | 360 |
W1_WORK_REQ | W1_CITY_UPR | VARCHAR2 | 360 |
W1_WO_DOCUMENT | ATTACHMENT_ID | CHAR | 56 |
W1_WO_DOCUMENT | CRE_DTTM | DATE | 7 |
W1_WO_DOCUMENT | DOCUMENT_ID | CHAR | 48 |
W1_WO_DOCUMENT | USER_ID | CHAR | 32 |
W1_WO_DOCUMENT | VERSION | NUMBER | 22 |
W1_WO_DOCUMENT | WO_ID | CHAR | 56 |