TX167 – REFUND LISTING REPORT

 

NOTE:  The specific fields with permissible entries to be filled in or left blank are listed below. Ignore fields that are not in the list next to the screens.

Figure 1. SY41 (TOP)

 1.    Job: Report name should always appear here. For example, TX167.

 2.    Server Name: Keep the server name that first appears.

 3.    Printer_Name: Select a valid printer or keep the displayed printer if one is present.

 4.    Jurisdiction: Enter your jurisdiction.

 5.    Tax Year: Enter the current Tax Year. (This information is used only to retrieve county name.)

 6.    Spool File Name: Enter TX167.LIS to create the file in text format.

 7.    Beginning Date: Enter the beginning effective or business date as specified in PARAM5.

 8.    Ending Date: Enter the ending effective or business date as specified in PARAM5.

 9.    ID1: Enter the minimum Parcel ID to include in the report or zero to include all parcels. Enter IDLIST to run the report on a specific list of parcels.

 10. ID2: If ID1 = minimum Parcel ID, enter the maximum Parcel ID associated with the parcels to include in the report. If ID1 = zero, enter ZZ for all parcels. If ID1 = IDLIST, enter the SETNAME of the IDLIST.

 11. ALT1: Enter Y to include only system-generated refunds, such as tax adjustments and inserted payments

          Enter N or leave blank and all refunds will be included.

 13. FCU: Formatting code. Enter HPLL132 to print in portrait mode on letter size paper. Enter HPLL132D to print in duplex (both sides) portrait mode on letter size paper. Enter HPLL132 to print landscape on letter size paper or HPLL132D to print duplex, landscape on letter size paper.

 16. ORDER BY : Used to determine the SORT order. You may use any of the following codes (see below) in any combination, separated by commas.

 17. PARAM1 ROLL TYPE: Enter any valid roll type, or leave null to include all rolltypes.

 18. PARAM2 REFUND STATUS IN:

          Enter valid refund status from TX14. Enter them in single quotes separated by commas. If blank, all refund statuses are included. Enter ‘NULL’ for null refund status.

 19. PARAM3 SUMMARY TYPE:

          Enter TYPE to summarize the report by the refund type.

          Enter STATUS to summarize the report by the status of the refunds.

          Enter BOTH to summarize the report by both type and status.

 20. PARAM4 EXCL 0 AMT REF? (Y/N):

          Enter Y to exclude the refund details if the total of the refund amount is zero for the range of business or effective dates.

          Enter N or leave blank to print all refund details for the range of business or effective dates.

 21. PARAM5 DATE CHECK (BUS/EFF):

          Enter BUS to include only records with a business date between the date range requested.

          Enter EFF to include only records with an effective date between the date range requested.

Figure 2. SY 41 (BOTTOM)

Press [Submit Job]. The system will notify you when the report is finished.

 

CODES:

CODE                 SORT FIELD

4                       TAXREF.PARID

5                       TAXREF.REFNO

6                       TAXREF.RNAME

7                       TAXREF.REFAMT

8                       TAXREF.USER1

9                       TAXREF.USER2

10                    TAXREF.USER3

11                    TAXREF.USER4

12                    TAXREF.USER5

13                    TAXREF.GLACCT

14                    TAXREFDET.REFSTATUS

15                    TAXREFDET.REFTYPE

16                    TAXREFDET.CHKAMT

17                    TAXREFDET.BUSDATE

5 user-defined fields are available on TX14. If any of these fields are to be printed on the TX167, an entry is required on SY83 for each field to be printed.

 

REPORT SAMPLE




 

Updated 19 May 2006