WORK ORDER OPERATION DETAIL Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACTIVITY_NUMBER |
XXX |
VARCHAR2 |
4 |
ACTUAL_WORK |
XXX |
VARCHAR2 |
17 |
CAPACITIES |
XXX |
VARCHAR2 |
4 |
CONFIRMATION_NUMBER |
XXX |
VARCHAR2 |
10 |
CONTROL_KEY |
XXX |
VARCHAR2 |
4 |
COUNTER |
Numeric field used to count entries in a table. Can be summed on a report. Example - if this field appeared on a table of Person information, it could be used on reports to show headcounts. |
VARCHAR2 |
8 |
DELETION_FLAG |
XXX |
VARCHAR2 |
1 |
DURATION |
XXX |
VARCHAR2 |
7 |
GOODS_RECIPIENT |
The person or group who will receive the goods. |
VARCHAR2 |
12 |
OBJECT_ID_RESOURCE |
XXX |
VARCHAR2 |
8 |
OBJECT_NUMBER |
XXX |
VARCHAR2 |
22 |
OBJECT_STATUS |
XXX |
VARCHAR2 |
40 |
OPERATION_TEXT |
XXX |
VARCHAR2 |
80 |
ROUTING_NUMBER |
XXX |
VARCHAR2 |
10 |
SEQUENCE |
Numerical value identifing the position of this data element within the table. |
VARCHAR2 |
20 |
TASK_LIST_TYPE |
XXX |
VARCHAR2 |
1 |
UNIT_FOR_WORK |
XXX |
VARCHAR2 |
3 |
USER_STATUS |
XXX |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
|
WORK_CENTER_KEY |
XXX |
VARCHAR2 |
8 |
WORK_INVOLVED |
XXX |
VARCHAR2 |
9 |
WORK_ORDER_CONFRM_ACTIVITY_KEY |
XXX |
VARCHAR2 |
6 |
WORK_ORDER_KEY |
XXX |
VARCHAR2 |
7 |
WORK_ORDER_PLANNER_GROUP_KEY |
XXX |
VARCHAR2 |
20 |