rpd Table: Payoff Quote

Database Reference Sybase DBMS

rpd Table: Payoff Quote

Indexes

Name	Segment 1	Segment 2	Segment 3	Segment 4	Segment 5
rpd_idx0	lse_s	d_quote_s	t_quote_s	batch_num_s	unit_s
rpd_idx1	batch_num_s	unit_s	lse_s	d_quote_s	t_quote_s
rpd_idx2	unit_s	batch_num_s	lse_s	d_quote_s	t_quote_s

Columns
Name	Description	Datatype ¿?	Allow Null
lse_s	Lease	char(10)	no
timestamp	Record modification stamp	timestamp	yes
unit_s	Asset	char(10)	no
d_eff_s	Effective date	datetime	yes
d_fmv_s	FMV date	datetime	yes
d_quote_s	Quote date	datetime	no
t_quote_s	Quote time	char(6)	no
d_good_s	Good until date	datetime	yes
method_s	Method	char(4)	yes
quote_type_c	Quote type (P/T)	char(1)	yes
pmt_recd_c	Future payments received (Y/N)	char(1)	yes
ref_s	FMV reference	char(36)	yes
commt1_s	Comments [1]	char(80)	yes
commt2_s	Comments [2]	char(80)	yes
opr_s	Operator initials	char(3)	yes
base_s	Base rate	char(4)	yes
base_def_s	Base payoff amount default	char(4)	yes
tax_d	Portfolio tax rate	double precision	yes
rate_d	Interest rate	double precision	yes
fmv_d	Fair market value	double precision	yes
wear_d	Wear & tear	double precision	yes
mileage_d	Excess mileage	double precision	yes
base_d	Base payoff amount	double precision	yes
pmt_dlnq_d	Payment delinquent	double precision	yes
pmt_curr_d	Payments current	double precision	yes
asm_outs_d	Assessments outstanding	double precision	yes
fee_d	Fee/penalty	double precision	yes
sales_tax_d	Sales tax	double precision	yes
itc_d	ITC recaptured	double precision	yes
add_d	Additional charges	double precision	yes
quote_d	Total quote	double precision	yes
sec_d	Security deposit	double precision	yes
use_tax_d	Use tax	double precision	yes
late_d	Late charges	double precision	yes
itc_rev_d	ITC reversed	double precision	yes
diem_d	Per diem	double precision	yes
bas_wo_d	Base amount for termination	double precision	yes
int_adj_d	Interest adjustment	double precision	yes
base_amt_d	Base taxable amount	double precision	yes
invoice_c	Create payoff quote invoice (Y/N)	char(1)	yes
cr_lif1_re_d	Credit life insurance 1 rebate	double precision	yes
cr_lif2_re_d	Credit life insurance 2 rebate	double precision	yes
cr_dis1_re_d	Credit disability insurance 1 rebate	double precision	yes
cr_dis2_re_d	Credit disability insurance 2 rebate	double precision	yes
excl_unguar_res_c	Exclude unguaranteed residual amount	char(1)	yes
col_fee_d	Collection fees	double precision	yes
ass_fee_d	Assumption fees	double precision	yes
leg_fee_d	Legal fees	double precision	yes
pmt_ext_fee_d	Payment extension fees	double precision	yes
lse_ext_fee_d	Lease extension fees	double precision	yes
lsrw_fee_d	Lease rewrite fees	double precision	yes
other_d	Other charges	double precision	yes
maint_d	Maintenance fee	double precision	yes
prop_tax_d	Property tax	double precision	yes
fhut_fee_d	Federal highway use tax fee	double precision	yes
adj_payoff_asm_c	Adjust payoff assessments (Y/N)	char(1)	yes
rcr1_d	Recurring charge [1]	double precision	yes
rcr2_d	Recurring charge [2]	double precision	yes
rcr3_d	Recurring charge [3]	double precision	yes
rcr4_d	Recurring charge [4]	double precision	yes
rcr5_d	Recurring charge [5]	double precision	yes
rcr6_d	Recurring charge [6]	double precision	yes
rcr7_d	Recurring charge [7]	double precision	yes
rcr8_d	Recurring charge [8]	double precision	yes
rcr9_d	Recurring charge [9]	double precision	yes
rcr10_d	Recurring charge [10]	double precision	yes
rcr11_d	Recurring charge [11]	double precision	yes
rcr12_d	Recurring charge [12]	double precision	yes
rcr13_d	Recurring charge [13]	double precision	yes
rcr14_d	Recurring charge [14]	double precision	yes
rcr15_d	Recurring charge [15]	double precision	yes
tot_diem_d	Total per diem amount	double precision	yes
days_diem_l	Days of per diem	integer	yes
batch_num_s	Batch number	char(6)	no
payoff_lvl_c	Payoff quote level (L/A) L - Lease A - Asset	char(1)	yes
rcr16_d	Recurring charge [16]	double precision	yes
rcr17_d	Recurring charge [17]	double precision	yes
rcr18_d	Recurring charge [18]	double precision	yes
rcr19_d	Recurring charge [19]	double precision	yes
rcr20_d	Recurring charge [20]	double precision	yes
rcr21_d	Recurring charge [21]	double precision	yes
rcr22_d	Recurring charge [22]	double precision	yes
rcr23_d	Recurring charge [23]	double precision	yes
rcr24_d	Recurring charge [24]	double precision	yes
rcr25_d	Recurring charge [25]	double precision	yes
rcr26_d	Recurring charge [26]	double precision	yes
rcr27_d	Recurring charge [27]	double precision	yes
rcr28_d	Recurring charge [28]	double precision	yes
rcr29_d	Recurring charge [29]	double precision	yes
rcr30_d	Recurring charge [30]	double precision	yes
rcr31_d	Recurring charge [31]	double precision	yes
rcr32_d	Recurring charge [32]	double precision	yes
rcr33_d	Recurring charge [33]	double precision	yes
rcr34_d	Recurring charge [34]	double precision	yes
rcr35_d	Recurring charge [35]	double precision	yes
lse_fee1_d	Lease fee [1]	double precision	yes
lse_fee2_d	Lease fee [2]	double precision	yes
lse_fee3_d	Lease fee [3]	double precision	yes
lse_fee4_d	Lease fee [4]	double precision	yes
lse_fee5_d	Lease fee [5]	double precision	yes
lse_fee6_d	Lease fee [6]	double precision	yes
lse_fee7_d	Lease fee [7]	double precision	yes
lse_fee8_d	Lease fee [8]	double precision	yes
lse_fee9_d	Lease fee [9]	double precision	yes
lse_fee10_d	Lease fee [10]	double precision	yes
lse_fee11_d	Lease fee [11]	double precision	yes
lse_fee12_d	Lease fee [12]	double precision	yes
lse_fee13_d	Lease fee [13]	double precision	yes
lse_fee14_d	Lease fee [14]	double precision	yes
lse_fee15_d	Lease fee [15]	double precision	yes
lse_fee16_d	Lease fee [16]	double precision	yes
lse_fee17_d	Lease fee [17]	double precision	yes
lse_fee18_d	Lease fee [18]	double precision	yes
lse_fee19_d	Lease fee [19]	double precision	yes
lse_fee20_d	Lease fee [20]	double precision	yes
unit_fee1_d	Asset fee [1]	double precision	yes
unit_fee2_d	Asset fee [2]	double precision	yes
unit_fee3_d	Asset fee [3]	double precision	yes
unit_fee4_d	Asset fee [4]	double precision	yes
unit_fee5_d	Asset fee [5]	double precision	yes
unit_fee6_d	Asset fee [6]	double precision	yes
unit_fee7_d	Asset fee [7]	double precision	yes
unit_fee8_d	Asset fee [8]	double precision	yes
unit_fee9_d	Asset fee [9]	double precision	yes
unit_fee10_d	Asset fee [10]	double precision	yes