rpsp Table: Historical Lease Payment Schedule
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rpsp Table: Historical Lease Payment Schedule

Parent Table

Name Description
rps Historical Lease

Indexes

Name Segment 1 Segment 2
rpsp_idx0 lse_s unique_l

   
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
CHAR(10) no
unique_l
Record number (possible values are 1 to 360)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
pmt_frq_l
Number of payments at frequency
NUMBER(10) yes
pmt_amt_d
Payment amount
NUMBER(15,2) yes
pmt_cd_s
Payment frequency code
CHAR(4) yes