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