rou Table: Addresses for Asset
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rou Table: Addresses for Asset

Indexes

Name Segment 1 Segment 2
rou_idx0 unit_s adr_typ_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
unit_s
Asset
CHAR(10) no
adr_typ_s
Address type (ADDR.TYP code)
CHAR(4) no
stamp_l
Record modification stamp
NUMBER(10) no
vtx_taid_s
Vertex tax area id
CHAR(10) yes
st_s
State code (RST.ST_S code)
CHAR(2) yes
cnty_s
County
VARCHAR2(60) yes
cty_s
City
VARCHAR2(25) yes
add_s
Address
VARCHAR2(36) yes
add2_s
Address 2
VARCHAR2(36) yes
zip_s
Zip code
CHAR(9) yes