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.