customer
Tracks detailed customer information, including contact details, account status, and transaction history for billing and Customer Relationship Management.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | The unique internal identifier for the record. | |
| accountnumber | String | The account number associated with the customer or entity. | |
| alcoholrecipienttype | String | The type of recipient for alcohol-related transactions. | |
| altemail | String | The alternative email address for the customer or entity. | |
| altname | String | An alternate name for the customer or entity. | |
| assignedwebsite | String | The website assigned to the customer or entity. | |
| balancesearch | Decimal | The balance associated with the customer or account. | |
| billingratecard | String | The billing rate card applied to the customer or account. | |
| billingschedule | String | The billing schedule associated with the customer or account. | |
| billingtransactiontype | String | The type of billing transaction, such as recurring or one-time. | |
| billpay | Boolean | Indicates whether online bill pay is enabled for the customer. | |
| buyingreason | String | The reason for the customer's purchase, such as business need or promotion. | |
| buyingtimeframe | String | The time frame in which the customer plans to make a purchase. | |
| campaignevent | String | The campaign event associated with the customer or entity. | |
| category | String | The category assigned to the customer or entity. | |
| clickstream | String | The click-stream data from the first visit of the customer. | |
| comments | String | Additional comments or notes related to the customer or entity. | |
| companyname | String | The name of the company associated with the customer. | |
| consolbalancesearch | Decimal | The consolidated balance across all related entities. | |
| consoldaysoverduesearch | Integer | The consolidated days overdue for all related entities. | |
| consoloverduebalancesearch | Decimal | The consolidated overdue balance across all related entities. | |
| consolunbilledorderssearch | Decimal | The consolidated unbilled orders across all related entities. | |
| contact | String | The primary contact for the customer or entity. | |
| contactlist | String | A list of all contacts associated with the customer or entity. | |
| creditholdoverride | String | Indicates any override to the credit hold status for the customer. | |
| creditlimit | Decimal | The credit limit associated with the customer or account. | |
| currency | String | The currency associated with the customer or transaction. | |
| datecreated | Date | The date the customer or entity record was created. | |
| defaultbankaccount | String | The default bank account associated with the customer. | |
| defaultbillingaddress | String | The default billing address for the customer. | |
| defaultorderpriority | Double | The default order priority assigned to the customer. | |
| defaultshippingaddress | String | The default shipping address for the customer. | |
| duplicate | Boolean | Indicates whether the customer record is a duplicate. | |
| String | The primary email address associated with the customer. | ||
| emailpreference | String | The preferred email communication method for the customer. | |
| emailtransactions | Boolean | Indicates whether email notifications are sent for transactions. | |
| enddate | Date | The end date of the customer's current term or contract. | |
| entityid | String | The unique identifier for the entity, such as customer ID. | |
| entitynumber | Integer | The numerical identifier for the entity. | |
| entitystatus | String | The current status of the entity, such as active or inactive. | |
| entitytitle | String | The title associated with the entity, such as customer ID. | |
| estimatedbudget | Decimal | The estimated budget for the customer or entity. | |
| externalid | String | The external identifier for referencing the customer or entity. | |
| faxtransactions | Boolean | Indicates whether fax notifications are sent for transactions. | |
| firstname | String | The first name of the customer or contact. | |
| firstorderdate | Date | The date of the customer's first sales order. | |
| firstsaledate | Date | The date of the customer's first sale. | |
| firstvisit | Date | The date of the customer's first visit. | |
| giveaccess | Boolean | Indicates whether the customer has access to online portals. | |
| globalsubscriptionstatus | String | The global subscription status for the customer. | |
| isbudgetapproved | Boolean | Indicates whether the customer's budget has been approved. | |
| isinactive | Boolean | Indicates whether the customer or entity is inactive. | |
| isperson | Boolean | Indicates whether the entity is an individual person. | |
| keywords | String | The search engine keywords used during the customer's first visit. | |
| lastmodifieddate | Date | The date the customer or entity record was last modified. | |
| lastname | String | The last name of the customer or contact. | |
| lastorderdate | Date | The date of the customer's last sales order. | |
| lastpagevisited | String | The last page the customer visited on the website. | |
| lastsaledate | Date | The date of the customer's most recent sale. | |
| lastvisit | Date | The date of the customer's most recent visit. | |
| leadsource | String | The source from which the lead originated, such as referral or campaign. | |
| middlename | String | The middle name of the customer or contact. | |
| negativenumberformat | String | The format used for displaying negative numbers. | |
| numberformat | String | The format used for displaying numbers. | |
| oncredithold | Boolean | Indicates whether the customer is currently on credit hold. | |
| overduebalancesearch | Decimal | The overdue balance associated with the customer. | |
| parent | String | The parent entity or account associated with the customer. | |
| partner | String | The partner associated with the customer or entity. | |
| phoneticname | String | The phonetic version of the customer's name, often used for pronunciation. | |
| prefccprocessor | String | The preferred credit card processing profile for the customer. | |
| pricelevel | String | The price level applied to the customer's purchases. | |
| printoncheckas | String | The name printed on checks for the customer. | |
| printtransactions | Boolean | Indicates whether transaction records should be printed. | |
| probability | Double | The probability of closing the sale or transaction. | |
| receivablesaccount | String | The account used for receivables associated with the customer. | |
| referrer | String | The referrer from the customer's first visit to the website. | |
| reminderdays | Integer | The number of days before a reminder is sent to the customer. | |
| resalenumber | String | The resale number associated with the customer. | |
| salesreadiness | String | The customer's readiness for sales or a transaction. | |
| salesrep | String | The sales representative associated with the customer. | |
| salutation | String | The salutation used for the customer, such as Mr., Ms., or Dr. | |
| searchstage | String | The stage in the search or sales process. | |
| shipcomplete | Boolean | Indicates whether the order should be shipped completely or partially. | |
| shippingcarrier | String | The carrier responsible for shipping the items. | |
| shippingitem | String | The item being shipped. | |
| sourcewebsite | String | The source website from which the customer originated. | |
| startdate | Date | The start date of the customer's contract or relationship. | |
| terms | String | The payment terms associated with the customer. | |
| territory | String | The sales territory associated with the customer. | |
| thirdpartyacct | String | The third-party billing account number associated with the customer. | |
| thirdpartycarrier | String | The third-party billing carrier for the customer. | |
| thirdpartycountry | String | The third-party billing country associated with the customer. | |
| thirdpartyzipcode | String | The third-party billing zip code for the customer. | |
| title | String | The job title of the customer or contact. | |
| unbilledorderssearch | Decimal | The unbilled orders associated with the customer. | |
| visits | Integer | The number of visits the customer has made. |