CRM Incidentresolution

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 (ModifiedOn)	DateTime	ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read Description: Date and time when the case resolution activity was last modified.
2	ActualStart (ActualStart)	Date	ExternalName: actualstart ExternalType: DateTime Description: Actual start time of the case resolution activity.
3	CreatedBy (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 (ActualDurationMinutes)	Integer	ExternalName: actualdurationminutes ExternalType: Integer Description: Actual duration of the case resolution activity in minutes.
5	IsWorkflowCreated (IsWorkflowCreated)	Boolean	ExternalName: isworkflowcreated ExternalType: Boolean Description: Information that specifies if the case resolution activity was created from a workflow rule.
6	ScheduledEnd (ScheduledEnd)	Date	ExternalName: scheduledend ExternalType: DateTime Description: Scheduled end time of the case resolution activity.
7	Category (Category)	Text250	ExternalName: category ExternalType: String Description: Category for the case resolution activity.
8	IsBilled (IsBilled)	Boolean	ExternalName: isbilled ExternalType: Boolean Description: Information about whether the case resolution activity was billed as part of resolving a case.
9	ActivityId (ActivityId)	GUID	ExternalName: activityid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the case resolution activity.
10	StateCode (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 (Description)	BLOB [Memo]	ExternalName: description ExternalType: Memo Description: Type additional information that describes the case resolution.
12	StatusCode (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 (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 (TimeSpent)	Integer	ExternalName: timespent ExternalType: Integer Description: Time spent on the case resolution activity.
15	Subject (Subject)	Text200	ExternalName: subject ExternalType: String Description: Subject associated with the case resolution activity.
16	CreatedOn (CreatedOn)	DateTime	ExternalName: createdon ExternalType: DateTime ExternalAccess: Read Description: Date and time when the case resolution activity was created.
17	ModifiedBy (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 (ScheduledStart)	Date	ExternalName: scheduledstart ExternalType: DateTime Description: Scheduled start time of the case resolution activity.
19	ScheduledDurationMinutes (ScheduledDurationMinutes)	Integer	ExternalName: scheduleddurationminutes ExternalType: Integer ExternalAccess: Read Description: Scheduled duration of the case resolution activity, specified in minutes.
20	VersionNumber (VersionNumber)	BigInteger	ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read Description: Version number of the case.
21	ActualEnd (ActualEnd)	Date	ExternalName: actualend ExternalType: DateTime Description: Actual end time of the case resolution activity.
22	OwningBusinessUnit (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 (IncidentId)	GUID	ExternalName: incidentid ExternalType: Lookup Description: Unique identifier of the case. TableRelation: IF (IncidentIdType=CONST(incident)) "CRM Incident".IncidentId
24	Subcategory (Subcategory)	Text250	ExternalName: subcategory ExternalType: String Description: Subcategory of the case resolution activity.
25	OwningUser (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 (CreatedByName)	Text200	ExternalName: createdbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedBy)))	FlowField
27	IncidentIdName (IncidentIdName)	Text200	ExternalName: incidentidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Incident".Title WHERE (IncidentId=FIELD(IncidentId)))	FlowField
28	ModifiedByName (ModifiedByName)	Text200	ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedBy)))	FlowField
29	OwnerIdType (OwnerIdType)	Option	[ ,systemuser,team] ExternalName: owneridtype ExternalType: EntityName
30	ImportSequenceNumber (ImportSequenceNumber)	Integer	ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert Description: Unique identifier of the data import or data migration that created this record.
31	TimeZoneRuleVersionNumber (TimeZoneRuleVersionNumber)	Integer	MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer Description: For internal use only.
32	UTCConversionTimeZoneCode (UTCConversionTimeZoneCode)	Integer	MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer Description: Time zone code that was in use when the record was created.
33	OverriddenCreatedOn (OverriddenCreatedOn)	Date	ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert Description: Date and time that the record was migrated.
34	IncidentIdType (IncidentIdType)	Option	[ ,incident] ExternalName: incidentidtype ExternalType: EntityName ExternalAccess: Read
35	CreatedOnBehalfBy (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 (CreatedOnBehalfByName)	Text200	ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedOnBehalfBy)))	FlowField
37	ModifiedOnBehalfBy (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 (ModifiedOnBehalfByName)	Text200	ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedOnBehalfBy)))	FlowField
39	IsRegularActivity (IsRegularActivity)	Boolean	ExternalName: isregularactivity ExternalType: Boolean ExternalAccess: Read Description: Information regarding whether the activity is a regular activity type or event type.
40	OwningTeam (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 (ActivityId)		Clustered: Yes
1	Subject (Subject)

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table	From Field
CRM Post	RegardingObjectId (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