Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            GLTWLAYOUT FILE

                      GL Transaction Writer Layout

The General Ledger Transaction Writer Layout file stores transaction writer
layout information defined in the Layout form tab in GL55.1 (Transaction
Writer).


REFERENCED BY

GL255     GL256

UPDATED BY

GL55.1    GL55.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

GWL-TW-NAME          Alpha 12                                    GL55.1  GL55.2
Name                 The Transaction Writer name.

GWL-LINE             Numeric 2                                   GL55.1
Line                 The line number determines whether the
                     columns being maintained are on line 1
                     or line 2.

                     01 = Line 1
                     02 = Line 2

GWL-COLM-NBR         Numeric 2                                   GL55.1
Column Number        The column number within the line
                     number.


GWL-MATRIX-CAT       Alpha 12                                    GL55.1
Matrix Attribute     The attributes defined for General
                     Ledger transaction-type objects.
                     Attributes are used in selection and
                     sorting for reporting and analysis.


GWL-FIELD-SIZE       Numeric 2                                   GL55.1
Field Size           The size of the column. Date fields are
                     8, Numeric fields are a maximum of 18,
                     and alpha fields are a maximum of 20.


GWL-DECIMALS         Numeric 1                                   GL55.1
Decimals             The decimal values for the column are
                     0-6. Zero is the default. Decimals are
                     only used with amount and currency
                     rate-type fields.

                     0
                     1
                     2
                     3
                     4
                     5
                     6

GWL-COLM-SPACING     Numeric 2                                   GL55.1
Column Spacing       The number of blank spaces preceding
                     the column.


GWL-COUNT-TOT-OPT    Alpha 1                                     GL55.1
Count Total Option   Counts either the number of records in
                     an alpha or date field or totals the
                     value in a numeric field.

                     Y = Yes
                     N = No

GWL-TOTAL-BREAK      Alpha 1                                     GL55.1
Total Break          Determines if totals print when the
                     value in this field changes. No is the
                     default.

                     Y = Yes
                     N = No

GWL-PAGE-BREAK       Alpha 1                                     GL55.1
Page Break           Determines if a page break occurs when
                     the value in this field changes. No is
                     the default.

                     Y = Yes
                     N = No

GWL-DESC-OF          Alpha 1                                     GL55.1
Description Of       Determines if the description of the
                     field will print. No is the default.

                     Y = Yes
                     N = No

GWL-SUPR-COLM-DUPS   Alpha 1                                     GL55.1
Supress Column       Determines if the field value will
Duplicates           print if it equals the previous
                     transaction. No is the default.

                     Y = Yes
                     N = No

GWL-SUPR-LINE-DUPS   Alpha 1                                     GL55.1
Supress Line         Determines if the entire line will
Duplicates           print if it equals the previous
                     transaction field value. No is the
                     default.

                     Y = Yes
                     N = No

GWL-ALIGN-HEADING    Alpha 1                                     GL55.1
Align Heading        Determines how the heading aligns over
                     the field values. Left align defaults
                     for alpha fields. Right align defaults
                     for all other fields.
                     The heading is aligned based on the
                     entire column size.


                     L = Left
                     R = Right
                     C = Center
                     N = None

                         GLTWLAYOUT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GWLSET1   TW-NAME       KeyChange                                GL255   GL256
          LINE                                                   GL55.1  GL55.2
          COLM-NBR

GWLSET2   MATRIX-CAT    KeyChange
          TW-NAME
          LINE
          COLM-NBR

                         GLTWLAYOUT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxobjcat       MXOBJCAT     Required

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