partner
The table that stores partner-related information, used to track business partners, their statuses, and relationships in the system.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | A unique internal identifier assigned to each record in the system for tracking and reference. | |
| altemail | String | An alternative email address associated with the entity, used for secondary communications. | |
| altname | String | An alternate name for the partner, often used for referencing the partner in different contexts or systems. | |
| category | String | The classification or group to which the partner belongs, used for organizational and reporting purposes. | |
| class | String | The classification or category used to group partners based on shared characteristics or attributes. | |
| comments | String | A field for additional notes or comments related to the partner, typically used for internal records. | |
| companyname | String | The name of the company associated with the partner, often used for formal references in business dealings. | |
| contact | String | The primary point of contact for the partner, typically the main representative or liaison. | |
| contactlist | String | A list of contacts associated with the partner, including multiple people for communication purposes. | |
| datecreated | Date | The date the partner record was created in the system, used for tracking record history. | |
| defaultbillingaddress | String | The default billing address for the partner, used for invoicing and financial communications. | |
| defaultshippingaddress | String | The default shipping address for the partner, used for fulfillment and logistics. | |
| department | String | The department within the partner’s organization that the partner record is associated with. | |
| duplicate | Boolean | Indicates whether the partner record is a duplicate entry in the system, used to flag and prevent redundancy. | |
| String | The primary email address for the partner, used for direct communication and notifications. | ||
| emailpreference | String | The partner's preference for receiving email communications, such as marketing, updates, or transaction-related messages. | |
| entityid | String | A unique identifier for the partner entity, used for referencing the partner in reports and transactions. | |
| entitynumber | Integer | A sequential number assigned to the partner entity, typically used for organizational or reporting purposes. | |
| entitytitle | String | A title or label associated with the partner, used for formal references such as 'Partner ID' or 'Customer ID.' | |
| externalid | String | A unique identifier assigned to the partner by an external system, used for integration purposes. | |
| firstname | String | The first name of the primary contact or individual associated with the partner record. | |
| giveaccess | Boolean | Indicates whether the partner has login access to the system, allowing them to access the portal or manage their own data. | |
| globalsubscriptionstatus | String | The status of the partner's global subscription, such as active, pending, or expired. | |
| isinactive | Boolean | Indicates whether the partner is currently inactive, often used for filtering out non-active records in reports. | |
| isperson | Boolean | Specifies whether the partner is an individual person or an organization, affecting how the record is managed. | |
| lastmodifieddate | Date | The date when the partner record was last modified, used for auditing and tracking changes. | |
| lastname | String | The last name of the primary contact or individual associated with the partner record. | |
| location | String | The geographical location of the partner, used for logistical and regional grouping purposes. | |
| middlename | String | The middle name of the primary contact or individual associated with the partner record. | |
| parent | String | Identifies the parent partner or organization, used to indicate hierarchical relationships between entities. | |
| partnercode | String | A unique code assigned to the partner, typically used for internal tracking or identification in business processes. | |
| phoneticname | String | The phonetic or pronunciation of the partner's name, often used in languages like Japanese (for example, Furigana). | |
| printoncheckas | String | The name or title to be printed on checks or financial documents, typically used for formal transactions. | |
| salutation | String | The salutation used for addressing the partner, such as Mr., Ms., or Dr. | |
| subpartnerlogin | Boolean | Indicates whether the partner can provide login access to sub-partners, granting them access to associated records. | |
| title | String | The job title or position held by the primary contact or individual associated with the partner record. |