| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | A2AN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 2 | A2CO | Company | String | Generic Edit | 5 | 0 | Allow NULL? |
| 3 | A2EFTB | Date - Beginning Effective | Date | Generic Edit | 6 | 0 | |
| 4 | A2EFTF | Effective Date Existence (1/0) | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 5 | A2AC01 | Category Code - Address Book 01 | String | UDC (01 01) | 3 | 0 | Allow NULL? |
| 6 | A2AC02 | Category Code - Address Book 02 | String | UDC (01 02) | 3 | 0 | Allow NULL? |
| 7 | A2AC03 | Category Code - Address Book 03 | String | UDC (01 03) | 3 | 0 | Allow NULL? |
| 8 | A2AC04 | Category Code - Address Book 04 | String | UDC (01 04) | 3 | 0 | Allow NULL? |
| 9 | A2AC05 | Category Code - Address Book 05 | String | UDC (01 05) | 3 | 0 | Allow NULL? |
| 10 | A2AC06 | Category Code - Address Book 06 | String | UDC (01 06) | 3 | 0 | Allow NULL? |
| 11 | A2AC07 | Category Code - Address Book 07 | String | UDC (01 07) | 3 | 0 | Allow NULL? |
| 12 | A2AC08 | Category Code - Address Book 08 | String | UDC (01 08) | 3 | 0 | Allow NULL? |
| 13 | A2AC09 | Address Book 09 - Country Type | String | UDC (01 09) | 3 | 0 | Allow NULL? |
| 14 | A2AC10 | Address Book 10 - Nature of the Trade | String | UDC (01 10) | 3 | 0 | Allow NULL? |
| 15 | A2AC11 | Address Book 11 - Discount Group | String | UDC (01 11) | 3 | 0 | Allow NULL? |
| 16 | A2AC12 | Category Code - Address Book 12 | String | UDC (01 12) | 3 | 0 | Allow NULL? |
| 17 | A2AC13 | Category Code - Address Book 13 | String | UDC (01 13) | 3 | 0 | Allow NULL? |
| 18 | A2AC14 | Category Code - Address Book 14 | String | UDC (01 14) | 3 | 0 | Allow NULL? |
| 19 | A2AC15 | Category Code - Address Book 15 | String | UDC (01 15) | 3 | 0 | Allow NULL? |
| 20 | A2AC16 | Category Code - Address Book 16 | String | UDC (01 16) | 3 | 0 | Allow NULL? |
| 21 | A2AC17 | Category Code - Address Book 17 | String | UDC (01 17) | 3 | 0 | Allow NULL? |
| 22 | A2AC18 | Category Code - Address Book 18 | String | UDC (01 18) | 3 | 0 | Allow NULL? |
| 23 | A2AC19 | Category Code - Address Book 19 | String | UDC (01 19) | 3 | 0 | Allow NULL? |
| 24 | A2AC20 | Category Code - Address Book 20 | String | UDC (01 20) | 3 | 0 | Allow NULL? |
| 25 | A2AC21 | Category Code - Address Book 21 | String | UDC (01 21) | 3 | 0 | Allow NULL? |
| 26 | A2AC22 | Category Code - Address Book 22 | String | UDC (01 22) | 3 | 0 | Allow NULL? |
| 27 | A2AC23 | Category Code - Address Book 23 | String | UDC (01 23) | 3 | 0 | Allow NULL? |
| 28 | A2AC24 | Category Code - Address Book 24 | String | UDC (01 24) | 3 | 0 | Allow NULL? |
| 29 | A2AC25 | Category Code - Address Book 25 | String | UDC (01 25) | 3 | 0 | Allow NULL? |
| 30 | A2AC26 | Category Code - Address Book 26 | String | UDC (01 26) | 3 | 0 | Allow NULL? |
| 31 | A2AC27 | Category Code - Address Book 27 | String | UDC (01 27) | 3 | 0 | Allow NULL? |
| 32 | A2AC28 | Category Code - Address Book 28 | String | UDC (01 28) | 3 | 0 | Allow NULL? |
| 33 | A2AC29 | Category Code - Address Book 29 | String | UDC (01 29) | 3 | 0 | Allow NULL? |
| 34 | A2AC30 | Category Code - Address Book 30 | String | UDC (01 30) | 3 | 0 | Allow NULL? |
| 35 | A2USER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 36 | A2PID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 37 | A2UPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 38 | A2UPMT | Time - Last Updated | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 39 | A2MKEY | Machine Key | String | Generic Edit | 15 | 0 | Allow NULL? |