rph Table: Payment History
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rph Table: Payment History

Child Tables

Name Description
rpha Payment History Assessment

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 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

    
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
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
ymd_invo_bill_s
Invoice billed date (YYYYMMDD)
char(8) no
d_invo_s
Invoice due date
datetime yes
d_eff_s
Effective date of payment
datetime yes
d_lst_s
Effective date of last payment
datetime yes
ph_typ_p_s
Payment description
char(4) yes
ph_typ_r_s
Reversal description
char(4) yes
pmt_bill_c
Payment billed on invoice (Y/N)
char(1) yes
invo_s
Invoice number
char(8) yes
opr_p_s
Payment operator initials
char(3) yes
opr_r_s
Reversal operator initials
char(3) yes
inc_mat_d
Income 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
int_unpd_d
Interest unpaid
double precision yes
prn_out_p_d
Principal outstanding paid
double precision yes
prn_out_r_d
Principal outstanding received
double precision yes
partial_d
Last partial month interest
double precision yes
chk_num_s
Check number
char(10) yes