|
|
ADDRDATA FILE
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 AC113 AC12.2 AC121 AC123
AC130 AC131 AC145 AC160 AC17.3 AC17.4
AC18.2 AC18.3 AC190 AC191 AC195 AC197
AC198 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5
AC210 AC246 AC256 AC32.1 AC34.1 AC346
AC35.1 AC36.1 AC37.1 AC40.1 AC40.2 AC40.4
AC40.5 AC41.1 AC41.2 AC41.4 AC41.5 AC41.7
AC42.1 AC42.4 AC45.1 AC45.2 AC45.4 AC45.5
AC46.1 AC46.2 AC46.3 AC490 AC494 AC50.1
AC500 AC52.1 AC520 AC54.1 AC540 AC62.1
AC94.4 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 AM170 AM18.1 AM18.2
AM180 AM185 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 AM220 AM221 AM222 AM223
AM224 AM225 AM230 AM235 AM240 AM241
AM245 AM25.1 AM250 AM251 AM252 AM255
AM260 AM265 AM266 AM267 AM270 AM275
AM277 AM278 AM280 AM281 AM282 AM285
AM287 AM290 AM292 AM295 AM30.1 AM30.2
AM30.3 AM300 AM310 AM320 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
AP150 AP151 AP155 AP156 AP161 AP166
AP170 AP175 AP176 AP180 AP181 AP185
AP190 AP191 AP193 AP195 AP200 AP201
AP220 AP237 AP25.1 AP25.2 AP255 AP26.1
AP260 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 AR115
AR124 AR129 AR13.1 AR13.2 AR130 AR131
AR135 AR137 AR180 AR190 AR194 AR196
AR199 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1
AR250 AR251 AR252 AR253 AR255 AR256
AR271 AR28.1 AR29.1 AR29.2 AR29.3 AR290
AR30.1 AR30.6 AR30.8 AR31.5 AR31.6 AR33.1
AR33.3 AR33.5 AR33.6 AR34.1 AR34.2 AR35.1
AR35.2 AR37.1 AR37.2 AR37.3 AR37.4 AR37.5
AR37.6 AR37.7 AR42.1 AR42.2 AR42.6 AR42.7
AR43.1 AR44.3 AR48.3 AR502 AR504 AR560
AR570 AR575 AR580 AR75.1 AR80.1 AR80.2
AR82.1 ARLL.1 BL00.1 BL120 BL122 BL123
BL130 BL199 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 BN00.1
BN00.2 BN15.1 BN150 BN190 BN20.1 BN80.1
BN81.1 BN81.2 BR02.3 BR10.1 BR130 BR131
BR140 BR20.6 BR21.2 BR400 BR41.1 BR41.4
BR43.1 BR44.1 BR46.1 BR46.3 BR530 BR96.1
BRIP.1 CB00.3 CB01.2 CB01.4 CB03.1 CB03.2
CB05.1 CB06.1 CB06.2 CB10.1 CB10.3 CB15.1
CB15.2 CB175 CB180 CB185 CB190 CB191
CB195 CB20.1 CB210 CB215 CB220 CB221
CB25.1 CB260 CB30.1 CB500 CB80.1 CB90.2
CB90.5 CXCP.1 DT150 DT155 DT160 DT165
DT166 DT170 DT180 DT181 DT185 DT190
DT30.1 DT30.2 DT40.1 DT45.1 DT520 DT60.1
DT60.2 DT70.1 DT70.3 DT80.1 DT85.1 DT85.2
DT90.1 DT92.1 EE135 EE175 EE20.1 EE20.2
EE20.3 EE20.4 EE220 EE230 EE275 EE35.1
EE35.2 EE520 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 FB220
FB225 FB230 FB231 FB235 FB240 FB25.1
FB265 FB295 FB296 FB30.1 FB31.1 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 GL120 GL122 GL135 GL141
GL145 GL146 GL147 GL148 GL165 GL167
GL170 GL179 GL190 GL191 GL195 GL196
GL197 GL199 GL230 GL235 GL238 GL240
GL241 GL243 GL245 GL250 GL267 GL270
GL275 GL281 GL290 GL291 GL292 GL293
GL294 GL295 GL296 GL298 GL30.1 GL30.2
GL300 GL310 GL320 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 GL90.1 GL90.2 GL90.3 GL90.4
GL90.5 GL90.6 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 DR100 IC125
IC130 IC134 IC135 IC140 IC141 IC142
IC150 IC151 IC152 IC175 IC199 IC21.1
IC21.2 IC22.1 IC22.2 IC222 IC224 IC227
IC228 IC233 IC234 IC235 IC240 IC25.1
IC28.1 IC280 IC283 IC500 IC522 IC523
IC525 IC526 IC527 IC531 IC83.1 PC521
CU03.1 CU161 CU203 CU220 CU261 CU300
CU61.2 GL01.1 GL01.2 GL03.6 GL08.1 GL08.2
GL10.1 GL10.2 GL121 GL124 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 IFFC.1 IFGT.1
IFOS.1 MX135 MA01.1 MA01.2 MA05.3 MA05.6
MA126 MA180 MA205 MA231 MA310 MA530
MA531 MA54.1 MA540 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA66.3 MA67.1
MA67.2 MA68.1 MA70.1 MA75.1 MA80.1 MAI1.1
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE111 OE113 OE114 OE116 OE129
OE13.2 OE13.3 OE13.5 OE13.6 OE130 OE14.4
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE81.1 OE810
OE830 OE90.1 OE90.2 PA182 PBIP.1 PO01.1
PO100 PO101 PO122 PO131 PO135 PO136
PO150 PO199 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO25.1 PO25.5
PO25.6 PO25.7 PO26.1 PO27.2 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.1
PO32.2 PO33.1 PO34.1 PO35.1 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
POA2.4 POCP.1 POI3.1 POI7.1 POID.1 POIE.1
POIF.1 POIH.1 POII.1 POIJ.1 POIM.1 PR05.1
PR05.3 PR128 PR130 PR131 PR132 PR134
PR136 PR137 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 PR529 PR530 PR560 PR82.1 PR85.1
PRSA.1 UK102 UK330 UK47.1 MM280 RQ01.1
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ140 RQ235 RQ300 RQ35.1 RQ40.1
RQ41.1 RQ42.1 RQ44.1 RQ44.2 RQ500 RQIF.1
SL40.1 SL40.4 SLVW.1 TA147 TA195 TA196
TP135 IN01.1 IN120 TX00.1 TX04.1 TX100
TX101 TX202 TX226 TX301 TX40.1 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH25.1
WH25.2 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4 WH40.1 WH40.2 WH520 WH830 WO132
WO140 WO293 WODL.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GDD-ADDR-CODE Alpha 20 AC03.1 AC03.2
Element: Addr Code This is a code representing the address AC03.3 AC03.4
for the institution or the institution AC03.5 AC03.6
location. The address is stored in the AC03.7 AC10.1
ADDRDATA file. AC113 AC12.2
AC121 AC123
AC130 AC131
AC145 AC160
AC17.3 AC17.4
AC18.2 AC18.3
AC190 AC191
AC195 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC210 AC246
AC256 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC37.1 AC40.1
AC40.2 AC40.4
AC40.5 AC41.1
AC41.2 AC41.4
AC41.5 AC41.7
AC42.1 AC42.4
AC45.1 AC45.2
AC45.4 AC45.5
AC46.1 AC46.2
AC46.3 AC490
AC494 AC50.1
...
GDD-COUNTRY-CODE Alpha 2 AC03.1 AC03.2
Element: Country Code The country code. Required for VAT and AC03.3 AC03.4
intrastat reporting. Must be defined in AC03.5 AC03.6
IN01.1 (Country Maintenance). AC03.7 AC10.1
AC113 AC12.2
AC121 AC123
AC130 AC131
AC145 AC160
AC17.3 AC17.4
AC18.2 AC18.3
AC190 AC191
AC195 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC210 AC246
AC256 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC37.1 AC40.1
AC40.2 AC40.4
AC40.5 AC41.1
AC41.2 AC41.4
AC41.5 AC41.7
AC42.1 AC42.4
AC45.1 AC45.2
AC45.4 AC45.5
AC46.1 AC46.2
AC46.3 AC490
AC494 AC50.1
...
GDD-NAME Alpha 30 (Lower Case) AC03.1 AC03.2
Element: Name Displays the company description. AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC113 AC12.2
AC121 AC123
AC130 AC131
AC145 AC160
AC17.3 AC17.4
AC18.2 AC18.3
AC190 AC191
AC195 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC210 AC246
AC256 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC37.1 AC40.1
AC40.2 AC40.4
AC40.5 AC41.1
AC41.2 AC41.4
AC41.5 AC41.7
AC42.1 AC42.4
AC45.1 AC45.2
AC45.4 AC45.5
AC46.1 AC46.2
AC46.3 AC490
AC494 AC50.1
...
GDD-ADDR1 Alpha 30 (Lower Case) AC03.1 AC03.2
Element: Address 1 This field contains the first line of AC03.3 AC03.4
address information. AC03.5 AC03.6
AC03.7 AC10.1
AC113 AC12.2
AC121 AC123
AC130 AC131
AC145 AC160
AC17.3 AC17.4
AC18.2 AC18.3
AC190 AC191
AC195 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC210 AC246
AC256 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC37.1 AC40.1
AC40.2 AC40.4
AC40.5 AC41.1
AC41.2 AC41.4
AC41.5 AC41.7
AC42.1 AC42.4
AC45.1 AC45.2
AC45.4 AC45.5
AC46.1 AC46.2
AC46.3 AC490
AC494 AC50.1
...
GDD-ADDR2 Alpha 30 (Lower Case) AC03.1 AC03.2
Element: Address 1 This field contains the second line of AC03.3 AC03.4
address information. AC03.5 AC03.6
AC03.7 AC10.1
AC113 AC12.2
AC121 AC123
AC130 AC131
AC145 AC160
AC17.3 AC17.4
AC18.2 AC18.3
AC190 AC191
AC195 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC210 AC246
AC256 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC37.1 AC40.1
AC40.2 AC40.4
AC40.5 AC41.1
AC41.2 AC41.4
AC41.5 AC41.7
AC42.1 AC42.4
AC45.1 AC45.2
AC45.4 AC45.5
AC46.1 AC46.2
AC46.3 AC490
AC494 AC50.1
...
GDD-ADDR3 Alpha 30 (Lower Case) AC03.1 AC03.2
Element: Address 1 This field contains the third line of AC03.3 AC03.4
address information. AC03.5 AC03.6
AC03.7 AC10.1
AC113 AC12.2
AC121 AC123
AC130 AC131
AC145 AC160
AC17.3 AC17.4
AC18.2 AC18.3
AC190 AC191
AC195 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC210 AC246
AC256 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC37.1 AC40.1
AC40.2 AC40.4
AC40.5 AC41.1
AC41.2 AC41.4
AC41.5 AC41.7
AC42.1 AC42.4
AC45.1 AC45.2
AC45.4 AC45.5
AC46.1 AC46.2
AC46.3 AC490
AC494 AC50.1
...
GDD-ADDR4 Alpha 30 (Lower Case) AC03.1 AC03.2
Element: Address 1 This field contains the fourth line of AC03.3 AC03.4
address information. AC03.5 AC03.6
AC03.7 AC10.1
AC113 AC12.2
AC121 AC123
AC130 AC131
AC145 AC160
AC17.3 AC17.4
AC18.2 AC18.3
AC190 AC191
AC195 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC210 AC246
AC256 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC37.1 AC40.1
AC40.2 AC40.4
AC40.5 AC41.1
AC41.2 AC41.4
AC41.5 AC41.7
AC42.1 AC42.4
AC45.1 AC45.2
AC45.4 AC45.5
AC46.1 AC46.2
AC46.3 AC490
AC494 AC50.1
...
GDD-ADDR5 Alpha 18 (Lower Case) AC03.1 AC03.2
Element: City This field contains the fifth line of AC03.3 AC03.4
address information. In the United AC03.5 AC03.6
States, define the city. AC03.7 AC10.1
AC113 AC12.2
AC121 AC123
AC130 AC131
AC145 AC160
AC17.3 AC17.4
AC18.2 AC18.3
AC190 AC191
AC195 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC210 AC246
AC256 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC37.1 AC40.1
AC40.2 AC40.4
AC40.5 AC41.1
AC41.2 AC41.4
AC41.5 AC41.7
AC42.1 AC42.4
AC45.1 AC45.2
AC45.4 AC45.5
AC46.1 AC46.2
AC46.3 AC490
AC494 AC50.1
...
GDD-STATE-PROV Alpha 2 AC03.1 AC03.2
Element: State or ProviThe state or province. AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC113 AC12.2
AC121 AC123
AC130 AC131
AC145 AC160
AC17.3 AC17.4
AC18.2 AC18.3
AC190 AC191
AC195 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC210 AC246
AC256 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC37.1 AC40.1
AC40.2 AC40.4
AC40.5 AC41.1
AC41.2 AC41.4
AC41.5 AC41.7
AC42.1 AC42.4
AC45.1 AC45.2
AC45.4 AC45.5
AC46.1 AC46.2
AC46.3 AC490
AC494 AC50.1
...
GDD-POSTAL-CODE Alpha 10 (Lower Case) AC03.1 AC03.2
Element: Postal Code This field contains the postal code. AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC113 AC12.2
AC121 AC123
AC130 AC131
AC145 AC160
AC17.3 AC17.4
AC18.2 AC18.3
AC190 AC191
AC195 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC210 AC246
AC256 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC37.1 AC40.1
AC40.2 AC40.4
AC40.5 AC41.1
AC41.2 AC41.4
AC41.5 AC41.7
AC42.1 AC42.4
AC45.1 AC45.2
AC45.4 AC45.5
AC46.1 AC46.2
AC46.3 AC490
AC494 AC50.1
...
GDD-POSTAL-DIST Alpha 5 AC03.1 AC03.2
Element: Postal Dist AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC113 AC12.2
AC121 AC123
AC130 AC131
AC145 AC160
AC17.3 AC17.4
AC18.2 AC18.3
AC190 AC191
AC195 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC210 AC246
AC256 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC37.1 AC40.1
AC40.2 AC40.4
AC40.5 AC41.1
AC41.2 AC41.4
AC41.5 AC41.7
AC42.1 AC42.4
AC45.1 AC45.2
AC45.4 AC45.5
AC46.1 AC46.2
AC46.3 AC490
AC494 AC50.1
...
GDD-COUNTY Alpha 25 (Lower Case) AC03.1 AC03.2
Element: County The county for the company address. AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC113 AC12.2
AC121 AC123
AC130 AC131
AC145 AC160
AC17.3 AC17.4
AC18.2 AC18.3
AC190 AC191
AC195 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC210 AC246
AC256 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC37.1 AC40.1
AC40.2 AC40.4
AC40.5 AC41.1
AC41.2 AC41.4
AC41.5 AC41.7
AC42.1 AC42.4
AC45.1 AC45.2
AC45.4 AC45.5
AC46.1 AC46.2
AC46.3 AC490
AC494 AC50.1
...
GDD-COUNTRY Alpha 30 (Lower Case) AC03.1 AC03.2
Element: Country or OthThis field contains the country of the AC03.3 AC03.4
address, or it can be used for AC03.5 AC03.6
additional information such as an AC03.7 AC10.1
attention name. AC113 AC12.2
AC121 AC123
AC130 AC131
AC145 AC160
AC17.3 AC17.4
AC18.2 AC18.3
AC190 AC191
AC195 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC210 AC246
AC256 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC37.1 AC40.1
AC40.2 AC40.4
AC40.5 AC41.1
AC41.2 AC41.4
AC41.5 AC41.7
AC42.1 AC42.4
AC45.1 AC45.2
AC45.4 AC45.5
AC46.1 AC46.2
AC46.3 AC490
AC494 AC50.1
...
GDD-USAGE-COUNT Numeric 12 AC03.1 AC03.2
Element: Usage Count AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC113 AC12.2
AC121 AC123
AC130 AC131
AC145 AC160
AC17.3 AC17.4
AC18.2 AC18.3
AC190 AC191
AC195 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC210 AC246
AC256 AC32.1
AC34.1 AC346
AC35.1 AC36.1
AC37.1 AC40.1
AC40.2 AC40.4
AC40.5 AC41.1
AC41.2 AC41.4
AC41.5 AC41.7
AC42.1 AC42.4
AC45.1 AC45.2
AC45.4 AC45.5
AC46.1 AC46.2
AC46.3 AC490
AC494 AC50.1
...
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
AC113 AC12.2
AC121 AC123
AC130 AC131
AC145 AC160
AC17.3 AC17.4
AC18.2 AC18.3
AC190 AC191
AC195 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
...
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 AC03.1 AC03.2
NAME AC03.3 AC03.4
ADDR-CODE AC03.5 AC03.6
AC03.7 AC10.1
AC113 AC12.2
AC121 AC123
AC130 AC131
AC145 AC160
AC17.3 AC17.4
AC18.2 AC18.3
AC190 AC191
AC195 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
...
ADDRDATA FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Gladdress GLADDRESS
GDD-ADDR-CODE -> GAD-ADDR-CODE
GAD-COMPANY
GAD-ACCT-UNIT
|
