GLTWHDR – GL Transaction Writer Header
- System
- General Ledger (GL)
- Prefix
GWH- Primary key
TW-NAME- Fields
- 30
- Updated by
- 3 programs
- Referenced by
- 1 program
GLTWHDR is the GL Transaction Writer Header table in Lawson General Ledger (prefix GWH). It is indexed by TW-NAME (GWHSET1); alternate indexes: GWHSET2. It is related 1:1 to GLCODES, GLCHART, GLCHARTSUM, GLNAMES, GLSYSTEM, MXLISTHDR and MXOBJCAT and 1:M to GLTWLAYOUT and GLTWSEL. It is updated by GL256, GL55.1 and GL55.2 and referenced by GL255. The table has 30 fields, 2 indexes and 9 documented relations.
About GLTWHDR
The General Ledger Transaction Writer file contains report parameters defined in GL55.1 (Transaction Writer) and inputs the parameters into GL256 (Transaction Writer Report) to process the report.
Fields (30)
Column = COBOL field name without the GWH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GWH-TW-NAME PKTW_NAME | Alpha 12 | The name that identifies the report. | GL55.1, GL55.2 |
GWH-COMPLETE-FLAGCOMPLETE_FLAG | Alpha 1 | Indicates if the record is complete.
| GL55.1 |
GWH-FOLDER-NAMEFOLDER_NAME | Alpha 12 | This is the name of a folder. Folders are defined in RW01.1 (Folder). | GL55.1, GL55.2 |
GWH-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | The transaction writer report description. | GL55.1, GL55.2 |
GWH-COLM-SPACINGCOLM_SPACING | Numeric 2 | The default value used for creating spaces between columns. Valid values are 0-99. | GL55.1 |
GWH-COLM-HEAD-OPTCOLM_HEAD_OPT | Alpha 1 | Determines whether the two column heading lines are controlled manually or by the system (automatic).
| GL55.1 |
GWH-CSV-OUTPUTCSV_OUTPUT | Alpha 1 | A No value creates a 132-character wide report with up to two lines of detail per transaction. A Yes value creates a CSV file with two lines of detail strung into one line per transaction. The formatted heading line will be the first line of the CSV file. | GL55.1 |
GWH-SEARCH-METHODSEARCH_METHOD | Alpha 1 | The method used for transaction selection. S (System Control) enables the program to choose the best path and file based on the entered parameters. A (Account) uses the company, accounting unit, and account parameters. Only use this method if there are few accounts to be considered. C (Analysis Codes) uses analysis codes to select transactions to be included. H (Journal Header) uses the journal header file to select transactions to be included.
| GL55.1 |
GWH-LAST-RUN-DATELAST_RUN_DATE | Numeric 8 (yyyymmdd) | The last date the record was processed. | GL256, GL55.1, GL55.2 |
GWH-LAST-RUN-TIMELAST_RUN_TIME | Numeric 6 (hhmmss) | The last time the record was processed. | GL256, GL55.1, GL55.2 |
GWH-COMPANYCOMPANY | Numeric 4 | The company number as defined in GL10.1 (Company). | GL55.1 |
GWH-ACCT-UNITACCT_UNIT | Alpha 15 | The valid accounting unit used in conjunction with the company field. | GL55.1 |
GWH-COMPANY-GROUPCOMPANY_GROUP | Alpha 12 | A valid company group. All accounting units within each of the companies in the group are included. | GL55.1 |
GWH-MATRIX-LISTMATRIX_LIST | Alpha 12 | The Accounting unit list is one of the organizational parameter options as defined in MX10 (List) for object type ACCTU. | GL55.1 |
GWH-FR-ACCOUNTFR_ACCOUNT | Numeric 6 | The beginning account for a range of accounts. | GL55.1 |
GWH-TH-ACCOUNTTH_ACCOUNT | Numeric 6 | The ending account for a range of accounts. | GL55.1 |
GWH-ACCT-GROUPACCT_GROUP | Alpha 12 | An account group as defined in RW40.3 (Account Group). | GL55.1 |
GWH-CHART-NAMECHART_NAME | Alpha 12 | The name assigned to the chart of accounts when you defined your company structure in the General Ledger system. | GL55.1 |
GWH-SUMMARY-ACCTSUMMARY_ACCT | Alpha 12 | The summary account used in conjunction with the chart name. | GL55.1 |
GWH-FR-SUB-ACCTFR_SUB_ACCT | Numeric 4 | The beginning subaccount for a range of subaccounts. | GL55.1 |
GWH-TH-SUB-ACCTTH_SUB_ACCT | Numeric 4 | The ending subaccount for a range of subaccounts. | GL55.1 |
GWH-SUB-ACCT-GRPSUB_ACCT_GRP | Alpha 12 | A subaccount group as defined in RW40.4 (Subaccount Group). | GL55.1 |
GWH-LAST-SEQ-NBRLAST_SEQ_NBR | Numeric 6 | The last transaction sequence number. | GL55.1 |
GWH-SORT-MX-CATSORT_MX_CAT | Alpha 12 Occurs 8 Times ×8 | There are up to eight matrix attributes for sorting the selected objects. It does not have to be a selection category to be a sort category. The sort is in ascending order. | GL55.1 |
GWH-HEAD-LAYOUT-1HEAD_LAYOUT_1 | Alpha 132 (Lower Case) | The Header Layout line one. | GL55.1 |
GWH-HEAD-LAYOUT-2HEAD_LAYOUT_2 | Alpha 132 (Lower Case) | The header layout line two. | GL55.1 |
GWH-CURRENCY-CODECURRENCY_CODE | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | GL55.1 |
GWH-ACCOUNT-LISTACCOUNT_LIST | Alpha 12 | The Account List is one of the Account parameter options as defined in MX10 (List) for object type ACCNT. | GL55.1 |
GWH-LEDGERLEDGER | Alpha 15 | The name that identifies the strategic ledger. The Ledger information is used to post Strategic ledger data using SL190 (Strategic Ledger Posting) or used for reporting in the OLAP environment using SL87 (Strategic Ledger Data Mart Setup). | — |
GWH-LEVEL-GROUPLEVEL_GROUP | Alpha 12 | The Level Group is one of the organizational parameter options as defined in RW40.1 (Level Group). | GL55.1 |
Indexes (2)
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 |
|---|---|---|---|---|
GWHSET1 | TW-NAME | Primary | GL255, GL256, GL55.1, GL55.2 | |
GWHSET2 | FOLDER-NAME, TW-NAME | KeyChange | GL255 |
Relations
One to one (7) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Folder | GLCODES | Required | "F" → GCD-RECORD-TYPE, GWH-FOLDER-NAME → GCD-FOLDER-NAME, Spaces → GCD-PROCESS-GROUP, Spaces → GCD-SYSTEM, Zeroes → GCD-COMPANY | |
| Glchart | GLCHART | Not Required | GWH-CHART-NAME → GCH-CHART-NAME | |
| Glchartsum | GLCHARTSUM | Not Required | GWH-CHART-NAME → GCS-CHART-NAME, GWH-SUMMARY-ACCT → GCS-SUMMARY-ACCT | |
| Glnames | GLNAMES | Not Required | GWH-COMPANY → GLN-COMPANY, GWH-ACCT-UNIT → GLN-ACCT-UNIT | |
| Glsystem | GLSYSTEM | Not Required | GWH-COMPANY → GLS-COMPANY | |
| Mxlisthdr | MXLISTHDR | Not Required | "ACCTU" → MLH-OBJ-TYPE, GWH-MATRIX-LIST → MLH-MATRIX-LIST | |
| Mxobjcat | MXOBJCAT | Not Required | "GLTRN" → MOC-OBJ-TYPE, GWH-SORT-MX-CAT → MOC-MATRIX-CAT |
One to many (2) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Gltwlayout | GLTWLAYOUT | Delete Cascades | GWH-TW-NAME → GWL-TW-NAME, GWL-LINE, GWL-COLM-NBR | |
| Gltwsel | GLTWSEL | Delete Cascades | GWH-TW-NAME → GWS-TW-NAME, GWS-OR-GROUP, GWS-MATRIX-CAT, GWS-SEQ-NUMBER |
Programs
Updated by (3)
Referenced by (1)
- GL255 Transaction Writer Listing