rno Table: Note

Database Reference Sybase DBMS

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