GLSRCCODE

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
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP23.1 AP30.2 CB43.1 CB44.1 CB45.1
CB46.1 CB50.1 CB500 CB54.1 CB543 CB544
CB55.1 CB554 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 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 SL40.1 SL40.4


UPDATED BY
GL167 GL05.1 GL05.2 GL05.3 GL105 GL106
GL205

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GSR-SOURCE-CODE
Element: Source Code
Alpha 2
A two-character code assigned to a transaction to identify where the transaction was created.
GL05.1 GL05.2
GL105 GL167
GSR-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The source code description.
GL05.1 GL05.2
GL105 GL167
GSR-SOURCE-TYPE
Element: Source Type
Alpha 1
Indicates if the source code is Lawson or user-defined.
L = Lawson
U = User
GL05.1 GL05.2
GL105 GL167
GSR-EDIT-TYPE
Element: Edit Type
Alpha 1
Indicates the type of transaction to be edited.
S = Subledger
G = General Ledger
GL105 GL167
GSR-USED-FLAG
Element: Used
Alpha 1
Indicates if the record has been accessed by some source after creation.
GL05.1 GL05.2
GL105
GSR-LAST-SEQ
Element: Last Sequence Number
Numeric 3
The last sequence number.
GL105
GSR-LAST-FIELD-NBR
Element: Last Field Nbr
Numeric 3
The last field number.
GL05.3 GL105
GL106
GSR-PRIMARY-SYSTEM
Element: System
Alpha 2
The primary system associated with the source code.
GL105
GSR-SOURCE-GROUP
Element: Source Group
Alpha 5
The application group associated with the source code. For example, Financials.
GL105
GSR-GLSCCAT-SEQ1
GL Source Code
Category
Derived
The attribute associated with a source code.
GSR-GLSCCAT-SEQ2
GL Source Code
Category
Derived
The attribute associated with a source code.
GSR-GLSCCAT-SEQ3
GL Source Code
Category
Derived
The attribute associated with a source code.
GSR-CAT1-DESC
Element: Category Description
Derived
The attribute category description.
GSR-CAT2-DESC
Element: Category Description
Derived
The attribute category description.
GSR-CAT3-DESC
Element: Category Description
Derived
The attribute category description.


GLSRCCODE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GSRSET1 SOURCE-CODE
...
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP30.2 CB43.1
CB44.1 CB45.1
CB46.1 CB50.1
CB500 CB54.1
CB543 CB544
CB55.1 CB554
CA10.2 CA10.6
GL146 GL165
GL167 GL197
GL256 GL40.1
GL40.2 GL40.3


GLSRCCODE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Src Category GLSCCAT Delete Cascades
GSR-SOURCE-CODE->GSC-SOURCE-CODE
  GSC-SEQ-NBR


File created: Wed Jun 08 20:49:45 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.