Table 6617 "FS Work Order"

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	WorkOrderId	GUID	WO Number caption
2	CreatedOn	Datetime	Specifies the date and time when the work order was created. via Page 6616 “FS Work Orders”
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	Specifies the status of the work order. via Page 6616 “FS Work Orders”
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]	Specifies the work order type code. via Page 6616 “FS Work Orders”
35	ProcessId	GUID	Process Id caption
36	StageId	GUID	Stage Id caption
37	TraversedPath	Text[1250]	Traversed Path caption
38	Address1	Text[250]	Specifies the address for the work order. via Page 6616 “FS Work Orders”
39	Address2	Text[250]	Specifies the address for the work order. via Page 6616 “FS Work Orders”
40	Address3	Text[250]	Specifies the address for the work order. via Page 6616 “FS Work Orders”
41	AddressName	Text[250]	Address Name caption
43	AutoNumbering	Text[100]	Auto-Numbering caption
44	BillingAccount	GUID	Specifies the billing account for the work order. via Page 6616 “FS Work Orders”	TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
45	BookingSummary	BLOB	Booking Summary caption
46	ChildIndex	Integer	Child Index caption
47	City	Text[80]	Specifies the address for the work order. via Page 6616 “FS Work Orders”
48	ClosedBy	GUID	Closed By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
49	Country	Text[80]	Country/Region caption
50	CustomerAsset	GUID	Primary Incident Customer Asset caption	TableRelation Table 6613 “FS Customer Asset” (“FS Customer Asset”.CustomerAssetId)
51	DateWindowEnd	Date	Date Window End caption
52	DateWindowStart	Date	Date Window Start caption
53	EstimateSubtotalAmount	Decimal	Estimate Subtotal Amount caption
54	TransactionCurrencyId	GUID	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
56	ExchangeRate	Decimal	Exchange Rate caption
57	EstimateSubtotalAmount_Base	Decimal	Estimate Subtotal Amount (Base) caption
58	FollowUpNote	BLOB	Follow Up Note (Deprecated) caption
59	FollowUpRequired	Boolean	Follow Up Required (Deprecated) caption
61	Instructions	BLOB	—
62	InternalFlags	BLOB	Internal Flags caption
63	IsFollowUp	Boolean	Is FollowUp (Deprecated) caption
65	IsMobile	Boolean	Is Mobile caption
67	Latitude	Decimal	—
68	Longitude	Decimal	—
69	MapControl	Text[100]	This field should only be used to load the custom map control caption
70	OpportunityId	GUID	Opportunity caption	TableRelation Table 5343 “CRM Opportunity” (“CRM Opportunity”.OpportunityId)
71	ParentWorkOrder	GUID	Parent Work Order caption	TableRelation Table 6617 “FS Work Order” (“FS Work Order”.WorkOrderId)
72	PostalCode	Text[20]	Specifies the address for the work order. via Page 6616 “FS Work Orders”
73	PreferredResource	GUID	Preferred Resource (Deprecated) caption	TableRelation Table 6610 “FS Bookable Resource” (“FS Bookable Resource”.BookableResourceId)
74	PriceList	GUID	Price List caption	TableRelation Table 5346 “CRM Pricelevel” (“CRM Pricelevel”.PriceLevelId)
75	PrimaryIncidentDescription	BLOB	Primary Incident Description caption
76	PrimaryIncidentEstimatedDuration	Integer	Primary Incident Estimated Duration caption
79	ReportedByContact	GUID	Reported By Contact caption	TableRelation Table 5342 “CRM Contact” (“CRM Contact”.ContactId)
80	ServiceAccount	GUID	Specifies the service account for the work order. via Page 6616 “FS Work Orders”	TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
81	ServiceRequest	GUID	Case caption	TableRelation Table 5349 “CRM Incident” (“CRM Incident”.IncidentId)
83	StateOrProvince	Text[50]	State Or Province caption
84	SubStatus	GUID	Substatus caption	TableRelation Table 6621 “FS Work Order Substatus” (“FS Work Order Substatus”.WorkOrderSubstatusId)
85	SubtotalAmount	Decimal	Subtotal Amount caption
86	SubTotalAmount_Base	Decimal	Subtotal Amount (Base) caption
87	SupportContact	GUID	Support Contact caption	TableRelation Table 6610 “FS Bookable Resource” (“FS Bookable Resource”.BookableResourceId)
88	SystemStatus	Option	System Status caption
90	Taxable	Boolean	—
93	TimeClosed	Datetime	Closed On caption
94	TimeFromPromised	Datetime	Time From Promised caption
97	TimeToPromised	Datetime	Time To Promised caption
98	TimeWindowEnd	Datetime	Time Window End caption
99	TimeWindowStart	Datetime	Time Window Start caption
100	TotalAmount	Decimal	Total Amount caption
101	TotalAmount_Base	Decimal	Total Amount (Base) caption
102	TotalSalesTax	Decimal	Total Sales Tax caption
103	TotalSalesTax_Base	Decimal	Total Sales Tax (Base) caption
105	WorkLocation	Option	Work Location caption
109	WorkOrderSummary	BLOB	Work Order Summary caption
110	WorkOrderType	GUID	Specifies the work order type. via Page 6616 “FS Work Orders”	TableRelation Table 6622 “FS Work Order Type” (“FS Work Order Type”.WorkOrderTypeId)
115	PreferredResourceName	Text[100]	—	FlowField: lookup(“FS Bookable Resource”.Name where(BookableResourceId = field(PreferredResource)))
116	SupportContactName	Text[100]	—	FlowField: lookup(“FS Bookable Resource”.Name where(BookableResourceId = field(SupportContact)))
121	CustomerAssetName	Text[100]	—	FlowField: lookup(“FS Customer Asset”.Name where(CustomerAssetId = field(CustomerAsset)))
128	ParentWorkOrderName	Text[100]	—	FlowField: lookup(“FS Work Order”.Name where(WorkOrderId = field(ParentWorkOrder)))
129	SubStatusName	Text[100]	—	FlowField: lookup(“FS Work Order Substatus”.Name where(WorkOrderSubstatusId = field(SubStatus)))
130	WorkOrderTypeName	Text[100]	—	FlowField: lookup(“FS Work Order Type”.Name where(WorkOrderTypeId = field(WorkOrderType)))
138	completedon	Datetime	Completed On caption
139	CostNTEPercent	Integer	Cost not-to-exceed caption
140	firstarrivedon	Datetime	First Arrived On caption
142	NotToExceedCostAmount	Decimal	Cost not-to-exceed caption
143	NotToExceedCostAmount_Base	Decimal	Cost not-to-exceed (Base) caption
144	NotToExceedPriceAmount	Decimal	Price not-to-exceed caption
145	NotToExceedPriceAmount_Base	Decimal	Price not-to-exceed (Base) caption
146	PhoneNumber	Text[250]	Customer Phone Number caption
147	PriceNTEPercent	Integer	Price not-to-exceed caption
149	ProductsServicesCost	Decimal	Total Cost caption
150	ProductsServicesCost_Base	Decimal	Total Cost (Base) caption
151	ProductsServicesEstimatedCost	Decimal	Total Estimated Cost caption
152	ProductsServicesEstimatedCost_Base	Decimal	Total Estimated Cost (Base) caption
153	TotalEstimatedAfterTaxPrice	Decimal	Total Estimated After Tax Price caption
154	TotalEstimatedAfterTaxPrice_Base	Decimal	Total Estimated After Tax Price (Base) caption
155	TotalEstimatedDuration	Integer	Total Estimated Duration caption
162	DisplayAddress	Text[2048]	Display Address caption
163	ProjectTask	GUID	Business Central Project Task caption	TableRelation Table 6615 “FS Project Task” (“FS Project Task”.ProjectTaskId)
164	CompanyId	GUID	Company Id caption	TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId)
165	IntegrateToService	Boolean	Integrate to Service caption

