Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLSYSTEM


                             GLSYSTEM FILE

                         General Ledger Company

This file contains company information used by the Lawson General Ledger
system and subsystems defined in GL10.1 (Company).


REFERENCED BY

AC03.1    AC03.2    AC03.3    AC03.4    AC03.5    AC03.6
AC03.8    AC10.1    AC113     AC12.2    AC121     AC123
AC127     AC130     AC131     AC160     AC17.3    AC17.4
AC176     AC18.2    AC18.3    AC190     AC191     AC192
AC195     AC196     AC198     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC20.6    AC20.7    AC210     AC256
AC27.1    AC298     AC32.1    AC34.1    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.2
AC42.4    AC45.1    AC45.2    AC45.4    AC45.5    AC490
AC494     AC50.1    AC500     AC52.1    AC520     AC53.1
AC530     AC54.1    AC54.2    AC54.3    AC540     AC541
AC542     AC550     AC581     AC59.1    AC62.1    AC76.1
AC81.1    AC94.4    AC98.2    ACAC.1    ACVW.1    AM01.1
AM01.2    AM01.3    AM05.1    AM06.1    AM06.2    AM06.3
AM06.5    AM06.6    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    AM200     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     AM330     AM35.1    AM40.1    AM40.2    AM40.3
AM40.4    AM41.1    AM41.2    AM45.1    AM500     AM501
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    AM93.1
AM95.1    AM95.4    AM95.5    AM95.6    AM96.1    AM97.1
AM98.1    AM99.1    AP00.3    AP00.4    AP00.7    AP01.1
AP05.1    AP05.2    AP05.7    AP05.8    AP10.1    AP10.2
AP10.5    AP10.6    AP110     AP115     AP125     AP126
AP130     AP131     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     AP210
AP213     AP220     AP23.1    AP25.1    AP25.2    AP255
AP26.1    AP260     AP265     AP27.1    AP275     AP28.1
AP28.2    AP284     AP30.2    AP30.3    AP30.4    AP305
AP32.2    AP510     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    API3.1    API4.1    API5.1
AR01.1    AR08.1    AR10.1    AR100     AR105     AR115
AR12.1    AR12.2    AR124     AR129     AR13.1    AR13.2
AR130     AR131     AR135     AR137     AR14.1    AR15.4
AR150     AR160     AR161     AR170     AR180     AR190
AR191     AR194     AR196     AR199     AR20.1    AR21.1
AR21.2    AR21.3    AR21.4    AR230     AR232     AR24.1
AR25.1    AR250     AR251     AR252     AR253     AR255
AR256     AR258     AR271     AR275     AR28.1    AR286
AR287     AR29.1    AR29.2    AR29.3    AR290     AR30.1
AR30.2    AR30.3    AR30.4    AR30.6    AR30.7    AR30.8
AR30.9    AR31.1    AR31.5    AR31.6    AR35.1    AR35.2
AR36.1    AR37.1    AR37.2    AR37.3    AR37.4    AR37.5
AR37.6    AR37.7    AR42.1    AR42.2    AR42.6    AR42.7
AR42.8    AR43.1    AR44.3    AR45.1    AR48.3    AR50.1
AR501     AR502     AR503     AR504     AR507     AR53.1
AR550     AR560     AR570     AR575     AR580     AR70.1
AR70.2    AR72.1    AR75.1    AR82.1    AR90.1    BN00.1
BN00.2    BN100     BN101     BN102     BN103     BN104
BN105     BN145     BN15.1    BN150     BN190     BN20.1
BN245     BN31.1    BN31.2    BN32.1    BN32.2    BN32.3
BN45.1    BN531     BN65.1    BN66.1    BN71.1    BN72.1
BN80.1    BN81.1    BN81.2    BS13.1    BS14.1    BS15.1
BS32.1    BR00.2    BR10.1    BR10.2    BR11.1    BR120
BR121     BR122     BR123     BR124     BR130     BR131
BR15.2    BR151     BR152     BR153     BR154     BR155
BR156     BR16.1    BR20.6    BR252     BR40.3    BR400
BR41.1    BR41.4    BR420     BR43.1    BR47.1    BR51.1
BR51.2    BR52.1    BR52.2    BR52.4    BR52.5    BR521
BR530     BR55.2    BR65.1    BR65.2    BR901     BRCC.1
BRIP.1    BRPI.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
CB25.1    CB260     CB30.1    CB500     CB80.1    CB90.2
CB90.5    CXCP.1    DT150     DT155     DT160     DT161
DT165     DT166     DT170     DT180     DT181     DT185
DT190     DT220     DT30.1    DT30.2    DT40.1    DT45.1
DT52.1    DT520     DT60.1    DT60.2    DT70.1    DT70.3
DT80.1    DT80.4    DT85.1    DT85.2    DT90.1    DT90.3
DT92.1    EE05.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    CA195     CA199     CA200     CA210
CA215     CA240     CA290     FB10.1    FB100     FB101
FB11.1    FB11.2    FB111     FB120     FB121     FB122
FB141     FB165     FB195     FB20.1    FB20.2    FB20.3
FB20.4    FB20.6    FB20.7    FB21.1    FB210     FB211
FB220     FB225     FB230     FB231     FB240     FB25.1
FB265     FB295     FB296     FB30.1    FB31.1    FB40.1
FB40.2    FB40.3    FB40.4    FB40.5    FB65.1    FB95.1
FB95.2    FB95.3    FB95.4    FB95.5    FB95.6    GL122
GL130     GL135     GL141     GL145     GL147     GL165
GL179     GL195     GL196     GL230     GL235     GL238
GL240     GL241     GL243     GL245     GL247     GL250
GL256     GL267     GL270     GL275     GL281     GL284
GL285     GL286     GL287     GL288     GL289     GL290
GL291     GL292     GL293     GL294     GL295     GL296
GL297     GL298     GL30.1    GL30.2    GL300     GL320
GL325     GL326     GL327     GL328     GL330     GL36.1
GL41.1    GL41.3    GL41.4    GL43.1    GL50.1    GL50.2
GL50.4    GL50.5    GL55.1    GL65.1    GL65.3    GL67.1
GL70.1    GL70.2    GL70.3    GL70.5    GL70.6    GL700
GL90.1    GL90.2    GL90.3    GL90.4    GL90.5    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    GLSR.1    JB240
RW00.1    RW00.2    RW00.4    RW10.2    RW10.3    RW10.4
RW10.6    RW10.7    RW100     RW20.5    RW20.6    RW200
RW210     RW220     RW230     RW240     RW260     RW270
RW299     RW30.1    RW40.1    RW40.2    RW60.1    RW60.4
RW70.1    RW80.1    HCGL.1    HGDT.1    HGLS.1    HR00.1
HR01.1    HR02.1    HR11.1    HR11.2    HR200     HR511
HR650     ZR621     DR100     IC01.1    IC02.1    IC10.1
IC10.2    IC11.1    IC12.1    IC125     IC130     IC134
IC135     IC140     IC141     IC142     IC150     IC151
IC152     IC175     IC199     IC20.1    IC20.2    IC21.1
IC21.2    IC22.1    IC22.2    IC222     IC224     IC227
IC228     IC23.1    IC23.2    IC233     IC234     IC24.1
IC24.2    IC240     IC25.1    IC28.1    IC280     IC282
IC283     IC285     IC330     IC500     IC522     IC523
IC525     IC526     IC527     IC531     IC81.1    IC811
IC812     IC82.1    IC83.1    IC84.1    IC840     ICLC.1
PC521     CU01.1    CU01.2    CU03.1    CU161     CU20.3
CU20.4    CU203     CU220     CU261     CU300     CU61.2
GL01.1    GL01.2    GL03.6    GL08.1    GL08.2    GL11.1
GL121     GL123     GL124     GL14.8    GL16.4    GL161
GL162     GL201     GL208     GL210     GL211     GL220
GL221     GL222     GL223     GL225     GL23.1    GL24.1
GL25.1    GL261     GL311     GL312     GL313     GL342
GL38.2    GL42.1    GL61.1    GL62.1    GL721     GLAV.1
GLCV.1    GLEX.1    GLOP.1    GLRV.1    GLVW.1    IFAC.1
IFBO.1    IFCU.1    IFFC.1    IFGT.1    IFOS.1    IFOS.3
IFSG.1    JB00.1    JB00.2    JB00.3    JB00.4    JB200
MX135     MA01.1    MA01.2    MA05.3    MA05.6    MA08.1
MA126     MA180     MA205     MA208     MA231     MA310
MA41.1    MA41.2    MA41.4    MA41.7    MA43.1    MA43.2
MA43.3    MA43.4    MA43.5    MA43.7    MA43.8    MA43.9
MA53.1    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    MA730
MA75.1    MA80.1    MAI1.1    MLRV.1    PA02.1    PA100
PA102     PA13.1    PA13.2    PA213     PA502     PA513
PA52.1    PA52.3    PA52.4    PA52.5    PBIP.1    PO01.1
PO100     PO101     PO122     PO130     PO131     PO132
PO135     PO136     PO139     PO150     PO199     PO20.1
PO21.1    PO21.2    PO21.3    PO21.4    PO21.5    PO22.1
PO220     PO229     PO23.1    PO25.1    PO25.5    PO25.6
PO25.7    PO26.1    PO27.2    PO29.1    PO295     PO30.1
PO30.2    PO30.3    PO300     PO31.1    PO31.2    PO32.1
PO32.2    PO33.1    PO34.1    PO35.1    PO36.1    PO36.2
PO38.1    PO39.1    PO39.2    PO44.1    PO50.1    PO52.1
PO520     PO536     POA2.4    POCP.1    POD0.1    POED.1
POI3.1    POI7.1    POID.1    POIF.1    POIG.1    POIH.1
POII.1    POIJ.1    POIM.1    POIT.1    PR05.1    PR05.3
PR05.6    PR05.7    PR110     PR113     PR120     PR128
PR13.1    PR13.2    PR13.5    PR13.6    PR13.8    PR130
PR131     PR132     PR134     PR136     PR137     PR14.1
PR140     PR15.1    PR15.2    PR189     PR195     PR196
PR197     PR198     PR20.4    PR205     PR226     PR23.1
PR247     PR26.1    PR26.2    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    PR36.1    PR37.1
PR38.1    PR39.1    PR39.2    PR45.1    PR47.1    PR47.2
PR514     PR529     PR530     PR560     PR80.1    PR80.3
PR82.1    PR85.1    PR89.1    PRSA.1    UK102     UK330
UK47.1    UK47.2    UK560     MM280     MM80.1    MM80.2
RQ01.1    RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ12.1
RQ13.1    RQ140     RQ235     RQ300     RQ35.1    RQ40.1
RQ41.1    RQ42.1    RQ44.1    RQ44.2    RQ500     RQD0.1
RQIB.1    RQIC.1    RQID.1    RQIE.1    RQIF.1    RQIG.1
RQIJ.1    SL40.1    SL40.4    SLSE.1    SLSR.1    SLVW.1
TA147     TA195     TA196     TE01.3    UK120     IN08.1
IN120     IN20.1    TX00.1    TX04.1    TX100     TX202
TX204     TX226     TX40.1    TX804     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     WO30.1    WODL.1    GL00.2    GL00.7    CU00.1

