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 |
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). |
|
||||
GRS-REPORT-NAME Element: Report Name | Alpha 20 The name that identifies the report. |
|
||||
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.' |
|
||||
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 |
|
||||
GRS-SEQUENCE-NBR Element: Sequence Number | Numeric 4 The user-assigned sequence number to keep the records unique and to determine order. |
|
||||
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 |
|
||||
GRS-FR-VALUE Element: From Value | Alpha 30 The beginning value to include or exclude in the report. |
|
||||
GRS-TH-VALUE Element: To Value | Alpha 30 The ending value to include or exclude from the report. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GRSSET1 |
COMPANY REPORT-NAME OR-GROUP ITEM-NUMBER SEQUENCE-NBR |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Glrptdef | GLRPTDEF |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.