rhs Table: Historical Lease for Lease Extension/Reversal
Sybase DBMS

Specifies the columns and rows with Sybase data type information for the rhs Historical Lease for Lease Extension/Reversal table.

Parent-Child: This table has one or more child tables--click here for a listing.

rhs Columns

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

rhs Indexes

Index Name	Piece 1	Piece 2
rhs_idx0	lse_s	ext_num_s

Child Table Listing

Table Name	Description
rhsa	Historical Lease for Lease Extension/Reversal 2
rhsb	Historical Lease for Lease Extension/Reversal 3
rhsc	Historical Lease Partial Deduction for Lease Extension/Reversal
rhsp	Historical Lease Payment Schedule for Lease Extension/Reversal
rhsr	Historical Lease Recurring Charge for Lease Extension/Reversal
rhss	Historical Lease Salesperson for Lease Extension/Reversal

Data Type Definitions and Characteristics

Following are descriptions of the Sybase data types used in the LeasePak database. Note that LeasePak does not use all the Sybase data types.

char

Sybase fixed length character string. Typically used to store short and medium-length string data such as keys, names, addresses, descriptions, four-character codes, and single-character switch values.
Characteristics:

• length - The maximum number of ASCII or ISO-8859-1 characters the string can contain.

datetime

Sybase date and time, containing century, year, month, day, hour, minute, second, and second fraction (to 1/300 second) information.
Characteristics:

• format - The date format for the LeasePak database. For example, format YYYYMMDD is the 4-digit year number followed by the 2-digit month number followed by the 2-digit day number with no intervening punctuation.

double

Sybase numeric data type. Typically used to store percentage, rate, and dollar amount information.
Characteristics:

• scale - The fractional granularity, meaning the number of places available to the right of the decimal point.

integer

Sybase numeric data type. Typically used to store counter and whole number information--term length, payment due day, number of units on lease, number of times delinquent, etc.

timestamp

Sybase data type based on the varbinary data type storing raw binary data. Whenever a table includes a timestamp column, Sybase updates the information in timestamp each time a user inserts or updates a record, preventing multiple-user cross-update data corruption.

text

Sybase expandable character data type. Typically used to store long-length string data such as notebook entries.

LeasePak 6.0a Documentation Suite

© 2008 by McCue Systems Incorporated. All rights reserved.

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.