entity
Contains information on entities such as customers, suppliers, or other business relationships in the system.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | The unique internal identifier for the record, used to track and reference it within the system. | |
| altemail | String | An alternative email address for the individual or entity, used for secondary contact options. | |
| altname | String | An alternative name associated with the record, typically used for different naming conventions or additional identities. | |
| altphone | String | An alternative phone number, often used for secondary contact methods or backup communication. | |
| comments | String | Additional comments or notes related to the record, used for internal communication or reference. | |
| contact | Integer | The identifier for the contact record associated with the entity, used to reference and track specific contact details. | |
| customer | Integer | The identifier for the customer record associated with the entity, used to link the contact to a specific customer. | |
| datecreated | Date | The date the record was created, used for tracking the history and age of the record. | |
| String | The primary email address associated with the individual or entity, used for official communication. | ||
| employee | Integer | The identifier for the employee record associated with the entity, used to link the contact to a specific employee. | |
| entityid | String | The unique identifier for the entity, used to track and reference it in external systems or applications. | |
| entitynumber | Integer | The numerical identifier for the entity, often used for sorting or categorization purposes. | |
| entitytitle | String | The title or name associated with the entity, often used for reference or formal identification. | |
| externalid | String | An external identifier used to link the record with external systems or services, enabling integration. | |
| fax | String | The fax number associated with the entity, used for document transmission in situations requiring faxing. | |
| firstname | String | The first name of the individual associated with the record, used for personal identification. | |
| genericresource | Integer | The identifier for a generic resource associated with the entity, typically used in resource management systems. | |
| group | Integer | The identifier for the group to which the entity belongs, often used for classification or grouping purposes. | |
| homephone | String | The primary home phone number associated with the entity, used for personal contact. | |
| isinactive | Boolean | Indicates whether the record is marked as inactive, meaning it is no longer in use or relevant in active processes. | |
| isperson | Boolean | Indicates whether the entity is an individual person, used to differentiate between individual and organizational entities. | |
| laborcost | Decimal | The labor cost associated with the entity, typically used in financial or resource planning. | |
| lastmodifieddate | Datetime | The date and time when the record was last modified, used for tracking updates and changes. | |
| lastname | String | The last name of the individual associated with the record, used for personal identification. | |
| middlename | String | The middle name of the individual associated with the record, used for formal identification. | |
| mobilephone | String | The mobile phone number associated with the individual, used for communication via mobile device. | |
| othername | Integer | An identifier for other names associated with the entity, typically used for alternate or nickname references. | |
| parent | Integer | The identifier for the parent entity, used to establish hierarchical relationships between entities. | |
| partner | Integer | The identifier for a business partner or affiliated entity, used for partnership tracking. | |
| phone | String | The primary phone number associated with the entity, used for general contact. | |
| phoneticname | String | The phonetic spelling of the name (for example, Furigana), used for pronunciation assistance. | |
| project | Integer | The identifier for the project associated with the entity, used to link the contact to specific projects. | |
| projecttemplate | Integer | The identifier for the project template associated with the entity, used for template-based project management. | |
| salutation | String | The salutation used for addressing the individual, such as 'Mr.', 'Ms.', or 'Dr.', often used in formal communications. | |
| title | String | The job title or position of the individual, used to identify their role within the organization. | |
| toplevelparent | Integer | The identifier for the top-level parent entity in a hierarchical structure, used for organizational management. | |
| vendor | Integer | The identifier for the vendor associated with the entity, used for managing supplier relationships. | |
| type | String | The type of the entity, such as 'Customer', 'Vendor', or 'Employee', used for categorization and classification. |