| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | RECORD_ID | Parameter ID for Editing object | nvarchar | 20 | 0 | | | | Allow NULL? |
| 2 | STATUS_CODE | Address Engine Status Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | STATUS_CODE_PO | Address Engine Status Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | INFO_CODE | Address Information Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | INFO_CODE_PO | PO Address Information Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | ERROR_CODE | Error codes | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | ERROR_CODE_PO | Error codes | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | COUNTRY | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | ADDRNUMBER | Address number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | PERSNUMBER | Person number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | NATION | Version ID for International Addresses | char | 1 | 0 | | | | Allow NULL? |
| 12 | DATE_FROM | Valid-from date - in current Release only 00010101 possible | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | DATE_TO | Valid-to date in current Release only 99991231 possible | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | PACKAGE_NO | Package number for reading quarterly adjustment data | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | CITY1 | City | nvarchar | 40 | 0 | | | | Allow NULL? |
| 16 | CITY2 | District | nvarchar | 40 | 0 | | | | Allow NULL? |
| 17 | CITY_CODE | City code for city/street file | nvarchar | 12 | 0 | | | | Allow NULL? |
| 18 | CITYP_CODE | District code for City and Street file | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | HOME_CITY | City (different from postal city) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 20 | CITYH_CODE | Different city for city/street file | nvarchar | 12 | 0 | | | | Allow NULL? |
| 21 | CHCKSTATUS | City file test status | char | 1 | 0 | | | | Allow NULL? |
| 22 | REGIOGROUP | Regional structure grouping | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | POST_CODE1 | City postal code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | POST_CODE2 | PO Box Postal Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | POST_CODE3 | Company Postal Code (for Large Customers) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 26 | PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 27 | PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | nvarchar | 10 | 0 | | | | Allow NULL? |
| 29 | PO_BOX | PO Box | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | PO_BOX_NUM | Flag: PO Box Without Number | char | 1 | 0 | | | | Allow NULL? |
| 31 | PO_BOX_LOC | PO Box city | nvarchar | 40 | 0 | | | | Allow NULL? |
| 32 | CITY_CODE2 | City PO box code (City file) | nvarchar | 12 | 0 | | | | Allow NULL? |
| 33 | PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 34 | PO_BOX_CTY | PO box country | nvarchar | 3 | 0 | | | | Allow NULL? |
| 35 | TRANSPZONE | Transportation zone to or from which the goods are delivered | nvarchar | 10 | 0 | | | | Allow NULL? |
| 36 | STREET | Street | nvarchar | 60 | 0 | | | | Allow NULL? |
| 37 | STREETCODE | Street Number for City/Street File | nvarchar | 12 | 0 | | | | Allow NULL? |
| 38 | STREETABBR | (Not Supported) Abbreviation of Street Name | nvarchar | 2 | 0 | | | | Allow NULL? |
| 39 | HOUSE_NUM1 | House Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 40 | HOUSE_NUM2 | House number supplement | nvarchar | 10 | 0 | | | | Allow NULL? |
| 41 | STR_SUPPL1 | Street 2 | nvarchar | 40 | 0 | | | | Allow NULL? |
| 42 | STR_SUPPL2 | Street 3 | nvarchar | 40 | 0 | | | | Allow NULL? |
| 43 | STR_SUPPL3 | Street 4 | nvarchar | 40 | 0 | | | | Allow NULL? |
| 44 | LOCATION | Street 5 | nvarchar | 40 | 0 | | | | Allow NULL? |
| 45 | BUILDING | Building (Number or Code) | nvarchar | 20 | 0 | | | | Allow NULL? |
| 46 | FLOOR | Floor in building | nvarchar | 10 | 0 | | | | Allow NULL? |
| 47 | ROOMNUMBER | Room or Appartment Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 48 | LANGU | Language Key | char | 1 | 0 | | | | Allow NULL? |
| 49 | REGION | Region (State, Province, County) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 50 | TIME_ZONE | Address time zone | nvarchar | 6 | 0 | | | | Allow NULL? |
| 51 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | | | Allow NULL? |
| 52 | LANGU_CREA | Address record creation original language | char | 1 | 0 | | | | Allow NULL? |
| 53 | NAME_CO | c/o name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 54 | DONT_USE_S | Street Address Undeliverable Flag | nvarchar | 4 | 0 | | | | Allow NULL? |
| 55 | DONT_USE_P | PO Box Address Undeliverable Flag | nvarchar | 4 | 0 | | | | Allow NULL? |
| 56 | PO_BOX_LOBBY | PO Box Lobby | nvarchar | 40 | 0 | | | | Allow NULL? |
| 57 | DELI_SERV_TYPE | Type of Delivery Service | nvarchar | 4 | 0 | | | | Allow NULL? |
| 58 | DELI_SERV_NUMBER | Number of Delivery Service | nvarchar | 10 | 0 | | | | Allow NULL? |
| 59 | REGION2_LONG | region2 long name | nvarchar | 60 | 0 | | | | Allow NULL? |
| 60 | STOP | General Flag | char | 1 | 0 | | | | Allow NULL? |
| 61 | CHCKST_QU | City file check status after quarterly adjustment | char | 1 | 0 | | | | Allow NULL? |
| 62 | ERROR_FLAG | Flag: Quarterly adjustment error | char | 1 | 0 | | | | Allow NULL? |
