WORK ORDER USER STATUS Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IS_CANCELLED |
XXX |
VARCHAR2 |
1 |
IS_CLOSED |
Y= this account is closed. |
VARCHAR2 |
1 |
IS_IN_PROGRESS |
XXX |
VARCHAR2 |
1 |
IS_NEW |
XXX |
VARCHAR2 |
1 |
IS_OUT_OF_COMMISSION |
XXX |
VARCHAR2 |
1 |
IS_TRANSFERRED |
XXX |
VARCHAR2 |
1 |
IS_WAITING_FOR_CONTRACTOR |
XXX |
VARCHAR2 |
1 |
IS_WAITING_FOR_CUSTOMER |
XXX |
VARCHAR2 |
1 |
IS_WAITING_FOR_PARTS |
XXX |
VARCHAR2 |
1 |
IS_WAITING_FOR_SCHEDULE_DATE |
XXX |
VARCHAR2 |
1 |
IS_WAITING_TO_BE_ASSIGNED |
XXX |
VARCHAR2 |
1 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
|
WORK_ORDER_USER_STATUS_KEY |
XXX |
VARCHAR2 |
20 |