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 |
|