| Columns |
|---|
| Name |
Description |
Datatype ¿? |
Allow Null |
| unit_s |
Asset |
|
|
| app_s |
Application |
|
|
|
Record modification stamp |
|
|
| id_s |
Asset identification |
|
|
| dlr_s |
Vendor |
|
|
| pur_ord_s |
Purchase order number |
|
|
| d_acq_s |
Equipment acquisition date |
|
|
| d_act_s |
Ownership certificate activity date |
|
|
| d_fhut_s |
FHUT date of first use |
|
|
| d_serv_s |
In-service date |
|
|
| d_insp_s |
Inspection date |
|
|
| d_bok_s |
Book depreciation start date |
|
|
| d_po_s |
P.O. date |
|
|
| cls_s |
Class (CLASS code) |
|
|
| itc_s |
ITC take/bypass code |
|
|
| etc_s |
ETC take/bypass code |
|
|
| 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) |
|
|
| hw_s |
Federal highway use tax code |
|
|
| fed_amt_s |
Federal AMT method |
|
|
| itc_meth_s |
ITC accrual method |
|
|
| 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 |
|
|
| eqt_stat_s |
Asset status |
|
|
| tax_ent_s |
CCA tax entity |
|
|
| cca_cls_s |
CCA class |
|
|
| cca_acc_s |
CCA accrual method |
|
|
| cca_disp_s |
CCA disposition method |
|
|
| new_c |
New/used (N/U) |
|
|
| war_c |
Warranty insurance (Y/N) |
|
|
| res_ins_c |
Residual insurance (Y/N) |
|
|
| rpt_ptax_c |
Report property tax (Y/N) |
|
|
| tax_rptg_c |
Asset appears on tax reports (Y/N) |
|
|
| upf_stax_c |
Upfront sales tax (Y/N) |
|
|
| copt_c |
Auto options at lease commencement (Y/N) |
|
|
| ass_typ_c |
CCA asset type
L - Specified leasing property
O - Separate class
P - Asset in a pool
' ' - When CCA module not purchased |
|
|
| 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 |
|
|
| asset_s |
Associated asset |
|
|
| 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 |
|
|
| codm_l |
Odometer reading at lease commencement |
|
|
| weight_l |
FHUT asset weight (pounds) |
|
|
| mil_aam_l |
Average yearly allowable mileage |
|
|
| upf_strt_d |
Upfront sales tax - state rate |
|
|
| upf_ctrt_d |
Upfront sales tax - county rate |
|
|
| upf_cyrt_d |
Upfront sales tax - city rate |
|
|
| p_con_unit_d |
Asset yield |
|
|
| p_cca_addon_d |
CCA add-on rate
For types L, O |
|
|
| org_d |
Original acquisition cost |
|
|
| other_d |
Other charges |
|
|
| res_d |
Residual amount |
|
|
| lst_d |
List price |
|
|
| lic_d |
License fees |
|
|
| pre_d |
Warranty insurance premium |
|
|
| rep_d |
Repair cost |
|
|
| gas_d |
Gas cost |
|
|
| sal_bkd_d |
Book value salvage value |
|
|
| sal_st_d |
State salvage value |
|
|
| bk_basis_d |
Book tax basis |
|
|
| man_bas_d |
Manufacturer's depreciation basis |
|
|
| pmt_amt_d |
Asset payment amount |
|
|
| ast_cst_d |
Original asset cost |
|
|
| upf_bamt_d |
Upfront sales tax - base amount |
|
|
| upf_samt_d |
Upfront sales tax - sales tax amount |
|
|
| gst_vendor_payable_d |
GST vendor payable pending |
|
|
| cap_cost_d |
CCA capital cost |
|
|
| cca_itc_d |
CCA ITC (investment tax credit) |
|
|
| ins_prem_cost_d |
Insurance premium cost |
|
|
| 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 |
|
|
| eq_add2_s |
Equipment street address 2 |
|
|
| ger1_s |
Additional method of depreciation 1 |
|
|
| ger2_s |
Additional method of depreciation 2 |
|
|
| war_miles_l |
Warranty mileage allowance |
|
|
| color_s |
Vehicle color |
|
|
| cd_key_s |
Manufacturers key code |
|
|
| lic_st_s |
State of license plate issue |
|
|
| taxbasis_d |
Starting book value for depreciation |
|
|
| sub_count_l |
Number of sub-assets on an asset |
|
|
| part_num_s |
Part number |
|
|
| d_ins_exp_s |
Insurance expiration date |
|
|
| ins_unit_c |
Insurance asset (Y/N) |
|
|
| p_dim_val_d |
Diminishing value rate |
|
|
| lvr_c |
Leveraged (Y/N) |
|
|
| amt_life_l |
AMT depreciation life |
|
|
| fed_life_l |
Federal depreciation life |
|
|
| opt_res_d |
Optional residual |
|
|
| ptax_exempt_s |
Property tax exempt code |
|
|
| d_ptax_last_used_s |
Property tax last used date |
|
|
| stax_exempt_s |
Sales/use tax exempt code |
|
|
| utilize_veh_tax_rates_c |
Utilize vehicle tax rates (Y/N) |
|
|
| rec_d |
Contract receivable |
|
|
| idc_d |
Total initial direct costs |
|
|
| idc_rem_d |
Unamortized IDC - book |
|
|
| idc1_ins_prem_ue_d |
Insurance premium unearned IDC1 |
|
|
| idc1_ins_prem_susp_d |
Insurance premium suspended IDC1 |
|
|
| idc2_notary_fee_d |
Notary fee IDC2 |
|
|
| idc2_notary_fee_ue_d |
Notary fee unearned IDC2 |
|
|
| idc2_notary_fee_susp_d |
Notary fee suspended IDC2 |
|
|
| idr1_ins_fee_d |
Insurance fee IDR1 |
|
|
| idr1_ins_fee_ue_d |
Insurance fee unearned IDR1 |
|
|
| idr1_ins_fee_susp_d |
Insurance fee suspended IDR1 |
|
|
| idr2_reg_fee_d |
Registration fee IDR2 |
|
|
| idr2_reg_fee_ue_d |
Registration fee unearned IDR2 |
|
|
| idr2_reg_fee_susp_d |
Registration fee suspended IDR2 |
|
|
| idr3_dlr_subsidy_d |
Dealer subsidy IDR3 |
|
|
| idr3_dlr_subsidy_ue_d |
Dealer subsidy unearned IDR3 |
|
|
| idr3_dlr_subsidy_susp_d |
Dealer subsidy suspended IDR3 |
|
|
| idr4_open_comm_d |
Open commission IDR4 |
|
|
| idr4_open_comm_ue_d |
Open commission unearned IDR4 |
|
|
| idr4_open_comm_susp_d |
Open commission suspended IDR4 |
|
|
| sec_d |
Security deposit |
|
|
| l_ue_d |
Lessor unearned rental income |
|
|
| l_ue_org_d |
Lessor orig unearned rental income |
|
|
| l_in_ptd_d |
Lessor rental income accrued P-T-D |
|
|
| l_in_cur_d |
Lessor current month rent income |
|
|
| susp_l_acc_d |
Suspended lessor income accrued |
|
|
| prn_d |
Accrued principal |
|
|
| dp_mly_d |
Monthly rental depreciation |
|
|
| unrec_in_d |
Unrecognized operating income |
|
|
| idc6_d |
Dealer bonus IDC6 |
|
|
| idc6_pay_to_s |
Payable to IDC6 |
|
|
| idc7_pay_to_s |
Payable to IDC7 |
|
|
| idc7_dlr_plan_s |
Dealer reserve plan code IDC7 (RDP.DLR_PLAN_S code) |
|
|
| dlr_res_promo_s |
Dealer reserve promotion number |
|
|
| idc7_d |
Dealer reserve IDC7 |
|
|
| p_dlr_res_prog_rate_d |
Dealer reserve program rate |
|
|
| p_dlr_res_buy_rate_d |
Dealer reserve buy rate |
|
|
| vtx_taid_s |
Vertex tax area id |
|
|
| eq_cnty_s |
Equipment county |
|
|
| tax_pmt_typ_s |
Tax payment type (ST/UC/UR)
ST - Stream
UC - Upfront cost
UR - Upfront rentals |
|
|
| upf_ao_dlr_s |
Upfront sales tax admin origin - vendor number |
|
|
| assmt_tax_cls_s |
Assessment tax class (ASM.TAXCLS code) |
|
|
| d_supp_depr_start_s |
Supplemental depreciation start date |
|
|
| supp_depr_basis_d |
Supplemental depreciation basis |
|
|
| supp_depr_sal_d |
Supplemental depreciation salvage value |
|
|
| idc_asc842_d |
Total IDC ASC 842 initial direct cost amount |
|
|
| idc_asc842_rem_d |
Unamortized IDC ASC 842 amount -- book |
|
|
| st_rate_d |
State tax rate |
|
|
| ct_rate_d |
County tax rate |
|
|
| cy_rate_d |
City tax rate |
|
|
DBMS Platform Selector |
Database Reference |
LeasePak Database Objects |
Data Model |
Additional Information