rhs Table: Historical Lease for Lease Extension/Reversal
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference

rhs Table: Historical Lease for Lease Extension/Reversal

Child Tables

Name Description
rhsa Historical Lease 2 for Lease Extension/Reversal
rhsb Historical Lease 3 for Lease Extension/Reversal
rhsc Historical Lease Partial Deduction for Lease Extension/Reversal
rhsd Historical Lease 4 for Lease Extension/Reversal
rhsp Historical Lease Payment Schedule for Lease Extension/Reversal
rhsr Historical Lease Recurring Charge for Lease Extension/Reversal
rhss Historical Lease Salesperson for Lease Extension/Reversal
rhsv Historical Lease Subvention for Lease Extension/Reversal

Indexes

Name Segment 1 Segment 2
rhs_idx0 lse_s ext_num_s


Columns
Name DescriptionDatatype ¿? Allow Null
ext_num_s
Extension
lse_s
Lease
Record modification stamp
por_s
Portfolio
com_s
Company
reg_s
Region
off_s
Office
dlr_s
Vendor
brk_s
Broker
inv_s
Investor
les_s
Lessee number
dles_s
Delinquent lessee
  Note: this field contains the lessee number if the
  lease is delinquent and is blank if the lease is
  not delinquent
d_lsd_s
Lease date
d_com_s
Lease commencement date used for calculations
  rls.d_com_s is set to rlsb.d_org_com_s at booking and
  whenever an extension occurs. It may later be changed
  to another date based on lease adjustments.
d_boo_s
System booking date
d_dis_s
Disbursement date
d_mat_s
Maturity date
d_lup_s
Date of last update
t_lup_s
Time of last update
d_act_s
Activity status date
d_pmt_s
Next payment due date
d_acc_s
Accrued to date
d_pay_s
Last payment date
d_lst_s
Last payment due date
d_reb_s
Last rebook date
d_ass_s
Assumed lease date
d_pxt_s
Payment extension date
d_fxt_s
Date of first payment extension
d_lxt_s
Lease extension date
d_cus1_s
Custom date 1
d_susp_pmt_s
First payment on suspension
d_susp_on_s
Date placed on suspension/non-accrual
d_susp_eff_s
Effective date of suspension/non-accrual
d_eff_s
Effective date of last payment
t_boo_s
System booking time
d_doc_comp_s
Documentation completion date
d_lcus_s
Date custom outstanding last updated
  For use only by collection module
ym_acct_s
Accounting month time stamp (YYYYMM)
  This field contains a portion of ras.next_mth_s
d_expiry_date_s
Expiry date
d_pap_eff_s
PAP effective date
act_s
Activity status
acc_l_s
Accrual method lessor
acc_d_s
Accrual method vendor
acc_i_s
Accrual method investor
dir_s
Lease source
frm_s
Lease form code
del_s
Delinquency watch code
brk_pay_s
Broker payment code
late_s
Late charge assess
ls_typ_s
Lease type code
ext_s
Extension method
c_cus1_s
Custom code 1
c_cus2_s
Custom code 2
c_cus3_s
Custom code 3
po_meth_s
Purchase option billing method
pur_opt_s
Purchase option
pur_opt_owner_s
Purchase option owner
ml_optn_s
Maturing lease termination option
prim_num_s
Prime rate bank number
lat_ind_s
Late charge index
prd_s
Product type code
bus_c
Business/personal (B/P)
opn_c
Type of lease, open or closed (O/C)
due_lst_c
Payment due last accrual (Y/N)
acc_by_c
Re-accrue income for last period (Y/N)
a_pmt_c
Assumed payment (Y/N)
pre_brd_c
Backdated new lease (Y/N)
reb_allow_c
Rebook allowed (Y/N)
lse_ext_c
Lease extended (Y/N)
res_inc_c
Residual income separated (Y/N)
po_bill_c
Purchase option billed (Y/N)
partial_deductions_c
Lease booked using partial deductions module (Y/N)
b_lvl_c
Billing level (C/L/I)
  C - Customer
  L - Lessee
  I - Individual
stmt_c
Statement code (I/C/F/N/' ')
  I - individual invoice format
  C - coupon books
  F - group invoice format
  N - billing method outside of LeasePak
acc_ltch_c
Late charges assessed since last accrual
  A - Accrued, allow assessment of late charges
  L - Late charges assessed, disallow further late charges
  E - Preaccrued, enable assessment of late charges for
      prior period
  D - Preaccrued, disable further late charges for
      prior period
