rnh Table: Note Payable Payment History

Name	Segment 1	Segment 2	Segment 3	Segment 4	Segment 5
rnh_idx0	note_s	pmt_num_s	ymd_rev_s	d_pmt_run_s	t_pmt_run_s

Columns
Name	Description	Datatype ¿?	Allow Null
note_s	Note attached to lease	char(10)	no
pmt_num_s	Payment number	char(3)	no
ymd_rev_s	Reversal date (YYYYMMDD)	char(8)	no
d_pmt_run_s	Payment run date	datetime	no
t_pmt_run_s	Payment run time	char(6)	no
timestamp	Record modification stamp	timestamp	yes
d_due_s	Payment due date	datetime	yes
d_eff_s	Effective date of payment	datetime	yes
d_lst_s	Effective date of last payment	datetime	yes
nh_typ_p_s	Payment description	char(4)	yes
nh_typ_r_s	Reversal description	char(4)	yes
opr_p_s	Payment operator initials	char(3)	yes
opr_r_s	Reversal operator initials	char(3)	yes
bank_s	Bank account GL vector ' 1' - If multiple banks module is purchased ' ' - multiple banks module is not purchased	char(3)	yes
int_mat_d	Interest recognized at maturity	double precision	yes
car_d	Interest carryover	double precision	yes
prn_p_d	Principal paid	double precision	yes
int_p_d	Interest paid	double precision	yes
prn_adj_d	Principal adjustment	double precision	yes
chg_int_unpd_d	Change in interest unpaid (i.e. adjustments to the rno.int_unpd_d field)	double precision	yes
prn_out_bal_p_d	Outstanding principal balance after payment	double precision	yes
prn_out_bal_r_d	Outstanding principal balance after reversal	double precision	yes
partial_d	Last partial month interest	double precision	yes