GLSCCAT – GL Source Code Category

System
General Ledger Setup (IF)
Prefix
GSC
Primary key
SOURCE-CODE, SEQ-NBR
Fields
9
Updated by
2 programs
Referenced by
15 programs

GLSCCAT is the GL Source Code Category table in Lawson General Ledger Setup (prefix GSC). It is indexed by SOURCE-CODE, SEQ-NBR (GSCSET1); alternate indexes: GSCSET2 and GSCSET3. It is related 1:1 to MXCATDEF, GLSRCCODE and GLELMLIST. It is updated by GL05.1 and GL05.2 and referenced by AC190, AC197, CA10.2, GL106, GL205, GL70.1, GL70.2, GL70.3 and 7 more. The table has 9 fields, 3 indexes and 3 documented relations.

About GLSCCAT

This file contains a record for each category linked to a source code. There is a maximum of three records for each source code.

Fields (9)

Column = COBOL field name without the GSC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
GSC-SOURCE-CODE PK
SOURCE_CODE		Alpha 2A two-character code assigned to a transaction to identify where the transaction was created.GL05.1, GL05.2
GSC-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.GL05.1, GL05.2
GSC-FIELD-NAME
FIELD_NAME		Alpha 20 (Lower Case)Contains the originating field name.GL05.1, GL05.2
GSC-FIELD-ID
FIELD_ID		Numeric 3This field identifies the database field number to retrieve the transaction attribute value from. This value must match the element name assigned to the transaction attribute in MX00.1 (Attributes).GL05.1, GL05.2
GSC-MATRIX-CAT
MATRIX_CAT		Alpha 12You can associate an attribute with the source code to track Activity Management, General Ledger, or Profitability Ledger transactions. The default analysis is used as an additional mechanism to track and report on transactions. For example, use the Lawson-defined attribute "Acct Cat" to identify that a specific transaction includes account categories defined in the Activity Management system. Identify the system you want to use the default analysis in the Options section. The attribute must exist in MX00.1 (Attributes).GL05.1, GL05.2
GSC-AC-FLAG
AC_FLAG		Alpha 1This field determines whether the transaction attribute can be used with activity management transactions.
  • Y Yes
  • N No
GL05.1, GL05.2
GSC-GL-FLAG
GL_FLAG		Alpha 1This field determines whether the transaction attribute can be used with general ledger transactions.
  • Y Yes
  • N No
GL05.1, GL05.2
GSC-SL-FLAG
SL_FLAG		Alpha 1This field determines whether the transaction attribute can be used with strategic ledger transactions.GL05.1, GL05.2
GSC-ML-FLAG
ML_FLAG		Alpha 1This field determines whether the transaction attribute can be used with Multi-Ledger transactions.GL05.1, GL05.2

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GSCSET1SOURCE-CODE, SEQ-NBRPrimaryCA10.2, GL70.1, GL70.2, GL70.3, GL70.6, GL05.1, GL05.2, GL205 +5 more
GSCSET2SOURCE-CODE, FIELD-NAME, SEQ-NBRKeyChangeGL05.3, GL106
GSCSET3MATRIX-CAT, SOURCE-CODE, SEQ-NBRKeyChangeAC190, AC197, MX00.1

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Matrix CatMXCATDEFNot RequiredGSC-MATRIX-CAT → MXC-MATRIX-CAT
Source CodeGLSRCCODENot RequiredGSC-SOURCE-CODE → GSR-SOURCE-CODE
Src Code FieldGLELMLISTNot RequiredValid When (GSR-SOURCE-TYPE = "L")GSC-SOURCE-CODE → ELM-SOURCE-CODE, GSC-FIELD-NAME → ELM-FIELD-NAME

Programs

Updated by (2)

Referenced by (15)