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.