reqa Table: Asset 2
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

reqa Table: Asset 2

Parent Table

Name Description
req Asset

Indexes

Name Segment 1 Segment 2
reqa_idx0 unit_s unique_l

     
Columns
Name DescriptionDatatype ¿? Allow Null
unit_s
Asset
CHAR(10) no
unique_l
Record number (value is always 1)
NUMBER(10) no
stamp_l
Record modification stamp
NUMBER(10) no
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
NUMBER(15,2) yes
ger1_ytd_d
Depreciation Y-T-D additional 1
NUMBER(15,2) yes
ger1_ltd_d
Depreciation L-T-D additional 1
NUMBER(15,2) yes
ger2_mtd_d
Depreciation M-T-D additional 2
NUMBER(15,2) yes
ger2_ytd_d
Depreciation Y-T-D additional 2
NUMBER(15,2) yes
ger2_ltd_d
Depreciation L-T-D additional 2
NUMBER(15,2) yes
eq_add2_s
Equipment street address 2
VARCHAR2(36) yes
sub_dlr_s
Collateral substitution dealer
CHAR(9) yes
d_sub_s
Collateral substitution date
DATE yes
sub_miles_l
Collateral substitution mileage
NUMBER(10) yes
ext_war_mnths_l
Extended warranty months
NUMBER(10) yes
ext_war_miles_l
Extended warranty miles
NUMBER(10) yes
war_miles_l
Warranty mileage allowance
NUMBER(10) yes
days_p_repo_l
Total days in pending repossesion
NUMBER(10) 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
NUMBER(15,2) yes
repair_d
Repair charges
NUMBER(15,2) yes
beauty_d
App recon charges
NUMBER(15,2) yes
incentive_d
Incentive charges
NUMBER(15,2) yes
transprt_d
Transportation cost
NUMBER(15,2) yes
sale_fee_d
Sales fee charges
NUMBER(15,2) yes
dmv_d
DMV/title charges
NUMBER(15,2) yes
rep_labor_d
Repairs/labor charges
NUMBER(15,2) yes
storage_rec_d
Storage charges recovery
NUMBER(15,2) yes
storage_rem_d
Storage charges remarketing
NUMBER(15,2) yes
other_cr_d
Other credits
NUMBER(15,2) yes
gr_proc_d
Gross proceeds
NUMBER(15,2) yes
pre_gap_d
Pre gap payments due
NUMBER(15,2) yes
perm_st_c
Permanent state status (Y/N)
CHAR(1) yes
part_num_s
Part number
VARCHAR2(25) yes
sub_count_l
Number of sub-assets on an asset
NUMBER(10) yes
d_ins_can_s
Insurance cancellation date
DATE yes
d_ins_exp_s
Insurance expiration date
DATE 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
NUMBER(15,5) yes
p_ins_d
Insurance percentage
NUMBER(15,5) yes
ue_ins_inc_d
Unearned insurance income
NUMBER(15,2) yes
ltd_ins_pay_d
Life-to-date insurance payable
NUMBER(15,2) yes
ltd_ins_com_d
Life-to-date insurance commission
NUMBER(15,2) yes
ltd_ins_inc_d
Life-to-Date insurance income
NUMBER(15,2) yes
ins_pay_refund_d
Refund insurance payable
NUMBER(15,2) yes
ins_com_refund_d
Refund insurance commission
NUMBER(15,2) yes
ins_inc_refund_d
Refund insurance income
NUMBER(15,2) 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
NUMBER(15,2) yes
prev_taxbasis_d
Previous book depreciation basis
NUMBER(15,2) yes
prev_sal_bkd_d
Previous book salvage value
NUMBER(15,2) yes
depr_chg_l
Depreciation change counter
NUMBER(10) yes
d_prev_bkd_s
Previous book depreciation start date
DATE 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
NUMBER(15,2) 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
NUMBER(10) yes
fed_life_l
Federal depreciation life
NUMBER(10) yes
dfrd_tax_ytd_d
Deferred tax YTD amount
NUMBER(15,2) yes
fsc_ytd_d
FSC exclusion Y-T-D amount
NUMBER(15,2) yes
int_expn_ytd_d
Interest expenses Y-T-D amount
NUMBER(15,2) yes
olb_invo_d
Off lease billing invoice/rent amount
NUMBER(15,2) yes
olb_stax_d
Off lease billing sales tax amount
NUMBER(15,2) yes
tax_inc_ytd_d
Taxable income Y-T-D amount
NUMBER(15,2) yes
prev_ytd_fed_amt_d
Previous Y-T-D federal AMT depreciation
NUMBER(15,2) yes
prev_ytd_fed_d
Previous Y-T-D federal depreciation
NUMBER(15,2) yes
prev_ytd_st_d
Previous Y-T-D state depreciation
NUMBER(15,2) yes
opt_res_d
Optional residual
NUMBER(15,2) yes
ptax_exempt_s
Property tax exempt code
CHAR(4) yes
d_ptax_last_used_s
Property tax last used date
DATE 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
DATE yes
custom_payoff_quote1_d
Custom payoff quote amount [1]
NUMBER(15,2) yes
custom_payoff_quote2_d
Custom payoff quote amount [2]
NUMBER(15,2) yes
custom_payoff_quote3_d
Custom payoff quote amount [3]
NUMBER(15,2) yes
custom_payoff_quote4_d
Custom payoff quote amount [4]
NUMBER(15,2) yes
custom_payoff_quote5_d
Custom payoff quote amount [5]
NUMBER(15,2) yes
idc_d
Total initial direct costs
NUMBER(15,2) yes
idc_cur_d
IDC current month amortization - book
NUMBER(15,2) yes
idc_rem_d
Unamortized IDC - book
NUMBER(15,2) yes
susp_idc_acc_d
Suspended IDC accrued
NUMBER(15,2) yes
idc1_ins_prem_ue_d
Insurance premium unearned IDC1
NUMBER(15,2) yes
idc1_ins_prem_susp_d
Insurance premium suspended IDC1
NUMBER(15,2) yes
idc1_ins_prem_cur_d
Insurance premium current IDC1
NUMBER(15,2) yes
idc1_ins_prem_ytd_d
Insurance premium year-to-date IDC1
NUMBER(15,2) yes
idc2_notary_fee_d
Notary fee IDC2
NUMBER(15,2) yes
idc2_notary_fee_ue_d
Notary fee unearned IDC2
NUMBER(15,2) yes
idc2_notary_fee_susp_d
Notary fee suspended IDC2
NUMBER(15,2) yes
idc2_notary_fee_cur_d
Notary fee current IDC2
NUMBER(15,2) yes
idc2_notary_fee_ytd_d
Notary fee year-to-date IDC2
NUMBER(15,2) yes
idr1_ins_fee_d
Insurance fee IDR1
NUMBER(15,2) yes
idr1_ins_fee_ue_d
Insurance fee unearned IDR1
NUMBER(15,2) yes
idr1_ins_fee_susp_d
Insurance fee suspended IDR1
NUMBER(15,2) yes
idr1_ins_fee_cur_d
Insurance fee current IDR1
NUMBER(15,2) yes
idr1_ins_fee_ytd_d
Insurance fee year-to-date IDR1
NUMBER(15,2) yes
idr2_reg_fee_d
Registration fee IDR2
NUMBER(15,2) yes
idr2_reg_fee_ue_d
Registration fee unearned IDR2
NUMBER(15,2) yes
idr2_reg_fee_susp_d
Registration fee suspended IDR2
NUMBER(15,2) yes
idr2_reg_fee_cur_d
Registration fee current IDR2
NUMBER(15,2) yes
idr2_reg_fee_ytd_d
Registration fee year-to-date IDR2
NUMBER(15,2) yes
idr3_dlr_subsidy_d
Dealer subsidy IDR3
NUMBER(15,2) yes
idr3_dlr_subsidy_ue_d
Dealer subsidy unearned IDR3
NUMBER(15,2) yes
idr3_dlr_subsidy_susp_d
Dealer subsidy suspended IDR3
NUMBER(15,2) yes
idr3_dlr_subsidy_cur_d
Dealer subsidy current IDR3
NUMBER(15,2) yes
idr3_dlr_subsidy_ytd_d
Dealer subsidy year-to-date IDR3
NUMBER(15,2) yes
idr4_open_comm_d
Open commission IDR4
NUMBER(15,2) yes
idr4_open_comm_ue_d
Open commission unearned IDR4
NUMBER(15,2) yes
idr4_open_comm_susp_d
Open commission suspended IDR4
NUMBER(15,2) yes
idr4_open_comm_cur_d
Open commission current IDR4
NUMBER(15,2) yes
idr4_open_comm_ytd_d
Open commission year-to-date IDR4
NUMBER(15,2) yes
sec_d
Security deposit
NUMBER(15,2) yes
susp_l_acc_d
Suspended lessor income accrued
NUMBER(15,2) yes
l_in_ptd_d
Lessor rental income accrued P-T-D
NUMBER(15,2) yes
l_in_cur_d
Lessor current month rent income
NUMBER(15,2) yes
dp_mly_d
Monthly rental depreciation
NUMBER(15,2) yes
unrec_in_d
Unrecognized operating income
NUMBER(15,2) yes
dfrd_residual_red_d
Deferred residual reduction
NUMBER(15,2) yes
op_bill_adj_d
Operating lease princpal/income adjustment
NUMBER(15,2) yes
payoff_fee_ltd_d
Payoff/termination fee/penalty L-T-D
NUMBER(15,2) yes
d_taxbasis_s
Date of last tax depreciation basis update
DATE 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
NUMBER(15,2) yes
payoff_ct_stax_d
County sales tax in payoff
NUMBER(15,2) yes
payoff_cy_stax_d
City sales tax in payoff
NUMBER(15,2) 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
NUMBER(15,2) yes
idc6_d
Dealer bonus IDC6
NUMBER(15,2) yes
idc6_ap_d
Payable amount IDC6
NUMBER(15,2) yes
idc6_pay_to_s
Payable to IDC6
CHAR(9) yes
idc6_forfeit_d
Forfeit amount IDC6
NUMBER(15,2) yes
idc7_d
Dealer reserve IDC7
NUMBER(15,2) yes
idc7_ap_d
Payable amount IDC7
NUMBER(15,2) yes
idc7_cb_amt_d
Chargeback amount IDC7
NUMBER(15,2) 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
NUMBER(15,2) yes
p_dlr_res_buy_rate_d
Dealer reserve buy rate
NUMBER(15,2) yes
vtx_taid_s
Vertex tax area id
CHAR(10) yes
eq_cnty_s
Equipment county
VARCHAR2(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
DATE yes
d_supp_depr_last_eom_s
Supplemental depreciation last EOM date
DATE yes
supp_depr_months_l
Number of months to depreciate supplemental
NUMBER(10) yes
supp_depr_basis_d
Supplemental depreciation basis
NUMBER(15,2) yes
supp_depr_sal_d
Supplemental depreciation salvage value
NUMBER(15,2) yes
supp_depr_accumul_d
Accumulated supplemental depreciation
NUMBER(15,2) yes
supp_depr_mtd_d
Month-to-date supplemental depreciation
NUMBER(15,2) yes
supp_depr_ytd_d
Year-to-date supplemental depreciation
NUMBER(15,2) yes
supp_depr_ltd_d
Life-to-date supplemental depreciation
NUMBER(15,2) yes
acc_pay_tax_d
Accounts payable tax
NUMBER(15,2) yes
idc_asc842_d
Total IDC ASC 842 initial direct cost amount
NUMBER(15,2) yes
idc_asc842_rem_d
Unamortized IDC ASC 842 amount -- book
NUMBER(15,2) yes
idc_asc842_cur_d
IDC ASC 842 current month amortization amount -- book
NUMBER(15,2) yes
idc_asc842_ytd_d
IDC ASC 842 Y-T-D amount -- book
NUMBER(15,2) yes
susp_idc_asc842_acc_d
Suspended IDC ASC 842 accrued
NUMBER(15,2) yes