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

Database Reference Sybase 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
timestamp
Record modification stamp
timestamp yes
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
datetime yes
d_act_s
Ownership certificate activity date
datetime yes
d_fhut_s
FHUT date of first use
datetime yes
d_boo_s
System booking date
datetime yes
d_eqt_s
Equipment activity status date
datetime yes
d_serv_s
In-service date
datetime yes
d_insp_s
Inspection date
datetime yes
d_bok_s
Book depreciation start date
datetime yes
d_itc_s
ITC accrued to date
datetime yes
d_addon_s
Add-on date
datetime yes
d_po_s
P.O. date
datetime yes
d_cor_s
Correction sent date
datetime yes
d_lien_s
Last lien date
datetime 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)
char(30) yes
topt_c
Auto options at lease termination (Y/N)
char(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
char(36) yes
eq_cty_s
Equipment city
char(25) yes
eq_st_s
Equipment state
char(2) yes
eq_zip_s
Equipment zip
char(9) yes
desc_s
Equipment description
char(36) yes
opr_nam_s
Operator name
char(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
char(36) yes
sup_nam_s
Supplier name
char(36) yes
sup_add_s
Supplier address
char(36) yes
sup_add2_s
Supplier address 2
char(36) yes
sup_cty_s
Supplier city
char(25) yes
sup_st_s
Supplier state
char(2) yes
sup_zip_s
Supplier zip
char(9) yes
bun_s
DMV bundle number
char(25) yes
snum_s
DMV suspense receipt number
char(25) yes
adj_depr_life_l
Adjustment depreciable life
integer yes
codm_l
Odometer reading at lease commencement
integer yes
todm_l
Odometer reading at lease termination
integer yes
weight_l
FHUT asset weight (pounds)
integer yes
mil_aam_l
Average yearly allowable mileage
integer yes
p_sch_d
Percentage of schedule amount
double precision yes
p_con_unit_d
Asset yield
double precision yes
upf_strt_d
Upfront sales tax - state rate
double precision yes
upf_ctrt_d
Upfront sales tax - county rate
double precision yes
upf_cyrt_d
Upfront sales tax - city rate
double precision yes
pay_st_rate_d
Payoff/sale state rate
double precision yes
pay_ct_rate_d
Payoff/sale county rate
double precision yes
pay_cy_rate_d
Payoff/sale city rate
double precision yes
st_rate_d
State tax rate
double precision yes
ct_rate_d
County tax rate
double precision yes
cy_rate_d
City tax rate
double precision yes
tax_d
Portfolio tax rate
double precision yes
org_d
Original acquisition cost
double precision yes
other_d
Other charges
double precision yes
res_d
Residual amount
double precision yes
strt_d
Starting asset cost
double precision yes
inven_d
Inventoried value
double precision yes
acc_pay_d
Accounts payable
double precision yes
lst_d
List price
double precision yes
lic_d
License fees
double precision yes
pre_d
Warranty insurance premium
double precision yes
rep_d
Repair cost
double precision yes
gas_d
Gas cost
double precision yes
rec_ytd_gross_d
Gross receipts Y-T-D
double precision yes
unit_rec_ltd_d
Asset change in L-T-D receipts
double precision yes
oth_ytd_d
Other income Y-T-D
double precision yes
oth_ltd_d
Other income L-T-D
double precision yes
taxbasis_d
Starting book value for depreciation
double precision yes
itcbasis_d
Starting book value for ITC
double precision yes
sal_bkd_d
Book value salvage value
double precision yes
sal_st_d
State salvage value
double precision yes
mtd_bkd_d
Depreciation M-T-D book
double precision yes
ytd_bkd_d
Depreciation Y-T-D book
double precision yes
ltd_bkd_d
Depreciation L-T-D book
double precision yes
mtd_fed_d
Depreciation M-T-D federal
double precision yes
ytd_fed_d
Depreciation Y-T-D federal
double precision yes
ltd_fed_d
Depreciation L-T-D federal
double precision yes
mtd_st_d
Depreciation M-T-D state
double precision yes
ytd_st_d
Depreciation Y-T-D state
double precision yes
ltd_st_d
Depreciation L-T-D state
double precision yes
org_bkd_ltd_d
Original L-T-D book depreciation
double precision yes
itc_org_d
Original ITC
double precision yes
itc_sus_d
ITC sustained
double precision yes
itc_mtd_d
ITC M-T-D
double precision yes
itc_ytd_d
ITC Y-T-D
double precision yes
itc_ltd_d
ITC L-T-D
double precision yes
etc_mtd_d
ETC M-T-D
double precision yes
etc_ytd_d
ETC Y-T-D
double precision yes
etc_ltd_d
ETC L-T-D
double precision yes
nbv_pay_d
Net book value at payoff/termination
double precision yes
ytd_loss_d
Y-T-D loss on termination
double precision yes
ytd_gain_d
Y-T-D gain on termination
double precision yes
std_pay_d
State book value at payoff
double precision yes
fed_pay_d
Federal book value at payoff
double precision yes
res_pay_d
Residual at payoff
double precision yes
strt_pay_d
Starting cost at payoff
double precision yes
asm_pay_d
Assessments outstanding for payoff
double precision yes
pmt_pay_d
Payments outstanding for payoff
double precision yes
unit_rec_d
Asset receivable
double precision yes
chg_rec_d
Asset change in receivable
double precision yes
unit_prn_d
Asset principal
double precision yes
unit_l_ue_d
Asset lessor unearned
double precision yes
d_ue_d
Asset vendor unearned
double precision yes
unit_i_ue_d
Asset investor unearned
double precision yes
unit_l_ue_org_d
Asset lessor unearned original
double precision yes
d_ue_org_d
Asset vendor unearned original
double precision yes
unit_i_ue_org_d
Asset investor unearned original
double precision yes
sch_basis_d
Schedule percentage basis
double precision yes
fed_amt_ltd_d
Federal AMT L-T-D amount
double precision yes
bk_basis_d
Book tax basis
double precision yes
itc_org_ue_d
Original ITC unearned
double precision yes
itc_cur_ue_d
Current ITC unearned
double precision yes
itc_in_ytd_d
ITC income Y-T-D
double precision yes
itc_in_cur_d
ITC current month income
double precision yes
man_bas_d
Manufacturer's depreciation basis
double precision yes
pmt_acc_d
Payment amount accrued Y-T-D
double precision yes
pmt_amt_d
Asset payment amount
double precision yes
l_in_ytd_d
Lessor income Y-T-D
double precision yes
ast_cst_d
Original asset cost
double precision yes
org_bk_basis_d
Original book basis
double precision yes
adj_bk_basis_d
Adjustment to book basis
double precision yes
unit_r_ue_d
Asset unearned residual
double precision yes
rec_ytd_chg_d
Asset change in Y-T-D receipts
double precision yes
etc_org_d
ETC original total
double precision yes
upf_bamt_d
Upfront sales tax - base amount
double precision yes
upf_samt_d
Upfront sales tax - sales tax amount
double precision yes
idc_ytd_d
IDC Y-T-D amount - book
double precision yes
idc_tax_ytd_d
IDC Y-T-D amount - tax
double precision yes
fed_amt_ytd_d
Federal AMT Y-T-D amount
double precision yes
pay_tax_amt_d
Payoff/sale taxable amount
double precision yes
amt_pay_d
Federal AMT book value at payoff
double precision yes
r_in_ytd_d
Residual income Y-T-D
double precision yes
unit_r_ue_org_d
Asset original unearned residual
double precision 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
double precision yes
ap_reduced_comm_d
A/P reduce at commencement
  for partial deductions module
double precision yes
d_disp_s
Asset disposition date
datetime yes
ins_prem_cost_d
Insurance premium cost
double precision yes
ytd_bkd_pay_d
Depreciation Y-T-D book at payoff
double precision yes
ytd_fed_pay_d
Depreciation Y-T-D federal at payoff
double precision yes
ytd_st_pay_d
Depreciation Y-T-D state at payoff
double precision yes
fed_amt_ytd_pay_d
Federal AMT Y-T-D at payoff
double precision yes
msi_chg_key_c
Change lease key is in progress
char(1) yes
prop_tax_basis_d
Property tax basis
double precision 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