DynamicsDocs.com

Diagrams

Table

CRM Incidentresolution

Fields |
Keys |
Relations To |
Relations From

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

Fields

#	Name	Type
1	ModifiedOn	DateTime	ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read Description: Date and time when the case resolution activity was last modified.
2	ActualStart	Date	ExternalName: actualstart ExternalType: DateTime Description: Actual start time of the case resolution activity.
3	CreatedBy	GUID	ExternalName: createdby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who created the case resolution activity. TableRelation: "CRM Systemuser".SystemUserId
4	ActualDurationMinutes	Integer	ExternalName: actualdurationminutes ExternalType: Integer Description: Actual duration of the case resolution activity in minutes.
5	IsWorkflowCreated	Boolean	ExternalName: isworkflowcreated ExternalType: Boolean Description: Information that specifies if the case resolution activity was created from a workflow rule.
6	ScheduledEnd	Date	ExternalName: scheduledend ExternalType: DateTime Description: Scheduled end time of the case resolution activity.
7	Category	Text250	ExternalName: category ExternalType: String Description: Category for the case resolution activity.
8	IsBilled	Boolean	ExternalName: isbilled ExternalType: Boolean Description: Information about whether the case resolution activity was billed as part of resolving a case.
9	ActivityId	GUID	ExternalName: activityid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the case resolution activity.
10	StateCode	Option	[Open,Completed,Canceled] OptionOrdinalValues: [0;1;2] InitValue: Open ExternalName: statecode ExternalType: State ExternalAccess: Modify Description: Shows whether the case resolution is open, completed, or canceled. By default, all case resolutions are completed and the status value can't be changed.
11	Description	BLOB [Memo]	ExternalName: description ExternalType: Memo Description: Type additional information that describes the case resolution.
12	StatusCode	Option	[ ,Open,Closed,Canceled] OptionOrdinalValues: [-1;1;2;3] InitValue: [ ] ExternalName: statuscode ExternalType: Status Description: Reason for the status of the case resolution activity.
13	OwnerId	GUID	ExternalName: ownerid ExternalType: Owner Description: Unique identifier of the user or team who owns the case resolution activity. TableRelation: IF (OwnerIdType=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (OwnerIdType=CONST(team)) "CRM Team".TeamId;
14	TimeSpent	Integer	ExternalName: timespent ExternalType: Integer Description: Time spent on the case resolution activity.
15	Subject	Text200	ExternalName: subject ExternalType: String Description: Subject associated with the case resolution activity.
16	CreatedOn	DateTime	ExternalName: createdon ExternalType: DateTime ExternalAccess: Read Description: Date and time when the case resolution activity was created.
17	ModifiedBy	GUID	ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who last modified the case resolution activity. TableRelation: "CRM Systemuser".SystemUserId
18	ScheduledStart	Date	ExternalName: scheduledstart ExternalType: DateTime Description: Scheduled start time of the case resolution activity.
19	ScheduledDurationMinutes	Integer	ExternalName: scheduleddurationminutes ExternalType: Integer ExternalAccess: Read Description: Scheduled duration of the case resolution activity, specified in minutes.
20	VersionNumber	BigInteger	ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read Description: Version number of the case.
21	ActualEnd	Date	ExternalName: actualend ExternalType: DateTime Description: Actual end time of the case resolution activity.
22	OwningBusinessUnit	GUID	ExternalName: owningbusinessunit ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the business unit that owns the case resolution activity. TableRelation: "CRM Businessunit".BusinessUnitId
23	IncidentId	GUID	ExternalName: incidentid ExternalType: Lookup Description: Unique identifier of the case. TableRelation: IF (IncidentIdType=CONST(incident)) "CRM Incident".IncidentId
24	Subcategory	Text250	ExternalName: subcategory ExternalType: String Description: Subcategory of the case resolution activity.
25	OwningUser	GUID	ExternalName: owninguser ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who owns the case resolution. TableRelation: "CRM Systemuser".SystemUserId
26	CreatedByName	Text200	ExternalName: createdbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedBy)))	FlowField
27	IncidentIdName	Text200	ExternalName: incidentidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Incident".Title WHERE (IncidentId=FIELD(IncidentId)))	FlowField
28	ModifiedByName	Text200	ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedBy)))	FlowField
29	OwnerIdType	Option	[ ,systemuser,team] ExternalName: owneridtype ExternalType: EntityName
30	ImportSequenceNumber	Integer	ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert Description: Unique identifier of the data import or data migration that created this record.
31	TimeZoneRuleVersionNumber	Integer	MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer Description: For internal use only.
32	UTCConversionTimeZoneCode	Integer	MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer Description: Time zone code that was in use when the record was created.
33	OverriddenCreatedOn	Date	ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert Description: Date and time that the record was migrated.
34	IncidentIdType	Option	[ ,incident] ExternalName: incidentidtype ExternalType: EntityName ExternalAccess: Read
35	CreatedOnBehalfBy	GUID	ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the delegate user who created the incidentresolution. TableRelation: "CRM Systemuser".SystemUserId
36	CreatedOnBehalfByName	Text200	ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedOnBehalfBy)))	FlowField
37	ModifiedOnBehalfBy	GUID	ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the delegate user who last modified the incidentresolution. TableRelation: "CRM Systemuser".SystemUserId
38	ModifiedOnBehalfByName	Text200	ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedOnBehalfBy)))	FlowField
39	IsRegularActivity	Boolean	ExternalName: isregularactivity ExternalType: Boolean ExternalAccess: Read Description: Information regarding whether the activity is a regular activity type or event type.
40	OwningTeam	GUID	ExternalName: owningteam ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the team who owns the case resolution. TableRelation: "CRM Team".TeamId

