| Name | Description | 
|---|---|
| rhf | Historical Lease for Accrual/Billing Cycle Change/Reversal | 
| Name | Segment 1 | Segment 2 | Segment 3 | Segment 4 | 
|---|---|---|---|---|
| rhfa_idx0 | lse_s | ext_num_s | cycle_num_s | unique_l | 
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null | 
| ext_num_s | Extension  | 
char(2) | no | 
| cycle_num_s | Accrual/billing cycle change number in a given lease period The first lease period is from book lease to maturity. Each subsequent lease extension (if any) represents a new and separate lease period.  | 
char(2) | no | 
| lse_s | Lease  | 
char(10) | no | 
| unique_l | Record number (value is always 1)  | 
integer | no | 
| timestamp | Record modification stamp  | 
timestamp | yes | 
| lse_nam_s | Lease address name  | 
char(36) | yes | 
| lse_add_s | Lease address  | 
char(36) | yes | 
| lse_add2_s | Lease address 2  | 
char(36) | yes | 
| lse_cty_s | Lease address city  | 
char(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  | 
char(36) | yes | 
| bill_add_s | Billing address  | 
char(36) | yes | 
| bill_add2_s | Billing address 2  | 
char(36) | yes | 
| bill_cty_s | Billing address city  | 
char(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  | 
datetime | 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  | 
double precision | yes | 
| idc1_ins_prem_ue_d | Insurance premium unearned IDC1  | 
double precision | yes | 
| idc1_ins_prem_cur_d | Insurance premium current IDC1  | 
double precision | yes | 
| idc1_ins_prem_ytd_d | Insurance premium year-to-date IDC1  | 
double precision | yes | 
| idc1_ins_prem_susp_d | Insurance premium suspended IDC1  | 
double precision | yes | 
| idc1_ins_prem_red_d | Insurance premium reduction IDC1  | 
double precision | yes | 
| idc1_ins_prem_ap_d | Insurance premium accounts payable IDC1  | 
double precision | yes | 
| idc2_notary_fee_d | Notary fee IDC2  | 
double precision | yes | 
| idc2_notary_fee_ue_d | Notary fee unearned IDC2  | 
double precision | yes | 
| idc2_notary_fee_cur_d | Notary fee current IDC2  | 
double precision | yes | 
| idc2_notary_fee_ytd_d | Notary fee year-to-date IDC2  | 
double precision | yes | 
| idc2_notary_fee_susp_d | Notary fee suspended IDC2  | 
double precision | yes | 
| idc2_notary_fee_red_d | Notary fee reduction IDC2  | 
double precision | yes | 
| idc2_notary_fee_ap_d | Notary fee accounts payable IDC2  | 
double precision | yes | 
| idr1_ins_fee_d | Insurance fee IDR1  | 
double precision | yes | 
| idr1_ins_fee_ue_d | Insurance fee unearned IDR1  | 
double precision | yes | 
| idr1_ins_fee_cur_d | Insurance fee current IDR1  | 
double precision | yes | 
| idr1_ins_fee_ytd_d | Insurance fee year-to-date IDR1  | 
double precision | yes | 
| idr1_ins_fee_susp_d | Insurance fee suspended IDR1  | 
double precision | yes | 
| idr1_ins_fee_red_d | Insurance fee reduction IDR1  | 
double precision | yes | 
| idr2_reg_fee_d | Registration fee IDR2  | 
double precision | yes | 
| idr2_reg_fee_ue_d | Registration fee unearned IDR2  | 
double precision | yes | 
| idr2_reg_fee_cur_d | Registration fee current IDR2  | 
double precision | yes | 
| idr2_reg_fee_ytd_d | Registration fee year-to-date IDR2  | 
double precision | yes | 
| idr2_reg_fee_susp_d | Registration fee suspended IDR2  | 
double precision | yes | 
| idr2_reg_fee_red_d | Registration fee reduction IDR2  | 
double precision | yes | 
| idr3_dlr_subsidy_d | Dealer subsidy IDR3  | 
double precision | yes | 
| idr3_dlr_subsidy_ue_d | Dealer subsidy unearned IDR3  | 
double precision | yes | 
| idr3_dlr_subsidy_cur_d | Dealer subsidy current IDR3  | 
double precision | yes | 
| idr3_dlr_subsidy_ytd_d | Dealer subsidy year-to-date IDR3  | 
double precision | yes | 
| idr3_dlr_subsidy_susp_d | Dealer subsidy suspended IDR3  | 
double precision | yes | 
| idr3_dlr_subsidy_red_d | Dealer subsidy reduction IDR3  | 
double precision | yes | 
| idr4_open_comm_d | Open commission IDR4  | 
double precision | yes | 
| idr4_open_comm_ue_d | Open commission unearned IDR4  | 
double precision | yes | 
| idr4_open_comm_cur_d | Open commission current IDR4  | 
double precision | yes | 
| idr4_open_comm_ytd_d | Open commission year-to-date IDR4  | 
double precision | yes | 
| idr4_open_comm_susp_d | Open commission suspended IDR4  | 
double precision | yes | 
| idr4_open_comm_red_d | Open commission reduction IDR4  | 
double precision | yes | 
| adv_inv_days_l | Advanced invoice days  | 
integer | 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  | 
datetime | yes | 
| d_rcr_esc_rc_s | Date of last escrow payment  | 
datetime | yes | 
| d_cb_end_prior_s | End date of prior credit bureau reporting period  | 
datetime | 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  | 
double precision | yes | 
| rcr_esc_ytd_d | Escrow received year-to-date  | 
double precision | yes | 
| rcr_esc_ltd_d | Escrow received lease-to-date  | 
double precision | yes | 
| rcr_esc_dsb_d | Escrow disbursed lease-to-date  | 
double precision | 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  | 
integer | yes | 
| idc_accr_meth_c | IDC accrual method (O/N)  | 
char(1) | yes | 
| d_last_cur_pmt_s | Last payment date prior to delinquency  | 
datetime | yes | 
| ltch_waive_ltd_d | Late charges waived L-T-D  | 
double precision | yes | 
| coll_waive_ltd_d | Collection fees waived L-T-D  | 
double precision | yes | 
| asmf_waive_ltd_d | Assumption fees waived L-T-D  | 
double precision | yes | 
| prtx_waive_ltd_d | Property tax waived L-T-D  | 
double precision | yes | 
| legf_waive_ltd_d | Legal fees waived L-T-D  | 
double precision | yes | 
| pext_waive_ltd_d | Payment extension fees waived L-T-D  | 
double precision | yes | 
| lext_waive_ltd_d | Lease extension fees waived L-T-D  | 
double precision | yes | 
| itcf_waive_ltd_d | ITC fees waived L-T-D  | 
double precision | yes | 
| fhut_waive_ltd_d | Federal highway use tax waived L-T-D  | 
double precision | yes | 
| lsrw_waive_ltd_d | Lease re-write fees waived L-T-D  | 
double precision | yes | 
| othf_waive_ltd_d | Other fees waived L-T-D  | 
double precision | yes | 
| stax_waive_ltd_d | Sales/Use tax waived L-T-D  | 
double precision | yes | 
| rcr_waive_ltd1_d | Recurring charge waived L-T-D [1]  | 
double precision | yes | 
| rcr_waive_ltd2_d | Recurring charge waived L-T-D [2]  | 
double precision | yes | 
| rcr_waive_ltd3_d | Recurring charge waived L-T-D [3]  | 
double precision | yes | 
| rcr_waive_ltd4_d | Recurring charge waived L-T-D [4]  | 
double precision | yes | 
| rcr_waive_ltd5_d | Recurring charge waived L-T-D [5]  | 
double precision | yes | 
| rcr_waive_ltd6_d | Recurring charge waived L-T-D [6]  | 
double precision | yes | 
| rcr_waive_ltd7_d | Recurring charge waived L-T-D [7]  | 
double precision | yes | 
| rcr_waive_ltd8_d | Recurring charge waived L-T-D [8]  | 
double precision | yes | 
| rcr_waive_ltd9_d | Recurring charge waived L-T-D [9]  | 
double precision | yes | 
| rcr_waive_ltd10_d | Recurring charge waived L-T-D [10]  | 
double precision | yes | 
| rcr_waive_ltd11_d | Recurring charge waived L-T-D [11]  | 
double precision | yes | 
| rcr_waive_ltd12_d | Recurring charge waived L-T-D [12]  | 
double precision | yes | 
| rcr_waive_ltd13_d | Recurring charge waived L-T-D [13]  | 
double precision | yes | 
| rcr_waive_ltd14_d | Recurring charge waived L-T-D [14]  | 
double precision | yes | 
| rcr_waive_ltd15_d | Recurring charge waived L-T-D [15]  | 
double precision | yes | 
| pmt_waive_ltd_d | Payment waived L-T-D  | 
double precision | yes | 
| prn_waive_ltd_d | Principal waived L-T-D  | 
double precision | yes | 
| int_waive_ltd_d | Interest waived L-T-D  | 
double precision | yes | 
| idc3_d | Fixed rate reserves IDC3  | 
double precision | yes | 
| idc3_ue_d | Unearned IDC3  | 
double precision | yes | 
| idc3_cur_d | Current IDC3  | 
double precision | yes | 
| idc3_ytd_d | Year to date IDC3  | 
double precision | yes | 
| idc3_red_d | Reduction IDC3  | 
double precision | yes | 
| idc3_susp_d | Suspended IDC3  | 
double precision | yes | 
| idc3_ap_d | Payable amount IDC3  | 
double precision | yes | 
| idc4_d | Standard reserves IDC4  | 
double precision | yes | 
| idc4_ue_d | Unearned IDC4  | 
double precision | yes | 
| idc4_cur_d | Current IDC4  | 
double precision | yes | 
| idc4_ytd_d | Year to date IDC4  | 
double precision | yes | 
| idc4_red_d | Reduction IDC4  | 
double precision | yes | 
| idc4_susp_d | Suspended IDC4  | 
double precision | yes | 
| idc4_ap_d | Payable amount IDC4  | 
double precision | yes | 
| idc5_d | Guaranteed reserves IDC5  | 
double precision | yes | 
| idc5_ue_d | Unearned IDC5  | 
double precision | yes | 
| idc5_cur_d | Current IDC5  | 
double precision | yes | 
| idc5_ytd_d | Year to date IDC5  | 
double precision | yes | 
| idc5_red_d | Reduction IDC5  | 
double precision | yes | 
| idc5_susp_d | Suspended IDC5  | 
double precision | yes | 
| idc5_ap_d | Payable amount IDC5  | 
double precision | yes | 
| idr5_d | Subvention IDR5  | 
double precision | yes | 
| idr5_ue_d | Unearned IDR5  | 
double precision | yes | 
| idr5_cur_d | Current IDR5  | 
double precision | yes | 
| idr5_ytd_d | Year to date IDR5  | 
double precision | yes | 
| idr5_red_d | Reduction IDR5  | 
double precision | yes | 
| idr5_susp_d | Suspended IDR5  | 
double precision | yes | 
| idr6_d | Dealer buy down ID6  | 
double precision | yes | 
| idr6_ue_d | Unearned IDR6  | 
double precision | yes | 
| idr6_cur_d | Current IDR6  | 
double precision | yes | 
| idr6_ytd_d | Year to date IDR6  | 
double precision | yes | 
| idr6_red_d | Reduction IDR6  | 
double precision | yes | 
| idr6_susp_d | Suspended IDR6  | 
double precision | yes | 
| idr7_d | Credit life insurance 1 IDR7  | 
double precision | yes | 
| idr7_ue_d | Unearned IDR7  | 
double precision | yes | 
| idr7_cur_d | Current IDR7  | 
double precision | yes | 
| idr7_ytd_d | Year to date IDR7  | 
double precision | yes | 
| idr7_red_d | Reduction IDR7  | 
double precision | yes | 
| idr7_susp_d | Suspended IDR7  | 
double precision | yes | 
| idr7_save_d | Save unearned IDR7  | 
double precision | yes | 
| idr8_d | Credit life insurance 2 IDR8  | 
double precision | yes | 
| idr8_ue_d | Unearned IDR8  | 
double precision | yes | 
| idr8_cur_d | Current IDR8  | 
double precision | yes | 
| idr8_ytd_d | Year to date IDR8  | 
double precision | yes | 
| idr8_red_d | Reduction IDR8  | 
double precision | yes | 
| idr8_susp_d | Suspended IDR8  | 
double precision | yes | 
| idr8_save_d | Save unearned IDR8  | 
double precision | yes | 
| idr9_d | Credit disability insurance 1 IDR9  | 
double precision | yes | 
| idr9_ue_d | Unearned IDR9  | 
double precision | yes | 
| idr9_cur_d | Current IDR9  | 
double precision | yes | 
| idr9_ytd_d | Year to date IDR9  | 
double precision | yes | 
| idr9_red_d | Reduction IDR9  | 
double precision | yes | 
| idr9_susp_d | Suspended IDR9  | 
double precision | yes | 
| idr9_save_d | Save unearned IDR9  | 
double precision | yes | 
| idra_d | Credit disability insurance 2 IDRA  | 
double precision | yes | 
| idra_ue_d | Unearned IDRA  | 
double precision | yes | 
| idra_cur_d | Current IDRA  | 
double precision | yes | 
| idra_ytd_d | Year to date IDRA  | 
double precision | yes | 
| idra_red_d | Reduction IDRA  | 
double precision | yes | 
| idra_susp_d | Suspended IDRA  | 
double precision | yes | 
| idra_save_d | Save unearned IDRA  | 
double precision | yes | 
| idrb_d | Acquisition fee IDRB  | 
double precision | yes | 
| idrb_ue_d | Unearned IDRB  | 
double precision | yes | 
| idrb_cur_d | Current IDRB  | 
double precision | yes | 
| idrb_ytd_d | Year to date IDRB  | 
double precision | yes | 
| idrb_red_d | Reduction IDRB  | 
double precision | yes | 
| idrb_susp_d | Suspended IDRB  | 
double precision | yes | 
| idrc_d | Warranty insurance IDRC  | 
double precision | yes | 
| idrc_ue_d | Unearned IDRC  | 
double precision | yes | 
| idrc_cur_d | Current IDRC  | 
double precision | yes | 
| idrc_ytd_d | Year to date IDRC  | 
double precision | yes | 
| idrc_red_d | Reduction IDRC  | 
double precision | yes | 
| idrc_susp_d | Suspended IDRC  | 
double precision | yes | 
| idrc_save_d | Save unearned IDRC  | 
double precision | yes | 
| x_msrp_d | Excess MSRP  | 
double precision | yes | 
| x_msrp_s | Excess MSRP bank code  | 
char(3) | yes | 
| l_est_ue_d | Estimated unearned  | 
double precision | yes | 
| inf_dwn_pmt_d | Informational down payment amount  | 
double precision | 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  | 
integer | yes | 
| trade_in_gross_allow_d | Trade-in gross allowance  | 
double precision | yes | 
| trade_in_outst_debt_d | Trade-in outstanding debt  | 
double precision | yes | 
| trade_in_net_allow_d | Trade-in net allowance  | 
double precision | yes | 
| trade_in_cash_dwn_d | Trade-in cash down  | 
double precision | yes | 
| dwn_pmt_tax_d | Down payment tax  | 
double precision | 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  | 
double precision | yes | 
| pmt_rsc_l | Number of payment reschedules  | 
integer | yes | 
| pxt_ext_mnts_l | Number of months payment extended  | 
integer | yes | 
| del5_l | Number of times delinquent [5]  | 
integer | yes | 
| del6_l | Number of times delinquent [6]  | 
integer | yes | 
| del7_l | Number of times delinquent [7]  | 
integer | 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 |