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    AC191     AC256     AC295     AC297     AC42.1
AC530     AC54.1    AC541     AC58.1    AC59.1    AC90.2
AC90.4    AC90.6    AC90.8    AC95.2    AC95.4    AC95.6
AC97.2    AC97.4    AC97.6    ACAC.1    ACVW.1    SE90.1
AP115     AP125     AP126     AP131     AP193     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP220
AP23.1    AP25.1    AP25.2    AP26.1    AP27.1    AP30.2
AP30.4    AP305     AP32.2    AP520     API1.1    API2.1
AR09.1    AR09.4    AR115     AR124     AR20.1    AR21.1
AR21.2    AR21.3    AR24.1    AR29.2    AR30.1    AR30.2
AR30.4    AR42.1    AR42.2    AR42.7    AR43.1    AR560
AR570     AR575     AR580     BN150     BN66.1    BR40.1
BR42.1    BR43.1    CB10.1    CB180     CB191     CB20.1
CB30.1    CB500     CB80.1    CXCP.1    EE135     EE20.3
EE35.1    EE35.2    EE520     CA110     FB145     FB190
FB40.1    FB40.2    FB40.3    FB45.1    GL100     GL199
GL241     GL50.4    GL65.1    GL90.3    HR07.1    HR11.1
HR11.2    HR507     HR511     HR650     DR100     IC140
IC141     IC142     IC222     IC28.1    IC531     IC83.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    IFRS.1    MX07.1    MX07.2    MX207
MA41.1    MA41.2    MA41.4    MA41.7    MA43.1    MA43.2
MA43.3    MA43.4    MA43.5    MA43.7    MA43.8    MA43.9
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA63.1    MA65.1    MA66.2    MA66.3    MA67.1    MA67.2
MA68.1    MA70.1    MA75.1    MA80.1    MAI1.1    PA02.1
PA100     PA102     PA13.1    PA13.2    PA502     PA513
PA52.1    PA52.3    PA52.4    PA52.5    PO100     PO101
PO122     PO131     PO150     PO190     PO20.1    PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO23.1
PO25.1    PO25.5    PO25.6    PO25.7    PO26.1    PO27.2
PO29.1    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     POCP.1    POD0.1
POI3.1    POID.1    POIF.1    POIG.1    POII.1    POIJ.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    PR36.1    PR37.1    PR38.1    PR45.1    PR529
PR530     PR560     PR80.1    PR82.1    PR85.1    PR89.1
PRSA.1    UK102     UK330     UK560     RQ10.1    RQ10.2
RQ10.3    RQ11.1    RQ12.1    RQ13.1    RQ140     RQ300
RQ35.1    RQ40.1    RQ41.1    RQ42.1    RQ44.1    RQ44.2
RQ500     RQD0.1    RQIE.1    RQIF.1    SL40.4    SLFD.1
TA147     UK120     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

UPDATED BY

AC131     AC160     AC176     AC190     AC198     AC40.4
AC41.4    AC45.4    AC540     AC542     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    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    AP170
AP175     AP176     AP185     AP190     AP191     AR190
BN190     BR124     BR130     BR131     BR153     BR154
BR41.4    BRIP.1    BRPI.1    CB175     DT190     EE175
CA190     GL135     GL146     GL165     GL170     GL195
GL197     GL40.1    GL40.2    GL40.3    GL40.7    GL40.8
GL44.1    GL45.1    GL75.1    IC125     IC130     GL01.4
GL105     GL311     GL312     GL313     MA180     PO135
PO136     PO139     PR195     PR198     TA195     TA196
WO140

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:
                       S = Summary
                       D = Detail
                       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   AC160
Object                 This is a the last unique transaction     AC176   AC190
Identification         identifier value assigned to a general    AC198   AC40.4
                       ledger transaction destined for another   AC41.4  AC45.4
                       machine.                                  AC540   AC542
                                                                 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  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  AP170
                                                                 AP175   AP176
                                                                 AP185   AP190
                                                                 AP191   AR190
                                                                 BN190   BR124
                                                                 BR130   BR131
                                                                 BR153   BR154
                                                                 ...

SYS-AC-COMMIT-FL       Alpha 1                                   GL01.4  GL105
Activity Management    This field determines whether
Commitment             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
Activity Management    This field determines whether budgets
Budget                 are edited when transactions are
                       transferred to the Activity Management
                       system.


SYS-COMMIT-PCT         Percent 6.2  (Percent)                    AC295   AC297
Element: Commit Pct                                              AC90.2  AC90.4
                                                                 AC90.6  AC90.8
                                                                 AC95.2  AC95.4
                                                                 AC95.6  AC97.2
                                                                 AC97.4  AC97.6
                                                                 ACVW.1  GL01.4
                                                                 SE90.1

SYS-GL-COMMIT-FL       Alpha 1                                   GL01.4  GL105
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.

                         SYSTEMCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SYSSET1   SYSTEM                                                 AC00.1  AC131
                                                                 AC160   AC176
                                                                 AC190   AC191
                                                                 AC198   AC256
                                                                 AC295   AC297
                                                                 AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC45.4
                                                                 AC530   AC54.1
                                                                 AC540   AC541
                                                                 AC542   AC58.1
                                                                 AC59.1  AC90.2
                                                                 AC90.4  AC90.6
                                                                 AC90.8  AC95.2
                                                                 AC95.4  AC95.6
                                                                 ...

                         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