GLRPTDEF

GL Report Definition

This file contains report parameters defined in Ledger Report Setup (GL50.1) and inputs the parameters into GL290 (General Ledger Report) for report processing.

REFERENCED BY
GL250


UPDATED BY
GL110 GL290 GL50.1 GL50.2 GL50.4 GL50.5

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLR-COMPANY
Element: Company
Numeric 4
The company number as defined in GL10.1 (Company).
GL110 GL50.1
GL50.2 GL50.5
GLR-REPORT-NAME
Element: Report Name
Alpha 20
The name that identifies the report.
GL50.1 GL50.2
GL50.5
GLR-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The report description.
GL50.2 GL50.5
GLR-CREATOR
Element: Creator
Alpha 15
The ID for the person that created the report.
GL50.2 GL50.5
GLR-LAST-RUN-DATE
Element: Last Run Date
Numeric 8 (yyyymmdd)
Displays the last date the report was run.
GL290 GL50.5
GLR-PRIMARY-SORT
Element: Primary Sort
Numeric 1
The primary report sort order.
1 = Levels, Account, Subacct
2 = Acct Unit, Account, Subacct
3 = Account, Subacct, Levels
4 = Account, Subacct, Acct Unit
GL50.2
GLR-TRANS-TYPE
Element: Transaction Type
Alpha 1
Determines if amounts or units are processed in each transaction.
A = Amounts
B = Both Amounts and Units
U = Units
GL290 GL50.2
GLR-ACCT-ACTIVITY
Element: Account Activity
Alpha 1
Determines the type of account activity to be included in the report.
A = All Accounts
B = Beg Balance and Trans Activity
T = Transaction Activity Only
GL50.2
GLR-COMPLETE-FLAG
Element: Complete Flag
Alpha 1
Indicates if the record is complete.
Y = Complete Record
GL50.1
GLR-LAST-ITEM-SEQ
Element: Last Item Sequence
Numeric 4
The last item sequence number.
GL50.4
GLR-TRN-DTL-SLECT
Element: Transaction Detail
Numeric 2 Occurs 32 Times
Indicates the order that transaction detail is selected.
GL50.1
GLR-SORT-ORDER
Element: Sort Order
Numeric 1 Occurs 4 Times
The report sort order.
3 = 3rd Sort
4 = 4th Sort
5 = 5th Sort
6 = 6th Sort
GL50.1 GL50.2
GLR-PRT-TOTAL-FLG
Element: Print Total Flag
Alpha 1 Occurs 3 Times
Indicates if totals are printed in the report.
X = Print Total
GL50.1
GLR-PG-BREAK-FLAG
Element: Page Break Flag
Alpha 1 Occurs 2 Times
Indicates if page breaks occur at the variable or account level.
X = Page Break
GL50.1
GLR-RUNNING-BAL
Element: Running Balance
Alpha 1
Indicates if running balances are included in the report.
Y = Yes
N = No
GL50.2


GLRPTDEF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLRSET1 COMPANY
REPORT-NAME
GL110 GL250
GL290 GL50.1
GL50.2 GL50.4
GL50.5


GLRPTDEF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
GLR-COMPANY->GLS-COMPANY


GLRPTDEF FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Selection GLRPTSEL
GLR-COMPANY->GRS-COMPANY
GLR-REPORT-NAME->GRS-REPORT-NAME
  GRS-OR-GROUP
  GRS-ITEM-NUMBER
  GRS-SEQUENCE-NBR


File created: Thu Jun 09 11:13:21 2016

Home
Contact Us



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