Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             GLADDRESS FILE

                         General Ledger Address

This file contains the name, address, and communication numbers for the
company and needed accounting units defined on the Address form tab in GL10.1
(Company).


REFERENCED BY

AC03.1    AC03.2    AC03.3    AC03.4    AC03.5    AC03.6
AC03.8    AC10.1    AC12.2    AC131     AC160     AC17.3
AC17.4    AC170     AC176     AC18.2    AC18.3    AC190
AC195     AC196     AC198     AC210     AC256     AC32.1
AC34.1    AC35.1    AC36.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
AC490     AC494     AC50.1    AC500     AC52.1    AC520
AC530     AC54.1    AC540     AC541     AC542     AC59.1
AC62.1    AC70.1    AC70.2    AC70.4    AC76.1    AC94.4
ACVW.1    AM01.1    AM01.2    AM01.3    AM05.1    AM06.1
AM06.2    AM06.3    AM06.5    AM09.1    AM115     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     AM220     AM221
AM222     AM223     AM224     AM225     AM230     AM235
AM240     AM241     AM245     AM25.1    AM250     AM251
AM252     AM255     AM260     AM265     AM266     AM270
AM275     AM277     AM278     AM280     AM281     AM282
AM285     AM290     AM292     AM295     AM30.1    AM30.2
AM30.3    AM300     AM310     AM320     AM35.1    AM40.1
AM40.2    AM40.3    AM41.1    AM45.1    AM500     AM51.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    AM93.1    AM95.1    AM95.4
AM95.5    AM95.6    AM96.1    AM97.1    AM98.1    AM99.1
AP00.4    AP01.1    AP05.1    AP05.2    AP05.7    AP05.8
AP115     AP130     AP150     AP151     AP155     AP156
AP161     AP166     AP170     AP175     AP176     AP180
AP181     AP185     AP190     AP191     AP193     AP195
AP200     AP201     AP220     AP255     AP260     AP265
AP275     AP28.1    AP28.2    AP30.2    AP30.4    AP305
AP32.2    AP520     AP55.1    AP55.2    AP56.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.2    AR30.3    AR30.4
AR30.6    AR30.8    AR31.5    AR31.6    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    AR82.1    BL00.1    BL123
BL199     BN00.1    BN00.2    BN15.1    BN150     BN190
BN20.1    BN80.1    BN81.1    BN81.2    BR121     BR41.1
BRIP.1    CB00.3    CB01.2    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     CB260
CB30.1    CB500     CB80.1    CB90.2    CB90.5    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    CA190
CA195     CA199     CA210     CA215     CA240     CA290
FB10.1    FB100     FB101     FB120     FB121     FB122
FB141     FB195     FB20.1    FB20.2    FB20.3    FB20.4
FB20.6    FB20.7    FB21.1    FB210     FB220     FB225
FB230     FB231     FB25.1    FB295     FB30.1    FB31.1
FB65.1    FB95.1    FB95.2    FB95.3    FB95.4    FB95.5
FB95.6    GL120     GL122     GL135     GL141     GL145
GL146     GL165     GL167     GL170     GL179     GL190
GL191     GL195     GL196     GL199     GL230     GL235
GL238     GL240     GL241     GL243     GL245     GL250
GL267     GL270     GL275     GL281     GL290     GL291
GL292     GL293     GL294     GL295     GL296     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    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     IC141     IC142     IC150     IC151     IC152
IC175     IC199     IC21.1    IC21.2    IC22.1    IC22.2
IC224     IC227     IC228     IC233     IC234     IC240
IC280     IC283     IC500     IC522     IC523     IC525
IC526     IC527     IC83.1    PC521     CU03.1    CU161
CU20.3    CU20.4    CU203     CU220     CU261     CU300
CU61.2    GL01.1    GL01.2    GL03.6    GL08.1    GL08.2
GL121     GL14.8    GL161     GL162     GL198     GL210
GL220     GL221     GL222     GL225     GL25.1    GL261
GL311     GL312     GL313     GL342     GL38.2    GL42.1
GL61.1    GL62.1    GLAV.1    GLCV.1    GLVW.1    IFCU.1
IFGT.1    IFOS.1    IFTR.1    MX135     MA01.1    MA05.3
MA05.6    MA126     MA205     MA231     MA310     MA63.1
MA65.1    MA68.1    PO01.1    PO135     PO136     PO199
PO26.1    POA2.4    POI7.1    POIH.1    POIJ.1    PR05.1
PR05.3    PR128     PR131     PR132     PR134     PR136
PR137     PR195     PR197     PR198     PR26.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    PR36.1
PR37.1    PR38.1    PR45.1    PR47.1    PR514     PR530
PR82.1    PR85.1    PRSA.1    UK102     UK330     RQ01.1
RQ11.1    RQ12.1    RQ13.1    RQ235     SLVW.1    TA195
UK120     IN120     IN20.1    TX00.1    TX04.1    TX100
TX40.1    WH130     WH33.1    WH33.2    WH33.3    WH33.4
WH33.5    WH33.6    WH33.8    WH33.9    WH34.1    WH34.2
WH34.3    WH34.4

UPDATED BY

