|
|
GLRPTDEF FILE
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 Numeric 4 GL110 GL50.1
Company The company number as defined in GL10.1 GL50.2 GL50.5
(Company).
GLR-REPORT-NAME Alpha 20 GL50.1 GL50.2
Report Name The name that identifies the report. GL50.5
GLR-DESCRIPTION Alpha 30 (Lower Case) GL50.2 GL50.5
Description The report description.
GLR-CREATOR Alpha 15 GL50.2 GL50.5
Creator The ID for the person that created the
report.
GLR-LAST-RUN-DATE Numeric 8 (yyyymmdd) GL290 GL50.5
Last Run Date Displays the last date the report was
run.
GLR-PRIMARY-SORT Numeric 1 GL50.2
Primary Sort 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 Alpha 1 GL290 GL50.2
Transaction Type Determines if amounts or units are
processed in each transaction.
A = Amounts
B = Both Amounts and Units
U = Units
GLR-ACCT-ACTIVITY Alpha 1 GL50.2
Account Activity Determines the type of account activity
to be included in the report.
A = All Accounts
B = Beg Balance or Trans Activity
T = Transaction Activity Only
GLR-COMPLETE-FLAG Alpha 1 GL50.1
Complete Flag Indicates if the record is complete.
Y = Complete Record
GLR-LAST-ITEM-SEQ Numeric 4 GL50.4
Last Item Sequence The last item sequence number.
GLR-TRN-DTL-SLECT Numeric 2 Occurs 31 Times GL50.1
Transaction Detail Indicates the order that transaction
detail is selected.
GLR-SORT-ORDER Numeric 1 Occurs 4 Times GL50.1 GL50.2
Sort Order The report sort order.
3 = 3rd Sort
4 = 4th Sort
5 = 5th Sort
6 = 6th Sort
GLR-PRT-TOTAL-FLG Alpha 1 Occurs 3 Times GL50.1
Print Total Flag Indicates if totals are printed in the
report.
X = Print Total
GLR-PG-BREAK-FLAG Alpha 1 Occurs 2 Times GL50.1
Page Break Flag Indicates if page breaks occur at the
variable or account level.
X = Page Break
GLR-RUNNING-BAL Alpha 1 GL50.2
Running Balance Indicates if running balances are
included in the report.
Y = Yes
N = No
GLRPTDEF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLRSET1 COMPANY GL110 GL250
REPORT-NAME GL290 GL50.1
GL50.2 GL50.4
GL50.5
GLRPTDEF FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
GLR-COMPANY -> GLS-COMPANY
GLRPTDEF FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|