msdyn_workorderproduct EntityType

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

Entity Set Path
[organization URI]/api/data/v9.0/msdyn_workorderproducts
Base Type
crmbaseentity
Display Name
Work Order Product
Primary Key
msdyn_workorderproductid
Primary Key Attribute
msdyn_name
Operations Supported
POST GET PATCH DELETE

Properties

Properties represent fields of data stored in the entity.Some properties are read-only.

Name Type Details
createdon Edm.DateTimeOffset

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.

Display Name: Created On

Read Only
exchangerate Edm.Decimal

Shows the exchange rate for the currency associated with the entity with respect to the base currency.

Display Name: Exchange Rate

Read Only
importsequencenumber Edm.Int32

Shows the sequence number of the import that created this record.

Display Name: Import Sequence Number

modifiedon Edm.DateTimeOffset

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.

Display Name: Modified On

Read Only
msdyn_additionalcost Edm.Decimal

Enter any additional costs associated with this product. The values are manually entered. Note: additional cost is not unit dependent.

Display Name: Additional Cost

msdyn_additionalcost_base Edm.Decimal

Shows the value of the additional cost in the base currency.

Display Name: Additional Cost (Base)

Read Only
msdyn_allocated Edm.Boolean

Display Name: Allocated

Default Options
Value Label
1 Yes
0 No
msdyn_commissioncosts Edm.Decimal

Enter the commission costs associated with this product. The value is manually specified and isn't automatically calculated.

Display Name: Commission Costs

msdyn_commissioncosts_base Edm.Decimal

Shows the value of the commission costs in the base currency.

Display Name: Commission Costs (Base)

Read Only
msdyn_description Edm.String

Enter the description of the product as presented to the customer. The value defaults to the description defined on the product.

Display Name: Description

msdyn_discountamount Edm.Decimal

Specify any discount amount on this product. Note: If you enter a discount amount you cannot enter a discount %

Display Name: Discount Amount

msdyn_discountamount_base Edm.Decimal

Shows the value of the discount amount in the base currency.

Display Name: Discount Amount (Base)

Read Only
msdyn_discountpercent Edm.Double

Specify any discount % on this product. Note: If you enter a discount % it will overwrite the discount $

Display Name: Discount %

msdyn_estimatediscountamount Edm.Decimal

Enter a discount amount on the subtotal amount. Note: If you enter a discount amount you cannot enter a discount %

Display Name: Estimate Discount Amount

msdyn_estimatediscountamount_base Edm.Decimal

Shows the value of the estimate discount amount in the base currency.

Display Name: Estimate Discount Amount (Base)

Read Only
msdyn_estimatediscountpercent Edm.Double

Enter a discount % on the subtotal amount. Note: If you enter a discount % it will overwrite the discount $

Display Name: Estimate Discount %

msdyn_estimatequantity Edm.Double

Enter the estimated required quantity of this product.

Display Name: Estimate Quantity

msdyn_estimatesubtotal Edm.Decimal

Shows the total amount for this product, excluding discounts.

Display Name: Estimate Subtotal

msdyn_estimatesubtotal_base Edm.Decimal

Shows the value of the estimate subtotal in the base currency.

Display Name: Estimate Subtotal (Base)

Read Only
msdyn_estimatetotalamount Edm.Decimal

Shows the estimated total amount of this product, including discounts.

Display Name: Estimate Total Amount

msdyn_estimatetotalamount_base Edm.Decimal

Shows the value of the estimate total amount in the base currency.

Display Name: Estimate Total Amount (Base)

Read Only
msdyn_estimatetotalcost Edm.Decimal

Shows the estimated total cost of this product.

Display Name: Estimate Total Cost

msdyn_estimatetotalcost_base Edm.Decimal

Shows the value of the estimate total cost in the base currency.

Display Name: Estimate Total Cost (Base)

Read Only
msdyn_estimateunitamount Edm.Decimal

Shows the estimated sale amount per unit.

Display Name: Estimate Unit Amount

