| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals | |
|---|---|---|---|---|---|---|---|---|---|---|
| 00: Foundation Environment | ||||||||||
| 1 | F0070 | Country Constants Master File | 2 | CK | ADID | Address Format ID | String | UDC | 2 | 0 |
| 76V: Venezuela | ||||||||||
| 2 | F76VLO01 | Withholdings Temporal Table - VEN -04 - 76V | 6 | LO | ADID | Address Format ID | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
UDC 00 / AF (Address Format ID) stock values
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | 01 | Postal Code / City - No State | N | |
| 2 | 02 | City, State, Postal Separated | N | |
| 3 | 03 | City / Postal Code | N | |
| 4 | 04 | City / State / Postal One Line | N | |
| 5 | 05 | No Postal Code | N | |
| 6 | 06 | Postal / State / City One Line | N | |
| 7 | 07 | No State or Postal Code | N | |
| 8 | 08 | Postal / City / State One Line | N | |
| 9 | 09 | Postal Right Just. - Separate | N | |
| 10 | 10 | City / Postal Code - No State | N | |
| 11 | 11 | Postal Code / City on 2nd Line | N | |
| 12 | 12 | Postal Separate Line | N | |
| 13 | 13 | Postal Code First Line | N | |
| 14 | 14 | City, County, Postal Separate | N | |
| 15 | 15 | Mailing Name Last | N | |
| 16 | 16 | Postal Code/City - Blank Line | N |