Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SYSTEMCODE


                            SYSTEMCODE FILE

                              System Code

This file contains system code information used for remote site processing.

REFERENCED BY

AC00.1    AC10.6    AC10.7    AC169     AC191     AC256
AC295     AC346     AC42.1    AC46.1    AC50.2    AC502
AC54.1    AC56.1    AC560     AC69.2    AC70.1    AC90.2
AC90.4    AC90.6    AC90.8    AC95.2    AC95.4    AC95.6
ACAC.1    ACVW.1    SE90.1    AP10.1    AP10.2    AP193
AP520     AP810     AR09.1    AR09.4    AR115     AR124
AR190     AR20.1    AR21.1    AR21.2    AR21.3    AR24.1
AR29.2    AR30.1    AR32.1    AR34.1    AR42.1    AR42.2
AR42.7    AR43.1    AR560     AR570     AR575     AR580
ARLL.1    BN150     BN305     BN66.1    BR190     BR40.1
BR42.2    BR43.1    BR44.1    BR96.1    CB10.1    CB15.1
CB15.2    CB150     CB180     CB191     CB20.1    CB30.1
CB45.1    CB46.1    CB500     CB543     CB544     CB55.1
CB554     CB80.1    CB82.1    CXCP.1    EE135     EE20.3
EE35.1    EE35.2    EE520     ET09.1    ET530     ET540
ETI2.1    CA110     CA195     FB100     FB101     FB120
FB121     FB122     FB145     FB165     FB190     FB20.1
FB20.3    FB20.4    FB20.6    FB20.7    FB21.1    FB30.1
FB31.1    FB40.1    FB40.2    FB40.3    FB45.1    GL100
GL167     GL190     GL191     GL199     GL241     GL50.4
GL500     GL65.1    GL70.1    GL70.2    GL70.3    GL70.5
GL70.6    GL90.3    HR07.1    HR11.1    HR11.2    HR25.1
HR250     HR507     HR511     IC02.1    GL00.1    GL00.7
GL02.3    GL03.4    GL03.5    GL123     GL124     GL13.4
GL14.2    GL160     GL205     GL60.1    IFAC.1    IFGT.1
IFIC.1    IFRS.1    LP130     MA310     PA02.1    PA100
PA102     PA115     PA13.1    PA13.2    PA182     PA502
PA513     PA52.1    PA52.3    PA52.4    PA52.5    PO150
PO190     PO26.1    POCP.1    POD0.1    POIF.1    POIG.1
POIM.1    PR110     PR113     PR120     PR128     PR13.1
PR13.5    PR13.6    PR13.8    PR130     PR131     PR132
PR134     PR136     PR137     PR140     PR189     PR197
PR29.1    PR32.1    PR32.2    PR33.1    PR33.2    PR33.3
PR35.1    PR35.2    PR35.3    PR35.4    PR35.5    PR35.6
PR35.8    PR35.9    PR36.1    PR37.1    PR38.1    PR45.1
PR529     PR530     PR560     PR80.1    PR82.1    PR85.1
PR89.1    UK102     UK330     UK560     MM280     MM80.1
MM80.2    RQ11.1    RQ12.1    RQ13.1    RQ13.2    RQ35.1
RQ500     RQD0.1    RQIB.1    RQIF.1    RQIJ.1    SL40.4
SLFD.1    TA147     WH130     WH132     WH190     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


UPDATED BY

AC131     AC145     AC160     AC190     AC197     AC198
AC40.4    AC41.4    AC45.1    AC45.4    AC540     AM115
AM117     AM125     AM135     AM145     AM15.1    AM15.2
AM15.3    AM15.4    AM154     AM170     AM19.1    AM19.2
AM190     AM192     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
AM502     AM551     AM92.1    AM96.1    AM98.1    AP115
AP125     AP126     AP131     AP170     AP175     AP176
AP185     AP190     AP191     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP21.1    AP220     AP23.1
AP25.1    AP25.2    AP26.1    AP27.1    AP30.2    AP30.4
AP305     API1.1    API2.1    AR195     BL120     BL122
BL123     BL130     BL20.1    BL20.3    BL21.2    BL21.5
BL29.1    BL29.2    BL520     BL820     BL92.1    BN190
BR124     BR130     BR131     BR140     BR153     BR154
BR41.4    BRIP.1    CB175     CB186     CB187     DT190
EE175     ET175     CA190     GL135     GL146     GL165
GL170     GL195     GL197     GL40.1    GL40.2    GL40.3
GL40.7    GL40.8    GL44.1    GL45.1    GL75.1    IC130
GL01.4    GL105     GL311     LP198     MA180     MA41.1
MA41.2    MA41.4    MA41.7    MA43.1    MA43.2    MA43.3
MA43.4    MA43.6    MA43.7    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA63.1    MA65.1    MA66.2
MA66.3    MA67.2    MA67.3    MA68.2    MA68.3    MA68.5
MA70.1    MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2
PD130     PD20.1    PD20.2    PD20.3    PO100     PO101
PO122     PO131     PO135     PO136     PO139     PO20.1
PO21.1    PO21.2    PO21.3    PO21.4    PO21.5    PO22.1
PO23.1    PO24.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    PO32.4    PO33.1    PO34.1
PO35.1    PO36.1    PO36.2    PO38.1    PO39.1    PO39.2
PO44.1    PO50.1    PO52.1    PO520     PO536     POI3.1
POID.1    POII.1    POIJ.1    PR195     PR198     RQ10.1
RQ10.2    TA195     TA196     WH20.2    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

