Table 5349 "CRM Incident"

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

Properties

Property	Value
Caption	CRM Incident
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	IncidentId	Guid	Case caption
2	OwningBusinessUnit	Guid	Owning Business Unit caption	TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId)
3	ContractId	Guid	Contract caption	TableRelation Table 5357 “CRM Contract” (“CRM Contract”.ContractId)
4	OwningUser	Guid	Owning User caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
5	ActualServiceUnits	Integer	Actual Service Units caption
6	CaseOriginCode	Option	Origin caption	OptionCaption: ,Phone,Email,Web,Facebook,Twitter
7	BilledServiceUnits	Integer	Billed Service Units caption
8	CaseTypeCode	Option	Case Type caption	OptionCaption: ,Question,Problem,Request
9	ProductSerialNumber	Text[100]	Serial Number caption
10	Title Δ BC28	Text[200]	Specifies the name of the case.
11	ProductId	Guid	Product caption	TableRelation Table 5348 “CRM Product” (“CRM Product”.ProductId)
12	ContractServiceLevelCode	Option	Service Level caption	OptionCaption: ,Gold,Silver,Bronze
13	AccountId	Guid	Account caption	TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
14	Description	BLOB	—
15	ContactId	Guid	Contact caption	TableRelation Table 5342 “CRM Contact” (“CRM Contact”.ContactId)
16	IsDecrementing	Boolean	Decrementing caption
17	CreatedOn Δ BC28	DateTime	Specifies when the sales order was created.
18	TicketNumber Δ BC28	Text[100]	Specifies the number of the case.
19	PriorityCode	Option	Priority caption	OptionCaption: High,Normal,Low
20	CustomerSatisfactionCode	Option	Satisfaction caption	OptionCaption: ,Very Satisfied,Satisfied,Neutral,Dissatisfied,Very Dissatisfied
21	IncidentStageCode	Option	Case Stage caption	OptionCaption: Default Value
22	ModifiedOn	DateTime	Modified On caption
23	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
24	FollowupBy	Date	Follow Up By caption
25	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
26	VersionNumber	BigInteger	Version Number caption
27	StateCode Δ BC28	Option	Specifies the status of the case.	OptionCaption: Active,Resolved,Canceled
28	SeverityCode	Option	Severity caption	OptionCaption: Default Value
29	StatusCode	Option	Status Reason caption	OptionCaption: ,Problem Solved,Information Provided,Canceled,Merged,In Progress,On Hold,Waiting for Details,Researching
30	ResponsibleContactId	Guid	Responsible Contact caption	TableRelation Table 5342 “CRM Contact” (“CRM Contact”.ContactId)
31	AccountIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Account”.Name where(AccountId = field(AccountId)))
32	ContactIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Contact”.FullName where(ContactId = field(ContactId)))
33	ResponsibleContactIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Contact”.FullName where(ContactId = field(ResponsibleContactId)))
34	ContractIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Contract”.Title where(ContractId = field(ContractId)))
35	ProductIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Product”.Name where(ProductId = field(ProductId)))
36	CreatedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedBy)))
37	ModifiedByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedBy)))
38	CustomerId	Guid	Customer caption	TableRelation Table 5341 “CRM Account”, Table 5342 “CRM Contact” (if (CustomerIdType = const(account)) “CRM Account”.AccountId else if (CustomerIdType = const(contact)) “CRM Contact”.ContactId)
39	CustomerIdType	Option	Customer Type caption	OptionCaption: ,account,contact
40	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)
41	OwnerIdType	Option	—	OptionCaption: ,systemuser,team
42	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
43	ImportSequenceNumber	Integer	Import Sequence Number caption
44	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
45	OverriddenCreatedOn	Date	Record Created On caption
46	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
47	CreatedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(CreatedOnBehalfBy)))
48	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
49	ModifiedOnBehalfByName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Systemuser”.FullName where(SystemUserId = field(ModifiedOnBehalfBy)))
50	OwningTeam	Guid	Owning Team caption	TableRelation Table 5359 “CRM Team” (“CRM Team”.TeamId)
51	TransactionCurrencyId	Guid	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
52	TransactionCurrencyIdName Δ BC24	Text[100]	—	FlowField: lookup(“CRM Transactioncurrency”.CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)))
53	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
54	ServiceStage	Option	Service Stage caption	OptionCaption: ,Identify,Research,Resolve
55	ExistingCase	Guid	Existing Case caption	TableRelation Table 5349 “CRM Incident” (“CRM Incident”.IncidentId)
56	StageId	Guid	Process Stage caption
57	ProcessId	Guid	Process caption
58	EntityImageId	Guid	Entity Image Id caption
59	CheckEmail	Boolean	Check Email caption
60	ActivitiesComplete	Boolean	Activities Complete caption
61	FollowUpTaskCreated	Boolean	Follow up Task Created caption
62	NumberOfChildIncidents	Integer	Child Cases caption
63	MessageTypeCode	Option	Received As caption	OptionCaption: ,Public Message,Private Message
64	BlockedProfile	Boolean	Blocked Profile caption
65	MasterId	Guid	Master Case caption	TableRelation Table 5349 “CRM Incident” (“CRM Incident”.IncidentId)
66	MasterIdName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Incident”.Title where(IncidentId = field(MasterId)))
67	TraversedPath	Text[250]	Traversed Path caption
68	ParentCaseId	Guid	Parent Case caption	TableRelation Table 5349 “CRM Incident” (“CRM Incident”.IncidentId)
69	DecrementEntitlementTerm	Boolean	Decrement Entitlement Terms caption
70	ParentCaseIdName Δ BC24	Text[200]	—	FlowField: lookup(“CRM Incident”.Title where(IncidentId = field(ParentCaseId)))
71	SentimentValue Δ BC28	Decimal	Sentiment Value caption
72	InfluenceScore Δ BC28	Decimal	Influence Score caption
73	Merged	Boolean	Internal Use Only caption
74	RouteCase	Boolean	Route Case caption
75	ResolveBy	DateTime	Resolve By caption
76	ResponseBy	DateTime	First Response By caption
77	CustomerContacted	Boolean	Customer Contacted caption
78	IsEscalated	Boolean	—
79	EscalatedOn	DateTime	Escalated On caption
80	PrimaryContactId	Guid	Contact caption	TableRelation Table 5342 “CRM Contact” (“CRM Contact”.ContactId)
81	PrimaryContactIdName Δ BC24	Text[160]	—	FlowField: lookup(“CRM Contact”.FullName where(ContactId = field(PrimaryContactId)))
82	FirstResponseSent	Boolean	First Response Sent caption
83	FirstResponseSLAStatus	Option	First Response SLA Status caption	OptionCaption: In Progress,Nearing Noncompliance,Succeeded,Noncompliant
84	ResolveBySLAStatus	Option	Resolve By SLA Status caption	OptionCaption: In Progress,Nearing Noncompliance,Succeeded,Noncompliant
85	OnHoldTime	Integer	On Hold Time (Minutes) caption
86	LastOnHoldTime	DateTime	Last On Hold Time caption

