General Ledger Report Setup
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 |
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). |
|
||||
GLR-REPORT-NAME Element: Report Name | Alpha 20 The name that identifies the report. |
|
||||
GLR-DESCRIPTION Element: Description | Alpha 30 (Lower Case) The report description. |
|
||||
GLR-CREATOR Element: Creator | Alpha 15 The ID for the person that created the report. |
|
||||
GLR-LAST-RUN-DATE Element: Last Run Date | Numeric 8 (yyyymmdd) Displays the last date the report was run. |
|
||||
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 |
|
||||
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 |
|
||||
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 |
|
||||
GLR-COMPLETE-FLAG Element: Complete Flag | Alpha 1 Indicates if the record is complete. Y = Complete Record |
|
||||
GLR-LAST-ITEM-SEQ Element: Last Item Sequence | Numeric 4 The last item sequence number. |
|
||||
GLR-TRN-DTL-SLECT Element: Transaction Detail | Numeric 2 Occurs 32 Times Indicates the order that transaction detail is selected. |
|
||||
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 |
|
||||
GLR-PRT-TOTAL-FLG Element: Print Total Flag | Alpha 1 Occurs 3 Times Indicates if totals are printed in the report. X = Print Total |
|
||||
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 |
|
||||
GLR-RUNNING-BAL Element: Running Balance | Alpha 1 Indicates if running balances are included in the report. Y = Yes N = No |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GLRSET1 |
COMPANY REPORT-NAME |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
---|---|---|---|---|---|
Company | GLSYSTEM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Selection | GLRPTSEL |
|
All trademarks and registered trademarks are the property of their
respective owners.