Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLRPTSEL


                             GLRPTSEL FILE

                          GL Report Selection

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


REFERENCED BY

GL250     GL290

UPDATED BY

GL110     GL50.2    GL50.4    GL50.5

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GRS-COMPANY            Numeric 4                                 GL110   GL50.4
Element: Company       The company number as defined in GL10.1   GL50.5
                       (Company).


GRS-REPORT-NAME        Alpha 20                                  GL50.4  GL50.5
Element: Report Name   The name that identifies the report.

GRS-OR-GROUP           Alpha 1                                   GL50.4
Element: or Group      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.'


GRS-ITEM-NUMBER        Numeric 2                                 GL50.4
Element: Item Number   Indicates 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

GRS-SEQUENCE-NBR       Numeric 4                                 GL50.4
Element: Sequence Number

GRS-SELECT-OMIT        Alpha 1                                   GL50.4
Element: Select Omit   Determines whether the item number and
                       value range are included in the report.

                       E = Exclude
                       I = Include

GRS-FR-VALUE           Alpha 30                                  GL50.4
Element: From Value    The beginning value to include or
                       exclude in the report.


GRS-TH-VALUE           Alpha 30                                  GL50.4
Element: To Value      The ending value to include or exclude
                       from the report.


                         GLRPTSEL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GRSSET1   COMPANY                                                GL110   GL250
          REPORT-NAME                                            GL290   GL50.1
          OR-GROUP                                               GL50.2  GL50.4
          ITEM-NUMBER                                            GL50.5
          SEQUENCE-NBR

                         GLRPTSEL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glrptdef       GLRPTDEF     Required

                            GRS-COMPANY        -> GLR-COMPANY
                            GRS-REPORT-NAME    -> GLR-REPORT-NAME