| NAME_CO |
c/o name |
CHAR |
40 |
0 |
|
AD_NAME_CO
|
|
| CITY1 |
City |
CHAR |
40 |
0 |
|
AD_CITY1
|
|
| CITY2 |
District |
CHAR |
40 |
0 |
|
AD_CITY2
|
|
| CITY_CODE |
City code for city/street file |
CHAR |
12 |
0 |
|
AD_CITYNUM
|
|
| CITYP_CODE |
District code for City and Street file |
CHAR |
8 |
0 |
|
AD_CITYPNM
|
|
| HOME_CITY |
City (different from postal city) |
CHAR |
40 |
0 |
|
AD_CITY3
|
|
| CITYH_CODE |
Different city for city/street file |
CHAR |
12 |
0 |
|
AD_CITYHNM
|
|
| CHCKSTATUS |
City file test status |
CHAR |
1 |
0 |
|
AD_CHECKST
|
|
Not Checked |
| C |
checked against city index |
| D |
differs from city index |
|
| REGIOGROUP |
Regional structure grouping |
CHAR |
8 |
0 |
|
REGIOGROUP
|
|
| POST_CODE1 |
City postal code |
CHAR |
10 |
0 |
|
AD_PSTCD1
|
|
| POST_CODE2 |
PO Box Postal Code |
CHAR |
10 |
0 |
|
AD_PSTCD2
|
|
| POST_CODE3 |
Company Postal Code (for Large Customers) |
CHAR |
10 |
0 |
|
AD_PSTCD3
|
|
| PCODE1_EXT |
(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code |
CHAR |
10 |
0 |
|
AD_PST1XT
|
|
| PCODE2_EXT |
(Not Supported) PO Box Postal Code Extension |
CHAR |
10 |
0 |
|
AD_PST2XT
|
|
| PCODE3_EXT |
(Not Supported) Major Customer Postal Code Extension |
CHAR |
10 |
0 |
|
AD_PST3XT
|
|
| PO_BOX |
PO Box |
CHAR |
10 |
0 |
|
AD_POBX
|
|
| DONT_USE_P |
PO Box Address Undeliverable Flag |
CHAR |
4 |
0 |
|
AD_NO_USEP
|
|
| PO_BOX_NUM |
Flag: PO Box Without Number |
CHAR |
1 |
0 |
|
AD_POBXNUM
|
|
| PO_BOX_LOC |
PO Box city |
CHAR |
40 |
0 |
|
AD_POBXLOC
|
|
| CITY_CODE2 |
City PO box code (City file) |
CHAR |
12 |
0 |
|
AD_CIT2NUM
|
|
| PO_BOX_REG |
Region for PO Box (Country/Region, State, Province, ...) |
CHAR |
3 |
0 |
|
AD_POBXREG
|
|
| PO_BOX_CTY |
PO Box of Country/Region |
CHAR |
3 |
0 |
|
AD_POBXCTY
|
|
| POSTALAREA |
(Not Supported) Post Delivery District |
CHAR |
15 |
0 |
|
AD_PSTLAR
|
|
| TRANSPZONE |
Transportation zone to or from which the goods are delivered |
CHAR |
10 |
0 |
|
LZONE
|
|
| STREET |
Street |
CHAR |
60 |
0 |
|
AD_STREET
|
|
| DONT_USE_S |
Street Address Undeliverable Flag |
CHAR |
4 |
0 |
|
AD_NO_USES
|
|
| STREETCODE |
Street Number for City/Street File |
CHAR |
12 |
0 |
|
AD_STRNUM
|
|
| STREETABBR |
(Not Supported) Abbreviation of Street Name |
CHAR |
2 |
0 |
|
AD_STRABBR
|
|
| HOUSE_NUM1 |
House Number |
CHAR |
10 |
0 |
|
AD_HSNM1
|
|
| HOUSE_NUM2 |
House number supplement |
CHAR |
10 |
0 |
|
AD_HSNM2
|
|
| HOUSE_NUM3 |
(Not supported) House Number Range |
CHAR |
10 |
0 |
|
AD_HSNM3
|
|
| STR_SUPPL1 |
Street 2 |
CHAR |
40 |
0 |
|
AD_STRSPP1
|
|
| STR_SUPPL2 |
Street 3 |
CHAR |
40 |
0 |
|
AD_STRSPP2
|
|
| STR_SUPPL3 |
Street 4 |
CHAR |
40 |
0 |
|
AD_STRSPP3
|
|
| LOCATION |
Street 5 |
CHAR |
40 |
0 |
|
AD_LCTN
|
|
| BUILDING |
Building (Number or Code) |
CHAR |
20 |
0 |
|
AD_BLDNG
|
|
| FLOOR |
Floor in building |
CHAR |
10 |
0 |
|
AD_FLOOR
|
|
| ROOMNUMBER |
Room or Apartment Number |
CHAR |
10 |
0 |
|
AD_ROOMNUM
|
|
| COUNTRY |
Country/Region Key |
CHAR |
3 |
0 |
|
LAND1
|
|
| LANGU |
Language Key |
LANG |
1 |
0 |
|
SPRAS
|
|
| REGION |
Region (State, Province, County) |
CHAR |
3 |
0 |
|
REGIO
|
|
| SORT1 |
Search Term 1 |
CHAR |
20 |
0 |
|
AD_SORT1
|
|
| SORT2 |
Search Term 2 |
CHAR |
20 |
0 |
|
AD_SORT2
|
|
| SORT_PHN |
(Not Supported) Phonetic Search Sort Field |
CHAR |
20 |
0 |
|
AD_SRTPHN
|
|
| ADDRORIGIN |
(Not Supported) Address Data Source (Key) |
CHAR |
4 |
0 |
|
AD_ORIGINA
|
|
| EXTENSION1 |
Extension (only for data conversion) (e.g. data line) |
CHAR |
40 |
0 |
|
AD_EXTENS1
|
|
| EXTENSION2 |
Extension (only for data conversion) (e.g. telebox) |
CHAR |
40 |
0 |
|
AD_EXTENS2
|
|
| TIME_ZONE |
Address time zone |
CHAR |
6 |
0 |
|
AD_TZONE
|
|
| TAXJURCODE |
Tax Jurisdiction |
CHAR |
15 |
0 |
|
AD_TXJCD
|
|
| ADDRESS_ID |
(Not supported) Physical address ID |
CHAR |
10 |
0 |
|
AD_ADDR_ID
|
|
| REMARK |
Address notes |
CHAR |
50 |
0 |
|
AD_REMARK1
|
|
| LANGU_CREA |
Address record creation original language |
LANG |
1 |
0 |
|
AD_LANGUCR
|
|