Updated: 2009-09-21



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is ...



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 23110 - Contact Acitvity Action
    * 23120 - Email Action
    * 23130 - Report Action
    * 23141 - UDF Action
    * 23144 - Popup Action
    * 23146 - Transaction Action
    * 23148 - Another Macro Action
    * 23150 - Company Activity Action?
    * 23160 - Service Contract Action
    * 23170 - Work Assignment Action?
    * 23180 - Transaction Update Action



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| RuleAction.ActionName || nvarchar(50) ||  ||   ||
|| RuleAction.AllowUserToCancel || bit ||  ||   ||
|| RuleAction.Category || int ||  ||   ||
|| RuleAction.ChildItemClassTypeID || int ||  ||   ||
|| RuleAction.ChildItemID || int ||  ||   ||
|| RuleAction.ChildItemStoreID || int || Not Used. ||   ||
|| RuleAction.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| RuleAction.ClearUserField || bit ||  ||   ||
|| RuleAction.ContactReplacementType || int ||  ||   ||
|| RuleAction.DateOffsetType || int ||  ||   ||
|| RuleAction.DateType || int ||  ||   ||
|| RuleAction.DelActivityOnStatusChange || bit ||  ||   ||
|| RuleAction.EmployeeReplacementType || int ||  ||   ||
|| RuleAction.ExecuteAsGroup || bit ||  ||   ||
|| RuleAction.FixedDaysOffset || int ||  ||   ||
|| RuleAction.FixedTime || float ||  ||   ||
|| RuleAction.GroupAction || bit ||  ||   ||
|| RuleAction.ID || int || Primary Key for the Table ||   ||
|| RuleAction.IsActive || bit || Not Used for This Table ||   ||
|| RuleAction.IsSystem || bit || Used to Mark Required Records ||   ||
|| RuleAction.Message || text ||  ||   ||
|| RuleAction.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| RuleAction.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| RuleAction.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| RuleAction.OffsetBeforeDate || bit ||  ||   ||
|| RuleAction.ParentClassTypeID || int ||  ||   ||
|| RuleAction.ParentID || int || ID of Category/Group Above ||   ||
|| RuleAction.ParentStoreID || int || Not Used. ||   ||
|| RuleAction.Preview || bit ||  ||   ||
|| RuleAction.ReplaceContract || bit ||  ||   ||
|| RuleAction.ReplaceCustomer || bit ||  ||   ||
|| RuleAction.ReplaceDisposition || bit ||  ||   ||
|| RuleAction.ReplaceDispositionID || int ||  ||   ||
|| RuleAction.ReplaceStation || bit ||  ||   ||
|| RuleAction.ReplaceStatusID || int ||  ||   ||
|| RuleAction.ReplaceTransaction || bit ||  ||   ||
|| RuleAction.SaveRecord || bit ||  ||   ||
|| RuleAction.SeqID || int ||  ||   ||
|| RuleAction.ServiceContractID || int ||  ||   ||
|| RuleAction.SetOnlyIfBlank || bit ||  ||   ||
|| RuleAction.SortIndex || float ||  ||   ||
|| RuleAction.StationClassTypeID || int ||  ||   ||
|| RuleAction.StationID || int ||  ||   ||
|| RuleAction.StoreID || int || Not Used. ||   ||
|| RuleAction.textAppendOptions || int ||  ||   ||
|| RuleAction.TransactionType || int ||  ||   ||
|| RuleAction.UseCurrentDate || bit ||  ||   ||
|| RuleAction.UseCurrentTime || bit ||  ||   ||
|| RuleAction.UserFieldDataType || int ||  ||   ||
|| RuleAction.UserFieldName || nvarchar(50) ||  ||   ||
|| RuleAction.UserFieldSetValue || bit ||  ||   ||
|| RuleAction.UserFieldValue || text ||  ||   ||
Related Tables