rhy Table: Lease Year to Date History

Database Reference Sybase DBMS

rhy Table: Lease Year to Date History

Indexes

Name	Segment 1	Segment 2
rhy_idx0	lse_s	year_s

Columns
Name	Description	Datatype ¿?	Allow Null
lse_s	Lease	char(10)	no
year_s	Year (YYYY)	char(4)	no
timestamp	Record modification stamp	timestamp	yes
rec_ytd_d	Net receipts Y-T-D	double precision	yes
rent_ytd_d	Rental income Y-T-D	double precision	yes
oth_ytd_d	Other income Y-T-D	double precision	yes
l_in_ytd_d	Lessor income Y-T-D	double precision	yes
d_in_ytd_d	Vendor income Y-T-D	double precision	yes
i_in_ytd_d	Investor income Y-T-D	double precision	yes
pmt_acc_d	Payment amount accrued Y-T-D	double precision	yes
r_in_ytd_d	Residual income Y-T-D	double precision	yes
l_ue_chg_ytd_d	Y-T-D lessor unearned income changes	double precision	yes
prn_ytd_d	Principal paid Y-T-D	double precision	yes
int_ytd_d	Interest Y-T-D	double precision	yes
idc_ytd_tax_d	IDC Y-T-D amortization - tax	double precision	yes
idc_ytd_d	IDC Y-T-D amount - book	double precision	yes
l_in_red_ytd_d	Lessor income reduction Y-T-D	double precision	yes
r_in_red_ytd_d	Residual income reduction Y-T-D	double precision	yes
idc1_ins_prem_ytd_d	Insurance premium year-to-date IDC1	double precision	yes
idc2_notary_fee_ytd_d	Notary fee year-to-date IDC2	double precision	yes
idr1_ins_fee_ytd_d	Insurance fee year-to-date IDR1	double precision	yes
idr2_reg_fee_ytd_d	Registration fee year-to-date IDR2	double precision	yes
idr3_dlr_subsidy_ytd_d	Dealer subsidy year-to-date IDR3	double precision	yes
idr4_open_comm_ytd_d	Open commission year-to-date IDR4	double precision	yes
rcr_esc_ytd_d	Escrow received year-to-date	double precision	yes
idc3_ytd_d	Year to date IDC3	double precision	yes
idc4_ytd_d	Year to date IDC4	double precision	yes
idc5_ytd_d	Year to date IDC5	double precision	yes
idr5_ytd_d	Year to date IDR5	double precision	yes
idr6_ytd_d	Year to date IDR6	double precision	yes
idr7_ytd_d	Year to date IDR7	double precision	yes
idr8_ytd_d	Year to date IDR8	double precision	yes
idr9_ytd_d	Year to date IDR9	double precision	yes
idra_ytd_d	Year to date IDRA	double precision	yes
idrb_ytd_d	Year to date IDRB	double precision	yes
idrc_ytd_d	Year to date IDRC	double precision	yes
alt_idc3_ytd_d	Alternate year to date IDC3	double precision	yes
alt_idc4_ytd_d	Alternate year to date IDC4	double precision	yes
alt_idc5_ytd_d	Alternate year to date IDC5	double precision	yes
alt_idr5_ytd_d	Alternate year to date IDR5	double precision	yes
alt_idr6_ytd_d	Alternate year to date IDR6	double precision	yes
alt_idrb_ytd_d	Alternate year to date IDRB	double precision	yes
gl_in_ytd_d	GL lessor income Y-T-D	double precision	yes
idc6_ytd_d	Year to date IDC6	double precision	yes
idrd_ytd_d	Year to date IDRD	double precision	yes
idre_ytd_d	Year to date IDRE	double precision	yes
idrf_ytd_d	Year to date IDRF	double precision	yes
idrg_ytd_d	Year to date IDRG	double precision	yes
idrh_ytd_d	Year to date IDRH	double precision	yes
idc7_ytd_d	Year to date IDC7	double precision	yes
tax_inc_ytd_d	Taxable income Y-T-D amount	double precision	yes
fsc_ytd_d	FSC exclusion Y-T-D amount	double precision	yes
int_expn_ytd_d	Interest expenses Y-T-D amount	double precision	yes
dfrd_tax_ytd_d	Deferred tax YTD amount	double precision	yes
idc8_ytd_d	Year to date IDC8	double precision	yes
alt_idc8_ytd_d	Alternate year to date IDC8	double precision	yes
idc9_ytd_d	Year to date IDC9	double precision	yes
alt_idc9_ytd_d	Alternate year to date IDC9	double precision	yes
idca_ytd_d	Year to date IDCA	double precision	yes
alt_idca_ytd_d	Alternate year to date IDCA	double precision	yes
idcb_ytd_d	Year to date IDCB	double precision	yes
alt_idcb_ytd_d	Alternate year to date IDCB	double precision	yes
idcc_ytd_d	Year to date IDCC	double precision	yes
alt_idcc_ytd_d	Alternate year to date IDCC	double precision	yes
idcd_ytd_d	Year to date IDCD	double precision	yes
alt_idcd_ytd_d	Alternate year to date IDCD	double precision	yes
idce_ytd_d	Year to date IDCE	double precision	yes
alt_idce_ytd_d	Alternate year to date IDCE	double precision	yes
idcf_ytd_d	Year to date IDCF	double precision	yes
alt_idcf_ytd_d	Alternate year to date IDCF	double precision	yes
idcg_ytd_d	Year to date IDCG	double precision	yes
alt_idcg_ytd_d	Alternate year to date IDCG	double precision	yes
idch_ytd_d	Year to date IDCH	double precision	yes
alt_idch_ytd_d	Alternate year to date IDCH	double precision	yes
idc_asc842_ytd_d	IDC ASC 842 Y-T-D amount -- book	double precision	yes