| Description |
Column |
Datatype |
| Extension
|
ext_num_s |
char (2) |
| Portfolio
|
por_s |
char (2) |
| Company
|
com_s |
char (2) |
| Region
|
reg_s |
char (2) |
| Office
|
off_s |
char (3) |
| Lease
|
lse_s |
char (10) |
| Asset
|
unit_s |
char (10) |
| Sybase timestamp
|
timestamp |
timestamp |
| Asset identification
|
id_s |
char (25) |
| Purchase order number
|
pur_ord_s |
char (25) |
| Vendor
|
dlr_s |
char (9) |
| Application
|
app_s |
char (10) |
| Equipment acquisition date
|
d_acq_s |
datetime |
| Ownership certificate activity date
|
d_act_s |
datetime |
| FHUT date of first use
|
d_fhut_s |
datetime |
| System booking date
|
d_boo_s |
datetime |
| Equipment activity status date
|
d_eqt_s |
datetime |
| In-service date
|
d_serv_s |
datetime |
| Inspection date
|
d_insp_s |
datetime |
| Book depreciation start date
|
d_bok_s |
datetime |
| ITC accrued to date
|
d_itc_s |
datetime |
| Add-on date
|
d_addon_s |
datetime |
| P.O. date
|
d_po_s |
datetime |
| Correction sent date
|
d_cor_s |
datetime |
| Last lien date
|
d_lien_s |
datetime |
| Class
|
cls_s |
char (4) |
| ITC take/bypass code
|
itc_s |
char (4) |
| ETC take/bypass code
|
etc_s |
char (4) |
| Tax benefit owner code
|
txb_s |
char (4) |
| Equipment activity status
|
eqt_s |
char (4) |
| Asset manufacturer code
|
mnf_s |
char (4) |
| Asset model code
|
mdl_s |
char (4) |
| Asset year code
|
yr_s |
char (2) |
| Book depreciation method
|
bkd_s |
char (4) |
| Federal method of depreciation
|
fed_s |
char (4) |
| State method of depreciation
|
std_s |
char (4) |
| State
|
st_s |
char (2) |
| County location code
|
ct_s |
char (4) |
| City location code
|
cy_s |
char (4) |
| Tax payment code
|
txp_s |
char (4) |
| Ownership certificate code
|
co_s |
char (4) |
| Federal highway use tax code
|
hw_s |
char (4) |
| Equipment status at payoff
|
eqt_pay_s |
char (4) |
| Federal AMT method
|
fed_amt_s |
char (4) |
| ITC accrual method
|
itc_meth_s |
char (4) |
| Asset status
|
eqt_stat_s |
char (4) |
| Activity status prior to booking
|
eqt_inv_s |
char (4) |
| Tax type
|
tax_type_s |
char (4) |
| Book accounting method
|
bk_acct_s |
char (4) |
| Upfront sales tax - state
|
upf_st_s |
char (2) |
| Upfront sales tax - county
|
upf_ct_s |
char (4) |
| Upfront sales tax - city
|
upf_cy_s |
char (4) |
| Required correction code
|
corr_s |
char (4) |
| Payoff/sale state location code
|
pay_st_s |
char (2) |
| Payoff/sale county location code
|
pay_ct_s |
char (4) |
| Payoff/sale city location code
|
pay_cy_s |
char (4) |
| Asset payoff method
|
pay_meth_s |
char (4) |
| New/used (N/U)
|
new_c |
char (1) |
| Auto options at lease commencement (Y/N)
|
copt_c |
char (30) |
| Auto options at lease termination (Y/N)
|
topt_c |
char (30) |
| Warranty insurance (Y/N)
|
war_c |
char (1) |
| Residual insurance (Y/N)
|
res_ins_c |
char (1) |
| An asset payoff was done (Y/N)
|
unt_pay_c |
char (1) |
| Off-lease (Y/N)
|
off_c |
char (1) |
| Report property tax (Y/N)
|
rpt_ptax_c |
char (1) |
| Pre-inventory (Y/N)
|
pre_inv_c |
char (1) |
| Asset appears on tax reports (Y/N)
|
tax_rptg_c |
char (1) |
| Allow termination reversal (Y/N)
|
term_rev_c |
char (1) |
| Gross profit type - related/unrelated (R/U)
|
gp_typ_c |
char (1) |
| Upfront sales tax (Y/N)
|
upf_stax_c |
char (1) |
| Equipment street address
|
eq_add_s |
char (36) |
| Equipment city
|
eq_cty_s |
char (25) |
| Equipment state
|
eq_st_s |
char (2) |
| Equipment zip
|
eq_zip_s |
char (9) |
| Equipment description
|
desc_s |
char (36) |
| Operator name
|
opr_nam_s |
char (36) |
| License (auto)
|
lic_s |
char (9) |
| Stock number
|
stock_s |
char (7) |
| Next asset in loan
|
nxt_ln_s |
char (10) |
| Previous asset in loan
|
prv_ln_s |
char (10) |
| First loan for asset
|
frst_loan_s |
char (11) |
| Last loan for asset
|
last_loan_s |
char (11) |
| Cashier's check number
|
cashier_chk_s |
char (6) |
| Suspense item number written
|
sus_s |
char (6) |
| Suspense item number cleared
|
sus_clr_s |
char (6) |
| Associated asset
|
asset_s |
char (10) |
| Clerk when asset removed from collateral tracking
|
ini_cur_s |
char (3) |
| Check reference
|
chk_ref_s |
char (36) |
| Supplier name
|
sup_nam_s |
char (36) |
| Supplier address
|
sup_add_s |
char (36) |
| Supplier address 2
|
sup_add2_s |
char (36) |
| Supplier city
|
sup_cty_s |
char (25) |
| Supplier state
|
sup_st_s |
char (2) |
| Supplier zip
|
sup_zip_s |
char (9) |
| DMV bundle number
|
bun_s |
char (25) |
| DMV suspense receipt number
|
snum_s |
char (25) |
| Adjustment depreciable life
|
adj_depr_life_l |
integer |
| Odometer reading at lease commencement
|
codm_l |
integer |
| Odometer reading at lease termination
|
todm_l |
integer |
| FHUT asset weight (pounds)
|
weight_l |
integer |
| Average yearly allowable mileage
|
mil_aam_l |
integer |
| Percentage of schedule amount
|
p_sch_d |
double precision |
| Asset yield
|
p_con_unit_d |
double precision |
| Upfront sales tax - state rate
|
upf_strt_d |
double precision |
| Upfront sales tax - county rate
|
upf_ctrt_d |
double precision |
| Upfront sales tax - city rate
|
upf_cyrt_d |
double precision |
| Payoff/sale state rate
|
pay_st_rate_d |
double precision |
| Payoff/sale county rate
|
pay_ct_rate_d |
double precision |
| Payoff/sale city rate
|
pay_cy_rate_d |
double precision |
| State tax rate
|
st_rate_d |
double precision |
| County tax rate
|
ct_rate_d |
double precision |
| City tax rate
|
cy_rate_d |
double precision |
| Portfolio tax rate
|
tax_d |
double precision |
| Original acquisition cost
|
org_d |
double precision |
| Other charges
|
other_d |
double precision |
| Residual amount
|
res_d |
double precision |
| Starting asset cost
|
strt_d |
double precision |
| Inventoried value
|
inven_d |
double precision |
| Accounts payable
|
acc_pay_d |
double precision |
| List price
|
lst_d |
double precision |
| License fees
|
lic_d |
double precision |
| Warranty insurance premium
|
pre_d |
double precision |
| Repair cost
|
rep_d |
double precision |
| Gas cost
|
gas_d |
double precision |
| Gross receipts Y-T-D
|
rec_ytd_gross_d |
double precision |
| Asset change in L-T-D receipts
|
unit_rec_ltd_d |
double precision |
| Other income Y-T-D
|
oth_ytd_d |
double precision |
| Other income L-T-D
|
oth_ltd_d |
double precision |
| Starting book value for depreciation
|
taxbasis_d |
double precision |
| Starting book value for ITC
|
itcbasis_d |
double precision |
| Book value salvage value
|
sal_bkd_d |
double precision |
| State salvage value
|
sal_st_d |
double precision |
| Depreciation M-T-D book
|
mtd_bkd_d |
double precision |
| Depreciation Y-T-D book
|
ytd_bkd_d |
double precision |
| Depreciation L-T-D book
|
ltd_bkd_d |
double precision |
| Depreciation M-T-D federal
|
mtd_fed_d |
double precision |
| Depreciation Y-T-D federal
|
ytd_fed_d |
double precision |
| Depreciation L-T-D federal
|
ltd_fed_d |
double precision |
| Depreciation M-T-D state
|
mtd_st_d |
double precision |
| Depreciation Y-T-D state
|
ytd_st_d |
double precision |
| Depreciation L-T-D state
|
ltd_st_d |
double precision |
| Original L-T-D book depreciation
|
org_bkd_ltd_d |
double precision |
| Original ITC
|
itc_org_d |
double precision |
| ITC sustained
|
itc_sus_d |
double precision |
| ITC M-T-D
|
itc_mtd_d |
double precision |
| ITC Y-T-D
|
itc_ytd_d |
double precision |
| ITC L-T-D
|
itc_ltd_d |
double precision |
| ETC M-T-D
|
etc_mtd_d |
double precision |
| ETC Y-T-D
|
etc_ytd_d |
double precision |
| ETC L-T-D
|
etc_ltd_d |
double precision |
| Net book value at payoff/termination
|
nbv_pay_d |
double precision |
| Y-T-D loss on termination
|
ytd_loss_d |
double precision |
| Y-T-D gain on termination
|
ytd_gain_d |
double precision |
| State book value at payoff
|
std_pay_d |
double precision |
| Federal book value at payoff
|
fed_pay_d |
double precision |
| Residual at payoff
|
res_pay_d |
double precision |
| Starting cost at payoff
|
strt_pay_d |
double precision |
| Assessments outstanding for payoff
|
asm_pay_d |
double precision |
| Payments outstanding for payoff
|
pmt_pay_d |
double precision |
| Asset receivable
|
unit_rec_d |
double precision |
| Asset change in receivable
|
chg_rec_d |
double precision |
| Asset principal
|
unit_prn_d |
double precision |
| Asset lessor unearned
|
unit_l_ue_d |
double precision |
| Asset vendor unearned
|
d_ue_d |
double precision |
| Asset investor unearned
|
unit_i_ue_d |
double precision |
| Asset lessor unearned original
|
unit_l_ue_org_d |
double precision |
| Asset vendor unearned original
|
d_ue_org_d |
double precision |
| Asset investor unearned original
|
unit_i_ue_org_d |
double precision |
| Schedule percentage basis
|
sch_basis_d |
double precision |
| Federal AMT L-T-D amount
|
fed_amt_ltd_d |
double precision |
| Book tax basis
|
bk_basis_d |
double precision |
| Original ITC unearned
|
itc_org_ue_d |
double precision |
| Current ITC unearned
|
itc_cur_ue_d |
double precision |
| ITC income Y-T-D
|
itc_in_ytd_d |
double precision |
| ITC current month income
|
itc_in_cur_d |
double precision |
| Manufacturer's depreciation basis
|
man_bas_d |
double precision |
| Payment amount accrued Y-T-D
|
pmt_acc_d |
double precision |
| Asset payment amount
|
pmt_amt_d |
double precision |
| Lessor income Y-T-D
|
l_in_ytd_d |
double precision |
| Original asset cost
|
ast_cst_d |
double precision |
| Original book basis
|
org_bk_basis_d |
double precision |
| Adjustment to book basis
|
adj_bk_basis_d |
double precision |
| Asset residual unearned
|
unit_r_ue_d |
double precision |
| Asset change in Y-T-D receipts
|
rec_ytd_chg_d |
double precision |
| Gross receipts L-T-D
|
rec_ltd_chg_d |
double precision |
| Upfront sales tax - base amount
|
upf_bamt_d |
double precision |
| Upfront sales tax - sales tax amount
|
upf_samt_d |
double precision |
| IDC Y-T-D amount - book
|
idc_ytd_d |
double precision |
| IDC Y-T-D amount - tax
|
idc_tax_ytd_d |
double precision |
| Federal AMT Y-T-D amount
|
fed_amt_ytd_d |
double precision |
| Payoff/sale taxable amount
|
pay_tax_amt_d |
double precision |
| Federal AMT book value at payoff
|
amt_pay_d |
double precision |
| Residual income Y-T-D
|
r_in_ytd_d |
double precision |
| Asset residual unearned original
|
unit_r_ue_org_d |
double precision |
| Allow property tax assessment (Y/N)
|
allow_ptx_c |
char (1) |
| Note attached to asset
|
note_s |
char (10) |
| GST vendor payable
|
gst_vendor_payable_d |
double precision |
A/P reduce at commencement
for partial deductions module
|
ap_reduced_comm_d |
double precision |
| Asset disposition date
|
d_disp_s |
datetime |
| Insurance premium cost
|
ins_prem_cost_d |
double precision |
| Depreciation Y-T-D book at payoff
|
ytd_bkd_pay_d |
double precision |
| Depreciation Y-T-D federal at payoff
|
ytd_fed_pay_d |
double precision |
| Depreciation Y-T-D state at payoff
|
ytd_st_pay_d |
double precision |
| Federal AMT Y-T-D at payoff
|
fed_amt_ytd_pay_d |
double precision |
| Change lease key is in progress
|
msi_chg_key_c |
char (1) |
| Property tax basis
|
prop_tax_basis_d |
double precision |
| Warranty
|
warranty_c |
char (1) |
| Title status
|
title_status_s |
char (4) |
| Cancel credit life insurance 1
|
can_cr_lif1_c |
char (1) |
| Cancel credit life insurance 2
|
can_cr_lif2_c |
char (1) |
| Cancel credit disability insurance 1
|
can_cr_dis1_c |
char (1) |
| Cancel credit disability insurance 2
|
can_cr_dis2_c |
char (1) |
| Cancel warranty insurance
|
can_warranty_c |
char (1) |