| Name | Description | 
|---|---|
| reqa | Asset 2 | 
| reqc | Asset Condition | 
| reqp | Asset Payment Schedule | 
| requ | Asset UCC | 
| Name | Segment 1 | Segment 2 | Segment 3 | Segment 4 | Segment 5 | Segment 6 | 
|---|---|---|---|---|---|---|
| req_idx0 | por_s | com_s | reg_s | off_s | lse_s | unit_s | 
| req_idx1 | unit_s | |||||
| req_idx2 | id_s | unit_s | ||||
| req_idx3 | pur_ord_s | unit_s | ||||
| req_idx4 | dlr_s | unit_s | ||||
| req_idx5 | app_s | unit_s | ||||
| req_spec1_idx | lse_s | unit_s | 
| 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 | 
| timestamp | Record modification stamp  | 
timestamp | yes | 
| 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  | 
datetime | yes | 
| d_act_s | Ownership certificate activity date  | 
datetime | yes | 
| d_fhut_s | FHUT date of first use  | 
datetime | yes | 
| d_boo_s | System booking date  | 
datetime | yes | 
| d_eqt_s | Equipment activity status date  | 
datetime | yes | 
| d_serv_s | In-service date  | 
datetime | yes | 
| d_insp_s | Inspection date  | 
datetime | yes | 
| d_bok_s | Book depreciation start date  | 
datetime | yes | 
| d_itc_s | ITC accrued to date  | 
datetime | yes | 
| d_addon_s | Add-on date  | 
datetime | yes | 
| d_po_s | P.O. date  | 
datetime | yes | 
| d_cor_s | Correction sent date  | 
datetime | yes | 
| d_lien_s | Last lien date  | 
datetime | 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)  | 
char(30) | yes | 
| topt_c | Auto options at lease termination (Y/N)  | 
char(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  | 
char(36) | yes | 
| eq_cty_s | Equipment city  | 
char(25) | yes | 
| eq_st_s | Equipment state  | 
char(2) | yes | 
| eq_zip_s | Equipment zip  | 
char(9) | yes | 
| desc_s | Equipment description  | 
char(36) | yes | 
| opr_nam_s | Operator name  | 
char(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  | 
char(36) | yes | 
| sup_nam_s | Supplier name  | 
char(36) | yes | 
| sup_add_s | Supplier address  | 
char(36) | yes | 
| sup_add2_s | Supplier address 2  | 
char(36) | yes | 
| sup_cty_s | Supplier city  | 
char(25) | yes | 
| sup_st_s | Supplier state  | 
char(2) | yes | 
| sup_zip_s | Supplier zip  | 
char(9) | yes | 
| bun_s | DMV bundle number  | 
char(25) | yes | 
| snum_s | DMV suspense receipt number  | 
char(25) | yes | 
| adj_depr_life_l | Adjustment depreciable life  | 
integer | yes | 
| codm_l | Odometer reading at lease commencement  | 
integer | yes | 
| todm_l | Odometer reading at lease termination  | 
integer | yes | 
| weight_l | FHUT asset weight (pounds)  | 
integer | yes | 
| mil_aam_l | Average yearly allowable mileage  | 
integer | yes | 
| p_sch_d | Percentage of schedule amount  | 
double precision | yes | 
| p_con_unit_d | Asset yield  | 
double precision | yes | 
| upf_strt_d | Upfront sales tax - state rate  | 
double precision | yes | 
| upf_ctrt_d | Upfront sales tax - county rate  | 
double precision | yes | 
| upf_cyrt_d | Upfront sales tax - city rate  | 
double precision | yes | 
| pay_st_rate_d | Payoff/sale state rate  | 
double precision | yes | 
| pay_ct_rate_d | Payoff/sale county rate  | 
double precision | yes | 
| pay_cy_rate_d | Payoff/sale city rate  | 
double precision | yes | 
| st_rate_d | State tax rate  | 
double precision | yes | 
| ct_rate_d | County tax rate  | 
double precision | yes | 
| cy_rate_d | City tax rate  | 
double precision | yes | 
| tax_d | Portfolio tax rate  | 
double precision | yes | 
| org_d | Original acquisition cost  | 
double precision | yes | 
| other_d | Other charges  | 
double precision | yes | 
| res_d | Residual amount  | 
double precision | yes | 
| strt_d | Starting asset cost  | 
double precision | yes | 
| inven_d | Inventoried value  | 
double precision | yes | 
| acc_pay_d | Accounts payable  | 
double precision | yes | 
| lst_d | List price  | 
double precision | yes | 
| lic_d | License fees  | 
double precision | yes | 
| pre_d | Warranty insurance premium  | 
double precision | yes | 
| rep_d | Repair cost  | 
double precision | yes | 
| gas_d | Gas cost  | 
double precision | yes | 
| rec_ytd_gross_d | Gross receipts Y-T-D  | 
double precision | yes | 
| unit_rec_ltd_d | Asset change in L-T-D receipts  | 
double precision | yes | 
| oth_ytd_d | Other income Y-T-D  | 
double precision | yes | 
| oth_ltd_d | Other income L-T-D  | 
double precision | yes | 
| taxbasis_d | Starting book value for depreciation  | 
double precision | yes | 
| itcbasis_d | Starting book value for ITC  | 
double precision | yes | 
| sal_bkd_d | Book value salvage value  | 
double precision | yes | 
| sal_st_d | State salvage value  | 
double precision | yes | 
| mtd_bkd_d | Depreciation M-T-D book  | 
double precision | yes | 
| ytd_bkd_d | Depreciation Y-T-D book  | 
double precision | yes | 
| ltd_bkd_d | Depreciation L-T-D book  | 
double precision | yes | 
| mtd_fed_d | Depreciation M-T-D federal  | 
double precision | yes | 
| ytd_fed_d | Depreciation Y-T-D federal  | 
double precision | yes | 
| ltd_fed_d | Depreciation L-T-D federal  | 
double precision | yes | 
| mtd_st_d | Depreciation M-T-D state  | 
double precision | yes | 
| ytd_st_d | Depreciation Y-T-D state  | 
double precision | yes | 
| ltd_st_d | Depreciation L-T-D state  | 
double precision | yes | 
| org_bkd_ltd_d | Original L-T-D book depreciation  | 
double precision | yes | 
| itc_org_d | Original ITC  | 
double precision | yes | 
| itc_sus_d | ITC sustained  | 
double precision | yes | 
| itc_mtd_d | ITC M-T-D  | 
double precision | yes | 
| itc_ytd_d | ITC Y-T-D  | 
double precision | yes | 
| itc_ltd_d | ITC L-T-D  | 
double precision | yes | 
| etc_mtd_d | ETC M-T-D  | 
double precision | yes | 
| etc_ytd_d | ETC Y-T-D  | 
double precision | yes | 
| etc_ltd_d | ETC L-T-D  | 
double precision | yes | 
| nbv_pay_d | Net book value at payoff/termination  | 
double precision | yes | 
| ytd_loss_d | Y-T-D loss on termination  | 
double precision | yes | 
| ytd_gain_d | Y-T-D gain on termination  | 
double precision | yes | 
| std_pay_d | State book value at payoff  | 
double precision | yes | 
| fed_pay_d | Federal book value at payoff  | 
double precision | yes | 
| res_pay_d | Residual at payoff  | 
double precision | yes | 
| strt_pay_d | Starting cost at payoff  | 
double precision | yes | 
| asm_pay_d | Assessments outstanding for payoff  | 
double precision | yes | 
| pmt_pay_d | Payments outstanding for payoff  | 
double precision | yes | 
| unit_rec_d | Asset receivable  | 
double precision | yes | 
| chg_rec_d | Asset change in receivable  | 
double precision | yes | 
| unit_prn_d | Asset principal  | 
double precision | yes | 
| unit_l_ue_d | Asset lessor unearned  | 
double precision | yes | 
| d_ue_d | Asset vendor unearned  | 
double precision | yes | 
| unit_i_ue_d | Asset investor unearned  | 
double precision | yes | 
| unit_l_ue_org_d | Asset lessor unearned original  | 
double precision | yes | 
| d_ue_org_d | Asset vendor unearned original  | 
double precision | yes | 
| unit_i_ue_org_d | Asset investor unearned original  | 
double precision | yes | 
| sch_basis_d | Schedule percentage basis  | 
double precision | yes | 
| fed_amt_ltd_d | Federal AMT L-T-D amount  | 
double precision | yes | 
| bk_basis_d | Book tax basis  | 
double precision | yes | 
| itc_org_ue_d | Original ITC unearned  | 
double precision | yes | 
| itc_cur_ue_d | Current ITC unearned  | 
double precision | yes | 
| itc_in_ytd_d | ITC income Y-T-D  | 
double precision | yes | 
| itc_in_cur_d | ITC current month income  | 
double precision | yes | 
| man_bas_d | Manufacturer's depreciation basis  | 
double precision | yes | 
| pmt_acc_d | Payment amount accrued Y-T-D  | 
double precision | yes | 
| pmt_amt_d | Asset payment amount  | 
double precision | yes | 
| l_in_ytd_d | Lessor income Y-T-D  | 
double precision | yes | 
| ast_cst_d | Original asset cost  | 
double precision | yes | 
| org_bk_basis_d | Original book basis  | 
double precision | yes | 
| adj_bk_basis_d | Adjustment to book basis  | 
double precision | yes | 
| unit_r_ue_d | Asset unearned residual  | 
double precision | yes | 
| rec_ytd_chg_d | Asset change in Y-T-D receipts  | 
double precision | yes | 
| etc_org_d | ETC original total  | 
double precision | yes | 
| upf_bamt_d | Upfront sales tax - base amount  | 
double precision | yes | 
| upf_samt_d | Upfront sales tax - sales tax amount  | 
double precision | yes | 
| idc_ytd_d | IDC Y-T-D amount - book  | 
double precision | yes | 
| idc_tax_ytd_d | IDC Y-T-D amount - tax  | 
double precision | yes | 
| fed_amt_ytd_d | Federal AMT Y-T-D amount  | 
double precision | yes | 
| pay_tax_amt_d | Payoff/sale taxable amount  | 
double precision | yes | 
| amt_pay_d | Federal AMT book value at payoff  | 
double precision | yes | 
| r_in_ytd_d | Residual income Y-T-D  | 
double precision | yes | 
| unit_r_ue_org_d | Asset original unearned residual  | 
double precision | 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  | 
double precision | yes | 
| ap_reduced_comm_d | A/P reduce at commencement for partial deductions module  | 
double precision | yes | 
| d_disp_s | Asset disposition date  | 
datetime | yes | 
| ins_prem_cost_d | Insurance premium cost  | 
double precision | yes | 
| ytd_bkd_pay_d | Depreciation Y-T-D book at payoff  | 
double precision | yes | 
| ytd_fed_pay_d | Depreciation Y-T-D federal at payoff  | 
double precision | yes | 
| ytd_st_pay_d | Depreciation Y-T-D state at payoff  | 
double precision | yes | 
| fed_amt_ytd_pay_d | Federal AMT Y-T-D at payoff  | 
double precision | yes | 
| msi_chg_key_c | Change lease key is in progress  | 
char(1) | yes | 
| prop_tax_basis_d | Property tax basis  | 
double precision | 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 |