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