Product table/entity reference (Microsoft Dynamics 365 Field Service)

Article
2025-02-08

Information about products and their pricing information.

Note

The Microsoft Dynamics 365 Field Service Product table extends the Microsoft Dynamics 365 Product table.

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

msdyn_ConvertToCustomerAsset
msdyn_DefaultVendor
msdyn_FieldServiceProductType
msdyn_PurchaseName
msdyn_Taxable
msdyn_UPCCode

msdyn_ConvertToCustomerAsset

Property	Value
Description	Specify whether a product is to be converted to a customer asset. When a product is used on a work order, the system will automatically convert it into a customer asset when the work order is closed.
DisplayName	Convert to Customer Asset
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_converttocustomerasset`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`msdyn_product_msdyn_converttocustomerasset`
DefaultValue	False
True Label	Yes
False Label	No

msdyn_DefaultVendor

Property	Value
Description	Default vendor that supplies this product
DisplayName	Default Vendor
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_defaultvendor`
RequiredLevel	None
Type	Lookup
Targets	account

msdyn_FieldServiceProductType

Property	Value
Description
DisplayName	Field Service Product Type
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_fieldserviceproducttype`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`msdyn_fieldserviceproducttype`

msdyn_FieldServiceProductType Choices/Options

Value	Label
690970000	Inventory
690970001	Non-Inventory
690970002	Service

msdyn_PurchaseName

Property	Value
Description	Type the name for the product when used on a purchase order.
DisplayName	Purchase Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_purchasename`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

msdyn_Taxable

Property	Value
Description	Select whether the item is taxable. If an item is set as not taxable, it won't be taxable even on a taxable work order.
DisplayName	Taxable
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_taxable`
RequiredLevel	ApplicationRequired
Type	Boolean
GlobalChoiceName	`msdyn_product_msdyn_taxable`
DefaultValue	True
True Label	Yes
False Label	No

msdyn_UPCCode

Property	Value
Description	Shows the UPC Code for product. Used for bar code scanning.
DisplayName	UPC Code
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_upccode`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

msdyn_account_product_DefaultVendor

One-To-Many Relationship: account msdyn_account_product_DefaultVendor

Property	Value
ReferencedEntity	`account`
ReferencedAttribute	`accountid`
ReferencingAttribute	`msdyn_defaultvendor`
ReferencingEntityNavigationPropertyName	`msdyn_defaultvendor`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `Cascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

msdyn_product_msdyn_actual_Product
msdyn_product_msdyn_agreementbookingproduct_Product
msdyn_product_msdyn_agreementbookingservice_Service
msdyn_product_msdyn_agreementinvoiceproduct_Product
msdyn_product_msdyn_fieldservicesetting
msdyn_product_msdyn_incidenttypeproduct_Product
msdyn_product_msdyn_incidenttypeservice_Service
msdyn_product_msdyn_inventoryadjustmentproduct_Product
msdyn_product_msdyn_inventoryjournal_Product
msdyn_product_msdyn_productinventory_Product
msdyn_product_msdyn_purchaseorderproduct_Product
msdyn_product_msdyn_rmaproduct_Product
msdyn_product_msdyn_rtvproduct_Product
msdyn_product_msdyn_workorderproduct_Product
msdyn_product_msdyn_workorderservice_Service

msdyn_product_msdyn_actual_Product

Many-To-One Relationship: msdyn_actual msdyn_product_msdyn_actual_Product

Property	Value
ReferencingEntity	`msdyn_actual`
ReferencingAttribute	`msdyn_product`
ReferencedEntityNavigationPropertyName	`msdyn_product_msdyn_actual_Product`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_product_msdyn_agreementbookingproduct_Product

Many-To-One Relationship: msdyn_agreementbookingproduct msdyn_product_msdyn_agreementbookingproduct_Product

Property	Value
ReferencingEntity	`msdyn_agreementbookingproduct`
ReferencingAttribute	`msdyn_product`
ReferencedEntityNavigationPropertyName	`msdyn_product_msdyn_agreementbookingproduct_Product`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseLabel` Group: `Details` Label: Product MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_product_msdyn_agreementbookingservice_Service

Many-To-One Relationship: msdyn_agreementbookingservice msdyn_product_msdyn_agreementbookingservice_Service

Property	Value
ReferencingEntity	`msdyn_agreementbookingservice`
ReferencingAttribute	`msdyn_service`
ReferencedEntityNavigationPropertyName	`msdyn_product_msdyn_agreementbookingservice_Service`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseLabel` Group: `Details` Label: Service MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_product_msdyn_agreementinvoiceproduct_Product

Many-To-One Relationship: msdyn_agreementinvoiceproduct msdyn_product_msdyn_agreementinvoiceproduct_Product

Property	Value
ReferencingEntity	`msdyn_agreementinvoiceproduct`
ReferencingAttribute	`msdyn_product`
ReferencedEntityNavigationPropertyName	`msdyn_product_msdyn_agreementinvoiceproduct_Product`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseLabel` Group: `Details` Label: Product MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_product_msdyn_fieldservicesetting