SYS-DESCRIPTION        Alpha 30  (Lower Case)                    GL01.4  GL105
Element: Description   The system code description.

SYS-RECORD-TYPE        Alpha 1                                   GL01.4  GL105
Element: Record Type   This field identifies the type of record
                       defined.

                       Valid values are:
                       L = Lawson
                       U = User

SYS-REMOTE-SITE-FL     Alpha 1                                   GL01.4  GL105
Element: Remote Site   This field determines whether the
                       general ledger transactions should be
                       posted to the accounts on the processing
                       (remote) machine or sent to another
                       machine for posting.

                       Y = Yes
                       N = No

SYS-REMOTE-SLT-FL      Alpha 1                                   GL01.4
Element: Account Flag

SYS-MACHINE-CODE       Alpha 12                                  GL01.4
Element: Machine Code  This field designates a code name
                       associated to a particular machine in a
                       multiple machine environment.  If the
                       General Ledger Module on a particular
                       machine is established for account
                       validation only and the actual general
                       ledger transactions should be sent to
                       another machine, the Remote Site machine
                        name should be entered here.


SYS-OBJ-ID             Numeric 12                                AC131   AC145
Element: Obj Id        This is a the last unique transaction     AC160   AC190
                       identifier value assigned to a general    AC197   AC198
                       ledger transaction destined for another   AC40.4  AC41.4
                       machine.                                  AC45.1  AC45.4
                                                                 AC540   AM115
                                                                 AM117   AM125
                                                                 AM135   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM154   AM170
                                                                 AM19.1  AM19.2
                                                                 AM190   AM192
                                                                 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
                                                                 AM502   AM551
                                                                 AM92.1  AM96.1
                                                                 AM98.1  AP115
                                                                 AP125   AP126
                                                                 AP131   AP170
                                                                 AP175   AP176
                                                                 ...

SYS-AC-COMMIT-FL       Alpha 1                                   GL01.4
Element: Ac Commit Fl  This field determines whether
                       commitments for all activities are
                       updated in the Activity Management (AC)
                       system when you transfer transactions
                       from a Lawson application to the AC
                       system.


SYS-AC-BUD-FL          Alpha 1                                   GL01.4
Element: Ac Bud Fl     This field determines whether budgets
                       are edited when transactions are
                       transferred to the Activity Management
                       system.


SYS-COMMIT-PCT         Percent 6.2  (Percent)                    GL01.4
Element: Commit Pct

SYS-GL-COMMIT-FL       Alpha 1                                   GL01.4
Element: Gl Commit Fl  This is the Yes/No flag for GL
                       commitments.

SYS-GL-BUD-FL          Alpha 1                                   GL01.4
Element: Gl Bud Fl     This is the Yes/No flag indicating
                       whether GL commitments should be edited
                       against a budget.

SYS-AC-RNI-UPD-OPT     Alpha 1                                   GL01.4
Element: Ac Rni Upd OptThis is the Yes/No flag indicating
                       whether PO135 will create accruals in
                       AC.

SYS-COMMT-DT-FL-PO     Alpha 1                                   GL01.4
Element: Commt Dt Fl PoThis is the option field indicating
                       whether PO Date or Delivery Date will be
                       used with PO commitments.

SYS-COMMT-DT-FL-RQ     Alpha 1                                   GL01.4
Element: Commt Dt Fl RqThis is the option field indicating
                       whether RQ Creation or Delivery Date
                       will be used with RQ commitments.

SYS-PSA-HR-FL          Alpha 1                                   GL01.4  GL105
Element: Psa Hr Fl     This field is used to indicate if the
                       client is using Lawson HR.

SYS-PSA-PR-FL          Alpha 1                                   GL01.4  GL105
Element: Psa Pr Fl     This field is used to indicate if the
                       client is using Lawson PR.

SYS-CURR-POST-LVL      Alpha 1
Element: Curr Post Lvl

SYS-RETAIL-FLAG        Numeric 1                                 GL01.4  GL105
Element: Retail Flag

                         SYSTEMCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SYSSET1   SYSTEM                                                 AC00.1  AC10.6
                                                                 AC10.7  AC131
                                                                 AC145   AC160
                                                                 AC169   AC190
                                                                 AC191   AC197
                                                                 AC198   AC256
                                                                 AC295   AC346
                                                                 AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC45.1
                                                                 AC45.4  AC46.1
                                                                 AC50.2  AC502
                                                                 AC54.1  AC540
                                                                 AC56.1  AC560
                                                                 AC69.2  AC70.1
                                                                 ...

                         SYSTEMCODE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glcodes        GLCODES

                            "C"           -> GCD-RECORD-TYPE
                            Spaces        -> GCD-FOLDER-NAME
                            Spaces        -> GCD-PROCESS-GROUP
                            SYS-SYSTEM    -> GCD-SYSTEM
                                             GCD-COMPANY