rin Table: Investor
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rin Table: Investor

Indexes

Name Segment 1
rin_idx0 inv_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
inv_s
Investor
char(9) no
timestamp
Record modification stamp
timestamp yes
stat_s
Activity status
char(4) yes
invst_grp_c
Investor group (Y/N)
char(1) yes
def_por_s
Default portfolio
char(2) yes
def_com_s
Default company
char(2) yes
def_reg_s
Default region
char(2) yes
def_off_s
Default office
char(3) yes
nam_s
Name
char(36) yes
add_s
Address
char(36) yes
add2_s
Address 2
char(36) yes
cty_s
City
char(25) yes
st_s
State code (RST.ST_S code)
char(2) yes
zip_s
Zip code
char(9) yes
phn_s
Phone number
char(10) yes
cont_nam_s
Contact name
char(36) yes
cont_title_s
Contact title
char(25) yes
lt_version_s
Letter version code
char(4) yes
email_s
Email address
char(50) yes
d_lup_s
Date of last update
datetime yes
t_lup_s
Time of last update
char(6) yes