msdyn_estimateunitamount_base Edm.Decimal

Shows the value of the estimate unit amount in the base currency.

Display Name: Estimate Unit Amount (Base)

Read Only
msdyn_estimateunitcost Edm.Decimal

Shows the estimated cost amount per unit.

Display Name: Estimate Unit Cost

msdyn_estimateunitcost_base Edm.Decimal

Shows the value of the estimate unit cost in the base currency.

Display Name: Estimate Unit Cost (Base)

Read Only
msdyn_internaldescription Edm.String

Enter any internal notes you want to track on this product.

Display Name: Internal Description

msdyn_internalflags Edm.String

For internal use only.

Display Name: Internal Flags

msdyn_lineorder Edm.Int32

Display Name: Line Order

msdyn_linestatus Edm.Int32

Enter the current status of the line, estimate or used.

Display Name: Line Status

Default Options
Value Label
690970000 Estimated
690970001 Used
msdyn_name Edm.String

Enter the name of the custom entity.

Display Name: Name

msdyn_qtytobill Edm.Double

Enter the quantity you wish to bill the customer for. By default, this will default to the same value as "Quantity."

Display Name: Quantity To Bill

msdyn_quantity Edm.Double

Shows the actual quantity of the product.

Display Name: Quantity

msdyn_subtotal Edm.Decimal

Enter the total amount excluding discounts.

Display Name: Subtotal

msdyn_subtotal_base Edm.Decimal

Shows the value of the subtotal in the base currency.

Display Name: Subtotal (Base)

Read Only
msdyn_taxable Edm.Boolean

Specify if product is taxable. If you do not wish to charge tax set this field to No.

Display Name: Taxable

Default Options
Value Label
1 Yes
0 No
msdyn_totalamount Edm.Decimal

Enter the total amount charged to the customer.

Display Name: Total Amount

msdyn_totalamount_base Edm.Decimal

Shows the value of the total amount in the base currency.

Display Name: Total Amount (Base)

Read Only
msdyn_totalcost Edm.Decimal

Shows the total cost of this product. This is calculated by (Unit Cost * Units) + Additional Cost + Commission Costs.

Display Name: Total Cost

msdyn_totalcost_base Edm.Decimal

Shows the value of the total cost in the base currency.

Display Name: Total Cost (Base)

Read Only
msdyn_unitamount Edm.Decimal

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.

Display Name: Unit Amount

msdyn_unitamount_base Edm.Decimal

Shows the value of the unit amount in the base currency.

Display Name: Unit Amount (Base)

Read Only
msdyn_unitcost Edm.Decimal

Shows the actual cost per unit.

Display Name: Unit Cost

msdyn_unitcost_base Edm.Decimal

Shows the value of the unit cost in the base currency.

Display Name: Unit Cost (Base)

Read Only
msdyn_workorderproductid Edm.Guid

Shows the entity instances.

Display Name: Work Order Product

overriddencreatedon Edm.DateTimeOffset

Shows the date and time that the record was migrated.

Display Name: Record Created On

statecode Edm.Int32

Status of the Work Order Product

Display Name: Status

Default Options
Value Label
0 Active
1 Inactive
statuscode Edm.Int32

Reason for the status of the Work Order Product

Display Name: Status Reason

Default Options
Value Label
1 Active
2 Inactive
timezoneruleversionnumber Edm.Int32

For internal use only.

Display Name: Time Zone Rule Version Number

utcconversiontimezonecode Edm.Int32

Shows the time zone code that was in use when the record was created.

Display Name: UTC Conversion Time Zone Code

versionnumber Edm.Int64

Version Number

Display Name: Version Number

Read Only

Lookup Properties

Lookup properties are read-only, computed properties which contain entity primary key Edm.Guid data for one or more corresponding single-valued navigation properties. More information: Lookup properties and Retrieve data about lookup properties.

Name Single-valued navigation property Description
_createdby_value createdby

Unique identifier of the user who created the record.

_createdonbehalfby_value createdonbehalfby

