GLRPTDEF – General Ledger Report Setup

System
General Ledger (GL)
Prefix
GLR
Primary key
COMPANY, REPORT-NAME
Fields
15
Updated by
6 programs
Referenced by
1 program

GLRPTDEF is the General Ledger Report Setup table in Lawson General Ledger (prefix GLR). It is indexed by COMPANY, REPORT-NAME (GLRSET1). It is related 1:1 to GLSYSTEM and 1:M to GLRPTSEL. It is updated by GL110, GL290, GL50.1, GL50.2, GL50.4 and GL50.5 and referenced by GL250. The table has 15 fields, 1 index and 2 documented relations.

About GLRPTDEF

This file contains report parameters defined in Ledger Report Setup (GL50.1) and inputs the parameters into GL290 (General Ledger Report) for report processing.

Fields (15)

Column = COBOL field name without the GLR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#GLR-COMPANY PK
COMPANY		Numeric 4The company number as defined in GL10.1 (Company).GL110, GL50.1, GL50.2, GL50.5
#GLR-REPORT-NAME PK
REPORT_NAME		Alpha 20The name that identifies the report.GL50.1, GL50.2, GL50.5
#GLR-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The report description.GL50.2, GL50.5
#GLR-CREATOR
CREATOR		Alpha 15The ID for the person that created the report.GL50.2, GL50.5
#GLR-LAST-RUN-DATE
LAST_RUN_DATE		Numeric 8 (yyyymmdd)Displays the last date the report was run.GL290, GL50.5
#GLR-PRIMARY-SORT
PRIMARY_SORT		Numeric 1The primary report sort order.
  • 1 Levels, Account, Subacct
  • 2 Acct Unit, Account, Subacct
  • 3 Account, Subacct, Levels
  • 4 Account, Subacct, Acct Unit
GL50.2
#GLR-TRANS-TYPE
TRANS_TYPE		Alpha 1Determines if amounts or units are processed in each transaction.
  • A Amounts
  • B Both Amounts and Units
  • U Units
GL290, GL50.2
#GLR-ACCT-ACTIVITY
ACCT_ACTIVITY		Alpha 1Determines the type of account activity to be included in the report.
  • A All Accounts
  • B Beg Balance and Trans Activity
  • T Transaction Activity Only
GL50.2
#GLR-COMPLETE-FLAG
COMPLETE_FLAG		Alpha 1Indicates if the record is complete.
  • Y Complete Record
GL50.1
#GLR-LAST-ITEM-SEQ
LAST_ITEM_SEQ		Numeric 4The last item sequence number.GL50.4
#GLR-TRN-DTL-SLECT
TRN_DTL_SLECT		Numeric 2 Occurs 32 Times ×32Indicates the order that transaction detail is selected.GL50.1
#GLR-SORT-ORDER
SORT_ORDER		Numeric 1 Occurs 4 Times ×4The report sort order.
  • 3 3rd Sort
  • 4 4th Sort
  • 5 5th Sort
  • 6 6th Sort
GL50.1, GL50.2
#GLR-PRT-TOTAL-FLG
PRT_TOTAL_FLG		Alpha 1 Occurs 3 Times ×3Indicates if totals are printed in the report.
  • X Print Total
GL50.1
#GLR-PG-BREAK-FLAG
PG_BREAK_FLAG		Alpha 1 Occurs 2 Times ×2Indicates if page breaks occur at the variable or account level.
  • X Page Break
GL50.1
#GLR-RUNNING-BAL
RUNNING_BAL		Alpha 1Indicates if running balances are included in the report.
  • Y Yes
  • N No
GL50.2

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GLRSET1
  1. COMPANY
  2. REPORT-NAME
PrimaryGL110, GL250, GL290, GL50.1, GL50.2, GL50.4, GL50.5

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLSYSTEMGLRPTSELGLRPTDEF

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CompanyGLSYSTEMRequired
GLR-COMPANY→GLS-COMPANY

One to many (1) — child tables

RelationTableRulesConditionField map
SelectionGLRPTSEL
GLR-COMPANY→GRS-COMPANY
GLR-REPORT-NAME→GRS-REPORT-NAME
—→GRS-OR-GROUP
—→GRS-ITEM-NUMBER
—→GRS-SEQUENCE-NBR

Programs

Updated by (6)

Referenced by (1)