Table_Name |
---|
W1_ACTIVITY_MEASUREMENT_TYPE |
W1_EU_TIMESHEET |
W1_PROJECT_CATEGORY_LOG |
W1_PROJECT_CATEGORY_LOG_PARM |
W1_VENDOR_LOC_PAYTO_LOC |
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 | 22 |
W1_EMPLOYEE_TRAINING | EFFECTIVE_DT | DATE | 7 |
W1_EMPLOYEE_TRAINING | EMPLOYEE_NOTIFIED | CHAR | 1 |
W1_EMPLOYEE_TRAINING | SUPERVISOR_NOTIFIED | CHAR | 1 |
W1_EMPLOYEE_TRAINING | W1EXPIRATION_DT | DATE | 7 |
W1_EU | AUTO_TS_ CREATION | CHAR | 1 |
W1_EU_TIMESHEET | EU_DT | DATE | 7 |
W1_EU_TIMESHEET | EU_ID | CHAR | 12 |
W1_EU_TIMESHEET | HOURS | NUMBER | 22 |
W1_EU_TIMESHEET | VERSION | NUMBER | 22 |
W1_MAINT_TRIGGER | AUTO_SCHEDULE_FLG | CHAR | 4 |
W1_MAINT_TRIGGER | W1_CREW_ID | CHAR | 12 |
W1_PO_HEADER_DOCUMENT | PRINT_FLG | CHAR | 4 |
W1_PO_LINE | RR_ID | CHAR | 14 |
W1_PO_LINE_DOCUMENT | PRINT_FLG | CHAR | 4 |
W1_PROJECT_CATEGORY | BO_STATUS_CD | CHAR | 12 |
W1_PROJECT_CATEGORY | BO_STATUS_REASON_CD | VARCHAR2 | 30 |
W1_PROJECT_CATEGORY_LOG | ADHOC_CHAR_VAL | VARCHAR2 | 254 |
W1_PROJECT_CATEGORY_LOG | BO_STATUS_CD | CHAR | 12 |
W1_PROJECT_CATEGORY_LOG | BO_STATUS_REASON_CD | VARCHAR2 | 30 |
W1_PROJECT_CATEGORY_LOG | CHAR_TYPE_CD | CHAR | 8 |
W1_PROJECT_CATEGORY_LOG | CHAR_VAL | CHAR | 16 |
W1_PROJECT_CATEGORY_LOG | CHAR_VAL_FK1 | VARCHAR2 | 50 |
W1_PROJECT_CATEGORY_LOG | CHAR_VAL_FK2 | VARCHAR2 | 50 |
W1_PROJECT_CATEGORY_LOG | CHAR_VAL_FK3 | VARCHAR2 | 50 |
W1_PROJECT_CATEGORY_LOG | CHAR_VAL_FK4 | VARCHAR2 | 50 |
W1_PROJECT_CATEGORY_LOG | CHAR_VAL_FK5 | VARCHAR2 | 50 |
W1_PROJECT_CATEGORY_LOG | DESCRLONG | VARCHAR2 | 4000 |
W1_PROJECT_CATEGORY_LOG | LOG_DTTM | DATE | 7 |
W1_PROJECT_CATEGORY_LOG | LOG_ENTRY_TYPE_FLG | CHAR | 4 |
W1_PROJECT_CATEGORY_LOG | MESSAGE_CAT_NBR | NUMBER | 22 |
W1_PROJECT_CATEGORY_LOG | MESSAGE_NBR | NUMBER | 22 |
W1_PROJECT_CATEGORY_LOG | PRJ_CAT_CD | VARCHAR2 | 30 |
W1_PROJECT_CATEGORY_LOG | SEQNO | NUMBER | 22 |
W1_PROJECT_CATEGORY_LOG | USER_ID | CHAR | 8 |
W1_PROJECT_CATEGORY_LOG | VERSION | NUMBER | 22 |
W1_PROJECT_CATEGORY_LOG_PARM | F1_MSG_PARM_ VLONG | VARCHAR2 | 2000 |
W1_PROJECT_CATEGORY_LOG_PARM | MSG_PARM_TYP_ FLG | CHAR | 4 |
W1_PROJECT_CATEGORY_LOG_PARM | PARM_SEQ | NUMBER | 22 |
W1_PROJECT_CATEGORY_LOG_PARM | PRJ_CAT_CD | VARCHAR2 | 30 |
W1_PROJECT_CATEGORY_LOG_PARM | SEQNO | NUMBER | 22 |
W1_PROJECT_CATEGORY_LOG_PARM | VERSION | NUMBER | 22 |
W1_RR | BC_LINE_ID | CHAR | 14 |
W1_TIMESHEET_DETAIL | EU_ID | CHAR | 12 |
W1_VENDOR_LOC_PAYTO_LOC | PAY_TO_LOC | CHAR | 12 |
W1_VENDOR_LOC_PAYTO_LOC | VENDOR_LOC_ID | CHAR | 12 |
W1_VENDOR_LOC_PAYTO_LOC | VERSION | NUMBER | 22 |
Table_Name | Index_Name |
---|---|
W1_ACTIVITY | W1T244S18 |
W1_ACTIVITY | W1T244S19 |
W1_ACTIVITY | W1T244S20 |
W1_ACTIVITY_MEASUREMENT_TYPE | W1T962P0 |
W1_ACTIVITY_TYPE | W1C237S3 |
W1_EMPLOYEE_TRAINING | W1M502P0 |
W1_EU_TIMESHEET | W1M961P0 |
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_LINE | W1T443S3 |
W1_RCPT_HDR | W1T460S3 |
W1_RCPT_LINE | W1T468S3 |
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_TIMESHEET_DETAIL | W1M595S3 |
W1_TMPL_ACT | W1M617S1 |
W1_VENDOR_LOC_PAYTO_LOC | W1M955P0 |
W1_WO | W1T232S13 |
W1_WO | W1T232S14 |
W1_WORK_REQ | W1T298S8 |
Table_Name | Index_Name |
---|---|
W1_RTN_LINE | W1M637S2 |
W1_RTN_LINE | W1M637S3 |
W1_STOCK_ITEM_DTL | W1M601S13 |