ADDRDATA

Address Code Address

REFERENCED BY
GL210 GL223


UPDATED BY
AC03.1 AC03.2 AC03.3 AC03.4 AC03.5 AC03.6
AC03.7 AC10.1 AC17.3 AC17.4 AC210 ACVW.1
AM01.1 AM01.2 AM01.3 AM05.1 AM06.1 AM06.2
AM06.3 AM06.5 AM06.6 AM09.1 AM115 AM117
AM118 AM12.1 AM120 AM125 AM135 AM145
AM15.1 AM15.2 AM15.3 AM15.4 AM152 AM154
AM16.1 AM17.1 AM170 AM18.1 AM18.2 AM180
AM185 AM19.1 AM19.2 AM190 AM192 AM195
AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6
AM20.7 AM20.8 AM205 AM206 AM21.1 AM21.2
AM21.3 AM21.4 AM21.5 AM21.6 AM21.7 AM21.8
AM211 AM212 AM214 AM219 AM220 AM221
AM222 AM223 AM224 AM225 AM230 AM235
AM240 AM241 AM245 AM25.1 AM250 AM251
AM252 AM255 AM258 AM260 AM265 AM266
AM267 AM270 AM275 AM277 AM278 AM280
AM281 AM282 AM285 AM287 AM288 AM290
AM292 AM295 AM30.1 AM30.2 AM30.3 AM300
AM310 AM320 AM330 AM35.1 AM40.1 AM40.2
AM40.3 AM40.4 AM41.1 AM41.2 AM45.1 AM500
AM501 AM502 AM51.1 AM52.1 AM551 AM580
AM60.1 AM70.1 AM75.1 AM80.1 AM85.1 AM88.7
AM90.1 AM90.4 AM90.5 AM90.6 AM91.1 AM91.4
AM91.5 AM92.1 AM93.1 AM95.1 AM95.4 AM95.5
AM95.6 AM96.1 AM97.1 AM98.1 AM99.1 AP00.4
AP00.7 AP01.1 AP05.1 AP05.2 AP05.7 AP05.8
AP115 AP125 AP126 AP130 AP131 AP136
AP150 AP151 AP155 AP156 AP160 AP161
AP166 AP170 AP175 AP176 AP180 AP181
AP185 AP190 AP191 AP193 AP195 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.6 AP20.7
AP20.8 AP200 AP201 AP21.1 AP220 AP23.1
AP237 AP25.1 AP25.2 AP255 AP26.1 AP265
AP27.1 AP275 AP28.1 AP28.2 AP30.2 AP30.4
AP305 AP520 AP55.1 AP55.2 AP56.1 AP56.2
AP80.1 AP81.1 AP90.5 AP91.4 AP95.2 AP95.3
API1.1 API2.1 AR01.1 AR13.1 AR13.2 BN00.1
BN00.2 BN15.1 BN150 BN190 BN20.1 BN66.1
BN80.1 BN81.1 BN81.2 CB00.3 CB01.2 CB01.4
CB03.1 CB03.2 CB05.1 CB06.1 CB06.2 CB10.1
CB10.3 CB10.5 CB145 CB15.1 CB15.2 CB150
CB162 CB175 CB180 CB185 CB186 CB187
CB190 CB191 CB195 CB20.1 CB20.6 CB210
CB215 CB220 CB221 CB222 CB25.1 CB255
CB260 CB286 CB30.1 CB43.1 CB44.1 CB45.1
CB46.1 CB50.1 CB500 CB54.1 CB543 CB544
CB55.1 CB554 CB62.1 CB80.1 CB82.1 CB90.2
CB90.5 CB90.7 CB99.3 CB99.4 CB99.5 EE11.1
EE135 EE175 EE20.1 EE20.2 EE20.3 EE20.4
EE220 EE230 EE275 EE35.1 EE35.2 EE520
EE90.3 CA00.1 CA00.2 CA05.1 CA10.1 CA10.2
CA10.4 CA10.5 CA10.6 CA10.7 CA110 CA15.1
CA15.2 CA160 CA190 CA195 CA199 CA210
CA215 CA240 CA290 CA60.1 FB10.1 FB100
FB101 FB11.1 FB11.2 FB111 FB120 FB121
FB122 FB141 FB145 FB160 FB165 FB190
FB195 FB20.1 FB20.2 FB20.3 FB20.4 FB20.6
FB20.7 FB21.1 FB210 FB211 FB215 FB220
FB225 FB230 FB231 FB235 FB240 FB25.1
FB265 FB295 FB296 FB30.1 FB31.1 FB325
FB35.1 FB40.1 FB40.2 FB40.3 FB40.4 FB45.1
FB60.1 FB65.1 FB95.1 FB95.2 FB95.3 FB95.4
FB95.5 FB95.6 GL110 GL111 GL120 GL122
GL135 GL141 GL145 GL146 GL147 GL148
GL165 GL167 GL170 GL179 GL190 GL191
GL192 GL195 GL196 GL197 GL199 GL230
GL235 GL238 GL240 GL241 GL243 GL245
GL250 GL265 GL267 GL270 GL275 GL276
GL281 GL290 GL291 GL292 GL293 GL294
GL295 GL296 GL298 GL299 GL30.1 GL30.2
GL300 GL310 GL320 GL322 GL325 GL326
GL327 GL328 GL330 GL36.1 GL40.1 GL40.2
GL40.3 GL40.4 GL40.5 GL40.6 GL40.7 GL40.8
GL41.1 GL41.3 GL41.4 GL43.1 GL44.1 GL45.1
GL50.1 GL50.2 GL50.4 GL50.5 GL500 GL55.1
GL65.1 GL65.3 GL67.1 GL70.1 GL70.2 GL70.3
GL70.5 GL70.6 GL75.1 GL76.1 GL76.2 GL90.1
GL90.2 GL90.3 GL90.4 GL90.5 GL90.6 GL90.7
GL93.1 GL93.3 GL94.1 GL94.2 GL94.3 GL94.4
GL94.5 GL94.6 GL94.7 GL95.1 GL95.2 GL95.3
GL95.4 GL95.5 GL95.6 GL95.7 GL95.8 GL95.9
GL96.1 GL96.2 GL96.3 GL96.4 GL96.5 GL97.1
GL97.2 GL97.3 GL97.4 GL97.5 GL97.6 GL97.7
GL97.8 GL97.9 GL98.1 GL98.2 GL98.3 GL98.4
GL98.5 GL99.1 GL99.2 GL99.3 GL99.4 GL99.5
GL99.6 RW00.1 RW10.2 RW10.3 RW10.4 RW10.6
RW10.7 RW100 RW20.5 RW20.6 RW60.1 RW60.4
RW70.1 HR00.1 HR01.1 HR200 PR521 CU03.1
CU161 CU203 CU220 CU261 CU300 CU61.2
EX175 EX542 EX545 EXI2.1 EXI4.1 GL01.1
GL01.2 GL03.6 GL08.1 GL08.2 GL10.1 GL10.2
GL121 GL124 GL125 GL14.8 GL161 GL162
GL198 GL20.1 GL20.2 GL20.4 GL20.6 GL20.7
GL20.8 GL220 GL221 GL222 GL225 GL23.1
GL23.3 GL25.1 GL261 GL311 GL342 GL38.2
GL42.1 GL61.1 GL62.1 GLAV.1 GLCV.1 GLVW.1
IF00.1 IFAC.1 IFCU.1 IFEB.1 IFFC.1 IFGT.1
IFOS.1 IFUC.1 MX135 LP130 LP140 LP198
MA05.3 MA05.6 MA205 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.4 MA43.6
MA43.7 MA54.1 MA54.7 MA540 MAI1.1 PA182
PO01.1 PO136 PO15.1 PO15.2 PO15.4 PO190
PO300 PO520 POCP.1 POI3.1 POI7.1 POIF.1
POIH.1 POII.1 POIJ.1 POIM.1 PR05.1 PR05.3
PR128 PR130 PR131 PR132 PR134 PR135
PR136 PR137 PR140 PR189 PR195 PR196
PR197 PR198 PR26.1 PR29.1 PR32.1 PR32.2
PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR37.1 PR38.1 PR45.1 PR47.1 PR514 PR529
PR530 PR560 PR582 PR80.1 PR80.4 PR82.1
PR85.1 PR89.1 UK102 UK330 UK47.1 UK560
MM280 RQ01.1 RQ50.1 SL40.1 SL40.4 SLVW.1
SNGL.1 TA147 TA195 TA196 IN01.1 IN120
TX00.1 TX04.1 TX100 TX101 TX202 TX222
TX226 TX301 TX40.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GDD-ADDR-CODE
Element: Addr Code
Alpha 20
This is a code representing the address for the institution or the institution location. The address is stored in the ADDRDATA file.
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM152 AM154
AM16.1 AM17.1
AM170 AM18.1
AM18.2 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM20.7 AM20.8
AM205 AM206
AM21.1 AM21.2
GDD-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM152 AM154
AM16.1 AM17.1
AM170 AM18.1
AM18.2 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM20.7 AM20.8
AM205 AM206
AM21.1 AM21.2
GDD-NAME
Element: Name
Alpha 30 (Lower Case)
Displays the company description.
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM152 AM154
AM16.1 AM17.1
AM170 AM18.1
AM18.2 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM20.7 AM20.8
AM205 AM206
AM21.1 AM21.2
GDD-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM152 AM154
AM16.1 AM17.1
AM170 AM18.1
AM18.2 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM20.7 AM20.8
AM205 AM206
AM21.1 AM21.2
GDD-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM152 AM154
AM16.1 AM17.1
AM170 AM18.1
AM18.2 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM20.7 AM20.8
AM205 AM206
AM21.1 AM21.2
GDD-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM152 AM154
AM16.1 AM17.1
AM170 AM18.1
AM18.2 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM20.7 AM20.8
AM205 AM206
AM21.1 AM21.2
GDD-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM152 AM154
AM16.1 AM17.1
AM170 AM18.1
AM18.2 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM20.7 AM20.8
AM205 AM206
AM21.1 AM21.2
GDD-ADDR5
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM152 AM154
AM16.1 AM17.1
AM170 AM18.1
AM18.2 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM20.7 AM20.8
AM205 AM206
AM21.1 AM21.2
GDD-STATE-PROV
Element: State
Alpha 2
This field contains the two-character state code of the address.
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM152 AM154
AM16.1 AM17.1
AM170 AM18.1
AM18.2 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM20.7 AM20.8
AM205 AM206
AM21.1 AM21.2
GDD-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
This field contains the postal code.
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM152 AM154
AM16.1 AM17.1
AM170 AM18.1
AM18.2 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM20.7 AM20.8
AM205 AM206
AM21.1 AM21.2
GDD-POSTAL-DIST
Element: Postal Dist
Alpha 5
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM152 AM154
AM16.1 AM17.1
AM170 AM18.1
AM18.2 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM20.7 AM20.8
AM205 AM206
AM21.1 AM21.2
GDD-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM152 AM154
AM16.1 AM17.1
AM170 AM18.1
AM18.2 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM20.7 AM20.8
AM205 AM206
AM21.1 AM21.2
GDD-COUNTRY
Element: Country
Alpha 30 (Lower Case)
This field contains the country of the address, or it can be used for additional information such as an attention name.
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM152 AM154
AM16.1 AM17.1
AM170 AM18.1
AM18.2 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM20.7 AM20.8
AM205 AM206
AM21.1 AM21.2
GDD-USAGE-COUNT
Element: Usage Count
Numeric 12
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM152 AM154
AM16.1 AM17.1
AM170 AM18.1
AM18.2 AM180
AM185 AM19.1
AM19.2 AM190
AM192 AM195
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM20.7 AM20.8
AM205 AM206
AM21.1 AM21.2


ADDRDATA FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GDDSET1 ADDR-CODE
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145
GDDSET2 NAME
ADDR-CODE
GDDSET3 ADDR1
ADDR-CODE
GDDSET4 ADDR5
NAME
ADDR-CODE
GDDSET5 POSTAL-CODE
NAME
ADDR-CODE
GDDSET6 STATE-PROV
NAME
ADDR-CODE
GDDSET7 COUNTRY-CODE
NAME
ADDR-CODE
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145


ADDRDATA FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Gladdress GLADDRESS
GDD-ADDR-CODE->GAD-ADDR-CODE
  GAD-COMPANY
  GAD-ACCT-UNIT


File created: Wed Jun 08 20:49:42 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.