| Description |
Column |
Datatype |
| Lease
|
lse_s |
char (10) |
| Sybase timestamp
|
timestamp |
timestamp |
| Portfolio
|
por_s |
char (2) |
| Company
|
com_s |
char (2) |
| Region
|
reg_s |
char (2) |
| Office
|
off_s |
char (3) |
| Lessee number
|
les_s |
char (9) |
| Vendor
|
dlr_s |
char (9) |
| Equipment acquisition date
|
d_acq_s |
datetime |
| Lease date
|
d_lsd_s |
datetime |
| Equipment activity status date
|
d_act_s |
datetime |
| Maturity date
|
d_mat_s |
datetime |
| Effective date
|
d_eff_s |
datetime |
| Date of payoff/termination
|
d_pay_s |
datetime |
| Time of payoff/termination
|
t_pay_s |
char (6) |
| Activity status
|
act_s |
char (4) |
| Lease rating
|
rat_s |
char (4) |
| Payoff source
|
p_src_s |
char (4) |
| Payoff method
|
meth_s |
char (4) |
| Transaction code
|
trn_s |
char (4) |
| Asset manufacturer code
|
mnf_s |
char (4) |
| Asset model code
|
mdl_s |
char (4) |
| Asset model year
|
model_yr_s |
char (2) |
| New/used (N/U)
|
new_c |
char (1) |
| Payoff type - payoff/termination (P/T)
|
ptyp_c |
char (1) |
| Lease description
|
desc_s |
char (36) |
| Operator initials
|
opr_s |
char (3) |
| Number of payments accrued
|
pmt_l |
integer |
| Lease term
|
trm_l |
integer |
| Payoff amount due
|
pay_due_d |
double precision |
| Proceeds of sale
|
pro_sale_d |
double precision |
| Gain/Loss on termination
|
gnls_d |
double precision |
| Allowance for bad debt
|
allow_d |
double precision |
| Original acquisition cost
|
org_d |
double precision |
| Residual amount
|
res_d |
double precision |
| Net receipts L-T-D (actual)
|
rec_ltd_d |
double precision |
| Net receipts Y-T-D
|
rec_ytd_d |
double precision |
| Other income L-T-D
|
oth_ltd_d |
double precision |
| Other income Y-T-D
|
oth_ytd_d |
double precision |
| Payoff taxable amount
|
tax_amt_d |
double precision |
| Number of times delinquent [1]
|
del1_l |
integer |
| Number of times delinquent [2]
|
del2_l |
integer |
| Number of times delinquent [3]
|
del3_l |
integer |
| Number of times delinquent [4]
|
del4_l |
integer |
| Number of times delinquent [5]
|
del5_l |
integer |
| Number of times delinquent [6]
|
del6_l |
integer |
| Number of times delinquent [7]
|
del7_l |
integer |
| Excess mileage
|
mileage_d |
double precision |
| Wear & tear
|
wear_d |
double precision |
| FMV quote
|
fmv_d |
double precision |
| Security deposit
|
sec_d |
double precision |
| Reversed payments
|
rev_pmt_d |
double precision |
| Base payoff amount
|
base_d |
double precision |
| Payments outstanding
|
pmt_outs_d |
double precision |
| Assessments outstanding
|
asm_outs_d |
double precision |
| Additional charges
|
add_d |
double precision |
| Fee/penalty
|
fee_d |
double precision |
| ITC recaptured
|
itc_d |
double precision |
| 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 |
| Total quote
|
quote_d |
double precision |
| Total received
|
tot_rcv_d |
double precision |
| Payoff amount
|
payoff_d |
double precision |
| Refund check amount
|
refund_d |
double precision |
| Debt principle balance amount
|
debt_prn_bal_d |
double precision |
| Debt additional interest amount
|
debt_add_int_d |
double precision |
| Debt penalty fee amount
|
debt_pen_d |
double precision |
| Tax gain/loss amount
|
tax_gnls_d |
double precision |
| Staged equity account payable clearing amount
|
stg_eqty_ap_clr_d |
double precision |
| Broker fee account payable clearing amount
|
brk_fee_ap_clr_d |
double precision |
| Payoff source name
|
payo_src_name_s |
char (36) |