pap_pmt_c
PAP-ACH option (Y/N/1/2/3)
  Y - PAP-ACH is on. Rules are based upon U0212 Current
      Payment Only setting.
  N - PAP-ACH is off.
  1 - PAP-ACH is on. Overrides U0212 Current Payment Only
      setting. Treated as option 'Y' of the U0212 Current
      Payment Only setting.
  2 - PAP-ACH is on. Overrides U0212 Current Payment Only
      setting. Treated as option 'N' of the U0212 Current
      Payment Only setting.
  3 - PAP-ACH is on. Overrides U0212 Current Payment Only
      setting. Treated as option 'O' of the U0212 Current
      Payment Only setting.
auto_charge_c
Automatic charge off (Y/N/D)
  Y - Lease will be automatically charged off after
      delinquent for more than 120 days.
  N - No automatic charge off.
  D - Lease will defer charge off for 1 month.
ext_incm_ca_c
Cash/accrual basis for extension income (C/A)
susp_idc_allowed_c
Suspended IDC accrued allowed (Y/N)
desc_s
General description
s_cus2_s
Custom string 2
trd_desc_s
Trade-in description
ini_mcur_s
Clerk when removed from Matured Lease tracking
cus_s
Customer number
grp_s
Group number
prev_grp_s
Previous lease in group
next_grp_s
Next lease in group
note_s
Note attached to lease
index_pntr_s
Index pointer (Cost of Funds)
disc_invst_s
Investor/investor group of discounted lease
buyout_quote_l
Number of lease buyout quotes
invst_defr_l
Investor settlement deferral days
trm_l
Lease term
est_trm_l
Estimated lease term
pmt_l
Number of payments accrued
n_unt_l
Number of assets on this lease
del1_l
Number of times delinquent [1]
del2_l
Number of times delinquent [2]
del3_l
Number of times delinquent [3]
del4_l
Number of times delinquent [4]
due_l
Payment due day
ass_l
Number of assumptions
ext_l
Number of lease extensions
pmt_ext_l
Number of payment extensions
due_ext_l
Number of payment due date changes
abp_l
Number of accruals to bypass
lat_wav_l
Number of late charge waivers
grc_l
Grace period in days
pmt_prcd_l
Number of payments processed
days_delq_l
Number of days delinquent
  See notes for del_amt_d field
p_con_d
Lessor yield
p_dly_d
Vendor yield
p_inv_yld_d
Investor yield factor
p_fund_d
Cost of funds
p_erly_pay_d
NPV discount rate
p_irr_d
IRR (yield)
p_irr_nr_d
IRR (yield) without residual
bad_debt_d
Bad debt percentage
i_cus1_l
Custom integer 1
i_cus2_l
Custom integer 2
p_rent_d
Lessor rental simple rate
p_byrt_d
Lessor rental rate add-on
p_cntr_d
Contract rental rate add-on
p_rent_i_d
Investor rental simple rate
p_inv_d
Investor rental rate add-on
p_rent_d_d
Vendor rental simple rate
p_part_d
Rate of participation
p_max_d
Maximum interest rate - lease level
p_min_d
Minimum interest rate - lease level
op_bill_adj_d
Operating lease princpal/income adjustment
tot_org_d
Total acquisition cost
tot_other_d
Other charges
sec_d
Security deposit
cap_d
Down payment
up_d
Documentation fee
pro_d
Interim rent
brk_fee_d
Broker fees
idc_d
Total initial direct costs
tot_res_d
Residual amount
  If tot_res_d is entered by the user, the value of p_res_d
  is erased.
