GLTWLAYOUT – GL Transaction Writer Layout

System
General Ledger (GL)
Prefix
GWL
Primary key
TW-NAME, LINE, COLM-NBR
Fields
14
Updated by
2 programs
Referenced by
2 programs

GLTWLAYOUT is the GL Transaction Writer Layout table in Lawson General Ledger (prefix GWL). It is indexed by TW-NAME, LINE, COLM-NBR (GWLSET1). It is related 1:1 to MXOBJCAT. It is updated by GL55.1 and GL55.2 and referenced by GL255 and GL256. The table has 14 fields, 1 index and 1 documented relation.

About GLTWLAYOUT

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

Fields (14)

Column = COBOL field name without the GWL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
GWL-TW-NAME PK
TW_NAME		Alpha 12The Transaction Writer name.GL55.1, GL55.2
GWL-LINE PK
LINE		Numeric 2The line number determines whether the columns being maintained are on line 1 or line 2.
  • 01 Line 1
  • 02 Line 2
GL55.1
GWL-COLM-NBR PK
COLM_NBR		Numeric 2The column number within the line number.GL55.1
GWL-MATRIX-CAT
MATRIX_CAT		Alpha 12The attributes defined for General Ledger transaction-type objects. Attributes are used in selection and sorting for reporting and analysis.GL55.1
GWL-FIELD-SIZE
FIELD_SIZE		Numeric 2The size of the column. Date fields are 8, Numeric fields are a maximum of 18, and alpha fields are a maximum of 20.GL55.1
GWL-DECIMALS
DECIMALS		Numeric 1The 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 6GL55.1
GWL-COLM-SPACING
COLM_SPACING		Numeric 2The number of blank spaces preceding the column.GL55.1
GWL-COUNT-TOT-OPT
COUNT_TOT_OPT		Alpha 1Counts either the number of records in an alpha or date field or totals the value in a numeric field.
  • Y Yes
  • N No
GL55.1
GWL-TOTAL-BREAK
TOTAL_BREAK		Alpha 1Determines if totals print when the value in this field changes. No is the default.
  • Y Yes
  • N No
GL55.1
GWL-PAGE-BREAK
PAGE_BREAK		Alpha 1Determines if a page break occurs when the value in this field changes. No is the default.
  • Y Yes
  • N No
GL55.1
GWL-DESC-OF
DESC_OF		Alpha 1Determines if the description of the field will print. No is the default.
  • Y Yes
  • N No
GL55.1
GWL-SUPR-COLM-DUPS
SUPR_COLM_DUPS		Alpha 1Determines if the field value will print if it equals the previous transaction. No is the default.
  • Y Yes
  • N No
GL55.1
GWL-SUPR-LINE-DUPS
SUPR_LINE_DUPS		Alpha 1Determines if the entire line will print if it equals the previous transaction field value. No is the default.
  • Y Yes
  • N No
GL55.1
GWL-ALIGN-HEADING
ALIGN_HEADING		Alpha 1Determines 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
GL55.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GWLSET1TW-NAME, LINE, COLM-NBRPrimaryGL255, GL256, GL55.1, GL55.2

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
MxobjcatMXOBJCATRequired"GLTRN" → MOC-OBJ-TYPE, GWL-MATRIX-CAT → MOC-MATRIX-CAT

Programs

Updated by (2)

Referenced by (2)