othername
Stores data for other names associated with entities, often used for aliases or secondary names.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | The internal system-generated identifier for the record. | |
| accountnumber | String | The unique account identifier associated with the entity. | |
| altemail | String | The alternative email address for the contact. | |
| altname | String | An alternate or secondary name for the entity. | |
| category | String | The category or classification assigned to the entity. | |
| comments | String | Additional comments or notes related to the entity. | |
| companyname | String | The name of the company associated with the entity. | |
| contact | String | The primary contact person for the entity. | |
| contactlist | String | A list of contacts associated with the entity. | |
| creditlimit | Decimal | The maximum credit limit extended to the entity. | |
| currency | String | The currency used for financial transactions with the entity. | |
| datecreated | Date | The date when the entity record was created. | |
| defaultbillingaddress | String | The default billing address for the entity. | |
| defaultshippingaddress | String | The default shipping address for the entity. | |
| String | The email address associated with the entity or contact. | ||
| emailpreference | String | The preferred method for receiving emails from the entity. | |
| entityid | String | The unique identifier assigned to the entity. | |
| entitynumber | Integer | The number assigned to the entity for internal tracking. | |
| entitytitle | String | The title associated with the entity or other name. | |
| externalid | String | An external identifier used for integrations with other systems. | |
| firstname | String | The first name of the entity or individual. | |
| globalsubscriptionstatus | String | The global subscription status of the entity. | |
| isinactive | Boolean | Indicates whether the entity is inactive and not currently in use. | |
| isperson | Boolean | Indicates whether the entity is an individual (person) or not. | |
| lastmodifieddate | Date | The date and time when the entity record was last modified. | |
| lastname | String | The last name of the individual associated with the entity. | |
| middlename | String | The middle name of the individual associated with the entity. | |
| phoneticname | String | The phonetic version of the entity's name. | |
| printoncheckas | String | The name to be printed on checks issued to the entity. | |
| salutation | String | The formal salutation used for addressing the individual (for example, Mr., Ms.). | |
| terms | String | The payment terms associated with the entity. | |
| title | String | The job title or role of the individual associated with the entity. |