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

You could leave a comment if you were logged in.