Keys

PK: WorkOrderId (clustered)
Name: Name

Procedures

2 local procedures, no public ones.

Relations

ClosedBy: TableRelation 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”
OwningUser: TableRelation Table 5340 “CRM Systemuser”
BillingAccount: TableRelation Table 5341 “CRM Account”
ServiceAccount: TableRelation Table 5341 “CRM Account”
ReportedByContact: TableRelation Table 5342 “CRM Contact”
OpportunityId: TableRelation Table 5343 “CRM Opportunity”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
PriceList: TableRelation Table 5346 “CRM Pricelevel”
ServiceRequest: TableRelation Table 5349 “CRM Incident”
OwningTeam: TableRelation Table 5359 “CRM Team”
OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”
CompanyId: TableRelation Table 5393 “CDS Company”
PreferredResourceName: CalcFormula Table 6610 “FS Bookable Resource”
SupportContactName: CalcFormula Table 6610 “FS Bookable Resource”
PreferredResource: TableRelation Table 6610 “FS Bookable Resource”
SupportContact: TableRelation Table 6610 “FS Bookable Resource”
CustomerAssetName: CalcFormula Table 6613 “FS Customer Asset”
CustomerAsset: TableRelation Table 6613 “FS Customer Asset”
ProjectTask: TableRelation Table 6615 “FS Project Task”
ParentWorkOrderName: CalcFormula Table 6617 “FS Work Order”
ParentWorkOrder: TableRelation Table 6617 “FS Work Order”
SubStatusName: CalcFormula Table 6621 “FS Work Order Substatus”
SubStatus: TableRelation Table 6621 “FS Work Order Substatus”
WorkOrderTypeName: CalcFormula Table 6622 “FS Work Order Type”
WorkOrderType: TableRelation Table 6622 “FS Work Order Type”

Referenced by

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

Table 6611 “FS Bookable Resource Booking”: WorkOrderName, WorkOrder
Table 6617 “FS Work Order”: ParentWorkOrderName, ParentWorkOrder
Table 6618 “FS Work Order Incident”: WorkOrderName, WorkOrder
Table 6619 “FS Work Order Product”: WorkOrderName, WorkOrder
Table 6620 “FS Work Order Service”: WorkOrderName, WorkOrder

Pages and codeunits on this table

Page 6616 “FS Work Orders” (source table)

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Codeunit 5342 “CRM Synch. Helper” (2 calls: GetBaseCurrencyCode → GetNavCurrencyCode, GetCurrencyCode → GetNavCurrencyCode)

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. 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"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Across versions

Neighbourhood 21 connected objects and pages