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

Database Reference Sybase 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
timestamp
Record modification stamp
timestamp yes
d_strt_s
Start date
datetime yes
d_end_s
End date
datetime 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
char(20) yes
trm1_l
Lease term [1]
integer yes
trm2_l
Lease term [2]
integer yes
trm3_l
Lease term [3]
integer yes
trm4_l
Lease term [4]
integer yes
trm5_l
Lease term [5]
integer yes
trm6_l
Lease term [6]
integer yes
trm7_l
Lease term [7]
integer yes
trm8_l
Lease term [8]
integer yes
adv_beg_l
Advanced payments begin
integer yes
adv_end_l
Advanced payments end
integer yes
sec_pmt_l
Security (number of payments)
integer yes
p_var_d
Variance percent
double precision yes
p_sec_dep_d
Security deposit percent
double precision yes
p_comm_d
Compensation percent
double precision yes
sec_d
Security deposit
double precision yes
var_d
Variance amount
double precision yes
comm_d
Compensation amount
double precision yes
int1_d
Internal cost 1
double precision yes
int2_d
Internal cost 2
double precision yes
int3_d
Internal cost 3
double precision yes
p_res1_d
Residual percentage 1
double precision yes
p_res2_d
Residual percentage 2
double precision yes
p_res3_d
Residual percentage 3
double precision yes
p_res4_d
Residual percentage 4
double precision yes
p_res5_d
Residual percentage 5
double precision yes
p_res6_d
Residual percentage 6
double precision yes
p_res7_d
Residual percentage 7
double precision yes
p_res8_d
Residual percentage 8
double precision yes
def_app_s
Default application
char(10) yes