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    AC45.1    AC54.1    AC540
AM115     AM117     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.2    AM500     AM502     AM551     AM92.1    AM96.1
AM98.1    AP125     AP126     AP131     AP151     AP155
AP160     AP161     AP170     AP175     AP180     AP181
AP190     AP191     AP193     AP25.1    AP25.2    AP255
AP26.1    AP265     AP27.1    AP28.1    AP28.2    AP30.2
AP30.4    AP520     AP55.1    AP80.1    AP81.1    AP90.5
API1.1    AR01.1    AR115     AR124     AR129     AR130
AR131     AR135     AR196     AR20.1    AR21.1    AR21.2
AR21.3    AR24.1    AR29.2    AR30.1    AR30.2    AR30.3
AR30.8    AR31.1    AR31.5    AR31.6    AR33.1    AR33.3
AR33.5    AR33.6    AR34.1    AR34.4    AR35.1    AR35.2
AR42.1    AR42.2    AR44.3    AR48.3    AR560     AR570
AR575     AR580     AR80.1    AR80.2    AR82.1    ARLL.1
BL120     BL122     BL130     BL140     BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL820
BL92.1    BN100     BN101     BN102     BN103     BN105
BN15.1    BN150     BN215     BN245     BN31.1    BN31.2
BN32.1    BN32.2    BN32.3    BN531     BN65.1    BN71.1
BN72.1    BS13.1    BS14.1    BS15.1    BS32.1    BR120
BR41.1    BR41.4    BR43.1    BR46.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    HAP3.1    HEP4.1
HPOS.1    HPQC.1    HPRS.1    HR11.1    HR11.2    HR15.1
HR155     HR511     HR515     HR54.1    HR55.2    HRS1.1
HRSC.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     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    IC62.4    IC67.1    IC68.1
IC68.2    IC68.3    IC72.1    IC73.1    IC74.1    IC81.1
IC82.1    IC820     IC83.1    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     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    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.1    OE13.2    OE13.3
OE13.4    OE13.5    OE13.6    OE14.4    OE229     OE30.1
OE30.2    OE30.3    OE30.4    OE30.5    OE30.6    OE30.7
OE30.9    OE510     OE530     OE81.1    OE81.3    OE810
OE830     OE86.1    OE90.1    OE90.2    PA02.1    PA100
PA102     PA13.1    PA13.2    PA16.1    PA20.1    PA21.1
PA22.1    PA24.1    PA27.1    PA34.1    PA35.1    PA36.1
PA38.1    PA502     PA513     PA52.1    PA52.2    PA52.3
PA52.4    PA52.5    PA520     PA54.1    TR21.1    TR22.1
TR26.1    TR500     PO100     PO101     PO122     PO131
PO16.1    PO20.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO228     PO23.1    PO29.1    PO30.1    PO30.2
PO30.3    PO300     PO31.1    PO31.2    PO32.2    PO33.1
PO34.1    PO35.1    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     PO64.1    POI3.1    POIE.1
POII.1    POIJ.1    PR00.1    PR110     PR113     PR120
PR128     PR13.1    PR13.5    PR13.6    PR13.8    PR130
PR131     PR132     PR134     PR136     PR160     PR180
PR197     PR29.1    PR30.1    PR32.2    PR33.2    PR33.3
PR35.1    PR35.2    PR35.3    PR35.4    PR35.5    PR35.6
PR35.8    PR35.9    PR36.1    PR45.1    PR529     PR530
PR560     PR82.1    PR85.1    PRSC.1    UK102     MM280
RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ12.1    RQ13.1
RQ13.2    RQ35.1    RQ39.1    RQ39.2    RQ39.3    RQ500
RQIC.1    RQID.1    RQIF.1    RQIG.1    RQIH.1    RQIJ.1
SL40.1    TA147     TP135     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     BL199
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     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   BL199
                                                                 CB195   GL01.1
                                                                 GL01.2  IC199
                                                                 PO135   PO199
                                                                 PR196

GCD-END-DATE           Numeric 8  (yyyymmdd)                     AC195   AM190
Element: Ending Date   The ending date in a range of dates.      AM192   AP195
                                                                 AR199   BL199
                                                                 CB195   GL01.1
                                                                 GL01.2  IC199
                                                                 PO135   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   BL199
                       is updated along with the GCD-YEAR to     CA199   CB195
                       indicate the last period closed.          GL179   GL500
                                                                 IC199   PO135
                                                                 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   BL199
                       is updated to indicate the last year      CA199   CB195
                       closed along with the GCD-PERIOD.         GL179   IC199
                                                                 PO135   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  AC45.1
                        Where RECORD-TYPE = "C"                  AC54.1  AC540
                                                                 AM115   AM117
                                                                 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
                                                                 ...

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