GLRPTSEL – GL Report Selection

System
General Ledger (GL)
Prefix
GRS
Primary key
COMPANY, REPORT-NAME, OR-GROUP, ITEM-NUMBER, SEQUENCE-NBR
Fields
8
Updated by
4 programs
Referenced by
2 programs

GLRPTSEL is the GL Report Selection table in Lawson General Ledger (prefix GRS). It is indexed by COMPANY, REPORT-NAME, OR-GROUP, ITEM-NUMBER, SEQUENCE-NBR (GRSSET1). It is related 1:1 to GLRPTDEF. It is updated by GL110, GL50.2, GL50.4 and GL50.5 and referenced by GL250 and GL290. The table has 8 fields, 1 index and 1 documented relation.

About GLRPTSEL

This file contains field selection values for Ledger Report Setup (GL50.1). The values are used for report processing in GL290 (General Ledger Report).

Fields (8)

Column = COBOL field name without the GRS- 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
#GRS-COMPANY PK
COMPANY		Numeric 4The company number as defined in GL10.1 (Company).GL110, GL50.4, GL50.5
#GRS-REPORT-NAME PK
REPORT_NAME		Alpha 20The name that identifies the report.GL50.4, GL50.5
#GRS-OR-GROUP PK
OR_GROUP		Alpha 1A 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.'GL50.4
#GRS-ITEM-NUMBER PK
ITEM_NUMBER		Numeric 2Indicates items to be used for filtering report information.
  • 01 Variable Level
  • 02 Accounting Unit
  • 03 Account
  • 04 Subaccount
  • 05 System
  • 06 Journal Number
  • 07 Journal Type
  • 08 Transaction Amount
  • 09 Posting Date
  • 10 Transaction Date
  • 11 Intercpy Nbr
  • 12 Operator
  • 13 Reference
  • 14 Project
  • 15 Source Code
  • 16 Transaction Curr
  • 17 Base Amount
  • 18 Interzone Number
  • 19 Account Currency
  • 20 Account Rate
  • 21 Account Amount
  • 22 Original Program
  • 23 Status
  • 24 Negative Adj
  • 25 Document Nbr
  • 26 Close Sequence
  • 27 Updated Date
  • 28 Reconcile Code
  • 29 Effective Date
GL50.4
#GRS-SEQUENCE-NBR PK
SEQUENCE_NBR		Numeric 4The user-assigned sequence number to keep the records unique and to determine order.GL50.4
#GRS-SELECT-OMIT
SELECT_OMIT		Alpha 1Determines whether the item number and value range are included in the report.
  • E Exclude
  • I Include
GL50.4
#GRS-FR-VALUE
FR_VALUE		Alpha 30The beginning value to include or exclude in the report.GL50.4
#GRS-TH-VALUE
TH_VALUE		Alpha 30The ending value to include or exclude from the report.GL50.4

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
GRSSET1
  1. COMPANY
  2. REPORT-NAME
  3. OR-GROUP
  4. ITEM-NUMBER
  5. SEQUENCE-NBR
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)
GLRPTDEFGLRPTSEL

One to one (1) — lookups and parents

RelationTableRulesConditionField map
GlrptdefGLRPTDEFRequired
GRS-COMPANY→GLR-COMPANY
GRS-REPORT-NAME→GLR-REPORT-NAME

Programs

Updated by (4)

Referenced by (2)