rrpf Table: Rate Plan Payment Factor
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rrpf Table: Rate Plan Payment Factor

Parent Table

Name Description
rrp Rate Plan

Indexes

Name Segment 1 Segment 2
rrpf_idx0 rate_plan_cd_s unique_l

   
Columns
Name DescriptionDatatype ¿? Allow Null
rate_plan_cd_s
Rate plan code
CHAR(4) no
unique_l
Record number (possible values are 1 to 6)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
min_d
Minimum acquisition cost
NUMBER(15,2) yes
max_d
Maximum acquisition cost
NUMBER(15,2) yes
p_factor1_d
Rate Plan payment factor [1]
NUMBER(15,5) yes
p_factor2_d
Rate Plan payment factor [2]
NUMBER(15,5) yes
p_factor3_d
Rate Plan payment factor [3]
NUMBER(15,5) yes
p_factor4_d
Rate Plan payment factor [4]
NUMBER(15,5) yes
p_factor5_d
Rate Plan payment factor [5]
NUMBER(15,5) yes
p_factor6_d
Rate Plan payment factor [6]
NUMBER(15,5) yes
p_factor7_d
Rate Plan payment factor [7]
NUMBER(15,5) yes
p_factor8_d
Rate Plan payment factor [8]
NUMBER(15,5) yes