Current Release Notes
LeasePak 7.6a
Build 8877
For information on previous releases, refer to the Release Notes Archive. You can also find copies of the archive PDFs in the separate ReadMe folder.
Release Bulletin
A full list of discrepancies fixed and enhancements delivered in this release are in the latest Release Bulletin (76a_release_bulletin_GA.pdf).
Important Notices
LeasePak Database columns to be removed in 7.6a
Build 8877
The following columns are obsolete and will be removed from LeasePak in the 7.6a release. If you are currently using or referencing any of these columns in your custom software, NETSOL recommends that you remove them from the software.
| Column Name |
|---|
| mwr.reserved1_s |
| rac.pap_amt_pref_c |
| rcg.davox_eop_skip_c |
| rcg.davox_multi_proc_l |
| rco.davox_excl_c |
| rzu.old_value_s |
LeasePak Database Columns to be Changed in 7.6a
Build 8877
The following columns will be changed in the 7.6a release of LeasePak. If you are currently using
or referencing any of these columns in your custom software: when you upgrade to LeasePak 7.6a,
you should also update your custom software to handle the changes to these columns.
| Column Name | |
|---|---|
| raq.yr_s | Changing from char(2) format YY to char(4) format YYYY |
| req.yr_s | Changing from char(2) format YY to char(4) format YYYY |
| rhq.yr_s | Changing from char(2) format YY to char(4) format YYYY |
| rps.model_yr_s | Changing from char(2) format YY to char(4) format YYYY |
| rpr.dpr_key_seg_s | Renaming from rpr.dpr_key_seg_s to rpr.ym_prim_s, and changing from char(4) format **MM to char(6) format YYYYMM (where ** was a 2-digit proprietary number which encoded both the year and a sort order) |
Database Changes
rapd Application Document
| Column Name | Description | Oracle Datatype | Oracle Allow Null | Sybase Datatype | Sybase Allow Null | Initial Value |
|---|---|---|---|---|---|---|
| doc_id_s | Document ID | CHAR(10) | yes | char(10) | yes | NULL |
rcg Custom General
| Column Name | Description | Oracle Datatype | Oracle Allow Null | Sybase Datatype | Sybase Allow Null | Initial Value |
|---|---|---|---|---|---|---|
| unique_sub_asset_id_c | Ensure rsq.id_s is unique across all sub asset records (Y/N) | CHAR(1) | yes | char(1) | yes | 'N' |
rcgb Custom General 2
| Column Name | Description | Oracle Datatype | Oracle Allow Null | Sybase Datatype | Sybase Allow Null | Initial Value |
|---|---|---|---|---|---|---|
| docgen_attach_dir_s | DocGen file attachment directory (PDF) | VARCHAR2(80) | yes | char(80) | yes | NULL |
| docgen_template_dir_s | DocGen document template directory (MS Word) | VARCHAR2(80) | yes | char(80) | yes | NULL |
| wm_url_s | WebMerge URL (Uniform Resource Locator) | VARCHAR2(80) | yes | char(80) | yes | NULL |
| wm_encr_api_key_s | WebMerge encrypted API key | VARCHAR2(50) | yes | char(50) | yes | NULL |
| wm_encr_api_secret_s | WebMerge encrypted API secret | VARCHAR2(50) | yes | char(50) | yes | NULL |
rdcd Application Document List
| Column Name | Description | Oracle Datatype | Oracle Allow Null | Sybase Datatype | Sybase Allow Null | Initial Value |
|---|---|---|---|---|---|---|
| doc_id_s | Document ID | CHAR(10) | yes | char(10) | yes | NULL |
rdg Document Generation
| Table Name | Description |
|---|---|
| rdg | Document Generation |
rds Document Data Definition SQL
NEW TABLE
| Table Name | Description |
|---|---|
| rds | Document Data Definition SQL |
rdx Document
NEW TABLE
| Table Name | Description |
|---|---|
| rdx | Document |
rhf Historical Lease for Accrual/Billing Cycle Change/Reversal
NEW TABLE
| Table Name | Description |
|---|---|
| rhf | Historical Lease for Accrual/Billing Cycle Change/Reversal |
rhfa Historical Lease 2 for Accrual/Billing Cycle Change/Reversal
NEW TABLE
| Table Name | Description |
|---|---|
| rhfa | Historical Lease 2 for Accrual/Billing Cycle Change/Reversal |
rhfb Historical Lease 3 for Accrual/Billing Cycle Change/Reversal
NEW TABLE
| Table Name | Description |
|---|---|
| rhfb | Historical Lease 3 for Accrual/Billing Cycle Change/Reversal |
| Column Name | Description | Oracle Datatype | Oracle Allow Null | Sybase Datatype | Sybase Allow Null | Initial Value |
|---|---|---|---|---|---|---|
| est_prop_tax_processed_c | Estimated property tax processed (Y/N) | CHAR(1) | yes | char(1) | yes | 'N' |
| d_org_com_s | Lease original commencement date Commencement date specified at most recent extension, or at booking if there are no extensions. Note that calculations are not based on rlsb.d_org_com_s. Instead, they are based on rls.d_com_s. |
DATE | yes | datetime | yes | NULL |
| cycle_changes_l | Number of accrual/billing cycle changes rlsb.cycle_changes_l is set to zero at booking and whenever an extension occurs. It is incremented by 1 whenever an accrual/billing cycle change occurs. |
NUMBER(10) | yes | integer | yes | 0 |
rhfc Historical Lease Partial Deduction for Accrual/Billing Cycle Change/Reversal
NEW TABLE
| Table Name | Description |
|---|---|
| rhfc | Historical Lease Partial Deduction for Accrual/Billing Cycle Change/Reversal |
rhfd Historical Lease 4 for Accrual/Billing Cycle Change/Reversal
NEW TABLE
| Table Name | Description |
|---|---|
| rhfd | Historical Lease 4 for Accrual/Billing Cycle Change/Reversal |
rhfp Historical Lease Payment Schedule for Accrual/Billing Cycle Change/Reversal
NEW TABLE
| Table Name | Description |
|---|---|
| rhfp | Historical Lease Payment Schedule for Accrual/Billing Cycle Change/Reversal |
rhfr Historical Lease Recurring Charge for Accrual/Billing Cycle Change/Reversal
NEW TABLE
| Table Name | Description |
|---|---|
| rhfr | Historical Lease Recurring Charge for Accrual/Billing Cycle Change/Reversal |
rhfs Historical Lease Salesperson for Accrual/Billing Cycle Change/Reversal
NEW TABLE
| Table Name | Description |
|---|---|
| rhfs | Historical Lease Salesperson for Accrual/Billing Cycle Change/Reversal |
rhfv Historical Lease Subvention for Accrual/Billing Cycle Change/Reversal
NEW TABLE
| Table Name | Description |
|---|---|
| rhfv | Historical Lease Subvention for Accrual/Billing Cycle Change/Reversal |
rhsb Historical Lease 3 for Lease Extension/Reversal
| Column Name | Description | Oracle Datatype | Oracle Allow Null | Sybase Datatype | Sybase Allow Null | Initial Value |
|---|---|---|---|---|---|---|
| est_prop_tax_processed_c | Estimated property tax processed (Y/N) | CHAR(1) | yes | char(1) | yes | 'N' |
| d_org_com_s | Lease original commencement date Commencement date specified at most recent extension, or at booking if there are no extensions. Note that calculations are not based on rlsb.d_org_com_s. Instead, they are based on rls.d_com_s. |
DATE | yes | datetime | yes | NULL |
| cycle_changes_l | Number of accrual/billing cycle changes rlsb.cycle_changes_l is set to zero at booking and whenever an extension occurs. It is incremented by 1 whenever an accrual/billing cycle change occurs. |
NUMBER(10) | yes | integer | yes | 0 |
rlsb Lease 3
| Column Name | Description | Oracle Datatype | Oracle Allow Null | Sybase Datatype | Sybase Allow Null | Initial Value |
|---|---|---|---|---|---|---|
| est_prop_tax_processed_c | Estimated property tax processed (Y/N) | CHAR(1) | yes | char(1) | yes | 'N' |
| d_org_com_s | Lease original commencement date Commencement date specified at most recent extension, or at booking if there are no extensions. Note that calculations are not based on rlsb.d_org_com_s. Instead, they are based on rls.d_com_s. |
DATE | yes | datetime | yes | NULL |
| cycle_changes_l | Number of accrual/billing cycle changes rlsb.cycle_changes_l is set to zero at booking and whenever an extension occurs. It is incremented by 1 whenever an accrual/billing cycle change occurs. |
NUMBER(10) | yes | integer | yes | 0 |
roc Power Purchase Agreement Credit Used
| Table Name | Description |
|---|---|
| roc | Power Purchase Agreement Credit Used |
ror Power Purchase Agreement Rate Header
| Table Name | Description |
|---|---|
| ror | Power Purchase Agreement Rate Header |
rora Power Purchase Agreement Rate
| Table Name | Description |
|---|---|
| rora | Power Purchase Agreement Rate |
rot Power Purchase Agreement Transaction
| Table Name | Description |
|---|---|
| rot | Power Purchase Agreement Transaction |
rpay Portfolio 2
| Column Name | Description | Oracle Datatype | Oracle Allow Null | Sybase Datatype | Sybase Allow Null | Initial Value |
|---|---|---|---|---|---|---|
| prorate_depr_c | Prorate depreciation (Y/N) | CHAR(1) | yes | char(1) | yes | NULL |
rsq Sub Asset
| Index Name | Pieces |
|---|---|
| rsq_idx2 | id_s unit_s |
rty Lease Level Transaction
| Table Name | Description |
|---|---|
| rty | Lease Level Transaction |
For the full listing of LeasePak 7.6a database objects, refer to the Database Reference.
Enhancements
545060 Disbursal Cash Accounts During Batch Booking
Build 8877
Requires Batch Applications and Multiple Banks module. Enhancement to allow users to select bank accounts to disburse each type of payment automatically at the time of lease booking instead of using one bank account for all types of disbursement.
- U0101 New Lease→Batch Applications
- U0212 Portfolio→New Lease Customizations
- 218 Batch Applications
- LeasePak Modules → Batch Applications
545162 U0117 Cashier Check Disbursal - Copy LP Check No. To Bank Check Number
Build 8877
Enhancement to allow users to copy LeasePak Check Number to Bank Check Number while processing U0117 Cashier’s Check Disbursal.
547120 Change in RPR - Daily Base Rate - key change
Build 8877
Internal code enhancement. Contact your NETSOL representative for more information.
547121 Changes in Year fields Asset Tables (RAQ, REQ, RHQ, RPS)
Build 8877
Modifies the Asset Year from 2-digit to 4-digits for multiple updates of LeasePak.
- U0101 New Lease→Add Asset
- U0120 Change Asset
- U0801 Application→Application Asset
- R0502 Application Inquiry
- R0905 Lease Inquiry
- 247 FDI Asset Extracts
547123 LeasePak 7.6/8.0 Upgrade - 3DES to AES update
Build 8877
Users will need to follow the Post Conversion Procedures after running the standard 7.6a database conversion UNIX script when they upgrade from 7.5a.
547179 Remove the Davox module from the system
Build 8877
Davox functionality is no longer in use and has been removed from LPC and DocSuite.
547364 Document Attachment Unique Key
Build 8877
Adds a new column unique_s in database table rfa for document attachment unique key.
547379 Add support of mpower authentication modes and port number in LeasePak.INI
Build 8877
Allows a user to define mPower authentication mode in LeasePak .INI file.
547400 Broker record - Add field name and error message code in API response
Build 8877
Adds response message and code for broker record in createApplication methods of following web services:
547401 UDC Client record- Add field name and error message code in API response
Build 8877
Enhancement to existing web service MsiAppExtractor→extractUDC to return error message and code.
- MsiAppExtractor→extractUDC
547404 UD Fields record- Add field name and error message code in API response
Build 8877
Modifies response message of user defined field records to add error message and error codes.
547405 UD Table record- Add field name and error message code in API response
Build 8877
Modifies response message of user defined table records to add error message and error codes.
547590 Portfolio Initialization Phase-1
Build 8877
Internal code enhancement.
Current Release Notes |
Release Notes Archive |
LeasePak Functionality Change Listing
© 2025 NETSOL Technologies. All rights reserved.
The information contained in this document is the sole 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 nor does it have the obligation to update any of the information contained herein; 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.
The information contained in this document is the sole 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 nor does it have the obligation to update any of the information contained herein; 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.