{$page}

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:

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

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 Account.BillingAddressID
Account.ShippingAddressID
AccountContact.BillingAddressID
AccountContact.ShippingAddressID
AccountContact.PaymentAddressID
Employee.AddressID
Employee.MailAddressID
EmployeeGroup.AddressID
GLAccount.AddressID
Store.AddressID
Store.PickUpAddressID
TransDetail.ShippingAddressID
TransDetail.ShipFromAddressID
TransHeader.ShippingAddressID
TransHeader.ShipFromAddressID
TransHeader.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. TaxClass.ID
Address.ValidatedAddress text Full address formatted by the address validation.

Related Tables

AddressLink Table

See Also