Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLCODES


                              GLCODES FILE

                          General Ledger Codes

GLCODES is a multi-purpose file. It holds information relating to systems,
source codes, folders and process groups.

System codes are defined in System Control. Each system code represents a
subsystem that interfaces transactions to the Lawson General Ledger or uses
Subsystem Control features. Subsystem Control features determine at what point
the Lawson General Ledger is closed, and which dates are valid for entry in
the subsystems. In addition, the status of the entry as it hits the General
Ledger can be controlled for each system. Choices are released or unreleased.

Source codes provide the Lawson General Ledger system with a method of
identifying and classifying transactions. Any transaction either entering the
General Ledger from a subsystem or created in GL must have a source code.
Source codes (defined in Source Codes) help to group and total transactions on
reports.

Folders also provide a method for identifying and classifying. However, they
classify the pieces used to create Lawson GL Report Writer reports. Folders
are defined in RW01 (Folders).

Process groups are created in RW02 (Process Groups). They group Lawson GL
Report Writer reports that should be processed (run) at the same time.






REFERENCED BY

AC255     AC256     AC55.1    AC55.2    GL204     GL255
GL50.4    GL55.1    GL55.2    GL90.4    RW00.1    RW00.6
RW04.1    RW04.2    RW10.2    RW10.3    RW10.4    RW10.8
RW100     RW11.1    RW11.2    RW11.3    RW11.4    RW20.1
RW20.2    RW20.8    RW200     RW201     RW210     RW220
RW230     RW240     RW250     RW260     RW270     RW299
RW30.1    RW40.1    RW40.2    RW40.3    RW40.4    RW40.5
RW40.6    RW40.7    RW40.8    RW50.1    RW60.1    RW60.2
RW60.3    RW70.1    RW202     AC130     AC40.1    AC40.4
AC41.1    AC41.4    AC42.1    AC54.1    AC540     AM115
AM125     AM135     AM145     AM15.1    AM15.2    AM15.3
AM15.4    AM154     AM170     AM20.1    AM20.2    AM20.3
AM20.4    AM20.5    AM20.6    AM21.1    AM21.2    AM21.3
AM21.4    AM21.5    AM21.6    AM30.1    AM30.2    AM30.3
AM40.1    AM40.2    AM40.3    AM40.4    AM41.1    AM41.2
AM500     AM551     AM96.1    AM98.1    AP125     AP126
AP131     AP151     AP155     AP160     AP161     AP170
AP175     AP180     AP181     AP190     AP191     AP193
AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.6
AP20.7    AP20.8    AP23.1    AP25.1    AP25.2    AP255
AP26.1    AP265     AP27.1    AP28.1    AP28.2    AP30.2
AP30.4    AP32.2    AP520     AP55.1    AP80.1    AP81.1
AP90.5    API1.1    AR01.1    AR115     AR124     AR129
AR130     AR131     AR135     AR137     AR190     AR196
AR20.1    AR21.1    AR21.2    AR21.3    AR24.1    AR29.2
AR30.1    AR30.2    AR30.3    AR30.4    AR30.8    AR30.9
AR31.1    AR31.5    AR31.6    AR35.1    AR35.2    AR42.1
AR42.2    AR44.3    AR48.3    AR560     AR570     AR575
AR580     AR80.1    AR80.2    AR82.1    BR120     BR151
BR152     BR156     BR21.1    BR41.1    BR41.4    BR43.1
CB06.2    CB10.1    CB15.1    CB15.2    CB180     CB185
CB190     CB191     CB20.1    CB25.1    CB30.1    CB500
CB80.1    CXCP.1    DT180     DT181     DT185     DT190
DT30.1    DT30.2    DT40.1    DT520     DT92.1    EE20.1
EE20.2    EE20.4    EE520     GL122     GL145     GL146
GL165     GL190     GL191     GL197     GL199     GL230
GL245     GL256     GL30.1    GL40.1    GL40.2    GL40.3
GL40.6    GL40.7    GL40.8    GL44.1    GL45.1    GL65.1
DR100     IC10.2    IC12.1    IC12.2    IC120     IC125
IC130     IC134     IC138     IC140     IC141     IC142
IC145     IC150     IC151     IC152     IC170     IC175
IC182     IC20.1    IC20.2    IC21.1    IC21.2    IC22.1
IC22.2    IC223     IC224     IC225     IC226     IC227
IC228     IC23.1    IC23.2    IC23.3    IC23.4    IC23.5
IC24.1    IC24.2    IC25.1    IC26.1    IC26.2    IC262
IC270     IC28.1    IC281     IC282     IC285     IC29.1
IC29.2    IC29.3    IC295     IC31.1    IC320     IC330
IC36.1    IC40.1    IC40.2    IC44.1    IC45.1    IC500
IC520     IC521     IC522     IC523     IC524     IC525
IC526     IC527     IC530     IC531     IC574     IC598
IC61.1    IC62.1    IC62.2    IC67.1    IC68.1    IC68.2
IC68.3    IC72.1    IC73.1    IC74.1    IC81.1    IC82.1
IC820     IC83.1    IC84.1    IC84.2    IC840     IC90.1
IC95.1    IC95.2    IC95.3    PC120     SEA1.1    CU03.1
GL03.6    GL12.1    GL12.2    GL124     GL198     GL201
GL225     GL25.1    IFGT.1    JB00.2    JB200     MA180
MA41.2    MA41.7    MA43.1    MA43.2    MA43.3    MA43.9
MA530     MA531     MA540     MA60.2    MA60.3    MA60.5
MA61.1    MA63.1    MA66.2    MA66.3    MA67.1    MA67.2
MA70.1    MA75.1    MA80.1    MAI1.1    PO100     PO101
PO122     PO131     PO16.1    PO20.1    PO21.1    PO21.2
PO21.3    PO21.4    PO21.5    PO22.1    PO228     PO23.1
PO25.1    PO25.5    PO25.6    PO25.7    PO27.2    PO29.1
PO30.1    PO30.2    PO30.3    PO300     PO31.1    PO31.2
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     PO64.1    POI3.1    POII.1    POIJ.1
PR197     MM280     MM80.1    MM80.2    RQ10.1    RQ10.2
RQ10.3    RQ11.1    RQ12.1    RQ13.1    RQ35.1    RQ39.1
RQ39.2    RQ39.3    RQ500     RQIC.1    RQID.1    RQIE.1
RQIF.1    RQIG.1    RQIH.1    RQIJ.1    SEA3.1    SL40.1
WH110     WH120     WH126     WH130     WH132     WH190
WH20.1    WH20.2    WH20.3    WH20.4    WH20.5    WH20.6
WH20.7    WH22.1    WH220     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
WH34.5    WH40.1    WH40.2    WH520     WH830     WO10.1
WO120     WO130     WO131     WO132     WO133     WO140
WO20.1    WO215     WO220     WO232     WO235     WO250
WO251     WO252     WO255     WO256     WO280     WO30.1
WO30.2    WO300     WO32.1    WO32.2    WO32.3    WO32.4
WO32.5    WO35.1    WO40.1    WO40.2    WO40.3    WO40.4
WO40.5    WO40.6    WO41.1    WO41.2    WO41.3    WO41.4
WO42.1    WO42.2    WO42.3    WO42.4    WO42.5    WO45.1
WO510     WO80.1    WO81.1    WO81.2    WO82.1    WOEX.1
WOSP.1    RW03.2