UPDATED BY

CA190     FB145     FB190     FB45.1    GL110     GL120
GL146     GL167     GL170     GL190     GL191     GL197
GL199     GL310     GL40.1    GL40.2    GL40.3    GL40.7
GL40.8    GL44.1    GL45.1    GL500     GL75.1    GL10.1
GL10.2    GL198     GL20.6

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GLS-COMPANY            Numeric 4                                 GL10.1  GL110
Element: Company       The number that identifies a company. A   GL20.1  GL240
                       company represents a business or legal    RW100
                       entity of an organization.


GLS-NAME               Alpha 30  (Lower Case)                    GL10.1  GL110
Element: Name          This is the company name or               GL210
                       description.

GLS-BS-ACCT-UNIT       Alpha 15                                  GL20.6
Element: Base AccountinThe accounting unit name which is a
                       unique location within the company.


GLS-NBR-ACCT-PERS      Numeric 2                                 GL10.1
Number of              The number of periods for a company
Accounting Periods     fiscal year. Valid values are 1 - 13.

                       01
                       13

GLS-ACCT-PERIOD        Numeric 2                                 GL10.1  GL167
Element: Accounting PerThis is the current accounting period.    GL198   GL199
                       This field is updated by GL199 (Period    GL500
                       Closing).

                       01
                       13

