req Table: Asset
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference

req Table: Asset

Child Tables

Name Description
reqa Asset 2
reqc Asset Condition
reqp Asset Payment Schedule
requ Asset UCC

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6
req_idx0 por_s com_s reg_s off_s lse_s unit_s
req_idx1 unit_s          
req_idx2 id_s unit_s        
req_idx3 pur_ord_s unit_s        
req_idx4 dlr_s unit_s        
req_idx5 app_s unit_s        
req_spec1_idx lse_s unit_s        


Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
com_s
Company
reg_s
Region
off_s
Office
lse_s
Lease
unit_s
Asset
Record modification stamp
id_s
Asset identification
pur_ord_s
Purchase order number
dlr_s
Vendor
app_s
Application
d_acq_s
Equipment acquisition date
d_act_s
Ownership certificate activity date
d_fhut_s
FHUT date of first use
d_boo_s
System booking date
d_eqt_s
Equipment activity status date
d_serv_s
In-service date
d_insp_s
Inspection date
d_bok_s
Book depreciation start date
d_itc_s
ITC accrued to date
d_addon_s
Add-on date
d_po_s
P.O. date
d_cor_s
Correction sent date
d_lien_s
Last lien date
cls_s
Class (CLASS code)
itc_s
ITC take/bypass code
etc_s
ETC take/bypass code
txb_s
Tax benefit owner code
eqt_s
Equipment activity status
mnf_s
Asset manufacturer code
mdl_s
Asset model code
yr_s
Asset year (YYYY)
bkd_s
Book depreciation method
fed_s
Federal method of depreciation
std_s
State method of depreciation
st_s
State code (RST.ST_S code)
ct_s
County location code
cy_s
City location code
txp_s
Tax payment code (TXP code)
co_s
Ownership certificate code
hw_s
Federal highway use tax code
eqt_pay_s
Equipment status at payoff
fed_amt_s
Federal AMT method
itc_meth_s
ITC accrual method
eqt_stat_s
Asset status
eqt_inv_s
Activity status prior to booking
tax_type_s
Tax type
bk_acct_s
Book accounting method
upf_st_s
Upfront sales tax - state
upf_ct_s
Upfront sales tax - county
upf_cy_s
Upfront sales tax - city
corr_s
Required correction code
pay_st_s
Payoff/sale state location code
pay_ct_s
Payoff/sale county location code
pay_cy_s
Payoff/sale city location code
pay_meth_s
Asset payoff method
new_c
New/used (N/U)
copt_c
Auto options at lease commencement (Y/N)
topt_c
Auto options at lease termination (Y/N)
war_c
Warranty insurance (Y/N)
res_ins_c
Residual insurance (Y/N)
unt_pay_c
An asset payoff was done (Y/N)
off_c
Off-lease (Y/N)
rpt_ptax_c
Report property tax (Y/N)
pre_inv_c
Pre-inventory (Y/N)
tax_rptg_c
Asset appears on tax reports (Y/N)
term_rev_c
Allow termination reversal (Y/N)
gp_typ_c
Gross profit type (R/U)
  R - related
  U - unrelated