UPDATED BY

AC195     AM190     AM192     AP195     AR199     CB195
CA199     GL04.1    GL04.2    GL110     GL167     GL179
GL500     RW01.1    RW01.2    RW02.1    RW02.2    IC199
GL01.1    GL01.2    GL10.1    PO135     PO139     PO199
PR196

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GCD-RECORD-TYPE        Alpha 1                                   GL01.1  GL01.2
Element: Record Type   This field is filled by the program       GL04.1  GL04.2
                       creating a GLCODES record. This field     GL10.1  GL167
                       specifies the record as a system code,    RW01.1  RW01.2
                       source code, folder, or process group.    RW02.1  RW02.2

                       C = System Code
                       F = Folder
                       P = Process Group
                       R = Reconciliation Code

GCD-FOLDER-NAME        Alpha 12                                  RW01.1  RW01.2
Element: Folder        Required for record type "F," this
                       field is created in RW01. A folder is
                       used to classify the pieces comprising a
                       GL Report Writer report or ratio.


GCD-PROCESS-GROUP      Alpha 15                                  RW02.1  RW02.2
Element: Process Group Required for record type "P," this
                       field is created in RW02. A process
                       group is used to group GL Report Writer
                       reports together for processing.


GCD-SYSTEM             Alpha 2                                   GL01.1  GL01.2
Element: System        A two-character code representing an      GL04.1  GL04.2
                       application used within the Lawson        GL10.1  GL167
                       system. (i.e.: GL = General Ledger, AP =
                       Accounts Payable, etc.)

GCD-SOURCE-CODE        Alpha 2
Element: Source Code   Required field for record types of "C"
                       or "S." This field can represent either
                       a system code or a source code.

                       System codes have a record type of "C."
                       They identify all systems that interface
                       to the Lawson General Ledger or use
                       subledger control features.

                       Source codes have a record type of "S."
                       Source codes help to classify
                       transactions in the Lawson General
                       Ledger system.




GCD-COMPANY            Numeric 4                                 GL01.1  GL01.2
Element: Company       The company number as defined in GL10.1   GL10.1  GL110
                       (Company).                                GL167


