| Name | Segment 1 | Segment 2 | Segment 3 |
|---|---|---|---|
| rhq_idx0 | lse_s | ext_num_s | unit_s |
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null |
| ext_num_s | Extension |
char(2) | no |
| por_s | Portfolio |
char(2) | yes |
| com_s | Company |
char(2) | yes |
| reg_s | Region |
char(2) | yes |
| off_s | Office |
char(3) | yes |
| lse_s | Lease |
char(10) | no |
| unit_s | Asset |
char(10) | no |
| timestamp | Record modification stamp |
timestamp | yes |
| id_s | Asset identification |
char(25) | yes |
| pur_ord_s | Purchase order number |
char(25) | yes |
| dlr_s | Vendor |
char(9) | yes |
| app_s | Application |
char(10) | yes |
| 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 |