Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              GLSCCAT FILE

                        GL Source Code Category

This file contains a record for each category linked to a source code. There
is a maximum of three records for each source code.


REFERENCED BY

CA10.2    GL70.1    GL70.2    GL70.3    GL70.6    GL205
IFSC.1    AC190     AC541     AC741     GR741     MX00.1

UPDATED BY

GL05.1    GL05.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

GSC-SOURCE-CODE      Alpha 2                                     GL05.1  GL05.2
Source Code          A two-character code assigned to a
                     transaction to identify where the
                     transaction was created.


GSC-SEQ-NBR          Numeric 4                                   GL05.1  GL05.2
Sequence Number      An automatically assigned sequence
                     number.

GSC-FIELD-NAME       Alpha 20  (Lower Case)                      GL05.1  GL05.2
Field Name           Contains the originating field name.

GSC-FIELD-ID         Numeric 3                                   GL05.1  GL05.2
Field ID             This field identifies the database
                     field number to retrieve the transaction
                     attribute value from. This value must
                     match the element name assigned to the
                     transaction attribute in MX00.1
                     (Attributes).


GSC-MATRIX-CAT       Alpha 12                                    GL05.1  GL05.2
Matrix Category      You can associate an attribute with the
                     source code to track Activity
                     Management, General Ledger, or
                     Profitability Ledger transactions. The
                     default analysis is used as an
                     additional mechanism to track and report
                     on transactions. For example, use the
                     Lawson-defined attribute "Acct Cat" to
                     identify that a specific transaction
                     includes account categories defined in
                     the Activity Management system.

                     Identify the system you want to use the
                     default analysis in the Options section.
                     The attribute must exist in MX00.1
                     (Attributes).



GSC-AC-FLAG          Alpha 1                                     GL05.1  GL05.2
Activity Management  This field determines whether the
                     transaction attribute can be used with
                     activity management transactions.

                     Y = Yes
                     N = No

GSC-GL-FLAG          Alpha 1                                     GL05.1  GL05.2
Gl Flag              This field determines whether the
                     transaction attribute can be used with
                     general ledger transactions.

                     Y = Yes
                     N = No

GSC-SL-FLAG          Alpha 1                                     GL05.1  GL05.2
Sl Flag              This field determines whether the
                     transaction attribute can be used with
                     strategic ledger transactions.


GSC-ML-FLAG          Alpha 1                                     GL05.1  GL05.2
Ml Flag              This field determines whether the
                     transaction attribute can be used with
                     Multi-Ledger transactions.

                         GLSCCAT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GSCSET1   SOURCE-CODE                                            CA10.2  GL70.1
          SEQ-NBR                                                GL70.2  GL70.3
                                                                 GL70.6  GL05.1
                                                                 GL05.2  GL205
                                                                 IFSC.1

GSCSET2   SOURCE-CODE   KeyChange                                AC190   AC541
          FIELD-NAME                                             AC741   GR741
          SEQ-NBR                                                GL05.3

GSCSET3   MATRIX-CAT    KeyChange                                MX00.1
          SOURCE-CODE
          SEQ-NBR

                         GLSCCAT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Matrix Cat     MXCATDEF     Not Required

                            GSC-MATRIX-CAT     -> MXC-MATRIX-CAT

Source Code    GLSRCCODE    Not Required

                            GSC-SOURCE-CODE    -> GSR-SOURCE-CODE

Src Code Field GLELMLIST    Not Required
                            Valid When (GSC-SOURCE-TYPE = "L" )

                            GSC-SOURCE-CODE    -> ELM-SOURCE-CODE
                            GSC-FIELD-NAME     -> ELM-FIELD-NAME