GCD-DESCRIPTION        Alpha 30  (Lower Case)                    GL01.1  GL01.2
Element: Description   The system code description.              GL04.1  GL04.2
                                                                 GL10.1  GL167
                                                                 RW01.1  RW01.2
                                                                 RW02.1  RW02.2
                                                                 RW100

GCD-SYSTEM-FLAG        Alpha 1                                   GL01.1  GL01.2
Element: System Flag   Indicates if subledger control features   GL10.1  GL167
                       are used for the system being defined.

                       Y = Yes
                       N = No

GCD-BEGIN-DATE         Numeric 8  (yyyymmdd)                     AC195   AM190
Element: Begin Date    The beginning date in a range of dates.   AM192   AP195
                                                                 AR199   CB195
                                                                 GL01.1  GL01.2
                                                                 IC199   PO135
                                                                 PO139   PO199
                                                                 PR196

GCD-END-DATE           Numeric 8  (yyyymmdd)                     AC195   AM190
Element: Ending Date   The ending date in a range of dates.      AM192   AP195
                                                                 AR199   CB195
                                                                 GL01.1  GL01.2
                                                                 IC199   PO135
                                                                 PO139   PO199
                                                                 PR196

GCD-PERIOD             Numeric 2                                 AC195   AM190
Element: Last Closed PeWhen the subsystem closing program is     AM192   AP195
                       run for the indicated system, this field  AR199   CA199
                       is updated along with the GCD-YEAR to     CB195   GL179
                       indicate the last period closed.          GL500   IC199
                                                                 PO135   PO139
                                                                 PO199   PR196

GCD-YEAR               Numeric 4                                 AC195   AM190
Element: Last Closed YeWhen the subsystem closing program is     AM192   AP195
                       run for the indicated system, this field  AR199   CA199
                       is updated to indicate the last year      CB195   GL179
                       closed along with the GCD-PERIOD.         IC199   PO135
                                                                 PO139   PO199
                                                                 PR196

GCD-OPEN-PERIODS       Numeric 2                                 GL01.1  GL01.2
Element: Open Periods  It is used by the subsystem's closing
                       program to increment the new ending date
                       (GCD-END-DATE) in the valid entry date
                       range.

                       00
                       12

GCD-USER-CLASS         Alpha 12                                  RW01.1  RW01.2
Element: User Class    Represents a group of users that have
                       authority to use a system.


GCD-ACTIVITY-IGNOR     Alpha 1                                   GL01.1  GL01.2
Element: Activity IgnorIndicates if Activity system
                       transactions are ignored.

                       N = No
                       Y = Yes

GCD-ZONE-IGNORE        Alpha 1                                   GL01.1  GL01.2
Element: Zone Ignore   Indicates if Base Zone transactions are
                       ignored.

                       N = No
                       Y = Yes

GCD-ACTIVITY           Alpha 15
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


GCD-HOLD-CODE          Alpha 4                                   GL01.1  GL01.2
Element: Hold Code     This field contains the journal hold
                       code.


GCD-JRNL-BOOK-NBR      Alpha 12                                  GL01.1  GL01.2
Element: Journal Book  The journal book assigned to the
                       transaction.

                         GLCODES FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GCDSET1   RECORD-TYPE   This path is used to retrieve Report     AC255   AC256
          FOLDER-NAME   Writer folders.                          AC55.1  AC55.2
          PROCESS-GROUP                                          GL04.1  GL04.2
          SYSTEM                                                 GL204   GL255
          COMPANY                                                GL50.4  GL55.1
                                                                 GL55.2  GL90.4
                                                                 RW00.1  RW00.6
                                                                 RW01.1  RW01.2
                                                                 RW04.1  RW04.2
                                                                 RW10.2  RW10.3
                                                                 RW10.4  RW10.8
                                                                 RW100   RW11.1
                                                                 RW11.2  RW11.3
                                                                 RW11.4  RW20.1
                                                                 RW20.2  RW20.8
                                                                 ...

GCDSET2   PROCESS-GROUP This path is used to retrieve process    RW00.1  RW02.1
                        groups.                                  RW02.2  RW200
                                                                 RW202
                        Subset
                        Where RECORD-TYPE = "P"

GCDSET3   SOURCE-CODE   This path is used to retrieve source
                        codes.

                        KeyChange, Subset
                        Where RECORD-TYPE = "S"

GCDSET4   COMPANY       This path is used to retrieve system     AC130   AC195
          SYSTEM        codes.                                   AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                        Subset                                   AC42.1  AC54.1
                        Where RECORD-TYPE = "C"                  AC540   AM115
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM190
                                                                 AM192   AM20.1
                                                                 AM20.2  AM20.3
                                                                 AM20.4  AM20.5
                                                                 AM20.6  AM21.1
                                                                 AM21.2  AM21.3
                                                                 ...