Keys

Key1: IncidentId (clustered)
Key2: Title

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”
AccountIdName: CalcFormula Table 5341 “CRM Account”
AccountId: TableRelation Table 5341 “CRM Account”
CustomerId: TableRelation Table 5341 “CRM Account” (conditional)
ContactIdName: CalcFormula Table 5342 “CRM Contact”
PrimaryContactIdName: CalcFormula Table 5342 “CRM Contact”
ResponsibleContactIdName: CalcFormula Table 5342 “CRM Contact”
ContactId: TableRelation Table 5342 “CRM Contact”
CustomerId: TableRelation Table 5342 “CRM Contact” (conditional)
PrimaryContactId: TableRelation Table 5342 “CRM Contact”
ResponsibleContactId: TableRelation Table 5342 “CRM Contact”
TransactionCurrencyIdName: CalcFormula Table 5345 “CRM Transactioncurrency”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
ProductIdName: CalcFormula Table 5348 “CRM Product”
ProductId: TableRelation Table 5348 “CRM Product”
MasterIdName: CalcFormula Table 5349 “CRM Incident”
ParentCaseIdName: CalcFormula Table 5349 “CRM Incident”
ExistingCase: TableRelation Table 5349 “CRM Incident”
MasterId: TableRelation Table 5349 “CRM Incident”
ParentCaseId: TableRelation Table 5349 “CRM Incident”
ContractIdName: CalcFormula Table 5357 “CRM Contract”
ContractId: TableRelation Table 5357 “CRM Contract”
OwnerId: TableRelation Table 5359 “CRM Team” (conditional)
OwningTeam: TableRelation Table 5359 “CRM Team”
OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”

Referenced by

10 fields in 5 objects relate to this table (TableRelation or CalcFormula).

Table 5349 “CRM Incident”: MasterIdName, ParentCaseIdName, ExistingCase, MasterId, ParentCaseId
Table 5350 “CRM Incidentresolution”: IncidentIdName, IncidentId
Table 5385 “CRM Annotation”: ObjectId
Table 6400 “FS Work Order”: ServiceRequest
Table 6617 “FS Work Order”: ServiceRequest

Pages and codeunits on this table

Page 5349 “CRM Case List” (source table)

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 Incident"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Across versions

Neighbourhood 13 connected objects and pages