Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLTWSEL


                              GLTWSEL FILE

                      GL Transaction Writer Select

This file stores transaction writer report secondary values defined in GL55.1
(Transaction Writer).


REFERENCED BY

GL255     GL256

UPDATED BY

GL55.1    GL55.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GWS-TW-NAME            Alpha 12                                  GL55.1  GL55.2
Element: Name          The Transaction Writer name.

GWS-OR-GROUP           Alpha 1                                   GL55.1
Element: Or Group      A single value used to group multiple
                       selections together. Each group of value
                       selections will be treated internally as
                       an 'and' and externally as an 'or'.


GWS-SEQ-NUMBER         Numeric 6                                 GL55.1
Element: Sequence NumbeA unique number assigned to each
                       transaction to be transferred into the
                       Lawson system.


GWS-MATRIX-CAT         Alpha 12                                  GL55.1
Element: Matrix AttribuAttribute name assigned to General
                       Ledger Transaction-type objects.
                       Attributes are used in selection and
                       sorting for reporting and analysis.


GWS-FR-MX-VAL          Alpha 32                                  GL55.1
Element: From Matrix VaThe beginning attribute value in a
                       attribute range.


GWS-TH-MX-VAL          Alpha 32                                  GL55.1
Element: To Matrix ValuThe ending value in a range of
                       attribute values.


                         GLTWSEL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GWSSET1   TW-NAME                                                GL255   GL256
          OR-GROUP                                               GL55.1  GL55.2
          MATRIX-CAT
          SEQ-NUMBER

GWSSET2   MATRIX-CAT    KeyChange
          TW-NAME
          OR-GROUP
          SEQ-NUMBER

                         GLTWSEL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxobjcat       MXOBJCAT     Required

                            "GLTRN"           -> MOC-OBJ-TYPE  (MOCSET1)
                            GWS-MATRIX-CAT    -> MOC-MATRIX-CAT