| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | WOJOBS | Job Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | WOUKID | Unique Key ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 3 | WOC9LANC | Master Work Order | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | WODCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 5 | WOITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 6 | WOMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 7 | WOTRQT | Quantity Available | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 8 | WOUORG | Units - Order/Transaction Quantity | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 9 | WOSTRT | Date - Start (Julian) | Date | Generic Edit | 6 | 0 | |
| 10 | WODRQJ | Date - Requested | Date | Generic Edit | 6 | 0 | |
| 11 | WOLITM | 2nd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 12 | WOAITM | 3rd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 13 | WODSC1 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 14 | WOUOM8 | Unit of Measure - Production | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 15 | WOSRP1 | Sales Rpt 01 - Product Family | String | UDC (41 S1) | 3 | 0 | Allow NULL? |
| 16 | WOSRP2 | Sales Rpt 02 - Family Section | String | UDC (41 S2) | 3 | 0 | Allow NULL? |
| 17 | WOSRP3 | Sales Category Code 3 | String | UDC (41 S3) | 3 | 0 | Allow NULL? |
| 18 | WOSRP4 | Sales Category Code 4 | String | UDC (41 S4) | 3 | 0 | Allow NULL? |
| 19 | WOSRP5 | Sales Category Code 5 | String | UDC (41 S5) | 3 | 0 | Allow NULL? |
| 20 | WOSRP6 | Sales Rpt 06 - Product Line (Revenue) | String | UDC (41 06) | 6 | 0 | Allow NULL? |
| 21 | WOSRP7 | Category Code 7 | String | UDC (41 07) | 6 | 0 | Allow NULL? |
| 22 | WOSRP8 | Sales Rpt 08 - Product Discount Group | String | UDC (41 08) | 6 | 0 | Allow NULL? |
| 23 | WOSRP9 | Category Code 9 | String | UDC (41 09) | 6 | 0 | Allow NULL? |
| 24 | WOSRP0 | Category Code 10 | String | UDC (41 10) | 6 | 0 | Allow NULL? |
| 25 | WOPRP1 | Commodity Class | String | UDC (41 P1) | 3 | 0 | Allow NULL? |
| 26 | WOPRP2 | Commodity Sub Class | String | UDC (41 P2) | 3 | 0 | Allow NULL? |
| 27 | WOPRP3 | Supplier Rebate Code | String | UDC (41 P3) | 3 | 0 | Allow NULL? |
| 28 | WOPRP4 | Master Planning Family | String | UDC (41 P4) | 3 | 0 | Allow NULL? |
| 29 | WOPRP5 | Purchasing Category Code 5 | String | UDC (41 P5) | 3 | 0 | Allow NULL? |
| 30 | WOPRP6 | Group - Item Dimension | String | UDC (41 01) | 6 | 0 | Allow NULL? |
| 31 | WOPRP7 | Group - Warehouse Process 1 | String | UDC (41 02) | 6 | 0 | Allow NULL? |
| 32 | WOPRP8 | Group - Warehouse Process 2 | String | UDC (41 02) | 6 | 0 | Allow NULL? |
| 33 | WOPRP9 | Group - Warehouse Process 3 | String | UDC (41 02) | 6 | 0 | Allow NULL? |
| 34 | WOPRP0 | Item Pool | String | UDC (41 05) | 6 | 0 | Allow NULL? |
| 35 | WOCKAV | Check Availability Y/N | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 36 | WOUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 37 | WOPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 38 | WOJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 39 | WOUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 40 | WOUPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
