| LAND1 |
Country Key |
LAND1 |
T005
|
CHAR |
|
3 |
0 |
|
| ALORT |
IS-M: City Number (Unique) |
JALORT |
|
CHAR |
|
8 |
0 |
|
| SUCHFELDO |
Search field for accessing postal structures w/o matchcode |
SUCHFELD |
|
CHAR |
|
40 |
0 |
|
| ORT_NAME_K |
IS-M: City Name (Short Text) |
ORT_NAME_K |
|
CHAR |
|
25 |
0 |
|
| ORT_NAME_L |
IS-M: City name (long text) |
ORT_NAME_L |
|
CHAR |
|
50 |
0 |
|
| ORT_NAME_G |
IS-M: City name in block capitals |
ORT_NAME_G |
|
CHAR |
|
50 |
0 |
|
| ORT_NAME_S |
IS-M: City Name (Long Text, No Special Characters) |
ORT_NAME_S |
|
CHAR |
|
50 |
0 |
|
| ORTZUSA |
IS-M: Affix for City Name |
ORTZUSA |
|
CHAR |
|
30 |
0 |
|
| KREISG_SCH |
IS-M: District Municipality Key |
KREISG_SCH |
JSTKGSPRO
|
CHAR |
|
15 |
0 |
|
| HERKKZORT |
IS-M: Origin Indicator for City |
HERKZORT |
TJS31
|
CHAR |
|
1 |
0 |
|
| HERKKZSTR |
IS-M: Origin Indicator for Street File |
HERKZSTR |
TJS31
|
CHAR |
|
1 |
0 |
|
| XSTRMANUEL |
IS-M: Additional Streets were Entered Manually |
XSTRMANUEL |
|
CHAR |
|
1 |
0 |
Possible values
|
| X_FEHLER |
IS-M: Incorrect data record |
X_FEHLER |
|
CHAR |
|
1 |
0 |
Possible values
|
| ERFUSER |
Created By |
ERFUSER |
|
CHAR |
|
12 |
0 |
|
| ERFDATE |
Created On |
ERFDATE |
|
DATS |
|
8 |
0 |
|
| ERFTIME |
Time Created |
ERFTIME |
|
TIMS |
|
6 |
0 |
|
| AENUSER |
Last Changed By |
AENUSER |
|
CHAR |
|
12 |
0 |
|
| AENDATE |
Date of Last Change |
AENDATE |
|
DATS |
|
8 |
0 |
|
| AENTIME |
Time of Last Change |
AENTIME |
|
TIMS |
|
6 |
0 |
|
| VERSION_J |
IS-M: Version year |
VERSION_J |
|
NUMC |
|
4 |
0 |
|
| VERSION_M |
IS-M: Version month |
VERSION_M |
|
NUMC |
|
2 |
0 |
Possible values
| 01 |
January |
| 02 |
February |
| 03 |
March |
| 04 |
April |
| 05 |
May |
| 06 |
June |
| 07 |
July |
| 08 |
August |
| 09 |
September |
| 10 |
October |
| 11 |
November |
| 12 |
December |
|
| VERSION_T |
IS-M: Version day |
VERSION_T |
|
NUMC |
|
2 |
0 |
|
| VERSION_NR |
IS-M: Version number |
VERSION_NR |
|
CHAR |
|
5 |
0 |
|
| GUELTIGAB |
Valid-From Date |
GUELTIGVON |
|
DATS |
|
8 |
0 |
|
| GUELTIGBIS |
Valid-To Date |
GUELTIGBIS |
|
DATS |
|
8 |
0 |
|
| LOESCH_VM |
Deletion Flag for Master Data in Media Sales & Distribution |
LOEVM_ISP |
|
CHAR |
|
1 |
0 |
Possible values
|
| CITYSTATEFACCODE |
Type of Location Defined by the City Name |
CITYSTATEFACCODE |
|
CHAR |
|
1 |
0 |
Possible values
| A |
Postal airport |
| B |
Industry sector |
| C |
Municipal post office |
| D |
Distribution center |
| E |
SCF |
| F |
Del/dist.center |
| G |
Main post office |
| K |
Bulk post office |
| M |
MoneyOrderUnit |
| N |
NonPostalComm. |
| P |
Post office |
| S |
Stop |
| U |
Urbanization |
|
| PREFCITYSTATEKEY |
Preferred city number from city state product file |
PREFCITYSTATEKEY |
|
CHAR |
|
6 |
0 |
|
| PREFCITYSTNAME |
Preferred city name |
PREFCITYSTNAME |
|
CHAR |
|
28 |
0 |
|
| CITYDELIND |
Indicates Whether Carrier Routes Defined |
CITYDELIND |
|
CHAR |
|
1 |
0 |
|
| CARRRTESORTIND |
Indicates Whether Price Reduction Possible for Letter Post |
CARRRTESORTIND |
|
CHAR |
|
1 |
0 |
|
| UNIQUEZIPIND |
Indicates Whether or not ZIP Code is Unique |
UNIQUEZIPIND |
|
CHAR |
|
1 |
0 |
|
| FINANCENO |
Finance Number; Required by USPS |
FINANCENO |
|
CHAR |
|
6 |
0 |
|
| STATEABBREV |
Region (State, Province, County) |
REGIO |
T005S
|
CHAR |
|
3 |
0 |
|
| COUNTYNO |
County Code |
COUNC |
T005E
|
CHAR |
|
3 |
0 |
|
| ORT_NAME_AL |
IS-M: Alternative City Name |
ORT_NAME_AL |
|
CHAR |
|
50 |
0 |
|
| CEBUCOCODE |
Cebuco Code |
CEBUCOCODE |
|
CHAR |
|
3 |
0 |
|
| CITYNAME_NEN |
City Name (NEN Standard) |
CITYNAME_NEN |
|
CHAR |
|
24 |
0 |
|
