|
accountid
|
int
|
|
|
0
Browse foreign values
|
|
account_no
|
varchar(100)
|
|
|
|
|
accountname
|
varchar(100)
|
|
|
|
|
parentid
|
int
|
|
|
0
|
|
account_type
|
varchar(200)
|
|
|
|
|
industry
|
varchar(200)
|
|
|
|
|
annualrevenue
|
decimal(25,8)
|
|
|
|
|
rating
|
varchar(200)
|
|
|
|
|
ownership
|
varchar(50)
|
|
|
|
|
siccode
|
varchar(50)
|
|
|
|
|
tickersymbol
|
varchar(30)
|
|
|
|
|
phone
|
varchar(30)
|
|
|
|
|
otherphone
|
varchar(30)
|
|
|
|
|
email1
|
varchar(100)
|
|
|
|
|
email2
|
varchar(100)
|
|
|
|
|
website
|
varchar(100)
|
|
|
|
|
fax
|
varchar(30)
|
|
|
|
|
employees
|
int
|
|
|
0
|
|
emailoptout
|
varchar(3)
|
|
|
0
|
|
notify_owner
|
varchar(3)
|
|
|
0
|
|
isconvertedfromlead
|
varchar(3)
|
|
|
0
|
|
tags
|
varchar(1)
|
|
|
|