rlsa Table: Lease 2
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rlsa Table: Lease 2

Parent Table

Name Description
rls Lease

Indexes

Name Segment 1 Segment 2
rlsa_idx0 lse_s unique_l

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