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 NumbeThe user-assigned sequence number to
keep the records unique and to determine
order.
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
|
