rhy Table: Lease Year to Date History
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rhy Table: Lease Year to Date History

Indexes

Name Segment 1 Segment 2
rhy_idx0 lse_s year_s

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