| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | LAND1 | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ALORT | IS-M: City Number (Unique) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | INT_NR | IS-M: PTT street number (CH) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | KENNUNG | IS-M: CH/S: Customer-Specific Street Identifier | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | STRASSENNR | IS-M: Street Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | STRNRPTT | IS-M: PTT street number (CH) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 7 | STRART | IS-M: CH/S: Street Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | PRAEPCODE | IS-M: CH/S: Preposition Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | SPRCODE | IS-M: CH: Language Code | char | 1 | 0 | | | | Allow NULL? |
| 10 | GRUNDPLZ | IS-M: CH: 4-Digit Basic Postal Code CH | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | STRSTAMM | IS-M: CH/S: Street Master | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | X_UPDATE | IS-M: Processing indicator for J_1SSTRKUN (CH) | char | 1 | 0 | | | | Allow NULL? |
| 13 | SUCHFELDS | Search field for accessing postal structures w/o matchcode | nvarchar | 40 | 0 | | | | Allow NULL? |
| 14 | STR_NAME_K | IS-M: Street Name (Short) | nvarchar | 25 | 0 | | | | Allow NULL? |
| 15 | STR_NAME_L | IS-M: Street Name (long) | nvarchar | 50 | 0 | | | | Allow NULL? |
| 16 | STR_NAME_G | IS-M: Street name - upper case for matchcode | nvarchar | 50 | 0 | | | | Allow NULL? |
| 17 | STR_NAME_S | IS-M: Street Name (Long Without Special Characters) | nvarchar | 50 | 0 | | | | Allow NULL? |
| 18 | OTL_KEY | IS-M: City District Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | KREISG_SCH | IS-M: District Municipality Key | nvarchar | 15 | 0 | | | | Allow NULL? |
| 20 | HNRKENN | IS-M: Identifier for House Number Range | char | 1 | 0 | | | | Allow NULL? |
| 21 | HNR1VON | IS-M: House Number From (Numerical) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | HNR2VON | IS-M/SD: Affix to First House Number (Alphanumeric) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | HNR1BIS | IS-M: House Numbers To (Numerical) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | HNR2BIS | IS-M/SD: Affix for Last House Number (Alphanumeric) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | PLZ_ZSTR | IS-M: Postal Code of Street Section for Home Delivery | nvarchar | 10 | 0 | | | | Allow NULL? |
| 26 | STR_NRPOST | IS-M: Street number from German postal service | nvarchar | 15 | 0 | | | | Allow NULL? |
| 27 | STRHNR1000 | IS-M: 1000 column in house number interval | char | 1 | 0 | | | | Allow NULL? |
| 28 | STR_CODE | IS-M: Street code for coding street sections | nvarchar | 3 | 0 | | | | Allow NULL? |
| 29 | X_FEHLER | IS-M: Incorrect data record | char | 1 | 0 | | | | Allow NULL? |
| 30 | ERFUSER | Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 31 | ERFDATE | Created On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | ERFTIME | Time Created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 33 | AENUSER | Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 34 | AENDATE | Date of Last Change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | AENTIME | Time of Last Change | nvarchar | 6 | 0 | | | | Allow NULL? |
| 36 | VERSION_J | IS-M: Version year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 37 | VERSION_M | IS-M: Version month | nvarchar | 2 | 0 | | | | Allow NULL? |
| 38 | VERSION_T | IS-M: Version day | nvarchar | 2 | 0 | | | | Allow NULL? |
| 39 | VERSION_NR | IS-M: Version number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 40 | GUELTIGAB | Valid-From Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 41 | GUELTIGBIS | Valid-To Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 42 | LOESCH_VM | Deletion Flag for Master Data in Media Sales & Distribution | char | 1 | 0 | | | | Allow NULL? |
| 43 | PREDIRECTIONAL | Predirectional | nvarchar | 10 | 0 | | | | Allow NULL? |
| 44 | SUFFIXABBREV | Suffix to Street Name According to USPS | nvarchar | 4 | 0 | | | | Allow NULL? |
| 45 | POSTDIRECTIONAL | Postdirectional | nvarchar | 10 | 0 | | | | Allow NULL? |
| 46 | RECORDTYPECODE | Record Type in ZIP+4 File | char | 1 | 0 | | | | Allow NULL? |
| 47 | CARRIERROUTEID | Indicates Whether Truck Routes are for Drop-Off or Delivery | nvarchar | 4 | 0 | | | | Allow NULL? |
| 48 | BUILDINGFIRMNAME | Building or Company Name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 49 | ADDRSECABBREV | IS-M: Secondary Address Text | nvarchar | 4 | 0 | | | | Allow NULL? |
| 50 | ADDRSECNUMLOW | IS-M: Secondary Address Number (Lower Limit) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 51 | ADDRSECNUMHIGH | IS-M: Secondary Address Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 52 | ADDRSECODDEVEN | IS-M: Odd/Even Indicator for Secondary Address Number | char | 1 | 0 | | | | Allow NULL? |
| 53 | ZIPADDONLOW | IS-M: Extension of 5-digit ZIP code (lower limit) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 54 | ZIPADDONHIGH | IS-M: Extension of 5-digit ZIP code (upper limit) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 55 | LACSSTATUSIND | Locatable Address Conversion Service (LACS) indicator | char | 1 | 0 | | | | Allow NULL? |
| 56 | GOVTBLDGIND | Building Type | char | 1 | 0 | | | | Allow NULL? |
| 57 | FINANCENO | Finance Number; Required by USPS | nvarchar | 6 | 0 | | | | Allow NULL? |
| 58 | STATEABBREV | Region (State, Province, County) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 59 | COUNTYNO | County Code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 60 | CONGRDISTRICTNO | Code for District in a Geographical Area | nvarchar | 2 | 0 | | | | Allow NULL? |
| 61 | PREFCITYSTATEKEY | City Number from City State Product File | nvarchar | 6 | 0 | | | | Allow NULL? |
| 62 | STREETNAME_NEN | Street Name (NEN Standard) | nvarchar | 24 | 0 | | | | Allow NULL? |
| 63 | STREETNAME_PTT | Street Name (PTT Standard) | nvarchar | 17 | 0 | | | | Allow NULL? |
| 64 | SERIESINDICATOR | Indicator in PTT Postal Data: Street, Houseboat or Trailer | char | 1 | 0 | | | | Allow NULL? |
| 65 | J_1SAENDER | Change Number | nvarchar | 9 | 0 | | | | Allow NULL? |
