GLELMLIST

General Ledger Element List

This file contains valid source code and category relationship records.

REFERENCED BY
GL205 MX00.2 MX100


UPDATED BY
GL05.1 GL05.2 GL05.3 GL106

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ELM-SOURCE-CODE
Element: Source Code
Alpha 2
A two-character code assigned to a transaction that identifies where it was created.
GL05.3 GL106
ELM-FIELD-NAME
Element: Field Name
Alpha 20 (Lower Case)
The element field name used to identify transactions.
GL05.3 GL106
ELM-ELEMENT-NAME
Element: Element Name
Alpha 20
The name that identifies the element associated with the attribute.
GL05.3 GL106
ELM-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This is the database field description.
GL05.3 GL106
ELM-SOURCE-TYPE
Element: Source Type
Alpha 1
Determines if the source code is Lawson or user-defined.
L = Lawson
U = User
GL05.3 GL106
ELM-FIELD-ID
Element: Field ID
Numeric 3
The originating system field ID number.
GL05.3 GL106


GLELMLIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ELMSET1 SOURCE-CODE
FIELD-NAME
GL05.1 GL05.2
GL05.3 GL106
GL205
ELMSET2 ELEMENT-NAME
SOURCE-CODE
FIELD-NAME
KeyChange
MX00.2 MX100
ELMSET3 SOURCE-CODE
FIELD-ID
GL05.1 GL05.2
GL05.3


GLELMLIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Mxelement MXELEMENT Required
ELM-ELEMENT-NAME->MXE-ELEMENT-NAME
Source Code GLSRCCODE Required
ELM-SOURCE-CODE->GSR-SOURCE-CODE


GLELMLIST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glsccat GLSCCAT
ELM-SOURCE-CODE->GSC-SOURCE-CODE
ELM-FIELD-NAME->GSC-FIELD-NAME
  GSC-SEQ-NBR


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

Home
Contact Us



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