| Name | Description | 
|---|---|
| rhq | Historical Asset for Lease Extension/Reversal | 
| Name | Segment 1 | Segment 2 | Segment 3 | Segment 4 | 
|---|---|---|---|---|
| rhqa_idx0 | lse_s | ext_num_s | unit_s | unique_l | 
| Columns | |||
|---|---|---|---|
| Name | Description | Datatype ¿? | Allow Null | 
| lse_s | Lease  | 
char(10) | no | 
| ext_num_s | Extension  | 
char(2) | no | 
| unit_s | Asset  | 
char(10) | no | 
| unique_l | Record number (value is always 1)  | 
integer | no | 
| timestamp | Record modification stamp  | 
timestamp | yes | 
| ger1_s | Additional method of depreciation 1  | 
char(4) | yes | 
| ger2_s | Additional method of depreciation 2  | 
char(4) | yes | 
| ger1_mtd_d | Depreciation M-T-D additional 1  | 
double precision | yes | 
| ger1_ytd_d | Depreciation Y-T-D additional 1  | 
double precision | yes | 
| ger1_ltd_d | Depreciation L-T-D additional 1  | 
double precision | yes | 
| ger2_mtd_d | Depreciation M-T-D additional 2  | 
double precision | yes | 
| ger2_ytd_d | Depreciation Y-T-D additional 2  | 
double precision | yes | 
| ger2_ltd_d | Depreciation L-T-D additional 2  | 
double precision | yes | 
| eq_add2_s | Equipment street address 2  | 
char(36) | yes | 
| sub_dlr_s | Collateral substitution dealer  | 
char(9) | yes | 
| d_sub_s | Collateral substitution date  | 
datetime | yes | 
| sub_miles_l | Collateral substitution mileage  | 
integer | yes | 
| ext_war_mnths_l | Extended warranty months  | 
integer | yes | 
| ext_war_miles_l | Extended warranty miles  | 
integer | yes | 
| war_miles_l | Warranty mileage allowance  | 
integer | yes | 
| days_p_repo_l | Total days in pending repossesion  | 
integer | 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 | 
| lien_hldr_claim_c | Lien holder claim  | 
char(1) | yes | 
| repo_invst_d | Repossesion investments  | 
double precision | yes | 
| repair_d | Repair charges  | 
double precision | yes | 
| beauty_d | App recon charges  | 
double precision | yes | 
| incentive_d | Incentive charges  | 
double precision | yes | 
| transprt_d | Transportation cost  | 
double precision | yes | 
| sale_fee_d | Sales fee charges  | 
double precision | yes | 
| dmv_d | DMV/title charges  | 
double precision | yes | 
| rep_labor_d | Repairs/labor charges  | 
double precision | yes | 
| storage_rec_d | Storage charges recovery  | 
double precision | yes | 
| storage_rem_d | Storage charges remarketing  | 
double precision | yes | 
| other_cr_d | Other credits  | 
double precision | yes | 
| gr_proc_d | Gross proceeds  | 
double precision | yes | 
| pre_gap_d | Pre gap payments due  | 
double precision | yes | 
| perm_st_c | Permanent state status (Y/N)  | 
char(1) | yes | 
| part_num_s | Part number  | 
char(25) | yes | 
| sub_count_l | Number of sub-assets on an asset  | 
integer | yes | 
| d_ins_can_s | Insurance cancellation date  | 
datetime | yes | 
| d_ins_exp_s | Insurance expiration date  | 
datetime | yes | 
| ins_bank_s | Insurance bank code  | 
char(3) | yes | 
| ins_can_s | Insurance cancellation reason  | 
char(4) | yes | 
| ins_unit_c | Insurance asset (Y/N)  | 
char(1) | yes | 
| p_dim_val_d | Diminishing value rate  | 
double precision | yes | 
| p_ins_d | Insurance percentage  | 
double precision | yes | 
| ue_ins_inc_d | Unearned insurance income  | 
double precision | yes | 
| ltd_ins_pay_d | Life-to-date insurance payable  | 
double precision | yes | 
| ltd_ins_com_d | Life-to-date insurance commission  | 
double precision | yes | 
| ltd_ins_inc_d | Life-to-Date insurance income  | 
double precision | yes | 
| ins_pay_refund_d | Refund insurance payable  | 
double precision | yes | 
| ins_com_refund_d | Refund insurance commission  | 
double precision | yes | 
| ins_inc_refund_d | Refund insurance income  | 
double precision | yes | 
| pmt_sch_meth_c | Payment schedule adjustment method A=Amount T=Term  | 
char(1) | yes | 
| prev_ltd_bkd_d | Previous life-to-date depreciation  | 
double precision | yes | 
| prev_taxbasis_d | Previous book depreciation basis  | 
double precision | yes | 
| prev_sal_bkd_d | Previous book salvage value  | 
double precision | yes | 
| depr_chg_l | Depreciation change counter  | 
integer | yes | 
| d_prev_bkd_s | Previous book depreciation start date  | 
datetime | yes | 
| prev_bkd_s | Previous book depreciation method  | 
char(4) | yes | 
| fin_to_oper_c | Changed accounting method from FIN to OPER (Y/N)  | 
char(1) | yes | 
| def_bkd_d | Deferred book depreciation amount  | 
double precision | yes | 
| def_bkd_taken_c | Deferred book depreciation taken N - Not taken D - Taken by depreciation P - Taken by payoff S = Taken by sale of asset  | 
char(1) | yes | 
| lvr_c | Leveraged (Y/N)  | 
char(1) | yes | 
| amt_life_l | AMT depreciation life  | 
integer | yes | 
| fed_life_l | Federal depreciation life  | 
integer | yes | 
| dfrd_tax_ytd_d | Deferred tax YTD amount  | 
double precision | yes | 
| fsc_ytd_d | FSC exclusion Y-T-D amount  | 
double precision | yes | 
| int_expn_ytd_d | Interest expenses Y-T-D amount  | 
double precision | yes | 
| olb_invo_d | Off lease billing invoice/rent amount  | 
double precision | yes | 
| olb_stax_d | Off lease billing sales tax amount  | 
double precision | yes | 
| tax_inc_ytd_d | Taxable income Y-T-D amount  | 
double precision | yes | 
| prev_ytd_fed_amt_d | Previous Y-T-D federal AMT depreciation  | 
double precision | yes | 
| prev_ytd_fed_d | Previous Y-T-D federal depreciation  | 
double precision | yes | 
| prev_ytd_st_d | Previous Y-T-D state depreciation  | 
double precision | yes | 
| opt_res_d | Optional residual  | 
double precision | yes | 
| ptax_exempt_s | Property tax exempt code  | 
char(4) | yes | 
| d_ptax_last_used_s | Property tax last used date  | 
datetime | 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 | 
| d_payoff_quote_s | Payoff quote preparation date  | 
datetime | yes | 
| custom_payoff_quote1_d | Custom payoff quote amount [1]  | 
double precision | yes | 
| custom_payoff_quote2_d | Custom payoff quote amount [2]  | 
double precision | yes | 
| custom_payoff_quote3_d | Custom payoff quote amount [3]  | 
double precision | yes | 
| custom_payoff_quote4_d | Custom payoff quote amount [4]  | 
double precision | yes | 
| custom_payoff_quote5_d | Custom payoff quote amount [5]  | 
double precision | yes | 
| idc_d | Total initial direct costs  | 
double precision | yes | 
| idc_cur_d | IDC current month amortization - book  | 
double precision | yes | 
| idc_rem_d | Unamortized IDC - book  | 
double precision | yes | 
| susp_idc_acc_d | Suspended IDC accrued  | 
double precision | yes | 
| idc1_ins_prem_ue_d | Insurance premium unearned IDC1  | 
double precision | yes | 
| idc1_ins_prem_susp_d | Insurance premium suspended IDC1  | 
double precision | yes | 
| idc1_ins_prem_cur_d | Insurance premium current IDC1  | 
double precision | yes | 
| idc1_ins_prem_ytd_d | Insurance premium year-to-date IDC1  | 
double precision | yes | 
| idc2_notary_fee_d | Notary fee IDC2  | 
double precision | yes | 
| idc2_notary_fee_ue_d | Notary fee unearned IDC2  | 
double precision | yes | 
| idc2_notary_fee_susp_d | Notary fee suspended IDC2  | 
double precision | yes | 
| idc2_notary_fee_cur_d | Notary fee current IDC2  | 
double precision | yes | 
| idc2_notary_fee_ytd_d | Notary fee year-to-date IDC2  | 
double precision | yes | 
| idr1_ins_fee_d | Insurance fee IDR1  | 
double precision | yes | 
| idr1_ins_fee_ue_d | Insurance fee unearned IDR1  | 
double precision | yes | 
| idr1_ins_fee_susp_d | Insurance fee suspended IDR1  | 
double precision | yes | 
| idr1_ins_fee_cur_d | Insurance fee current IDR1  | 
double precision | yes | 
| idr1_ins_fee_ytd_d | Insurance fee year-to-date IDR1  | 
double precision | yes | 
| idr2_reg_fee_d | Registration fee IDR2  | 
double precision | yes | 
| idr2_reg_fee_ue_d | Registration fee unearned IDR2  | 
double precision | yes | 
| idr2_reg_fee_susp_d | Registration fee suspended IDR2  | 
double precision | yes | 
| idr2_reg_fee_cur_d | Registration fee current IDR2  | 
double precision | yes | 
| idr2_reg_fee_ytd_d | Registration fee year-to-date IDR2  | 
double precision | yes | 
| idr3_dlr_subsidy_d | Dealer subsidy IDR3  | 
double precision | yes | 
| idr3_dlr_subsidy_ue_d | Dealer subsidy unearned IDR3  | 
double precision | yes | 
| idr3_dlr_subsidy_susp_d | Dealer subsidy suspended IDR3  | 
double precision | yes | 
| idr3_dlr_subsidy_cur_d | Dealer subsidy current IDR3  | 
double precision | yes | 
| idr3_dlr_subsidy_ytd_d | Dealer subsidy year-to-date IDR3  | 
double precision | yes | 
| idr4_open_comm_d | Open commission IDR4  | 
double precision | yes | 
| idr4_open_comm_ue_d | Open commission unearned IDR4  | 
double precision | yes | 
| idr4_open_comm_susp_d | Open commission suspended IDR4  | 
double precision | yes | 
| idr4_open_comm_cur_d | Open commission current IDR4  | 
double precision | yes | 
| idr4_open_comm_ytd_d | Open commission year-to-date IDR4  | 
double precision | yes | 
| sec_d | Security deposit  | 
double precision | yes | 
| susp_l_acc_d | Suspended lessor income accrued  | 
double precision | yes | 
| l_in_ptd_d | Lessor rental income accrued P-T-D  | 
double precision | yes | 
| l_in_cur_d | Lessor current month rent income  | 
double precision | yes | 
| dp_mly_d | Monthly rental depreciation  | 
double precision | yes | 
| unrec_in_d | Unrecognized operating income  | 
double precision | yes | 
| dfrd_residual_red_d | Deferred residual reduction  | 
double precision | yes | 
| op_bill_adj_d | Operating lease princpal/income adjustment  | 
double precision | yes | 
| payoff_fee_ltd_d | Payoff/termination fee/penalty L-T-D  | 
double precision | yes | 
| d_taxbasis_s | Date of last tax depreciation basis update  | 
datetime | yes | 
| opr_taxbasis_s | Operator who last updated tax depreciation basis  | 
char(3) | yes | 
| lse_act_at_payoff_s | Lease activity status at payoff/termination (ACT code)  | 
char(4) | yes | 
| payoff_st_stax_d | State sales tax in payoff  | 
double precision | yes | 
| payoff_ct_stax_d | County sales tax in payoff  | 
double precision | yes | 
| payoff_cy_stax_d | City sales tax in payoff  | 
double precision | yes | 
| recalc_payoff_stax_rev_c | Recalculate payoff sales tax in reversal (Y/N)  | 
char(1) | yes | 
| last_eoy_year_s | Last year (YYYY) for which Clear YTD Fields has run  | 
char(4) | yes | 
| sal_write_down_loss_d | Salvage value write-down loss  | 
double precision | yes | 
| idc6_d | Dealer bonus IDC6  | 
double precision | yes | 
| idc6_ap_d | Payable amount IDC6  | 
double precision | yes | 
| idc6_pay_to_s | Payable to IDC6  | 
char(9) | yes | 
| idc6_forfeit_d | Forfeit amount IDC6  | 
double precision | yes | 
| idc7_d | Dealer reserve IDC7  | 
double precision | yes | 
| idc7_ap_d | Payable amount IDC7  | 
double precision | yes | 
| idc7_cb_amt_d | Chargeback amount IDC7  | 
double precision | 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 | 
| p_dlr_res_prog_rate_d | Dealer reserve program rate  | 
double precision | yes | 
| p_dlr_res_buy_rate_d | Dealer reserve buy rate  | 
double precision | yes | 
| vtx_taid_s | Vertex tax area id  | 
char(10) | yes | 
| eq_cnty_s | Equipment county  | 
char(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 | 
| pay_txp_s | Payoff/sale tax payment code (TXP code)  | 
char(4) | yes | 
| assmt_tax_cls_s | Assessment tax class (ASM.TAXCLS code)  | 
char(4) | yes | 
| seq_upd_skip_c | Skip during EOP sequential updates (Y/N)  | 
char(1) | yes | 
| paid_off_ck_c | Lease change-keyed after payoff (Y/' ') Y - Lease was change-keyed ' ' - Lease was not change-keyed  | 
char(1) | yes | 
| d_supp_depr_start_s | Supplemental depreciation start date  | 
datetime | yes | 
| d_supp_depr_last_eom_s | Supplemental depreciation last EOM date  | 
datetime | yes | 
| supp_depr_months_l | Number of months to depreciate supplemental  | 
integer | yes | 
| supp_depr_basis_d | Supplemental depreciation basis  | 
double precision | yes | 
| supp_depr_sal_d | Supplemental depreciation salvage value  | 
double precision | yes | 
| supp_depr_accumul_d | Accumulated supplemental depreciation  | 
double precision | yes | 
| supp_depr_mtd_d | Month-to-date supplemental depreciation  | 
double precision | yes | 
| supp_depr_ytd_d | Year-to-date supplemental depreciation  | 
double precision | yes | 
| supp_depr_ltd_d | Life-to-date supplemental depreciation  | 
double precision | yes | 
| acc_pay_tax_d | Accounts payable tax  | 
double precision | yes | 
| idc_asc842_d | Total IDC ASC 842 initial direct cost amount  | 
double precision | yes | 
| idc_asc842_rem_d | Unamortized IDC ASC 842 amount -- book  | 
double precision | yes | 
| idc_asc842_cur_d | IDC ASC 842 current month amortization amount -- book  | 
double precision | yes | 
| idc_asc842_ytd_d | IDC ASC 842 Y-T-D amount -- book  | 
double precision | yes | 
| susp_idc_asc842_acc_d | Suspended IDC ASC 842 accrued  | 
double precision | yes |