| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | WRLLX | Low Level Code | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 2 | WRINT01 | Integer01 - EnterpriseOne | Integer | Generic Edit | 4 | 0 | Allow NULL? |
| 3 | WRMMCU | Branch | String | Generic Edit | 12 | 0 | Allow NULL? |
| 4 | WRITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | WRDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 6 | WRLOCN | Location | String | Generic Edit | 20 | 0 | Allow NULL? |
| 7 | WRLOTN | Lot/Serial Number | String | Generic Edit | 30 | 0 | Allow NULL? |
| 8 | WRLOCF | Location - From | String | Generic Edit | 20 | 0 | Allow NULL? |
| 9 | WRLOTF | Lot - From | String | Generic Edit | 30 | 0 | Allow NULL? |
| 10 | WRDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 11 | WRLITM | 2nd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 12 | WRAITM | 3rd Item Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 13 | WRPART | Parent Child Relationship | Character | UDC (H01 PA) | 1 | 0 | Allow NULL? |
| 14 | WRUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 15 | WRGLPT | Category - G/L | String | UDC (41 9) | 4 | 0 | Allow NULL? |
| 16 | WRLEDG | Cost Method | String | UDC (40 CM) | 2 | 0 | Allow NULL? |
| 17 | WRSRST | Status Code W.O. | String | UDC (00 SS) | 2 | 0 | Allow NULL? |
| 18 | WRPPFG | Variance Flag | Character | UDC (H00 PP) | 1 | 0 | Allow NULL? |
| 19 | WREXPI | Explode Item (1/0) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 20 | WREV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | WRSTKT | Stocking Type | Character | UDC (41 I) | 1 | 0 | Allow NULL? |
| 22 | WRUORG | Units - Order/Transaction Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 23 | WRCLEV | Level - Inventory Cost | Character | UDC (H40 CL) | 1 | 0 | Allow NULL? |
| 24 | WRSOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 25 | WRSOCN | Units - Quantity Canceled/Scrapped | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 26 | WRLGWK | Cost Method Work Field | String | UDC (40 CM) | 2 | 0 | Allow NULL? |
| 27 | WRDOCZ | Document (Order # Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 28 | WRERRC | Error Code | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 29 | WRUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 30 | WRPEID | Process ID | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 31 | WRJOBS | Job Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |