Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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
Name                 The Transaction Writer name.

GWS-OR-GROUP         Alpha 1                                     GL55.1
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
Sequence Number      A unique number assigned to each
                     transaction to be transferred into the
                     Lawson system.


GWS-MATRIX-CAT       Alpha 12                                    GL55.1
Matrix Attribute     Attribute 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
From Matrix Value    The beginning attribute value in a
                     attribute range.


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


                         GLTWSEL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GWSSET1   TW-NAME       KeyChange                                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