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