| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ADDRNUMBER | Address number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | PERSNUMBER | Person number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | ADDR_TYPE | Address type (1=Organization, 2=Person, 3=Contact person) | char | 1 | 0 | | | | Allow NULL? |
| 5 | DATE_FROM | Valid-from date - in current Release only 00010101 possible | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | NATION | Version ID for International Addresses | char | 1 | 0 | | | | Allow NULL? |
| 7 | VALIDATED_ON | Date the Validation was carried out | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | VALIDATED_AT | Time when the Validation was carried out | nvarchar | 6 | 0 | | | | Allow NULL? |
| 9 | COUNTRY | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | REGION | Region (State, Province, County) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | ERR_CODE | Error codes | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | ERR_CODE_PO | Error codes | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | POST_CODE2 | PO Box Postal Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | CHCKSTATUS | City file test status | char | 1 | 0 | | | | Allow NULL? |