Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ADDRDATA


                             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