220 Historical RTX Clean-up

The utility cleans up the Historical Payment records from the rtx table up to a given date. The other parameters it requires are the portfolio number and whether or not to select only termainated/paid off leases for clean up.

Running this utility will delete records from the rtx table and therefore prevent future reversal transactions such as payoff reversals that depend on those records. This clean up will only be done on records that are no longer needed

Below is an example of using this utility:

This Utility option will clean up Historical Payment table [RTX]. 

Do you wish to continue [Y/N]? 

User will need to enter 'Y' or 'y' to continue. The program will display:

Client Password?

Users will need to enter their LeasePak client string password. The program will display:

Enter portfolio, or press Enter to exit:

Uers will need to enter a valid portfolio number. It will be used limit the clean up activity to the rtx records having lease numbers (lse_s) populated with the given portfolio only. The program will display:

Enter clean-up to date in YYMMDD format, or press Enter to exit: 

Users will need to enter a valid cutoff date in the past or future or blank. Any other response will display the following message and redisplay the current prompt:

Invalid YYMMDD date.  

In case, the user enters a valid date, the program will display the following:

Clean-up only terminated/paid off leases (Y/N), or press Enter to exit?

Enter 'N' or 'n' to bypass the terminated/paid off condition along with all other prompts coming next and to start cleaning up the rtx records based on the first two conditions that is the rtx records with leases belonging to the given portfolio and with an effective date less than or equal to the date entered in the previous prompt.

Enter 'Y' or 'y' to further limit the clean up activity to rtx records with leases that are already terminated or paid off . The program will display the following:

Enter the cutoff date in YYMMDD format or press Enter to exit. All leases tagged for RTX clean-up must be paid off or terminated prior to or equal to this date:

Users will need to enter any valid date in the past or future or a blank.

If the user enters a valid date to the last prompt, the program will clean up rtx records with leases belonging to the given portfolio and are paid off or terminated with an effective date less than or equal to the date entered in the final prompt.

After completing the clean up process, the program will exit the utility and return the user to the server command line.

Back to Utilities Menu

LeasePak  Documentation Suite

©  by NetSol Technologies Inc. All rights reserved.

The information contained in this document is the property of NetSol Technologies Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NetSol Technologies Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NetSol Technologies Inc. is prohibited.

Your document is loading...

This message should disappear within 5-15 seconds, depending on the size of the document and the speed of your connection to the Documentation Suite.

If you can still see this message after 20 seconds, try clicking the Refresh or Reload button on your Web browser.

If your document still does not load, refer to Document Load Troubleshooting for instructions on how to fix possible problems with either your Documentation Suite installation or Web browser setup.

If you do not have read access to the parent docsuite directory, you will not be able to load the Document Load Troubleshooting document. In this case, contact your network administrator for assistance.