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

You could leave a comment if you were logged in.