| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | ZCTCID | Transaction ID | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 2 | ZCPEID | Process ID | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 3 | ZCCTID | Computer ID | String | Generic Edit | 15 | 0 | Allow NULL? |
| 4 | ZCJOBS | Job Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 5 | ZCXLIN | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 6 | ZCDOCO | Document (Order No Invoice etc.) | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 7 | ZCDCTO | Order Type | String | UDC (00 DT) | 2 | 0 | Allow NULL? |
| 8 | ZCKCOO | Order Company (Order Number) | String | Generic Edit | 5 | 0 | Allow NULL? |
| 9 | ZCLNID | Line Number | Numeric | Generic Edit | 6 | 3 | Allow NULL? |
| 10 | ZCSEQ | Sequence Number | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 11 | ZCEDTY | Type Record | Character | UDC (00 RD) | 1 | 0 | Allow NULL? |
| 12 | ZCITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 13 | ZCMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 14 | ZCUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 15 | ZCPDDJ | Date - Scheduled Pick | Date | Generic Edit | 6 | 0 | |
| 16 | ZCSOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 17 | ZCSOBK | Units - Qty Backordered/Held | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 18 | ZCSOCN | Units - Quantity Canceled/Scrapped | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 19 | ZCLOCN | Location | String | Generic Edit | 20 | 0 | Allow NULL? |
| 20 | ZCLOTN | Lot/Serial Number | String | Generic Edit | 30 | 0 | Allow NULL? |
| 21 | ZCSHCM | Shipping Commodity Class | String | UDC (41 E) | 3 | 0 | Allow NULL? |
| 22 | ZCSHCN | Shipping Conditions Code | String | UDC (41 C) | 3 | 0 | Allow NULL? |
| 23 | ZCSRP1 | Sales Catalog Section | String | UDC (41 S1) | 3 | 0 | Allow NULL? |
| 24 | ZCSRP2 | Sub Section | String | UDC (41 S2) | 3 | 0 | Allow NULL? |
| 25 | ZCSRP3 | Sales Category Code 3 | String | UDC (41 S3) | 3 | 0 | Allow NULL? |
| 26 | ZCSRP4 | Sales Category Code 4 | String | UDC (41 S4) | 3 | 0 | Allow NULL? |
| 27 | ZCSRP5 | Sales Category Code 5 | String | UDC (41 S5) | 3 | 0 | Allow NULL? |
| 28 | ZCPRP1 | Commodity Class | String | UDC (41 P1) | 3 | 0 | Allow NULL? |
| 29 | ZCPRP2 | Commodity Sub Class | String | UDC (41 P2) | 3 | 0 | Allow NULL? |
| 30 | ZCPRP3 | Supplier Rebate Code | String | UDC (41 P3) | 3 | 0 | Allow NULL? |
| 31 | ZCPRP4 | Master Planning Family | String | UDC (41 P4) | 3 | 0 | Allow NULL? |
| 32 | ZCPRP5 | Purchasing Category Code 5 | String | UDC (41 P5) | 3 | 0 | Allow NULL? |
| 33 | ZCRPRC | Reprice (Basket Price) Category | String | UDC (40 PI) | 8 | 0 | Allow NULL? |
| 34 | ZCORPR | Order Reprice Category | String | UDC (40 PI) | 8 | 0 | Allow NULL? |
| 35 | ZCVEND | Primary / Last Supplier Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 36 | ZCBUYR | Buyer Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 37 | ZCCARS | Carrier Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 38 | ZCINMG | Print Message | String | UDC (40 PM) | 10 | 0 | Allow NULL? |
| 39 | ZCPRGR | Item Price Group | String | UDC (40 PI) | 8 | 0 | Allow NULL? |
| 40 | ZCSTKT | Stocking Type | Character | UDC (41 I) | 1 | 0 | Allow NULL? |
| 41 | ZCTAX1 | Sales Taxable (Y/N) | Character | UDC (H00 TV) | 1 | 0 | Allow NULL? |
| 42 | ZCLNTY | Line Type | String | Generic Edit | 2 | 0 | Allow NULL? |
| 43 | ZCMOT | Mode of Transport | String | UDC (00 TM) | 3 | 0 | Allow NULL? |
| 44 | ZCROUT | Route Code | String | UDC (42 RT) | 3 | 0 | Allow NULL? |
| 45 | ZCUNCS | Amount - Unit Cost | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 46 | ZCCOMM | Committed (H/S) | Character | UDC (H42 CP) | 1 | 0 | Allow NULL? |
| 47 | ZCRSDJ | Date - Promised Delivery | Date | Generic Edit | 6 | 0 | |
| 48 | ZCFRGD | From Grade | String | UDC (40 LG) | 3 | 0 | Allow NULL? |
| 49 | ZCTHGD | Thru Grade | String | UDC (40 LG) | 3 | 0 | Allow NULL? |
| 50 | ZCFRMP | From Potency | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 51 | ZCTHRP | Thru Potency | Numeric | Generic Edit | 7 | 3 | Allow NULL? |
| 52 | ZCCPQS | Quantity Shipped Variance | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 53 | ZCCPBK | Qty Backordered/Held Variance | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 54 | ZCCPCN | Quantity Canceled/Scrapped Variance | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 55 | ZCEDCK | Check Expiration Date | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 56 | ZCSBCK | Check Sell By Date | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 57 | ZCCMDM | Commitment Date Method | Character | UDC (H40 CD) | 1 | 0 | Allow NULL? |
| 58 | ZCBBCK | Check Best Before Date | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 59 | ZCSQOR | Units - Secondary Quantity Ordered | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 60 | ZCSONE | Units - Future Quantity Committed | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 61 | ZCGENSTR | Generic String Field Value | String | Generic Edit | 30 | 0 | Allow NULL? |
| 62 | ZCPPDJ | Date - Promised Shipment | Date | Generic Edit | 6 | 0 | |
| 63 | ZCALLOC | Allocation Process Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
