> For the complete documentation index, see [llms.txt](https://infinisuite.gitbook.io/sdk/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://infinisuite.gitbook.io/sdk/data-model-and-schema/tables/lead.md).

# 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