LeasePak 5.1a Database Reference (Sybase)

rrp Table: Rate Plan

Description	Column	Datatype
Rate plan code	rate_plan_cd_s	char (4)
Sybase timestamp	timestamp	timestamp
Start date	d_strt_s	datetime
End date	d_end_s	datetime
Purchase option	pur_opt_s	char (4)
Purchase option owner	pur_own_s	char (4)
Payment frequency code	pmt_cd_s	char (4)
Market code	mkt_cd_s	char (4)
Account code	acc_cd_s	char (4)
Rate plan description	short_desc_s	char (20)
Lease term [1]	trm1_l	integer
Lease term [2]	trm2_l	integer
Lease term [3]	trm3_l	integer
Lease term [4]	trm4_l	integer
Lease term [5]	trm5_l	integer
Lease term [6]	trm6_l	integer
Lease term [7]	trm7_l	integer
Lease term [8]	trm8_l	integer
Advanced payments begin	adv_beg_l	integer
Advanced payments end	adv_end_l	integer
Security (number of payments)	sec_pmt_l	integer
Variance percent	p_var_d	double precision
Security deposit percent	p_sec_dep_d	double precision
Compensation percent	p_comm_d	double precision
Security deposit	sec_d	double precision
Variance amount	var_d	double precision
Compensation amount	comm_d	double precision
Internal cost 1	int1_d	double precision
Internal cost 2	int2_d	double precision
Internal cost 3	int3_d	double precision
Residual percentage 1	p_res1_d	double precision
Residual percentage 2	p_res2_d	double precision
Residual percentage 3	p_res3_d	double precision
Residual percentage 4	p_res4_d	double precision
Residual percentage 5	p_res5_d	double precision
Residual percentage 6	p_res6_d	double precision
Residual percentage 7	p_res7_d	double precision
Residual percentage 8	p_res8_d	double precision

rrp Indexes:

Index name	Piece 1
rrp_idx0	rate_plan_cd_s

rrp Child Tables:

Table	Description
rrpf	Rate Plan Payment Factor

Home • Table • Indexes • Children