Table_Name |
|---|
W1_AST_DERMS_EVTCTL_CSTHIST |
W1_CU_CU_USAGE |
W1_DESIGN_ELEMENT_CHKLST_TYP |
W1_DESIGN_ELEMENT_DEP |
W1_TMPL_WO_DOCUMENT |
W1_WO_DOCUMENT |
Table_Name | Column_Name | Data Type | Data Length |
|---|---|---|---|
W1_AST_DERMS_EVTCTL_CSTHIST | ASSET_ID | CHAR | 12 |
W1_AST_DERMS_EVTCTL_CSTHIST | CST_SCORE | NUMBER | 16 |
W1_AST_DERMS_EVTCTL_CSTHIST | VERSION | NUMBER | 5 |
W1_AST_DERMS_EVTCTL_CSTHIST | W1_DYN_OPT_EVENT_ID | CHAR | 12 |
W1_AST_DERMS_EVTCTL_CSTHIST | ASSET_AVAILABILITY_FLG | CHAR | 1 |
W1_ W1_CU_CU_USAGE | CU_ID | CHAR | 12 |
W1_ W1_CU_CU_USAGE | CU_USAGE_CD | VARCHAR2 | 30 |
W1_ W1_CU_CU_USAGE | VERSION | NUMBER | 5 |
W1_DESIGN_ELEMENT_CHKLST_TYP | DESIGN_ELEMENT_ID | CHAR | 12 |
W1_DESIGN_ELEMENT_CHKLST_TYP | CHECKLIST_TYPE_CD | VARCHAR2 | 30 |
W1_DESIGN_ELEMENT_CHKLST_TYP | VERSION | NUMBER | 5 |
W1_DESIGN_ELEMENT_DEP | DESIGN_ELEMENT_ID | CHAR | 12 |
W1_DESIGN_ELEMENT_DEP | PRED_DESIGN_ELEMENT_ID | CHAR | 12 |
W1_DESIGN_ELEMENT_DEP | TIMING_OPTION_FLG | CHAR | 4 |
W1_DESIGN_ELEMENT_DEP | W1_MIN_OFFSET | NUMBER | 6 |
W1_DESIGN_ELEMENT_DEP | W1_MAX_OFFSET | NUMBER | 6 |
W1_DESIGN_ELEMENT_DEP | RESOURCE_OPTION_FLG | CHAR | 4 |
W1_DESIGN_ELEMENT_DEP | VERSION | NUMBER | 5 |
W1_TMPL_WO_DOCUMENT | TMPL_WO_ID | CHAR | 48 |
W1_TMPL_WO_DOCUMENT | ATTACHMENT_ID | CHAR | 56 |
W1_TMPL_WO_DOCUMENT | DOCUMENT_ID | CHAR | 48 |
W1_TMPL_WO_DOCUMENT | CRE_DTTM | DATE | 7 |
W1_TMPL_WO_DOCUMENT | USER_ID | CHAR | 32 |
W1_TMPL_WO_DOCUMENT | VERSION | NUMBER | 22 |
W1_WO_DOCUMENT | WO_ID | CHAR | 56 |
W1_WO_DOCUMENT | ATTACHMENT_ID | CHAR | 56 |
W1_WO_DOCUMENT | DOCUMENT_ID | CHAR | 48 |
W1_WO_DOCUMENT | CRE_DTTM | DATE | 7 |
W1_WO_DOCUMENT | USER_ID | CHAR | 32 |
W1_WO_DOCUMENT | VERSION | NUMBER | 22 |
Table_Name | Column_Name | Data Type | Data Length |
|---|---|---|---|
W1_BC_LINE | PI_RATIO | NUMBER (3) | NUMBER (8) |
W1_WORK_LOC | CITY | VARCHAR2 (90) | VARCHAR2 (30) |
W1_WORK_LOC | W1_CITY_UPR | VARCHAR2 (90) | VARCHAR2 (30) |
W1_WORK_REQ | CITY | VARCHAR2 (90) | VARCHAR2 (30) |
W1_WORK_REQ | W1_CITY_UPR | VARCHAR2 (90) | VARCHAR2 (30) |
Table_Name | Index_Name |
|---|---|
W1_ACT_CONSTR_LOC | W1T780S1 |
W1_APPROVAL_PROF | W1C556S1 |
W1_AST_DERMS_EVTCTL_CSTHIST | W1M967P0 |
W1_COMPLIANCE_TYPE_CHAR | W1C845S1 |
W1_CU | W1M746S3 |
W1_CU_CU_USAGE | W1M968P0 |
W1_CU_SET | W1C757S1 |
W1_DESIGN_ELEMENT_CHAR | W1M799S1 |
W1_DESIGN_ELEMENT_CHKLST_TYP | W1T966P0 |
W1_DESIGN_ELEMENT_DEP | W1T965P0 |
W1_DESIGN_ELEMENT_LOG | W1M801S1 |
W1_DESIGN_ELEMENT_LOG | W1M801S2 |
W1_EMPLOYEE | W1M500S5 |
W1_EMPLOYEE | W1M500S6 |
W1_EQUIP_GROUP | W1C768S1 |
W1_EU_TIMESHEET | W1M961P0 |
W1_FT | W1T312S1 |
W1_PR_HDR | W1T434S6 |
W1_PR_LINE | W1T443S3 |
W1_TIMEKEEPER | W1C948S1 |
W1_TMPL_WO_DOCUMENT | W1T970P0 |
W1_WORK_DESIGN_CHAR | W1M790S1 |
W1_WORK_DESIGN_LOG | W1M792S1 |
W1_WORK_DESIGN_LOG | W1M792S2 |
W1_WO_DOCUMENT | W1T969P0 |
Table_Name | Index_Name |
|---|---|
W1_RTN_LINE | W1M637S2 |
W1_RTN_LINE | W1M637S3 |
W1_STOCK_ITEM_DTL | W1M601S13 |