|
|
GLSRCCODE FILE
General Ledger Source Code
This file contains the Lawson and user-defined source codes defined in GL05.1
(Source Code) and GL105 (System, Source Code Load).
REFERENCED BY
AC190 AC256 AC54.1 AC540 AC70.1 AP20.1
AP20.2 AP20.5 AP20.7 AP23.1 AP30.2 AP32.2
CA10.2 CA10.7 GL146 GL165 GL256 GL40.1
GL40.2 GL40.3 GL40.4 GL40.8 GL40.9 GL44.1
GL45.1 GL50.4 GL65.1 GL70.1 GL70.2 GL70.3
GL70.7 GL205 MA40.1 MA40.2 MA41.1 MA41.2
MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3
MA43.4 MA52.1 SL40.1 SL40.4
UPDATED BY
GL167 GL05.1 GL05.2 GL05.3 GL105 GL106
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GSR-SOURCE-CODE Alpha 2 GL05.1 GL05.2
Source Code A two-character code assigned to a GL105 GL167
transaction to identify where the
transaction was created.
GSR-DESCRIPTION Alpha 30 (Lower Case) GL05.1 GL05.2
Description The source code description. GL105 GL167
GSR-SOURCE-TYPE Alpha 1 GL05.1 GL05.2
Source Type Indicates if the source code is Lawson GL105 GL167
or user-defined.
L = Lawson
U = User
GSR-EDIT-TYPE Alpha 1 GL105 GL167
Edit Type Indicates the type of transaction to be
edited.
S = Subledger
G = General Ledger
GSR-USED-FLAG Alpha 1 GL05.1 GL05.2
Used Indicates if the record has been GL105
accessed by some source after creation.
GSR-ACTIVE-FLAG Alpha 1 GL05.1 GL05.2
Active Indicates the source code status. Valid GL105 GL167
values are active and inactive.
A = Active
I = Inactive
GSR-LAST-SEQ Numeric 3 GL105
Last Sequence Number The last sequence number.
GSR-LAST-FIELD-NBR Numeric 3 GL05.3 GL105
Last Field Number The last field number. GL106
GSR-PRIMARY-SYSTEM Alpha 2 GL105
System The primary system associated with the
source code.
GSR-SOURCE-GROUP Alpha 5 GL105
Source Group The application group associated with
the source code. For example,
Financials.
GSR-GLSCCAT-SEQ1 Derived
GL Source Code The attribute associated with a source
Category code.
GSR-GLSCCAT-SEQ2 Derived
GL Source Code The attribute associated with a source
Category code.
GSR-GLSCCAT-SEQ3 Derived
GL Source Code The attribute associated with a source
Category code.
GSR-CAT1-DESC Derived
Category Description The attribute category description.
GSR-CAT2-DESC Derived
Category Description The attribute category description.
GSR-CAT3-DESC Derived
Category Description The attribute category description.
GLSRCCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GSRSET1 SOURCE-CODE AC190 AC256
AC54.1 AC540
AC70.1 AP20.1
AP20.2 AP20.5
AP20.7 AP23.1
AP30.2 AP32.2
CA10.2 CA10.7
GL146 GL165
GL167 GL256
GL40.1 GL40.2
GL40.3 GL40.4
GL40.8 GL40.9
GL44.1 GL45.1
GL50.4 GL65.1
GL70.1 GL70.2
...
GSRSET3 PRIMARY-SYSTEMKeyChange
SOURCE-GROUP
SOURCE-CODE
GLSRCCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cat1 Desc MXCATDEF Not Required
GSC-MATRIX-CAT -> MXC-MATRIX-CAT (MXCSET1)
Cat2 Desc MXCATDEF Not Required
GSC-MATRIX-CAT -> MXC-MATRIX-CAT
Cat3 Desc MXCATDEF Not Required
GSC-MATRIX-CAT -> MXC-MATRIX-CAT
Glsccat Seq1 GLSCCAT Not Required
GSR-SOURCE-CODE -> GSC-SOURCE-CODE
1 -> GSC-SEQ-NBR
Glsccat Seq2 GLSCCAT Not Required
GSR-SOURCE-CODE -> GSC-SOURCE-CODE
2 -> GSC-SEQ-NBR
Glsccat Seq3 GLSCCAT Not Required
GSR-SOURCE-CODE -> GSC-SOURCE-CODE
3 -> GSC-SEQ-NBR
GLSRCCODE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Src Category GLSCCAT Delete Cascades
GSR-SOURCE-CODE -> GSC-SOURCE-CODE
GSC-SEQ-NBR
|