lead

Type: table

Columns

Column	Type	Attributes	Description
companyname	varchar
companyrowid	int
description	varchar
estimatedclosedate	datetime
estimatedrevenueamount	decimal
firstcontactdate	datetime
firstname	varchar
isactive	tinyint
isindividual	tinyint
lastname	varchar
leadid	varchar
middlename	varchar
phonenbr	varchar
probabilitypercent	decimal
relationshiprowid	int
rowid	int	auto_increment
salesourcelistitemrowid	int
salespersonrelationshiprowid	int
salestatuslistitemrowid	int
saletypelistitemrowid	int
updatetimestamp	timestamp	on update CURRENT_TIMESTAMP

v.ismain -- Wed, Feb 28, 2018 2:58 PM