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

2025-08-29

In this entity you record all the products proposed and used for a work order

Messages

The following table lists the messages for the Work Order Product (msdyn_workorderproduct) table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
`Assign` Event: True	`PATCH` /msdyn_workorderproducts(msdyn_workorderproductid) Update the `ownerid` property.	AssignRequest
`Associate` Event: True	Associate records	Associate records
`BulkRetain` Event: True	BulkRetain	Learn to use messages with the SDK for .NET
`Create` Event: True	`POST` /msdyn_workorderproducts See Create	Create records
`CreateMultiple` Event: True	CreateMultiple	CreateMultipleRequest
`Delete` Event: True	`DELETE` /msdyn_workorderproducts(msdyn_workorderproductid) See Delete	Delete records
`Disassociate` Event: True	Disassociate records	Disassociate records
`GrantAccess` Event: True	GrantAccess	GrantAccessRequest
`IsValidStateTransition` Event: False	IsValidStateTransition	IsValidStateTransitionRequest
`ModifyAccess` Event: True	ModifyAccess	ModifyAccessRequest
`PurgeRetainedContent` Event: True	PurgeRetainedContent	Learn to use messages with the SDK for .NET
`Restore` Event: True	Restore	Learn to use messages with the SDK for .NET
`Retain` Event: True	Retain	Learn to use messages with the SDK for .NET
`Retrieve` Event: True	`GET` /msdyn_workorderproducts(msdyn_workorderproductid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: True	`GET` /msdyn_workorderproducts See Query data	Query data
`RetrievePrincipalAccess` Event: True	RetrievePrincipalAccess	RetrievePrincipalAccessRequest
`RetrieveSharedPrincipalsAndAccess` Event: True	RetrieveSharedPrincipalsAndAccess	RetrieveSharedPrincipalsAndAccessRequest
`RevokeAccess` Event: True	RevokeAccess	RevokeAccessRequest
`RollbackRetain` Event: True	RollbackRetain	Learn to use messages with the SDK for .NET
`SetState` Event: True	`PATCH` /msdyn_workorderproducts(msdyn_workorderproductid) Update the `statecode` and `statuscode` properties.	SetStateRequest
`Update` Event: True	`PATCH` /msdyn_workorderproducts(msdyn_workorderproductid) See Update	Update records
`UpdateMultiple` Event: True	UpdateMultiple	UpdateMultipleRequest
`Upsert` Event: False	`PATCH` /msdyn_workorderproducts(msdyn_workorderproductid) See Upsert a table row	UpsertRequest
`UpsertMultiple` Event: False	UpsertMultiple	UpsertMultipleRequest
`ValidateRetentionConfig` Event: True	ValidateRetentionConfig	Learn to use messages with the SDK for .NET

Properties

The following table lists selected properties for the Work Order Product (msdyn_workorderproduct) table.

Property	Value
DisplayName	Work Order Product
DisplayCollectionName	Work Order Products
SchemaName	`msdyn_workorderproduct`
CollectionSchemaName	`msdyn_workorderproducts`
EntitySetName	`msdyn_workorderproducts`
LogicalName	`msdyn_workorderproduct`
LogicalCollectionName	`msdyn_workorderproducts`
PrimaryIdAttribute	`msdyn_workorderproductid`
PrimaryNameAttribute	`msdyn_name`
TableType	`Standard`
OwnershipType	`UserOwned`

Writable columns/attributes

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

ImportSequenceNumber
msdyn_AdditionalCost
msdyn_AgreementBookingProduct
msdyn_Allocated
msdyn_Booking
msdyn_CommissionCosts
msdyn_CustomerAsset
msdyn_Description
msdyn_DisableEntitlement
msdyn_DiscountAmount
msdyn_DiscountPercent
msdyn_Entitlement
msdyn_EstimateDiscountAmount
msdyn_EstimateDiscountPercent
msdyn_EstimateQuantity
msdyn_EstimateSubtotal
msdyn_EstimateTotalAmount
msdyn_EstimateTotalCost
msdyn_EstimateUnitAmount
msdyn_EstimateUnitCost
msdyn_InternalDescription
msdyn_InternalFlags
msdyn_LineOrder
msdyn_LineStatus
msdyn_name
msdyn_PriceList
msdyn_Product
msdyn_PurchaseOrderReceiptProduct
msdyn_QtyToBill
msdyn_Quantity
msdyn_Subtotal
msdyn_Taxable
msdyn_TotalAmount
msdyn_TotalCost
msdyn_Unit
msdyn_UnitAmount
msdyn_UnitCost
msdyn_Warehouse
msdyn_WorkOrder
msdyn_WorkOrderIncident
msdyn_workorderproductId
OverriddenCreatedOn
OwnerId
OwnerIdType
statecode
statuscode
TimeZoneRuleVersionNumber
TransactionCurrencyId
UTCConversionTimeZoneCode

ImportSequenceNumber

Property	Value
Description	Shows the sequence number of the import that created this record.
DisplayName	Import Sequence Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`importsequencenumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

msdyn_AdditionalCost

Property	Value
Description	Enter any additional costs associated with this product. The values are manually entered. Note: additional cost is not unit dependent.
DisplayName	Additional Cost
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_additionalcost`
RequiredLevel	None
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_AgreementBookingProduct

Property	Value
Description	Agreement Booking Product linked to this Work Order Product
DisplayName	Agreement Booking Product
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_agreementbookingproduct`
RequiredLevel	None
Type	Lookup
Targets	msdyn_agreementbookingproduct

msdyn_Allocated

Property	Value
Description
DisplayName	Allocated
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_allocated`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`msdyn_workorderproduct_msdyn_allocated`
DefaultValue	False
True Label	Yes
False Label	No

msdyn_Booking

Property	Value
Description	The booking where this product was added
DisplayName	Booking
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_booking`
RequiredLevel	None
Type	Lookup
Targets	bookableresourcebooking

msdyn_CommissionCosts

Property	Value
Description	Enter the commission costs associated with this product. The value is manually specified and isn't automatically calculated.
DisplayName	Commission Costs
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_commissioncosts`
RequiredLevel	None
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_CustomerAsset

Property	Value
Description	Unique identifier for Customer Asset associated with Work Order Product.
DisplayName	Customer Asset
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_customerasset`
RequiredLevel	None
Type	Lookup
Targets	msdyn_customerasset

msdyn_Description

Property	Value
Description	Enter the description of the product as presented to the customer. The value defaults to the description defined on the product.
DisplayName	Description
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_description`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

msdyn_DisableEntitlement

Property	Value
Description	Choose whether to disable entitlement selection for this work order product.
DisplayName	Disable Entitlement
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_disableentitlement`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`msdyn_msdyn_workorderproduct_msdyn_disableentitlement`
DefaultValue	False
True Label	Yes
False Label	No

msdyn_DiscountAmount

Property	Value
Description	Specify any discount amount on this product. Note: If you enter a discount amount you cannot enter a discount %
DisplayName	Discount Amount
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_discountamount`
RequiredLevel	None
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_DiscountPercent

Property	Value
Description	Specify any discount % on this product. Note: If you enter a discount % it will overwrite the discount $
DisplayName	Discount %
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_discountpercent`
RequiredLevel	None
Type	Double
ImeMode	Auto
MaxValue	100
MinValue	0
Precision	2

msdyn_Entitlement

Property	Value
Description	Entitlement to apply to the Work Order Product.
DisplayName	Entitlement
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_entitlement`
RequiredLevel	None
Type	Lookup
Targets	entitlement

msdyn_EstimateDiscountAmount

Property	Value
Description	Enter a discount amount on the subtotal amount. Note: If you enter a discount amount you cannot enter a discount %
DisplayName	Estimate Discount Amount
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_estimatediscountamount`
RequiredLevel	None
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_EstimateDiscountPercent

Property	Value
Description	Enter a discount % on the subtotal amount. Note: If you enter a discount % it will overwrite the discount $
DisplayName	Estimate Discount %
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_estimatediscountpercent`
RequiredLevel	None
Type	Double
ImeMode	Auto
MaxValue	100
MinValue	0
Precision	2

msdyn_EstimateQuantity

Property	Value
Description	Enter the estimated required quantity of this product.
DisplayName	Estimate Quantity
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_estimatequantity`
RequiredLevel	None
Type	Double
ImeMode	Auto
MaxValue	1000000000
MinValue	0
Precision	2

msdyn_EstimateSubtotal

Property	Value
Description	Shows the total amount for this product, excluding discounts.
DisplayName	Estimate Subtotal
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_estimatesubtotal`
RequiredLevel	None
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_EstimateTotalAmount

Property	Value
Description	Shows the estimated total amount of this product, including discounts.
DisplayName	Estimate Total Amount
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_estimatetotalamount`
RequiredLevel	None
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_EstimateTotalCost

Property	Value
Description	Shows the estimated total cost of this product.
DisplayName	Estimate Total Cost
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_estimatetotalcost`
RequiredLevel	None
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_EstimateUnitAmount

Property	Value
Description	Shows the estimated sale amount per unit.
DisplayName	Estimate Unit Amount
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_estimateunitamount`
RequiredLevel	None
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_EstimateUnitCost

Property	Value
Description	Shows the estimated cost amount per unit.
DisplayName	Estimate Unit Cost
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_estimateunitcost`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_InternalDescription

Property	Value
Description	Enter any internal notes you want to track on this product.
DisplayName	Internal Description
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_internaldescription`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

msdyn_InternalFlags

Property	Value
Description	For internal use only.
DisplayName	Internal Flags
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_internalflags`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1048576

msdyn_LineOrder

Property	Value
Description
DisplayName	Line Order
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_lineorder`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

msdyn_LineStatus

Property	Value
Description	Enter the current status of the line, estimate or used.
DisplayName	Line Status
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_linestatus`
RequiredLevel	ApplicationRequired
Type	Picklist
DefaultFormValue	690970000
GlobalChoiceName	`msdyn_productservicestatus`

msdyn_LineStatus Choices/Options

Value	Label
690970000	Estimated
690970001	Used

msdyn_name

Property	Value
Description	Enter the name of the custom entity.
DisplayName	Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_name`
RequiredLevel	ApplicationRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

msdyn_PriceList

Property	Value
Description	Price List that determines the pricing for this product
DisplayName	Price List
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_pricelist`
RequiredLevel	ApplicationRequired
Type	Lookup
Targets	pricelevel

msdyn_Product

Property	Value
Description	Product to use
DisplayName	Product
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_product`
RequiredLevel	ApplicationRequired
Type	Lookup
Targets	product

msdyn_PurchaseOrderReceiptProduct

Property	Value
Description	Purchase Order Receipt Product linked to this Work Order Product
DisplayName	Purchase Order Receipt Product
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_purchaseorderreceiptproduct`
RequiredLevel	None
Type	Lookup
Targets	msdyn_purchaseorderreceiptproduct

msdyn_QtyToBill

Property	Value
Description	Enter the quantity you wish to bill the customer for. By default, this will default to the same value as "Quantity."
DisplayName	Quantity To Bill
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_qtytobill`
RequiredLevel	ApplicationRequired
Type	Double
ImeMode	Disabled
MaxValue	1000000000
MinValue	0
Precision	2

msdyn_Quantity

Property	Value
Description	Shows the actual quantity of the product.
DisplayName	Quantity
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_quantity`
RequiredLevel	ApplicationRequired
Type	Double
ImeMode	Disabled
MaxValue	1000000000
MinValue	0
Precision	2

msdyn_Subtotal

Property	Value
Description	Enter the total amount excluding discounts.
DisplayName	Subtotal
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_subtotal`
RequiredLevel	ApplicationRequired
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_Taxable

Property	Value
Description	Specify if product is taxable. If you do not wish to charge tax set this field to No.
DisplayName	Taxable
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_taxable`
RequiredLevel	ApplicationRequired
Type	Boolean
GlobalChoiceName	`msdyn_workorderproduct_msdyn_taxable`
DefaultValue	False
True Label	Yes
False Label	No

msdyn_TotalAmount

Property	Value
Description	Enter the total amount charged to the customer.
DisplayName	Total Amount
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_totalamount`
RequiredLevel	ApplicationRequired
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_TotalCost

Property	Value
Description	*Shows the total cost of this product. This is calculated by (Unit Cost Units) + Additional Cost + Commission Costs.**
DisplayName	Total Cost
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_totalcost`
RequiredLevel	ApplicationRequired
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_Unit

Property	Value
Description	The unit that determines the pricing and final quantity for this product
DisplayName	Unit
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_unit`
RequiredLevel	ApplicationRequired
Type	Lookup
Targets	uom

msdyn_UnitAmount

Property	Value
Description	Enter the amount you want to charge the customer per unit. By default, this is calculated based on the selected price list. The amount can be changed.
DisplayName	Unit Amount
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_unitamount`
RequiredLevel	ApplicationRequired
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_UnitCost

Property	Value
Description	Shows the actual cost per unit.
DisplayName	Unit Cost
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_unitcost`
RequiredLevel	ApplicationRequired
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_Warehouse

Property	Value
Description	Warehouse this product is being retrieved from
DisplayName	Warehouse
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_warehouse`
RequiredLevel	None
Type	Lookup
Targets	msdyn_warehouse

msdyn_WorkOrder

Property	Value
Description	Unique identifier for Work Order associated with Work Order Product.
DisplayName	Work Order
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_workorder`
RequiredLevel	ApplicationRequired
Type	Lookup
Targets	msdyn_workorder

msdyn_WorkOrderIncident

Property	Value
Description	The Incident related to this product
DisplayName	Work Order Incident
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_workorderincident`
RequiredLevel	None
Type	Lookup
Targets	msdyn_workorderincident

msdyn_workorderproductId

Property	Value
Description	Shows the entity instances.
DisplayName	Work Order Product
IsValidForForm	False
IsValidForRead	True
LogicalName	`msdyn_workorderproductid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

OverriddenCreatedOn

Property	Value
Description	Shows the date and time that the record was migrated.
DisplayName	Record Created On
IsValidForForm	False
IsValidForRead	True
LogicalName	`overriddencreatedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

OwnerId

Property	Value
Description	Owner Id
DisplayName	Owner
IsValidForForm	True
IsValidForRead	True
LogicalName	`ownerid`
RequiredLevel	SystemRequired
Type	Owner
Targets	systemuser, team

OwnerIdType

Property	Value
Description	Owner Id Type
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owneridtype`
RequiredLevel	SystemRequired
Type	EntityName

statecode

Property	Value
Description	Status of the Work Order Product
DisplayName	Status
IsValidForForm	True
IsValidForRead	True
LogicalName	`statecode`
RequiredLevel	SystemRequired
Type	State
DefaultFormValue
GlobalChoiceName	`msdyn_workorderproduct_statecode`

statecode Choices/Options

Value	Details
0	Label: Active DefaultStatus: 1 InvariantName: `Active`
1	Label: Inactive DefaultStatus: 2 InvariantName: `Inactive`

statuscode

Property	Value
Description	Reason for the status of the Work Order Product
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	`statuscode`
RequiredLevel	None
Type	Status
DefaultFormValue
GlobalChoiceName	`msdyn_workorderproduct_statuscode`

statuscode Choices/Options

Value	Details
1	Label: Active State:0 TransitionData: None
2	Label: Inactive State:1 TransitionData: None

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName	Time Zone Rule Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`timezoneruleversionnumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

TransactionCurrencyId

Property	Value
Description	Unique identifier of the currency associated with the entity.
DisplayName	Currency
IsValidForForm	True
IsValidForRead	True
LogicalName	`transactioncurrencyid`
RequiredLevel	None
Type	Lookup
Targets	transactioncurrency

UTCConversionTimeZoneCode

Property	Value
Description	Shows the time zone code that was in use when the record was created.
DisplayName	UTC Conversion Time Zone Code
IsValidForForm	False
IsValidForRead	True
LogicalName	`utcconversiontimezonecode`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

CreatedBy
CreatedOn
CreatedOnBehalfBy
ExchangeRate
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
msdyn_additionalcost_Base
msdyn_commissioncosts_Base
msdyn_discountamount_Base
msdyn_estimatediscountamount_Base
msdyn_estimatesubtotal_Base
msdyn_estimatetotalamount_Base
msdyn_estimatetotalcost_Base
msdyn_estimateunitamount_Base
msdyn_estimateunitcost_Base
msdyn_subtotal_Base
msdyn_totalamount_Base
msdyn_totalcost_Base
msdyn_unitamount_Base
msdyn_unitcost_Base
OwnerIdName
OwnerIdYomiName
OwningBusinessUnit
OwningTeam
OwningUser
VersionNumber

CreatedBy

Property	Value
Description	Unique identifier of the user who created the record.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName	Created On
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

CreatedOnBehalfBy

Property	Value
Description	Shows who created the record on behalf of another user.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ExchangeRate

Property	Value
Description	Shows the exchange rate for the currency associated with the entity with respect to the base currency.
DisplayName	Exchange Rate
IsValidForForm	True
IsValidForRead	True
LogicalName	`exchangerate`
RequiredLevel	None
Type	Decimal
ImeMode	Disabled
MaxValue	100000000000
MinValue	1E-10
Precision	10
SourceTypeMask	0

ModifiedBy

Property	Value
Description	Unique identifier of the user who modified the record.
DisplayName	Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName	Modified On
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ModifiedOnBehalfBy

Property	Value
Description	Shows who last updated the record on behalf of another user.
DisplayName	Modified By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

msdyn_additionalcost_Base

Property	Value
Description	Shows the value of the additional cost in the base currency.
DisplayName	Additional Cost (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_additionalcost_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_commissioncosts_Base

Property	Value
Description	Shows the value of the commission costs in the base currency.
DisplayName	Commission Costs (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_commissioncosts_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_discountamount_Base

Property	Value
Description	Shows the value of the discount amount in the base currency.
DisplayName	Discount Amount (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_discountamount_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_estimatediscountamount_Base

Property	Value
Description	Shows the value of the estimate discount amount in the base currency.
DisplayName	Estimate Discount Amount (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_estimatediscountamount_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_estimatesubtotal_Base

Property	Value
Description	Shows the value of the estimate subtotal in the base currency.
DisplayName	Estimate Subtotal (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_estimatesubtotal_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_estimatetotalamount_Base

Property	Value
Description	Shows the value of the estimate total amount in the base currency.
DisplayName	Estimate Total Amount (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_estimatetotalamount_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_estimatetotalcost_Base

Property	Value
Description	Shows the value of the estimate total cost in the base currency.
DisplayName	Estimate Total Cost (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_estimatetotalcost_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_estimateunitamount_Base

Property	Value
Description	Shows the value of the estimate unit amount in the base currency.
DisplayName	Estimate Unit Amount (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_estimateunitamount_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_estimateunitcost_Base

Property	Value
Description	Shows the value of the estimate unit cost in the base currency.
DisplayName	Estimate Unit Cost (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_estimateunitcost_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_subtotal_Base

Property	Value
Description	Shows the value of the subtotal in the base currency.
DisplayName	Subtotal (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_subtotal_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_totalamount_Base

Property	Value
Description	Shows the value of the total amount in the base currency.
DisplayName	Total Amount (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_totalamount_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_totalcost_Base

Property	Value
Description	Shows the value of the total cost in the base currency.
DisplayName	Total Cost (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_totalcost_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_unitamount_Base

Property	Value
Description	Shows the value of the unit amount in the base currency.
DisplayName	Unit Amount (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_unitamount_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_unitcost_Base

Property	Value
Description	Shows the value of the unit cost in the base currency.
DisplayName	Unit Cost (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_unitcost_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

OwnerIdName

Property	Value
Description	Name of the owner
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owneridname`
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

OwnerIdYomiName

Property	Value
Description	Yomi name of the owner
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	`owneridyominame`
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

OwningBusinessUnit

Property	Value
Description	Unique identifier for the business unit that owns the record
DisplayName	Owning Business Unit
IsValidForForm	True
IsValidForRead	True
LogicalName	`owningbusinessunit`
RequiredLevel	None
Type	Lookup
Targets	businessunit

OwningTeam

Property	Value
Description	Unique identifier for the team that owns the record.
DisplayName	Owning Team
IsValidForForm	False
IsValidForRead	True
LogicalName	`owningteam`
RequiredLevel	None
Type	Lookup
Targets	team

OwningUser

Property	Value
Description	Unique identifier for the user that owns the record.
DisplayName	Owning User
IsValidForForm	False
IsValidForRead	True
LogicalName	`owninguser`
RequiredLevel	None
Type	Lookup
Targets	systemuser

VersionNumber

Property	Value
Description	Version Number
DisplayName	Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`versionnumber`
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

Many-to-One relationships

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

msdyn_bookableresourcebooking_msdyn_workorderproduct_Booking
msdyn_entitlement_msdyn_workorderproduct_Entitlement
msdyn_msdyn_agreementbookingproduct_msdyn_workorderproduct_AgreementBookingProduct
msdyn_msdyn_customerasset_msdyn_workorderproduct_CustomerAsset
msdyn_msdyn_purchaseorderreceiptproduct_msdyn_workorderproduct_PurchaseOrderReceiptProduct
msdyn_msdyn_warehouse_msdyn_workorderproduct_Warehouse
msdyn_msdyn_workorder_msdyn_workorderproduct_WorkOrder
msdyn_msdyn_workorderincident_msdyn_workorderproduct_WorkOrderIncident
msdyn_product_msdyn_workorderproduct_Product

msdyn_bookableresourcebooking_msdyn_workorderproduct_Booking

One-To-Many Relationship: bookableresourcebooking msdyn_bookableresourcebooking_msdyn_workorderproduct_Booking

Property	Value
ReferencedEntity	`bookableresourcebooking`
ReferencedAttribute	`bookableresourcebookingid`
ReferencingAttribute	`msdyn_booking`
ReferencingEntityNavigationPropertyName	`msdyn_booking`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_entitlement_msdyn_workorderproduct_Entitlement

One-To-Many Relationship: entitlement msdyn_entitlement_msdyn_workorderproduct_Entitlement

Property	Value
ReferencedEntity	`entitlement`
ReferencedAttribute	`entitlementid`
ReferencingAttribute	`msdyn_entitlement`
ReferencingEntityNavigationPropertyName	`msdyn_Entitlement`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_msdyn_agreementbookingproduct_msdyn_workorderproduct_AgreementBookingProduct

One-To-Many Relationship: msdyn_agreementbookingproduct msdyn_msdyn_agreementbookingproduct_msdyn_workorderproduct_AgreementBookingProduct

Property	Value
ReferencedEntity	`msdyn_agreementbookingproduct`
ReferencedAttribute	`msdyn_agreementbookingproductid`
ReferencingAttribute	`msdyn_agreementbookingproduct`
ReferencingEntityNavigationPropertyName	`msdyn_agreementbookingproduct`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_msdyn_customerasset_msdyn_workorderproduct_CustomerAsset

One-To-Many Relationship: msdyn_customerasset msdyn_msdyn_customerasset_msdyn_workorderproduct_CustomerAsset

Property	Value
ReferencedEntity	`msdyn_customerasset`
ReferencedAttribute	`msdyn_customerassetid`
ReferencingAttribute	`msdyn_customerasset`
ReferencingEntityNavigationPropertyName	`msdyn_customerasset`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_msdyn_purchaseorderreceiptproduct_msdyn_workorderproduct_PurchaseOrderReceiptProduct

One-To-Many Relationship: msdyn_purchaseorderreceiptproduct msdyn_msdyn_purchaseorderreceiptproduct_msdyn_workorderproduct_PurchaseOrderReceiptProduct

Property	Value
ReferencedEntity	`msdyn_purchaseorderreceiptproduct`
ReferencedAttribute	`msdyn_purchaseorderreceiptproductid`
ReferencingAttribute	`msdyn_purchaseorderreceiptproduct`
ReferencingEntityNavigationPropertyName	`msdyn_purchaseorderreceiptproduct`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_msdyn_warehouse_msdyn_workorderproduct_Warehouse

One-To-Many Relationship: msdyn_warehouse msdyn_msdyn_warehouse_msdyn_workorderproduct_Warehouse

Property	Value
ReferencedEntity	`msdyn_warehouse`
ReferencedAttribute	`msdyn_warehouseid`
ReferencingAttribute	`msdyn_warehouse`
ReferencingEntityNavigationPropertyName	`msdyn_warehouse`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_msdyn_workorder_msdyn_workorderproduct_WorkOrder

One-To-Many Relationship: msdyn_workorder msdyn_msdyn_workorder_msdyn_workorderproduct_WorkOrder

Property	Value
ReferencedEntity	`msdyn_workorder`
ReferencedAttribute	`msdyn_workorderid`
ReferencingAttribute	`msdyn_workorder`
ReferencingEntityNavigationPropertyName	`msdyn_workorder`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `Cascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `Cascade` RollupView: `NoCascade` Share: `Cascade` Unshare: `Cascade`

msdyn_msdyn_workorderincident_msdyn_workorderproduct_WorkOrderIncident

One-To-Many Relationship: msdyn_workorderincident msdyn_msdyn_workorderincident_msdyn_workorderproduct_WorkOrderIncident

Property	Value
ReferencedEntity	`msdyn_workorderincident`
ReferencedAttribute	`msdyn_workorderincidentid`
ReferencingAttribute	`msdyn_workorderincident`
ReferencingEntityNavigationPropertyName	`msdyn_workorderincident`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

msdyn_product_msdyn_workorderproduct_Product

One-To-Many Relationship: product msdyn_product_msdyn_workorderproduct_Product

Property	Value
ReferencedEntity	`product`
ReferencedAttribute	`productid`
ReferencingAttribute	`msdyn_product`
ReferencingEntityNavigationPropertyName	`msdyn_product`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

One-to-Many relationships

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

msdyn_msdyn_workorderproduct_msdyn_customerasset_WorkOrderProduct
msdyn_msdyn_workorderproduct_msdyn_inventoryjournal_WorkOrderProduct
msdyn_msdyn_workorderproduct_msdyn_rmaproduct_WOProduct
msdyn_msdyn_workorderproduct_msdyn_rtvproduct_WorkOrderProduct
msdyn_workorderproduct_msdyn_bookingalerts

msdyn_msdyn_workorderproduct_msdyn_customerasset_WorkOrderProduct

Many-To-One Relationship: msdyn_customerasset msdyn_msdyn_workorderproduct_msdyn_customerasset_WorkOrderProduct

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

msdyn_msdyn_workorderproduct_msdyn_inventoryjournal_WorkOrderProduct

Many-To-One Relationship: msdyn_inventoryjournal msdyn_msdyn_workorderproduct_msdyn_inventoryjournal_WorkOrderProduct

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

msdyn_msdyn_workorderproduct_msdyn_rmaproduct_WOProduct

Many-To-One Relationship: msdyn_rmaproduct msdyn_msdyn_workorderproduct_msdyn_rmaproduct_WOProduct

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

msdyn_msdyn_workorderproduct_msdyn_rtvproduct_WorkOrderProduct

Many-To-One Relationship: msdyn_rtvproduct msdyn_msdyn_workorderproduct_msdyn_rtvproduct_WorkOrderProduct

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

msdyn_workorderproduct_msdyn_bookingalerts

Many-To-One Relationship: msdyn_bookingalert msdyn_workorderproduct_msdyn_bookingalerts

Property	Value
ReferencingEntity	`msdyn_bookingalert`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`msdyn_workorderproduct_msdyn_bookingalerts`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Feedback

Was this page helpful?