LeasePak 5.2a Database Reference (Sybase)

rls Table: Lease

Description	Column	Datatype
Lease	lse_s	char (10)
Sybase timestamp	timestamp	timestamp
Portfolio	por_s	char (2)
Company	com_s	char (2)
Region	reg_s	char (2)
Office	off_s	char (3)
Vendor	dlr_s	char (9)
Broker	brk_s	char (9)
Investor	inv_s	char (9)
Lessee number	les_s	char (9)
Delinquent lessee Note: this field contains the lessee number if the lease is delinquent and is blank if the lease is not delinquent	dles_s	char (9)
Lease date	d_lsd_s	datetime
Lease commencement date	d_com_s	datetime
System booking date	d_boo_s	datetime
Disbursement date	d_dis_s	datetime
Maturity date	d_mat_s	datetime
Date of last update	d_lup_s	datetime
Time of last update	t_lup_s	char (6)
Activity status date	d_act_s	datetime
Next payment due date	d_pmt_s	datetime
Accrued to date	d_acc_s	datetime
Last payment date	d_pay_s	datetime
Last payment due date	d_lst_s	datetime
Last rebook date	d_reb_s	datetime
Assumed lease date	d_ass_s	datetime
Payment extension date	d_pxt_s	datetime
Date of first payment extension	d_fxt_s	datetime
Lease extension date	d_lxt_s	datetime
Custom date 1	d_cus1_s	datetime
First payment on suspension	d_susp_pmt_s	datetime
Date placed on suspension/non-accrual	d_susp_on_s	datetime
Effective date of suspension/non-accrual	d_susp_eff_s	datetime
Effective date of last payment	d_eff_s	datetime
System booking time	t_boo_s	char (6)
Documentation completion date	d_doc_comp_s	datetime
Date custom outstanding last updated For use only by collection module	d_lcus_s	datetime
Accounting month time stamp (YYYYMM) This field contains a portion of ras.next_mth_s	ym_acct_s	char (6)
Expiry date	d_expiry_date_s	datetime
PAP effective date	d_pap_eff_s	datetime
Activity status	act_s	char (4)
Accrual method lessor	acc_l_s	char (4)
Accrual method vendor	acc_d_s	char (4)
Accrual method investor	acc_i_s	char (4)
Lease source	dir_s	char (4)
Lease form code	frm_s	char (4)
Delinquency watch code	del_s	char (4)
Broker payment code	brk_pay_s	char (4)
Late charge assess	late_s	char (4)
Lease type code	ls_typ_s	char (4)
Extension method	ext_s	char (4)
Custom code 1	c_cus1_s	char (4)
Custom code 2	c_cus2_s	char (4)
Custom code 3	c_cus3_s	char (4)
Purchase option billing method	po_meth_s	char (4)
Purchase option	pur_opt_s	char (4)
Purchase option owner	pur_opt_owner_s	char (4)
Maturing lease termination option	ml_optn_s	char (4)
Prime rate bank number	prim_num_s	char (4)
Late charge index	lat_ind_s	char (4)
IDC accounting method	idc_acct_s	char (4)
Product type code	prd_s	char (4)
Business/personal (B/P)	bus_c	char (1)
Type of lease, open or closed (O/C)	opn_c	char (1)
Payment due last accrual (Y/N)	due_lst_c	char (1)
Re-accrue income for last period (Y/N)	acc_by_c	char (1)
Assumed payment (Y/N)	a_pmt_c	char (1)
Backdated new lease (Y/N)	pre_brd_c	char (1)
Rebook allowed (Y/N)	reb_allow_c	char (1)
Lease extended (Y/N)	lse_ext_c	char (1)
Residual income separated (Y/N)	res_inc_c	char (1)
Purchase option billed (Y/N)	po_bill_c	char (1)
Lease booked using partial deductions module (Y/N)	partial_deductions_c	char (1)
Billing level (C/L/I) C - Customer L - Lessee I - Individual	b_lvl_c	char (1)
Statement code (I/C/F/N/' ') I - individual invoice format C - coupon books F - group invoice format N - billing method outside of LeasePak	stmt_c	char (1)
Late charges assessed since last accrual A - Accrued, allow assessment of late charges L - Late charges assessed, disallow further late charges E - Preaccrued, enable assessment of late charges for prior period D - Preaccrued, disable further late charges for prior period	acc_ltch_c	char (1)
Pre-authorize switch (Y/N)	pap_pmt_c	char (1)
Automatic charge off (Y/N/D) Y - Lease will be automatically charged off after delinquent for more than 120 days. N - No automatic charge off. D - Lease will defer charge off for 1 month.	auto_charge_c	char (1)
Cash/accrual basis for extension income (C/A)	ext_incm_ca_c	char (1)
Suspended IDC accrued allowed (Y/N)	susp_idc_allowed_c	char (1)
General description	desc_s	char (36)
Custom string 2	s_cus2_s	char (10)
Trade-in description	trd_desc_s	char (36)
Clerk when removed from Matured Lease tracking	ini_mcur_s	char (3)
Customer number	cus_s	char (9)
Group number	grp_s	char (3)
Previous lease in group	prev_grp_s	char (10)
Next lease in group	next_grp_s	char (10)
Note attached to lease	note_s	char (10)
Index pointer (Cost of Funds)	index_pntr_s	char (4)
Investor/investor group of discounted lease	disc_invst_s	char (9)
Number of lease buyout quotes	buyout_quote_l	integer
Investor settlement deferral days	invst_defr_l	integer
Lease term	trm_l	integer
Estimated lease term	est_trm_l	integer
Number of payments accrued	pmt_l	integer
Number of assets on this lease	n_unt_l	integer
Number of times delinquent [1]	del1_l	integer
Number of times delinquent [2]	del2_l	integer
Number of times delinquent [3]	del3_l	integer
Number of times delinquent [4]	del4_l	integer
Payment due day	due_l	integer
Number of assumptions	ass_l	integer
Number of lease extensions	ext_l	integer
Number of payment extensions	pmt_ext_l	integer
Number of payment due date changes	due_ext_l	integer
Number of accruals to bypass	abp_l	integer
Number of late charge waivers	lat_wav_l	integer
Grace period in days	grc_l	integer
Number of payments processed	pmt_prcd_l	integer
Number of days delinquent See notes for del_amt_d field	days_delq_l	integer
Lessor yield	p_con_d	double precision
Vendor yield	p_dly_d	double precision
Investor yield factor	p_inv_yld_d	double precision
Cost of funds	p_fund_d	double precision
NPV discount rate	p_erly_pay_d	double precision
IRR (yield)	p_irr_d	double precision
IRR (yield) without residual	p_irr_nr_d	double precision
Bad debt percentage	bad_debt_d	double precision
Custom integer 1	i_cus1_l	integer
Custom integer 2	i_cus2_l	integer
Lessor rental simple rate	p_rent_d	double precision
Lessor rental rate add-on	p_byrt_d	double precision
Contract rental rate add-on	p_cntr_d	double precision
Investor rental simple rate	p_rent_i_d	double precision
Investor rental rate add-on	p_inv_d	double precision
Vendor rental simple rate	p_rent_d_d	double precision
Rate of participation	p_part_d	double precision
Maximum interest rate - lease level	p_max_d	double precision
Minimum interest rate - lease level	p_min_d	double precision
Operating lease princpal/income adjustment	op_bill_adj_d	double precision
Total acquisition cost	tot_org_d	double precision
Other charges	tot_other_d	double precision
Security deposit	sec_d	double precision
Down payment	cap_d	double precision
Documentation fee	up_d	double precision
Interim rent	pro_d	double precision
Broker fees	brk_fee_d	double precision
Total initial direct costs	idc_d	double precision
Residual amount If tot_res_d is entered by the user, the value of p_res_d is erased.	tot_res_d	double precision
Guaranteed portion of residual	res_guar_d	double precision
Mark up	mrk_up_d	double precision
In-house fee	in_fee_d	double precision
Accrued principal	prn_d	double precision
Contract receivable	rec_d	double precision
Principal receivable	prn_rec_d	double precision
Net receipts Y-T-D (actual)	rec_ytd_actual_d	double precision
Net receipts L-T-D (actual)	rec_ltd_d	double precision
Rental income Y-T-D	rent_ytd_d	double precision
Other income Y-T-D	oth_ytd_d	double precision
Other income L-T-D	oth_ltd_d	double precision
Lessor income Y-T-D	l_in_ytd_d	double precision
Vendor income Y-T-D	d_in_ytd_d	double precision
Investor income Y-T-D	i_in_ytd_d	double precision
Lessor unearned rental income	l_ue_d	double precision
Lessor orig unearned rental income	l_ue_org_d	double precision
Lessor rental income accrued P-T-D	l_in_ptd_d	double precision
Lessor current month rent income	l_in_cur_d	double precision
Vendor current unearned rental income	d_ue_d	double precision
Vendor original unearned rental	d_ue_org_d	double precision
Vendor rental income accrued P-T-D	d_in_ptd_d	double precision
Vendor rental income accrued, current month	d_in_cur_d	double precision
Investor unearned rental income	i_ue_d	double precision
Investor orig unearned rental income	i_ue_org_d	double precision
Investor rental income accrued P-T-D	i_in_ptd_d	double precision
Investor current month rental income	i_in_cur_d	double precision
Monthly rental income	in_mly_d	double precision
Monthly rental depreciation	dp_mly_d	double precision
Late charge waiver amount	lat_wav_amt_d	double precision
Unrecognized operating income	unrec_in_d	double precision
Accumulated depreciation	acl_depr_d	double precision
Broker fee accounts payable	brk_ap_d	double precision
Amount of stub interest owed (-) or earned (+)	stub_amt_d	double precision
Vendor payment receivable, current month	d_pmt_cur_d	double precision
NPV of payment stream	npv_d	double precision
Titling tax paid up-front	tax_paid_d	double precision
Use tax accrued	tax_accr_d	double precision
Custom float 1	f_cus1_d	double precision
Custom float 2	f_cus2_d	double precision
Custom float 3	f_cus3_d	double precision
Custom float 4	f_cus4_d	double precision
Custom float 5	f_cus5_d	double precision
Vendor receivable	d_rec_d	double precision
Vendor payment participation unearned	d_part_ue_d	double precision
Amount current paid	cur_paid_d	double precision
Amount last paid	lst_paid_d	double precision
Scheduled interest P-T-D	sch_int_ptd_d	double precision
Unamortized IDC - book	idc_rem_d	double precision
IDC current month amortization - book	idc_cur_d	double precision
Leased assets Starting cost of assets under lease	lsd_unit_d	double precision
Payment amount accrued Y-T-D	pmt_acc_d	double precision
Residual income Y-T-D	r_in_ytd_d	double precision
Unearned residual	r_ue_d	double precision
Original unearned residual	r_ue_org_d	double precision
Residual income accrued P-T-D	r_in_ptd_d	double precision
Residual current month income	r_in_cur_d	double precision
Suspended lessor income accrued	susp_l_acc_d	double precision
Suspended vendor income accrued	susp_d_acc_d	double precision
Suspended investor income accrued	susp_i_acc_d	double precision
Suspended residual income accrued	susp_r_acc_d	double precision
Suspended income collected	susp_col_d	double precision
Fixed price purchase	fp_amt_d	double precision
First payment suspended earnings	susp_frst_d	double precision
Contract receivable (begin of year)	rec_boy_d	double precision
Lessor unearned income (begin of year)	l_ue_boy_d	double precision
Residual (beginning of year)	res_boy_d	double precision
Y-T-D lessor unearned income changes	l_ue_chg_ytd_d	double precision
Interest carryover	car_d	double precision
Interest unpaid	int_unpd_d	double precision
Principal paid Y-T-D	prn_ytd_d	double precision
Principal paid L-T-D	prn_ltd_d	double precision
Interest paid Y-T-D	int_pd_ytd_d	double precision
Interest paid L-T-D	int_ltd_d	double precision
Trade-in	trade_in_d	double precision
Accrual amount to date (COF)	accrual_amt_to_date_d	double precision
Total delinquent amount Notes: 1. Used only by the collection module 2. Calculated only for delinquent leases 3. Only accurate as of the last time EOP Sequential Updates was run with the U1121 Collection switch on 4. Set to 0 for non-delinquent leases 5. These notes also apply to the gr_rec_d, net_out_d, gr_out_d, and days_delq_l fields	del_amt_d	double precision
Custom gross receivable See notes for del_amt_d field	gr_rec_d	double precision
Custom net outstanding See notes for del_amt_d field	net_out_d	double precision
Custom gross outstanding See notes for del_amt_d field	gr_out_d	double precision
Excess mileage adjustment	ml_mile_d	double precision
Wear and tear adjustment	ml_wear_d	double precision
Proceeds of sale	ml_sale_d	double precision
Book value	ml_book_d	double precision
Tax IDC	idc_tax_d	double precision
Unamortized IDC - tax	idc_rem_tax_d	double precision
IDC current month amortization - tax	idc_cur_tax_d	double precision
IDC Y-T-D amortization - tax	idc_ytd_tax_d	double precision
IDC Y-T-D amount - book	idc_ytd_d	double precision
Lessor income reduction Y-T-D	l_in_red_ytd_d	double precision
Residual income reduction Y-T-D	r_in_red_ytd_d	double precision
IDC reduction	idc_red_d	double precision
IDC interest portion	idc_interest_d	double precision
Accrual amount this month (COF)	accrual_amt_this_month_d	double precision
Cost of funds 2 (For FCT)	p_fund2_d	double precision
Number of automatic lease extensions	auto_ext_l	integer
Deferred extension income	dfrd_ext_incm_d	double precision
Deferred residual reduction	dfrd_residual_red_d	double precision
Suspended IDC accrued	susp_idc_acc_d	double precision
Change lease key is in progress	msi_chg_key_c	char (1)

rls Indexes:

Index name	Piece 1	Piece 2	Piece 3	Piece 4	Piece 5
rls_idx0	lse_s
rls_idx1	por_s	com_s	reg_s	off_s	lse_s
rls_idx2	dlr_s	lse_s
rls_idx3	brk_s	lse_s
rls_idx4	inv_s	lse_s
rls_idx5	les_s	lse_s
rls_idx6	dles_s	lse_s

rls Child Tables:

Table	Description
rlsa	Lease 2
rlsb	Lease 3
rlsc	Lease Partial Deduction
rlsp	Lease Payment Schedule
rlsr	Lease Recurring Charge
rlss	Lease Salesperson

Home • Table • Indexes • Children

The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of McCue Systems, Inc. is prohibited.