Table 6618 "FS Work Order Incident"

FieldServiceIntegration · Microsoft.Integration.DynamicsFieldService · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
TableType	CRM
DataClassification	SystemMetadata

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	WorkOrderIncidentId	GUID	Work Order Incident caption
2	CreatedOn	Datetime	Created On caption
3	CreatedBy	GUID	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
4	ModifiedOn	Datetime	Modified On caption
5	ModifiedBy	GUID	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
6	CreatedOnBehalfBy	GUID	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
7	ModifiedOnBehalfBy	GUID	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
16	OwnerId	GUID	Owner caption
21	OwningBusinessUnit	GUID	Owning Business Unit caption	TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId)
22	OwningUser	GUID	Owning User caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
23	OwningTeam	GUID	Owning Team caption	TableRelation Table 5359 “CRM Team” (“CRM Team”.TeamId)
25	StateCode	Option	Status caption
27	StatusCode	Option	Status Reason caption
29	VersionNumber	BigInteger	Version Number caption
30	ImportSequenceNumber	Integer	Import Sequence Number caption
31	OverriddenCreatedOn	Date	Record Created On caption
32	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
33	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
34	Name	Text[100]	—
36	CustomerAsset	GUID	Customer Asset caption	TableRelation Table 6613 “FS Customer Asset” (“FS Customer Asset”.CustomerAssetId)
37	Description	BLOB	—
38	EstimatedDuration	Integer	Estimated Duration caption
39	IncidentResolved	Boolean	Incident Resolved caption
42	InternalFlags	BLOB	Internal Flags caption
43	IsMobile	Boolean	Is Mobile caption
45	IsPrimary	Boolean	Is Primary caption
47	ItemsPopulated	Boolean	Items Populated caption
50	TasksPercentCompleted	Decimal	Tasks % Completed caption
51	WorkOrder	GUID	Work Order caption	TableRelation Table 6617 “FS Work Order” (“FS Work Order”.WorkOrderId)
53	CustomerAssetName	Text[100]	—	FlowField: lookup(“FS Customer Asset”.Name where(CustomerAssetId = field(CustomerAsset)))
56	WorkOrderName	Text[100]	—	FlowField: lookup(“FS Work Order”.Name where(WorkOrderId = field(WorkOrder)))
60	IncidentType	Guid	Incident Type caption	TableRelation Table 6625 “FS Incident Type” (“FS Incident Type”.IncidentTypeId)
70	CompanyId	GUID	Company Id caption	TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId)

Keys

PK: WorkOrderIncidentId (clustered)
Name: Name

Relations

CreatedBy: TableRelation Table 5340 “CRM Systemuser”
CreatedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
OwningUser: TableRelation Table 5340 “CRM Systemuser”
OwningTeam: TableRelation Table 5359 “CRM Team”
OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”
CompanyId: TableRelation Table 5393 “CDS Company”
CustomerAssetName: CalcFormula Table 6613 “FS Customer Asset”
CustomerAsset: TableRelation Table 6613 “FS Customer Asset”
WorkOrderName: CalcFormula Table 6617 “FS Work Order”
WorkOrder: TableRelation Table 6617 “FS Work Order”
IncidentType: TableRelation Table 6625 “FS Incident Type”

Referenced by

4 fields in 2 objects relate to this table (TableRelation or CalcFormula).

Table 6619 “FS Work Order Product”: WorkOrderIncidentName, WorkOrderIncident
Table 6620 “FS Work Order Service”: WorkOrderIncidentName, WorkOrderIncident

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