Shows who created the record on behalf of another user.

_modifiedby_value modifiedby

Unique identifier of the user who modified the record.

_modifiedonbehalfby_value modifiedonbehalfby

Shows who last updated the record on behalf of another user.

_msdyn_agreementbookingproduct_value msdyn_agreementbookingproduct

Agreement Booking Product linked to this Work Order Product

_msdyn_booking_value msdyn_booking

The booking where this product was added

_msdyn_customerasset_value msdyn_customerasset

Unique identifier for Customer Asset associated with Work Order Product.

_msdyn_pricelist_value msdyn_pricelist

Price List that determines the pricing for this product

_msdyn_product_value msdyn_product

Product to use

_msdyn_purchaseorderreceiptproduct_value msdyn_purchaseorderreceiptproduct

Purchase Order Receipt Product linked to this Work Order Product

_msdyn_unit_value msdyn_unit

The unit that determines the pricing and final quantity for this product

_msdyn_warehouse_value msdyn_warehouse

Warehouse this product is being retrieved from

_msdyn_workorder_value msdyn_workorder

Unique identifier for Work Order associated with Work Order Product.

_msdyn_workorderincident_value msdyn_workorderincident

The Incident related to this product

_ownerid_value ownerid

Owner Id

_owningbusinessunit_value owningbusinessunit

Unique identifier for the business unit that owns the record

_owningteam_value owningteam

Unique identifier for the team that owns the record.

_owninguser_value owninguser

Unique identifier for the user that owns the record.

_transactioncurrencyid_value transactioncurrencyid

Unique identifier of the currency associated with the entity.

Single-valued navigation properties

Single-valued navigation properties represent lookup fields where a single entity can be referenced. Each single-valued navigation property has a corresponding partner collection-valued navigation property on the related entity.

Name Type Partner
createdby systemuser lk_msdyn_workorderproduct_createdby
createdonbehalfby systemuser lk_msdyn_workorderproduct_createdonbehalfby
modifiedby systemuser lk_msdyn_workorderproduct_modifiedby
modifiedonbehalfby systemuser lk_msdyn_workorderproduct_modifiedonbehalfby
msdyn_agreementbookingproduct msdyn_agreementbookingproduct msdyn_msdyn_agreementbookingproduct_msdyn_workorderproduct_AgreementBookingProduct
msdyn_booking bookableresourcebooking msdyn_bookableresourcebooking_msdyn_workorderproduct_Booking
msdyn_customerasset msdyn_customerasset msdyn_msdyn_customerasset_msdyn_workorderproduct_CustomerAsset
msdyn_pricelist pricelevel msdyn_pricelevel_msdyn_workorderproduct_PriceList
msdyn_product product msdyn_product_msdyn_workorderproduct_Product
msdyn_purchaseorderreceiptproduct msdyn_purchaseorderreceiptproduct msdyn_msdyn_purchaseorderreceiptproduct_msdyn_workorderproduct_PurchaseOrderReceiptProduct
msdyn_unit uom msdyn_uom_msdyn_workorderproduct_Unit
msdyn_warehouse msdyn_warehouse msdyn_msdyn_warehouse_msdyn_workorderproduct_Warehouse
msdyn_workorder msdyn_workorder msdyn_msdyn_workorder_msdyn_workorderproduct_WorkOrder
msdyn_workorderincident msdyn_workorderincident msdyn_msdyn_workorderincident_msdyn_workorderproduct_WorkOrderIncident
ownerid principal owner_msdyn_workorderproduct
owningbusinessunit businessunit business_unit_msdyn_workorderproduct
owningteam team team_msdyn_workorderproduct
owninguser systemuser user_msdyn_workorderproduct
transactioncurrencyid transactioncurrency TransactionCurrency_msdyn_workorderproduct

Collection-valued navigation properties

Collection-valued navigation properties represent collections of entities which may represent either a one-to-many (1:N) or many-to-many (N:N) relationship between the entities.

