LeasePak 5.1a Database Reference (Sybase)

rhy Table: Lease Year to Date History

Description	Column	Datatype
Lease	lse_s	char (10)
Year	year_s	char (4)
Sybase timestamp	timestamp	timestamp
Net receipts Y-T-D	rec_ytd_d	double precision
Rental income Y-T-D	rent_ytd_d	double precision
Other income Y-T-D	oth_ytd_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
Payment amount accrued Y-T-D	pmt_acc_d	double precision
Residual income Y-T-D	r_in_ytd_d	double precision
Y-T-D lessor unearned income changes	l_ue_chg_ytd_d	double precision
Principal paid Y-T-D	prn_ytd_d	double precision
Interest Y-T-D	int_ytd_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
Insurance premium year-to-date IDC1	idc1_ins_prem_ytd_d	double precision
Notary fee year-to-date IDC2	idc2_notary_fee_ytd_d	double precision
Insurance fee year-to-date IDR1	idr1_ins_fee_ytd_d	double precision
Registration fee year-to-date IDR2	idr2_reg_fee_ytd_d	double precision
Dealer subsidy year-to-date IDR3	idr3_dlr_subsidy_ytd_d	double precision
Open commission year-to-date IDR4	idr4_open_comm_ytd_d	double precision
Escrow received year-to-date	rcr_esc_ytd_d	double precision
Year to date IDC3	idc3_ytd_d	double precision
Year to date IDC4	idc4_ytd_d	double precision
Year to date IDC5	idc5_ytd_d	double precision
Year to date IDR5	idr5_ytd_d	double precision
Year to date IDR6	idr6_ytd_d	double precision
Year to date IDR7	idr7_ytd_d	double precision
Year to date IDR8	idr8_ytd_d	double precision
Year to date IDR9	idr9_ytd_d	double precision
Year to date IDRA	idra_ytd_d	double precision
Year to date IDRB	idrb_ytd_d	double precision
Year to date IDRC	idrc_ytd_d	double precision
Alternate year to date IDC3	alt_idc3_ytd_d	double precision
Alternate year to date IDC4	alt_idc4_ytd_d	double precision
Alternate year to date IDC5	alt_idc5_ytd_d	double precision
Alternate year to date IDR5	alt_idr5_ytd_d	double precision
Alternate year to date IDR6	alt_idr6_ytd_d	double precision
Alternate year to date IDRB	alt_idrb_ytd_d	double precision
GL lessor income Y-T-D	gl_in_ytd_d	double precision

rhy Indexes:

Index name	Piece 1	Piece 2
rhy_idx0	lse_s	year_s

Home • Table • Indexes