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

Database Reference

rhsa Table: Historical Lease 2 for Lease Extension/Reversal

Parent Table

Name Description
rhs Historical Lease for Lease Extension/Reversal

Indexes

Name Segment 1 Segment 2 Segment 3
rhsa_idx0 lse_s ext_num_s unique_l


Columns
Name DescriptionDatatype ¿? Allow Null
ext_num_s
Extension
lse_s
Lease
unique_l
Record number (value is always 1)
Record modification stamp
lse_nam_s
Lease address name
lse_add_s
Lease address
lse_add2_s
Lease address 2
lse_cty_s
Lease address city
lse_st_s
Lease address state
lse_zip_s
Lease address zip code
bill_nam_s
Billing address name
bill_add_s
Billing address
bill_add2_s
Billing address 2
bill_cty_s
Billing address city
bill_st_s
Billing address state
bill_zip_s
Billing address zip code
d_last_prin_adj_s
Last IBL principal change date
capitalize_interest_c
Capitalize IBL interest (Y/N/' ')
idc1_ins_prem_pay_to_s
Insurance premium payable to IDC1
idc2_notary_fee_pay_to_s
Notary fee payable to IDC2
idc1_ins_prem_d
Insurance premium IDC1
idc1_ins_prem_ue_d
Insurance premium unearned IDC1
idc1_ins_prem_cur_d
Insurance premium current IDC1
idc1_ins_prem_ytd_d
Insurance premium year-to-date IDC1
idc1_ins_prem_susp_d
Insurance premium suspended IDC1
idc1_ins_prem_red_d
Insurance premium reduction IDC1
idc1_ins_prem_ap_d
Insurance premium accounts payable IDC1
idc2_notary_fee_d
Notary fee IDC2
idc2_notary_fee_ue_d
Notary fee unearned IDC2
idc2_notary_fee_cur_d
Notary fee current IDC2
idc2_notary_fee_ytd_d
Notary fee year-to-date IDC2
idc2_notary_fee_susp_d
Notary fee suspended IDC2
idc2_notary_fee_red_d
Notary fee reduction IDC2
idc2_notary_fee_ap_d
Notary fee accounts payable IDC2
idr1_ins_fee_d
Insurance fee IDR1
idr1_ins_fee_ue_d
Insurance fee unearned IDR1
idr1_ins_fee_cur_d
Insurance fee current IDR1
idr1_ins_fee_ytd_d
Insurance fee year-to-date IDR1
idr1_ins_fee_susp_d
Insurance fee suspended IDR1
idr1_ins_fee_red_d
Insurance fee reduction IDR1
idr2_reg_fee_d
Registration fee IDR2
idr2_reg_fee_ue_d
Registration fee unearned IDR2
idr2_reg_fee_cur_d
Registration fee current IDR2
idr2_reg_fee_ytd_d
Registration fee year-to-date IDR2
idr2_reg_fee_susp_d
Registration fee suspended IDR2
idr2_reg_fee_red_d
Registration fee reduction IDR2
idr3_dlr_subsidy_d
Dealer subsidy IDR3
idr3_dlr_subsidy_ue_d
Dealer subsidy unearned IDR3
idr3_dlr_subsidy_cur_d
Dealer subsidy current IDR3
idr3_dlr_subsidy_ytd_d
Dealer subsidy year-to-date IDR3
idr3_dlr_subsidy_susp_d
Dealer subsidy suspended IDR3
idr3_dlr_subsidy_red_d
Dealer subsidy reduction IDR3
idr4_open_comm_d
Open commission IDR4
idr4_open_comm_ue_d
Open commission unearned IDR4
idr4_open_comm_cur_d
Open commission current IDR4
idr4_open_comm_ytd_d
Open commission year-to-date IDR4
idr4_open_comm_susp_d
Open commission suspended IDR4
idr4_open_comm_red_d
Open commission reduction IDR4
adv_inv_days_l
Advanced invoice days
allow_ext_c
Allow lease extension (Y/N)
ibl_pmt_meth_ab_c
IBL payment method (A/B)
d_rcr_esc_pd_s
Date of last escrow disbursal
d_rcr_esc_rc_s
Date of last escrow payment
d_cb_end_prior_s
End date of prior credit bureau reporting period
pmt_hist_s
First half of 24-month payment history profile
  See rxl.pmt_hist_profile_s for description of values
