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    AC191     AC256     AC295
AC346     AC42.1    AC46.1    AC50.2    AC502     AC54.1
AC90.2    AC90.4    AC90.6    AC90.8    AC95.2    AC95.4
AC95.6    ACAC.1    ACVW.1    SE90.1    AP125     AP126
AP131     AP193     AP25.1    AP25.2    AP26.1    AP27.1
AP30.2    AP30.4    AP520     API1.1    API2.1    AR09.1
AR09.4    AR115     AR124     AR190     AR20.1    AR21.1
AR21.2    AR21.3    AR24.1    AR29.2    AR30.1    AR34.1
AR42.1    AR42.2    AR42.7    AR43.1    AR560     AR570
AR575     AR580     ARLL.1    BL120     BL122     BL130
BL20.1    BL20.3    BL21.2    BL21.5    BL29.1    BL29.2
BL520     BL820     BL92.1    BN150     BR190     BR40.1
BR42.2    BR43.1    BR44.1    BR96.1    CB10.1    CB15.1
CB15.2    CB180     CB191     CB20.1    CB30.1    CB500
CB80.1    CXCP.1    EE135     EE20.3    EE35.1    EE35.2
EE520     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
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     DR100     IC140     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    MA530
MA531     MA60.2    MA60.3    MA60.5    MA61.1    MA65.1
MA66.2    MA66.3    MA67.1    MA67.2    MA70.1    MA75.1
MA80.1    MAI1.1    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     OE111     OE113     OE114
OE116     OE129     OE13.2    OE13.3    OE13.5    OE13.6
OE14.4    OE30.1    OE30.2    OE30.3    OE30.4    OE30.5
OE30.6    OE30.7    OE30.9    OE510     OE530     OE81.1
OE810     OE830     OE90.1    OE90.2    PA02.1    PA100
PA102     PA13.1    PA13.2    PA182     PA502     PA513
PA52.1    PA52.3    PA52.4    PA52.5    PO100     PO101
PO122     PO131     PO150     PO20.1    PO21.2    PO21.3
PO21.4    PO21.5    PO22.1    PO23.1    PO25.1    PO25.6
PO25.7    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     PO536     POCP.1    POI3.1    POID.1    POIE.1
POIF.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
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     PR82.1    PR85.1
PRSA.1    UK102     UK330     RQ10.1    RQ10.2    RQ12.1
RQ13.1    RQ13.2    RQ140     RQ300     RQ35.1    RQ40.1
RQ41.1    RQ42.1    RQ44.1    RQ44.2    RQ500     RQIF.1
SL40.4    SLFD.1    TA147     TP135     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     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     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    AP170     AP175     AP176
AP185     AP190     AP191     BL123     BN190     BR130
BR131     BR140     BR41.4    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     MA180     OE130     PO135
PO136     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:
                       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  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
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
Object                 This is a the last unique transaction     AC160   AC190
Identification         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
                                                                 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  AP170
                                                                 AP175   AP176
                                                                 AP185   AP190
                                                                 AP191   BL123
                                                                 BN190   BR130
                                                                 ...

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)                    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
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

                         SYSTEMCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SYSSET1   SYSTEM                                                 AC00.1  AC10.6
                                                                 AC10.7  AC131
                                                                 AC145   AC160
                                                                 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   AC90.2
                                                                 AC90.4  AC90.6
                                                                 AC90.8  AC95.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