NotesDatabaseEnhancementsDiscrepanciesDocumentation

LeasePak 6.0a Release Notes
Build Sequence 6.00.2250

Cumulative release notes for LeasePak version 6.0a , build 2250.

Notes
Sorted by Priority, then by Most Recent/Latest Build

Linux: Permanent Note

My.sql /usr/bin/isql

Linux users: RedHat installs My.sql by default, including the executable /usr/bin/isql. Shell scripts naturally find /usr/bin before finding the correct Sybase path. This will cause errors in any LeasePak shell script using isql. Allowing a default installation of My.sql on a LeasePak server is inherently incompatible with the operation of Sybase. NetSol strongly recommmends not installing My.sql on the LeasePak server. Where My.sql is installed alongside Sybase, users must remove, rename, or relocate /usr/bin/isql so that LeasePak shell scripts will not find it when searching for the Sybase isql.

Setup Instructions for All Users: Logging on as the Root User
Build 6.00.2245

The system administrator must log on cleanly as the root user before running setup, so that no LeasePak variables are set prior to installation. The system administrator can do this either by logging on initially as root or by using

su -

where the hyphen (-) is mandatory.

Linux: Special LeasePak 6.0a Setup Instructions for Linux Users
Build 6.00.2245

For Linux users only: you must use the following procedure to install the new build of LeasePak 6.0a.

