| Columns |
| Name |
Description |
Datatype ¿? |
Allow Null |
| por_s |
Portfolio |
CHAR(2) |
no |
| com_s |
Company |
CHAR(2) |
no |
| reg_s |
Region |
CHAR(2) |
no |
| off_s |
Office |
CHAR(3) |
no |
| lse_s |
Lease |
CHAR(10) |
no |
| unit_s |
Asset |
CHAR(10) |
no |
| stamp_l |
Record modification stamp |
NUMBER(10) |
no |
| id_s |
Asset identification |
CHAR(25) |
no |
| pur_ord_s |
Purchase order number |
CHAR(25) |
no |
| dlr_s |
Vendor |
CHAR(9) |
no |
| app_s |
Application |
CHAR(10) |
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_boo_s |
System booking date |
DATE |
yes |
| d_eqt_s |
Equipment activity status date |
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_itc_s |
ITC accrued to date |
DATE |
yes |
| d_addon_s |
Add-on date |
DATE |
yes |
| d_po_s |
P.O. date |
DATE |
yes |
| d_cor_s |
Correction sent date |
DATE |
yes |
| d_lien_s |
Last lien 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 |
| txb_s |
Tax benefit owner code |
CHAR(4) |
yes |
| eqt_s |
Equipment activity status |
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 |
| co_s |
Ownership certificate code |
CHAR(4) |
yes |
| hw_s |
Federal highway use tax code |
CHAR(4) |
yes |
| eqt_pay_s |
Equipment status at payoff |
CHAR(4) |
yes |
| fed_amt_s |
Federal AMT method |
CHAR(4) |
yes |
| itc_meth_s |
ITC accrual method |
CHAR(4) |
yes |
| eqt_stat_s |
Asset status |
CHAR(4) |
yes |
| eqt_inv_s |
Activity status prior to booking |
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 |
| corr_s |
Required correction code |
CHAR(4) |
yes |
| pay_st_s |
Payoff/sale state location code |
CHAR(2) |
yes |
| pay_ct_s |
Payoff/sale county location code |
CHAR(4) |
yes |
| pay_cy_s |
Payoff/sale city location code |
CHAR(4) |
yes |
| pay_meth_s |
Asset payoff method |
CHAR(4) |
yes |
| new_c |
New/used (N/U) |
CHAR(1) |
yes |
| copt_c |
Auto options at lease commencement (Y/N) |
VARCHAR2(30) |
yes |
| topt_c |
Auto options at lease termination (Y/N) |
VARCHAR2(30) |
yes |
| war_c |
Warranty insurance (Y/N) |
CHAR(1) |
yes |
| res_ins_c |
Residual insurance (Y/N) |
CHAR(1) |
yes |
| unt_pay_c |
An asset payoff was done (Y/N) |
CHAR(1) |
yes |
| off_c |
Off-lease (Y/N) |
CHAR(1) |
yes |
| rpt_ptax_c |
Report property tax (Y/N) |
CHAR(1) |
yes |
| pre_inv_c |
Pre-inventory (Y/N) |
CHAR(1) |
yes |
| tax_rptg_c |
Asset appears on tax reports (Y/N) |
CHAR(1) |
yes |
| term_rev_c |
Allow termination reversal (Y/N) |
CHAR(1) |
yes |
| gp_typ_c |
Gross profit type (R/U)
R - related
U - unrelated |
CHAR(1) |
yes |
| upf_stax_c |
Upfront sales tax (Y/N) |
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 |
| nxt_ln_s |
Next asset in loan |
CHAR(10) |
yes |
| prv_ln_s |
Previous asset in loan |
CHAR(10) |
yes |
| frst_loan_s |
First loan for asset |
CHAR(11) |
yes |
| last_loan_s |
Last loan for asset |
CHAR(11) |
yes |
| cashier_chk_s |
Cashier's check number |
CHAR(6) |
yes |
| sus_s |
Suspense item number written |
CHAR(6) |
yes |
| sus_clr_s |
Suspense item number cleared |
CHAR(6) |
yes |
| asset_s |
Associated asset |
CHAR(10) |
yes |
| ini_cur_s |
Clerk when asset removed from collateral tracking |
CHAR(3) |
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 |
| bun_s |
DMV bundle number |
VARCHAR2(25) |
yes |
| snum_s |
DMV suspense receipt number |
VARCHAR2(25) |
yes |
| adj_depr_life_l |
Adjustment depreciable life |
NUMBER(10) |
yes |
| codm_l |
Odometer reading at lease commencement |
NUMBER(10) |
yes |
| todm_l |
Odometer reading at lease termination |
NUMBER(10) |
yes |
| weight_l |
FHUT asset weight (pounds) |
NUMBER(10) |
yes |
| mil_aam_l |
Average yearly allowable mileage |
NUMBER(10) |
yes |
| p_sch_d |
Percentage of schedule amount |
NUMBER(15,5) |
yes |
| p_con_unit_d |
Asset yield |
NUMBER(15,7) |
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 |
| pay_st_rate_d |
Payoff/sale state rate |
NUMBER(15,5) |
yes |
| pay_ct_rate_d |
Payoff/sale county rate |
NUMBER(15,5) |
yes |
| pay_cy_rate_d |
Payoff/sale city rate |
NUMBER(15,5) |
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 |
| tax_d |
Portfolio tax rate |
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 |
| strt_d |
Starting asset cost |
NUMBER(15,2) |
yes |
| inven_d |
Inventoried value |
NUMBER(15,2) |
yes |
| acc_pay_d |
Accounts payable |
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 |
| rec_ytd_gross_d |
Gross receipts Y-T-D |
NUMBER(15,2) |
yes |
| unit_rec_ltd_d |
Asset change in L-T-D receipts |
NUMBER(15,2) |
yes |
| oth_ytd_d |
Other income Y-T-D |
NUMBER(15,2) |
yes |
| oth_ltd_d |
Other income L-T-D |
NUMBER(15,2) |
yes |
| taxbasis_d |
Starting book value for depreciation |
NUMBER(15,2) |
yes |
| itcbasis_d |
Starting book value for ITC |
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 |
| mtd_bkd_d |
Depreciation M-T-D book |
NUMBER(15,2) |
yes |
| ytd_bkd_d |
Depreciation Y-T-D book |
NUMBER(15,2) |
yes |
| ltd_bkd_d |
Depreciation L-T-D book |
NUMBER(15,2) |
yes |
| mtd_fed_d |
Depreciation M-T-D federal |
NUMBER(15,2) |
yes |
| ytd_fed_d |
Depreciation Y-T-D federal |
NUMBER(15,2) |
yes |
| ltd_fed_d |
Depreciation L-T-D federal |
NUMBER(15,2) |
yes |
| mtd_st_d |
Depreciation M-T-D state |
NUMBER(15,2) |
yes |
| ytd_st_d |
Depreciation Y-T-D state |
NUMBER(15,2) |
yes |
| ltd_st_d |
Depreciation L-T-D state |
NUMBER(15,2) |
yes |
| org_bkd_ltd_d |
Original L-T-D book depreciation |
NUMBER(15,2) |
yes |
| itc_org_d |
Original ITC |
NUMBER(15,2) |
yes |
| itc_sus_d |
ITC sustained |
NUMBER(15,2) |
yes |
| itc_mtd_d |
ITC M-T-D |
NUMBER(15,2) |
yes |
| itc_ytd_d |
ITC Y-T-D |
NUMBER(15,2) |
yes |
| itc_ltd_d |
ITC L-T-D |
NUMBER(15,2) |
yes |
| etc_mtd_d |
ETC M-T-D |
NUMBER(15,2) |
yes |
| etc_ytd_d |
ETC Y-T-D |
NUMBER(15,2) |
yes |
| etc_ltd_d |
ETC L-T-D |
NUMBER(15,2) |
yes |
| nbv_pay_d |
Net book value at payoff/termination |
NUMBER(15,2) |
yes |
| ytd_loss_d |
Y-T-D loss on termination |
NUMBER(15,2) |
yes |
| ytd_gain_d |
Y-T-D gain on termination |
NUMBER(15,2) |
yes |
| std_pay_d |
State book value at payoff |
NUMBER(15,2) |
yes |
| fed_pay_d |
Federal book value at payoff |
NUMBER(15,2) |
yes |
| res_pay_d |
Residual at payoff |
NUMBER(15,2) |
yes |
| strt_pay_d |
Starting cost at payoff |
NUMBER(15,2) |
yes |
| asm_pay_d |
Assessments outstanding for payoff |
NUMBER(15,2) |
yes |
| pmt_pay_d |
Payments outstanding for payoff |
NUMBER(15,2) |
yes |
| unit_rec_d |
Asset receivable |
NUMBER(15,2) |
yes |
| chg_rec_d |
Asset change in receivable |
NUMBER(15,2) |
yes |
| unit_prn_d |
Asset principal |
NUMBER(15,2) |
yes |
| unit_l_ue_d |
Asset lessor unearned |
NUMBER(15,2) |
yes |
| d_ue_d |
Asset vendor unearned |
NUMBER(15,2) |
yes |
| unit_i_ue_d |
Asset investor unearned |
NUMBER(15,2) |
yes |
| unit_l_ue_org_d |
Asset lessor unearned original |
NUMBER(15,2) |
yes |
| d_ue_org_d |
Asset vendor unearned original |
NUMBER(15,2) |
yes |
| unit_i_ue_org_d |
Asset investor unearned original |
NUMBER(15,2) |
yes |
| sch_basis_d |
Schedule percentage basis |
NUMBER(15,2) |
yes |
| fed_amt_ltd_d |
Federal AMT L-T-D amount |
NUMBER(15,2) |
yes |
| bk_basis_d |
Book tax basis |
NUMBER(15,2) |
yes |
| itc_org_ue_d |
Original ITC unearned |
NUMBER(15,2) |
yes |
| itc_cur_ue_d |
Current ITC unearned |
NUMBER(15,2) |
yes |
| itc_in_ytd_d |
ITC income Y-T-D |
NUMBER(15,2) |
yes |
| itc_in_cur_d |
ITC current month income |
NUMBER(15,2) |
yes |
| man_bas_d |
Manufacturer's depreciation basis |
NUMBER(15,2) |
yes |
| pmt_acc_d |
Payment amount accrued Y-T-D |
NUMBER(15,2) |
yes |
| pmt_amt_d |
Asset payment amount |
NUMBER(15,2) |
yes |
| l_in_ytd_d |
Lessor income Y-T-D |
NUMBER(15,2) |
yes |
| ast_cst_d |
Original asset cost |
NUMBER(15,2) |
yes |
| org_bk_basis_d |
Original book basis |
NUMBER(15,2) |
yes |
| adj_bk_basis_d |
Adjustment to book basis |
NUMBER(15,2) |
yes |
| unit_r_ue_d |
Asset unearned residual |
NUMBER(15,2) |
yes |
| rec_ytd_chg_d |
Asset change in Y-T-D receipts |
NUMBER(15,2) |
yes |
| etc_org_d |
ETC original total |
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 |
| idc_ytd_d |
IDC Y-T-D amount - book |
NUMBER(15,2) |
yes |
| idc_tax_ytd_d |
IDC Y-T-D amount - tax |
NUMBER(15,2) |
yes |
| fed_amt_ytd_d |
Federal AMT Y-T-D amount |
NUMBER(15,2) |
yes |
| pay_tax_amt_d |
Payoff/sale taxable amount |
NUMBER(15,2) |
yes |
| amt_pay_d |
Federal AMT book value at payoff |
NUMBER(15,2) |
yes |
| r_in_ytd_d |
Residual income Y-T-D |
NUMBER(15,2) |
yes |
| unit_r_ue_org_d |
Asset original unearned residual |
NUMBER(15,2) |
yes |
| allow_ptx_c |
Allow property tax assessment (Y/N) |
CHAR(1) |
yes |
| note_s |
Note attached to asset |
CHAR(10) |
yes |
| gst_vendor_payable_d |
GST vendor payable |
NUMBER(15,2) |
yes |
| ap_reduced_comm_d |
A/P reduce at commencement
for partial deductions module |
NUMBER(15,2) |
yes |
| d_disp_s |
Asset disposition date |
DATE |
yes |
| ins_prem_cost_d |
Insurance premium cost |
NUMBER(15,2) |
yes |
| ytd_bkd_pay_d |
Depreciation Y-T-D book at payoff |
NUMBER(15,2) |
yes |
| ytd_fed_pay_d |
Depreciation Y-T-D federal at payoff |
NUMBER(15,2) |
yes |
| ytd_st_pay_d |
Depreciation Y-T-D state at payoff |
NUMBER(15,2) |
yes |
| fed_amt_ytd_pay_d |
Federal AMT Y-T-D at payoff |
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 |
| can_cr_lif1_c |
Cancel credit life insurance 1 |
CHAR(1) |
yes |
| can_cr_lif2_c |
Cancel credit life insurance 2 |
CHAR(1) |
yes |
| can_cr_dis1_c |
Cancel credit disability insurance 1 |
CHAR(1) |
yes |
| can_cr_dis2_c |
Cancel credit disability insurance 2 |
CHAR(1) |
yes |
| can_warranty_c |
Cancel warranty insurance |
CHAR(1) |
yes |