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 | |||||
| AddressLink.ParentID | int | Links to the parent. | sql_structure_-_account_table.ID 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 Table
sql_structure_-_store_table Table
You could leave a comment if you were logged in.