rhqa Table: Historical Asset 2 for Lease Extension/Reversal
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference

rhqa Table: Historical Asset 2 for Lease Extension/Reversal

Parent Table

Name Description
rhq Historical Asset for Lease Extension/Reversal

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4
rhqa_idx0 lse_s ext_num_s unit_s unique_l


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