| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TRKORR | Request/Task | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | PERSNUMBER | Person number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | DATE_FROM | Valid-from date - in current Release only 00010101 possible | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | NATION | Version ID for International Addresses | char | 1 | 0 | | | | Allow NULL? |
| 6 | DATE_TO | Valid-to date in current Release only 99991231 possible | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | TITLE | Form-of-Address Key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | NAME_FIRST | First name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 9 | NAME_LAST | Last name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 10 | NAME2 | Name of person at birth | nvarchar | 40 | 0 | | | | Allow NULL? |
| 11 | NAMEMIDDLE | Middle name or second forename of a person | nvarchar | 40 | 0 | | | | Allow NULL? |
| 12 | NAME_LAST2 | Second surname of a person | nvarchar | 40 | 0 | | | | Allow NULL? |
| 13 | NAME_TEXT | Full Name of Person | nvarchar | 80 | 0 | | | | Allow NULL? |
| 14 | CONVERTED | Status of Field 'Full Name' NAME_TEXT | char | 1 | 0 | | | | Allow NULL? |
| 15 | TITLE_ACA1 | Academic Title: Key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | TITLE_ACA2 | Second academic title (key) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | PREFIX1 | Name Prefix (Key) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | PREFIX2 | 2nd name prefix (key) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | TITLE_SPPL | Name supplement, e.g. noble title (key) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | NICKNAME | Nickname or name used | nvarchar | 40 | 0 | | | | Allow NULL? |
| 21 | INITIALS | "Middle Initial" or personal initials | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | NAMEFORMAT | Name format | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | NAMCOUNTRY | Country for name format rule | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | PROFESSION | Profession | nvarchar | 40 | 0 | | | | Allow NULL? |
| 25 | SEX | Gender key | char | 1 | 0 | | | | Allow NULL? |
| 26 | LANGU | Language Key | char | 1 | 0 | | | | Allow NULL? |
| 27 | PERS_GROUP | Person Group (Key) (Business Address Services) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 28 | FLAGGROUPS | Flag: There are other person group assignments | char | 1 | 0 | | | | Allow NULL? |
| 29 | SORT1 | Search Term 1 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 30 | SORT2 | Search Term 2 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 31 | SORT_PHN | (Not Supported) Phonetic Search Sort Field | nvarchar | 20 | 0 | | | | Allow NULL? |
| 32 | ADDR_COMP | (not used) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 33 | ADDR_PERS | (not used) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 34 | FLPERSTEL | Flag: person has personal telephone numbers | char | 1 | 0 | | | | Allow NULL? |
| 35 | FLPERSCOMM | Flag: Person has personal comm. numbers (apart from Tel.) | char | 1 | 0 | | | | Allow NULL? |
| 36 | PERSORIGIN | Personal data source (key) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 37 | MC_NAMEFIR | First name in upper case for search help | nvarchar | 25 | 0 | | | | Allow NULL? |
| 38 | MC_NAMELAS | Last name in upper-case for search help | nvarchar | 25 | 0 | | | | Allow NULL? |
| 39 | MC_NAME2 | NAME2 field in upper case for matchcode | nvarchar | 25 | 0 | | | | Allow NULL? |
| 40 | LANGU_CREA | Address record creation original language | char | 1 | 0 | | | | Allow NULL? |
| 41 | ADRP_UUID | UUID Used in the Address | varbinary | 16 | 0 | | | | |
| 42 | UUID_BELATED | Indicator: UUID was generated later | char | 1 | 0 | | | | Allow NULL? |
| 43 | ID_CATEGORY | Category of an Address ID | char | 1 | 0 | | | | Allow NULL? |
| 44 | ADRP_ERR_STATUS | Error Status of Address | char | 1 | 0 | | | | Allow NULL? |
