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