| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | CHCNTRTID | Contract ID | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 2 | CHCNTRTTYP | Contract Type | String | Generic Edit (43C CT) | 10 | 0 | Allow NULL? |
| 3 | CHCNTRTNM | Contract Name | String | Generic Edit | 30 | 0 | Allow NULL? |
| 4 | CHCNTRTCD | Contract Code | String | Generic Edit | 12 | 0 | Allow NULL? |
| 5 | CHCNTRTSTS | Contract Status | String | UDC (43C CS) | 3 | 0 | Allow NULL? |
| 6 | CHCNTRAMT | Contract Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 7 | CHMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 8 | CHCNTRTENT | Contracting Entity | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 9 | CHCNTRCRDC | Contract Currency Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 10 | CHPTC | Payment Terms Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 11 | CHCNTRTMGR | Conract Manager | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 12 | CHCNTRTPT | Price Type | String | UDC (43C PT) | 3 | 0 | Allow NULL? |
| 13 | CHCNTRTDF | Delivery Form | String | UDC (43C DF) | 3 | 0 | Allow NULL? |
| 14 | CHOWNERSP | Ownership | String | UDC (43C OS) | 3 | 0 | Allow NULL? |
| 15 | CHCNTRTSD | Start Date | JDE UTime | Generic Edit | 11 | 0 | |
| 16 | CHCNTRTED | End Date | JDE UTime | Generic Edit | 11 | 0 | |
| 17 | CHRNWTYPE | Renew Type | String | UDC (43C RT) | 3 | 0 | Allow NULL? |
| 18 | CHRNWEDTE | Renewable End Date | JDE UTime | Generic Edit | 11 | 0 | |
| 19 | CHCNTRD | Review Date | JDE UTime | Generic Edit | 11 | 0 | |
| 20 | CHRNWTRM | Renew Term | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 21 | CHRNWUOM | Renew Period | String | UDC (43C RU) | 3 | 0 | Allow NULL? |
| 22 | CHCMDCDE | Commodity Code | String | Generic Edit | 15 | 0 | Allow NULL? |
| 23 | CHGEOCST | Geographic ID | String | UDC (40G GI) | 3 | 0 | Allow NULL? |
| 24 | CHCNTRTCOM | Contract Comment | String | Generic Edit | 255 | 0 | Allow NULL? |
| 25 | CHCNTRAB01 | Contract Address Book Number 01 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 26 | CHCNTRAB02 | Contract Address Book Number 02 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 27 | CHCNTRAB03 | Contract Address Book Number 03 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 28 | CHCNTRAB04 | Contract Address Book Number 04 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 29 | CHCNTRAB05 | Contract Address Book Number 05 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 30 | CHCNTRAB06 | Contract Address Book Number 06 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 31 | CHCNTRAB07 | Contract Address Book Number 07 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 32 | CHCNTRAB08 | Contract Address Book Number 08 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 33 | CHCNTRAB09 | Contract Address Book Number 09 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 34 | CHCNTRAB10 | Contract Address Book Number 10 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 35 | CHCNTRAB11 | Contract Address Book Number 11 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 36 | CHCNTRAB12 | Contract Address Book Number 12 | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 37 | CHCNTRT01 | Contract Code 01 | String | UDC (43C 01) | 3 | 0 | Allow NULL? |
| 38 | CHCNTRT02 | Contract Code 02 | String | UDC (43C 02) | 3 | 0 | Allow NULL? |
| 39 | CHCNTRT03 | Contract Code 03 | String | UDC (43C 03) | 3 | 0 | Allow NULL? |
| 40 | CHCNTRT04 | Contract Code 04 | String | UDC (43C 04) | 3 | 0 | Allow NULL? |
| 41 | CHCNTRT05 | Contract Code 05 | String | UDC (43C 05) | 3 | 0 | Allow NULL? |
| 42 | CHCNTRT06 | Contract Code 06 | String | UDC (43C 06) | 8 | 0 | Allow NULL? |
| 43 | CHCNTRT07 | Contract Code 07 | String | UDC (43C 07) | 8 | 0 | Allow NULL? |
| 44 | CHCNTRT08 | Contract Code 08 | String | UDC (43C 08) | 8 | 0 | Allow NULL? |
| 45 | CHCNTRT09 | Contract Code 09 | String | UDC (43C 09) | 8 | 0 | Allow NULL? |
| 46 | CHCNTRT10 | Contract Code 10 | String | UDC (43C 10) | 8 | 0 | Allow NULL? |
| 47 | CHCNTRT11 | Contract Code 11 | String | UDC (43C 11) | 10 | 0 | Allow NULL? |
| 48 | CHCNTRT12 | Contract Code 12 | String | UDC (43C 12) | 10 | 0 | Allow NULL? |
| 49 | CHCNTRT13 | Contract Code 13 | String | UDC (43C 13) | 10 | 0 | Allow NULL? |
| 50 | CHCNTRT14 | Contract Code 14 | String | UDC (43C 14) | 10 | 0 | Allow NULL? |
| 51 | CHCNTRT15 | Contract Code 15 | String | UDC (43C 15) | 10 | 0 | Allow NULL? |
| 52 | CHCNTRTDT1 | Contract Date 01 | Date | Generic Edit | 6 | 0 | |
| 53 | CHCNTRTDT2 | Contract Date 02 | Date | Generic Edit | 6 | 0 | |
| 54 | CHCNTRTDT3 | Contract Date 03 | Date | Generic Edit | 6 | 0 | |
| 55 | CHCNTRTDT4 | Contract Date 04 | Date | Generic Edit | 6 | 0 | |
| 56 | CHCNTRTDT5 | Contract Date 05 | Date | Generic Edit | 6 | 0 | |
| 57 | CHCNTRTDT6 | Contract Date 06 | Date | Generic Edit | 6 | 0 | |
| 58 | CHCNTRPT01 | Contract Property 01 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 59 | CHCNTRPT02 | Contract Property 02 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 60 | CHCNTRPT03 | Contract Property 03 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 61 | CHCNTRPT04 | Contract Property 04 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 62 | CHCNTRPT05 | Contract Property 05 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 63 | CHCNTRPT06 | Contract Property 06 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 64 | CHURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 65 | CHURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 66 | CHURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 67 | CHURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 68 | CHURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 69 | CHTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 70 | CHUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 71 | CHPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 72 | CHJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 73 | CHUUPMJ | Universal Date Updated | JDE UTime | Generic Edit | 11 | 0 | |
| 74 | CHCNTRTBYR | Contract Buyer | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