Many-To-One Relationship: msdyn_fieldservicesetting msdyn_product_msdyn_fieldservicesetting

Property	Value
ReferencingEntity	`msdyn_fieldservicesetting`
ReferencingAttribute	`msdyn_travelchargeitemid`
ReferencedEntityNavigationPropertyName	`msdyn_product_msdyn_fieldservicesetting`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseLabel` Group: `Details` Label: Travel Charge Item MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_product_msdyn_incidenttypeproduct_Product

Many-To-One Relationship: msdyn_incidenttypeproduct msdyn_product_msdyn_incidenttypeproduct_Product

Property	Value
ReferencingEntity	`msdyn_incidenttypeproduct`
ReferencingAttribute	`msdyn_product`
ReferencedEntityNavigationPropertyName	`msdyn_product_msdyn_incidenttypeproduct_Product`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_product_msdyn_incidenttypeservice_Service

Many-To-One Relationship: msdyn_incidenttypeservice msdyn_product_msdyn_incidenttypeservice_Service

Property	Value
ReferencingEntity	`msdyn_incidenttypeservice`
ReferencingAttribute	`msdyn_service`
ReferencedEntityNavigationPropertyName	`msdyn_product_msdyn_incidenttypeservice_Service`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_product_msdyn_inventoryadjustmentproduct_Product

Many-To-One Relationship: msdyn_inventoryadjustmentproduct msdyn_product_msdyn_inventoryadjustmentproduct_Product

Property	Value
ReferencingEntity	`msdyn_inventoryadjustmentproduct`
ReferencingAttribute	`msdyn_product`
ReferencedEntityNavigationPropertyName	`msdyn_product_msdyn_inventoryadjustmentproduct_Product`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_product_msdyn_inventoryjournal_Product

Many-To-One Relationship: msdyn_inventoryjournal msdyn_product_msdyn_inventoryjournal_Product

Property	Value
ReferencingEntity	`msdyn_inventoryjournal`
ReferencingAttribute	`msdyn_product`
ReferencedEntityNavigationPropertyName	`msdyn_product_msdyn_inventoryjournal_Product`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_product_msdyn_productinventory_Product

Many-To-One Relationship: msdyn_productinventory msdyn_product_msdyn_productinventory_Product

Property	Value
ReferencingEntity	`msdyn_productinventory`
ReferencingAttribute	`msdyn_product`
ReferencedEntityNavigationPropertyName	`msdyn_product_msdyn_productinventory_Product`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_product_msdyn_purchaseorderproduct_Product

Many-To-One Relationship: msdyn_purchaseorderproduct msdyn_product_msdyn_purchaseorderproduct_Product

Property	Value
ReferencingEntity	`msdyn_purchaseorderproduct`
ReferencingAttribute	`msdyn_product`
ReferencedEntityNavigationPropertyName	`msdyn_product_msdyn_purchaseorderproduct_Product`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseLabel` Group: `Details` Label: Product MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_product_msdyn_rmaproduct_Product

Many-To-One Relationship: msdyn_rmaproduct msdyn_product_msdyn_rmaproduct_Product

Property	Value
ReferencingEntity	`msdyn_rmaproduct`
ReferencingAttribute	`msdyn_product`
ReferencedEntityNavigationPropertyName	`msdyn_product_msdyn_rmaproduct_Product`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_product_msdyn_rtvproduct_Product

Many-To-One Relationship: msdyn_rtvproduct msdyn_product_msdyn_rtvproduct_Product

Property	Value
ReferencingEntity	`msdyn_rtvproduct`
ReferencingAttribute	`msdyn_product`
ReferencedEntityNavigationPropertyName	`msdyn_product_msdyn_rtvproduct_Product`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_product_msdyn_workorderproduct_Product

Many-To-One Relationship: msdyn_workorderproduct msdyn_product_msdyn_workorderproduct_Product

Property	Value
ReferencingEntity	`msdyn_workorderproduct`
ReferencingAttribute	`msdyn_product`
ReferencedEntityNavigationPropertyName	`msdyn_product_msdyn_workorderproduct_Product`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_product_msdyn_workorderservice_Service

Many-To-One Relationship: msdyn_workorderservice msdyn_product_msdyn_workorderservice_Service

Property	Value
ReferencingEntity	`msdyn_workorderservice`
ReferencingAttribute	`msdyn_service`
ReferencedEntityNavigationPropertyName	`msdyn_product_msdyn_workorderservice_Service`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Share via