| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | CHCUMID | CUM ID | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 2 | CHCREATEDJ | Date - Create | Date | Generic Edit | 6 | 0 | |
| 3 | CHCREATETM | Create Time | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 4 | CHMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 5 | CHAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 6 | CHCITM | Item Number - Customer/Supplier | String | Generic Edit | 25 | 0 | Allow NULL? |
| 7 | CHSHAN | Address Number - Ship To | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | CHCSTPO | Customer PO | String | Generic Edit | 30 | 0 | Allow NULL? |
| 9 | CHCUMUV1 | CUM User Field Value 1 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 10 | CHCUMUV2 | CUM User Field Value 2 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 11 | CHCUMUV3 | CUM User Field Value 3 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 12 | CHCUMUT1 | CUM User Field Type 1 | String | UDC (40R UF) | 3 | 0 | Allow NULL? |
| 13 | CHCUMUT2 | CUM User Field Type 2 | String | UDC (40R UF) | 3 | 0 | Allow NULL? |
| 14 | CHCUMUT3 | CUM User Field Type 3 | String | UDC (40R UF) | 3 | 0 | Allow NULL? |
| 15 | CHCUMTYPE | CUM Type | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 16 | CHCUMATID | CUM Attachment ID | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 17 | CHCUMADJ | Code - CUM Adjustment | String | UDC (40R CA) | 2 | 0 | Allow NULL? |
| 18 | CHSHPN | Shipment Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 19 | CHCUMREFNO | CUM Reference Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 20 | CHCUMS | CUM Quantity Shipped | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 21 | CHCUMSADJ | CUM Shipped Adjustment | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 22 | CHADDJ | Date - Actual Ship Date | Date | Generic Edit | 6 | 0 | |
| 23 | CHADTM | Actual Shipment Time | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 24 | CHCCUMRQY | Customer CUM Received Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 25 | CHCCUMRDJ | Date - Customer CUM Received | Date | Generic Edit | 6 | 0 | |
| 26 | CHCCUMRTM | Customer CUM Received Time | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 27 | CHCRQQYFM | CUM Required Quantity - Firm | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 28 | CHCRQQYPN | CUM Required Quantity - Plan | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 29 | CHCRQQYPS | CUM Required Quantity - Production Seq | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 30 | CHCRQSDJFM | Date - Firm CUM Required Start | Date | Generic Edit | 6 | 0 | |
| 31 | CHCRQSTMFM | CUM Required Start Time - Firm | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 32 | CHCRQEDJFM | Date - Firm CUM Required End | Date | Generic Edit | 6 | 0 | |
| 33 | CHCRQETMFM | CUM Required End Time - Firm | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 34 | CHCRQSDJPN | Date - Plan CUM Required Start | Date | Generic Edit | 6 | 0 | |
| 35 | CHCRQSTMPN | CUM Required Start Time - Plan | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 36 | CHCRQEDJPN | Date - Plan CUM Required End | Date | Generic Edit | 6 | 0 | |
| 37 | CHCRQETMPN | CUM Required End Time - Plan | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 38 | CHCRQSDJPS | Date - Prod Seq CUM Required Start | Date | Generic Edit | 6 | 0 | |
| 39 | CHCRQSTMPS | CUM Required Start Time - Prod Seq | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 40 | CHCRQEDJPS | Date - Prod Seq CUM Required End | Date | Generic Edit | 6 | 0 | |
| 41 | CHCRQETMPS | CUM Required End Time - Prod Seq | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 42 | CHCCUMSQY | Customer CUM Shipped Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 43 | CHCCUMSDJ | Date - Customer CUM Shipped | Date | Generic Edit | 6 | 0 | |
| 44 | CHCCUMSTM | Customer CUM Shipped Time | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 45 | CHCCUMSUOM | Customer CUM Shipped UOM | String | Generic Edit | 2 | 0 | Allow NULL? |
| 46 | CHFBCUMQY | Fabrication CUM Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 47 | CHFBCUMSDJ | Date - Fabrication CUM Start | Date | Generic Edit | 6 | 0 | |
| 48 | CHFBCUMEDJ | Date - Fabrication CUM End | Date | Generic Edit | 6 | 0 | |
| 49 | CHMTCUMQY | Material CUM Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 50 | CHMTCUMSDJ | Date - Material CUM Start | Date | Generic Edit | 6 | 0 | |
| 51 | CHMTCUMEDJ | Date - Material CUM End | Date | Generic Edit | 6 | 0 | |
| 52 | CHCUMRBDJ | Date - CUM Rollback | Date | Generic Edit | 6 | 0 | |
| 53 | CHCUMRBTM | CUM Rollback Time | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 54 | CHURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 55 | CHURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 56 | CHURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 57 | CHURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 58 | CHURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 59 | CHUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 60 | CHPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 61 | CHJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 62 | CHUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 63 | CHTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |