| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | WHMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 2 | WHWDOCO | Work Order ID | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 3 | WHWAWON | WIM Alternate Work Order Number | String | Generic Edit | 20 | 0 | Allow NULL? |
| 4 | WHWODSC | Blend Management Work Order Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 5 | WHWWOT | Work Order Type | String | UDC (31B TW) | 3 | 0 | Allow NULL? |
| 6 | WHWCRTR | Creator ID | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 7 | WHWODC | Work Order Date Created | Date | Generic Edit | 6 | 0 | |
| 8 | WHWODR | Work Order Date Requested | Date | Generic Edit | 6 | 0 | |
| 9 | WHWWOST | Work Order Status | String | UDC (31B WF) | 10 | 0 | Allow NULL? |
| 10 | WHWWOH1 | Work Order Category Code 1 | String | UDC (31B H1) | 10 | 0 | Allow NULL? |
| 11 | WHWWOH2 | Work Order Category Code 2 | String | UDC (31B H2) | 10 | 0 | Allow NULL? |
| 12 | WHWWOH3 | Work Order Category Code 3 | String | UDC (31B H3) | 10 | 0 | Allow NULL? |
| 13 | WHWWOH4 | Work Order Category Code 4 | String | UDC (31B H4) | 10 | 0 | Allow NULL? |
| 14 | WHWWOH5 | Work Order Category Code 5 | String | UDC (31B H5) | 10 | 0 | Allow NULL? |
| 15 | WHWTI | Template Indicator | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | WHWOTN | WO Template Name | String | Generic Edit | 20 | 0 | Allow NULL? |
| 17 | WHWOTT | WO Template Class | Character | UDC (31B WL) | 1 | 0 | Allow NULL? |
| 18 | WHWOTS | WO Template Status | Character | UDC (31B ST) | 1 | 0 | Allow NULL? |
| 19 | WHBMEFFF | Effective - From Date | Date | Generic Edit | 6 | 0 | |
| 20 | WHBMEFFT | Effective - Thru Date | Date | Generic Edit | 6 | 0 | |
| 21 | WHWHAR | Harvest Operation Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 22 | WHURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 23 | WHURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 24 | WHURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 25 | WHURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 26 | WHURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 27 | WHWMDT | Blend Mgmt Date | Date | Generic Edit | 6 | 0 | |
| 28 | WHWNUM | Blend Mgmt Numeric | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 29 | WHWAB | Blend Mgmt Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 30 | WHWCD | Blend Mgmt Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 31 | WHWRF | Blend Mgmt Reference | String | Generic Edit | 30 | 0 | Allow NULL? |
| 32 | WHUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 33 | WHUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 34 | WHUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 35 | WHJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | WHMKEY | Machine Key | String | Generic Edit | 15 | 0 | Allow NULL? |
| 37 | WHPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |