Table_Name |
|---|
W1_ACTIVITY_MEASUREMENT_TYPE |
W1_AST_DERMS_EVTCTL_CSTHIST |
W1_CU_CU_USAGE |
W1_DESIGN_ELEMENT_CHKLST_TYP |
W1_DESIGN_ELEMENT_DEP |
W1_EU_TIMESHEET |
W1_PROJECT_CATEGORY_LOG |
W1_PROJECT_CATEGORY_LOG_PARM |
W1_TMPL_WO_DOCUMENT |
W1_VENDOR_LOC_PAYTO_LOC |
W1_WO_DOCUMENT |
Table_Name | Column_Name | Data Type | Data Length |
|---|---|---|---|
W1_ACTIVITY_MEASUREMENT_TYPE | ACT_ID | CHAR | 14 |
W1_ACTIVITY_MEASUREMENT_TYPE | MEASUREMENT_TYPE_CD | VARCHAR2 | 30 |
W1_ACTIVITY_MEASUREMENT_TYPE | VERSION | NUMBER | 5 |
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_EU_TIMESHEET | EU_ID | CHAR | 12 |
W1_EU_TIMESHEET | EU_DT | DATE | 7 |
W1_EU_TIMESHEET | HOURS | NUMBER | 13 |
W1_EU_TIMESHEET | VERSION | NUMBER | 5 |
W1_PROJECT_CATEGORY_LOG | PRJ_CAT_CD | VARCHAR2 | 120 |
W1_PROJECT_CATEGORY_LOG | SEQNO | NUMBER | 22 |
W1_PROJECT_CATEGORY_LOG | BO_STATUS_CD | CHAR | 48 |
W1_PROJECT_CATEGORY_LOG | BO_STATUS_REASON_CD | VARCHAR2 | 120 |
W1_PROJECT_CATEGORY_LOG | ADHOC_CHAR_VAL | VARCHAR2 | 1016 |
W1_PROJECT_CATEGORY_LOG | CHAR_TYPE_CD | CHAR | 32 |
W1_PROJECT_CATEGORY_LOG | CHAR_VAL | CHAR | 64 |
W1_PROJECT_CATEGORY_LOG | CHAR_VAL_FK1 | VARCHAR2 | 200 |
W1_PROJECT_CATEGORY_LOG | CHAR_VAL_FK2 | VARCHAR2 | 200 |
W1_PROJECT_CATEGORY_LOG | CHAR_VAL_FK3 | VARCHAR2 | 200 |
W1_PROJECT_CATEGORY_LOG | CHAR_VAL_FK4 | VARCHAR2 | 200 |
W1_PROJECT_CATEGORY_LOG | CHAR_VAL_FK5 | VARCHAR2 | 200 |
W1_PROJECT_CATEGORY_LOG | DESCRLONG | VARCHAR2 | 16000 |
W1_PROJECT_CATEGORY_LOG | LOG_DTTM | DATE | 7 |
W1_PROJECT_CATEGORY_LOG | LOG_ENTRY_TYPE_FLG | CHAR | 16 |
W1_PROJECT_CATEGORY_LOG | MESSAGE_CAT_NBR | NUMBER | 22 |
W1_PROJECT_CATEGORY_LOG | MESSAGE_NBR | NUMBER | 22 |
W1_PROJECT_CATEGORY_LOG | USER_ID | CHAR | 32 |
W1_PROJECT_CATEGORY_LOG | VERSION | NUMBER | 22 |
W1_PROJECT_CATEGORY_LOG_PARM | PRJ_CAT_CD | VARCHAR2 | 120 |
W1_PROJECT_CATEGORY_LOG_PARM | SEQNO | NUMBER | 22 |
W1_PROJECT_CATEGORY_LOG_PARM | PARM_SEQ | NUMBER | 22 |
W1_PROJECT_CATEGORY_LOG_PARM | MSG_PARM_TYP_FLG | CHAR | 16 |
W1_PROJECT_CATEGORY_LOG_PARM | F1_MSG_PARM_VLONG | VARCHAR2 | 8000 |
W1_PROJECT_CATEGORY_LOG_PARM | VERSION | NUMBER | 22 |
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_VENDOR_LOC_PAYTO_LOC | VENDOR_LOC_ID | CHAR | 48 |
W1_VENDOR_LOC_PAYTO_LOC | PAY_TO_LOC | CHAR | 48 |
W1_VENDOR_LOC_PAYTO_LOC | 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_ACTIVITY | W1T244S18 |
W1_ACTIVITY | W1T244S19 |
W1_ACTIVITY | W1T244S20 |
W1_ACTIVITY_MEASUREMENT_TYPE | W1T962P0 |
W1_ACTIVITY_TYPE | W1C237S3 |
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_INVOICE_HEADER | W1T500S2 |
W1_INVOICE_LINE | W1T509S3 |
W1_INVOICE_LINE | W1T509S4 |
W1_INVOICE_LINE | W1T509S5 |
W1_MAINT_TRIGGER | W1M658S3 |
W1_NODE | W1M205S10 |
W1_NODE | W1M205S11 |
W1_NODE_TYPE | W1C200S1 |
W1_PI_CNT_MST | W1T324S3 |
W1_PO_HEADER | W1T410S5 |
W1_PO_LINE | W1T418S5 |
W1_PO_LINE | W1T418S6 |
W1_PO_LINE | W1T418S7 |
W1_PO_LINE | W1T418S8 |
W1_PROJECT_CATEGORY_LOG | W1C963P0 |
W1_PROJECT_CATEGORY_LOG_PARM | W1C964P0 |
W1_PR_HDR | W1T434S6 |
W1_PR_LINE | W1T443S3 |
W1_RCPT_HDR | W1T460S3 |
W1_RCPT_LINE | W1T468S3 |
W1_RR | W1T405S2 |
W1_RTN_LINE | W1T483S2 |
W1_RTN_LINE | W1T483S3 |
W1_RTN_LINE | W1T483S4 |
W1_RTN_LINE | W1T483S5 |
W1_RTN_LINE | W1T483S6 |
W1_STOCK_ITEM_DTL | W1M568S4 |
W1_STOCK_ITEM_DTL | W1M568S5 |
W1_TIMEKEEPER | W1C948S1 |
W1_TIMESHEET_DETAIL | W1M595S3 |
W1_TMPL_ACT | W1M617S1 |
W1_TMPL_WO_DOCUMENT | W1T970P0 |
W1_VENDOR_LOC_PAYTO_LOC | W1M955P0 |
W1_WO | W1T232S13 |
W1_WO | W1T232S14 |
W1_WORK_DESIGN_CHAR | W1M790S1 |
W1_WORK_DESIGN_LOG | W1M792S1 |
W1_WORK_DESIGN_LOG | W1M792S2 |
W1_WORK_REQ | W1T298S8 |
W1_WO_DOCUMENT | W1T969P0 |
Table_Name | Index_Name |
|---|---|
W1_RTN_LINE | W1M637S2 |
W1_RTN_LINE | W1M637S3 |
W1_STOCK_ITEM_DTL | W1M601S13 |