GLTWSEL – GL Transaction Writer Select
- System
- General Ledger (GL)
- Prefix
GWS- Primary key
TW-NAME,OR-GROUP,MATRIX-CAT,SEQ-NUMBER- Fields
- 6
- Updated by
- 2 programs
- Referenced by
- 2 programs
GLTWSEL is the GL Transaction Writer Select table in Lawson General Ledger (prefix GWS). It is indexed by TW-NAME, OR-GROUP, MATRIX-CAT, SEQ-NUMBER (GWSSET1). 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 6 fields, 1 index and 1 documented relation.
About GLTWSEL
This file stores transaction writer report secondary values defined in GL55.1 (Transaction Writer).
Fields (6)
Column = COBOL field name without the GWS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GWS-TW-NAME PKTW_NAME | Alpha 12 | The Transaction Writer name. | GL55.1, GL55.2 |
GWS-OR-GROUP PKOR_GROUP | Alpha 1 | 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'. | GL55.1 |
GWS-SEQ-NUMBER PKSEQ_NUMBER | Numeric 6 | A unique number assigned to each transaction to be transferred into the Lawson system. | GL55.1 |
GWS-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | Attribute name assigned to General Ledger Transaction-type objects. Attributes are used in selection and sorting for reporting and analysis. | GL55.1 |
GWS-FR-MX-VALFR_MX_VAL | Alpha 32 | The beginning attribute value in a attribute range. | GL55.1 |
GWS-TH-MX-VALTH_MX_VAL | Alpha 32 | The ending value in a range of attribute values. | GL55.1 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GWSSET1 | TW-NAME, OR-GROUP, MATRIX-CAT, SEQ-NUMBER | Primary | GL255, GL256, GL55.1, GL55.2 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Mxobjcat | MXOBJCAT | Required | "GLTRN" → MOC-OBJ-TYPE, GWS-MATRIX-CAT → MOC-MATRIX-CAT |