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.