Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            SYSTEMCODE FILE

                              System Code

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

REFERENCED BY

AC256     AC295     AC297     AC530     AC54.1    AC541
AC741     AC90.2    AC90.4    AC90.6    AC90.8    AC95.2
AC95.4    AC95.6    AC97.2    AC97.4    AC97.6    ACAC.1
ACVW.1    GR741     SE90.1    AP193     AP30.2    AP30.4
AP32.2    AP520     API1.1    API2.1    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
BR40.1    BR42.1    CB10.1    CB180     CB191     CB20.1
CB30.1    CB80.1    EE135     EE35.1    EE35.2    EE520
GL199     GL241     GL50.4    GL90.3    GL02.3    GL03.4
GL03.5    GL123     GL124     GL13.4    GL14.2    GL160
GL205     GL60.1    IFGT.1    IFRS.1    POIF.1    PR128
PR131     PR132     PR134     PR136     PR137     PR197
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     PR82.1
PR85.1    PRSA.1    UK102     UK330     SLFD.1    UK120

UPDATED BY

AC131     AC160     AC170     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    AM40.1    AM40.2    AM41.1    AM500     AM551
AM96.1    AM98.1    AP170     AP175     AP176     AP185
AP190     AP191     AR190     BL123     BN190     BR41.1
BRIP.1    CB175     DT190     EE175     CA190     GL135
GL146     GL165     GL170     GL195     GL40.1    GL40.2
GL40.3    GL40.7    GL40.8    GL44.1    GL45.1    GL75.1
IC125     IC130     GL01.4    GL105     GL311     GL312
GL313     PO135     PO136     PR195     PR198     TA195

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-REMOTE-SLT-FL    Alpha 1                                     GL01.4
Remote Slt Fl        This field determines whether
                     profitability ledger information is
                     processed separately from daily
                     transactions.

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



SYS-MACHINE-CODE     Alpha 12                                    GL01.4
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       AC170   AC176
Identification       identifier value assigned to a general      AC190   AC198
                     ledger transaction destined for another     AC40.4  AC41.4
                     machine.                                    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  AM40.1
                                                                 AM40.2  AM41.1
                                                                 AM500   AM551
                                                                 AM96.1  AM98.1
                                                                 AP170   AP175
                                                                 AP176   AP185
                                                                 AP190   AP191
                                                                 AR190   BL123
                                                                 BN190   BR41.1
                                                                 BRIP.1  CA190
                                                                 CB175   DT190
                                                                 EE175   GL135
                                                                 ...

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

                         SYSTEMCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SYSSET1   SYSTEM                                                 AC131   AC160
                                                                 AC170   AC176
                                                                 AC190   AC198
                                                                 AC256   AC295
                                                                 AC297   AC40.4
                                                                 AC41.4  AC45.4
                                                                 AC530   AC54.1
                                                                 AC540   AC541
                                                                 AC542   AC741
                                                                 AC90.2  AC90.4
                                                                 AC90.6  AC90.8
                                                                 AC95.2  AC95.4
                                                                 AC95.6  AC97.2
                                                                 AC97.4  AC97.6
                                                                 ACAC.1  ACVW.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