GLS-COND-DFT-PRD       Derived
Element: Default PeriodThis field determines the period for
                       viewing when using the Drill Around
                       Chart Name feature.


GLS-FISCAL-YEAR        Numeric 4                                 GL10.1  GL198
Element: Fiscal Year   This is the current fiscal year.  This    GL199   GL500
                       field is updated by Period Closing        RW200   RW299
                       (GL199).

GLS-LAST-FISC-YR       Derived
Element: Last Fiscal YeThe last fiscal year.

GLS-NEXT-FISC-YR       Derived
Element: Next Fiscal YeThe next fiscal year.

GLS-LST-YR-CLOSED      Numeric 4
Element: Last Year ClosThis field is updated by GL199 with the
                       last year when using limited closing.
                       When the last year is closed final, this
                       field is set back to zero. Changes to
                       the retained earnings account number are
                       prohibited if this field is not equal to
                       zero.


GLS-PER-END-DATE       Numeric 8  (yyyymmdd) Occurs 39 Times     GL10.1  GL198
Element: Period End DatRequired for the number of account        GL199   GL500
                       periods for each year (current, last,
                       next). This period ending date is used
                       to determine the period to which
                       transactions are posted.
                       Occurrence 1-13 = Current period ending
                       dates.
                       Occurrence 14-26 = Last year period
                       ending dates.
                       Occurrence 27-39 = Next year period
                       ending dates.
                       These dates are changed by GL199 (Period
                       Closing) when closing period 12 of the
                       current year. The current year dates
                       become last year dates, next year dates
                       become current year dates, and new next
                       year dates are calculated.






