rpha Table: Payment History Assessment
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rpha Table: Payment History Assessment

Parent Table

Name Description
rph Payment History

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6
rpha_idx0 lse_s pmt_num_s ymd_rev_s d_pmt_run_s t_pmt_run_s unique_l

    
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
DATE no
t_pmt_run_s
Payment run time
CHAR(6) no
unique_l
Record number (possible values are 1 to 25)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
a_typ_s
Assessment type
CHAR(4) yes
aamt_p_d
Assessment amount paid
NUMBER(15,2) yes