Table 6400 FS Work Order in 27

Jonas Paprotka, Base Application 27.5.46862.47359, checked 2026-09-20

App: Base Application
Namespace: Microsoft.Integration.FieldService
Obsolete: Pending 25.0. Field Service is moved to Field Service Integration app.

Versions1718192021222324 25 262728 latest

Source29

Fields, 103

Id	Name	Type	Obsolete
1	WorkOrderId	Guid	-
2	CreatedOn	DateTime	-
3	CreatedBy	Guid	-
4	ModifiedOn	DateTime	-
5	ModifiedBy	Guid	-
6	CreatedOnBehalfBy	Guid	-
7	ModifiedOnBehalfBy	Guid	-
16	OwnerId	Guid	-
21	OwningBusinessUnit	Guid	-
22	OwningUser	Guid	-
23	OwningTeam	Guid	-
25	StateCode	Option	-
27	StatusCode	Option	-
29	VersionNumber	BigInteger	-
30	ImportSequenceNumber	Integer	-
31	OverriddenCreatedOn	Date	-
32	TimeZoneRuleVersionNumber	Integer	-
33	UTCConversionTimeZoneCode	Integer	-
34	Name	Text[100]	-
35	ProcessId	Guid	-
36	StageId	Guid	-
37	TraversedPath	Text[1250]	-
38	Address1	Text[250]	-
39	Address2	Text[250]	-
40	Address3	Text[250]	-
41	AddressName	Text[250]	-
43	AutoNumbering	Text[100]	-
44	BillingAccount	Guid	-
45	BookingSummary	Blob	-
46	ChildIndex	Integer	-
47	City	Text[80]	-
48	ClosedBy	Guid	-
49	Country	Text[80]	-
50	CustomerAsset	Guid	-
51	DateWindowEnd	Date	-
52	DateWindowStart	Date	-
53	EstimateSubtotalAmount	Decimal	-
54	TransactionCurrencyId	Guid	-
56	ExchangeRate	Decimal	-
57	EstimateSubtotalAmount_Base	Decimal	-
58	FollowUpNote	Blob	-
59	FollowUpRequired	Boolean	-
61	Instructions	Blob	-
62	InternalFlags	Blob	-
63	IsFollowUp	Boolean	-
65	IsMobile	Boolean	-
67	Latitude	Decimal	-
68	Longitude	Decimal	-
69	MapControl	Text[100]	-
70	OpportunityId	Guid	-
71	ParentWorkOrder	Guid	-
72	PostalCode	Text[20]	-
73	PreferredResource	Guid	-
74	PriceList	Guid	-
75	PrimaryIncidentDescription	Blob	-
76	PrimaryIncidentEstimatedDuration	Integer	-
79	ReportedByContact	Guid	-
80	ServiceAccount	Guid	-
81	ServiceRequest	Guid	-
83	StateOrProvince	Text[50]	-
84	SubStatus	Guid	-
85	SubtotalAmount	Decimal	-
86	SubTotalAmount_Base	Decimal	-
87	SupportContact	Guid	-
88	SystemStatus	Option	-
90	Taxable	Boolean	-
93	TimeClosed	DateTime	-
94	TimeFromPromised	DateTime	-
97	TimeToPromised	DateTime	-
98	TimeWindowEnd	DateTime	-
99	TimeWindowStart	DateTime	-
100	TotalAmount	Decimal	-
101	TotalAmount_Base	Decimal	-
102	TotalSalesTax	Decimal	-
103	TotalSalesTax_Base	Decimal	-
105	WorkLocation	Option	-
109	WorkOrderSummary	Blob	-
110	WorkOrderType	Guid	-
115	PreferredResourceName	Text[100]	-
116	SupportContactName	Text[100]	-
121	CustomerAssetName	Text[100]	-
128	ParentWorkOrderName	Text[100]	-
129	SubStatusName	Text[100]	-
130	WorkOrderTypeName	Text[100]	-
138	completedon	DateTime	-
139	CostNTEPercent	Integer	-
140	firstarrivedon	DateTime	-
142	NotToExceedCostAmount	Decimal	-
143	NotToExceedCostAmount_Base	Decimal	-
144	NotToExceedPriceAmount	Decimal	-
145	NotToExceedPriceAmount_Base	Decimal	-
146	PhoneNumber	Text[250]	-
147	PriceNTEPercent	Integer	-
149	ProductsServicesCost	Decimal	-
150	ProductsServicesCost_Base	Decimal	-
151	ProductsServicesEstimatedCost	Decimal	-
152	ProductsServicesEstimatedCost_Base	Decimal	-
153	TotalEstimatedAfterTaxPrice	Decimal	-
154	TotalEstimatedAfterTaxPrice_Base	Decimal	-
155	TotalEstimatedDuration	Integer	-
162	DisplayAddress	Text[2048]	-
163	ProjectTask	Guid	-
164	CompanyId	Guid	-

Keys, 2

Name	Fields	Obsolete
PK, clustered	WorkOrderId	-
Name	Name	-