|
|
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 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP23.1 AP30.2
AP32.2 BR40.1 BR42.1 CA10.2 CA10.6 GL146
GL165 GL197 GL256 GL40.1 GL40.2 GL40.3
GL40.4 GL40.7 GL40.8 GL44.1 GL45.1 GL50.4
GL65.1 GL70.1 GL70.2 GL70.3 GL70.6 GL205
MA41.2 MA43.2 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
Element: 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
Element: Description The source code description. GL105 GL167
GSR-SOURCE-TYPE Alpha 1 GL05.1 GL05.2
Element: 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
Element: Edit Type Indicates the type of transaction to be
edited.
S = Subledger
G = General Ledger
GSR-USED-FLAG Alpha 1 GL05.1 GL05.2
Element: Used Indicates if the record has been GL105
accessed by some source after creation.
GSR-ACTIVE-FLAG Alpha 1 GL05.1 GL05.2
Element: Active Indicates the source code status. Valid GL105 GL167
values are active and inactive.
A = Active
I = Inactive
GSR-LAST-SEQ Numeric 3 GL105
Element: Last Sequence The last sequence number.
GSR-LAST-FIELD-NBR Numeric 3 GL05.3 GL105
Element: Last Field NbrThe last field number. GL106
GSR-PRIMARY-SYSTEM Alpha 2 GL105
Element: System Code The primary system associated with the
source code.
GSR-SOURCE-GROUP Alpha 5 GL105
Element: Buyer 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
Element: Category DescrThe attribute category description.
GSR-CAT2-DESC Derived
Element: Category DescrThe attribute category description.
GSR-CAT3-DESC Derived
Element: Category DescrThe attribute category description.
GLSRCCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GSRSET1 SOURCE-CODE AC190 AC256
AC54.1 AC540
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP30.2
AP32.2 BR40.1
BR42.1 CA10.2
CA10.6 GL146
GL165 GL167
GL197 GL256
GL40.1 GL40.2
GL40.3 GL40.4
GL40.7 GL40.8
GL44.1 GL45.1
...
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
|
