res Table: Equity Movement Status
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

res Table: Equity Movement Status

Indexes

Name Segment 1 Segment 2 Segment 3
res_idx0 unit_s d_eqt_move_s t_run_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
unit_s
Asset
CHAR(10) no
d_eqt_move_s
Equipment movement status date
DATE no
t_run_s
Run time
CHAR(6) no
stamp_l
Record modification stamp
NUMBER(10) no
d_eqt_s
Equipment activity status date
DATE yes
mov_s
Movement code
CHAR(4) yes
eqt_s
Equipment activity status
CHAR(4) yes
st_s
Equipment state
CHAR(2) yes
ct_s
Equipment county
CHAR(4) yes
cy_s
Equipment city
CHAR(4) yes
por_s
Portfolio
CHAR(2) yes
com_s
Company
CHAR(2) yes
reg_s
Region
CHAR(2) yes
off_s
Office
CHAR(3) yes
lse_s
Lease
CHAR(10) yes
add_s
Equipment street address
VARCHAR2(36) yes
zip_s
Equipment zip code
CHAR(9) yes
eq_strt_d
Equipment starting cost
NUMBER(15,2) yes
res_d
Residual amount
NUMBER(15,2) yes
fd_book_d
Federal book value
NUMBER(15,2) yes
st_book_d
State book value
NUMBER(15,2) yes
inven_d
Inventoried value
NUMBER(15,2) yes
vtx_taid_s
Vertex tax area id
CHAR(10) yes
add2_s
Address 2
VARCHAR2(36) yes
cnty_s
County
VARCHAR2(60) yes
cty_s
City
VARCHAR2(25) yes