| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | WFUKID | Unique Key ID (Internal) | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 2 | WFJOBS | Job Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | WFMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 4 | WFITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | WFLITM | 2nd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 6 | WFAITM | 3rd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 7 | WFDSC1 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 8 | WFDSC2 | Description - Line 2 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 9 | WFLOCN | Location | String | Generic Edit | 20 | 0 | Allow NULL? |
| 10 | WFLOTN | Lot/Serial Number | String | Generic Edit | 30 | 0 | Allow NULL? |
| 11 | WFCHAR | CHAR | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 12 | WFLPNU | License Plate Number | String | Generic Edit | 40 | 0 | Allow NULL? |
| 13 | WFUOM1 | Unit of Measure - Primary | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 14 | WFPQOH | Quantity on Hand - Primary units | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 15 | WFDQTY | Dual Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 16 | WFUOM2 | Unit of Measure - Secondary | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 17 | WFUORG | Units - Order/Transaction Quantity | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | WFUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 19 | WFTDQTY | Transaction Dual Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 20 | WFUOM10 | Transaction Unit of Measure - Secondary | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 21 | WFLRCJ | Date - Last Receipt (Julian) | Date | Generic Edit | 6 | 0 | |
| 22 | WFLOTS | Lot Status Code | Character | UDC (41 L) | 1 | 0 | Allow NULL? |
| 23 | WFMMEJ | Date - Lot Expiration | Date | Generic Edit | 6 | 0 | |
| 24 | WFDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 25 | WFKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 26 | WFDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 27 | WFLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 28 | WFNLIN | Number of Lines | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 29 | WFSFXO | Order Suffix | String | Generic Edit | 3 | 0 | Allow NULL? |
| 30 | WFAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 31 | WFSHAN | Address Number - Ship To | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 32 | WFSTKT | Stocking Type | Character | UDC (41 I) | 1 | 0 | Allow NULL? |
| 33 | WFLNTY | Line Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 34 | WFLCOD | Code - Location Tax Status | String | UDC (46 LT) | 2 | 0 | Allow NULL? |
| 35 | WFPACK | Code - Packing | String | UDC (46 PK) | 4 | 0 | Allow NULL? |
| 36 | WFRPCK | Repack (Y/N) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 37 | WFRCDJ | Date - Received | Date | Generic Edit | 6 | 0 | |
| 38 | WFDRQJ | Date - Requested | Date | Generic Edit | 6 | 0 | |
| 39 | WFTRDJ | Date - Order/Transaction | Date | Generic Edit | 6 | 0 | |
| 40 | WFLTTR | Status Code - Last | String | UDC (40 AT) | 3 | 0 | Allow NULL? |
| 41 | WFPRP6 | Group - Item Dimension | String | UDC (41 01) | 6 | 0 | Allow NULL? |
| 42 | WFTFLA | Standard Unit of Measure Conversion | String | UDC (H40 ST) | 2 | 0 | Allow NULL? |
| 43 | WFDUAL | Dual Unit Of Measure Item | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 44 | WFDPPO | Dual Picking Process Option | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 45 | WFPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 46 | WFFRTO | From/To | Character | Generic Edit | 1 | 0 | Allow NULL? |
