Skip to main content
Skip table of contents

GLRE - FLTRSH

Transaction File Listing Detail Line Reformatting
When the Transaction File listing report GLREFLTR is run in Short Format, the detail line can be reformatted for a user-defined list of subsystems. A more complete setup is described in common code GLRP-SR19JB.
Once this common code is turned "ON" a header will need to be made in NUUPHD. The new header must have the name "GLHDFLSH."
Code Category: GLRE
Code Value: FLTRSH
Short Description: Enter "OFF" to disable this common code. Enter "ON" to enable.
Medium Description: Enter "ON" to enable Concatenation Mode. Enter "OFF" to insert a space before and after each reformatted field.
Long Description: Used to describe the common code.
Associated Numeric Values
1-5: Reserved for future use.
Associated Codes
1-5: Enter subsystem IDs to which reformatting applies (only 6 subsystems will fit on one line). Only reformatting on corresponding "Associated Descriptions" line will be applied to these subsystems (i.e.: reformatting in "Associated Descriptions" line 1 only applies to subsystems listed in "Codes" line 1).
Associated Descriptions
1-5: Enter reformatting here in the following format (exclude "<"and ">"): <Variable Name><Starting Column><Length> If more than one field needs to be reformatted, concatenate the pattern until "Associated Descriptions" line is full. Only four fields will fit on one "Associated Descriptions" line, and there will always be at least two blank spaces at the end of each "Associated Descriptions" line. Reformatting only applies to subsystems listed on corresponding "Codes" line.

Valid <Variable Name>

Maximum Length**

REFPrimary Reference

16

PIDPayee ID

12

PERFiscal Period

2

TYPTransaction Type

2

DESAssociated Description

30

MISMiscellaneous Code

4

RF2Secondary Reference

16

DT2Secondary Reference Date

8

BATBatch ID1

6

SBSSubsystem ID

2

PEDPerson Entity DB Code

2

CKICheck Stock ID

2

CKNCheck Number

6

CNCCKI and CKN concatenated

8

GWOWork Order (for future use)

12

CURForeign Currency Code

4

DATPrimary Transaction Date

8

PEPPreparer's ID

4

CNOContract Number

16

OFYOriginal Fiscal Year

4


Note: Larger Maximum Lengths can be used, but nothing will be printed beyond the Maximum Length.
ExampleFor the following setup of common code GLRE-FLTRSH, all detail line entries with a subsystem ID in the list on line one of the "Codes" column (EN, OH, AR, etc.) will have the Primary Reference (REF) printed in column 1 for a length of 10 characters (only the first 10 characters will be printed), the Subsystem ID (SBS) printed in column 11 for a length of 2, the Check Stock ID (CKI) printed in column 13 for a length of 2, and only the first 3 characters of the Check Number (CKN) will be printed starting in column 15.All detail line entries with a subsystem ID listed on line two of the "Codes" column (JN) will have the Preparer's ID (PEP) printed in column 3 for a length of 16. Since the Preparer's ID has a maximum length of 4, and since the common code setup specifies a length of 16, the last 12 characters will be blank.All detail line entries with a subsystem ID listed on line three of the "Codes" column (DF) will have the Primary Transaction Date printed in column 6 for a length of 26. As with the Preparer's ID, since the specified print length (26) is longer than the maximum length for the Primary Transaction Date field (8), the last 18 characters will be blank.

Codes

Associated Descriptions

EVOLDTFSLAEH

REF0110SBS1102CKI1302CKN1503

JNPEP0316

 

DFDAT0626

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.