LeasePak Utilities

The LeasePak utilities are options of the program $uexe/lpautil.exe. You must have direct access to the LeasePak server, either as the LeasePak administrative user (lpadmin) or as the MSI release administrator (msiadmin), in order to run this program. Many of the utilities can severely corrupt LeasePak and its databases; consult your MSI representative before running any of them.

Terminal emulation: you must use one of the supported terminal types. Refer to the Terminal Emulation section of the document System Requirements for more information.

  0    Exit
108    Add user security record  
109    Dump contents of linked-in maps
111    Copy the batch payment and PAP files into LeasePak
112    Unix and SQL Server password translation
200    Lock/unlock updates
207    DAS update
212    Change Key Utility (change port/comp/regn/offc)
213    Initialize multi-process lease ranges
214    Print EOP file dependencies
215    Set up EOP module
217    Auditing Extract update
218    Batch Applications
219    Transfer data from scratch files into RBS table for BA
220    Historical RTX Clean-up
221    DAVOX Download
222    ALI Import

Your selection?

Type the number of your selection and press Enter.

Options

0 Exit

Exits the $uexe/lpautil.exe program.

108 Add user security record

Use this utility to set up the security record for the LeasePak administrative user only. You must acquire a special password from MSI in order to use this utility; refer to the LeasePak Administrative User section of the document LeasePak Server Configuration and Maintenance for more information or consult your MSI representative.

109 Dump contents of linked-in maps

This is an MSI product support tool used to examine the information contained in storage areas linked directly into the executable image of LeasePak. Use this utility only on the advice of your MSI representative; improper use will corrupt LeasePak and its databases.

111 Copy the batch payment and PAP files into LeasePak

Copies the Batch Payment and Pre-Authorized Payment (PAP) files into the LeasePak database. Use this utility only on the advice of your MSI representative; improper use will corrupt LeasePak and its databases.

112 Unix and SQL Server password translation

Translates a LeasePak client user's Client String into the corresponding encrypted server (OS) and DBMS passwords. For more information, refer to the Passwords section of the document LeasePak Users.

200 Lock/unlock updates

Locks or unlocks updates on a specific portfolio. Consult your MSI representative before using this update; unlocking a portfolio while End of Period is running will corrupt LeasePak and its databases.

207 DAS updates

Initializes the internal LeasePak calendar. Use this only as part of the initial set up of a LeasePak database; improper use will corrupt LeasePak and its databases.

212 Change Key Utility (change port/comp/regn/offc)

Normally you change the key (portfolio/company/region/office) for a single lease through the Change Lease Key [U0114] update. Use utility 212 with an input file to change the keys for a group of leases. Contact your MSI representative for information and assistance; improper use will corrupt LeasePak and its databases.

213 Initialize multi-process lease ranges

If you have an End of Preriod multi-process count greater than 1, you can use this utility to determine the range of lease numbers to run with each process. Contact your MSI representative for information and assistance with multi-process End of Period.

214 Print EOP file dependencies

As a tool for MSI product support and development, this utility creates a report listing file I/O conflicts between End of Period modules.

215 Set up EOP module

Updates the End of Period (rep) table for a specific portfolio to prepare it for running individually in debug mode. Improper use of this utility will corrupt LeasePak and its databases.

217 Auditing Extract update

Works in conjunction with the Non-Monetary Archive Report [R0413]. This function will allow all non-monetary changes to be extracted by date first. LeasePak will display the information based on lease number and all records on or before the extract date entered in the lpautil.exe option. Certain non-monetary fields will be displayed in the report after the user has performed all the necessary changes to the lease.

218 Batch Applications

Begins processing applications through the Batch Application update. For more information, refer to the document New Lease [U0101]: Batch Applications.

219 Transfer data from scratch files into RBS table for BA

Transfers data from a scratch file into the RBS table for the specified portfolio for Batch Assessment processing. For more information, refer to the Batch Assessment [U0418] section of the document End of Period [U04]: Daily Updates.

220 Historical RTX Clean-up

Cleans up the Historical Payment table (rtx). This utility deletes data from the table; contact your MSI representative for more information.

221 DAVOX Download

Creates a DAVOX download file; contact your MSI representative for more information.

222 ALI Import

Transfers data from an ALI scratch file for the specified portfolio into the RBS table for Batch Assessment processing. This utility parses a file of ALI charges and, for each lease, inserts a record into the Batch Assessment/Waiver table for the next End of Period (End of Day) to process. ALI will provide the input file or the user will create it in the following format:

	<lease>XXXXXXXXXX
	<due date>XXXXXX
	<amount>XXXXXXXX
	<>

You must prefix all field values with their label in angle brackets (<>).

<lease> Lease number which will receive the assessment. If you wish to charge the assessment to an existing active lease, you must include this item.

<due date> Invoice due date on which the assessment is due. This is optional, and required only if the due date for the invoice is to be different from the next payment due date for the lease. The format for the invoice due date should be 6 characters, 2 each for year, month, and day (that is, YYMMDD). If the due date is not needed, the line item may be omitted or the prefix may be listed with no value.

<amount> Amount to assess. A positive value means that an assessment will be processed; a negative value means that a waiver will be processed.

The final <> terminates the lease data set and is required. Name the input file p*_ali.dat, where * is the portfolio number, and place the file in $top/env/environment/data, where environment is the LeasePak environment you are working in.

The utility will prompt you for your client string password, the ALI vendor number, and the portfolio number. Once a data file is sucessfully input into the RBS table, LeasePak will delete the file so it cannot be accidently imported again. If the process fails for any reason, you must clear the RBS table manually and re-run the utility. If LeasePak encounters any exceptions while running the utility, it creates an exception file, p*_ali_import_except.rpt (where * is the portfolio number), located in the same environment directory.

For more information about this utility, contact your MSI representative.

The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, 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 McCue Systems, Inc. is prohibited.

LeasePak Utilities

Menu

Options