Diagrams


Table

CRM Incident

DynamicsDocs.comCRM Incident«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...«Table 5344»CRM PostCreatedByCreatedByNameCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameOrganizationIdOrganizationIdNamePostId [PK]RegardingObjectIdRegardingObjectTypeCode; [,systemuser,...Source; [AutoPost,ManualPost]TextTimeZoneRuleVersionNumberType; [Check-in,Idea,News,PrivateMessa...UTCConversionTimeZoneCodeRegardingObjectOwnerIdRegardingObjectOwnerIdType; [,systemus...RegardingObjectOwningBusinessUModifiedByModifiedByNameModifiedOnBehalfByModifiedOnBehalfByNameModifiedOn«Table 5350»CRM IncidentresolutionModifiedOnActualStartCreatedByActualDurationMinutesIsWorkflowCreatedScheduledEndCategoryIsBilledActivityId [PK]StateCode; [Open,Completed,Canceled]DescriptionStatusCode; [,Open,Closed,Canceled]OwnerIdTimeSpentSubjectCreatedOnModifiedByScheduledStartScheduledDurationMinutesVersionNumberActualEndOwningBusinessUnitIncidentIdSubcategoryOwningUserCreatedByNameIncidentIdNameModifiedByNameOwnerIdType; [,systemuser,team]ImportSequenceNumberTimeZoneRuleVersionNumber...«Table 5364»CRM BusinessunitBusinessUnitId [PK]OrganizationIdNameDescriptionDivisionNameFileAsNameTickerSymbolStockExchangeUTCOffsetCreatedOnModifiedOnCreditLimitCostCenterWebSiteUrlFtpSiteUrlEMailAddressInheritanceMaskCreatedByModifiedByWorkflowSuspendedParentBusinessUnitIdIsDisabledDisabledReasonVersionNumberParentBusinessUnitIdNameAddress1_AddressIdAddress1_AddressTypeCode; [DefaultValu...Address1_NameAddress1_Line1Address1_Line2Address1_Line3...«Table 5357»CRM ContractContractId [PK]OwningBusinessUnitContractServiceLevelCode; [Gold,Silver...ServiceAddressBillToAddressOwningUserContactIdAccountIdBillingAccountIdContractNumberBillingContactIdActiveOnExpiresOnCancelOnTitleContractLanguageBillingStartOnEffectivityCalendarBillingEndOnBillingFrequencyCode; [Monthly,Bimonth...CreatedByCreatedOnModifiedByAllotmentTypeCode; [,NumberofCases,Tim...UseDiscountAsPercentageModifiedOnTotalPriceVersionNumberTotalDiscountStateCode; [Draft,Invoiced,Active,OnHo...NetPrice...«Table 5340»CRM SystemuserSystemUserId [PK]OrganizationIdBusinessUnitIdParentSystemUserIdFirstNameSalutationMiddleNameLastNamePersonalEMailAddressFullNameNickNameTitleInternalEMailAddressJobTitleMobileAlertEMailPreferredEmailCode; [DefaultValue]HomePhoneMobilePhonePreferredPhoneCode; [MainPhone,OtherPh...PreferredAddressCode; [MailingAddress,...PhotoUrlDomainNamePassportLoCreatedOnPassportHiDisabledReasonModifiedOnCreatedByEmployeeIdModifiedByIsDisabled...«Table 5348»CRM ProductProductId [PK]DefaultUoMScheduleIdOrganizationIdNameDefaultUoMIdPriceLevelIdDescriptionProductTypeCode; [SalesInventory,Misce...ProductUrlPriceIsKitProductNumberSizeCurrentCostStockVolumeStandardCostStockWeightQuantityDecimalQuantityOnHandIsStockItemSupplierNameVendorNameVendorPartNumberCreatedOnModifiedOnCreatedByStateCode; [Active,Retired,Draft,Under...ModifiedByStatusCode; [,Active,Retired,Draft,Und...VersionNumberDefaultUoMIdName...«Table 5341»CRM AccountAccountId [PK]AccountCategoryCode; [,PreferredCustom...DefaultPriceLevelIdCustomerSizeCode; [DefaultValue]PreferredContactMethodCode; [Any,Email...CustomerTypeCode; [,Competitor,Consult...AccountRatingCode; [DefaultValue]IndustryCode; [,Accounting,Agriculture...TerritoryCode; [DefaultValue]AccountClassificationCode; [DefaultVal...BusinessTypeCode; [DefaultValue]OwningBusinessUnitTraversedPathOwningUserPaymentTermsCode; [,Net30,2%10Net30,Ne...ShippingMethodCode; [DefaultValue]PrimaryContactIdParticipatesInWorkflowNameAccountNumberRevenueNumberOfEmployeesDescriptionSICOwnershipCode; [,Public,Private,Subsid...MarketCapSharesOutstandingTickerSymbolStockExchangeWebSiteURLFtpSiteURL...«Table 5342»CRM ContactContactId [PK]DefaultPriceLevelIdCustomerSizeCode; [DefaultValue]CustomerTypeCode; [DefaultValue]PreferredContactMethodCode; [Any,Email...LeadSourceCode; [DefaultValue]OwningBusinessUnitOwningUserPaymentTermsCode; [,Net30,2%10Net30,Ne...ShippingMethodCode; [DefaultValue]AccountIdParticipatesInWorkflowIsBackofficeCustomerSalutationJobTitleFirstNameDepartmentNickNameMiddleNameLastNameSuffixYomiFirstNameFullNameYomiMiddleNameYomiLastNameAnniversaryBirthDateGovernmentIdYomiFullNameDescriptionEmployeeId...«Table 5359»CRM TeamTeamId [PK]OrganizationIdBusinessUnitIdNameDescriptionEMailAddressCreatedOnModifiedOnCreatedByModifiedByVersionNumberCreatedByNameModifiedByNameBusinessUnitIdNameImportSequenceNumberOverriddenCreatedOnAdministratorIdIsDefaultAdministratorIdNameYomiNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameTraversedPathTransactionCurrencyIdTransactionCurrencyIdNameExchangeRateTeamType; [Owner,Access]RegardingObjectIdSystemManaged...«Table 5345»CRM TransactioncurrencyStatusCode; [,Active,Inactive]ModifiedOnStateCode; [Active,Inactive]VersionNumberModifiedByImportSequenceNumberOverriddenCreatedOnCreatedOnTransactionCurrencyId [PK]ExchangeRateCurrencySymbolCurrencyNameCreatedByISOCurrencyCodeOrganizationIdModifiedByNameCreatedByNameCurrencyPrecisionCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameEntityImageId<OwningBusinessUnit><ContractId><ProductId><AccountId><CustomerId><ContactId><ResponsibleContactId><CustomerId><PrimaryContactId><OwnerId><OwningTeam><TransactionCurrencyId><ExistingCase><MasterId><ParentCaseId><RegardingObjectId><IncidentId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectOwningBusinessU><OwnerId><OwningTeam><OwningBusinessUnit><ParentBusinessUnitId><TransactionCurrencyId><BusinessUnitId><OwningBusinessUnit><OwningBusinessUnit><OwningBusinessUnit><BusinessUnitId><ContactId><BillingContactId><CustomerId><BillingCustomerId><AccountId><BillingAccountId><CustomerId><BillingCustomerId><OriginatingContract><OwnerId><OwningTeam><TransactionCurrencyId><TransactionCurrencyId><AdministratorId><TransactionCurrencyId><ParentProductId><PrimaryContactId><AccountId><ParentCustomerId><ParentAccountId><MasterId><OwnerId><OwningTeam><TransactionCurrencyId><ParentContactId><MasterId><ParentCustomerId><OwnerId><OwningTeam><TransactionCurrencyId><TransactionCurrencyId>

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

Fields

# Name Type
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 Text100
10 Title Text200
11 ProductId GUID
12 ContractServiceLevelCode Option
13 AccountId GUID
14 Description BLOB [Memo]
15 ContactId GUID
16 IsDecrementing Boolean
17 CreatedOn DateTime
18 TicketNumber Text100
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 Text160 FlowField
32 ContactIdName Text160 FlowField
33 ResponsibleContactIdName Text160 FlowField
34 ContractIdName Text100 FlowField
35 ProductIdName Text100 FlowField
36 CreatedByName Text200 FlowField
37 ModifiedByName Text200 FlowField
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 Text200 FlowField
48 ModifiedOnBehalfBy GUID
49 ModifiedOnBehalfByName Text200 FlowField
50 OwningTeam GUID
51 TransactionCurrencyId GUID
52 TransactionCurrencyIdName Text100 FlowField
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 Text200 FlowField
67 TraversedPath Text250
68 ParentCaseId GUID
69 DecrementEntitlementTerm Boolean
70 ParentCaseIdName Text200 FlowField
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 Text160 FlowField
82 FirstResponseSent Boolean
83 FirstResponseSLAStatus Option
84 ResolveBySLAStatus Option
85 OnHoldTime Integer
86 LastOnHoldTime DateTime

Keys

# Fields
0 IncidentId Clustered: Yes
1 Title

Table Relations To Other Tables

Field Related Table Related Field
CustomerId CRM Account AccountId 1..n
OwningBusinessUnit CRM Businessunit BusinessUnitId 1..n
PrimaryContactId CRM Contact ContactId 1..n
ContractId CRM Contract ContractId 1..n
ParentCaseId CRM Incident IncidentId 1..n
ProductId CRM Product ProductId 1..n
ModifiedOnBehalfBy CRM Systemuser SystemUserId 1..n
OwningTeam CRM Team TeamId 1..n
TransactionCurrencyId CRM Transactioncurrency TransactionCurrencyId 1..n

Table Relations From Other Tables

From Table From Field
CRM Incident ParentCaseId 1..n
CRM Incidentresolution IncidentId 1..n
CRM Post RegardingObjectId 1..n