Table 6406 "FS Work Order Service"

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	WorkOrderServiceId	GUID	Work Order Service 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[200]	—
35	AdditionalCost Δ BC28	Decimal	Additional Cost caption
36	TransactionCurrencyId	GUID	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
38	ExchangeRate Δ BC28	Decimal	Exchange Rate caption
39	AdditionalCost_Base Δ BC28	Decimal	Additional Cost (Base) caption
41	Booking	GUID	—	TableRelation Table 6412 “FS Bookable Resource Booking” (“FS Bookable Resource Booking”.BookableResourceBookingId)
42	CalculatedUnitAmount Δ BC28	Decimal	Calculated Unit Amount caption
43	CalculatedUnitAmount_Base Δ BC28	Decimal	Calculated Unit Amount (Base) caption
44	CommissionCosts Δ BC28	Decimal	Commission Costs caption
45	CommissionCosts_Base Δ BC28	Decimal	Commission Costs (Base) caption
46	CustomerAsset	GUID	Customer Asset caption	TableRelation Table 6420 “FS Customer Asset” (“FS Customer Asset”.CustomerAssetId)
47	Description	BLOB	—
48	DisableEntitlement	Boolean	Disable Entitlement caption
50	DiscountAmount Δ BC28	Decimal	Discount Amount caption
51	DiscountAmount_Base Δ BC28	Decimal	Discount Amount (Base) caption
52	DiscountPercent Δ BC28	Decimal	Discount % caption
53	Duration	Integer	—
54	DurationToBill	Integer	Duration To Bill caption
56	EstimateCalculatedUnitAmount Δ BC28	Decimal	Estimate Calculated Unit Amount caption
57	EstimateCalculatedUnitAmount_Base Δ BC28	Decimal	Estimate Calculated Unit Amount (Base) caption
58	EstimateDiscountAmount Δ BC28	Decimal	Estimate Discount Amount caption
59	EstimateDiscountAmount_Base Δ BC28	Decimal	Estimate Discount Amount (Base) caption
60	EstimateDiscountPercent Δ BC28	Decimal	Estimate Discount % caption
61	EstimateDuration	Integer	Estimate Duration caption
62	EstimateSubtotal Δ BC28	Decimal	Estimate Subtotal caption
63	EstimateSubtotal_Base Δ BC28	Decimal	Estimate Subtotal (Base) caption
64	EstimateTotalAmount Δ BC28	Decimal	Estimate Total Amount caption
65	EstimateTotalAmount_Base Δ BC28	Decimal	Estimate Total Amount (Base) caption
66	EstimateTotalCost Δ BC28	Decimal	Estimate Total Cost caption
67	EstimateTotalCost_Base Δ BC28	Decimal	Estimate Total Cost (Base) caption
68	EstimateUnitAmount Δ BC28	Decimal	Estimate Unit Amount caption
69	EtimateUnitAmount_Base Δ BC28	Decimal	Estimate Unit Amount (Base) caption
70	EstimateUnitCost Δ BC28	Decimal	Estimate Unit Cost caption
71	EstimateUnitCost_Base Δ BC28	Decimal	Estimate Unit Cost (Base) caption
72	InternalDescription	BLOB	Internal Description caption
73	InternalFlags	BLOB	Internal Flags caption
74	LineOrder	Integer	Line Order caption
75	LineStatus	Option	Line Status caption
77	MinimumChargeAmount Δ BC28	Decimal	Minimum Charge Amount caption
78	MinimumChargeAmount_Base Δ BC28	Decimal	Minimum Charge Amount (Base) caption
79	MinimumChargeDuration	Integer	Minimum Charge Duration caption
80	PriceList	GUID	Price List caption	TableRelation Table 5346 “CRM Pricelevel” (“CRM Pricelevel”.PriceLevelId)
81	Service	GUID	—	TableRelation Table 5348 “CRM Product” (“CRM Product”.ProductId)
82	Subtotal Δ BC28	Decimal	—
83	Subtotal_Base Δ BC28	Decimal	Subtotal (Base) caption
84	Taxable	Boolean	—
86	TotalAmount Δ BC28	Decimal	Total Amount caption
87	TotalAmount_Base Δ BC28	Decimal	Total Amount (Base) caption
88	TotalCost Δ BC28	Decimal	Total Cost caption
89	TotalCost_Base Δ BC28	Decimal	Total Cost (Base) caption
90	Unit	GUID	—	TableRelation Table 5361 “CRM Uom” (“CRM Uom”.UoMId)
91	UnitAmount Δ BC28	Decimal	Unit Amount caption
92	UnitAmount_Base Δ BC28	Decimal	Unit Amount (Base) caption
93	UnitCost Δ BC28	Decimal	Unit Cost caption
94	UnitCost_Base Δ BC28	Decimal	Unit Cost (Base) caption
95	WorkOrder	GUID	Work Order caption	TableRelation Table 6400 “FS Work Order” (“FS Work Order”.WorkOrderId)
96	WorkOrderIncident	GUID	Work Order Incident caption	TableRelation Table 6403 “FS Work Order Incident” (“FS Work Order Incident”.WorkOrderIncidentId)
97	BookingName	Text[100]	—	FlowField: lookup(“FS Bookable Resource Booking”.Name where(BookableResourceBookingId = field(Booking)))
100	CustomerAssetName	Text[100]	—	FlowField: lookup(“FS Customer Asset”.Name where(CustomerAssetId = field(CustomerAsset)))
101	WorkOrderName	Text[100]	—	FlowField: lookup(“FS Work Order”.Name where(WorkOrderId = field(WorkOrder)))
102	WorkOrderIncidentName	Text[100]	—	FlowField: lookup(“FS Work Order Incident”.Name where(WorkOrderIncidentId = field(WorkOrderIncident)))
106	CompanyId	GUID	Company Id caption	TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId)
107	ProjectTask	GUID	External Project caption	TableRelation Table 6404 “FS Project Task” (“FS Project Task”.ProjectTaskId)
108	WorkOrderStatus	Option	Work Order Status caption
112	DurationConsumed	Integer	Duration Consumed caption
113	DurationInvoiced	Integer	Duration Invoiced caption

Keys

PK: workorderserviceId (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”
TransactionCurrencyId: TableRelation Table 5345 “CRM Transactioncurrency”
PriceList: TableRelation Table 5346 “CRM Pricelevel”
Service: TableRelation Table 5348 “CRM Product”
OwningTeam: TableRelation Table 5359 “CRM Team”
Unit: TableRelation Table 5361 “CRM Uom”
OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”
CompanyId: TableRelation Table 5393 “CDS Company”
WorkOrderName: CalcFormula Table 6400 “FS Work Order”
WorkOrder: TableRelation Table 6400 “FS Work Order”
WorkOrderIncidentName: CalcFormula Table 6403 “FS Work Order Incident”
WorkOrderIncident: TableRelation Table 6403 “FS Work Order Incident”
ProjectTask: TableRelation Table 6404 “FS Project Task”
BookingName: CalcFormula Table 6412 “FS Bookable Resource Booking”
Booking: TableRelation Table 6412 “FS Bookable Resource Booking”
CustomerAssetName: CalcFormula Table 6420 “FS Customer Asset”
CustomerAsset: TableRelation Table 6420 “FS Customer Asset”

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