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 |