Name | Description |
---|---|
rls | Lease |
Name | Segment 1 | Segment 2 |
---|---|---|
rlsa_idx0 | lse_s | unique_l |
Columns | |||
---|---|---|---|
Name | Description | Datatype ¿? | Allow Null |
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 |