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

Database Reference Oracle DBMS

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