LeasePak 5.1a Database Reference (Sybase)

rph Table: Payment History

Description	Column	Datatype
Lease	lse_s	char (10)
Payment number	pmt_num_s	char (3)
Reversal date (YYYYMMDD)	ymd_rev_s	char (8)
Payment run date	d_pmt_run_s	datetime
Payment run time	t_pmt_run_s	char (6)
Sybase timestamp	timestamp	timestamp
Invoice billed date (YYYYMMDD)	ymd_invo_bill_s	char (8)
Invoice due date	d_invo_s	datetime
Effective date of payment	d_eff_s	datetime
Effective date of last payment	d_lst_s	datetime
Payment description	ph_typ_p_s	char (4)
Reversal description	ph_typ_r_s	char (4)
Payment billed on invoice (Y/N)	pmt_bill_c	char (1)
Invoice number	invo_s	char (8)
Payment operator initials	opr_p_s	char (3)
Reversal operator initials	opr_r_s	char (3)
Income recognized at maturity	inc_mat_d	double precision
Interest carryover	car_d	double precision
Principal paid	prn_p_d	double precision
Interest paid	int_p_d	double precision
Principal adjustment	prn_adj_d	double precision
Interest unpaid	int_unpd_d	double precision
Principal outstanding paid	prn_out_p_d	double precision
Principal outstanding received	prn_out_r_d	double precision
Last partial month interest	partial_d	double precision

Index name	Piece 1	Piece 2	Piece 3	Piece 4	Piece 5
rph_idx0	lse_s	pmt_num_s	ymd_rev_s	d_pmt_run_s	t_pmt_run_s
rph_idx1	lse_s	ymd_invo_bill_s	d_pmt_run_s	t_pmt_run_s	pmt_num_s

Table	Description
rpha	Payment History Assessment