{$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
- 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 | 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
- Backlinks include_pagepage_componentbacklinks
You could leave a comment if you were logged in.