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

216 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. Positive number with no decimal, rightmost two digits specify cents.

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 222 utility will prompt you for your client string password, the ALI vendor number, and the portfolio number. Once a data file is successfully input into the RBS table, LeasePak will delete the file so it cannot be accidentally 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.

224 Cost Per Use Import File

Cost Per Use: For users with the Cost Per Use module, use this utility to load meter charge assessment and reversal information into the RBM table for processing by the End of Period (Sequential Updates, Daily) module Batch Meter [U0448]. To use the utility, create a batch input file named p*_btchcpu.dat (where * is the portfolio number) and place it in the data directory of your LeasePak environment. Each line of the batch input file must contain the following three elements separated by commas:

Transaction type, either A for assessment or R for reversal
Asset number or asset serial number, preceded by U if the asset number or S is the serial number (with no space between the U or S and the following number)
Meter ID, preceded by M (with no space between the M and the following ID).

For assessment transactions (type 'A'), you may also include the following:

Meter reading, preceded by V (for Value), with no space between the V and the following value (also, do not use commas or other punctuation in the meter value)
Service credits, preceded by C, with no space between the C and the number of credits (also, do not use commas or other punctuation in the credit number)
Meter period end date, format YYMMDD, preceded by E (for End date), with no space between the E and the number of credits

These additional elements are also separated by commas. You can specify them in any order as long as you place them after the required elements.

Example 1

A,U12245,M0001,V12500,E040115

This line assesses Asset 12245, Meter 0001 with a meter reading of 12,500 and a meter period end date of 01/15/04.

Example 2

A,SSER#124912-23133,M0002,V550000,C2300

This line assesses an asset with serial number SER#124912-23133, Meter 0002 with a meter reading of 550,000 and 2,300 service credits.

Example 3

R,SSER#124912-23133,M0002

This line reverses the most recent meter charge made to the asset with serial number SER#124912-23133.

Once the batch input file is successfully loaded, the Batch Meter module (if set to run) will process it during the next End of Period.

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