Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLSRCCODE


                             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