upf_stax_c
Upfront sales tax (Y/N)
eq_add_s
Equipment street address
eq_cty_s
Equipment city
eq_st_s
Equipment state
eq_zip_s
Equipment zip
desc_s
Equipment description
opr_nam_s
Operator name
lic_s
License (auto)
stock_s
Stock number
nxt_ln_s
Next asset in loan
prv_ln_s
Previous asset in loan
frst_loan_s
First loan for asset
last_loan_s
Last loan for asset
cashier_chk_s
Cashier's check number
sus_s
Suspense item number written
sus_clr_s
Suspense item number cleared
asset_s
Associated asset
ini_cur_s
Clerk when asset removed from collateral tracking
chk_ref_s
Check reference
sup_nam_s
Supplier name
sup_add_s
Supplier address
sup_add2_s
Supplier address 2
sup_cty_s
Supplier city
sup_st_s
Supplier state
sup_zip_s
Supplier zip
bun_s
DMV bundle number
snum_s
DMV suspense receipt number
adj_depr_life_l
Adjustment depreciable life
codm_l
Odometer reading at lease commencement
todm_l
Odometer reading at lease termination
weight_l
FHUT asset weight (pounds)
mil_aam_l
Average yearly allowable mileage
p_sch_d
Percentage of schedule amount
p_con_unit_d
Asset yield
upf_strt_d
Upfront sales tax - state rate
upf_ctrt_d
Upfront sales tax - county rate
upf_cyrt_d
Upfront sales tax - city rate
pay_st_rate_d
Payoff/sale state rate
pay_ct_rate_d
Payoff/sale county rate
pay_cy_rate_d
Payoff/sale city rate
st_rate_d
State tax rate
ct_rate_d
County tax rate
cy_rate_d
City tax rate
tax_d
Portfolio tax rate
org_d
Original acquisition cost
other_d
Other charges
res_d
Residual amount
strt_d
Starting asset cost
inven_d
Inventoried value
acc_pay_d
Accounts payable
lst_d
List price
lic_d
License fees
pre_d
Warranty insurance premium
rep_d
Repair cost
gas_d
Gas cost
rec_ytd_gross_d
Gross receipts Y-T-D
unit_rec_ltd_d
Asset change in L-T-D receipts
oth_ytd_d
Other income Y-T-D
oth_ltd_d
Other income L-T-D
taxbasis_d
Starting book value for depreciation
itcbasis_d
Starting book value for ITC
sal_bkd_d
Book value salvage value
sal_st_d
State salvage value
mtd_bkd_d
Depreciation M-T-D book
ytd_bkd_d
Depreciation Y-T-D book
ltd_bkd_d
Depreciation L-T-D book
mtd_fed_d
Depreciation M-T-D federal
ytd_fed_d
Depreciation Y-T-D federal
ltd_fed_d
Depreciation L-T-D federal
mtd_st_d
Depreciation M-T-D state
ytd_st_d
Depreciation Y-T-D state
ltd_st_d
Depreciation L-T-D state
org_bkd_ltd_d
Original L-T-D book depreciation
itc_org_d
Original ITC
itc_sus_d
ITC sustained
itc_mtd_d
ITC M-T-D
itc_ytd_d
ITC Y-T-D
itc_ltd_d
ITC L-T-D
etc_mtd_d
ETC M-T-D
etc_ytd_d
ETC Y-T-D
etc_ltd_d
ETC L-T-D
nbv_pay_d
Net book value at payoff/termination
ytd_loss_d
Y-T-D loss on termination
ytd_gain_d
Y-T-D gain on termination
std_pay_d
State book value at payoff
fed_pay_d
Federal book value at payoff
res_pay_d
Residual at payoff
strt_pay_d
Starting cost at payoff
asm_pay_d
Assessments outstanding for payoff
pmt_pay_d
Payments outstanding for payoff
unit_rec_d
Asset receivable
chg_rec_d
Asset change in receivable
unit_prn_d
Asset principal
unit_l_ue_d
Asset lessor unearned
d_ue_d
Asset vendor unearned
unit_i_ue_d
Asset investor unearned
unit_l_ue_org_d
Asset lessor unearned original
d_ue_org_d
Asset vendor unearned original
unit_i_ue_org_d
Asset investor unearned original
sch_basis_d
Schedule percentage basis
fed_amt_ltd_d
Federal AMT L-T-D amount
bk_basis_d
Book tax basis
itc_org_ue_d
Original ITC unearned
itc_cur_ue_d
Current ITC unearned
itc_in_ytd_d
ITC income Y-T-D
itc_in_cur_d
ITC current month income
man_bas_d
Manufacturer's depreciation basis
pmt_acc_d
Payment amount accrued Y-T-D
pmt_amt_d
Asset payment amount
l_in_ytd_d
Lessor income Y-T-D
ast_cst_d
Original asset cost
org_bk_basis_d
Original book basis
adj_bk_basis_d
Adjustment to book basis
unit_r_ue_d
Asset unearned residual
rec_ytd_chg_d
Asset change in Y-T-D receipts
etc_org_d
ETC original total
upf_bamt_d
Upfront sales tax - base amount
upf_samt_d
Upfront sales tax - sales tax amount
idc_ytd_d
IDC Y-T-D amount - book
idc_tax_ytd_d
IDC Y-T-D amount - tax
fed_amt_ytd_d
Federal AMT Y-T-D amount
pay_tax_amt_d
Payoff/sale taxable amount
amt_pay_d
Federal AMT book value at payoff
r_in_ytd_d
Residual income Y-T-D
unit_r_ue_org_d
Asset original unearned residual
allow_ptx_c
Allow property tax assessment (Y/N)
note_s
Note attached to asset
gst_vendor_payable_d
GST vendor payable
ap_reduced_comm_d
A/P reduce at commencement
  for partial deductions module
d_disp_s
Asset disposition date
ins_prem_cost_d
Insurance premium cost
ytd_bkd_pay_d
Depreciation Y-T-D book at payoff
ytd_fed_pay_d
Depreciation Y-T-D federal at payoff
ytd_st_pay_d
Depreciation Y-T-D state at payoff
fed_amt_ytd_pay_d
Federal AMT Y-T-D at payoff
msi_chg_key_c
Change lease key is in progress
prop_tax_basis_d
Property tax basis
warranty_c
Warranty
title_status_s
Title status
can_cr_lif1_c
Cancel credit life insurance 1
can_cr_lif2_c
Cancel credit life insurance 2
can_cr_dis1_c
Cancel credit disability insurance 1
can_cr_dis2_c
Cancel credit disability insurance 2
can_warranty_c
Cancel warranty insurance