Updated: 2009-09-21



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is used for the storage of all addresses used by the following objects:
  * Accounts (Customers, Vendors, Prospects)
  * Contacts
  * Transactions (Orders, Estimates, POs, RDs, Bills)
  * Store Information
  * Employee Information
  * GLAccount



The formatted address is a multi-line memo that is usually used for reporting on on-screen display.  It contains multiple lines and is formatted based on the standard US address format.  A store option (ShowCountryField) allows the user to decide if the country is displayed in the formatted address or not.



Information on Table Data
  * ClassTypeIDs Stores in Table:
    * 4001 - Address



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| Address.City || nvarchar(25) ||  ||   ||
|| Address.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| Address.Country || nvarchar(25) ||  ||   ||
|| Address.County || nvarchar(25) ||  ||   ||
|| Address.FormattedText || text || Full address formatted for printing on a envelope. ||  ||
|| Address.ID || int || Primary Key for the Table || [[sql_structure_-_account_table]].BillingAddressID \\ [[sql_structure_-_account_table]].ShippingAddressID  \\ [[sql_structure_-_accountcontact_table]].BillingAddressID \\ [[sql_structure_-_accountcontact_table]].ShippingAddressID \\ [[sql_structure_-_accountcontact_table]].PaymentAddressID  \\ [[sql_structure_-_employee_table]].AddressID  \\ [[sql_structure_-_employee_table]].MailAddressID  \\ [[sql_structure_-_employeegroup_table]].AddressID  \\ [[sql_structure_-_glaccount_table]].AddressID  \\ [[sql_structure_-_store_table]].AddressID  \\ [[sql_structure_-_store_table]].PickUpAddressID  \\ [[sql_structure_-_transdetail_table]].ShippingAddressID  \\ [[sql_structure_-_transdetail_table]].ShipFromAddressID  \\ [[sql_structure_-_transheader_table]].ShippingAddressID  \\ [[sql_structure_-_transheader_table]].ShipFromAddressID  \\ [[sql_structure_-_transheader_table]].InvoiceAddressID  \\ ||
|| Address.IsActive || bit || Not Used for This Table ||   ||
|| Address.IsSystem || bit || Used to Mark Required Records ||   ||
|| Address.IsValidated || bit || Determines if the address has been validated by Avatax. ||  ||
|| Address.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| Address.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| Address.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| Address.PostalCode || nvarchar(25) ||  ||   ||
|| Address.SeqID || int ||  ||   ||
|| Address.State || nvarchar(25) ||  ||   ||
|| Address.StoreID || int || Not Used. ||   ||
|| Address.StreetAddress1 || nvarchar(40) ||  ||   ||
|| Address.StreetAddress2 || nvarchar(40) ||  ||   ||
|| Address.TaxClassID || int || ID of the TaxClass when using address based tax lookup. || [[sql_structure_-_taxclass_table]].ID ||
|| Address.ValidatedAddress || text || Full address formatted by the address validation. ||  ||
Related Tables 



[[sql_structure_-_addresslink_table]]