| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
|---|
| 1 | ADADUKID | Assessment Donation ID | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 2 | ADSTDADNM | Standard Assessmens/Donation Name | String | Generic Edit | 12 | 0 | Allow NULL? |
| 3 | ADASSDDESC | Assessment/Donation Description | String | Generic Edit | 30 | 0 | Allow NULL? |
| 4 | ADADJTYPE | Type | String | UDC (43C AT) | 3 | 0 | Allow NULL? |
| 5 | ADADEFFDT | Assessment/Donation Effective Date | JDE UTime | Generic Edit | 11 | 0 | |
| 6 | ADADEXDT | Assessment/Donation Expire Date | JDE UTime | Generic Edit | 11 | 0 | |
| 7 | ADADPER | Assessment/Donation Percent | Numeric | Generic Edit | 7 | 4 | Allow NULL? |
| 8 | ADCNTRTGN | Gross or Net | String | UDC (43C GN) | 3 | 0 | Allow NULL? |
| 9 | ADCAMTPER | Amount Per | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 10 | ADCNTRTUOM | Amount per UOM | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 11 | ADCNTRTAMT | Flat Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 12 | ADADCRDC | Assessment/Donation Currency Code | String | Generic Edit | 3 | 0 | Allow NULL? |
| 13 | ADADCOMM | Assessment/Donation Comment | String | Generic Edit | 256 | 0 | Allow NULL? |
| 14 | ADANI | Account Number - Input (Mode Unknown) | String | Generic Edit | 29 | 0 | Allow NULL? |
| 15 | ADURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 16 | ADURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 17 | ADURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 18 | ADURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 19 | ADURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 20 | ADTORG | Transaction Originator | String | Generic Edit | 10 | 0 | Allow NULL? |
| 21 | ADUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 22 | ADPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 23 | ADJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 24 | ADUUPMJ | Universal Date Updated | JDE UTime | Generic Edit | 11 | 0 | |
