| Columns | 
| Name | 
Description | 
Datatype ¿? | 
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  | 
 | 
 |