rpd Table: Payoff Quote

Database Reference

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