Columns |
Name |
Description |
Datatype ¿? |
Allow Null |
ext_num_s |
Extension |
|
|
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. |
|
|
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 |
|
|