| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | DNDMCT | Agreement Number - Distribution | String | Generic Edit | 12 | 0 | Allow NULL? |
| 2 | DNDMCS | Agreement Supplement - Distribution | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 3 | DNDL01 | Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 4 | DNDL02 | Description 02 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 5 | DNDL03 | Description 03 | String | Generic Edit | 30 | 0 | Allow NULL? |
| 6 | DNMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 7 | DNNWRN | New/Renewal Flag | Character | UDC (38 NR) | 1 | 0 | Allow NULL? |
| 8 | DNAGRS | Amendments (Y/N) - Agreements | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 9 | DNCMAN | Address Number - Contract Manager | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 10 | DNCADM | Address Number - Contract Administrator | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 11 | DNPANM | Partner Agreement Number | String | Generic Edit | 25 | 0 | Allow NULL? |
| 12 | DNCNTD | Date - Signed | Date | Generic Edit | 6 | 0 | |
| 13 | DNDMTC | Agreement Type - Distribution | Character | UDC (38 CV) | 1 | 0 | Allow NULL? |
| 14 | DNDMPC | Agreement Purpose - Distribution | String | UDC (38 CP) | 3 | 0 | Allow NULL? |
| 15 | DNDMSC | Agreement Status | Character | UDC (38 CU) | 1 | 0 | Allow NULL? |
| 16 | DNEFTJ | Date - Effective | Date | Generic Edit | 6 | 0 | |
| 17 | DNEXDJ | Date - Expired | Date | Generic Edit | 6 | 0 | |
| 18 | DNAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 19 | DNAAGM | Agreement - Associated Number | String | Generic Edit | 12 | 0 | Allow NULL? |
| 20 | DNAAGS | Agreement - Associated Supplement | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 21 | DNRAGM | Created From Agreement Number | String | Generic Edit | 12 | 0 | Allow NULL? |
| 22 | DNRAGS | Agreement - Associated Supplement | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 23 | DNCAGM | Created From Agreement Number | String | Generic Edit | 12 | 0 | Allow NULL? |
| 24 | DNCAGS | Agreement - Associated Supplement | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 25 | DNPAGM | Parent Agreement Number | String | Generic Edit | 12 | 0 | Allow NULL? |
| 26 | DNPAGS | Agreement - Associated Supplement | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 27 | DNZD01 | Category Code - Agreements 01 | String | UDC (38 R1) | 3 | 0 | Allow NULL? |
| 28 | DNZD02 | Category Code - Agreements 02 | String | UDC (38 R2) | 3 | 0 | Allow NULL? |
| 29 | DNZD03 | Category Code - Agreements 03 | String | UDC (38 R3) | 3 | 0 | Allow NULL? |
| 30 | DNZD04 | Category Code - Agreements 04 | String | UDC (38 R4) | 3 | 0 | Allow NULL? |
| 31 | DNZD05 | Category Code - Agreements 05 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 32 | DNZD06 | Category Code - Agreements 06 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 33 | DNZD07 | Category Code - Agreements 07 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 34 | DNZD08 | Category Code - Agreements 08 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 35 | DNZD09 | Category Code - Agreements 09 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 36 | DNZD10 | Category Code - Agreements 10 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 37 | DNQEDT | Enforce Quantity Edits | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 38 | DNCAND | Date - Cancellation of Contract | Date | Generic Edit | 6 | 0 | |
| 39 | DNCANR | Cancellation Reason Code | String | UDC (38 CC) | 3 | 0 | Allow NULL? |
| 40 | DNUPGL | Update General Ledger | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 41 | DNPRAS | Price at Ambient/Standard/Weight (A S W) | Character | UDC (38 PR) | 1 | 0 | Allow NULL? |
| 42 | DNCMOO | Commingled Other Owner | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 43 | DNCNQY | Agreement Quantity Type | Character | UDC (38 CN) | 1 | 0 | Allow NULL? |
| 44 | DNTV01 | Sales Detail Line Origin | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 45 | DNTV02 | Future Use 02 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 46 | DNTV03 | Future Use 03 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 47 | DNURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 48 | DNURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 49 | DNURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 50 | DNURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 51 | DNURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 52 | DNUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 53 | DNPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 54 | DNJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 55 | DNUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 56 | DNTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 57 | DNRPQT | Percentage - Quantity Tolerance | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 58 | DNQED3 | Balance Quantity Edit Control | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 59 | DNQED2 | Transaction Quantity Edit Control | Character | Generic Edit | 1 | 0 | Allow NULL? |
