Table 5349 CRM Incident in 20
- App
- Base Application
Versions171819202122232425262728latest
Source29
Fields, 86
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | IncidentId | Guid | - |
| 2 | OwningBusinessUnit | Guid | - |
| 3 | ContractId | Guid | - |
| 4 | OwningUser | Guid | - |
| 5 | ActualServiceUnits | Integer | - |
| 6 | CaseOriginCode | Option | - |
| 7 | BilledServiceUnits | Integer | - |
| 8 | CaseTypeCode | Option | - |
| 9 | ProductSerialNumber | Text[100] | - |
| 10 | Title | Text[200] | - |
| 11 | ProductId | Guid | - |
| 12 | ContractServiceLevelCode | Option | - |
| 13 | AccountId | Guid | - |
| 14 | Description | Blob | - |
| 15 | ContactId | Guid | - |
| 16 | IsDecrementing | Boolean | - |
| 17 | CreatedOn | DateTime | - |
| 18 | TicketNumber | Text[100] | - |
| 19 | PriorityCode | Option | - |
| 20 | CustomerSatisfactionCode | Option | - |
| 21 | IncidentStageCode | Option | - |
| 22 | ModifiedOn | DateTime | - |
| 23 | CreatedBy | Guid | - |
| 24 | FollowupBy | Date | - |
| 25 | ModifiedBy | Guid | - |
| 26 | VersionNumber | BigInteger | - |
| 27 | StateCode | Option | - |
| 28 | SeverityCode | Option | - |
| 29 | StatusCode | Option | - |
| 30 | ResponsibleContactId | Guid | - |
| 31 | AccountIdName | Text[160] | - |
| 32 | ContactIdName | Text[160] | - |
| 33 | ResponsibleContactIdName | Text[160] | - |
| 34 | ContractIdName | Text[100] | - |
| 35 | ProductIdName | Text[100] | - |
| 36 | CreatedByName | Text[200] | - |
| 37 | ModifiedByName | Text[200] | - |
| 38 | CustomerId | Guid | - |
| 39 | CustomerIdType | Option | - |
| 40 | OwnerId | Guid | - |
| 41 | OwnerIdType | Option | - |
| 42 | TimeZoneRuleVersionNumber | Integer | - |
| 43 | ImportSequenceNumber | Integer | - |
| 44 | UTCConversionTimeZoneCode | Integer | - |
| 45 | OverriddenCreatedOn | Date | - |
| 46 | CreatedOnBehalfBy | Guid | - |
| 47 | CreatedOnBehalfByName | Text[200] | - |
| 48 | ModifiedOnBehalfBy | Guid | - |
| 49 | ModifiedOnBehalfByName | Text[200] | - |
| 50 | OwningTeam | Guid | - |
| 51 | TransactionCurrencyId | Guid | - |
| 52 | TransactionCurrencyIdName | Text[100] | - |
| 53 | ExchangeRate | Decimal | - |
| 54 | ServiceStage | Option | - |
| 55 | ExistingCase | Guid | - |
| 56 | StageId | Guid | - |
| 57 | ProcessId | Guid | - |
| 58 | EntityImageId | Guid | - |
| 59 | CheckEmail | Boolean | - |
| 60 | ActivitiesComplete | Boolean | - |
| 61 | FollowUpTaskCreated | Boolean | - |
| 62 | NumberOfChildIncidents | Integer | - |
| 63 | MessageTypeCode | Option | - |
| 64 | BlockedProfile | Boolean | - |
| 65 | MasterId | Guid | - |
| 66 | MasterIdName | Text[200] | - |
| 67 | TraversedPath | Text[250] | - |
| 68 | ParentCaseId | Guid | - |
| 69 | DecrementEntitlementTerm | Boolean | - |
| 70 | ParentCaseIdName | Text[200] | - |
| 71 | SentimentValue | Decimal | - |
| 72 | InfluenceScore | Decimal | - |
| 73 | Merged | Boolean | - |
| 74 | RouteCase | Boolean | - |
| 75 | ResolveBy | DateTime | - |
| 76 | ResponseBy | DateTime | - |
| 77 | CustomerContacted | Boolean | - |
| 78 | IsEscalated | Boolean | - |
| 79 | EscalatedOn | DateTime | - |
| 80 | PrimaryContactId | Guid | - |
| 81 | PrimaryContactIdName | Text[160] | - |
| 82 | FirstResponseSent | Boolean | - |
| 83 | FirstResponseSLAStatus | Option | - |
| 84 | ResolveBySLAStatus | Option | - |
| 85 | OnHoldTime | Integer | - |
| 86 | LastOnHoldTime | DateTime | - |
Keys, 2
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | IncidentId | - |
| Key2 | Title | - |