{$page}

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 Account.ID
AccountContact.BillingAddressID int Link to Billing Address Address.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 PaymentMethod.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 Account.AccountingContactID
CourseContactLink.ContactID
Journal.ContactID
PartConsumptionJournal.ContactID
TransHeader.ContactID
TransHeaderHistory.ContactID
TransHeader.InvoiceContactID
TransHeaderHistory.InvoiceContactID
Account.PrimaryContactID
TransDetail.ShippingContactID
TransHeader.ShippingContactID
TransHeaderHistory.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 Address.ID
AccountContact.PaymentAddressLinkID int Link (when needed) to Payment Address Link Table AddressLink.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 Employee.ID
AccountContact.SalespersonID2 int Employee.ID
AccountContact.SalespersonID3 int Employee.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 Address.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

See Also

You could leave a comment if you were logged in.