SYSTEMCODE – System Code

System
General Ledger Setup (IF)
Prefix
SYS
Primary key
SYSTEM
Fields
22
Updated by
334 programs
Referenced by
444 programs

SYSTEMCODE is the System Code table in Lawson General Ledger Setup (prefix SYS). It is indexed by SYSTEM (SYSSET1). It is related 1:M to GLCODES. It is updated by AC131, AC145, AC160, AC190, AC197, AC198, AC40.4, AC41.4 and 326 more and referenced by AC00.1, AC00.3, AC02.1, AC06.1, AC06.2, AC08.1, AC08.2, AC08.3 and 436 more. The table has 22 fields, 1 index and 1 documented relation.

About SYSTEMCODE

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

Fields (22)

Column = COBOL field name without the SYS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#SYS-SYSTEM PK
SYSTEM		Alpha 2A two-character code representing an application used within the Lawson system. (i.e., GL = General Ledger, AP = Accounts Payable, etc.)GL01.4, GL105
#SYS-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The system code description.GL01.4, GL105
#SYS-RECORD-TYPE
RECORD_TYPE		Alpha 1This field identifies the type of record defined. Valid values are:
  • L Lawson
  • U User
GL01.4, GL105
#SYS-REMOTE-SITE-FL
REMOTE_SITE_FL		Alpha 1This 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
GL01.4, GL105
#SYS-REMOTE-SLT-FL
REMOTE_SLT_FL		Alpha 1—GL01.4
#SYS-MACHINE-CODE
MACHINE_CODE		Alpha 12This 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.GL01.4
#SYS-OBJ-ID
OBJ_ID		Numeric 12This is a the last unique transaction identifier value assigned to a general ledger transaction destined for another machine.AC131, AC145, AC160, AC190, AC197, AC198, AC40.4, AC41.4 +52 more (list truncated in source)
#SYS-AC-COMMIT-FL
AC_COMMIT_FL		Alpha 1This 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.GL01.4
#SYS-AC-BUD-FL
AC_BUD_FL		Alpha 1This field determines whether budgets are edited when transactions are transferred to the Activity Management system.GL01.4
#SYS-COMMIT-PCT
COMMIT_PCT		Percent 6.2 (Percent)—AC297, GL01.4
#SYS-GL-COMMIT-FL
GL_COMMIT_FL		Alpha 1This is the Yes/No flag for GL commitments.GL01.4
#SYS-GL-BUD-FL
GL_BUD_FL		Alpha 1This is the Yes/No flag indicating whether GL commitments should be edited against a budget.GL01.4
#SYS-AC-RNI-UPD-OPT
AC_RNI_UPD_OPT		Alpha 1This is the Yes/No flag indicating whether PO135 will create accruals in AC.GL01.4
#SYS-COMMT-DT-FL-PO
COMMT_DT_FL_PO		Alpha 1This is the option field indicating whether PO Date or Delivery Date will be used with PO commitments.GL01.4
#SYS-COMMT-DT-FL-RQ
COMMT_DT_FL_RQ		Alpha 1This is the option field indicating whether RQ Creation or Delivery Date will be used with RQ commitments.GL01.4
#SYS-PSA-HR-FL
PSA_HR_FL		Alpha 1This field is used to indicate if the client is using Lawson HR.GL01.4, GL105
#SYS-PSA-PR-FL
PSA_PR_FL		Alpha 1This field is used to indicate if the client is using Lawson PR.GL01.4, GL105
#SYS-CURR-POST-LVL
CURR_POST_LVL		Alpha 1——
#SYS-RETAIL-FLAG
RETAIL_FLAG		Numeric 1—GL01.4, GL105
#SYS-GL-COMHIS-FL
GL_COMHIS_FL		Alpha 1—GL01.4
#SYS-AUDIT-FLAG
AUDIT_FLAG		Alpha 1—GL01.4
#SYS-RECOGNIZE-REV
RECOGNIZE_REV		Alpha 1—
  • C Cash Application
  • I Invoicing
GL01.4

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
SYSSET1
  1. SYSTEM
PrimaryAC00.1, AC00.3, AC02.1, AC06.1, AC06.2, AC08.1, AC08.2, AC08.3 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLCODESSYSTEMCODE

One to many (1) — child tables

RelationTableRulesConditionField map
GlcodesGLCODES
"C"→GCD-RECORD-TYPE
Spaces→GCD-FOLDER-NAME
Spaces→GCD-PROCESS-GROUP
SYS-SYSTEM→GCD-SYSTEM
—→GCD-COMPANY

Programs

Updated by (334)

Referenced by (444)