Name Type Partner
msdyn_msdyn_workorderproduct_invoicedetail invoicedetail msdyn_workorderproductid
msdyn_msdyn_workorderproduct_msdyn_customerasset_WorkOrderProduct msdyn_customerasset msdyn_workorderproduct
msdyn_msdyn_workorderproduct_msdyn_inventoryjournal_WorkOrderProduct msdyn_inventoryjournal msdyn_workorderproduct
msdyn_msdyn_workorderproduct_msdyn_rmaproduct_WOProduct msdyn_rmaproduct msdyn_woproduct
msdyn_msdyn_workorderproduct_msdyn_rtvproduct_WorkOrderProduct msdyn_rtvproduct msdyn_workorderproduct
msdyn_workorderproduct_ActivityPointers activitypointer regardingobjectid_msdyn_workorderproduct
msdyn_workorderproduct_Annotations annotation objectid_msdyn_workorderproduct
msdyn_workorderproduct_Appointments appointment regardingobjectid_msdyn_workorderproduct_appointment
msdyn_workorderproduct_AsyncOperations asyncoperation regardingobjectid_msdyn_workorderproduct
msdyn_workorderproduct_BulkDeleteFailures bulkdeletefailure regardingobjectid_msdyn_workorderproduct
msdyn_workorderproduct_connections1 connection record1id_msdyn_workorderproduct
msdyn_workorderproduct_connections2 connection record2id_msdyn_workorderproduct
msdyn_workorderproduct_Emails email regardingobjectid_msdyn_workorderproduct_email
msdyn_workorderproduct_Faxes fax regardingobjectid_msdyn_workorderproduct_fax
msdyn_workorderproduct_Letters letter regardingobjectid_msdyn_workorderproduct_letter
msdyn_workorderproduct_MailboxTrackingFolders mailboxtrackingfolder regardingobjectid_msdyn_workorderproduct
msdyn_workorderproduct_msdyn_approvals msdyn_approval regardingobjectid_msdyn_workorderproduct_msdyn_approval
msdyn_workorderproduct_msdyn_bookingalerts msdyn_bookingalert regardingobjectid_msdyn_workorderproduct_msdyn_bookingalert
msdyn_workorderproduct_PhoneCalls phonecall regardingobjectid_msdyn_workorderproduct_phonecall
msdyn_workorderproduct_PrincipalObjectAttributeAccesses principalobjectattributeaccess objectid_msdyn_workorderproduct
msdyn_workorderproduct_ProcessSession processsession regardingobjectid_msdyn_workorderproduct
msdyn_workorderproduct_RecurringAppointmentMasters recurringappointmentmaster regardingobjectid_msdyn_workorderproduct_recurringappointmentmaster
msdyn_workorderproduct_ServiceAppointments serviceappointment regardingobjectid_msdyn_workorderproduct_serviceappointment
msdyn_workorderproduct_SharePointDocumentLocations sharepointdocumentlocation regardingobjectid_msdyn_workorderproduct
msdyn_workorderproduct_SocialActivities socialactivity regardingobjectid_msdyn_workorderproduct_socialactivity
msdyn_workorderproduct_SyncErrors syncerror regardingobjectid_msdyn_workorderproduct
msdyn_workorderproduct_Tasks task regardingobjectid_msdyn_workorderproduct_task

Operations

The following operations can be used with the msdyn_workorderproduct entity type.

Name Binding
GrantAccess Not Bound
IsValidStateTransition Not Bound
ModifyAccess Not Bound
RetrievePrincipalAccess Not Bound
RetrieveSharedPrincipalsAndAccess Not Bound
RevokeAccess Not Bound

Solutions

The following solutions include the msdyn_workorderproduct entity type.

Name Description
Field Service Microsoft Dynamics 365 for Field Service allows organizations of any size to deliver intelligent, world class field service, managing all aspects of the end-to-end field service management cycle. Features include scheduling, mobile, asset management, inventory control, customer notifications, and resource utilization controls that help maximize efficiency and minimize costs.

See also