Table 6400 "FS Work Order"

Base Application · Microsoft.Integration.FieldService · BC24-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
TableType	CRM
DataClassification	SystemMetadata
ObsoleteState	Removed
ObsoleteTag	28.0
ObsoleteReason	Field Service is moved to Field Service Integration app.

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	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]	Work Order Number caption
35	ProcessId	GUID	Process Id caption
36	StageId	GUID	Stage Id caption
37	TraversedPath	Text[1250]	Traversed Path caption
38	Address1	Text[250]	Street 1 caption
39	Address2	Text[250]	Street 2 caption
40	Address3	Text[250]	Street 3 caption
41	AddressName	Text[250]	Address Name caption
43	AutoNumbering	Text[100]	Auto-Numbering caption
44	BillingAccount	GUID	Billing Account caption	TableRelation Table 5341 “CRM Account” (“CRM Account”.AccountId)
45	BookingSummary	BLOB	Booking Summary caption
46	ChildIndex	Integer	Child Index caption
47	City	Text[80]	—
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 6420 “FS Customer Asset” (“FS Customer Asset”.CustomerAssetId)
51	DateWindowEnd	Date	Date Window End caption
52	DateWindowStart	Date	Date Window Start caption
53	EstimateSubtotalAmount Δ BC28	Decimal	Estimate Subtotal Amount caption
54	TransactionCurrencyId	GUID	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
56	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
57	EstimateSubtotalAmount_Base Δ BC28	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 Δ BC28	Decimal	—
68	Longitude Δ BC28	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 Δ BC28	GUID	Parent Work Order caption
72	PostalCode	Text[20]	Postal Code caption
73	PreferredResource	GUID	Preferred Resource (Deprecated) caption	TableRelation Table 6410 “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	Service Account caption	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 6408 “FS Work Order Substatus” (“FS Work Order Substatus”.WorkOrderSubstatusId)
85	SubtotalAmount Δ BC28	Decimal	Subtotal Amount caption
86	SubTotalAmount_Base Δ BC28	Decimal	Subtotal Amount (Base) caption
87	SupportContact	GUID	Support Contact caption	TableRelation Table 6410 “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 Δ BC28	Decimal	Total Amount caption
101	TotalAmount_Base Δ BC28	Decimal	Total Amount (Base) caption
102	TotalSalesTax Δ BC28	Decimal	Total Sales Tax caption
103	TotalSalesTax_Base Δ BC28	Decimal	Total Sales Tax (Base) caption
105	WorkLocation	Option	Work Location caption
109	WorkOrderSummary	BLOB	Work Order Summary caption
110	WorkOrderType	GUID	Work Order Type caption	TableRelation Table 6409 “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 Δ BC28	Text[100]	—	FlowField:
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 Δ BC28	Decimal	Cost not-to-exceed caption
143	NotToExceedCostAmount_Base Δ BC28	Decimal	Cost not-to-exceed (Base) caption
144	NotToExceedPriceAmount Δ BC28	Decimal	Price not-to-exceed caption
145	NotToExceedPriceAmount_Base Δ BC28	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 Δ BC28	Decimal	Total Cost caption
150	ProductsServicesCost_Base Δ BC28	Decimal	Total Cost (Base) caption
151	ProductsServicesEstimatedCost Δ BC28	Decimal	Total Estimated Cost caption
152	ProductsServicesEstimatedCost_Base Δ BC28	Decimal	Total Estimated Cost (Base) caption
153	TotalEstimatedAfterTaxPrice Δ BC28	Decimal	Total Estimated After Tax Price caption
154	TotalEstimatedAfterTaxPrice_Base Δ BC28	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 6404 “FS Project Task” (“FS Project Task”.ProjectTaskId)
164	CompanyId	GUID	Company Id caption	TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId)

Keys

PK: WorkOrderId (clustered)
Name: Name

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”
ProjectTask: TableRelation Table 6404 “FS Project Task”
SubStatusName: CalcFormula Table 6408 “FS Work Order Substatus”
SubStatus: TableRelation Table 6408 “FS Work Order Substatus”
WorkOrderTypeName: CalcFormula Table 6409 “FS Work Order Type”
WorkOrderType: TableRelation Table 6409 “FS Work Order Type”
PreferredResourceName: CalcFormula Table 6410 “FS Bookable Resource”
SupportContactName: CalcFormula Table 6410 “FS Bookable Resource”
PreferredResource: TableRelation Table 6410 “FS Bookable Resource”
SupportContact: TableRelation Table 6410 “FS Bookable Resource”
CustomerAssetName: CalcFormula Table 6420 “FS Customer Asset”
CustomerAsset: TableRelation Table 6420 “FS Customer Asset”

Referenced by

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

Table 6402 “FS Work Order Product”: WorkOrderName, WorkOrder
Table 6403 “FS Work Order Incident”: WorkOrderName, WorkOrder
Table 6406 “FS Work Order Service”: WorkOrderName, WorkOrder
Table 6412 “FS Bookable Resource Booking”: WorkOrderName, WorkOrder

Deprecations

object: Removed 28.0 (#if not CLEANSCHEMA28), “Field Service is moved to Field Service Integration app.”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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

Across versionsobsolete removed since 28.0

Neighbourhood 19 connected objects and pages