GLS-PER-END-CODE       Alpha 1 Occurs 39 Times                   GL10.1  GL10.2
Element: Period End CodThis field is used to indicate the        GL110   GL167
                       closing status for each period.           GL198   GL199
                       Occurrence 1-13 = Current year period     GL500
                       ending code.
                       Occurrence 14-26 = Last year period
                       ending code.
                       Occurrence 27-39 = Next year period
                       ending code.
                       These fields are updated by GL199
                       (Period Closing) and Backposting
                       Control. If closing the period, the
                       period end code is set to indicate a
                       limited close or a final close. If
                       closing for a year, the period end code
                       will be set to indicate a limited or
                       final close, and also current year is
                       changed to last year, next year is
                       changed to current year, and next year
                       is set to spaces.





                       B = Backpost
                       F = Final
                       L = Limited
                       " " = Open

GLS-CONTROL-CODE       Alpha 1                                   GL10.1
Element: Control Group This field is used to indicate whether
                       control totals are required for journal
                       entries before releasing.

                       If you select Yes in the Control Totals
                       field on the Journals form tab in
                       GL10.1, GL40.1 (Journal Entry) will use
                       required control totals, which are set
                       up using GL45 (Journal Control).


                       N = No
                       Y = Yes

GLS-INTLV-BAL-FLG      Alpha 1                                   GL10.1
Interlevel Balance     Indicates if interzone balancing is
Flag                   used. If interzone balancing is used, a
                       base zone must be defined.

                       N = No
                       Y = Yes

GLS-CURRENCY-TABLE     Alpha 12                                  GL10.1
Element: Currency TableThe currency table name. Currency
                       tables are assigned to companies and
                       define currency exchange and translation
                       information. Currency tables are defined
                       in CU00.1 (Currency Table).


GLS-CURR-CONV-FLG      Alpha 1                                   GL10.1
Element: Curr Exchange Not required.
                       Y = Yes
                       N = No

GLS-CURR-TRAN-FLG      Alpha 1                                   GL10.1
Currency               Used to control currency translation
Translation Flag       processing.

                       Y = Yes
                       N = No

GLS-CURRENCY-CODE      Alpha 5                                   GL10.1  GL110
Element: Currency Code This is the company base currency code
                       as defined in CU01.1 (Currency Code).


GLS-COMPANY-ND         Numeric 1                                 GL10.1  GL110
Element: Number of DeciDecimal positions in the company
                       currency code amount fields.


GLS-IS-ACCT-UNIT       Alpha 15                                  GL20.6
Element: Is Acct Unit

GLS-ACTIVE-STATUS      Alpha 1                                   GL10.1
Element: Active Status The active status field is used to
                       display the development status of a
                       company.

                       D = Delete
                       L = Live
                       T = Test
                       C = Consolidation
                       E = Elimination

GLS-AVG-DAILY-BAL      Alpha 1                                   GL110
Average Daily          Not required.
Balance                N = No
                       Y = Yes
                       " " = No

GLS-AUTO-JE-NBR        Alpha 1                                   GL10.1
Auto Journal Entry     If you select Yes in the Auto Journal
Number                 Numbering field on the Journals form tab
                       in GL10, GL40 (Journal Entry) will
                       assign journal entry numbers
                       automatically using the Last JE Used
                       Field.

                       N = No
                       Y = Yes

GLS-LEVEL-DESC         Alpha 12  (Lower Case)                    GL10.1
Element: Level DescriptOccurs 5 Times
                       This is the level description.

GLS-NBR-DIGITS         Numeric 2 Occurs 5 Times                  GL10.1  GL120
Element: Number Digits This is the level size.                   GL124   GL161
                       00                                        GL190   GL20.1
                       15                                        GL240

GLS-LVL-ONE-DIGIT      Derived
Element: Level One DigiDisplays the array value.

GLS-GL190-RUN-DT.html">GL190-RUN-DT       Numeric 8  (yyyymmdd)                     GL190
Element: GL190 Run DateThis is the date that GL190 (Journal
                       Posting) was run. Updated each time
                       GL190 is run.


