rrp Table: Rate Plan
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rrp Table: Rate Plan

Child Tables

Name Description
rrpf Rate Plan Payment Factor

Indexes

Name Segment 1
rrp_idx0 rate_plan_cd_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
rate_plan_cd_s
Rate plan code
CHAR(4) no
stamp_l
Record modification stamp
NUMBER(10) no
d_strt_s
Start date
DATE yes
d_end_s
End date
DATE yes
pur_opt_s
Purchase option
CHAR(4) yes
pur_own_s
Purchase option owner
CHAR(4) yes
pmt_cd_s
Payment frequency code
CHAR(4) yes
mkt_cd_s
Market code
CHAR(4) yes
acc_cd_s
Account code
CHAR(4) yes
short_desc_s
Rate plan description
VARCHAR2(20) yes
trm1_l
Lease term [1]
NUMBER(10) yes
trm2_l
Lease term [2]
NUMBER(10) yes
trm3_l
Lease term [3]
NUMBER(10) yes
trm4_l
Lease term [4]
NUMBER(10) yes
trm5_l
Lease term [5]
NUMBER(10) yes
trm6_l
Lease term [6]
NUMBER(10) yes
trm7_l
Lease term [7]
NUMBER(10) yes
trm8_l
Lease term [8]
NUMBER(10) yes
adv_beg_l
Advanced payments begin
NUMBER(10) yes
adv_end_l
Advanced payments end
NUMBER(10) yes
sec_pmt_l
Security (number of payments)
NUMBER(10) yes
p_var_d
Variance percent
NUMBER(15,2) yes
p_sec_dep_d
Security deposit percent
NUMBER(15,5) yes
p_comm_d
Compensation percent
NUMBER(15,2) yes
sec_d
Security deposit
NUMBER(15,2) yes
var_d
Variance amount
NUMBER(15,2) yes
comm_d
Compensation amount
NUMBER(15,2) yes
int1_d
Internal cost 1
NUMBER(15,2) yes
int2_d
Internal cost 2
NUMBER(15,2) yes
int3_d
Internal cost 3
NUMBER(15,2) yes
p_res1_d
Residual percentage 1
NUMBER(15,5) yes
p_res2_d
Residual percentage 2
NUMBER(15,5) yes
p_res3_d
Residual percentage 3
NUMBER(15,5) yes
p_res4_d
Residual percentage 4
NUMBER(15,5) yes
p_res5_d
Residual percentage 5
NUMBER(15,5) yes
p_res6_d
Residual percentage 6
NUMBER(15,5) yes
p_res7_d
Residual percentage 7
NUMBER(15,5) yes
p_res8_d
Residual percentage 8
NUMBER(15,5) yes
def_app_s
Default application
CHAR(10) yes