Updated: 2009-09-23



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table stores the links between Companies/Contacts/Store and Addresses.



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 4002 - Address Link



The AddressTypeID is only used for Billing, Shipping, and other standard types created to be automatically added to new companies and contacts.



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| AddressLink.AddressID || int || ID of the Address Linked To || [[sql_structure_-_address_table]].ID ||
|| AddressLink.AddressName || varchar(50) || The text name for the type of address (Shipping, Billing, etc.) ||   ||
|| AddressLink.AddressTypeID || int || An enumerated type for the address. || [[sql_structure_-_element_table]].ID where ClassTypeID  4000  ||
|| AddressLink.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| AddressLink.ID || int || Primary Key for the Table ||   ||
|| AddressLink.IsActive || bit || Not Used for This Table ||   ||
|| AddressLink.IsMaster || bit || If true, then the this link can edit it's address, otherwise the address is read only ||   ||
|| AddressLink.IsSystem || bit || Used to Mark Required Records ||   ||
|| AddressLink.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| AddressLink.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| AddressLink.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| AddressLink.ParentClassTypeID || int || Determines whether the Parent is a Store, Company, or Contact.   \\ 1000 - [[sql_structure_-_store_table]] \\ 2000 - [[sql_structure_-_account_table]] \\ 3000 - [[sql_structure_-_contact_table|sql_structure_-_contact_table]] ||   ||
|| AddressLink.ParentID || int || Links to the parent. || [[sql_structure_-_account_table]].ID \\ [[sql_structure_-_contact_table|sql_structure_-_contact_table]].ID \\ [[sql_structure_-_store_table]].ID ||
|| AddressLink.SeqID || int ||  ||   ||
|| AddressLink.StoreID || int || Not Used. ||   ||
Related Tables 



[[sql_structure_-_address_table Table]] 



[[sql_structure_-_element_table Table]] 



[[sql_structure_-_account_table Table]]



[[sql_structure_-_contact_table|sql_structure_-_contact_table Table]]



[[sql_structure_-_store_table Table]]