rps Table: Historical Lease

Database Reference

rps Table: Historical Lease

Child Tables

Name	Description
rpsp	Historical Lease Payment Schedule

Indexes

Name	Segment 1	Segment 2	Segment 3	Segment 4	Segment 5
rps_idx0	lse_s
rps_idx1	por_s	com_s	reg_s	off_s	lse_s
rps_idx2	les_s	lse_s
rps_idx3	dlr_s	lse_s

Columns
Name	Description	Datatype ¿?	Allow Null
lse_s	Lease
	Record modification stamp
por_s	Portfolio
com_s	Company
reg_s	Region
off_s	Office
les_s	Lessee number
dlr_s	Vendor
d_acq_s	Equipment acquisition date
d_lsd_s	Lease date
d_act_s	Equipment activity status date
d_mat_s	Maturity date
d_eff_s	Effective date
d_pay_s	Date of payoff/termination
t_pay_s	Time of payoff/termination
act_s	Activity status
rat_s	Lease rating
p_src_s	Payoff source
meth_s	Payoff method
trn_s	Transaction code
mnf_s	Asset manufacturer code
mdl_s	Asset model code
model_yr_s	Asset model year (YYYY)
new_c	New/used (N/U)
ptyp_c	Payoff type - payoff/termination (P/T)
desc_s	Lease description
opr_s	Operator initials
pmt_l	Number of payments accrued
trm_l	Lease term
pay_due_d	Payoff amount due
pro_sale_d	Proceeds of sale
gnls_d	Gain/Loss on termination
allow_d	Allowance for bad debt
org_d	Original acquisition cost
res_d	Residual amount
rec_ltd_d	Net receipts L-T-D (actual)
rec_ytd_d	Net receipts Y-T-D
oth_ltd_d	Other income L-T-D
oth_ytd_d	Other income Y-T-D
tax_amt_d	Payoff taxable amount
del1_l	Number of times delinquent [1]
del2_l	Number of times delinquent [2]
del3_l	Number of times delinquent [3]
del4_l	Number of times delinquent [4]
del5_l	Number of times delinquent [5]
del6_l	Number of times delinquent [6]
del7_l	Number of times delinquent [7]
mileage_d	Excess mileage
wear_d	Wear & tear
fmv_d	Fair market value
sec_d	Security deposit
rev_pmt_d	Reversed payments
base_d	Base payoff amount
pmt_outs_d	Payments outstanding
asm_outs_d	Assessments outstanding
add_d	Additional charges
fee_d	Fee/penalty
itc_d	ITC recaptured
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
quote_d	Total quote
tot_rcv_d	Total received
payoff_d	Payoff amount
refund_d	Refund check amount
debt_prn_bal_d	Debt principle balance amount
debt_add_int_d	Debt additional interest amount
debt_pen_d	Debt penalty fee amount
tax_gnls_d	Tax gain/loss amount
stg_eqty_ap_clr_d	Staged equity account payable clearing amount
brk_fee_ap_clr_d	Broker fee account payable clearing amount
payo_src_name_s	Payoff source name
prn_write_down_c	Principal write down (Y/N)
metro2_s	Metro2 file format code
d_first_delq_s	Date of first delinquency
invo_format_s	Invoice format code
sec_status_c	Security deposit disbursal status (P/U/N) P - processed U - unprocessed N - n/a
sec_refund_d	Security deposit refund amount
non_comm_d	Non commission amount
payoff_reason_s	Reason lease was paid off (PAYO.LEASE code)
special_comment_s	Special comment code (SP.COMMENT code)