| 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 |
|
|