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

Database Reference Oracle DBMS

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