Updated: 2009-10-13

Version: Control 4.4

Table Purpose, Usage, and Notes

This table contains the records of contacts for companies. This includes customers, prospects, personal listings, and vendors. For all but vendors, at least one contact record is required

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • 3000 - Contact for Customer, Prospect, or Vendor

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
AccountContact.AccountID int ID of the Customer/Prospect/Vendor Account sql_structure_-_account_table.ID
AccountContact.BillingAddressID int Link to Billing Address sql_structure_-_address_table.ID
AccountContact.BirthDate datetime DateTime of BirthDate
AccountContact.BirthDateDay int Day of the birth month (1-31)
AccountContact.BirthDateMonth int Month of the birth year (1-12)
AccountContact.CCBillingAddress nvarchar(50) Deprecated
AccountContact.CCCSCustomerGuid varchar(50) GUID for unique cc identification
AccountContact.CCSwiped bit Yes/No on whether the credit card was swiped
AccountContact.ClassTypeID int Identifier for the Type of Object
AccountContact.ContactType int 0 for Full Contact, 1 for Limited
AccountContact.DefaultPaymentBankCode varchar(50) Used with Wire Transfer Payment Type
AccountContact.DefaultPaymentBankReference varchar(50) Used with Wire Transfer Payment Type
AccountContact.DefaultPaymentBranchCode varchar(50) Used with Wire Transfer Payment Type
AccountContact.DefaultPaymentCCAccount varchar(50) Used with Wire Transfer Payment Type
AccountContact.DefaultPaymentCIN varchar(50) Used with Wire Transfer Payment Type
AccountContact.DefaultPaymentExpDate datetime Expiration Date of Default Credit Card
AccountContact.DefaultPaymentNameOnCard nvarchar(25) Name on Card of Default Credit Card
AccountContact.DefaultPaymentState varchar(50) Used with Wire Transfer Payment Type
AccountContact.DefaultPaymentTrackingNumber nvarchar(25) deprecated
AccountContact.DefaultPaymentTypeID int Link to Payment Method SQL Structure PaymentMethod Table.ID
AccountContact.DefaultPaymentVCode char(10) deprecated
AccountContact.DisplayNumber varchar(50) Mostly Masked Credit Card Number
AccountContact.EmailAddress nvarchar(50) Email Address of Contact
AccountContact.FirstName nvarchar(25) First Name of Contact
AccountContact.GenderType int 0Male, 1Female
AccountContact.ID int Primary Key for the Table sql_structure_-_account_table.AccountingContactID
sql_structure_-_coursecontactlink_table.ContactID
sql_structure_-_journal_table.ContactID
SQL Structure - PartConsumptionJournal Table.ContactID
sql_structure_-_transheader_table.ContactID
sql_structure_-_transheaderhistory_table.ContactID
sql_structure_-_transheader_table.InvoiceContactID
sql_structure_-_transheaderhistory_table.InvoiceContactID
sql_structure_-_account_table.PrimaryContactID
sql_structure_-_transdetail_table.ShippingContactID
sql_structure_-_transheader_table.ShippingContactID
sql_structure_-_transheaderhistory_table.ShippingContactID
AccountContact.IDNumber varchar(50) deprecated
AccountContact.ImageID int Link to Contact's Image
AccountContact.IsAccountingContact bit Yes/No Contact is Primary Accounting Contact
AccountContact.IsActive bit Yes/No Contact Is Active
AccountContact.IsCCNumEncrypt bit
AccountContact.IsPrimaryContact bit Yes/No Contact is Company Primary Contact
AccountContact.IsSystem bit Yes/No Contact is from System Data (Read Only)
AccountContact.IsVCodeEncrypted bit deprecated
AccountContact.LastName nvarchar(25) Contact Last Name
AccountContact.MainFaxNumberID int Link to Main Fax Number
AccountContact.MainPhoneNumberID int Link to Main Phone Number
AccountContact.MiddleName varchar(50) Contact Middle Name
AccountContact.ModifiedByComputer nvarchar(25) Computer Name of Last Edit
AccountContact.ModifiedByUser nvarchar(25) Windows User Name of Last Edit
AccountContact.ModifiedDate datetime DateTime of Last Edit
AccountContact.Notes text Notes recorded on the notes tab of Contact
AccountContact.NumOfMakeups int ?
AccountContact.PaymentAddressID int Link To Payment Address sql_structure_-_address_table.ID
AccountContact.PaymentAddressLinkID int Link (when needed) to Payment Address Link Table sql_structure_-_addresslink_table.ID
AccountContact.Position nvarchar(25) Name of contacts position in company
AccountContact.PrimaryNumber varchar(75) Formatted primary phone number for contact
AccountContact.PriNumberTypeID int
AccountContact.PriNumberTypeText varchar(50)
AccountContact.SalespersonID1 int Link to Primary Salesperson sql_structure_-_employee_table.ID
AccountContact.SalespersonID2 int sql_structure_-_employee_table.ID
AccountContact.SalespersonID3 int sql_structure_-_employee_table.ID
AccountContact.SecNumberTypeID int ID of Second Phone Number Type ?
AccountContact.SecNumberTypeText varchar(50) Second Phone Number Type (fax, cell, office)
AccountContact.SecondaryNumber varchar(75) Formatted Second Phone Number
AccountContact.SendBillingAddress bit ?
AccountContact.SeqID int number of edits
AccountContact.ShippingAddressID int Link to Shipping Address sql_structure_-_address_table.ID
AccountContact.StoreID int deprecated
AccountContact.ThirdNumber varchar(75) Formatted Third Phone Number
AccountContact.ThirdNumberTypeID int ID of Third Phone Number type ?
AccountContact.ThirdNumberTypeText varchar(50) Third Phone Number Type (fax, cell, office)
AccountContact.Title nvarchar(10) Contact's Title (Mr, Mrs, etc)
AccountContact.UseCompanySalespeople bit Yes/No whether to use the Company Salespeople instead of choosing specific ones for this contact
AccountContact.UserID int Used by WebView for Customer Logins
AccountContactUserField.ClassTypeID int Identifier for the Type of Object
AccountContactUserField.ID int Primary Key for the Table
AccountContactUserField.IsActive bit Yes/No whether a contact user field is active
AccountContactUserField.IsSystem bit Yes/No whether a contact user field is from System Data
AccountContactUserField.ModifiedByComputer nvarchar(25) Name of computer where last modification was made
AccountContactUserField.ModifiedByUser nvarchar(25) Windows User Name of user that made last modification
AccountContactUserField.ModifiedDate datetime DateTime of Last Modification
AccountContactUserField.SeqID int Count of modifications
AccountContactUserField.StoreID int deprecated

Related Tables

You could leave a comment if you were logged in.