| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | DFDMCT | Agreement Number - Distribution | String | Generic Edit | 12 | 0 | Allow NULL? |
| 2 | DFDMCS | Agreement Supplement - Distribution | Numeric | Generic Edit | 3 | 0 | Allow NULL? |
| 3 | DFCNQY | Agreement Quantity Type | Character | UDC (38 CN) | 1 | 0 | Allow NULL? |
| 4 | DFDTO | Due To | Character | UDC (38 DT) | 1 | 0 | Allow NULL? |
| 5 | DFDES | Destination | String | Generic Edit | 12 | 0 | Allow NULL? |
| 6 | DFDESY | Destination Type | String | UDC (38 DY) | 2 | 0 | Allow NULL? |
| 7 | DFITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | DFSEQ | Sequence Number | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 9 | DFCNQT | Contract Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 10 | DFAA | Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 11 | DFUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 12 | DFMINQ | Quantity - Minimum Transaction | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 13 | DFMAXQ | Quantity - Maximum Capacity | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 14 | DFEFTJ | Date - Effective | Date | Generic Edit | 6 | 0 | |
| 15 | DFEXDJ | Date - Expired | Date | Generic Edit | 6 | 0 | |
| 16 | DFUPRC | Amount - Price per Unit | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 17 | DFASN | Price and Adjustment Schedule | String | UDC (40 AS) | 8 | 0 | Allow NULL? |
| 18 | DFPASN | Penalty and Adjustment Schedule | String | UDC (40 AS) | 8 | 0 | Allow NULL? |
| 19 | DFMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 20 | DFCRCD | Currency Code - From | String | Generic Edit | 3 | 0 | Allow NULL? |
| 21 | DFTV01 | Sales Detail Line Origin | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 22 | DFTV02 | Future Use 02 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 23 | DFTV03 | Future Use 03 | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | DFQTY1 | Future Use Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 25 | DFTVUM | Future Use Unit of Measure | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 26 | DFURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 27 | DFURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 28 | DFURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 29 | DFURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 30 | DFURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 31 | DFUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 32 | DFPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 33 | DFJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 34 | DFUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 35 | DFTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 36 | DFRPQT | Percentage - Quantity Tolerance | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 37 | DFQEDT | Enforce Quantity Edits | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 38 | DFQED3 | Balance Quantity Edit Control | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 39 | DFQED2 | Transaction Quantity Edit Control | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 40 | DFPDP5 | Reporting Code 5 - Purchasing | String | UDC (41 P5) | 3 | 0 | Allow NULL? |
