entity
The entity table.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | Internal ID | |
| altemail | String | Alt. Email | |
| altname | String | Name | |
| altphone | String | Alt. Phone | |
| comments | String | Comments | |
| contact | Integer | Contact | |
| customer | Integer | Customer | |
| datecreated | Date | Date Created | |
| String | |||
| employee | Integer | Employee | |
| entityid | String | Entity ID | |
| entitynumber | Integer | Number | |
| entitytitle | String | Name/ID | |
| externalid | String | External ID | |
| fax | String | Fax | |
| firstname | String | First Name | |
| genericresource | Integer | Generic Resource | |
| group | Integer | Group | |
| homephone | String | Home Phone | |
| isinactive | Boolean | Inactive | |
| isperson | Boolean | Is Individual | |
| laborcost | Decimal | Labor Cost | |
| lastmodifieddate | Datetime | Last Modified Date | |
| lastname | String | Last Name | |
| middlename | String | Middle Name | |
| mobilephone | String | Mobile Phone | |
| othername | Integer | Other Name | |
| parent | Integer | Parent | |
| partner | Integer | Partner | |
| phone | String | Phone | |
| phoneticname | String | Furigana | |
| project | Integer | Project | |
| projecttemplate | Integer | Project Template | |
| salutation | String | Mr./Ms... | |
| title | String | Job Title | |
| toplevelparent | Integer | Top Level Parent | |
| vendor | Integer | Vendor | |
| type | String | Type |