GLS-GL190-RUN-TM.html">GL190-RUN-TM       Numeric 6  (hhmmss)                       GL190
Element: GL190 Run TimeThis is the last time that GL190
                       (Journal Posting) was run. Updated each
                       time GL190 is run.


GLS-POSTED-TH-DT       Numeric 8  (yyyymmdd)                     GL190
Element: Posted ThroughThis is the last posted- through date
                       used by GL190 (Journal Posting).


GLS-PROJ-ACCT-FLG      Alpha 1
Element: Activity Flag This field is for the Activity system
                       only. It reports the option chosen for
                       the Edit Account Number field.

                       Valid values are:

                       Blank = No Activity system company
                       exists.

                       E = The Activity company exists. Edit
                       Account  Number is Yes. Edits are done
                       validating the account for the project.

                       Y = The Activity company exists. Edit
                       Account  Number is No. Transactions will
                       post to Activities if the project is
                       defined in the Activity system, but no
                       edits for  account validation are
                       performed.




                       N = No

GLS-BASE-ZONE          Alpha 15                                  GL10.1
Element: Base Zone     This is the default base zone used to
                       create interzone balancing transactions.



GLS-BACKPOST           Alpha 1 Occurs 26 Times                   GL110   GL190
Element: Backpost      This field is used to indicate if         GL198   GL199
                       backposting occurred for a period.        GL45.1  GL500
                       Occurrence 1-13 = Current year periods.

                       Occurrence 14-26 = Last year periods.

                       * = Backposting has occurred

GLS-GL150-RUN-DTE      Numeric 8  (yyyymmdd)
Element: Run Date      Indicates the last time that
                       Consolidation File Creation was run.


GLS-CHART-NAME         Alpha 12                                  GL10.1  GL110
Element: Chart Name    This is the name you assigned to the
                       chart of accounts when you defined your
                       company structure in the General Ledger
                       system.


GLS-DEFAULT-PERIOD     Numeric 2                                 GL10.1
Element: Default PeriodThis field determines the period for
                       viewing when using the Drill Around
                       Chart Name feature.

                       00
                       13

GLS-JOURNAL-BY-DOC     Alpha 1                                   GL10.1
Element: Journal by DocDetermines if each interfaced document
                       (for example an invoice) is assigned a
                       journal number. No is the  default
                       value.

                       N = No
                       Y = Yes

GLS-UPDATING           Numeric 2                                 CA190   FB145
Element: Updating      This will be set with a value when an     FB190   FB45.1
                       update program is running in GL.  The     GL110   GL120
                       value will determine the program that is  GL146   GL170
                       running.  No other updates may take       GL190   GL191
                       place while this field is not blank.      GL197   GL199
                                                                 GL40.1  GL40.2
                       00 = None                                 GL40.3  GL40.7
                       01 = GL170 Running                        GL40.8  GL44.1
                       02 = GL146 Running                        GL45.1  GL75.1
                       03 = CA190 Running
                       04 = GL190 Running
                       05 = GL199 Running
                       06 = GL110 Running
                       07 = GL120 Running
                       08 = GL191 Running
                       09 = AD190 Running
                       10 = AD191 Running
                       11 = GL45 Running
                       12 = GL40 Running
                       13 = GL75 Running
                       14 = GL161 Running

GLS-CLOSE-SEQ          Numeric 2 Occurs 39 Times                 GL110   GL167
Element: Close SequenceThe sequence number of the entry.         GL199

GLS-LEVEL-DEPTH        Numeric 1                                 GL10.1
Element: Level Depth   The company can contain up to 5 levels
                       of accounting units.

                       1 = One Level
                       2 = Two Levels
                       3 = Three Levels
                       4 = Four Levels
                       5 = Five Levels

GLS-JRNL-BOOK-REQ      Alpha 1                                   GL10.1
Journal Book           This field determines whether a Journal
Required               Book value must be assigned to all
                       General Ledger transactions.

                       N = No
                       Y = Yes

GLS-SEQ-TRNS-CD        Alpha 1                                   GL10.1
Element: Seq Trans CodeDetermines whether each General Ledger
                       transaction created must be assigned a
                       unique transaction sequence number by
                       the system.

                       J = by Journal Book
                       C = by Company
                       N = Not Required

GLS-RESET-SEQ-NBR      Alpha 1                                   GL10.1
Element: Reset Seq NumbThis field determines whether the
                       Transaction Sequence Number is reset at
                       year-end or continues.

                       N = No
                       Y = Yes

GLS-CHG-POST-TRAN      Alpha 1                                   GL10.1
Element: Change Post TrThis field determines whether posted
                       journal entries can be backed out, or
                       unposted, in GL45.1 (Journal Control) or
                       GL146 (Journal Backout and Unrelease).

                       N = No
                       Y = Yes

