rno Table: Note

Database Reference

rno Table: Note

Child Tables

Name	Description
rnon	Note Payment Schedule

Indexes

Name	Segment 1	Segment 2	Segment 3	Segment 4	Segment 5
rno_idx0	por_s	com_s	reg_s	off_s	note_s
rno_idx1	len_s	note_s
rno_idx2	note_s
rno_idx3	lse_s	note_s
rno_idx4	unit_s	note_s

Columns
Name	Description	Datatype ¿?	Allow Null
por_s	Portfolio
com_s	Company
reg_s	Region
off_s	Office
note_s	Note attached to lease
	Record modification stamp
len_s	Lender
lse_s	Lease
unit_s	Asset
d_note_s	Note date
d_com_s	Note commencement date
d_boo_s	System booking date
t_boo_s	System booking time
d_mat_s	Maturity date
d_att_s	Date note was attached to lease/asset
d_lup_s	Date of last update
t_lup_s	Time of last update
d_act_s	Activity status date
d_pmt_s	Next payment due date
d_acc_s	Note accrued to date
d_pay_s	Last payment date
d_lst_s	Last payment due date
d_eff_s	Effective date of last payment
d_pyf_s	Date note was paid off
t_pyf_s	Time note was paid off
d_epf_s	Payoff effective date
act_nt_s	Activity status
acc_nt_s	Accrual method
typ_nt_s	Note type
fl_idx_s	Float index code
bank_s	Bank account GL vector ' 1' - If multiple banks module is purchased ' ' - multiple banks module is not purchased
due_lst_c	Payment due last accrual (Y/N)
rem_allow_c	Removal allowed (Y/N)
commt1_s	Comments [1]
commt2_s	Comments [2]
desc_s	Note description
pmt_l	Number of payments accrued
note_trm_l	Note term
due_l	Payment due day
pmt_prcd_l	Number of payments processed
p_int_rt_d	Interest rate
p_add_rt_d	Note rate add-on
p_min_rt_d	Float floor rate
p_max_rt_d	Float ceiling rate
org_d	Original principal amount
down_d	Down payment
cur_prn1_d	Current principal balance
int_car_d	Interest carry over
int_unpd_d	Interest unpaid
int_accr_cur_d	Interest accrued current month
int_ptd_d	Interest accrued period to date
int_ytd1_d	Interest Y-T-D
int_ltd_d	Interest paid L-T-D
int_prv1_d	Interest previous year
int_par_bk_d	Partial period interest at booking
int_par_pf_d	Partial period interest at payoff
base_amt_pf_d	Base payoff amount
outs_prn_pf_d	Principal outstanding at payoff
outs_int_pf_d	Interest outstanding at payoff
d_fund_s	Funding date
int_perd_d	Interest per diem
bank_loan_s	Bank loan number
gap_fee_d	Gap fee
sec_dep_d	Security deposit
res_for_chrg_bck_d	Reserve for charge backs
ser_fee_d	Service fee
sec_dep_bnk_code_s	Bank code for security deposit
res_chrg_bck_bnk_code_s	Bank code for reserve for charge backs
pre_pmt_res_bnk_code_s	Bank code for pre-payment reserve
eqp_cost_d	Equipment cost
lse_fee_d	Lease fees
lse_numb_att_s	Lease number tied to note
last_eoy_year_s	Last year (YYYY) for which Clear YTD Fields has run