Table 6619 "FS Work Order Product"

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	WorkOrderProductId	GUID	Work Order Product 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	Decimal	Additional Cost caption
36	TransactionCurrencyId	GUID	Currency caption	TableRelation Table 5345 “CRM Transactioncurrency” (“CRM Transactioncurrency”.TransactionCurrencyId)
38	ExchangeRate	Decimal	Exchange Rate caption
39	additionalcost_Base	Decimal	Additional Cost (Base) caption
40	WarehouseId	GUID	Warehouse caption	TableRelation Table 6624 “FS Warehouse” (“FS Warehouse”.WarehouseId)
41	Allocated	Boolean	—
43	Booking	GUID	—	TableRelation Table 6611 “FS Bookable Resource Booking” (“FS Bookable Resource Booking”.BookableResourceBookingId)
44	CommissionCosts	Decimal	Commission Costs caption
45	commissioncosts_Base	Decimal	Commission Costs (Base) caption
46	CustomerAsset	GUID	Customer Asset caption	TableRelation Table 6613 “FS Customer Asset” (“FS Customer Asset”.CustomerAssetId)
47	Description	BLOB	—
48	DisableEntitlement	Boolean	Disable Entitlement caption
50	DiscountAmount	Decimal	Discount Amount caption
51	DiscountAmount_Base	Decimal	Discount Amount (Base) caption
52	DiscountPercent	Decimal	Discount % caption
54	EstimateDiscountAmount	Decimal	Estimate Discount Amount caption
55	EstimateDiscountAmount_Base	Decimal	Estimate Discount Amount (Base) caption
56	EstimateDiscountPercent	Decimal	Estimate Discount % caption
57	EstimateQuantity	Decimal	Estimate Quantity caption
58	EstimateSubtotal	Decimal	Estimate Subtotal caption
59	EstimateSubtotal_Base	Decimal	Estimate Subtotal (Base) caption
60	EstimateTotalAmount	Decimal	Estimate Total Amount caption
61	EstimateTotalAmount_Base	Decimal	Estimate Total Amount (Base) caption
62	EstimateTotalCost	Decimal	Estimate Total Cost caption
63	EtimateTotalCost_Base	Decimal	Estimate Total Cost (Base) caption
64	EstimateUnitAmount	Decimal	Estimate Unit Amount caption
65	EstimateUnitAmount_Base	Decimal	Estimate Unit Amount (Base) caption
66	EstimateUnitCost	Decimal	Estimate Unit Cost caption
67	EstimateUnitCost_Base	Decimal	Estimate Unit Cost (Base) caption
68	InternalDescription	BLOB	Internal Description caption
69	InternalFlags	BLOB	Internal Flags caption
70	LineOrder	Integer	Line Order caption
71	LineStatus	Option	Line Status caption
73	PriceList	GUID	Price List caption	TableRelation Table 5346 “CRM Pricelevel” (“CRM Pricelevel”.PriceLevelId)
74	Product	GUID	—	TableRelation Table 5348 “CRM Product” (“CRM Product”.ProductId)
76	QtyToBill	Decimal	Quantity To Bill caption
77	Quantity	Decimal	—
78	Subtotal	Decimal	—
79	Subtotal_Base	Decimal	Subtotal (Base) caption
80	Taxable	Boolean	—
82	TotalAmount	Decimal	Total Amount caption
83	TotalAmount_Base	Decimal	Total Amount (Base) caption
84	TotalCost	Decimal	Total Cost caption
85	TotalCost_Base	Decimal	Total Cost (Base) caption
86	Unit	GUID	—	TableRelation Table 5361 “CRM Uom” (“CRM Uom”.UoMId)
87	UnitAmount	Decimal	Unit Amount caption
88	UnitAmount_Base	Decimal	Unit Amount (Base) caption
89	UnitCost	Decimal	Unit Cost caption
90	UnitCost_Base	Decimal	Unit Cost (Base) caption
92	WorkOrder	GUID	Work Order caption	TableRelation Table 6617 “FS Work Order” (“FS Work Order”.WorkOrderId)
93	WorkOrderIncident	GUID	Work Order Incident caption	TableRelation Table 6618 “FS Work Order Incident” (“FS Work Order Incident”.WorkOrderIncidentId)
94	BookingName	Text[100]	—	FlowField: lookup(“FS Bookable Resource Booking”.Name where(BookableResourceBookingId = field(Booking)))
97	CustomerAssetName	Text[100]	—	FlowField: lookup(“FS Customer Asset”.Name where(CustomerAssetId = field(CustomerAsset)))
100	WorkOrderName	Text[100]	—	FlowField: lookup(“FS Work Order”.Name where(WorkOrderId = field(WorkOrder)))
101	WorkOrderIncidentName	Text[100]	—	FlowField: lookup(“FS Work Order Incident”.Name where(WorkOrderIncidentId = field(WorkOrderIncident)))
105	ProjectTask	GUID	External Project caption	TableRelation Table 6615 “FS Project Task” (“FS Project Task”.ProjectTaskId)
106	WorkOrderStatus	Option	Work Order Status caption
108	CompanyId	GUID	Company Id caption	TableRelation Table 5393 “CDS Company” (“CDS Company”.CompanyId)
111	QuantityConsumed	Decimal	Quantity Consumed caption
112	QuantityInvoiced	Decimal	Quantity Invoiced caption
113	QuantityShipped	Decimal	Quantity Shipped caption
120	IntegrateToService	Boolean	Integrate to Service caption
121	LocationCode	Code[10]	Location Code caption
122	ProductId	Code[20]	Product Id caption

Keys

PK: workorderproductId (clustered)
Name: Name

Procedures

2 local procedures, no public ones.

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”
Product: 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”
BookingName: CalcFormula Table 6611 “FS Bookable Resource Booking”
Booking: TableRelation Table 6611 “FS Bookable Resource Booking”
CustomerAssetName: CalcFormula Table 6613 “FS Customer Asset”
CustomerAsset: TableRelation Table 6613 “FS Customer Asset”
ProjectTask: TableRelation Table 6615 “FS Project Task”
WorkOrderName: CalcFormula Table 6617 “FS Work Order”
WorkOrder: TableRelation Table 6617 “FS Work Order”
WorkOrderIncidentName: CalcFormula Table 6618 “FS Work Order Incident”
WorkOrderIncident: TableRelation Table 6618 “FS Work Order Incident”
WarehouseId: TableRelation Table 6624 “FS Warehouse”

Referenced by

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

Table 6613 “FS Customer Asset”: WorkOrderProductName, WorkOrderProduct

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