GLS-CHG-REL-TRAN       Alpha 1                                   GL10.1
Element: Change Rel TraThis field determines whether released
                       journal entries can be unreleased in
                       GL45.1 (Journal Control) or GL146
                       (Journal Backout and Unrelease).

                       N = No
                       Y = Yes

GLS-ERROR-SP-JBOOK     Alpha 12                                  GL10.1
Error Suspense         This field represents the Journal Book
Journal Book           value assigned to system-generated Error
                       Suspense entries.


GLS-YEAR-END-JBOOK     Alpha 12                                  GL10.1
Year End Journal       This field represents the Journal Book
Book                   value assigned to transactions created
                       by the system at year-end.


GLS-AUTO-JBK-SEQ       Alpha 1                                   GL10.1
Element: Auto Jbk Seq  This field determines if internal or
                       interfaced journal book entries should
                       be numbered sequentially by the system
                       as they are added.


GLS-SNGL-ACCT-TYPE     Alpha 1                                   GL10.1
Element: Sngl Acct TypeIndicates if an account must be either
                       all credits or all debits.


GLS-JE-APPROVE-AMT     Signed 15.2                               GL10.1
Element: Adj Amt

GLS-WORKFLOW-FLAG      Alpha 1                                   GL10.1
Element: All Flag

GLS-CURR-NAME-1        Alpha 12                                  GL10.1  GL110
Element: Name User                                               GL240   GL310

GLS-CURR-CODE-1        Alpha 5                                   GL10.1  GL110
Element: Currency Code                                           GL310

GLS-CURR-CODE-ND-1     Numeric 1                                 GL10.1  GL310
Account Currency
Code

GLS-CURR-NAME-2        Alpha 12                                  GL10.1  GL110
Element: Name User                                               GL240   GL310

GLS-CURR-CODE-2        Alpha 5                                   GL10.1  GL110
Report Currency 2      Type the currency code you want to        GL310
Code                   associate with the report currency name.

                       The currency code must exist in CU01.1
                       (Currency Codes).



GLS-CURR-CODE-ND-2     Numeric 1                                 GL10.1  GL310
Account Currency
Code

GLS-AUTO-BASE-BAL      Alpha 1                                   GL10.1
Element: Auto Base Bal Indicates whether the company requires
                       journal autobalancing in company base
                       currency.


GLS-CURR-RE-FLAG       Alpha 1                                   GL10.1
Element: Currency LedgeThis field is used to track journal
                       entry amounts by the transaction
                       currency in addition to the company base
                       currency.


GLS-BUD-EDIT-RANGE     Alpha 1                                   GL10.1  GL110
Element: Bud Edit RangeThis field indicates the budget range
                       against which GL commitments should be
                       edited. The valid values are:
                       N = No Edit
                       P = Period
                       Y = Year-To-Date
                       A = Annual

GLS-BUD-EDIT-TYPE      Alpha 1                                   GL10.1  GL110
Element: Bud Edit Type This field indicates whether GL
                       commitments are edited against
                       summarized budget amounts or detail
                       budget amounts.
                       D = Detail
                       S = Summary

GLS-FB-UPDATING        Numeric 2
Element: Fb Updating

GLS-ML-UPDATING        Numeric 2
Element: Ml Updating

                         GLSYSTEM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GLSSET1   COMPANY       This path is used to retrieve company    AC03.1  AC03.2
                        records.                                 AC03.3  AC03.4
                                                                 AC03.5  AC03.6
                                                                 AC03.8  AC10.1
                                                                 AC113   AC12.2
                                                                 AC121   AC123
                                                                 AC127   AC130
                                                                 AC131   AC160
                                                                 AC17.3  AC17.4
                                                                 AC176   AC18.2
                                                                 AC18.3  AC190
                                                                 AC191   AC192
                                                                 AC195   AC196
                                                                 AC198   AC20.1
                                                                 AC20.2  AC20.3
                                                                 ...

GLSSET2   CHART-NAME    KeyChange                                GL00.2  GL00.7
          COMPANY

GLSSET3   CURRENCY-TABLEKeyChange                                CU00.1
          COMPANY

                         GLSYSTEM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

All Co Addr    GLADDRESS    Not Required, Delete Cascades

                            GLS-COMPANY           -> GAD-COMPANY
                            Spaces                -> GAD-ACCT-UNIT

Bal Acct       GLCHARTDTL   Required

                            GLS-CHART-NAME        -> GDT-CHART-NAME
                            GCH-BAL-ACCOUNT       -> GDT-ACCOUNT
                            GCH-BAL-SUB-ACCT      -> GDT-SUB-ACCOUNT