inst_id_s
PAP institution/ACH transit ID
payer_acct_s
PAP account number
ini_icur_s
Clerk when removed from insurance tracking
rcr_esc_mtd_d
Escrow received month-to-date
rcr_esc_ytd_d
Escrow received year-to-date
rcr_esc_ltd_d
Escrow received lease-to-date
rcr_esc_dsb_d
Escrow disbursed lease-to-date
stop_cb_c
Stop credit bureau reporting (Y/N)
securitized_c
Securitize (Y/N)
weight_l
Lease weight
idc_accr_meth_c
IDC accrual method (O/N)
d_last_cur_pmt_s
Last payment date prior to delinquency
ltch_waive_ltd_d
Late charges waived L-T-D
coll_waive_ltd_d
Collection fees waived L-T-D
asmf_waive_ltd_d
Assumption fees waived L-T-D
prtx_waive_ltd_d
Property tax waived L-T-D
legf_waive_ltd_d
Legal fees waived L-T-D
pext_waive_ltd_d
Payment extension fees waived L-T-D
lext_waive_ltd_d
Lease extension fees waived L-T-D
itcf_waive_ltd_d
ITC fees waived L-T-D
fhut_waive_ltd_d
Federal highway use tax waived L-T-D
lsrw_waive_ltd_d
Lease re-write fees waived L-T-D
othf_waive_ltd_d
Other fees waived L-T-D
stax_waive_ltd_d
Sales/Use tax waived L-T-D
rcr_waive_ltd1_d
Recurring charge waived L-T-D [1]
rcr_waive_ltd2_d
Recurring charge waived L-T-D [2]
rcr_waive_ltd3_d
Recurring charge waived L-T-D [3]
rcr_waive_ltd4_d
Recurring charge waived L-T-D [4]
rcr_waive_ltd5_d
Recurring charge waived L-T-D [5]
rcr_waive_ltd6_d
Recurring charge waived L-T-D [6]
rcr_waive_ltd7_d
Recurring charge waived L-T-D [7]
rcr_waive_ltd8_d
Recurring charge waived L-T-D [8]
rcr_waive_ltd9_d
Recurring charge waived L-T-D [9]
rcr_waive_ltd10_d
Recurring charge waived L-T-D [10]
rcr_waive_ltd11_d
Recurring charge waived L-T-D [11]
rcr_waive_ltd12_d
Recurring charge waived L-T-D [12]
rcr_waive_ltd13_d
Recurring charge waived L-T-D [13]
rcr_waive_ltd14_d
Recurring charge waived L-T-D [14]
rcr_waive_ltd15_d
Recurring charge waived L-T-D [15]
pmt_waive_ltd_d
Payment waived L-T-D
prn_waive_ltd_d
Principal waived L-T-D
int_waive_ltd_d
Interest waived L-T-D
idc3_d
Fixed rate reserves IDC3
idc3_ue_d
Unearned IDC3
idc3_cur_d
Current IDC3
idc3_ytd_d
Year to date IDC3
idc3_red_d
Reduction IDC3
idc3_susp_d
Suspended IDC3
idc3_ap_d
Payable amount IDC3
idc4_d
Standard reserves IDC4
idc4_ue_d
Unearned IDC4
idc4_cur_d
Current IDC4
idc4_ytd_d
Year to date IDC4
idc4_red_d
Reduction IDC4
idc4_susp_d
Suspended IDC4
idc4_ap_d
Payable amount IDC4
idc5_d
Guaranteed reserves IDC5
idc5_ue_d
Unearned IDC5
idc5_cur_d
Current IDC5
idc5_ytd_d
Year to date IDC5
idc5_red_d
Reduction IDC5
idc5_susp_d
Suspended IDC5
idc5_ap_d
Payable amount IDC5
idr5_d
Subvention IDR5
idr5_ue_d
Unearned IDR5
idr5_cur_d
Current IDR5
idr5_ytd_d
Year to date IDR5
idr5_red_d
Reduction IDR5
idr5_susp_d
Suspended IDR5
idr6_d
Dealer buy down ID6
idr6_ue_d
Unearned IDR6
idr6_cur_d
Current IDR6
idr6_ytd_d
Year to date IDR6
idr6_red_d
Reduction IDR6
idr6_susp_d
Suspended IDR6
idr7_d
Credit life insurance 1 IDR7
idr7_ue_d
Unearned IDR7
idr7_cur_d
Current IDR7
idr7_ytd_d
Year to date IDR7
idr7_red_d
Reduction IDR7
idr7_susp_d
Suspended IDR7
idr7_save_d
Save unearned IDR7
idr8_d
Credit life insurance 2 IDR8
idr8_ue_d
Unearned IDR8
idr8_cur_d
Current IDR8
idr8_ytd_d
Year to date IDR8
idr8_red_d
Reduction IDR8
idr8_susp_d
Suspended IDR8
idr8_save_d
Save unearned IDR8
idr9_d
Credit disability insurance 1 IDR9
idr9_ue_d
Unearned IDR9
idr9_cur_d
Current IDR9
idr9_ytd_d
Year to date IDR9
idr9_red_d
Reduction IDR9
idr9_susp_d
Suspended IDR9
idr9_save_d
Save unearned IDR9
idra_d
Credit disability insurance 2 IDRA
idra_ue_d
Unearned IDRA
idra_cur_d
Current IDRA
idra_ytd_d
Year to date IDRA
idra_red_d
Reduction IDRA
idra_susp_d
Suspended IDRA
idra_save_d
Save unearned IDRA
idrb_d
Acquisition fee IDRB
idrb_ue_d
Unearned IDRB
idrb_cur_d
Current IDRB
idrb_ytd_d
Year to date IDRB
idrb_red_d
Reduction IDRB
idrb_susp_d
Suspended IDRB
idrc_d
Warranty insurance IDRC
idrc_ue_d
Unearned IDRC
idrc_cur_d
Current IDRC
idrc_ytd_d
Year to date IDRC
idrc_red_d
Reduction IDRC
idrc_susp_d
Suspended IDRC
idrc_save_d
Save unearned IDRC
x_msrp_d
Excess MSRP
x_msrp_s
Excess MSRP bank code
l_est_ue_d
Estimated unearned
inf_dwn_pmt_d
Informational down payment amount
trade_in_make_s
Trade-in make
trade_in_model_s
Trade-in model
trade_in_year_l
Trade-in year
trade_in_gross_allow_d
Trade-in gross allowance
trade_in_outst_debt_d
Trade-in outstanding debt
trade_in_net_allow_d
Trade-in net allowance
trade_in_cash_dwn_d
Trade-in cash down
dwn_pmt_tax_d
Down payment tax
rec_s
Dealer recourse
cred_quality_s
Credit quality
opt_ins_s
Optional insurance
purch_option_fee_d
Purchase option fee
pmt_rsc_l
Number of payment reschedules
pxt_ext_mnts_l
Number of months payment extended
del5_l
Number of times delinquent [5]
del6_l
Number of times delinquent [6]
del7_l
Number of times delinquent [7]
tran_eqty_c
Transfer of equity (Y/N)
can_cr_lif1_c
Cancel credit life insurance 1
can_cr_lif2_c
Cancel credit life insurance 2
can_cr_dis1_c
Cancel credit disability insurance 1
can_cr_dis2_c
Cancel credit disability insurance 2
can_warranty_c
Cancel warranty insurance
acct_type_c
Account type (P/L/I)
  P - Prestige Buyer
  L - Lease
  I - Retail Installment