GCDSET5   USER-CLASS    KeyChange, Subset                        RW03.2
          FOLDER-NAME   Where (RECORD-TYPE = "F" )

                         GLCODES FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Systemcode     SYSTEMCODE   Not Required
                            Valid When GCD-RECORD-TYPE = "C"

                            GCD-SYSTEM           -> SYS-SYSTEM

                         GLCODES FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amacctgrp      AMACCTGRP

                            GCD-COMPANY          -> AAG-COMPANY
                                                    AAG-ACCT-GRP

Amasset        AMASSET

                            GCD-COMPANY          -> AST-COMPANY
                                                    AST-ASSET

Amasttype      AMASTTYPE

                            GCD-COMPANY          -> ATP-COMPANY
                                                    ATP-ASSET-TYPE
                                                    ATP-SUB-TYPE

Amcalendar     AMCALENDAR

                            GCD-COMPANY          -> AMC-COMPANY
                                                    AMC-BOOK

Amtrans        AMTRANS

                            GCD-COMPANY          -> AMT-COMPANY
                            "4"                  -> AMT-TRANS-STATUS
                                                    AMT-ASSET-PROCESS
                                                    AMT-ASSET
                                                    AMT-SEQ-NUMBER

Computes       CMPUTE       Delete Restricted

                            GCD-FOLDER-NAME      -> CMP-FOLDER-NAME
                                                    CMP-COMPUTE-NAME

Formats        RWFORMAT     Delete Restricted

                            GCD-FOLDER-NAME      -> RWF-FOLDER-NAME
                                                    RWF-FORMAT
                                                    RWF-LINE-NBR

Glcontrol H    GLCONTROL

                            GCD-COMPANY          -> GLC-COMPANY
                            GCD-HOLD-CODE        -> GLC-HOLD-CODE
                                                    GLC-FISCAL-YEAR
                                                    GLC-ACCT-PERIOD
                                                    GLC-STATUS
                                                    GLC-SYSTEM
                                                    GLC-JE-TYPE
                                                    GLC-CONTROL-GROUP
                                                    GLC-JE-SEQUENCE

Glsysje        GLSYSJE
                            Valid When GCD-RECORD-TYPE = "C"

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

Groups         RWHEADER     Delete Restricted

                            GCD-FOLDER-NAME      -> RWH-FOLDER-NAME
                            "G"                  -> RWH-HEAD-TYPE
                                                    RWH-HEAD-NAME
                                                    RWH-RECORD-TYPE

Pr Grp Request RWREQUEST    Delete Restricted
                            Valid When GCD-RECORD-TYPE = "P"

                            GCD-PROCESS-GROUP    -> RWR-PROCESS-GROUP
                                                    RWR-REQUEST-NAME

Ratio Names    RADEFINE     Delete Restricted

                            GCD-FOLDER-NAME      -> RAD-FOLDER-NAME
                                                    RAD-RATIO-NAME

Rationames     RADEFINE     Delete Restricted

                            GCD-FOLDER-NAME      -> RAD-FOLDER-NAME
                                                    RAD-RATIO-NAME

Requests       RWREQUEST    Delete Restricted

                            GCD-FOLDER-NAME      -> RWR-FOLDER-NAME
                                                    RWR-REQUEST-NAME

Rows           RWHEADER     Delete Restricted

                            GCD-FOLDER-NAME      -> RWH-FOLDER-NAME
                            "R"                  -> RWH-HEAD-TYPE
                                                    RWH-HEAD-NAME
                                                    RWH-RECORD-TYPE

Rwuser         RWUSER

                            GCD-USER-CLASS       -> RWU-USER-CLASS
                                                    RWU-USERNAME

Total Names    RATOTALS     Delete Restricted

                            GCD-FOLDER-NAME      -> RAT-FOLDER-NAME
                                                    RAT-FISCAL-YEAR
                                                    RAT-TOTAL-NAME
                                                    RAT-ACCT-UNIT

Total Ranges   RWHEADER     Delete Restricted

                            GCD-FOLDER-NAME      -> RWH-FOLDER-NAME
                            "T"                  -> RWH-HEAD-TYPE
                                                    RWH-HEAD-NAME
                                                    RWH-RECORD-TYPE

Totalnames     RATOTALS     Delete Restricted

                            GCD-FOLDER-NAME      -> RAT-FOLDER-NAME
                                                    RAT-FISCAL-YEAR
                                                    RAT-TOTAL-NAME
                                                    RAT-ACCT-UNIT

Totalranges    RWHEADER     Delete Restricted

                            GCD-FOLDER-NAME      -> RWH-FOLDER-NAME
                            "T"                  -> RWH-HEAD-TYPE
                                                    RWH-HEAD-NAME
                                                    RWH-RECORD-TYPE