Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            SYSTEMCODE FILE

                              System Code

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

REFERENCED BY

AC190     AC256     AC530     AC54.1    AC70.1    ACAC.1
AP125     AP126     AP193     AP225     AP226     AP25.1
AP25.2    AP26.1    AP30.2    AP30.4    AP32.2    AP520
AP981     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     BL120     BL130     BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL820
BL92.1    BL940     BN150     CB10.1    CB180     CB191
CB20.1    CB30.1    CB80.1    CB980     EE135     EE35.1
EE35.2    EE520     GL199     GL241     GL50.4    GL90.3
DR100     IC141     IC142     IC83.1    GL03.4    GL03.5
GL205     IFGT.1    IFRS.1    IN20.1    MA40.1    MA41.4
MA41.6    MA43.3    MA43.4    MA520     MA530     MA540
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     OE113     OE114     OE129     OE14.4    OE15.1
OE15.2    OE15.3    OE15.4    OE15.5    OE15.7    OE30.1
OE30.2    OE30.3    OE30.4    OE30.5    OE30.6    OE30.7
OE30.9    OE510     OE810     OE830     OE920     OE950
PO100     PO20.1    PO21.1    PO21.2    PO21.3    PO21.5
PO21.6    PO22.1    PO22.2    PO22.3    PO25.1    PO25.2
PO25.4    PO26.1    PO28.6    PO30.1    PO31.1    PO32.1
PO33.1    PO34.1    PO35.1    PO530     PO821     PO990
PR128     PR131     PR132     PR134     PR136     PR137
PR140     PR150     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
PR530     PR80.1    PR82.1    PR85.1    PRSA.1    UK102
UK330     RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ12.1
RQ13.1    RQ20.1    RQ20.3    RQ20.4    RQ35.1    RQ500
RQ990     SL40.4    SLFD.1    UK120     WH130     WH132
WH190     WH20.2    WH20.7    WH30.1    WH30.2    WH30.3
WH31.1    WH31.2    WH31.3    WH32.1    WH32.2    WH32.3
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

AC160     AC170     AC176     AC40.1    AC540     AM115
AM125     AM135     AM145     AM15.1    AM15.2    AM15.3
AM15.4    AM170     AM190     AM192     AM20.1    AM20.2
AM20.3    AM20.4    AM20.5    AM20.6    AM30.1    AM30.2
AM40.1    AM40.2    AM500     AM96.1    AM98.1    AP170
AP175     AP185     AP190     AP191     AR190     BL123
BN190     CB175     DT190     EE175     CA190     GL135
GL146     GL165     GL170     GL195     GL40.1    GL40.2
GL40.3    GL40.8    GL40.9    GL44.1    GL45.1    GL75.1
IC125     IC130     GL01.4    GL105     GL311     GL312
GL313     OE130     PO135     PO180     PR195     PR199
TA195     WO140

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SYS-SYSTEM           Alpha 2                                     GL01.4  GL105
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
Description          The system code description.

SYS-RECORD-TYPE      Alpha 1                                     GL105
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
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-MACHINE-CODE     Alpha 12                                    GL01.4
Machine              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                                  AC160   AC170
Object ID            This is a the last unique transaction       AC176   AC40.1
                     identifier value assigned to a general      AC540   AM115
                     ledger transaction destined for another     AM125   AM135
                     machine.                                    AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 AM40.1  AM40.2
                                                                 AM500   AM96.1
                                                                 AM98.1  AP170
                                                                 AP175   AP185
                                                                 AP190   AP191
                                                                 AR190   BL123
                                                                 BN190   CA190
                                                                 CB175   DT190
                                                                 EE175   GL135
                                                                 GL146   GL165
                                                                 GL170   GL195
                                                                 GL311   GL312
                                                                 GL313   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.8  GL40.9
                                                                 GL44.1  GL45.1
                                                                 GL75.1  IC125
                                                                 IC130   OE130
                                                                 ...

SYS-REMOTE-SLT-FL    Alpha 1                                     GL01.4
Remote Site          This field determines whether strategic
                     ledger information is processed
                     separately from daily transactions.

                     If you select Yes, strategic ledger
                     information is processed in the
                     Strategic Ledger Interface (SLIFGTFILE)
                     file to reduce processing time on the
                     daily interface file (IFGT). Run SL195
                     (Transaction Interface) to load
                     strategic information for use in the
                     Strategic Ledger system.

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


                         SYSTEMCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SYSSET1   SYSTEM                                                 AC160   AC170
                                                                 AC176   AC190
                                                                 AC256   AC40.1
                                                                 AC530   AC54.1
                                                                 AC540   AC70.1
                                                                 ACAC.1  AM115
                                                                 AM125   AM135
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM170
                                                                 AM190   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM30.1  AM30.2
                                                                 ...

                         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