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

GLRPTDEF FILE RELATIONS

ONE TO ONE RELATIONS

GLRPTDEF FILE RELATIONS

ONE TO MANY RELATIONS

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