GL110     GL10.1    GL124     GL20.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

GAD-COMPANY          Numeric 4                                   GL10.1  GL110
Company              The company number as defined in GL00.1     GL124   GL20.1
                     (Company).


GAD-ACCT-UNIT        Alpha 15                                    GL124   GL20.1
Accounting Unit      The valid Lawson General Ledger
                     accounting in GLNAMES.


GAD-NAME             Alpha 30  (Lower Case)                      GL10.1  GL124
Name                 Displays the company description.           GL20.1

GAD-ADDR1            Alpha 30  (Lower Case)                      GL10.1  GL124
Address 1            This field contains the first line of       GL20.1
                     address information.

GAD-ADDR2            Alpha 30  (Lower Case)                      GL10.1  GL124
Address 2            This field contains the second line of      GL20.1
                     address information.

GAD-ADDR3            Alpha 30  (Lower Case)                      GL10.1  GL124
Address 3            This field contains the third line of       GL20.1
                     address information.

GAD-ADDR4            Alpha 30  (Lower Case)                      GL10.1  GL124
Address 4            This field contains the fourth line of      GL20.1
                     address information.

GAD-ADDR5            Alpha 18  (Lower Case)                      GL10.1  GL124
City or Address 5    This field contains the fifth line of       GL20.1
                     address information. In the United
                     States, define the city.


GAD-STATE-PROV       Alpha 2                                     GL10.1  GL124
State or Province    The state or province.                      GL20.1

GAD-POSTAL-CODE      Alpha 10  (Lower Case)                      GL10.1  GL124
Postal Code          This field contains the postal code.        GL20.1

GAD-COUNTY           Alpha 25  (Lower Case)                      GL10.1  GL124
County               The county for the company address.         GL20.1

GAD-COUNTRY          Alpha 30  (Lower Case)                      GL10.1  GL124
Country or Other     This field contains the country of the      GL20.1
                     address, or it can be used for
                     additional information such as an
                     attention name.

GAD-ADDR-CONTACT     Alpha 30  (Lower Case)                      GL10.1  GL124
Contact              This is the name of the main contact.       GL20.1

GAD-PHONE-COUNTRY    Alpha 6                                     GL10.1  GL124
Telephone Country    This field contains the prefix of the       GL20.1
Code                 telephone number. For example, the
                     country or city code.


GAD-PHONE-NUMBER     Alpha 15                                    GL10.1  GL124
Telephone Number     Contains the telephone number,              GL20.1
                     including area code.


GAD-PHONE-EXT        Alpha 5                                     GL10.1  GL124
Telephone Extension  This field contains the telephone           GL20.1
                     extension number.

GAD-FAX-COUNTRY      Alpha 6                                     GL10.1  GL124
Fax Country          This field contains the prefix of the       GL20.1
                     fax number. For example, the country or
                     city code.


GAD-FAX-NUMBER       Alpha 15                                    GL10.1  GL124
Fax Number           This field contains the fax number.         GL20.1

GAD-FAX-EXT          Alpha 5                                     GL10.1  GL124
Fax Extension        This field contains the fax number          GL20.1
                     extension.


GAD-TELEX-NUMBER     Alpha 15                                    GL10.1  GL124
Telex Number         This is the telex number.                   GL20.1


GAD-OPT-FIELD1       Alpha 15  (Lower Case)                      GL10.1  GL124
Optional Field 1     This field lets you enter any               GL20.1
                     additional information you would like to
                     appear on the address.


GAD-OPT-FIELD2       Alpha 15  (Lower Case)                      GL10.1  GL124
Optional Field 2     This field lets you enter any additional    GL20.1
                     information you would like to appear on
                     the address.

GAD-OPT-FIELD3       Alpha 30  (Lower Case)                      GL10.1  GL124
Optional Field 3     This field lets you enter any additional    GL20.1
                     information you would like to appear on
                     the address.

GAD-COUNTRY-CODE     Alpha 2                                     GL10.1  GL124
Country Code         The country code.  Required for VAT and     GL20.1
                     intrastat reporting.  Must be defined in
                      IN01.1 (Country Maintenance).


                         GLADDRESS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GADSET1   COMPANY       This path accesses the accounting unit   AC03.1  AC03.2
          ACCT-UNIT     via company.                             AC03.3  AC03.4
                                                                 AC03.5  AC03.6
                                                                 AC03.8  AC10.1
                                                                 AC12.2  AC131
                                                                 AC160   AC17.3
                                                                 AC17.4  AC170
                                                                 AC176   AC18.2
                                                                 AC18.3  AC190
                                                                 AC195   AC196
                                                                 AC198   AC210
                                                                 AC256   AC32.1
                                                                 AC34.1  AC35.1
                                                                 AC36.1  AC40.1
                                                                 AC40.2  AC40.4
                                                                 ...

                         GLADDRESS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glnames        GLNAMES      Required
                            When GAD-ACCT-UNIT != Spaces

                            GAD-COMPANY      -> GLN-COMPANY
                            GAD-ACCT-UNIT    -> GLN-ACCT-UNIT

Glsystem       GLSYSTEM     Required

                            GAD-COMPANY      -> GLS-COMPANY