| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | N0SY | Product Code | String | UDC (98 SY) | 4 | 0 | Allow NULL? |
| 2 | N0MMCU | Branch | String | Generic Edit | 12 | 0 | Allow NULL? |
| 3 | N0SRP1 | Sales Rpt 01 - Product Family | String | UDC (41 S1) | 3 | 0 | Allow NULL? |
| 4 | N0SRP2 | Sales Rpt 02 - Family Section | String | UDC (41 S2) | 3 | 0 | Allow NULL? |
| 5 | N0SRP3 | Sales Category Code 3 | String | UDC (41 S3) | 3 | 0 | Allow NULL? |
| 6 | N0SRP4 | Sales Category Code 4 | String | UDC (41 S4) | 3 | 0 | Allow NULL? |
| 7 | N0SRP5 | Sales Category Code 5 | String | UDC (41 S5) | 3 | 0 | Allow NULL? |
| 8 | N0SRP6 | Sales Rpt 06 - Product Line (Revenue) | String | UDC (41 06) | 6 | 0 | Allow NULL? |
| 9 | N0SRP7 | Category Code 7 | String | UDC (41 07) | 6 | 0 | Allow NULL? |
| 10 | N0SRP8 | Sales Rpt 08 - Product Discount Group | String | UDC (41 08) | 6 | 0 | Allow NULL? |
| 11 | N0SRP9 | Category Code 9 | String | UDC (41 09) | 6 | 0 | Allow NULL? |
| 12 | N0SRP0 | Category Code 10 | String | UDC (41 10) | 6 | 0 | Allow NULL? |
| 13 | N0PRP1 | Commodity Class | String | UDC (41 P1) | 3 | 0 | Allow NULL? |
| 14 | N0PRP2 | Commodity Sub Class | String | UDC (41 P2) | 3 | 0 | Allow NULL? |
| 15 | N0PRP3 | Supplier Rebate Code | String | UDC (41 P3) | 3 | 0 | Allow NULL? |
| 16 | N0PRP4 | Master Planning Family | String | UDC (41 P4) | 3 | 0 | Allow NULL? |
| 17 | N0PRP5 | Purchasing Category Code 5 | String | UDC (41 P5) | 3 | 0 | Allow NULL? |
| 18 | N0PRP6 | Group - Item Dimension | String | UDC (41 01) | 6 | 0 | Allow NULL? |
| 19 | N0PRP7 | Group - Warehouse Process 1 | String | UDC (41 02) | 6 | 0 | Allow NULL? |
| 20 | N0PRP8 | Group - Warehouse Process 2 | String | UDC (41 02) | 6 | 0 | Allow NULL? |
| 21 | N0PRP9 | Group - Warehouse Process 3 | String | UDC (41 02) | 6 | 0 | Allow NULL? |
| 22 | N0PRP0 | Item Pool | String | UDC (41 05) | 6 | 0 | Allow NULL? |
| 23 | N0CARP | Preferred Carrier - Purchasing | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 24 | N0CARS | Carrier Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 25 | N0SHCN | Shipping Conditions Code | String | UDC (41 C) | 3 | 0 | Allow NULL? |
| 26 | N0SHCM | Shipping Commodity Class | String | UDC (41 E) | 3 | 0 | Allow NULL? |
| 27 | N0CYCL | Cycle Count Category | String | UDC (41 8) | 3 | 0 | Allow NULL? |
| 28 | N0RP01 | Division | String | UDC (00 01) | 3 | 0 | Allow NULL? |
| 29 | N0RP02 | Region | String | UDC (00 02) | 3 | 0 | Allow NULL? |
| 30 | N0RP03 | Group | String | UDC (00 03) | 3 | 0 | Allow NULL? |
| 31 | N0RP04 | Branch Office | String | UDC (00 04) | 3 | 0 | Allow NULL? |
| 32 | N0RP05 | Department Type | String | UDC (00 05) | 3 | 0 | Allow NULL? |
| 33 | N0RP06 | Person Responsible | String | UDC (00 06) | 3 | 0 | Allow NULL? |
| 34 | N0RP07 | Line of Business | String | UDC (00 07) | 3 | 0 | Allow NULL? |
| 35 | N0RP08 | Category Code - Business Unit 08 | String | UDC (00 08) | 3 | 0 | Allow NULL? |
| 36 | N0RP09 | Category Code - Business Unit 09 | String | UDC (00 09) | 3 | 0 | Allow NULL? |
| 37 | N0RP10 | Category Code - Business Unit 10 | String | UDC (00 10) | 3 | 0 | Allow NULL? |
| 38 | N0RP11 | Category Code - Business Unit 11 | String | UDC (00 11) | 3 | 0 | Allow NULL? |
| 39 | N0RP12 | Category Code - Business Unit 12 | String | UDC (00 12) | 3 | 0 | Allow NULL? |
| 40 | N0RP13 | Category Code - Business Unit 13 | String | UDC (00 13) | 3 | 0 | Allow NULL? |
| 41 | N0RP14 | Category Code - Business Unit 14 | String | UDC (00 14) | 3 | 0 | Allow NULL? |
| 42 | N0RP15 | Category Code - Business Unit 15 | String | UDC (00 15) | 3 | 0 | Allow NULL? |
| 43 | N0RP16 | Category Code - Business Unit 16 | String | UDC (00 16) | 3 | 0 | Allow NULL? |
| 44 | N0RP17 | Category Code - Business Unit 17 | String | UDC (00 17) | 3 | 0 | Allow NULL? |
| 45 | N0RP18 | Category Code - Business Unit 18 | String | UDC (00 18) | 3 | 0 | Allow NULL? |
| 46 | N0RP19 | Category Code - Business Unit 19 | String | UDC (00 19) | 3 | 0 | Allow NULL? |
| 47 | N0RP20 | Category Code - Business Unit 20 | String | UDC (00 20) | 3 | 0 | Allow NULL? |
| 48 | N0RP21 | Category Code - Business Unit 21 | String | UDC (00 21) | 10 | 0 | Allow NULL? |
| 49 | N0RP22 | Category Code - Business Unit 22 | String | UDC (00 22) | 10 | 0 | Allow NULL? |
| 50 | N0RP23 | Category Code - Business Unit 23 | String | UDC (00 23) | 10 | 0 | Allow NULL? |
| 51 | N0RP24 | Category Code - Business Unit 24 | String | UDC (00 24) | 10 | 0 | Allow NULL? |
| 52 | N0RP25 | Category Code - Business Unit 25 | String | UDC (00 25) | 10 | 0 | Allow NULL? |
| 53 | N0RP26 | Category Code - Business Unit 26 | String | UDC (00 26) | 10 | 0 | Allow NULL? |
| 54 | N0RP27 | Category Code - Business Unit 27 | String | UDC (00 27) | 10 | 0 | Allow NULL? |
| 55 | N0RP28 | Category Code - Business Unit 28 | String | UDC (00 28) | 10 | 0 | Allow NULL? |
| 56 | N0RP29 | Category Code - Business Unit 29 | String | UDC (00 29) | 10 | 0 | Allow NULL? |
| 57 | N0RP30 | Category Code - Business Unit 30 | String | UDC (00 30) | 10 | 0 | Allow NULL? |
| 58 | N0USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 59 | N0PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 60 | N0JOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 61 | N0UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 62 | N0TICU | Batch Time | Numeric | Generic Edit | 6 | 0 | Allow NULL? |