| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | WKC9ITM | Short Item Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | WKEV01 | J.D. EnterpriseOne Event Point 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 3 | WKSRP1 | Sales Rpt 01 - Product Family | String | UDC (41 S1) | 3 | 0 | Allow NULL? |
| 4 | WKSRP2 | Sales Rpt 02 - Family Section | String | UDC (41 S2) | 3 | 0 | Allow NULL? |
| 5 | WKSRP3 | Sales Category Code 3 | String | UDC (41 S3) | 3 | 0 | Allow NULL? |
| 6 | WKSRP4 | Sales Category Code 4 | String | UDC (41 S4) | 3 | 0 | Allow NULL? |
| 7 | WKSRP5 | Sales Category Code 5 | String | UDC (41 S5) | 3 | 0 | Allow NULL? |
| 8 | WKSRP6 | Sales Rpt 06 - Product Line (Revenue) | String | UDC (41 06) | 6 | 0 | Allow NULL? |
| 9 | WKSRP7 | Category Code 7 | String | UDC (41 07) | 6 | 0 | Allow NULL? |
| 10 | WKSRP8 | Sales Rpt 08 - Product Discount Group | String | UDC (41 08) | 6 | 0 | Allow NULL? |
| 11 | WKSRP9 | Category Code 9 | String | UDC (41 09) | 6 | 0 | Allow NULL? |
| 12 | WKSRP0 | Category Code 10 | String | UDC (41 10) | 6 | 0 | Allow NULL? |
| 13 | WKCARS | Carrier Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 14 | WKCARP | Preferred Carrier - Purchasing | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 15 | WKSHCN | Shipping Conditions Code | String | UDC (41 C) | 3 | 0 | Allow NULL? |
| 16 | WKSHCM | Shipping Commodity Class | String | UDC (41 E) | 3 | 0 | Allow NULL? |
| 17 | WKCYCL | Cycle Count Category | String | UDC (41 8) | 3 | 0 | Allow NULL? |
| 18 | WKPRP1 | Commodity Class | String | UDC (41 P1) | 3 | 0 | Allow NULL? |
| 19 | WKPRP2 | Commodity Sub Class | String | UDC (41 P2) | 3 | 0 | Allow NULL? |
| 20 | WKPRP3 | Supplier Rebate Code | String | UDC (41 P3) | 3 | 0 | Allow NULL? |
| 21 | WKPRP4 | Master Planning Family | String | UDC (41 P4) | 3 | 0 | Allow NULL? |
| 22 | WKPRP5 | Purchasing Category Code 5 | String | UDC (41 P5) | 3 | 0 | Allow NULL? |
| 23 | WKPRP6 | Group - Item Dimension | String | UDC (41 01) | 6 | 0 | Allow NULL? |
| 24 | WKPRP7 | Group - Warehouse Process 1 | String | UDC (41 02) | 6 | 0 | Allow NULL? |
| 25 | WKPRP8 | Group - Warehouse Process 2 | String | UDC (41 02) | 6 | 0 | Allow NULL? |
| 26 | WKPRP9 | Group - Warehouse Process 3 | String | UDC (41 02) | 6 | 0 | Allow NULL? |
| 27 | WKPRP0 | Item Pool | String | UDC (41 05) | 6 | 0 | Allow NULL? |