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 |