1. Stop all LeasePak Queue Manager queues: /etc/init.d/qmgr_v60a stop
2. Copy all Queue Manager configuration files and the LeasePak license to a separate location. The files to copy are:

       $QMDIR/com/start_queues.com
       $QMDIR/library/Config
       $QMDIR/library/DEVINIT
       $live/exe/*/lplicense.dat
   	

3. Use the same configuration information from your existing LeasePak 6.0a installation. You can find your existing setup parameters in $CFGDIR/relscfg.msirc
4. Use the copy of your LeasePak license file for the setup procedure (follow the instructions in the System Administration Guide).
5. Run the full setup program

   cd-rom_device/setup release_directory
   

   where cd-rom_device is the full path of your CD-ROM device and release_directory is the full path of your LeasePak release directory.
6. Use the copies of the Queue Manager configuration files to replace the files from the setup program, thereby restoring your Queue Manager setup parameters. Make sure that the owner, group, and permissions of the restored files match the files you are replacing.
7. Restart all Queue Manager queues: /etc/init.d/qmgr_v60a start

Payoff/Termination Reversals on Extended Operating Leases
Build 6.00.2243

While fixes made in response to Discrepancy 521333 address the functionality of extended operating leases through the payoff/termination process, they do not address the process of reversing payoffs/terminations for these types of leases. NetSol has filed Discrepancy 521705 for payoff/termination reversals of extended operating leases.

New OS and DBMS Platforms-Special Notice
Build 6.00.2143

For most clients, upgrading to LeasePak 6.0a requires upgrading the OS and DBMS software (all platforms). Refer to the System Administration Guide for more information.

rzq Business Calendar Table Changes
Build 6.00.2143

Customer bolt-ons that reference the rzq table will require maintenance this release because the table's key structure has changed to include the calendar code. Also, hldy1_s is now day_type1_s and hldy2_s is now day_type2_s.

Changes to the C-ISAM structure of the DZZ Audit Extract Table
Build 6.00.2143

Customers should run the audit extract in LeasePak version 5.3a and delete the dzz.dat.dat and dzz.dat.idx files found in the environment's data directory before upgrading to 6.0a from a prior version. Contact your NetSol representative for more information.

End User Code Objects
Build 6.00.2143

The System Administration Guide now includes a document on customizable and user-defined stored procedures as part of the new system of end-user code objects.

Sybase: Vertex Changes
Build 6.00.2143

NetSol has changed the code used in the Vertex Interface [U0437] for Sybase users. Except for some minor changes in the report format, the user should experience no differences in the operation of the interface. ~@br~@br~ NetSol made this change to provide better and more consistent functionality across the multiple platforms. Whereas before the Sybase version of the interface was using a stored procedure, while the Oracle version was using LeasePak program logic, now all versions use the program logic. ~@br~@br~ As part of these changes, NetSol has dropped the ~@co%vertex~ table and the following stored procedures: ~@co%mp_vertex_rlo_rnm~, ~@co%mp_vertex_rlo_rnm_upd~, ~@co%mp_vertex_rlo_archv~.

CD Ship Contents
Build 6.00.2143

Following are the contents of the different platform CDs shipped for the release. Contact your NetSol representative for more information.

HP Platform

1. LeasePak Sanitizer
2. Mdac
3. Ntsvcpak6a
4. Sybase OC 12.5.2 - W:\Sybase\PC Client 12.5.2\pcclient
5. LpClient
6. HPUX11i LpServer for Sybase
7. mPower web server (API) .war file
8. Documentation

SUN Platform

1. LeasePak Sanitizer
2. Mdac
3. Ntsvcpak6a
4. Sybase OC 12.5.2 - W:\Sybase\PC Client 12.5.2\pcclient
5. LpClient
6. Solaris9 LpServer for Sybase and Oracle
7. mPower web server (API) .war file
8. Documentation

Wintel Platform

1. LeasePak Sanitizer
2. Mdac
3. Ntsvcpak6a
4. Sybase OC 12.5.2 -- W:\Sybase\PC Client 12.5.2\pcclient
5. LpClient
6. Redhat 4 LpServer for Sybase and Oracle
7. mPower web server (API) .war file
8. Documentation

Oracle Client

1. Oracle OC 9i

LeasePak Database Changes

Grouped Alphabetically by Table/View Name

mwr: Recovery Work Schedule

Change Column in Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
options_s	reserved1_s	Reserved for future use [1]

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
opr_s		Operator initials	char/3	NULL

rapa: Application 2

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
dlr_rec_pmts_d		Dealer-received payments	double/8.2	0.0
prn_write_down_c		Principal write-down (Y/N)	switch	N
float_bus_or_cal_c		Set float rate on business or calendar + day (P/F/C): P - set rate on previous business day; F - set rate on following business day; C - set rate on calendar day	switch	C
float_frq_s		Frequency of float rate setting (FLOAT.FREQ + code): NONE - rate setting functionality is disabled; DAY - daily; MON - monthly; QTR - quarterly; SEMI - semiannually; ANNL - annually	char/4	'NONE'
float_day_l		Day of month on which float rate is set (1-31). A value of zero indicates that the rate + setting functionality has been disabled	integer	0
float_mon_l		Month in which float rate is set (0-12): 0 - frequency is NONE, MON or DAY; 1 - 3 - frequency is QTR; 1 - 6 - frequency is SEMI; 1 - 12 - frequency is ANNL	integer	0
p_float_base_d		Float base rate percentage	percent/2.5	100
calendar_s		Calendar code to use for determining business days (BUS.CALEND code)	char/4	BASE

raq: Application Asset

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
utilize_veh_tax_rates_c		Utilize vehicle tax rates (Y/N)	switch	N

rau: Application User Profile

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
email_s		Email address	char/50	NULL
fax_s		Fax dial number	char/10	NULL
phn_s		Phone number	char/10	NULL
def_nxt_own_to_opr_s		Default next owner to current operator (Y/N)	char/37	N*37

rbm: Batch Meter

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
cpu_level_c		Cost per use level (L/A): L - Lease level; A - Asset level	switch	L

rcc: Custom Code

Insert New Unique Record in Table

rcc_flg_c	cd_typ_s	cd_shrt_s	cd_long_s	security_l
2	TRN	944	CLRD SUSP REVERSAL	0
1	PAP		PAP OPTIONS	4
2	PAP	Y	YES	0
2	PAP	N	NO	0
2	PAP	1	YES OLDEST INVOICE	0
2	PAP	2	YES ALL START W/ OLD	0
2	PAP	3	YES NEWEST INVOICE	0
1	PAYOFF.ACT		PAYOFF STATUS	4
1	FLOAT.FREQ		FLOAT RATE FREQUENCY	0
2	FLOAT.FREQ	'NONE'	'NONE'	0
2	FLOAT.FREQ	DAY	DAILY	0
2	FLOAT.FREQ	MON	MONTHLY	0
2	FLOAT.FREQ	QTR	QUARTERLY	0
2	FLOAT.FREQ	SEMI	SEMI-ANNUALLY	0
2	FLOAT.FREQ	ANNL	ANNUALLY	0
1	CAL.FREQ		CALENDAR FREQUENCY	0
2	CAL.FREQ	'NONE'	'NONE'	0
2	CAL.FREQ	DAY	DAILY	0
2	CAL.FREQ	MON	MONTHLY	0
2	CAL.FREQ	QTR	QUARTERLY	0
2	CAL.FREQ	SEMI	SEMI-ANNUALLY	0
2	CAL.FREQ	ANNL	ANNUALLY	0
1	BUS.CALEND		BUSINESS CALENDAR	7
2	BUS.CALEND	BASE	BASE CALENDAR	0
1	EOP.EVENT		EVENTS IN EOP	0
2	EOP.EVENT	ELFL	EOP LAUNCH FAILED	0
2	EOP.EVENT	ELCH	EOP LAUNCH SUCCESS	0
2	EOP.EVENT	EPEN	EOP PENDING	0
2	EOP.EVENT	EHBT	MONITOR HEARTBEAT	0
2	EOP.EVENT	ESTL	EOP STALLED	0
2	EOP.EVENT	ESTR	STALLED EOP STARTED	0
2	EOP.EVENT	ERUN	EOP IS RUNNING	0
2	EOP.EVENT	EHLT	EOP HALTED	0
2	EOP.EVENT	EFAL	EOP FAILED	0
2	EOP.EVENT	EFIN	EOP COMPLETE	0
2	EOP.EVENT	ESKP	EOP COMPLETE W SKIPS	0
2	EOP.EVENT	EPOR	PORT COMPLETE	0
2	EOP.EVENT	EPPR	POST PORT RUNNING	0
2	EOP.EVENT	EPPF	POST PORT COMPLETE	0
2	EOP.EVENT	EERR	SOFTWARE ERROR	0
2	PMT.ORIG	LPEP	LP ENHANCED PAYMENTS	0
1	SUS.UD		UD SUSPENSE TYPE	7
1	LOC.FREEZE		FROZEN RATES	0
2	LOC.FREEZE	INCL	INCLUDE SUB-JURISDS	0
2	LOC.FREEZE	'NONE'	'NONE'	0
2	LOC.FREEZE	ST	STATE	0
2	LOC.FREEZE	CO	COUNTY	0
2	LOC.FREEZE	CI	CITY	0
2	LOC.FREEZE	STCO	STATE & COUNTY	0
2	LOC.FREEZE	STCI	STATE & CITY	0
2	LOC.FREEZE	COCI	COUNTY & CITY	0
2	LOC.FREEZE	SCC	STATE, COUNTY & CITY	0
2	Copy ACT rcc codes into PAYOFF.ACT code type		error: missing closing quote	error: missing closing quote

Update Existing Record in Table

Condition	New Value (if any)	security_l
where rcc_flg_c = '2' and cd_type_s = ' A.TYP'	set cd_long_s = 'FED HGHWY USE TAX FE'	0

rcg: Custom General

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
max_hist_pwd_l		Maximum historical passwords to store	Integer	4
min_spec_char_in_pwd_l		Minimum special characters in password	Integer	0
recalc_unit_res_c		Recalculate asset residual (Y/N)	switch	Y
enable_veh_tax_rates_c		Enable vehicle tax rates (Y/N)	switch	N
min_pwd_length_l		Minimum password length	Integer	6
min_num_char_in_pwd_l		Minimum numeric characters in password	Integer	0
min_upper_char_in_pwd_l		Minimum uppercase characters in password	Integer	0
paynet_subscriber_id_s		Paynet subscriber id	char/8	NULL
gl_his_c		Enable GL name history (Y/N)	char/1	N

Update Existing Record in Table

Field	New Value (if any)	security_l
field(253)
field(274)
field(275)
field(276)
field(281)
field(282)

rcp: Collection User Profile

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
xsl_filename_s		XSL file name	char/25	NULL
email_s		Email address	char/50	NULL
fax_s		Fax dial number	char/10	NULL
phn_s		Phone number	char/10	NULL

rcs: Historical Asset

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
olb_pro_d		Off lease billing proceeds	double/8.2	0.0

reo: End of Period Order

NEW TABLE
Create New Table

New Table	New Name (if any)	New Description (if any)
yes	reo	End of Period Order

Add Column to New Table

Column	New Value (if any)	Description	Datatype	Initial Fill
year_s		Year
por_s		Portfolio
year_s		Year
launch_seq_s		Order of launch
por_s		Portfolio
timestamp		Optimistic locking
delay_l		Seconds to wait before launching portfolio
interval_l		Seconds between each check by portfolio monitor
stall_l		Number of Intervals to wait for EOP processing to begin or resume before making an external notification
md_eoy_run_s		Month and day on which to run EOY (MMDD)
eom_run_days_s		Day of each month on which to run EOM, in two-digit format (0N or NN)
launch_c		Launch through EOP Suite (Y/N)
run_accr_c		Run accruals on next launch (Y/N)
run_invo_c		Run invoicing on next launch (Y/N)
beg_chk_s		Beginning check number to use on next launch, or 0 for no check printing
job_stat_s		EOP job status reported by portfolio_mon or eop_run (EOP.EVENT code)
d_stat_s		Status date
t_stat_s		Status Time

Add Index to New Table

Index	New Value (if any)	Pieces	Description
rx0		year_s, por_s	Unique Clustered Identifier Nochanges
rx1		year_s,launch_seq_s,por_s	Unique Changes

reqa/rhqa: Asset 2

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
utilize_veh_tax_rates_c		Utilize vehicle tax rates (Y/N)	switch	N
d_payoff_quote_s		Payoff quote preparation date	date	NULL
custom_payoff_quote1_d		Custom payoff quote amount [0]	double/8.2	0.0
custom_payoff_quote2_d		Custom payoff quote amount [1]	double/8.2	0.0
custom_payoff_quote3_d		Custom payoff quote amount [2]	double/8.2	0.0
custom_payoff_quote4_d		Custom payoff quote amount [3]	double/8.2	0.0
custom_payoff_quote5_d		Custom payoff quote amount [4]	double/8.2	0.0

rhg: Historical General Ledger Names

NEW TABLE
Create New Table

New Table	New Name (if any)	New Description (if any)
yes	rhg	Historical General Ledger Names

Add Column to New Table

Column	New Value (if any)	Description	Datatype	Initial Fill
por_s		Portfolio
com_s		Company
reg_s		Region
off_s		Office
gl_vector_s		GL Vector
d_run_s		Run date
timestamp		Optimistic locking
number_s		GL account number
gl_nam_s		GL account name

Add Index to New Table

Index	New Value (if any)	Pieces	Description
0r		por_s, com_s, reg_s, off_s, gl_vector_s, d_run_s	Clustered, Unique, No changes

rho: Historical Location

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
p_st_rat_veh_sales_d		State rate for vehicle sales tax	percentage/2.5	0.0
p_st_oth_rat_veh_sales_d		State other rate for vehicle sales tax	percentage/2.5	0.0
p_ct_rat_veh_sales_d		County rate for vehicle sales tax	percentage/2.5	0.0
p_ct_tran_rat_veh_sales_d		County transit rate for vehicle sales tax	percentage/2.5	0.0
p_cy_rat_veh_sales_d		City rate for vehicle sales tax	percentage/2.5	0.0
p_cy_tran_rat_veh_sales_d		City transit rate for vehicle sales tax	percentage/2.5	0.0
p_st_rat_veh_use_d		State rate for vehicle use tax	percentage/2.5	0.0
p_st_oth_rat_veh_use_d		State other rate for vehicle use tax	percentage/2.5	0.0
p_ct_rat_veh_use_d		County rate for vehicle use tax	percentage/2.5	0.0
p_ct_tran_rat_veh_use_d		County transit rate for vehicle use tax	percentage/2.5	0.0
p_cy_rat_veh_use_d		City rate for vehicle use tax	percentage/2.5	0.0
p_cy_tran_rat_veh_use_d		City transit rate for vehicle use tax	percentage/2.5	0.0

rip: Insurance User Profile

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
s_ins_mod_c		User has access to corresponding insurance menu option (Y/N)	char/30	YYNNNNNNNNNNNNNNNNNNNNNNNNNNNN
email_s		Email address	char/50	NULL
fax_s		Fax dial number	char/10	NULL
phn_s		Phone number	char/10	NULL

rkp: Collateral User Profile

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
email_s		Email address	char/50	NULL
fax_s		Fax dial number	char/10	NULL
phn_s		Phone number	char/10	NULL

rlc: Lease Meter Charge

NEW TABLE
Create New Table

New Table	New Name (if any)	New Description (if any)
yes	rlc	Lease Meter Charge

Add Column to New Table

Column	New Value (if any)	Description	Datatype	Initial Fill
lse_s		Lease number
meter_id_s		Meter ID
d_run_s		Run date
t_run_s		Run time
timestamp		Optimistic locking
invo_s		Invoice number
opr_s		Operator initials
opr_r_s		Reversal operator initials
d_rev_s		Date of transaction reversal
t_rev_s		Time of transaction reversal
d_usage_beg_s		Usage period begin date
d_usage_end_s		Usage period end date
base_allow_l		Base allowance
prev_credit_l		Previous credit
new_credit_l		New credit
credit_applied_l		Credit applied
billed1_l		Number of items billed 1
billed2_l		Number of items billed 2
billed3_l		Number of items billed 3
billed4_l		Number of items billed 4
billed5_l		Number of items billed 5
billed6_l		Number of items billed 6
billed7_l		Number of items billed 7
billed8_l		Number of items billed 8
billed9_l		Number of items billed 9
billed10_l		Number of items billed 10
p_cpu_rate1_d		Cost per use rate 1
p_cpu_rate2_d		Cost per use rate 2
p_cpu_rate3_d		Cost per use rate 3
p_cpu_rate4_d		Cost per use rate 4
p_cpu_rate5_d		Cost per use rate 5
p_cpu_rate6_d		Cost per use rate 6
p_cpu_rate7_d		Cost per use rate 7
p_cpu_rate8_d		Cost per use rate 8
p_cpu_rate9_d		Cost per use rate 9
p_cpu_rate10_d		Cost per use rate 10
charged_d		Amount charged
tot_read_d		Total meter read

Add Index to New Table

Index	New Value (if any)	Pieces	Description
r0		lse_s, meter_id_s, d_run_s, t_run_s	Clustered, Unique, No changes
r1		lse_s, meter_id_s, d_run_s, t_run_s, invo_s	Unique, No changes

rlm: Lease Meter

NEW TABLE
Create New Table

New Table	New Name (if any)	New Description (if any)
yes	rlm	Lease Meter

Add Column to New Table

Column	New Value (if any)	Description	Datatype	Initial Fill
lse_s		Lease number
meter_id_s		Meter id
timestamp		Optimistic locking
desc_s		Meter description
d_start_s		Meter start date
d_last_s		Date of last update
t_last_s		Time of last update
curr_credit_l		Current credit
base_allow_l		Base allowance
end_range1_l		End range 1
end_range2_l		End range 2
end_range3_l		End range 3
end_range4_l		End range 4
end_range5_l		End range 5
end_range6_l		End range 6
end_range7_l		End range 7
end_range8_l		End range 8
end_range9_l		End range 9
end_range10_l		End range 10
p_cpu_rate1_d		Cost per use rate 1
p_cpu_rate2_d		Cost per use rate 2
p_cpu_rate3_d		Cost per use rate 3
p_cpu_rate4_d		Cost per use rate 4
p_cpu_rate5_d		Cost per use rate 5
p_cpu_rate6_d		Cost per use rate 6
p_cpu_rate7_d		Cost per use rate 7
p_cpu_rate8_d		Cost per use rate 8
p_cpu_rate9_d		Cost per use rate 9
p_cpu_rate10_d		Cost per use rate 10
bill_frq_l		Billing frequency

Add Index to New Table

Index	New Value (if any)	Pieces	Description
r0		lse_s, meter_id_s	Clustered, Unique, No changes

rlo: Location

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
freeze_s		On a state row: NONE - no rates are frozen; ST - state rates are frozen; INCL - all rates are frozen in the state and in + every county and city in the state. On a county row: NONE - no rates are frozen; ST - state rates are frozen; CO - county rates are frozen; STCO - state and county rates are frozen; INCL - all rates are frozen in the county and in + every city in the county. On a city row: NONE - no rates are frozen; ST - state rates are frozen; CO - county rates are frozen; CI - city rates are frozen; STCO - state and county rates are frozen; STCI - state and city rates are frozen; COCI - county and city rates are frozen; SCC - state, county, and city rates are + frozen.	char/4	'NONE'
p_st_rat_veh_sales_d		State rate for vehicle sales tax	percentage/2.5	0.0
p_st_oth_rat_veh_sales_d		State other rate for vehicle sales tax	percentage/2.5	0.0
d_st_veh_sales_s		Effective date of rate change, state vehicle sales tax	date	NULL
p_ct_rat_veh_sales_d		County rate for vehicle sales tax	percentage/2.5	0.0
p_ct_tran_rat_veh_sales_d		County transit rate for vehicle sales tax	percentage/2.5	0.0
d_ct_veh_sales_s		Effective date of rate change, county vehicle sales tax	date	NULL
p_cy_rat_veh_sales_d		City rate for vehicle sales tax	percentage/2.5	0.0
p_cy_tran_rat_veh_sales_d		City transit rate for vehicle sales tax	percentage/2.5	0.0
d_cy_veh_sales_s		Effective date of rate change, city vehicle sales tax	date	NULL
p_st_rat_veh_use_d		State rate for vehicle use tax	percentage/2.5	0.0
p_st_oth_rat_veh_use_d		State other rate for vehicle use tax	percentage/2.5	0.0
d_st_veh_use_s		Effective date of rate change, state vehicle use tax	date	NULL
p_ct_rat_veh_use_d		County rate for vehicle use tax	percentage/2.5	0.0
p_ct_tran_rat_veh_use_d		County transit rate for vehicle use tax	percentage/2.5	0.0
d_ct_veh_use_s		Effective date of rate change, county vehicle use tax	date	NULL
p_cy_rat_veh_use_d		City rate for vehicle use tax	percentage/2.5	0.0
p_cy_tran_rat_veh_use_d		City transit rate for vehicle use tax	percentage/2.5	0.0
d_cy_veh_use_s		Effective date of rate change, city vehicle use tax	date	NULL
p_st_rat_veh_sales_o_d		Old state rate for vehicle sales tax	percentage/2.5	0.0
p_st_oth_rat_veh_sales_o_d		Old state other rate for vehicle sales tax	percentage/2.5	0.0
p_ct_rat_veh_sales_o_d		Old county rate for vehicle sales tax	percentage/2.5	0.0
p_ct_tran_rat_veh_sales_o_d		Old county transit rate for vehicle sales tax	percentage/2.5	0.0
p_cy_rat_veh_sales_o_d		Old city rate for vehicle sales tax	percentage/2.5	0.0
p_cy_tran_rat_veh_sales_o_d		Old city transit rate for vehicle sales tax	percentage/2.5	0.0
p_st_rat_veh_use_o_d		Old state rate for vehicle use tax	percentage/2.5	0.0
p_st_oth_rat_veh_use_o_d		Old state other rate for vehicle use tax	percentage/2.5	0.0
p_ct_rat_veh_use_o_d		Old county rate for vehicle use tax	percentage/2.5	0.0
p_ct_tran_rat_veh_use_o_d		Old county transit rate for vehicle use tax	percentage/2.5	0.0
p_cy_rat_veh_use_o_d		Old city rate for vehicle use tax	percentage/2.5	0.0
p_cy_tran_rat_veh_use_o_d		Old city transit rate for vehicle use tax	percentage/2.5	0.0

rls/rhs: Lease

Change Column in Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
accrual_amt_this_month_d	tot_cap_int_d	Total capitalized interest	double/8.2	(none)

rlsb/rhsb: Lease 3

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
d_last_ofsa_s		Last OFSA (Oracle Fin Svcs Apps) run date	date	NULL
d_payoff_quote_s		Payoff quote preparation date	date	NULL
custom_payoff_quote1_d		Custom payoff quote amount [0]	double/8.2	0.0
custom_payoff_quote2_d		Custom payoff quote amount [1]	double/8.2	0.0
custom_payoff_quote3_d		Custom payoff quote amount [2]	double/8.2	0.0
custom_payoff_quote4_d		Custom payoff quote amount [3]	double/8.2	0.0
custom_payoff_quote5_d		Custom payoff quote amount [4]	double/8.2	0.0
adhoc_pap_d		Ad hoc PAP amount	double/8.2	0.0
d_adhoc_eff_s		Ad hoc effective date	date	NULL
float_bus_or_cal_c		Set float rate on business or calendar + day (P/F/C): P - set rate on previous business day; F - set rate on following business day; C - set rate on calendar day	switch	C
float_frq_s		Frequency of float rate setting (FLOAT.FREQ + code): NONE - rate setting functionality is disabled; DAY - daily; MON - monthly; QTR - quarterly; SEMI - semiannually; ANNL - annually	char/4	'NONE'
float_day_l		Day of month on which float rate is set (1-31 or 0). A value of zero indicates that the rate + setting functionality has been disabled.	integer	0
float_mon_l		Month in which float rate is set (0-12): 0 - frequency is NONE, MON or DAY; 1 - 3 - frequency is QTR; 1 - 6 - frequency is SEMI; 1 - 12 - frequency is ANNL	integer	0
p_float_base_d		Float base rate percentage	percent/2.5	100
calendar_s		Calendar code to use for determining business days (BUS.CALEND code)	char/4	BASE

rmp: Maturing Lease User Profile

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
xsl_filename_s		XSL file name	char/25	NULL
email_s		Email address	char/50	NULL
fax_s		Fax dial number	char/10	NULL
phn_s		Phone number	char/10	NULL

rmr: Lease Meter Asset Reading

NEW TABLE
Create New Table

New Table	New Name (if any)	New Description (if any)
yes	rmr	Lease Meter Asset Reading

Add Column to New Table

Column	New Value (if any)	Description	Datatype	Initial Fill
lse_s		Lease number
meter_id_s		Meter ID
d_run_s		Run date
t_run_s		Run time
unit_s		Asset
timestamp		Optimistic locking
prev_read_d		Previous meter read
new_read_d		New meter read
srvc_credit_l		service credit

Add Index to New Table

Index	New Value (if any)	Pieces	Description
r0		lse_s, unit_s, meter_id_s, d_run_s, t_run_s	Clustered, Unique, No changes

rpay: Portfolio 2

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
lse_cpu_assmt_code_s		Lease level cost per use assessment code	char/4	NULL
batch_app_disb_bank_s		Batch application disbursal bank account G/L vector	char/3	126
rcr_idrb_s		Recurring charge code for IDRB	char/4	NULL
rcr_idr6_s		Recurring charge code for IDR6	char/4	NULL
ibl_int_after_mat_c		Accrue IBL interest after maturity (Y/N)	char/1	N
auto_calc_app_interim_rent_c		Automatically calculate interim rent on applications (Y/N)	char/1	N
d_last_paynet_export_s		Date of last Paynet export	date	NULL

rpd: Payoff Quote

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
tot_diem_d		Total per diem amount	double/8.2	0.0
days_diem_l		Days of per diem	integer	0

rru: Recovery User Profile

Change Column in Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
options_s	s_rec_mod_c	User has access to corresponding recovery menu option (Y/N)	char/30	YYYYYYYYNNNNNNNNNNNNNNNNNNNNNN

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
xsl_filename_s		XSL file name	char/25	NULL
email_s		Email address	char/50	NULL
fax_s		Fax dial number	char/10	NULL
phn_s		Phone number	char/10	NULL

rsc: User Security

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
force_pwd_chg_c		Force password change next login (Y/N)	switch	N
lse_summ_xsl_filename_s		Lease Summary XSL file name	char/25	NULL
launch_pad_xsl_filename_s		Launch Pad XSL fle name	char/25	NULL
allow_ud_access_c		Allow access to user defined fields and tables (Y/N)	switch	Y
auto_logout_l		Automatic logout time period: number - automatically logout an idle user after number + seconds; 0 - disable automatic logout	integer	0

rsp: Customer Service User Profile

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
xsl_filename_s		XSL file name	char/25	NULL
email_s		Email address	char/50	NULL
fax_s		Fax dial number	char/10	NULL
phn_s		Phone number	char/10	NULL

rsr: Suspense Reversal

Change Column in Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
comments_s	sus_comments_s	Suspense comments	char/36	(no init)

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
ud_sus_type_s		User defined suspense type (SUS.UD code)	char/4	NULL
d_fol_s		Follow-up date	date	NULL

rst: State

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
veh_tax_rpt_c		Separate vehicle tax disbursal report (Y/N)	switch	N
veh_accrual_tax_rates_c		Rate-set to utilize in vehicle accruals (E/U/S/N): E - Equipment rental rates; U - Vehicle use rates; S - Vehicle sales rates; N - None	switch	N
veh_payoff_tax_rates_c		Rate-set to utilize in vehicle payoffs (E/U/S/N): E - Equipment rental rates; U - Vehicle use rates; S - Vehicle sales rates; N - None	switch	N

rsu: Suspense

Change Column in Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
comments_s	sus_comments_s	Suspense comments	char/36	(no init)

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
ud_sus_type_s		User defined suspense type (SUS.UD code)	char/4	NULL
d_fol_s		Follow-up date	date	NULL

rtr/rhr: Tax Release

Add Column to Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
utilize_veh_tax_rates_c		Utilize vehicle tax rates (Y/N)	switch	N
p_st_oth_rat_d		State other rate	percentage/2.5	0.0

rxp: EOP Synchronization

Change Column in Existing Table

Column	New Value (if any)	Description	Datatype	Initial Fill
eop_end_complete_s	eop_end_status_s	EOP Post-portfolio job statuses (N/P/R/F/C): N - No EOP running; P - Pending; R - Running; F - Failed; C - Completed	char/20	N*20

rzq: Business Calendar

Replace Existing Table

New Table	New Name (if any)	New Description (if any)
no

New/Replacement Column in Replacement Table

Column	New Value (if any)	Description	Datatype	Initial Fill
calendar_s		Calendar code (BUS.CALEND code)	char/4	BASE
desc_s		Description	char/36	BASE
day_type_s		Type of day (X/H/' '): X - Non business day, usually + Saturday and Sunday; H - Holiday; ' ' - Business day. Position 1 is Nov 1st of the + previous year. Position 0 not used.
day_type1_s		Type of day (X/H/' '): X - Non business day, usually + Saturday and Sunday; H - Holiday; ' ' - Business day. Position 1 is Nov 1st of the + previous year.	char/231	oldrzq.hldy1_s
day_type2_s		Type of day (X/H/' '): X - Non business day, usually + Saturday and Sunday; H - Holiday; ' ' - Business day. day_type2_s is a continuation + of day_type1_s. Position 1 in day_type2_s is the day after + position 231 in day_type1_s.	char/231	oldrzq.hldy2_s

New/Replacement Index in Replacement Table

Index	New Value (if any)	Pieces	Description
rx0		calendar_s, year_s	unique clustered

Existing/Remaining Object in Replacement Table

Object Name	Description	Datatype	Initial Fill
year_s	Year	char/4	oldrzq.year_s
timestamp	Optimistic locking	timestamp	NULL

vrar_tot_out: A/R Total Outstanding

NEW VIEW
Create New View

New Table	New Name (if any)	New Description (if any)
no

Add Column to New View

Column	New Value (if any)	Description	Select Statement
tamt_b_d		Total Amount Billed	sum(isnull(tamt_b_d, 0.0))
tamt_p_d		Total Amount Paid	sum(isnull(tamt_p_d, 0.0))
tamt_out_d		Total Amount Outstanding	sum(isnull(tamt_b_d, 0.0) - isnull(tamt_p_d, 0.0))

vrarb_tot: A/R Totals by Invoice

NEW VIEW
Create New View

New Table	New Name (if any)	New Description (if any)
no

Add Column to New View

Column	New Value (if any)	Description	Select Statement
aamt_b_d		Assessment Amount Billed	sum(isnull(aamt_b_d, 0.0))
aamt_p_d		Assessment Amount Paid	sum(isnull(aamt_p_d, 0.0))

vrcx_brk: Broker Short Name

Add Column to Existing View

Column	New Value (if any)	Description	Select Statement
bus_phn_s		Business phone	rcx.bus_phn_s

vrcx_cus: Customer Short Name

Add Column to Existing View

Column	New Value (if any)	Description	Select Statement
bus_phn_s		Business phone	rcx.bus_phn_s

vrcx_grt: Guarantor Short Name

Add Column to Existing View

Column	New Value (if any)	Description	Select Statement
bus_phn_s		Business phone	rcx.bus_phn_s

vrcx_hls: Historical Lessee Short Name

Add Column to Existing View

Column	New Value (if any)	Description	Select Statement
bus_phn_s		Business phone	rcx.bus_phn_s

vrcx_inv: Investor Short Name

Add Column to Existing View

Column	New Value (if any)	Description	Select Statement
bus_phn_s		Business phone	rcx.bus_phn_s

vrcx_len: Lender Short Name

Add Column to Existing View

Column	New Value (if any)	Description	Select Statement
bus_phn_s		Business phone	rcx.bus_phn_s

vrcx_les: Lessee Short Name

Add Column to Existing View

Column	New Value (if any)	Description	Select Statement
bus_phn_s		Business phone	rcx.bus_phn_s

vrcx_vnd: Vendor Short Name

Add Column to Existing View

Column	New Value (if any)	Description	Select Statement
bus_phn_s		Business phone	rcx.bus_phn_s

vrgc_udc: User-Defined Client Cross Reference

NEW VIEW
Create New View

New Table	New Name (if any)	New Description (if any)
no

Add Column to New View

Column	New Value (if any)	Description	Select Statement
app_lse_s		Application/Lease	app_lse_s from rgc where rgc.client_typ_c = 'U'
client_id_s		Client Id	client_id_s from rgc where rgc.client_typ_c = 'U'

vrls_billing: Lease Billing Information

NEW VIEW
Create New View

New Table	New Name (if any)	New Description (if any)
no

Add Column to New View

Column	New Value (if any)	Description	Select Statement
lse_s		Lease	rls.lse_s from rls, ral where rls.b_lvl_c = 'L' and rls.les_s = ral.les_s (union) from rls, rcu where rls.b_lvl_c = 'C' and rls.cus_s = rcu.cus_s (union) from rls, rlsa where rls.b_lvl_c = 'I' and rls.lse_s = rlsa.lse_s
b_lvl_c		Billing Level (L-Lessee/C-Customer/I-Individual)	rls.b_lvl_c from rls, ral where rls.b_lvl_c = 'L' and rls.les_s = ral.les_s (union) from rls, rcu where rls.b_lvl_c = 'C' and rls.cus_s = rcu.cus_s (union) from rls, rlsa where rls.b_lvl_c = 'I' and rls.lse_s = rlsa.lse_s
bill_nam_s		Billing name	ral.bill_nam_s from rls, ral where rls.b_lvl_c = 'L' and rls.les_s = ral.les_s (union) from rls, rcu where rls.b_lvl_c = 'C' and rls.cus_s = rcu.cus_s (union) from rls, rlsa where rls.b_lvl_c = 'I' and rls.lse_s = rlsa.lse_s
bill_add_s		Billing address	ral.bill_add_s from rls, ral where rls.b_lvl_c = 'L' and rls.les_s = ral.les_s (union) from rls, rcu where rls.b_lvl_c = 'C' and rls.cus_s = rcu.cus_s (union) from rls, rlsa where rls.b_lvl_c = 'I' and rls.lse_s = rlsa.lse_s
bill_add2_s		Billing address 2	ral.bill_add2_s from rls, ral where rls.b_lvl_c = 'L' and rls.les_s = ral.les_s (union) from rls, rcu where rls.b_lvl_c = 'C' and rls.cus_s = rcu.cus_s (union) from rls, rlsa where rls.b_lvl_c = 'I' and rls.lse_s = rlsa.lse_s
bill_cty_s		Billing City	ral.bill_cty_s from rls, ral where rls.b_lvl_c = 'L' and rls.les_s = ral.les_s (union) from rls, rcu where rls.b_lvl_c = 'C' and rls.cus_s = rcu.cus_s (union) from rls, rlsa where rls.b_lvl_c = 'I' and rls.lse_s = rlsa.lse_s
bill_st_s		Billing State	ral.bill_st_s from rls, ral where rls.b_lvl_c = 'L' and rls.les_s = ral.les_s (union) from rls, rcu where rls.b_lvl_c = 'C' and rls.cus_s = rcu.cus_s (union) from rls, rlsa where rls.b_lvl_c = 'I' and rls.lse_s = rlsa.lse_s
bill_zip_s		Billing Zip	ral.bill_zip_s from rls, ral where rls.b_lvl_c = 'L' and rls.les_s = ral.les_s (union) from rls, rcu where rls.b_lvl_c = 'C' and rls.cus_s = rcu.cus_s (union) from rls, rlsa where rls.b_lvl_c = 'I' and rls.lse_s = rlsa.lse_s

Enhancements
Sorted by Ticket Number

513118 Extended Grace Period Maximum

Users can now enter grace periods of 0 to 999 days at the Portfolio [U0212], Lease Form [U0721], or application/lease level.

• Portfolio [U0212]: Miscellaneous Customizations, Grace Period in Days (field)
• Lease Form [U0721]
• Application [U08], Grace Period (field)
• New Lease [U0101]: Book Lease, Grace Period (field)
• Master Financial [U0202], Grace Period (field)

513611 Additional Non-Vertex Rates (Vehicle Tax)

Provides an additional set of non-Vertex tax rates for use with vehicles or other special circumstances.

• Additional Non-Vertex Rates

513812 Non-Monetary Archive Report Enhancement

The Non-Monetary Archive Report [R0413] now includes options for reporting on security, portfolio, custom general, and remittance address changes.

• Non-Monetary Archive Report [R0413]

515653 Batch Application Enhancement

Batch Applications module

This enhancement add two functions to Batch Applications:

• Portfolio [U0212]: Miscellaneous Customizations, Batch Application Disbursal Bank Code (field)
• Custom General [U0712]: Miscellaneous Customizations, Alternate A/P Check Screen (field)
• New Lease [U0101]: Batch Applications

515743 LeasePak Password Security Enhancements

LeasePak now includes the ability to specify a minimum length and inclusion of uppercase, numeric, or special characters for passwords, force a password change at a user's next login, and configure server-side files to lock out a user after a specified number of failed logon attempts.

• LeasePak Basics, Changing Client Password
• Security [U0706], Waiver Tolerance/Password Tab
• Custom General [U0712]: Miscellaneous Customizations

515915 Lease-Level Cost Per Use

Cost Per Use module

Cost Per Use now offers the addition of lease-level meters, where LeasePak tracks meter readings and assessed charges for the whole lease, using a lease-level general ledger assessment account.

• Cost Per Use

516220 Phone, Fax, and E-mail fields in Tracking Modules' User Profiles

LeasePak now includes fields for phone, fax, and e-mail information in the user profiles of the Application [U08], Collection [U11], Collateral [U12], Insurance [U13], Maturing Lease [U14], Customer Service [U16], and Recovery [U17] tracking modules.

• Application User Profile [U0831]
• Collection User Profile [U1131]
• Collateral User Profile [U1231]
• Insurance User Profile [U1331]
• Maturing Lease User Profile [U1431]
• Customer Service User Profile [U1631]
• Recovery User Profile [U1731]

516303 Tracking Modules Menu Security Enhancement

The Collateral [U12], Insurance [U13], Customer Service [U16], and Recovery [U17] tracking modules' user profiles all now include working Menu Security tabs that the administrator or supervisor can use to specify which tracking module menu items users have access to.

• Collateral User Profile [U1231]
• Insurance User Profile [U1331]
• Customer Service User Profile [U1631]
• Recovery User Profile [U1731]

516370 Multi Lease Insurance Maintenance

LeasePak now provides an update similar to Demographic [U0204] that allows the user to add, change, or delete insurance information for one or more leases under the same Customer.

• Multi Lease Ins Maintenance [U0234]

516657 Asset Write Up/Down Enhancement

The Change Asset [U0120] update now includes an option to write up or down the book value of an asset in inventory.

• Change Asset [U0120]: Write Up/Down

516671 Automatic Logout Timer

Security [U0706] now includes an optional function to set an automatic logout timer, giving a user with a LeasePak client session that remains inactive (no keyboard or mouse input) beyond the specified amount of time a 15-second warning, after which LeasePak will automatically log off the inactive user.

• Security [U0706], Waiver Tolerance/Password Tab

516676 Off Lease Billing Proceeds Reporting

Off Lease Billing module

Off Lease Billing users can now enter an amount during Payoff [U0103]: Payoff (lease or asset) that will appear in both the Tax Gain/Loss [R0311] and Gain/Loss--EOY [U0606] reports.

• Payoff [U0103]: Payoff, OLB Proceeds (field)
• Tax Gain/Loss [R0311], Proceeds From Sale (field)

516747 Ad Hoc ACH

PAP/ACH module

The Miscellaneous Billing Info [U0227] update now includes the option of submitting an ad hoc ACH request. This is available for PAP bank file layout types of 'ACH', 'BM1', 'RB1', and 'TD1' and can even be used for leases where regular PAP is set to 'No'.

• Miscellaneous Billing Info [U0227]

516893 XML-based Lease Summary, Alternate Lease Summary Screens

Collection, Customer Service, Maturing Lease, or Recovery Tracking module

LeasePak now provides user-customizable Lease Summary and Alternate Lease Summary screens based on an XML/XSL format.

• XSLT Customizations: Lease Summary

516948 User-Defined Fields and Tables Maintenance Enhancement

The new UDF/UDT Maintenance [U0235] update allows users to modify user-defined fields and tables without having to access the Vendor [U0201], Master Financial [U0202], Lessee [U0203], Customer [U0205], or Asset [U0210] updates. Also, LeasePak now includes a Security [U0706] switch to allow or block a user's access to user-defined fields and tables updates.

• UDF/UDT Maintenance [U0235]
• Security [U0706], Allow Access to UDF/UDT (field)

516984 Balloon Payment Residual for IBLs

Loan Accounting (IBL) module

LeasePak now allows users to book a balloon payment into the Residual field and use that amount in payoff calculations.

• Interest Bearing Loans, Balloon Payment Residual

516985 Effective Date After Maturity for IBLs

Loan Accounting (IBL) module

For IBLs in NMAT (matured) status and with Capitalize Interest set to 'N', users can now specify an effective date as far forward of the accrued-to or maturity date as needed. This feature applies to Payments [U0102]: Payments, Cash Control [U0126], Batch Payments [U0305], Batch Payments (EOP) [U0415], Payoff [U0103]: Payoff, and Batch Payoff [U0129].

• Interest Bearing Loans, Effective Date After Maturity

516993 Supervisor-Type Collection Status Enhancement

Alternate Lease Summary screen

Now when a supervisor places an account in supervisor-type status, automated processes and ordinary collectors cannot change the account to another status. Only a supervisor can change the status. While the account is in a supervisor-type status, all programs performing automatic status reassignments (for example, to statuses 80-86) will not be able to change the status on the account, although they will still be able to generate notes related to reassignment activity.

• Collection Status Defaults [U1151]

517165 Automatic Interim Interest Calculation for IBLs

Loan Accounting (IBL) module

LeasePak now offers a portfolio-level switch that the administrator can use to activate automatic interim rent interest calculations for IBL applications. LeasePak calculates interim rent based on the number of days between the Contract Date and Commencement Date, using the rate (fixed or floating) information entered in the application.

• Interest Bearing Loans, Automatic Interim Interest Calculation
• Portfolio [U0212]: New Lease Customizations, Auto App IBL Interim Rent (field)

517167 Enhanced Loan Rates

Commercial Loan module

Commercial Loan users now have the option of adding custom calendars to Weekend And Holiday Assgn [U0720], as well as new rate fields employing custom calendars to determine additional rate parameters such as base rate percentage, day of the month and month to get rates from the rate table, and frequency to retrieve rates.

• Commercial Loan
• Base Rates [U0705]

517497 Historical General Ledger Names/Numbers

LeasePak now provides a way of archiving general ledger account name and number change information, preserving historical names/numbers on older transactions.

• Historical General Ledger Names/Numbers

517582 Payoff Note Enhancement

LeasePak now provides an expanded list of notes generated during Payoff [U0103] or Batch Payoff [U0129] corresponding to lease activity status codes. The code category for the payoff note codes in Custom General [U0722] is PAYOFF.ACT.

• Lease Status Codes
• Custom General [U0722]

517663 Tax Rate Override Enhancement

The Location [U0701] update features two new fields: Prevent Update Code, in which the user can specify whether or not Vertex can update the code; and Manual Override, which the user can switch on to manually override the Vertex rate (or previously manually input rate) through the Location update.

• Location [U0701]

518251 LaunchPad for LeasePak

LeasePak now features an HTML/XML/XSL user-customizable menu interface, similar in structure to the new Alternate Lease Summary. Specific documentation coming soon.

• XSLT Customizations: Lease Summary

519108 LeasePak Utility 232: Master G/L Reconciliation Report

The LeasePak Utilities now include a function that provides a way for users to run the Master General Ledger Reconciliation Report [U0460] outside of End of Period.

• LeasePak Utilities 232: Master G/L Reconciliation report
• Master General Ledger Reconciliation Report [U0460]

519232 IBL Full History Report

Commercial Loan module

For Commercial Loan module users, LeasePak now offers an additional section to the IBL Inquiry [R0927] report, the IBL Full History [R0927B]. This new report provides a general header section for an Interest Bearing Loan (IBL) or individual IBL invoice, along with a full history section of payment and history activity.

• Commercial Loan
• IBL Full History [R0927B]

519234 Field for Outstanding Loan Balance in LPBookLease

Web Services API module

The Web service LPBookLease now includes a field for reporting on oustanding loan balance (outstandingLoanBalance).

• LeasePak Web Services API: Document-Literal Web Services, LPBookLease

521675 Batch IDC Adjustment Utility

Provides a LeasePak Utility to adjust (write up or down) Book IDC and Tax IDC and write up IDC2 Notary Fee (a broker payable) on a group of leases by way of a batch input file.

• LeasePak Utilities: 236 Batch IDC Adjustment Utility

Discrepancy Fixes

Verified fixes: code changes have been delivered and verified at time of publication.

Ticket Number	Main Update or Report	Description	Ver/Build (n.nn.nnnn)
509126	U0126	Reports for principal and interest payments were showing the batch payment creator for the operator initials, while overpayments were showing the processor for the operator initials.	6.00.2026
515798	U0415	LeasePak allowed a payment extension on a RAX5 loan to a partially paid invoice, resulting in batch payment errors as well as GLOOB conditions.	6.00.1834
515880	U0118DC	LeasPak did not create a new invoice accrual after a payment and accrual adjustment on a RAX5 IBL.	6.00.2045
515971	U0415	The U0415 exception report was creating redundant suspense exceptions for closed IBL accounts.	6.00.1941
516721	U0104	Error message 'Deferment fee will not process partial paid' should only appear once.	6.00.2026
516768	R0901	The total amount in Unrecognized Oper Income was truncated after running End of Year (EOP).	6.00.1954
517382	U0121	LeasePak froze when attempting to back out of General Ledger Adjustment without using the Cancel button.	6.00.1844
517462	U0109	Reversing a suspense item via U0102BR that was previously cleared through U0109CA produced an inconsistent R0405 transaction.	6.00.2001
517615	U0801	Client short names containing ampersands were displayed in tracking modules with double ampersands.	6.00.2026
517871	R0927	Calculations were off for IBL accounts, possibly due to leap year differences.	6.00.2218
517880	U0114	Change Lease Key was not making the appropriate journal entries.	6.00.1998
518228	U0228	User erroneous received message 'New cost is more or equal to existing cost' when in fact the new cost was less than the existing cost.	6.00.1949
518242	U0415	IBL RAX5 payments processed via batch U0415 (U0126U0305) were returning new and different exception messages.	6.00.1954
518246	LPUX	Client Auditing was tracking tables that did not require audit trail.	6.00.1941
518674	U0202	User was unable to delete billing address, state, or zip code, received errors 'Invalid state abbreviation', 'Invalid US zip code'.	6.00.2045
518807	U0102	User received error 'LSGL BAS: exceeded trasaction counter maximum (99)' while attempting to process a batch payment reversal.	6.00.2021
518911	U0102RR	LeasePak was using the maintenance date instead of the original effective date when a payment was reversed with a reason code other than TMSA.	6.00.2045
518994	U0103PF	LeasePak did not included a legal fee assessment in the Total Payoff amount, yet applied the fee during payoff, creating an out-of-balance condition.	6.00.2045
519052	U0101	LeasePak made an incorrect general ledger entry when an asset was deleted from inventory	6.00.2048
519109	LPUX	Drivers were mysteriously disappearing on the Solaris/Oracle platform, during both interactive and End of Period processes.	6.00.2201
519185	U0811	User received error 'ORA-01401: inserted value too large for column' when attempting to add a 37th application status.	6.00.2084
519292	U0433	Late charge method OUTF was not assessing correctly.	6.00.2108
519310	R0909	XML format report did not display comments.	6.00.2088
519491	U0102	Issues with distribution of paid tax amounts on RTP records.	6.00.2249
519501	Lease Summary F5	Stored procedure changes needed.	6.00.2096
519549	U08 Work Schedule	User receive error 'Run-time error 730: Control txtRefresh not found' when attempting to use the Application Work Schedule.	6.00.2103
519605	U0116	User was unable to waive part of the registration after accidently adding it twice. Also, registration was confirmed on Accounts Receivable R0404 but not on Assessment Waiver U0105.	6.00.2125
519612	API	The user-defined table was not working.	6.00.2129
519628	U0231	Add Meter Charges updated needed a warning message when user added meter charges without a Portfolio U0212 setup.	6.00.2112
519719	U0801	Application work shedule aborted when the schedule record was created after midnight.	6.00.2123
519998	Notebook	User received error 'bOraBatch Trans():Statement Execute Failed. Error-ORA-20101: mpkg_trig_mjl.mpp_lock_app_lease: unable to lock app/lease' while adding a Customer Service (S) type note in Notebook.	6.00.2182
520026	LPUX	Enhancement 515743. New password restrictions were allowing passwords with identical adjacent characters.	6.00.2168
520099	LPUX	ACH generated batch payment files with incorrect payment due dates.	6.00.2231
520122	LPUX	Program generated final invoice when deal already had first and last payments paid up front.	6.00.2234
520136	Change Password	User received error 'Error: Too many unsucessful login attempts. Account locked' then 'Error: No such file or directory' while attempting to change the password. Related to enhancement 515743.	6.00.2222
520186	LPUX	User received error 'Could not launch driver on Server. Check for bad, missing or incorrect permissions in the given server environment' when prompted for password change on logon to 6.0.	6.00.2215
520205	LPVB	Users sporadically received error 'Runtime error 9 Subscript out of range' on various reports and modules.	6.00.2201
520230	LPUX	EOP scratch file issue.	6.00.2240
520230	U0302	Issues with invoice timing and assessment placement on invoices with advanced invoicing.	6.00.2241
520240	LPVB	Scroll bar collapsed in U0203 Lessee. This is the same issue as 519556.	6.00.2218
520241	U11	The remaining payments calculation was not working on the Alternate Lease Summary screen.	6.00.2201
520241	U1101	Remaining payments calculation was not working.	6.00.2224
520253	U0420	Update incorrectly applied newest suspense item.	6.00.2222
520255	U0102PA	User received error 'Check number required for Cash Control' while forced to re-enter check numbers on subsequent payment screens.	6.00.2223
520292	R0405	Program displayed a Windows Cut/Copy/Paste/Delete/Select All dropdown when right-clicking on a date field.	6.00.2222
520293	Upgrade	User was unable to complete upgrade from 5.3a to 6.0a and received the error 'Add ras switches, invalid skip column length in ras, Can't Add ras switches' etc.	6.00.2201
520294	U0102 PA	Real Time collections was not working with payments to a lease with no overage amount.	6.00.2201
520296	U08	Application Asset terminated when the user chose NOUT on the Miscellaneous tab.	6.00.2201
520305	R0926	IBL RAX5 monthly schedule contract with 3 payments on the same effective date had a corruption occur to 1 batch payment record after the user reversed 1 of 3 same-dated payments, reapplying the other 2.	6.00.2222
520315	U1101	Update created a duplicate entry when the user noted an account, leaving an extra blank note.	6.00.2216
520327	U0235	The new UDF/UDT Maintenance update was not complying with the Portfolio switch settings for Code Edit or Input Required on many of the fields. Related to enhancement 516948.	6.00.2216
520335	U0233	If the beginning meter read was greater than 999, the beginning meter read was not being saved correctly--the program was dropping all numbers past the first comma.	6.00.2215
520341	R0915	R0915 report was displaying 'Freeze' setting at the state level, depending on whether the whole state was displayed or a specific county, and the combined rate was not displaying correctly on the U0701 update.	6.00.2224
520353	U0209	User was no longer able to add an IBL type lease to Customer/Group.	6.00.2215
520357	U0107 PE	User was unable to process a payment extension on an IBL/RAX5 lease when including a fee.	6.00.2222
520367	U0227	User was unable to populate new fields for BM1 bank file type.	6.00.2218
520403	U0203	User received error 'Invalid format size with specified input' when trying to pull all sections for the report.	6.00.2218
520458	U0437	Program was incorrectly updating the current State rate with Prevent Update set to ST.	6.00.2218
520459	U0713	Update lacked warning message if user changed Vertex Rate to Use to 'NONE'.	6.00.2218
520462	U0227	User had trouble with payments dropping off, auto-rescheduling of due dates and R0114 displaying incorrect information. Related to enhancement 516747.	6.00.2216
520494	U1101	Alternate Lease Summary was not reflecting the change when the collection status was changed.	6.00.2216
520540	U0302	The invoicing scratch file process was creating multiple entries with the same invoice number.	6.00.2220
520556	LPUX	User without U0706 access rights was able to an update in U0706.	6.00.2216
520627	R0915	Using the selection criteria 'All' resulted in no locations listed.	6.00.2218
520674	LPUX	User received error 'no next field on form' twice then error 'no fields found for path 1 on form LDT01' when clicking on the daily transaction journal link on the tax tab.	6.00.2222
520675	U1101RR	Program terminated when the user attempted to open the repo request screen from the collections menu and refer for repo.	6.00.2224
520676	LPVB	User received error 'invalid menu selection' and 'module not purchased or no security for this option' when clicking the Change link next to Vehicle Registration.	6.00.2222
520677	U11 RR	User received a VB error 91 while attempting to begin a REPO APPROVE note.	6.00.2229
520691	LPVB	Launchpad vertical menus were not displaying correctly with IE7 installed.	6.00.2220
520742	LPUX	Program was not accepting special characters in passwords. Related to enhancement 515743.	6.00.2220
520744	LPUX	User received misleading error 'New password requires special characters' when the missing element was numeric.	6.00.2220
520757	U1701RA	User received MSIDAO error while attempting to assign repossession agents and cancel assignments.	6.00.2228
520757	U1701RA	User received MSIDAO error while attempting to assign repossession agents and cancel assignments.	6.00.2228
520759	LPUX	User received error while attempting to view the notebook tab.	6.00.2225
520767	U1101	User was seeing a time stamp in the lessee number field. Related to 519701.	6.00.2224
520789	U0720	User was not able to tab properly through the update when tabbing through the last row in the scrolled region.	6.00.2220
520826	R0905	Inventory values for CSA and FIN contracts were incorrect when terminating an asset.	6.00.2224
520831	Change Password	User received error 'No such file or directory' while trying to unlock an account locked due to failed password attempts.	6.00.2220
520854	R0502	Report displayed errant characters in the Base Factor Rate field.	6.00.2220
520863	API	User was unable to sent applications through the API, received error 'java.rmi.RemoteException: Application number not found! SEVERE ERROR: No xml document found in xsox_message()'.	6.00.2223
520888	U0801	Fields disabled through field security were still available in the application tabs.	6.00.2223
520991	U1101	Progam was hanging when user attempted to retrieve an account.	6.00.2225
520992	U0218	Removing a lessee resulted in data corruption.	6.00.2225
521012	LeasePak Utilities	User received the error 'RZA Info has exceeded the buffer contents' while using Lease Utility 217- Auditing Extract.	6.00.2227
521043	U0302	User received error message 'Error reading DLO record for use tax rate' while running Cycle Invoices, either interactively or through End of Period.	6.00.2226
521052	U0306	The exception message 'Rev Susp ** created. Lease has been paid off or terminated' was shortened to 'Rev Susp** created', causing the user problems.	6.00.2229
521103	Lease Summary	The R0405 HTTP Request was not working in any of the Lease Summary screens.	6.00.2227
521106	U0401	User received error 'EOP SYNCH ERROR IN - Can't interpret flags IYN' during End of Period.	6.00.2227
521110	U0102 BR	User received error 'Lease is terminated/paid off' while attempting to reverse a batch payment.	6.00.2234
521112	U0305	User received error 'rxora_dtr_to_rtr.c: null character found in string field in dtr map at byte offset 69' during ACH batch payment file generation.	6.00.2231
521123	LPUX	User received error 'LEASEPAK UX - Mxora_execute: OCIStmtExecute error. OCI status: OCI_ERROR ORA-00001: (LPR_PRODUCTION.RID_IDX0) violated' during Sequential Updates.	6.00.2231
521134	U0227	User was unable to access update for matured or paid off leases.	6.00.2237
521136	U0105	The Multi-Asset Tax Waiver option was not updating the RTR table with the tax waivers.	6.00.2228
521143	LPUX	User received run time error 13, type mismatch, while attempting to sell an asset that had been previously sold and reversed.	6.00.2229
521176	U16 Lease Summary	The Lease Summary screen 'Enter Note' button was grayed out when it was populated by the ScreenPop application.	6.00.2228
521176	U1601 Lease Summary	The Enter Note button was grayed out on the Lease Summary screen when it was populated by the ScreenPop application.	6.00.2229
521195	U0103	Program left one asset with a negative starting cost after the user terminated an extended lease with two assets.	6.00.2240
521257	U0103 SA	Asset Net Book Value was incorrect.	6.00.2238
521286	mPower LinkIT	User received an error during the Insurance portion of API: 'INSURANCE: java.rmi.RemoteException: Severe Error: There was a problem receiving data from the server. Mxora_execute: OCIStmtExecute error. OCI status: OCI_ERRORORA-00001: unique constraint (LPR_PRODUCTION.RDM_IDX0) violatedorg.xml sax.SAXException: API Error, processing stopped'.	6.00.2231
521333	U0103	User received error 'Asset has corrupt negative inven_d' while attempting to pay off or terminate a lease.	6.00.2237
521379	U0103	User received error 'lxassmtw_upd_dls_wvr_lmts: Invalid assmt type passed in' while attempting a lease payoff reversal.	6.00.2229
521421	mPower API	API was missing the application-level field for Total Insurance Premium.	6.00.2234
521576	U0418	User received error 'mxsignal_handler(): Trapped signal SEGV' when attempting to include Batch Assessment in End of Period.	6.00.2250
521716	LPUX	PAP for August and September was applied to older outstanding invoices despite switch settings.	6.00.2231
521837	U11 Lease Summary	Scrnpop: Daily Transaction link was not working--user received error 'LEASEPAK UX - lxhttp_xml_bld_str: The XML document has exceeded the maximum allowable data transfer size of 65520 bytes'.	6.00.2237
521838	U11 Repo Request	Scrnpop: User ID erroneously changed during a repo approval.	6.00.2237
521841	U1101	Scrnpop: No queue movement occurred when user transferred status to a supervisor status.	6.00.2238
521846	U11 Customer Summary	User encountered an error and the Customer Summary screen terminated abnormally during an update.	6.00.2231
521854	U11 Lease Summary	Scrnpop: User received error while attempting to view next 10 on Notebook tab.	6.00.2237
521855	U0425	Linux only: EOP failed due to problem with Queue Manager.	6.00.2240
522035	SETUP	Setup script was removing the adm environments.	6.00.2249
522057	U0430	Accruals created duplicate invoices.	6.00.2250
522586	U0101 Book Lease	Booking the Acquisition Fee created a debit in the clearing account and subsequent general ledger out-of-balance condition.	6.00.2253
522620	R0405	Report displayed wrong Transaction Type for an IDC/IDR Adjustment.	6.00.2253
522653	LeasePak Utilities	Batch IDC Adjustment utility produced erroneous data in the audit report.	6.00.2253
522741	LeasePak Utilities	Batch IDC Adjustment utility wrote amount information to the lease number column on the audit report.	6.00.2254

Documentation Changes
Sorted by Ticket Number

For these, corrections to the documentation for the specified tickets are complete.

Ticket Number	Type	Document or Publication	Description	Month/Year
none	Change	System Administration Guide	System Administration Guide Changes to include information about new OS and DBMS platforms.	12/2006
none	Change	Database References	Improved design for LeasePak Database References.	12/2006
none	Change	Reference Guide	Created preliminary document for Print/View User Reports [R0929]	06/2007
17066	Correction	Reference Guide	Removed reference to sold assets from Off Lease Inventory [R1001]	06/2007
518251	Change	Documentation Suite	Created document for LaunchPad.	06/2007
519819	Correction	Reference Guide	Removed erroneous reference to Vehicle Finance exception from Off Lease Inventory [R1001].	06/2007
520190	Correction	System Administration Guide	Separated conversion instructions for Oracle and Sybase.	06/2007

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.