Updated: 2009-09-21



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is ...



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 5501 - Marking List Item
  * Use MarketingListID to identify the type of Marketing List Item in the table:
    * 10  Industry
    * 11  Origin (Company)
    * 13  Origin (Order)
    * 14  User Defined (Region by Default)



Note: This table may contain nested Marketing Items, in which case ParentID points back to this table.  Otherwise ParentID points to the [[sql_structure_-_element_table]].  The can be determined by looiking at the the ParentClassTypeID, where 5501 points to a parent Item but 5500 points to a category (in the Element table).



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| MarketingListItem.CanSelect || bit ||  ||   ||
|| MarketingListItem.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| MarketingListItem.Code1 || nvarchar(20) ||  ||   ||
|| MarketingListItem.Code2 || nvarchar(20) ||  ||   ||
|| MarketingListItem.Description || nvarchar(50) ||  ||   ||
|| MarketingListItem.ID || int || Primary Key for the Table ||   ||
|| MarketingListItem.IsActive || bit || Indicates if Enabled.  1Record is Active, 0Record is Not Active ||   ||
|| MarketingListItem.IsSystem || bit || Used to Mark Required Records ||   ||
|| MarketingListItem.ItemName || nvarchar(25) ||  ||   ||
|| MarketingListItem.MarketingListClassTypeID || int ||  ||   ||
|| MarketingListItem.MarketingListID || int || Top Level Marketing Category || MarketingListID  [[sql_structure_-_element_table]].ID where Element.ClassTypeID  5500 ||
|| MarketingListItem.MarketingListStoreID || int || Not Used. ||   ||
|| MarketingListItem.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| MarketingListItem.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| MarketingListItem.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| MarketingListItem.ParentClassTypeID || int || ClassTypeID of Parent. \\ * 5500  Top Level Category \\ * 5501  Parent Item ||   ||
|| MarketingListItem.ParentID || int || ID of Category/Group Above || ParentID  [[sql_structure_-_marketinglistitem_table]].ID \\ where ClassTypeID  5501 (item), \\ ParentID  [[sql_structure_-_element_table]].ID  \\ where ClassTypeID  5500 (category)  ||
|| MarketingListItem.ParentStoreID || int || Not Used. ||   ||
|| MarketingListItem.SeqID || int ||  ||   ||
|| MarketingListItem.StoreID || int || Not Used. ||   ||
Related Tables