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

Database Reference Sybase 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)
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