Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLSCCAT


                              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    GL106     AC190     AC197     MX00.1

UPDATED BY

GL05.1    GL05.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GSC-SOURCE-CODE        Alpha 2                                   GL05.1  GL05.2
Element: 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
Element: Sequence NumbeAn automatically assigned sequence
                       number.

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

GSC-FIELD-ID           Numeric 3                                 GL05.1  GL05.2
Element: 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
Element: Matrix CategorYou 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
Element: Ac Flag       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
Element: 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
Element: 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
Element: 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                                GL05.3  GL106
          FIELD-NAME
          SEQ-NBR

GSCSET3   MATRIX-CAT    KeyChange                                AC190   AC197
          SOURCE-CODE                                            MX00.1
          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 (GSR-SOURCE-TYPE = "L" )

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