GLSCCAT

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 ML70.1 ML70.2 ML70.3 ML70.6 GL106
AC190 AC197 MX00.1


UPDATED BY
GL05.1 GL05.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GSC-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
GSC-SEQ-NBR
Element: Sequence Number
Numeric 4
An automatically assigned sequence number.
GL05.1 GL05.2
GSC-FIELD-NAME
Element: Field Name
Alpha 20 (Lower Case)
Contains the originating field name.
GL05.1 GL05.2
GSC-FIELD-ID
Element: Field ID
Numeric 3
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).
GL05.1 GL05.2
GSC-MATRIX-CAT
Element: Matrix Category
Alpha 12
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).
GL05.1 GL05.2
GSC-AC-FLAG
Element: Ac Flag
Alpha 1
This field determines whether the transaction attribute can be used with activity management transactions.
Y = Yes
N = No
GL05.1 GL05.2
GSC-GL-FLAG
Element: Gl Flag
Alpha 1
This field determines whether the transaction attribute can be used with general ledger transactions.
Y = Yes
N = No
GL05.1 GL05.2
GSC-SL-FLAG
Element: Sl Flag
Alpha 1
This field determines whether the transaction attribute can be used with strategic ledger transactions.
GL05.1 GL05.2
GSC-ML-FLAG
Element: Ml Flag
Alpha 1
This field determines whether the transaction attribute can be used with Multi-Ledger transactions.
GL05.1 GL05.2


GLSCCAT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GSCSET1 SOURCE-CODE
SEQ-NBR
CA10.2 GL70.1
GL70.2 GL70.3
GL70.6 GL05.1
GL05.2 GL205
IFSC.1 ML70.1
ML70.2 ML70.3
ML70.6
GSCSET2 SOURCE-CODE
FIELD-NAME
SEQ-NBR
KeyChange
GL05.3 GL106
GSCSET3 MATRIX-CAT
SOURCE-CODE
SEQ-NBR
KeyChange
AC190 AC197
MX00.1


GLSCCAT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:20:46 2016

Home
Contact Us



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