| MC_NAME |
Name (Field NAME1) in Uppercase for Search Help |
CHAR |
25 |
0 |
|
AD_MC_NAME
|
|
| SORT1 |
Search Term 1 |
CHAR |
20 |
0 |
|
AD_SORT1
|
|
| SORT2 |
Search Term 2 |
CHAR |
20 |
0 |
|
AD_SORT2
|
|
| MC_CITY1 |
City name in Uppercase for Search Help |
CHAR |
25 |
0 |
|
AD_MC_CITY
|
|
| POST_CODE1 |
City postal code |
CHAR |
10 |
0 |
|
AD_PSTCD1
|
|
| MC_STREET |
Street Name in Uppercase for Search Help |
CHAR |
25 |
0 |
|
AD_MC_STRT
|
|
| HOUSE_NUM1 |
House Number |
CHAR |
10 |
0 |
|
AD_HSNM1
|
|
| COUNTRY |
Country/Region Key |
CHAR |
3 |
0 |
*
|
LAND1
|
|
| REGION |
Region (State, Province, County) |
CHAR |
3 |
0 |
*
|
REGIO
|
|
| NAME1_LNG |
Name 1 |
CHAR |
40 |
0 |
|
AD_NAME1
|
|
| CITY1_LNG |
City |
CHAR |
40 |
0 |
|
AD_CITY1
|
|
| STREET_LNG |
Street |
CHAR |
60 |
0 |
|
AD_STREET
|
|