| 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 | TITLE | Form-of-Address Key | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | NAME1 | Name 1 | nvarchar | 40 | 0 | | | | Allow NULL? |
| 5 | NAME2 | Name 2 | nvarchar | 40 | 0 | | | | Allow NULL? |
| 6 | NAME3 | Name 3 | nvarchar | 40 | 0 | | | | Allow NULL? |
| 7 | NAME4 | Name 4 | nvarchar | 40 | 0 | | | | Allow NULL? |
| 8 | CITY1 | City | nvarchar | 40 | 0 | | | | Allow NULL? |
| 9 | CITY2 | District | nvarchar | 40 | 0 | | | | Allow NULL? |
| 10 | HOME_CITY | City (different from postal city) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 11 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | POST_CODE2 | PO Box Postal Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | POST_CODE3 | Company Postal Code (for Large Customers) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | PO_BOX | PO Box | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | PO_BOX_LOC | PO Box city | nvarchar | 40 | 0 | | | | Allow NULL? |
| 16 | PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | POSTALAREA | (Not Supported) Post Delivery District | nvarchar | 15 | 0 | | | | Allow NULL? |
| 19 | STREET | Street | nvarchar | 60 | 0 | | | | Allow NULL? |
| 20 | HOUSE_NUM1 | House Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | COUNTRY | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | LANGU | Language Key | char | 1 | 0 | | | | Allow NULL? |
| 23 | REGION | Region (State, Province, County) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | SORT1 | Search Term 1 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 25 | SORT2 | Search Term 2 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 26 | TEL_NUMBER | First telephone no.: dialling code+number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 27 | TEL_EXTENS | First Telephone No.: Extension | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | FAX_NUMBER | First fax no.: dialling code+number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 29 | FAX_EXTENS | First fax no.: extension | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | MC_NAME1 | Name (field NAME1) in upper case for matchcode | nvarchar | 25 | 0 | | | | Allow NULL? |
| 31 | MC_CITY1 | City name in upper case for search help | nvarchar | 25 | 0 | | | | Allow NULL? |
| 32 | MC_STREET | Street name in upper case for search help | nvarchar | 25 | 0 | | | | Allow NULL? |
| 33 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | | | Allow NULL? |
| 34 | SMTP_ADDR | E-Mail Address | nvarchar | 241 | 0 | | | | Allow NULL? |
