rmfp Table: Loan Payment Schedule
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rmfp Table: Loan Payment Schedule

Parent Table

Name Description
rmf Loan

Indexes

Name Segment 1 Segment 2 Segment 3
rmfp_idx0 fin_inst_s loan_s unique_l

   
Columns
Name DescriptionDatatype ¿? Allow Null
fin_inst_s
Financial institution
CHAR(4) no
loan_s
Loan number
CHAR(7) 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