Bs Acct Unit   GLNAMES      Not Required

                            GLS-COMPANY           -> GLN-COMPANY
                            GLS-BS-ACCT-UNIT      -> GLN-ACCT-UNIT

Chart Of Accts GLCHART      Required

                            GLS-CHART-NAME        -> GCH-CHART-NAME

Co Address     GLADDRESS    Not Required, Delete Cascades

                            GLS-COMPANY           -> GAD-COMPANY
                            Spaces                -> GAD-ACCT-UNIT

Comt Acct      GLCHARTDTL   Not Required

                            GLS-CHART-NAME        -> GDT-CHART-NAME
                            GCH-COMT-ACCOUNT      -> GDT-ACCOUNT
                            GCH-COMT-SUB-ACCT     -> GDT-SUB-ACCOUNT

Cucodes        CUCODES      Required

                            GLS-CURRENCY-CODE     -> CUC-CURRENCY-CODE

Curr 1         CUCODES      Not Required

                            GLS-CURR-CODE-1       -> CUC-CURRENCY-CODE

Curr 2         CUCODES      Not Required

                            GLS-CURR-CODE-2       -> CUC-CURRENCY-CODE

Cutable        CUTABLE      Required

                            GLS-CURRENCY-TABLE    -> CTB-CURRENCY-TABLE

Es Acct        GLCHARTDTL   Not Required

                            GLS-CHART-NAME        -> GDT-CHART-NAME
                            GCH-ES-ACCOUNT        -> GDT-ACCOUNT
                            GCH-ES-SUB-ACCT       -> GDT-SUB-ACCOUNT

Gain Acct      GLCHARTDTL   Not Required

                            GLS-CHART-NAME        -> GDT-CHART-NAME
                            GCH-GAIN-ACCT         -> GDT-ACCOUNT
                            GCH-GAIN-SUB-ACCT     -> GDT-SUB-ACCOUNT

Glsysje Cp     GLSYSJE      Not Required

                            GLS-COMPANY           -> GSJ-COMPANY
                            "GL"                  -> GSJ-SYSTEM
                            GLS-FISCAL-YEAR       -> GSJ-FISCAL-YEAR
                            GLS-ACCT-PERIOD       -> GSJ-ACCT-PERIOD

Is Acct Unit   GLNAMES      Not Required

                            GLS-COMPANY           -> GLN-COMPANY
                            GLS-IS-ACCT-UNIT      -> GLN-ACCT-UNIT

Loss Acct      GLCHARTDTL   Not Required

                            GLS-CHART-NAME        -> GDT-CHART-NAME
                            GCH-LOSS-ACCT         -> GDT-ACCOUNT
                            GCH-LOSS-SUB-ACCT     -> GDT-SUB-ACCOUNT

Re Acct        GLCHARTDTL   Not Required

                            GLS-CHART-NAME        -> GDT-CHART-NAME
                            GCH-RE-ACCOUNT        -> GDT-ACCOUNT
                            GCH-RE-SUB-ACCT       -> GDT-SUB-ACCOUNT

Rnd Acct       GLCHARTDTL   Not Required

                            GLS-CHART-NAME        -> GDT-CHART-NAME
                            GCH-RND-ACCOUNT       -> GDT-ACCOUNT
                            GCH-RND-SUB-ACCT      -> GDT-SUB-ACCOUNT

Ure Acct       GLCHARTDTL   Not Required

                            GLS-CHART-NAME        -> GDT-CHART-NAME
                            GCH-URE-ACCOUNT       -> GDT-ACCOUNT
                            GCH-URE-SUB-ACCT      -> GDT-SUB-ACCOUNT

                         GLSYSTEM FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Units     GLNAMES      Delete Restricted

                            GLS-COMPANY           -> GLN-COMPANY
                                                     GLN-ACCT-UNIT

Caheader       CAHEADER

                            GLS-COMPANY           -> CAH-COMPANY
                                                     CAH-ALLOC-NAME
                                                     CAH-ALLOC-TYPE

Coledger       MLCOLEDGER

                            GLS-COMPANY           -> MLE-COMPANY
                                                     MLE-LEDGER

Company Groups GLCGCPY

                            GLS-COMPANY           -> GCC-COMPANY
                                                     GCC-COMPANY-GROUP

Consol         GLCONSOL

                            GLS-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                            Zeroes                -> GCN-LEVEL-DEPTH
                            Zeroes                -> GCN-BUDGET-NBR
                            "A"                   -> GCN-TRANS-TYPE
                            GLS-COMPANY           -> GCN-COMPANY
                                                     GCN-VAR-LEVELS
                                                     GCN-ACCOUNT
                                                     GCN-SUB-ACCOUNT
                                                     GCN-CURRENCY-CODE

