Diagrams


Table

CRM Incidentresolution

DynamicsDocs.comCRM Incidentresolution«Table 5350»CRM IncidentresolutionModifiedOnActualStartCreatedByActualDurationMinutesIsWorkflowCreatedScheduledEndCategoryIsBilledActivityId [PK]StateCode; [Open,Completed,Canceled]DescriptionStatusCode; [,Open,Closed,Canceled]OwnerIdTimeSpentSubjectCreatedOnModifiedByScheduledStartScheduledDurationMinutesVersionNumberActualEndOwningBusinessUnitIncidentIdSubcategoryOwningUserCreatedByNameIncidentIdNameModifiedByNameOwnerIdType; [,systemuser,team]ImportSequenceNumberTimeZoneRuleVersionNumber...«Table 5344»CRM PostCreatedByCreatedByNameCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameOrganizationIdOrganizationIdNamePostId [PK]RegardingObjectIdRegardingObjectTypeCode; [,systemuser,...Source; [AutoPost,ManualPost]TextTimeZoneRuleVersionNumberType; [Check-in,Idea,News,PrivateMessa...UTCConversionTimeZoneCodeRegardingObjectOwnerIdRegardingObjectOwnerIdType; [,systemus...RegardingObjectOwningBusinessUModifiedByModifiedByNameModifiedOnBehalfByModifiedOnBehalfByNameModifiedOn«Table 5340»CRM SystemuserSystemUserId [PK]OrganizationIdBusinessUnitIdParentSystemUserIdFirstNameSalutationMiddleNameLastNamePersonalEMailAddressFullNameNickNameTitleInternalEMailAddressJobTitleMobileAlertEMailPreferredEmailCode; [DefaultValue]HomePhoneMobilePhonePreferredPhoneCode; [MainPhone,OtherPh...PreferredAddressCode; [MailingAddress,...PhotoUrlDomainNamePassportLoCreatedOnPassportHiDisabledReasonModifiedOnCreatedByEmployeeIdModifiedByIsDisabled...«Table 5359»CRM TeamTeamId [PK]OrganizationIdBusinessUnitIdNameDescriptionEMailAddressCreatedOnModifiedOnCreatedByModifiedByVersionNumberCreatedByNameModifiedByNameBusinessUnitIdNameImportSequenceNumberOverriddenCreatedOnAdministratorIdIsDefaultAdministratorIdNameYomiNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameTraversedPathTransactionCurrencyIdTransactionCurrencyIdNameExchangeRateTeamType; [Owner,Access]RegardingObjectIdSystemManaged...«Table 5364»CRM BusinessunitBusinessUnitId [PK]OrganizationIdNameDescriptionDivisionNameFileAsNameTickerSymbolStockExchangeUTCOffsetCreatedOnModifiedOnCreditLimitCostCenterWebSiteUrlFtpSiteUrlEMailAddressInheritanceMaskCreatedByModifiedByWorkflowSuspendedParentBusinessUnitIdIsDisabledDisabledReasonVersionNumberParentBusinessUnitIdNameAddress1_AddressIdAddress1_AddressTypeCode; [DefaultValu...Address1_NameAddress1_Line1Address1_Line2Address1_Line3...«Table 5349»CRM IncidentIncidentId [PK]OwningBusinessUnitContractIdOwningUserActualServiceUnitsCaseOriginCode; [,Phone,Email,Web,Face...BilledServiceUnitsCaseTypeCode; [,Question,Problem,Reque...ProductSerialNumberTitleProductIdContractServiceLevelCode; [,Gold,Silve...AccountIdDescriptionContactIdIsDecrementingCreatedOnTicketNumberPriorityCode; [High,Normal,Low]CustomerSatisfactionCode; [,VerySatisf...IncidentStageCode; [DefaultValue]ModifiedOnCreatedByFollowupByModifiedByVersionNumberStateCode; [Active,Resolved,Canceled]SeverityCode; [DefaultValue]StatusCode; [,ProblemSolved,Informatio...ResponsibleContactIdAccountIdName...<OwnerId><OwningTeam><OwningBusinessUnit><IncidentId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectOwningBusinessU><BusinessUnitId><AdministratorId><BusinessUnitId><OwnerId><OwningTeam><ParentBusinessUnitId><OwningBusinessUnit><ExistingCase><MasterId><ParentCaseId>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 ModifiedOn DateTime
2 ActualStart Date
3 CreatedBy GUID
4 ActualDurationMinutes Integer
5 IsWorkflowCreated Boolean
6 ScheduledEnd Date
7 Category Text250
8 IsBilled Boolean
9 ActivityId GUID
10 StateCode Option
11 Description BLOB [Memo]
12 StatusCode Option
13 OwnerId GUID
14 TimeSpent Integer
15 Subject Text200
16 CreatedOn DateTime
17 ModifiedBy GUID
18 ScheduledStart Date
19 ScheduledDurationMinutes Integer
20 VersionNumber BigInteger
21 ActualEnd Date
22 OwningBusinessUnit GUID
23 IncidentId GUID
24 Subcategory Text250
25 OwningUser GUID
26 CreatedByName Text200 FlowField
27 IncidentIdName Text200 FlowField
28 ModifiedByName Text200 FlowField
29 OwnerIdType Option
30 ImportSequenceNumber Integer
31 TimeZoneRuleVersionNumber Integer
32 UTCConversionTimeZoneCode Integer
33 OverriddenCreatedOn Date
34 IncidentIdType Option
35 CreatedOnBehalfBy GUID
36 CreatedOnBehalfByName Text200 FlowField
37 ModifiedOnBehalfBy GUID
38 ModifiedOnBehalfByName Text200 FlowField
39 IsRegularActivity Boolean
40 OwningTeam GUID

Keys

# Fields
0 ActivityId Clustered: Yes
1 Subject

Table Relations To Other Tables

Field Related Table Related Field
OwningBusinessUnit CRM Businessunit BusinessUnitId 1..n
IncidentId CRM Incident IncidentId 1..n
ModifiedOnBehalfBy CRM Systemuser SystemUserId 1..n
OwningTeam CRM Team TeamId 1..n

Table Relations From Other Tables

From Table From Field
CRM Post RegardingObjectId 1..n