|
|
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
AC145 AC190 AC197 AC198 AC256 AC45.1
AC54.1 AC540 AP30.2 BR190 BR40.1 BR42.2
BR44.1 BR96.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 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-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: 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
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 AC145 AC190
AC197 AC198
AC256 AC45.1
AC54.1 AC540
AP30.2 BR190
BR40.1 BR42.2
BR44.1 BR96.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 GL50.4
...
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
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
|