Consol Y       GLCONSOL

                            GLS-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                            Zeroes                -> GCN-LEVEL-DEPTH
                            Zeroes                -> GCN-BUDGET-NBR
                            "Y"                   -> GCN-TRANS-TYPE
                            GLS-COMPANY           -> GCN-COMPANY
                                                     GCN-VAR-LEVELS
                                                     GCN-ACCOUNT
                                                     GCN-SUB-ACCOUNT
                                                     GCN-CURRENCY-CODE

Consol Z       GLCONSOL

                            GLS-FISCAL-YEAR       -> GCN-FISCAL-YEAR
                            Zeroes                -> GCN-LEVEL-DEPTH
                            Zeroes                -> GCN-BUDGET-NBR
                            "Z"                   -> GCN-TRANS-TYPE
                            GLS-COMPANY           -> GCN-COMPANY
                                                     GCN-VAR-LEVELS
                                                     GCN-ACCOUNT
                                                     GCN-SUB-ACCOUNT
                                                     GCN-CURRENCY-CODE

Curelat        CURELAT

                            GLS-CURRENCY-TABLE    -> CRL-CURRENCY-TABLE
                                                     CRL-FR-CURR-CODE
                                                     CRL-TO-CURR-CODE

Fbheader       FBHEADER

                            GLS-COMPANY           -> FBH-COMPANY
                                                     FBH-FISCAL-YEAR
                                                     FBH-BUDGET-NBR

Glclsaudit     GLCLSAUDIT

                            GLS-COMPANY           -> GCA-COMPANY
                                                     GCA-FISCAL-YEAR
                                                     GCA-ACCT-PERIOD
                                                     GCA-CLOSE-SEQ

Glcodes Sys    GLCODES

                            GLS-COMPANY           -> GCD-COMPANY
                                                     GCD-SYSTEM

Glcontrol      GLCONTROL

                            GLS-COMPANY           -> GLC-COMPANY
                                                     GLC-FISCAL-YEAR
                                                     GLC-ACCT-PERIOD
                                                     GLC-SYSTEM
                                                     GLC-JE-TYPE
                                                     GLC-CONTROL-GROUP
                                                     GLC-JE-SEQUENCE

Glmaster       GLMASTER

                            GLS-COMPANY           -> GLM-COMPANY
                                                     GLM-ACCT-UNIT
                                                     GLM-ACCOUNT
                                                     GLM-SUB-ACCOUNT

Glsysje        GLSYSJE      Delete Cascades

                            GLS-COMPANY           -> GSJ-COMPANY
                                                     GSJ-SYSTEM
                                                     GSJ-FISCAL-YEAR
                                                     GSJ-ACCT-PERIOD

Gltrans        GLTRANS

                            GLS-COMPANY           -> GLT-COMPANY
                                                     GLT-FISCAL-YEAR
                                                     GLT-ACCT-PERIOD
                                                     GLT-CONTROL-GROUP
                                                     GLT-SYSTEM
                                                     GLT-JE-TYPE
                                                     GLT-JE-SEQUENCE
                                                     GLT-LINE-NBR

Glunits        GLUNITS

                            GLS-COMPANY           -> GLU-COMPANY
                                                     GLU-ACCOUNT
                                                     GLU-SUB-ACCOUNT
                                                     GLU-VAR-LEVELS
                                                     GLU-ACCT-UNIT
                                                     GLU-FISCAL-YEAR

Intercompany   GLINTCO

                            "C"                   -> GIC-RECORD-TYPE
                            GLS-COMPANY           -> GIC-COMPANY-A
                                                     GIC-COMPANY-B
                                                     GIC-ZONE-A
                                                     GIC-ZONE-B
                                                     GIC-SYSTEM

Interzone      GLINTCO

                            "L"                   -> GIC-RECORD-TYPE
                            GLS-COMPANY           -> GIC-COMPANY-A
                                                     GIC-COMPANY-B
                                                     GIC-ZONE-A
                                                     GIC-ZONE-B
                                                     GIC-SYSTEM

Jbookhdr       JBOOKHDR     Delete Cascades

                            GLS-COMPANY           -> JBK-COMPANY
                                                     JBK-JRNL-BOOK-NBR

Mlcalmap       MLCALMAP

                            GLS-COMPANY           -> MCM-COMPANY
                                                     MCM-LEDGER
                                                     MCM-CURRENT-YR-FL

Mlcoledger     MLCOLEDGER

                            GLS-COMPANY           -> MLE-COMPANY
                                                     MLE-LEDGER