Table 5350 "CRM Incidentresolution"

Base Application · Microsoft.Integration.D365Sales · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	CRM Incidentresolution
TableType	CRM
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	ModifiedOn	DateTime	Modified On caption
2	ActualStart	Date	Actual Start caption
3	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
4	ActualDurationMinutes	Integer	Actual Duration caption
5	IsWorkflowCreated	Boolean	Is Workflow Created caption
6	ScheduledEnd	Date	Scheduled End caption
7	Category	Text[250]	—
8	IsBilled	Boolean	Is Billed caption
9	ActivityId	Guid	Case Resolution caption
10	StateCode	Option	Status caption	OptionCaption: Open,Completed,Canceled
11	Description	BLOB	—
12	StatusCode	Option	Status Reason caption	OptionCaption: ,Open,Closed,Canceled
13	OwnerId	Guid	Owner caption	TableRelation Table 5340 “CRM Systemuser”, Table 5359 “CRM Team” (if (OwnerIdType = const(systemuser)) “CRM Systemuser”.SystemUserId else if (OwnerIdType = const(team)) “CRM Team”.TeamId)
14	TimeSpent	Integer	Time Spent caption
15	Subject	Text[200]	—
16	CreatedOn	DateTime	Created On caption
17	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
18	ScheduledStart	Date	Scheduled Start caption
19	ScheduledDurationMinutes	Integer	Scheduled Duration caption
20	VersionNumber	BigInteger	Version Number caption
21	ActualEnd	Date	Actual End caption
22	OwningBusinessUnit	Guid	Owning Business Unit caption	TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId)
23	IncidentId	Guid	Case caption	TableRelation Table 5349 “CRM Incident” (if (IncidentIdType = const(incident)) “CRM Incident”.IncidentId)
24	Subcategory	Text[250]	Sub-Category caption
25	OwningUser	Guid	Owning User caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
26	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
27	IncidentIdName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Incident”.Title where(IncidentId = field(IncidentId)))
28	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
29	OwnerIdType	Option	—	OptionCaption: ,systemuser,team
30	ImportSequenceNumber	Integer	Import Sequence Number caption
31	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
32	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
33	OverriddenCreatedOn	Date	Record Created On caption
34	IncidentIdType	Option	—	OptionCaption: ,incident
35	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
36	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
37	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
38	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
39	IsRegularActivity	Boolean	Is Regular Activity caption
40	OwningTeam	Guid	Owning Team caption	TableRelation Table 5359 “CRM Team” (“CRM Team”.TeamId)

Keys

Key1: ActivityId (clustered)
Key2: Subject

Relations

CreatedByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedByName: CalcFormula Table 5340 “CRM Systemuser”
ModifiedOnBehalfByName: CalcFormula Table 5340 “CRM Systemuser”
CreatedBy: TableRelation Table 5340 “CRM Systemuser”
CreatedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
OwnerId: TableRelation Table 5340 “CRM Systemuser” (conditional)
OwningUser: TableRelation Table 5340 “CRM Systemuser”
IncidentIdName: CalcFormula Table 5349 “CRM Incident”
IncidentId: TableRelation Table 5349 “CRM Incident”
OwnerId: TableRelation Table 5359 “CRM Team” (conditional)
OwningTeam: TableRelation Table 5359 “CRM Team”
OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "CRM Incidentresolution"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.