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