GLRPTSEL

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
Element: Company
Numeric 4
The company number as defined in GL10.1 (Company).
GL110 GL50.4
GL50.5
GRS-REPORT-NAME
Element: Report Name
Alpha 20
The name that identifies the report.
GL50.4 GL50.5
GRS-OR-GROUP
Element: or Group
Alpha 1
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.'
GL50.4
GRS-ITEM-NUMBER
Element: Item Number
Numeric 2
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
GL50.4
GRS-SEQUENCE-NBR
Element: Sequence Number
Numeric 4
The user-assigned sequence number to keep the records unique and to determine order.
GL50.4
GRS-SELECT-OMIT
Element: Select Omit
Alpha 1
Determines whether the item number and value range are included in the report.
E = Exclude
I = Include
GL50.4
GRS-FR-VALUE
Element: From Value
Alpha 30
The beginning value to include or exclude in the report.
GL50.4
GRS-TH-VALUE
Element: To Value
Alpha 30
The ending value to include or exclude from the report.
GL50.4


GLRPTSEL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GRSSET1 COMPANY
REPORT-NAME
OR-GROUP
ITEM-NUMBER
SEQUENCE-NBR
GL110 GL250
GL290 GL50.1
GL50.2 GL50.4
GL50.5


GLRPTSEL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glrptdef GLRPTDEF Required
GRS-COMPANY->GLR-COMPANY
GRS-REPORT-NAME->GLR-REPORT-NAME


File created: Thu Jun 09 02:14:09 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.