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
Company              The company number as defined in GL10.1     GL50.5
                     (Company).


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

GRS-OR-GROUP         Alpha 1                                     GL50.4
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
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
Sequence Number      The user-assigned sequence number to
                     keep the records unique and to determine
                     order.

GRS-SELECT-OMIT      Alpha 1                                     GL50.4
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
From Value           The beginning value to include or
                     exclude in the report.


GRS-TH-VALUE         Alpha 30                                    GL50.4
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