| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TITEL | Form of address text | char | 1 | 0 | | | | Allow NULL? |
| 3 | NAME1 | Name 1 | char | 1 | 0 | | | | Allow NULL? |
| 4 | SORT1 | Search term 1 | char | 1 | 0 | | | | Allow NULL? |
| 5 | NAME2 | Name 2 | char | 1 | 0 | | | | Allow NULL? |
| 6 | SORT2 | Search term 2 | char | 1 | 0 | | | | Allow NULL? |
| 7 | NAME3 | Name 3 | char | 1 | 0 | | | | Allow NULL? |
| 8 | LANGU | Language Key | char | 1 | 0 | | | | Allow NULL? |
| 9 | NOT_USED1 | Field is not used | char | 1 | 0 | | | | Allow NULL? |
| 10 | NAME4 | Name 4 | char | 1 | 0 | | | | Allow NULL? |
| 11 | STREET | Street Name | char | 1 | 0 | | | | Allow NULL? |
| 12 | PO_BOX | Post office box | char | 1 | 0 | | | | Allow NULL? |
| 13 | CITY1 | Location | char | 1 | 0 | | | | Allow NULL? |
| 14 | POST_CODE1 | City postal code | char | 1 | 0 | | | | Allow NULL? |
| 15 | CITY2 | City district | char | 1 | 0 | | | | Allow NULL? |
| 16 | POST_CODE2 | PO Box Postal Code | char | 1 | 0 | | | | Allow NULL? |
| 17 | COUNTRY | Country Key | char | 1 | 0 | | | | Allow NULL? |
| 18 | REGION | Region (state, province, county) | char | 1 | 0 | | | | Allow NULL? |
| 19 | DEFLT_COMM | Communication Type (Key) (Central Address Management) | char | 1 | 0 | | | | Allow NULL? |
| 20 | TEL_NUMBER | First Telephone No.: Area Code + Number | char | 1 | 0 | | | | Allow NULL? |
| 21 | FAX_NUMBER | First Fax No.: Dialling Code + Number | char | 1 | 0 | | | | Allow NULL? |
| 22 | MCOM | Other communications data | char | 1 | 0 | | | | Allow NULL? |
| 23 | HOUSE_NUM1 | House Number | char | 1 | 0 | | | | Allow NULL? |
| 24 | NAME_CO | c/o Name | char | 1 | 0 | | | | Allow NULL? |
| 25 | HOUSE_NUM2 | House number affix | char | 1 | 0 | | | | Allow NULL? |
| 26 | HOUSE_NUM3 | House Number Range | char | 1 | 0 | | | | Allow NULL? |
| 27 | STR_SUPPL1 | Street 2 | char | 1 | 0 | | | | Allow NULL? |
| 28 | STR_SUPPL2 | Street 3 | char | 1 | 0 | | | | Allow NULL? |
| 29 | LOCATION | Street 5 | char | 1 | 0 | | | | Allow NULL? |
| 30 | BUILDING | Building (Number or Code) | char | 1 | 0 | | | | Allow NULL? |
| 31 | FLOOR | Floor in building | char | 1 | 0 | | | | Allow NULL? |
| 32 | ROOMNUMBER | Room or Appartment Number | char | 1 | 0 | | | | Allow NULL? |
| 33 | POSTALAREA | Post delivery district | char | 1 | 0 | | | | Allow NULL? |
| 34 | TRANSPZONE | Transportation zone to or from which the goods are delivered | char | 1 | 0 | | | | Allow NULL? |
| 35 | POST_CODE3 | Company postal code (for large customers) | char | 1 | 0 | | | | Allow NULL? |
| 36 | REMARK | Address notes | char | 1 | 0 | | | | Allow NULL? |
| 37 | ADDRORIGIN | Source for Address Data (key) | char | 1 | 0 | | | | Allow NULL? |
| 38 | DETAIL | Details | char | 1 | 0 | | | | Allow NULL? |
| 39 | NOT_USED2 | Field is not used | char | 1 | 0 | | | | Allow NULL? |
| 40 | NOT_USED3 | Field is not used | char | 1 | 0 | | | | Allow NULL? |
| 41 | NOT_USED6 | Field is not used | char | 1 | 0 | | | | Allow NULL? |
| 42 | NOT_USED7 | Field is not used | char | 1 | 0 | | | | Allow NULL? |
| 43 | NOT_USED4 | Field is not used | char | 1 | 0 | | | | Allow NULL? |
| 44 | NOT_USED5 | Field is not used | char | 1 | 0 | | | | Allow NULL? |
| 45 | TIME_ZONE | Address time zone | char | 1 | 0 | | | | Allow NULL? |
| 46 | STR_SUPPL3 | Street 4 | char | 1 | 0 | | | | Allow NULL? |
| 47 | EXTENSION1 | Extension (only for data conversion) (e.g. data line) | char | 1 | 0 | | | | Allow NULL? |
| 48 | EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | char | 1 | 0 | | | | Allow NULL? |
| 49 | TAXJURCODE | Jurisdiction for tax calculation - tax jurisdiction code | char | 1 | 0 | | | | Allow NULL? |
| 50 | REGIOGROUP | Regional structure grouping | char | 1 | 0 | | | | Allow NULL? |
| 51 | SMTP_ADDR | E-mail Address | char | 1 | 0 | | | | Allow NULL? |
| 52 | NOT_USED51 | Field is not used | nvarchar | 10 | 0 | | | | Allow NULL? |
| 53 | NOT_USED61 | Field is not used | nvarchar | 10 | 0 | | | | Allow NULL? |
| 54 | NOT_USED71 | Field is not used | nvarchar | 10 | 0 | | | | Allow NULL? |
| 55 | NOT_USED81 | Field is not used | nvarchar | 10 | 0 | | | | Allow NULL? |
| 56 | NOT_USED91 | Field is not used | nvarchar | 10 | 0 | | | | Allow NULL? |
| 57 | HOME_CITY | City (Different from Postal City) | char | 1 | 0 | | | | Allow NULL? |
| 58 | PO_BOX_NUM | Indicator: PO Box Without Number | char | 1 | 0 | | | | Allow NULL? |
| 59 | PO_BOX_CTY | PO Box Country | char | 1 | 0 | | | | Allow NULL? |
| 60 | PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | char | 1 | 0 | | | | Allow NULL? |
| 61 | PO_BOX_LOC | PO Box City | char | 1 | 0 | | | | Allow NULL? |
| 62 | NOT_USED106 | Street Address Undeliverable Flag | char | 1 | 0 | | | | Allow NULL? |
| 63 | NOT_USED107 | PO Box Address Undeliverable Indicator | char | 1 | 0 | | | | Allow NULL? |
| 64 | NOT_USED108 | Field is not used | char | 1 | 0 | | | | Allow NULL? |
| 65 | MOB_NUMBER | First Mobile Telephone Number: Area Code + Connection | char | 1 | 0 | | | | Allow NULL? |
| 66 | DELI_SERV_TYPE | Type of Delivery Service | char | 1 | 0 | | | | Allow NULL? |
| 67 | DELI_SERV_NUMBER | Number of Delivery Service | char | 1 | 0 | | | | Allow NULL? |
| 68 | PO_BOX_LOBBY | PO Box Lobby | char | 1 | 0 | | | | Allow NULL? |
| 69 | NOT_USED113 | Field is not used | char | 1 | 0 | | | | Allow NULL? |
| 70 | COUNTY | District (US: County) | char | 1 | 0 | | | | Allow NULL? |
| 71 | TOWNSHIP | City | char | 1 | 0 | | | | Allow NULL? |
