LeasePak 6.0b Release Notes
Includes release information through build 6.01.2708
The updated list of LeasePak 6.0b enhancements and discrepancy fixes is now part of the Release Bulletins.
To see all discrepancies fixed for 6.0b MR3, refer to the 6.0b MR3 Release Bulletin.
To see a cumulative list of discrepancies fixed for 6.0b, refer to the latest version of the
6.0b Pre-Release Bulletin.
You can also find a copy of these bulletins in the ReadMe folder.
The Fixed Discrepancies Listing contains an archive listing of dicrepancies fixed in
LeasePak versions prior to 6.0b. For discrepancies fixed in LeasePak 6.0b, refer to the Release Bulletins.
Important Notes
Sybase only: Conversion Error on rpd.batch_num_s
Heat Ticket 525522
This issue pertains only to Sybase users who either: (1) converted their production database using release 6.0b MR2 or prior
(any build prior to 6.01.2699), or (2) converted their production database using release 6.1a GA or prior (any build prior to 6.10.2906).
This issue has been fixed in version 6.0b, build 6.01.2699 and version 6.1a, build 6.10.2906. Users who have not yet upgraded their
production database to 6.0b or 6.1a should use the latest builds to avoid this issue.
If this issue pertains to your conversion, install the appropriate LeasePak build on your server
(for 6.0b users, 6.01.2699 or later; for 6.1a users, 6.10.2906 or later) and run the corrective scripts as described below.
__________
This error and corrective patch pertain to Sybase users only.
As a result of the currently shipped conversions, users upgrading their databases from a pre-v60b release to v60b or later
(e.g., v53a to v60b, or v60a to v61a, etc) and who have any records in the rpd (payoff quote), will show a failure in the
procedure s60blpux_proc3resize.sql relating to rpd.batch_num_s not allowing null values. The result is that a vital modification
of the new rpd.batch_num_s column is not performed. This can lead to further errors in the future and could contribute to system instability.
This patch consists of 4 files modified or created to correct this issue, both for future upgrades such that they will be
performed without this error, and for previously upgraded databases to correct the error and perform the needed operation on rpd.batch_num_s.
Of the 4 files, the first 3 are part of the standard database upgrade procedure, sgenlpux_conversion, and are called when a database
is upgraded through or to v60b:
- $uconv/s60blpux_proc3resize.sql - the previous, error prone handling of rpd.batch_num_s has been removed
- $uconv/s60blpux_proc2rpd.sql - the handling of rpd.batch_num_s has been relocated here
- $uconv/genconcfg - specifies that $uconv/s60blpux_proc2rpd.sql be called during a regular database conversion
The 4th file is to be executed by the database administrator on databases previously upgraded through or to v60b:
- $uconv/s60b_rpd_standalone - corrects the rpd.batch_num_s in previously upgraded databases
All 4 of these files will be present in all future shipments of v60b and v61a. For users who are in receipt of a build containing
this patch prior to upgrading their databases through or to v60b, there are no special instructions; the upgrade process should
complete successfully after a build containing the patch is installed.
For users who are in receipt of a build containing this patch after upgrading their databases through or to v60b, and the upgrade was
performed with a build prior to v60b build 6.01.2699 or v61a build 6.10.2906, the user must install the build containing the patch and
then execute the corrective s60b_rpd_standalone script as follows in each database upgraded prior to the builds stated:
Login as $MSIDBA that pertains to the release in question.
Execute:
$top/env/envname/conv/s60b_rpd_standalone envname [dbo-password]
Where envname is the name of the affected environment. The DBO password will be prompted for if it is omitted from the command line.
The user should see a display such as the following:
> $top/env/prod/conv/s60b_rpd_standalone prod pwdprod
2008-11-23 19:13:02 s60b_rpd_standalone: Correct rpd.batch_num_s in v60b database (prod)lpr_prod
2008-11-23 19:13:02 s60b_rpd_standalone: Running commands as lpr_prod
2008-11-23 19:13:02 s60b_rpd_standalone: Start conversion of (prod)lpr_prod
2008-11-23 19:13:02 s60b_rpd_standalone: Step 1.0: Start
2008-11-23 19:13:02 s60b_rpd_standalone: Step 1.0 (Start) Set compat_id_s in rcg ...
2008-11-23 19:13:02 s60b_rpd_standalone: Step 1.0 (Start) Turn on bulkcopy ...
2008-11-23 19:13:03 s60b_rpd_standalone: Turning on bulkcopy option...
2008-11-23 19:13:03 s60b_rpd_standalone: Step 2.0: Handle column
2008-11-23 19:13:03 s60b_rpd_standalone: Step 2.0 (Handle column) Update batch_num_s ...
2008-11-23 19:13:04 s60b_rpd_standalone: Step 2.0 (Handle column) Modify batch_num_s ...
2008-11-23 19:13:04 s60b_rpd_standalone: Step 3.0: Finish
2008-11-23 19:13:04 s60b_rpd_standalone: Step 3.0 (Finish) Turn off bulkcopy ...
2008-11-23 19:13:05 s60b_rpd_standalone: Bulkcopy option has been turned off.
2008-11-23 19:13:05 s60b_rpd_standalone: Step 3.0 (Finish) Update compat_id_s to 60b.2162c.4 ...
2008-11-23 19:13:05 s60b_rpd_standalone: 3 task groups selected for this procedure
2008-11-23 19:13:05 s60b_rpd_standalone: 6 items attempted in this procedure
2008-11-23 19:13:05 s60b_rpd_standalone: 0 item failures recorded in this procedure
2008-11-23 19:13:06 s60b_rpd_standalone: End
The script is designed to tolerate being run on a database which does not contain the erroneous rpd.batch_num_s, such as one which
converted without error because the rpd table was empty, or one which has already been patched with this procedure.
This issue has been fixed in version 6.0b, build 6.01.2699 and version 6.1a, build 6.10.2906.
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.
No Update from Previous LeasePak 6.0b Installations
You cannot update previous installations of LeasePak 6.0b to the current build. To install the current build of LeasePak 6.0b,
first remove any previous installations of 6.0b, then install the current build as a new installation (and upgrade, if applicable).
If needed, contact your NetSol product support representative for assistance.
Additional Database Size Requirments for Asset Focus Module
Users adding Asset Focus assets or converting assets to Asset Focus will need approximately 3 K additional space
per Asset Focus asset in the LeasePak database. Most of the additional space needed is used by
the LeasePak reqp Asset Payment Schedule and rqr Asset Receivable database tables.
The 3 K average will vary by the complexity of asset payment schedules.
Linux /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.
Oracle Upgrade to Version 6.0b
Oracle users currently on LeasePak versions 4.3a through 5.3a must first upgrade to LeasePak 6.0a before upgrading to version 6.0b.
Refer to the System Administration Guide for more information.
New OS and DBMS Platforms
For most clients, upgrading to LeasePak 6.0a or 6.0b requires upgrading the OS and DBMS software (all platforms).
Refer to the System Administration Guide for more information.
Changes to the C-ISAM structure of the DZZ Audit Extract Table
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 or 6.0b
from a version prior to 6.0a. Contact your NetSol product support representative for more information.
Sybase: Vertex Changes
MSI 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.
MSI 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.
As part of these changes, MSI has dropped the vertex table and the following stored procedures:
mp_vertex_rlo_rnm, mp_vertex_rlo_rnm_upd, mp_vertex_rlo_archv.
Enhancement Summaries
- 510015 Asset Focus Module
-
Provides support for origination, booking, payments, adjustments, end-of-term, accounting, and reporting of asset-level payment
schedules and transactions.
- 514758 Addition of Waiver to Batch Assessments
-
Requires the Batch Assessments module
Provides the addition of assessment waivers to Batch Assessments functionality.
- 516739 Contract End Date for Interest Bearing Loans
-
Allows users to set a contract end date for Interest Bearing Loans, removing the limitation
where previously LeasePak calculated it automatically based on the commencement date.
- 516847 Suspense Enhancement
-
Provides additional LeasePak suspense functionality, including a user-defined suspense type
(through the new LeasePak Custom Code category SUS.UD), follow-up date, and expanded comments field.
- 516986 Booked Application Post Processor Utility
-
Provides a LeasePak Utility to apply dealer payments (principal write down or pay down)
for lease applications of accrual types RAX5, RAXE, AAPR and AOSL.
- 517159 Booking Enhancements
-
Provides a group of enhancements to increase the ease and efficiency of booking applications, including:
- A new report program, Print/View User Reports [R0929], that allows users to view and print reports
residing in their LeasePak server home directories
- A new feature in Application User Profile and Application Status Transfer that allows setting the
application transfer to default to the current user
- A new feature in Application Assets that allows users to add multiple booked assets to a pending application
- A new switch in Custom General [U0712] that disables the automatic recalculation of residual-related asset fields during
the application and booking process
- An addition to the information displayed during Application Book Requirements validation
- 517167 Multiple Holiday Calendars
-
Requires the Commercial Loan module
Enables LeasePak users to define multiple holiday calendars for individual Floating Rate IBLs and commercial loans.
- 517234 Remaining Payments Count on Lease Summary Report
-
Provides the user the facility to view remaining payments for a lease from the Lease Summary [F5] report.
- 517254 Customer Payments without Groups
-
Requires the JULE Fund 1993 module package for Enhanced Payments and the Batch Payments module for batch payment functionality
Allows users to post payments at the customer level through Enhanced Payments or Batch Payments without setting leases up in groups.
This functionality is not available for users with Cash Control.
- 517476 Recurring Charge Payment Schedule
-
Requires the Recurring Charge Payment Schedule module
Separates the process of defining and managing recurring charges through Application Tracking [U08] and
introduces the new RCR Schedule [U0236] update for defining and managing application and lease recurring charges.
- 517581 Addition of Start Date and End Date to Payment Schedules
-
Provides a Start Date and End Date for each payment stream in the Application [U08]: Tab 8,
giving users a date reference for the length of each payment
stream.
- 517636 Enhanced Payments Filter
-
Allows users to enter criteria as to which open accounts receivable records are selected in Payments [U0102]: Enhanced Payments
so that the payment amount is applied to those open accounts receivable records only.
- 520890 Ad Hoc ACH
-
Requires the Electronic A/R (PAP/ACH) module
Separates the Ad Hoc ACH functionality from Miscellaneous Billing Info [U0227]
and places it in a separate financial update, Ad Hoc ACH [U0134].
- 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.
- 523281 Additional Fields for Web Services API (LinkIT)
-
Provide additional supported fields for the LinkIT Web services's MsiAppOriginator and MsiAppExtractor.
Column Resize
| Column Name | Description | Old Value | New Value |
|---|
| acct_balance_d | GL account amount | double/9.2[0:300] | double/9.2[0:350] |
ral Lessee
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| tot_asm1_b_d | Total client assessment 1 billed | double/8.2 | 0 |
| tot_asm1_p_d | Total client assessment 1 paid | double/8.2 | 0 |
| tot_asm2_b_d | Total client assessment 2 billed | double/8.2 | 0 |
| tot_asm2_p_d | Total client assessment 2 paid | double/8.2 | 0 |
| tot_asm3_b_d | Total client assessment 3 billed | double/8.2 | 0 |
| tot_asm3_p_d | Total client assessment 3 paid | double/8.2 | 0 |
| due_l | Due day | integer | 0 |
rapa Application 2
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| dlr_pmt_bank_code_s | Dealer payment bank code | char/4 | NULL |
| d_cntr_end_s | Contract end date | date | NULL |
| dlr_pmt_applied_c | Dealer payments applied (Y/N) | switch | 'N' |
| rcr_pmt_sched_c | Has recurring charge payment schedule (Y/N) | switch | 'N' |
| rcr_synch_c | Recurring charge payment schedule in synch with lease (Y/N) | switch | 'N' |
| asset_lvl_c | Has asset level payment schedule (Y/N) | switch | 'N' |
| assmt_desc_c | Has assessment description (Y/N) | switch | 'N' |
| p_unused_fee_d | Unused drawdown fee rate | percent/2.5 | 0 |
| unused_fee_thresh_d | Unused drawdown fee threshold | double/8.2 | 0 |
| d_unused_fee_start_s | Start date of unused drawdown fee assessment | date | NULL |
| d_unused_fee_next_s | Next date of unused drawdown fee assessment | date | NULL |
| unused_fee_frq_s | Unused drawdown fee frequency (NONE/DAY/MON/QTR/SEMI/ANNL) | char/4 | 'NONE' |
raq Application Asset
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| rec_d | Contract receivable | double/8.2 | 0 |
| idc_d | Total initial direct cost | double/8.2 | 0 |
| idc_rem_d | Unamortzed IDC - book | double/8.2 | 0 |
| idc1_ins_prem_ue_d | Insurance premium unearned IDC1 | double/8.2 | 0 |
| idc1_ins_prem_susp_d | Insurance premium suspended IDC1 | double/8.2 | 0 |
| idc2_notary_fee_d | Notary fee IDC2 | double/8.2 | 0 |
| idc2_notary_fee_ue_d | Notary fee unearned IDC2 | double/8.2 | 0 |
| idc2_notary_fee_susp_d | Notary fee suspended IDC2 | double/8.2 | 0 |
| idr1_ins_fee_d | Insurance fee IDR1 | double/8.2 | 0 |
| idr1_ins_fee_ue_d | Insurance fee unearned IDR1 | double/8.2 | 0 |
| idr1_ins_fee_susp_d | Insurance fee suspended IDR1 | double/8.2 | 0 |
| idr2_reg_fee_d | Registration fee IDR2 | double/8.2 | 0 |
| idr2_reg_fee_ue_d | Registration fee unearned IDR2 | double/8.2 | 0 |
| idr2_reg_fee_susp_d | Registration fee suspended IDR2 | double/8.2 | 0 |
| idr3_dlr_subsidy_d | Dealer subsidy IDR3 | double/8.2 | 0 |
| idr3_dlr_subsidy_ue_d | Dealer subsidy unearned IDR3 | double/8.2 | 0 |
| idr3_dlr_subsidy_susp_d | Dealer subsidy suspended IDR3 | double/8.2 | 0 |
| idr4_open_comm_d | Opening commission IDR4 | double/8.2 | 0 |
| idr4_open_comm_ue_d | Opening commission unearned IDR4 | double/8.2 | 0 |
| idr4_open_comm_susp_d | Opening commission suspended IDR4 | double/8.2 | 0 |
| sec_d | Security deposit | double/8.2 | 0 |
| l_ue_d | Lessor unearned rental income | double/8.2 | 0 |
| l_ue_org_d | Lessor orig unearned rental income | double/8.2 | 0 |
| l_in_ptd_d | Lessor rental income accrued P-T-D | double/8.2 | 0 |
| l_in_cur_d | Lessor current month rental income | double/8.2 | 0 |
| susp_l_acc_d | Suspended lessor income accrued | double/8.2 | 0 |
| prn_d | Accrued principal | double/8.2 | 0 |
| dp_mly_d | Monthly rental depreciation | double/8.2 | 0 |
| unrec_in_d | Unrecognized operating income | double/8.2 | 0 |
raqp Application Asset Payment Schedule
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| raqp | Application Asset Payment Schedule | 1-360 per participating raq |
Index Add
| Index Name | Pieces | Description |
|---|
| raqp_idx0 | unit_s,unique_l | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| unit_s | Asset number | char/10 | |
| unique_l | Record number | integer | |
| timestamp | Optimistic locking | timestamp | |
| pmt_frq_l | Number of payments at frequency | integer | |
| pmt_amnt_d | Asset payment amount | double/8.2 | |
| pmt_cd_s | Payment frequency code | char/4 | |
rar Accounts Receivable
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| d_prin_bill_s | Date principal billed | date | NULL |
| d_int_bill_s | Date interest billed | date | NULL |
rarb Accounts Receivable Assessment
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| d_assmt_bill_s | Date assessment billed | date | NULL |
rax Automatic Lease Extension
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| rcr_pmt_sched_c | Has recurring charge payment schedule (Y/N) | switch | 'N' |
| rcr_synch_c | Recurring charge payment schedule in synch with lease (Y/N) | switch | 'N' |
rbs Batch Assessment
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| assmt_desc_s | Assessment description | char/100 | NULL |
rcb Client Billing Receivable
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rcb | Client Billing Receivable | |
Index Add
| Index Name | Pieces | Description |
|---|
| rcb_idx0 | por_s,com_s,reg_s,off_s, client_id_s, client_rel_s, d_pmtdu_s | Clustered, Unique, No changes |
| rcb_idx1 | invo_s | Unique,No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| por_s | Portfolio | char/2 | |
| com_s | Company | char/2 | |
| reg_s | Region | char/2 | |
| off_s | Office | char/3 | |
| client_id_s | Client number | char/9 | |
| client_rel_s | Client relation | char/4 | |
| d_pmtdu_s | Payment due date | char/6 | |
| invo_s | Invoice number | char/8 | |
| timestamp | Optimistic locking | timestamp | |
| bank_s | Bank number | char/3 | |
| tamt_b_d | Total assessment billed | double/8.2 | |
| tamt_p_d | Total assessment paid | double/8.2 | |
rcba Client Billing Receivable Assessment
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rcba | Client Billing Receivable Assessment | 1-3 per rcb |
Index Add
| Index Name | Pieces | Description |
|---|
| rcba_idx0 | invo_s, unique_l | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| invo_s | Invoice number | char/8 | |
| unique_l | Unique number | integer | |
| timestamp | Optimistic locking | timestamp | |
| a_typ_s | Assessment type | char/4 | |
| aamt_b_d | Assessment billed | double/8.2 | |
| aamt_p_d | Assessment paid | double/8.2 | |
rcg Custom General
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| dup_adj_chars_in_pwd_c | Allow duplicate adjacent characters in password (Y/N) | switch | 'Y' |
| run_cstm_before_eop_c | Run custom program before EOP Suite processing (Y/N) | switch | 'N' |
| run_cstm_after_eop_c | Run custom program after EOP Suite processing (Y/N) | switch | 'N' |
rdr Deferral Reversal
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| d_cntr_end_s | Contract end date | date | NULL |
reo End of Period Order
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| run_cstm_before_c | Run custom program before Portfolio processing (Y/N) | switch | 'N' |
| run_cstm_after_c | Run custom program after Portfolio processing (Y/N) | switch | 'N' |
Column Change
| Column Name | Change Type | New Value |
|---|
| launch_c | Field description | Launch status (L/S/P/C/F): L - the portfolio is to be launched; S - the portfolio is to be skipped; P - the portfolio is being launched; C - the portfolio has launched successfully; F - the portfolio has failed to launch |
| interval_l | Field description | Seconds between each check by monitoring facility |
| job_stat_s | Field description | EOP job status reported by monitoring facility |
reqa Asset 2
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| idc_d | Total initial direct cost | double/8.2 | 0 |
| idc_cur_d | IDC current month amortization - book | double/8.2 | 0 |
| idc_rem_d | Unamortzed IDC - book | double/8.2 | 0 |
| susp_idc_acc_d | Suspended IDC accrued | double/8.2 | 0 |
| idc1_ins_prem_ue_d | Insurance premium unearned IDC1 | double/8.2 | 0 |
| idc1_ins_prem_susp_d | Insurance premium suspended IDC1 | double/8.2 | 0 |
| idc1_ins_prem_cur_d | Insurance premium current IDC1 | double/8.2 | 0 |
| idc1_ins_prem_ytd_d | Insurance premium year-to-date IDC1 | double/8.2 | 0 |
| idc2_notary_fee_d | Notary fee IDC2 | double/8.2 | 0 |
| idc2_notary_fee_ue_d | Notary fee unearned IDC2 | double/8.2 | 0 |
| idc2_notary_fee_susp_d | Notary fee suspended IDC2 | double/8.2 | 0 |
| idc2_notary_fee_cur_d | Notary fee current IDC2 | double/8.2 | 0 |
| idc2_notary_fee_ytd_d | Notary fee year-to-date IDC2 | double/8.2 | 0 |
| idr1_ins_fee_d | Insurance fee IDR1 | double/8.2 | 0 |
| idr1_ins_fee_ue_d | Insurance fee unearned IDR1 | double/8.2 | 0 |
| idr1_ins_fee_susp_d | Insurance fee suspended IDR1 | double/8.2 | 0 |
| idr1_ins_fee_cur_d | Insurance fee current IDR1 | double/8.2 | 0 |
| idr1_ins_fee_ytd_d | Insurance fee year-to-date IDR1 | double/8.2 | 0 |
| idr2_reg_fee_d | Registration fee IDR2 | double/8.2 | 0 |
| idr2_reg_fee_ue_d | Registration fee unearned IDR2 | double/8.2 | 0 |
| idr2_reg_fee_susp_d | Registration fee suspended IDR2 | double/8.2 | 0 |
| idr2_reg_fee_cur_d | Registration fee current IDR2 | double/8.2 | 0 |
| idr2_reg_fee_ytd_d | Registration fee year-to-date IDR2 | double/8.2 | 0 |
| idr3_dlr_subsidy_d | Dealer subsidy IDR3 | double/8.2 | 0 |
| idr3_dlr_subsidy_ue_d | Dealer subsidy unearned IDR3 | double/8.2 | 0 |
| idr3_dlr_subsidy_susp_d | Dealer subsidy suspended IDR3 | double/8.2 | 0 |
| idr3_dlr_subsidy_cur_d | Dealer subsidy current IDR3 | double/8.2 | 0 |
| idr3_dlr_subsidy_ytd_d | Dealer subsidy year-to-date IDR3 | double/8.2 | 0 |
| idr4_open_comm_d | Opening commission IDR4 | double/8.2 | 0 |
| idr4_open_comm_ue_d | Opening commission unearned IDR4 | double/8.2 | 0 |
| idr4_open_comm_susp_d | Opening commission suspended IDR4 | double/8.2 | 0 |
| idr4_open_comm_cur_d | Open commission current IDR4 | double/8.2 | 0 |
| idr4_open_comm_ytd_d | Open commission year-to-date IDR4 | double/8.2 | 0 |
| sec_d | Security deposit | double/8.2 | 0 |
| susp_l_acc_d | Suspended lessor income accrued | double/8.2 | 0 |
| l_in_ptd_d | Lessor rental income accrued P-T-D | double/8.2 | 0 |
| l_in_cur_d | Lessor current month rental income | double/8.2 | 0 |
| dp_mly_d | Monthly rental depreciation | double/8.2 | 0 |
| unrec_in_d | Unrecognized operating income | double/8.2 | 0 |
| dfrd_residual_red_d | Deferred residual reduction | double/8.2 | 0 |
| op_bill_adj_d | Operating lease principal/income adkustment | double/8.2 | 0 |
reqp Asset Payment Schedule
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| reqp | Asset Payment Schedule | 1-360 per participating req |
Index Add
| Index Name | Pieces | Description |
|---|
| reqp_idx0 | unit_s,unique_l | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| unit_s | Asset number | char/10 | |
| unique_l | Record number | integer | |
| timestamp | Optimistic locking | timestamp | |
| pmt_frq_l | Number of payments at frequency | integer | |
| pmt_amnt_d | Asset payment amount | double/8.2 | |
| pmt_cd_s | Payment frequency code | char/4 | |
rgl General Ledger
Column Resize
| Column Name | Description | Old Value | New Value |
|---|
| account | GL structure | double/9.2[0:300] | double/9.2[0:350] |
rhb Historical Client Billing Receivable
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rhb | Historical Client Billing Receivable | |
Index Add
| Index Name | Pieces | Description |
|---|
| rhb_idx0 | por_s,com_s,reg_s,off_s,client_id_s, client_rel_s, d_pmtdu_s | Clustered, Unique, No changes |
| rhb_idx1 | invo_s | Unique,No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| por_s | Portfolio | char/2 | |
| com_s | Company | char/2 | |
| reg_s | Region | char/2 | |
| off_s | Office | char/3 | |
| client_id_s | Client number | char/9 | |
| client_rel_s | Client relation | char/4 | |
| d_pmtdu_s | Payment due date | char/6 | |
| invo_s | Invoice number | char/8 | |
| timestamp | Optimistic locking | timestamp | |
| bank_s | Bank number | char/3 | |
| tamt_b_d | Total assessment billed | double/8.2 | |
| tamt_p_d | Total assessment paid | double/8.2 | |
rhba Historical Client Billing Receivable Assessment
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rhba | Historical Client Billing Receivable Assesssment | 1-3 per rhb |
Index Add
| Index Name | Pieces | Description |
|---|
| rhba_idx0 | invo_s, unique_l | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| invo_s | Invoice number | char/8 | |
| unique_l | Unique number | integer | |
| timestamp | Optimistic locking | timestamp | |
| a_typ_s | Assessment type | char/4 | |
| aamt_b_d | Assessment billed | double/8.2 | |
| aamt_p_d | Assessment paid | double/8.2 | |
rhc Historical Recurring Charge Payment Schedule Header
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rhc | Historical Recurring Charge Payment Schedule Header | 1 per participating rhs |
Index Add
| Index Name | Pieces | Description |
|---|
| rhc_idx0 | lse_s, ext_num_s, rcr_s | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| lse_s | Lease number | char/10 | |
| ext_num_s | Extension Number | char/2 | |
| rcr_s | RCR type | char/4 | |
| timestamp | Optimistic locking | timestamp | |
| rcr_synch_c | Recurring charge payment schedule in synch with lease (Y/N) | switch | |
rhcp Historical Recurring Charge Payment Schedule
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rhcp | Historical Recurring Charge Payment Schedule | 1-360 per rhc |
Index Add
| Index Name | Pieces | Description |
|---|
| rhcp_idx0 | lse_s, ext_num_s, rcr_s, unique_l | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| lse_s | Lease number | char/10 | |
| ext_num_s | Extension Number | char/2 | |
| rcr_s | RCR type | char/4 | |
| unique_l | Record number | integer | |
| timestamp | Optimistic locking | timestamp | |
| pmt_frq_l | Number of payments at frequency | integer[1:360] | |
| pmt_amt_d | Recurring charge payment amount | double/8.2[1:360] | |
| pmt_cd_s | Payment frequency code | char/4[1:360] | |
rhqp Historical Asset Payment Schedule
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rhqp | Historical Asset Payment Schedule | 1-360 per participating rhq |
Index Add
| Index Name | Pieces | Description |
|---|
| rhqp_idx0 | lse_s,ext_num_s, unit_s,unique_l | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| lse_s | Lease | char/10 | |
| ext_num_s | Extension number | char/2 | |
| unit_s | Asset | char/10 | |
| unique_l | Record number | integer | |
| timestamp | Optimistic locking | timestamp | |
| pmt_frq_l | Number of payments at frequency | integer | |
| pmt_amt_d | Asset payment amount | double/8.2 | |
| pmt_cd_s | Payment frequency code | char/4 | |
ria Invoice Assessment Description
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| ria | Invoice Assessment Description | |
Index Add
| Index Name | Pieces | Description |
|---|
| ria_idx0 | app_lse_s,a_typ_s,invo_s,unit_s | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| app_lse_s | Application/lease number | char/10 | |
| a_typ_s | Assessment/recurring charge type | char/4 | |
| invo_s | Invoice number | char/8 | |
| unit_s | Asset number | char/10 | |
| timestamp | Optimistic locking | timestamp | |
| assmt_desc_s | Assessment description | char/100 | |
rlsb Lease 3
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| orig_dlr_rec_pmt_d | Original dealer-received payments | double/8.2 | 0 |
| dlr_pmt_batch_num_s | Dealer payments batch number | char/20 | NULL |
| d_cntr_end_s | Contract end date | date | NULL |
| rcr_pmt_sched_c | Has recurring charge payment schedule (Y/N) | switch | 'N' |
| rcr_synch_c | Recurring charge payment schedule in synch with lease (Y/N) | switch | 'N' |
| asset_lvl_c | Has asset level payment schedule (Y/N) | switch | 'N' |
| assmt_desc_c | Has assessment description (Y/N) | switch | 'N' |
rpay Portfolio 2
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| client_asm_name1_s | Client assessment name 1 | char/20 | 'CLIENT ASSESSMENT 1' |
| client_asm_name2_s | Client assessment name 2 | char/20 | 'CLIENT ASSESSMENT 2' |
| client_asm_name3_s | Client assessment name 3 | char/20 | 'CLIENT ASSESSMENT 3' |
| invo_unit_detl_c | Invoice asset detail (N/P/T): N - None; P - Prorate; T - Top Down | switch | 'N' |
rpd Payoff Quote
Index Replace
| Index Name | Pieces | Description |
|---|
| rpd_idx0 | lse_s, d_quote_s, t_quote_s, batch_num_s, unit_s | Clustered, Unique, No changes |
| rpd_idx1 | unit_s, batch_num_s | Clustered, Unique, No changes |
Index Add
| Index Name | Pieces | Description |
|---|
| rpd_idx2 | batch_num_s,unit_s.lse_s,d_run_s,t_run_s | Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| batch_num_s | Batch number | char/6 Not Null | ' ' |
| payoff_lvl_c | Payoff quote level (L/A): L - Lease; A - Asset | switch | 'L' |
rpu Payment Reschedule Reversal Asset
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| bank_s | Bank account G/L vector | char/3 | NULL |
| sec_cash_c | Security deposit cash received (Y/N) | switch | 'N' |
| p_con_d | Yield | percent/2.7 | 0 |
| chg_prin_d | Change in principal amount | double/8.2 | 0 |
| chg_res_d | Change in residual amount | double/8.2 | 0 |
| chg_res_ue_d | Change in residual unearned amount | double/8.2 | 0 |
| chg_ue_d | Change in unearned Amount | double/8.2 | 0 |
| dp_mly_d | Monthly rental depreciation | double/8.2 | 0 |
| l_est_ue_d | Estimated unearned | double/8.2 | 0 |
| org_idc_d | Original IDC amount | double/8.2 | 0 |
| org_sec_d | Original security deposit | double/8.2 | 0 |
| pay_down_d | Pay down amount | double/8.2 | 0 |
| rec_d | Contract receivable | double/8.2 | 0 |
| res_d | Residual amount | double/8.2 | 0 |
| res_guar_d | Guaranteed portion of residual | double/8.2 | 0 |
| res_write_down_loss_d | Residual write down loss | double/8.2 | 0 |
rpup Payment Reschedule Reversal Asset Payment Schedule
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rpup | Payment Reschedule Reversal Asset Payment Schedule | 1-360 per participating rpu |
Index Add
| Index Name | Pieces | Description |
|---|
| rpup_idx0 | lse_s,pmt_rsc_rsc_s, unit_s,unique_l | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| lse_s | Lease | char/10 | |
| pmt_rsc_rsc_s | Payment reschedule number | char/10 | |
| unit_s | Asset | char/10 | |
| unique_l | Record number | integer | |
| timestamp | Optimistic locking | timestamp | |
| pmt_frq_l | Number of payments at frequency | integer | |
| pmt_amt_d | Asset payment amount | double/8.2 | |
| pmt_cd_s | Payment frequency code | char/4 | |
rqd Asset Payoff/Termination
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rqd | Asset Payoff/Termination | |
Index Add
| Index Name | Pieces | Description |
|---|
| rqd_idx0 | lse_s, d_run_s, t_run_s, batch_num_s, unit_s | Clustered, Unique, No changes |
| rqd_idx1 | unit_s,lse_s, d_run_s, t_run_s, batch_num_s | Unique, No changes |
| rqd_idx2 | batch_num_s,unit_s.lse_s,d_run_s,t_run_s | Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| lse_s | Lease | char/10 | |
| d_run_s | Run date | date | |
| t_run_s | Run time | char/6 | |
| batch_num_s | Batch number | char/6 | |
| unit_s | Asset number | char/10 | |
| timestamp | Optimistic locking | timestamp | |
| p_typ_c | Payoff transaction type (P/T): P - Payoff; T - Termination | char/1 | |
| eqt_s | Equipment activity status | char/4 | |
| opr_s | Operator initials | char/3 | |
| sec_status_c | Security deposit disbursal status (P/U/N): P - processed; U - unprocessed; N - n/a | switch | |
| trn_s | Transaction code | char/4 | |
| d_rev_s | Date of transaction reversal | date | |
| add_d | Additional charges | double/8.2 | |
| allow_d | Allowance for bad debt | double/8.2 | |
| asm_pay_d | Assessments outstanding of payoff | double/8.2 | |
| base_d | Base payoff amount | double/8.2 | |
| payoff_chk_d | Payoff check amount | double/8.2 | |
| fee_d | Fee/penalty | double/8.2 | |
| fmv_d | FMV quote | double/8.2 | |
| gnls_d | Gain/loss on termination | double/8.2 | |
| pmt_amt_d | Asset payment amount | double/8.2 | |
| pmt_pay_d | Payments outstanding of payoff | double/8.2 | |
| refund_d | Refund check amount | double/8.2 | |
| res_d | Residual amount | double/8.2 | |
| sec_d | Secuity deposit amount | double/8.2 | |
| total_rec_d | Total amount received | double/8.2 | |
| valuat_res_d | Valuation reserve | double/8.2 | |
rqdp Asset Payoff/Termination Payment Schedule
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rqdp | Asset Payoff/Termination Payment Schedule | |
Index Add
| Index Name | Pieces | Description |
|---|
| rqdp_idx0 | lse_s, d_run_s, t_run_s, batch_num_s, unit_s, unique_l | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| lse_s | Lease | char/10 | |
| d_run_s | Run date | date | |
| t_run_s | Run time | char/6 | |
| batch_num_s | Batch number | char/6 | |
| unit_s | Asset | char/10 | |
| unique_l | Record number | integer | |
| timestamp | Optimistic locking | timestamp | |
| pmt_frq_l | Number of payments at frequency | integer | |
| pmt_amt_d | Asset payment amount | double/8.2 | |
| pmt_cd_s | Payment frequency code | char/4 | |
rqr Asset Receivable
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rqr | Asset Receivable | |
Index Add
| Index Name | Pieces | Description |
|---|
| rqr_idx0 | invo_s, a_typ_s, unit_s | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| invo_s | Invoice number | char/8 | |
| a_typ_s | Assessment type | char/4 | |
| unit_s | Asset | char/10 | |
| timestamp | Optimistic locking | timestamp | |
| tamt_b_d | Total amount billed | double/8.2 | |
| sales_tax_d | Sales tax amount | double/8.2 | |
| outs_invo_at_payoff_d | Outstanding invoice amounts at payoff | double/8.2 | |
rqx Asset Transaction
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rqx | Asset Transaction | |
Index Add
| Index Name | Pieces | Description |
|---|
| rqx_idx0 | por_s,com_s,reg_s,off_s,lse_s,unit_s,d_run_s,t_run_s, trn_count_s | Clustered, Unique, No changes |
| rqx_idx1 | unit_s,d_run_s,t_run_s, trn_count_s | Unique, no changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| por_s | Portfolio | char/2 | |
| com_s | Company | char/2 | |
| reg_s | Region | char/2 | |
| off_s | Office | char/3 | |
| lse_s | Lease | char/10 | |
| unit_s | Asset | char/10 | |
| d_run_s | Run date | date | |
| t_run_s | Run time | char/6 | |
| trn_count_s | Transaction counter | char/2 | |
| timestamp | Optimistic locking | timestamp | |
| invo_s | Invoice number | char/8 | |
| bank_s | Bank account G/L vector | char/3 | |
| opr_s | Operator initials | char/3 | |
| d_eff_s | Effective date | date | |
| d_indu_s | Invoice due date | date | |
| chk_s | Check number | char/10 | |
| trn_s | Transaction code | char/4 | |
| crdt_l | Account credit vector | integer | |
| dbt_l | Account debit vector | integer | |
| chg_d | Amount of money change | double/8.2 | |
rrc Recurring Charge Payment Schedule Header
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rrc | Recurring Charge Payment Schedule Header | 1 per participating rls |
Index Add
| Index Name | Pieces | Description |
|---|
| rrc_idx0 | lse_s, rcr_s | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| lse_s | Lease number | char/10 |
| rcr_s | RCR type | char/4 |
| timestamp | Optimistic locking | timestamp |
| rcr_synch_c | Recurring charge payment schedule in synch with lease (Y/N) | switch |
| ext_l | Extension Number | integer |
rrcp Recurring Charge Payment Schedule
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rrcp | Recurring Charge Payment Schedule | 1-360 per rrc |
Index Add
| Index Name | Pieces | Description |
|---|
| rrcp_idx0 | lse_s, rcr_s,unique_l | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| lse_s | Lease number | char/10 | |
| rcr_s | RCR type | char/4 | |
| unique_l | Record number | integer | |
| timestamp | Optimistic locking | timestamp | |
| pmt_frq_l | Number of payments at frequency | integer[1:360] | |
| pmt_amt_d | Recurring charge payment amount | double/8.2[1:360] | |
| pmt_cd_s | Payment frequency code | char/4[1:360] | |
rrr Reschedule Reversal
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| d_cntr_end_s | Contract end date | date | NULL |
rsc Operator Security
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| assmt_desc_chg_c | Allow assessment description change (Y/N) | switch | 'N' |
rsr Suspense Reversal
Column Resize
| Column Name | Description | Old Value | New Value |
|---|
| sus_comments_s | Suspense comments | char/36 | char/100 |
rsu Suspense
Column Resize
| Column Name | Description | Old Value | New Value |
|---|
| sus_comments_s | Suspense comments | char/36 | char/100 |
rtb Client Billing Transaction
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rtb | Client Billing Transaction | |
Index Add
| Index Name | Pieces | Description |
|---|
| rtb_idx0 | por_s,com_s,reg_s,off_s,client_id_s, d_run_s, t_run_s, trn_count_s | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| por_s | Portfolio | char/2 | |
| com_s | Company | char/2 | |
| reg_s | Region | char/2 | |
| off_s | Office | char/3 | |
| client_id_s | Client number | char/9 | |
| d_run_s | Run date | char/6 | |
| t_run_s | Run time | char/6 | |
| trn_count_s | Transaction counter | char/2 | |
| timestamp | Optimistic locking | timestamp | |
| client_rel_s | Client relation | char/3 | |
| invo_s | Invoice number | char/8 | |
| bank_s | Bank number | char/3 | |
| opr_s | Operator initials | char/3 | |
| d_eff_s | Effective date | char/6 | |
| d_indu_s | Invoice due date | char/6 | |
| chk_s | Check number | char/10 | |
| trn_s | Transaction code | char/4 | |
| crdt_l | Account credit vector | integer | |
| dbt_l | Account debit vector | integer | |
| chg_d | Amount of money change | double/8.2 | |
rxp EOP Synchronization
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| cstm_before_status_s | Custom before program run status (E/S/P/R/C/F)--the first element is for the EOP before program, the next element is for the portfolio ' 1' before program, etc.: E - the custom program will be executed; S - the custom program will be skipped; P - the custom program is about to be run; R - the custom program is running; C - the custom program has completed successfully; F - the custom program has failed | char/100 | 'N'x100 |
| cstm_after_status_s | Custom after program run status (E/S/P/R/C/F/D)--the first element is for the EOP after program, the next element is for the portfolio ' 1' after program, etc.: E - the custom program will be executed; S - the custom program will be skipped; P - the custom program is about to be run; R - the custom program is running; C - the custom program has completed successfully; F - the custom program has failed; D - the custom program will not be run because the custom before program or portfolio launch failed | char/100 | 'N'x100 |
rxr Auto Lease Extension Recurring Charge Payment Schedule Header
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rxr | Auto Lease Extension Recurring Charge Payment Schedule Header | 1 per participating rax |
Index Add
| Index Name | Pieces | Description |
|---|
| rxr_idx0 | lse_s, ext_num_s, rcr_s | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| lse_s | Lease number | char/10 | |
| ext_num_s | Extension Number | char/2 | |
| rcr_s | RCR type | char/4 | |
| timestamp | Optimistic locking | timestamp | |
| rcr_synch_c | Recurring charge payment schedule in synch with lease (Y/N) | switch | |
rxrp Auto Lease Extension Recurring Charge Payment Schedule
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rxrp | Auto Lease Extension Recurring Charge Payment Schedule | 1-360 per rxr |
Index Add
| Index Name | Pieces | Description |
|---|
| rxrp_idx0 | lse_s, ext_num_s, rcr_s, unique_l | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| lse_s | Lease number | char/10 | |
| ext_num_s | Extension Number | char/2 | |
| rcr_s | RCR type | char/4 | |
| unique_l | Record number | integer | |
| timestamp | Optimistic locking | timestamp | |
| pmt_frq_l | Number of payments at frequency | integer[1:360] | |
| pmt_amt_d | Recurring charge payment amount | double/8.2[1:360] | |
| pmt_cd_s | Payment frequency code | char/4[1:360] | |
rxu Auto Lease Extension Asset
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| pmt_amt_d | Asset payment amount | double/8.2 | 0 |
rxup Auto Lease Extension Asset Payment Schedule
NEW TABLE
Table Add
| Table Name | Description | Notes |
|---|
| rxup | Auto Lease Extension Asset Payment Schedule | 1-360 per participating rxu |
Index Add
| Index Name | Pieces | Description |
|---|
| rxup_idx0 | lse_s,ext_num_s, unit_s,unique_l | Clustered, Unique, No changes |
Column Add
| Column Name | Description | Type Info | Initial Value |
|---|
| lse_s | Lease | char/10 | |
| ext_num_s | Extension number | char/2 | |
| unit_s | Asset | char/10 | |
| unique_l | Record number | integer | |
| timestamp | Optimistic locking | timestamp | |
| pmt_frq_l | Number of payments at frequency | integer[1:360] | |
| pmt_amnt_d | Asset payment amount | double/8.2[1:360] | |
| pmt_cd_s | Payment frequency code | char/4[1:360] | |
rzg General Ledger Name
Column Resize
| Column Name | Description | Old Value | New Value |
|---|
| GL | GL name structure | double/9.2[0:300] | double/9.2[0:350] |
vrpa_client_assmt Client Assessment Name
NEW VIEW
View Add
| View Name | Description | Notes |
|---|
| vrpa_client_assmt | Client Assessment Name | |
View Column Add
| View Column Name | Description |
|---|
| por_s | Portfolio |
| asm_cd_s | Assessment code |
| asm_name_s | Assessment name |
View Select Segments
| rpay.por_s |
| 'AS01' |
| rpay.client_asm_name1_s |
| from rpay |
| UNION ALL | rpay.por_s |
| 'AS02' |
| rpay.client_asm_name2_s |
| from rpay |
| UNION ALL | rpay.por_s |
| 'AS03' |
| rpay.client_asm_name3_s |
| from rpay |
rcc Custom Code
Data Add
| rcc_flg_c | cd_type_s | cd_shrt_s | cd_long_s | security_l |
|---|
| '2' | ' TRN' | '967 ' | 'ASSESS (CLNT BILL) ' | 0 |
| '2' | ' TRN' | '968 ' | 'WAIVE (CLNT BILL) ' | 0 |
| '2' | ' TRN' | '969 ' | 'PMT (CLNT BILL) ' | 0 |
| '2' | ' TRN' | '970 ' | 'PMT REV (CLNT BILL) ' | 0 |
gl General Ledger (combination)
Data Add
| unique_l | number_s | gl_type_c | gl_nam_s |
|---|
| 301 | '1301' | 'C' | 'CLIENT ASMT RECV 01' |
| 302 | '1302' | 'D' | 'CLIENT ASSESSED FEES 01' |
| 303 | '6303' | 'D' | 'CLIENT ASMT INC 01 ' |
| 304 | '1304' | 'C' | 'CLIENT ASMT RECV 02' |
| 305 | '1305' | 'D' | 'CLIENT ASSESSED FEES 02' |
| 306 | '6306' | 'D' | 'CLIENT ASMT INC 02 ' |
| 307 | '1307' | 'C' | 'CLIENT ASMT RECV 03' |
| 308 | '1308' | 'D' | 'CLIENT ASSESSED FEES 03' |
| 309 | '6309' | 'D' | 'CLIENT ASMT INC 03 ' |
rcgx Custom General Field Name 4
Data Change
| Field Number | Value | Field Name |
|---|
| field(365) | CONTRACT END DATE' | 'fld_name37_s[69..85] |
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.