customer
The customer table.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | Internal ID | |
| accountnumber | String | Account | |
| alcoholrecipienttype | String | Alcohol Recipient Type | |
| altemail | String | Alt. Email | |
| altname | String | Customer | |
| assignedwebsite | String | Assigned Web Site | |
| balancesearch | Decimal | Balance | |
| billingratecard | String | Billing Rate Card | |
| billingschedule | String | Billing Schedule | |
| billingtransactiontype | String | Billing Transaction Type | |
| billpay | Boolean | Enable Online Bill Pay | |
| buyingreason | String | Buying Reason | |
| buyingtimeframe | String | Buying Time Frame | |
| campaignevent | String | Campaign Event | |
| category | String | Category | |
| clickstream | String | Click-Stream (1st Visit) | |
| comments | String | Comments | |
| companyname | String | Company Name | |
| consolbalancesearch | Decimal | Consolidated Balance | |
| consoldaysoverduesearch | Integer | Consolidated Days Overdue | |
| consoloverduebalancesearch | Decimal | Consolidated Overdue Balance | |
| consolunbilledorderssearch | Decimal | Consolidated Unbilled Orders | |
| contact | String | Primary Contact | |
| contactlist | String | Contacts | |
| creditholdoverride | String | Credit Hold | |
| creditlimit | Decimal | Credit Limit | |
| currency | String | Currency | |
| datecreated | Date | Date Created | |
| defaultbankaccount | String | Default Bank Account | |
| defaultbillingaddress | String | Default Billing Address | |
| defaultorderpriority | Double | Default Order Priority | |
| defaultshippingaddress | String | Default Shipping Address | |
| duplicate | Boolean | Duplicate | |
| String | |||
| emailpreference | String | Email Preference | |
| emailtransactions | Boolean | Email Transactions | |
| enddate | Date | End Date | |
| entityid | String | Entity ID | |
| entitynumber | Integer | Number | |
| entitystatus | String | Status | |
| entitytitle | String | Customer ID | |
| estimatedbudget | Decimal | Estimated Budget | |
| externalid | String | External ID | |
| faxtransactions | Boolean | Fax Transactions | |
| firstname | String | First Name | |
| firstorderdate | Date | First Sales Order Date | |
| firstsaledate | Date | First Sale Date | |
| firstvisit | Date | First Visit | |
| giveaccess | Boolean | Login Access | |
| globalsubscriptionstatus | String | Global Subscription Status | |
| isbudgetapproved | Boolean | Budget Approved | |
| isinactive | Boolean | Inactive | |
| isperson | Boolean | Is Individual | |
| keywords | String | Search Engine Keywords (1st Visit) | |
| lastmodifieddate | Date | Last Modified Date | |
| lastname | String | Last Name | |
| lastorderdate | Date | Last Sales Order Date | |
| lastpagevisited | String | Last Page Visited | |
| lastsaledate | Date | Last Sales Date | |
| lastvisit | Date | Last Visit | |
| leadsource | String | Lead Source | |
| middlename | String | Middle Name | |
| negativenumberformat | String | Negative Number Format | |
| numberformat | String | Number Format | |
| oncredithold | Boolean | On Credit Hold | |
| overduebalancesearch | Decimal | Overdue | |
| parent | String | Parent | |
| partner | String | Partner | |
| phoneticname | String | Furigana | |
| prefccprocessor | String | Preferred Payment Processing Profile | |
| pricelevel | String | Price Level | |
| printoncheckas | String | Print on Check As | |
| printtransactions | Boolean | Print Transactions | |
| probability | Double | Probability | |
| receivablesaccount | String | Default Receivables Account | |
| referrer | String | Referrer (1st Visit) | |
| reminderdays | Integer | Reminder Days | |
| resalenumber | String | Resale Number | |
| salesreadiness | String | Sales Readiness | |
| salesrep | String | Sales Rep | |
| salutation | String | Mr./Ms... | |
| searchstage | String | Stage | |
| shipcomplete | Boolean | Ship Complete | |
| shippingcarrier | String | Carrier | |
| shippingitem | String | Shipping Item | |
| sourcewebsite | String | Source Web Site | |
| startdate | Date | Start Date | |
| terms | String | Terms | |
| territory | String | Territory | |
| thirdpartyacct | String | 3rd Party Billing Account Number | |
| thirdpartycarrier | String | 3rd Party Billing Carrier | |
| thirdpartycountry | String | 3rd Party Billing Country | |
| thirdpartyzipcode | String | 3rd Party Billing Zip | |
| title | String | Job Title | |
| unbilledorderssearch | Decimal | Unbilled Orders | |
| visits | Integer | Number of Visits |