Keys

#	Fields
0	ActivityId		Clustered: Yes
1	Subject

Table Relations To Other Tables

Field	Related Table	Related Field
OwningBusinessUnit	CRM Businessunit	BusinessUnitId	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
IncidentId	CRM Incident	IncidentId	TableRelation: IF (IncidentIdType=CONST(incident)) "CRM Incident".IncidentId	1..n
ModifiedOnBehalfBy	CRM Systemuser	SystemUserId	TableRelation: "CRM Systemuser".SystemUserId	1..n
OwningTeam	CRM Team	TeamId	TableRelation: "CRM Team".TeamId	1..n

Table Relations From Other Tables

From Table	From Field
CRM Post	RegardingObjectId	TableRelation: IF (RegardingObjectTypeCode=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (RegardingObjectTypeCode=CONST(account)) "CRM Account".AccountId ELSE IF (RegardingObjectTypeCode=CONST(contact)) "CRM Contact".ContactId ELSE IF (RegardingObjectTypeCode=CONST(opportunity)) "CRM Opportunity".OpportunityId ELSE IF (RegardingObjectTypeCode=CONST(post)) "CRM Post".PostId ELSE IF (RegardingObjectTypeCode=CONST(transactioncurrency)) "CRM Transactioncurrency".TransactionCurrencyId ELSE IF (RegardingObjectTypeCode=CONST(pricelevel)) "CRM Pricelevel".PriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(productpricelevel)) "CRM Productpricelevel".ProductPriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(product)) "CRM Product".ProductId ELSE IF (RegardingObjectTypeCode=CONST(incident)) "CRM Incident".IncidentId ELSE IF (RegardingObjectTypeCode=CONST(incidentresolution)) "CRM Incidentresolution".ActivityId ELSE IF (RegardingObjectTypeCode=CONST(quote)) "CRM Quote".QuoteId ELSE IF (RegardingObjectTypeCode=CONST(quotedetail)) "CRM Quotedetail".QuoteDetailId ELSE IF (RegardingObjectTypeCode=CONST(salesorder)) "CRM Salesorder".SalesOrderId ELSE IF (RegardingObjectTypeCode=CONST(salesorderdetail)) "CRM Salesorderdetail".SalesOrderDetailId ELSE IF (RegardingObjectTypeCode=CONST(invoice)) "CRM Invoice".InvoiceId ELSE IF (RegardingObjectTypeCode=CONST(invoicedetail)) "CRM Invoicedetail".InvoiceDetailId ELSE IF (RegardingObjectTypeCode=CONST(contract)) "CRM Contract".ContractId ELSE IF (RegardingObjectTypeCode=CONST(team)) "CRM Team".TeamId ELSE IF (RegardingObjectTypeCode=CONST(customeraddress)) "CRM Customeraddress".CustomerAddressId ELSE IF (RegardingObjectTypeCode=CONST(uom)) "CRM Uom".UoMId ELSE IF (RegardingObjectTypeCode=CONST(uomschedule)) "CRM Uomschedule".UoMScheduleId ELSE IF (RegardingObjectTypeCode=CONST(organization)) "CRM Organization".OrganizationId ELSE IF (RegardingObjectTypeCode=CONST(businessunit)) "CRM Businessunit".BusinessUnitId ELSE IF (RegardingObjectTypeCode=CONST(discount)) "CRM Discount".DiscountId ELSE IF (RegardingObjectTypeCode=CONST(discounttype)) "CRM Discounttype".DiscountTypeId;	1..n