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

AC00.1    AC191     AC256     AC295     AC297     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    AP125
AP126     AP131     AP193     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    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     BN66.1    BR40.1
BR42.1    CB10.1    CB180     CB191     CB20.1    CB30.1
CB500     CB80.1    EE135     EE35.1    EE35.2    EE520
CA110     FB190     FB40.1    FB40.2    FB40.3    FB45.1
GL100     GL199     GL241     GL50.4    GL65.1    GL90.3
IC222     IC28.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.2    MA43.2    MA43.9    MA530
MA531     MA60.2    MA60.3    MA60.5    MA61.1    MA66.3
MA67.1    MA67.2    MA70.1    MAI1.1    PO100     PO101
PO122     PO131     PO20.1    PO21.2    PO21.3    PO21.4
PO21.5    PO22.1    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     POI3.1    POIE.1    POIF.1
POII.1    POIJ.1    POIM.1    PR128     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     RQ10.1    RQ10.2
SL195     SLFD.1    TA147     UK120     WH20.2    WH20.7

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    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     BR130     BR131     BR41.1    BRIP.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     PR195     PR198
TA195     TA196

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                                     GL01.4  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  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
                                                                 BR130   BR131
                                                                 BR41.1  BRIP.1
                                                                 ...

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
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
Gl Commit Fl

SYS-GL-BUD-FL        Alpha 1                                     GL01.4
Gl Bud Fl

SYS-AC-RNI-UPD-OPT   Alpha 1                                     GL01.4
Ac Rni Upd Opt

SYS-COMMT-DT-FL-PO   Alpha 1                                     GL01.4
Commt Dt Fl Po

SYS-COMMT-DT-FL-RQ   Alpha 1                                     GL01.4
Commt Dt Fl Rq

                         SYSTEMCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SYSSET1   SYSTEM                                                 AC00.1  AC131
                                                                 AC160   AC170
                                                                 AC176   AC190
                                                                 AC191   AC198
                                                                 AC256   AC295
                                                                 AC297   AC40.4
                                                                 AC41.4  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
                                                                 AC97.2  AC97.4
                                                                 ...

                         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