---

LeasePak 5.1a Database Reference (Sybase)

Home • Table • Indexes

---

rpd Table: Payoff Quote

Description	Column	Datatype
Lease	lse_s	char (10)
Sybase timestamp	timestamp	timestamp
Asset	unit_s	char (10)
Effective date	d_eff_s	datetime
FMV date	d_fmv_s	datetime
Quote date	d_quote_s	datetime
Quote time	t_quote_s	char (6)
Good until date	d_good_s	datetime
Method	method_s	char (4)
Quote type (P/T)	quote_type_c	char (1)
Future payments received (Y/N)	pmt_recd_c	char (1)
FMV reference	ref_s	char (36)
Comments [1]	commt1_s	char (80)
Comments [2]	commt2_s	char (80)
Operator initials	opr_s	char (3)
Base rate	base_s	char (4)
Base payoff amount default	base_def_s	char (4)
Portfolio tax rate	tax_d	double precision
Interest rate	rate_d	double precision
FMV quote	fmv_d	double precision
Wear & tear	wear_d	double precision
Excess mileage	mileage_d	double precision
Base payoff amount	base_d	double precision
Payment delinquent	pmt_dlnq_d	double precision
Payments current	pmt_curr_d	double precision
Assessments outstanding	asm_outs_d	double precision
Fee/penalty	fee_d	double precision
Sales tax	sales_tax_d	double precision
ITC recaptured	itc_d	double precision
Additional charges	add_d	double precision
Total quote	quote_d	double precision
Security deposit	sec_d	double precision
Use tax	use_tax_d	double precision
Late charges	late_d	double precision
ITC reversed	itc_rev_d	double precision
Per diem	diem_d	double precision
Base amount for termination	bas_wo_d	double precision
Interest adjustment	int_adj_d	double precision
Base taxable amount	base_amt_d	double precision
Create payoff quote invoice (Y/N)	invoice_c	char (1)
Credit life insurance 1 rebate	cr_lif1_re_d	double precision
Credit life insurance 2 rebate	cr_lif2_re_d	double precision
Credit disability insurance 1 rebate	cr_dis1_re_d	double precision
Credit disability insurance 2 rebate	cr_dis2_re_d	double precision
Exclude unguaranteed residual amount	excl_unguar_res_c	char (1)
Collection fees	col_fee_d	double precision
Assumption fees	ass_fee_d	double precision
Legal fees	leg_fee_d	double precision
Payment extension fees	pmt_ext_fee_d	double precision
Lease extension fees	lse_ext_fee_d	double precision
Lease rewrite fees	lsrw_fee_d	double precision
Other charges	other_d	double precision
Maintenance fee	maint_d	double precision
Property tax	prop_tax_d	double precision
Federal highway use tax fee	fhut_fee_d	double precision
Adjust payoff assessments (Y/N)	adj_payoff_asm_c	char (1)
Recurring charge [1]	rcr1_d	double precision
Recurring charge [2]	rcr2_d	double precision
Recurring charge [3]	rcr3_d	double precision
Recurring charge [4]	rcr4_d	double precision
Recurring charge [5]	rcr5_d	double precision
Recurring charge [6]	rcr6_d	double precision
Recurring charge [7]	rcr7_d	double precision
Recurring charge [8]	rcr8_d	double precision
Recurring charge [9]	rcr9_d	double precision
Recurring charge [10]	rcr10_d	double precision
Recurring charge [11]	rcr11_d	double precision
Recurring charge [12]	rcr12_d	double precision
Recurring charge [13]	rcr13_d	double precision
Recurring charge [14]	rcr14_d	double precision
Recurring charge [15]	rcr15_d	double precision

rpd Indexes:

Index name	Piece 1	Piece 2	Piece 3	Piece 4
rpd_idx0	lse_s	d_quote_s	t_quote_s
rpd_idx1	unit_s	lse_s	d_quote_s	t_quote_s

---

Home • Table • Indexes

(c) Copyright 2004 McCue Systems, Inc.