res_guar_d
Guaranteed portion of residual
mrk_up_d
Mark up
in_fee_d
In-house fee
prn_d
Accrued principal
rec_d
Contract receivable
prn_rec_d
Principal receivable
rec_ytd_actual_d
Net receipts Y-T-D (actual)
rec_ltd_d
Net receipts L-T-D (actual)
rent_ytd_d
Rental income Y-T-D
oth_ytd_d
Other income Y-T-D
oth_ltd_d
Other income L-T-D
l_in_ytd_d
Lessor income Y-T-D
d_in_ytd_d
Vendor income Y-T-D
i_in_ytd_d
Investor income Y-T-D
l_ue_d
Lessor unearned rental income
l_ue_org_d
Lessor orig unearned rental income
l_in_ptd_d
Lessor rental income accrued P-T-D
l_in_cur_d
Lessor current month rent income
d_ue_d
Vendor current unearned rental income
d_ue_org_d
Vendor original unearned rental
d_in_ptd_d
Vendor rental income accrued P-T-D
d_in_cur_d
Vendor rental income accrued, current month
i_ue_d
Investor unearned rental income
i_ue_org_d
Investor original unearned rental income
i_in_ptd_d
Investor rental income accrued P-T-D
i_in_cur_d
Investor current month rental income
in_mly_d
Monthly rental income
dp_mly_d
Monthly rental depreciation
lat_wav_amt_d
Late charge waiver amount
unrec_in_d
Unrecognized operating income
acl_depr_d
Accumulated depreciation
brk_ap_d
Broker fee accounts payable
stub_amt_d
Amount of stub interest owed (-) or earned (+)
d_pmt_cur_d
Vendor payment receivable, current month
npv_d
NPV of payment stream
tax_paid_d
Titling tax paid up-front
tax_accr_d
Use tax accrued
f_cus1_d
Custom float 1
f_cus2_d
Custom float 2
f_cus3_d
Custom float 3
f_cus4_d
Custom float 4
f_cus5_d
Custom float 5
d_rec_d
Vendor receivable
d_part_ue_d
Vendor payment participation unearned
cur_paid_d
Amount current paid
lst_paid_d
Amount last paid
sch_int_ptd_d
Scheduled interest P-T-D
idc_rem_d
Unamortized IDC - book
idc_cur_d
IDC current month amortization - book
lsd_unit_d
Leased assets
  Starting cost of assets under lease
pmt_acc_d
Payment amount accrued Y-T-D
r_in_ytd_d
Residual income Y-T-D
r_ue_d
Unearned residual
r_ue_org_d
Original unearned residual
r_in_ptd_d
Residual income accrued P-T-D
r_in_cur_d
Residual current month income
susp_l_acc_d
Suspended lessor income accrued
susp_d_acc_d
Suspended vendor income accrued
susp_i_acc_d
Suspended investor income accrued
susp_r_acc_d
Suspended residual income accrued
susp_col_d
Suspended income collected
fp_amt_d
Fixed price purchase
susp_frst_d
First payment suspended earnings
rec_boy_d
Contract receivable (begin of year)
l_ue_boy_d
Lessor unearned income (begin of year)
res_boy_d
Residual (beginning of year)
l_ue_chg_ytd_d
Y-T-D lessor unearned income changes
car_d
Interest carryover
int_unpd_d
Interest unpaid
prn_ytd_d
Principal paid Y-T-D
prn_ltd_d
Principal paid L-T-D
int_pd_ytd_d
Interest paid Y-T-D
int_ltd_d
Interest paid L-T-D
trade_in_d
Trade-in
accrual_amt_to_date_d
Accrual amount to date (COF)
del_amt_d
Total delinquent amount
  Notes:
  1. Used only by the collection module
  2. Calculated only for delinquent leases
  3. Only accurate as of the last time EOP Sequential
     Updates was run with the U1121 Collection switch on
  4. Set to 0 for non-delinquent leases
  5. These notes also apply to the gr_rec_d, net_out_d,
     gr_out_d, and days_delq_l fields
gr_rec_d
Custom gross receivable
  See notes for del_amt_d field
net_out_d
Custom net outstanding
  See notes for del_amt_d field
gr_out_d
Custom gross outstanding
  See notes for del_amt_d field
ml_mile_d
Excess mileage adjustment
ml_wear_d
Wear and tear adjustment
ml_sale_d
Proceeds of sale
ml_book_d
Book value
idc_tax_d
Tax IDC
idc_rem_tax_d
Unamortized IDC - tax
idc_cur_tax_d
IDC current month amortization - tax
idc_ytd_tax_d
IDC Y-T-D amortization - tax
idc_ytd_d
IDC Y-T-D amount - book
l_in_red_ytd_d
Lessor income reduction Y-T-D
r_in_red_ytd_d
Residual income reduction Y-T-D
idc_red_d
IDC reduction
idc_interest_d
IDC interest portion
tot_cap_int_d
Total capitalized interest
p_fund2_d
Cost of funds 2 (For FCT)
auto_ext_l
Number of automatic lease extensions
dfrd_ext_incm_d
Deferred extension income
dfrd_residual_red_d
Deferred residual reduction
susp_idc_acc_d
Suspended IDC accrued
msi_chg_key_c
Change lease key is in progress