{$page}
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
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 | Address.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. | Element.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 - Store 2000 - Company 3000 - Contact | |||||
| AddressLink.ParentID | int | Links to the parent. | Account.ID Contact.ID Store.ID |
||||
| AddressLink.SeqID | int | ||||||
| AddressLink.StoreID | int | Not Used. |
Related Tables
See Also