msdyn_purchaseorderproduct EntityType

Record products to be ordered on purchase order

Entity Set Path
[organization URI]/api/data/v9.0/msdyn_purchaseorderproducts
Base Type
Display Name
Purchase Order Product
Primary Key
Primary Key Attribute
Operations Supported


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_dateexpected Edm.DateTimeOffset

Enter the date you expect this product to arrive to the shipping address. This value defaults to the date set on the PO.

Display Name: Date Expected

msdyn_description Edm.String

Enter the product description to display for the vendor.

Display Name: Description

msdyn_internalflags Edm.String

Display Name: Internal Flags

msdyn_isordered Edm.Boolean

Display Name: Is Ordered

Default Options
Value Label
1 Yes
0 No
msdyn_itemstatus Edm.Int32

Enter the current status of this product.

Display Name: Item Status

Default Options
Value Label
690970000 Pending
690970001 Received
690970002 Canceled
msdyn_lineorder Edm.Int32

Shows the order of this product within the purchase order.

Display Name: Line Order

msdyn_name Edm.String

Enter the name of the custom entity.

Display Name: Name

msdyn_purchaseorderproductid Edm.Guid

Shows the entity instances.

Display Name: Purchase Order Product

msdyn_qtybilled Edm.Double

Enter the quantity currently billed.

Display Name: Quantity Billed

msdyn_qtyreceived Edm.Double

Enter the quantity currently received.

Display Name: Quantity Received

msdyn_quantity Edm.Double

Enter the quantity ordered.

Display Name: Quantity

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_unitcost Edm.Decimal

Enter the cost of this product 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
overriddencreatedon Edm.DateTimeOffset

Shows the date and time that the record was migrated.

Display Name: Record Created On

statecode Edm.Int32

Status of the Purchase Order Product

Display Name: Status

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

Reason for the status of the Purchase 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_associatetobooking_value msdyn_associatetobooking

Link this product to Booking. If specified and warehouse is not set then product will be added to Resource Booking

_msdyn_associatetowarehouse_value msdyn_associatetowarehouse

Warehouse to which this product should be received to

_msdyn_associatetoworkorder_value msdyn_associatetoworkorder

Link this product to Work Order. If specified and warehouse is not set then product will be added to work order

_msdyn_product_value msdyn_product

Product to order

_msdyn_purchaseorder_value msdyn_purchaseorder

Purchase order this line item relates to

_msdyn_unit_value msdyn_unit

Unit for 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_purchaseorderproduct_createdby
createdonbehalfby systemuser lk_msdyn_purchaseorderproduct_createdonbehalfby
modifiedby systemuser lk_msdyn_purchaseorderproduct_modifiedby
modifiedonbehalfby systemuser lk_msdyn_purchaseorderproduct_modifiedonbehalfby
msdyn_associatetobooking bookableresourcebooking msdyn_bookableresourcebooking_msdyn_purchaseorderproduct_AssociateToBooking
msdyn_associatetowarehouse msdyn_warehouse msdyn_msdyn_warehouse_msdyn_purchaseorderproduct_AssociateToWarehouse
msdyn_associatetoworkorder msdyn_workorder msdyn_msdyn_workorder_msdyn_purchaseorderproduct_AssociateToWorkOrder
msdyn_product product msdyn_product_msdyn_purchaseorderproduct_Product
msdyn_purchaseorder msdyn_purchaseorder msdyn_msdyn_purchaseorder_msdyn_purchaseorderproduct_PurchaseOrder
msdyn_unit uom msdyn_uom_msdyn_purchaseorderproduct_Unit
ownerid principal owner_msdyn_purchaseorderproduct
owningbusinessunit businessunit business_unit_msdyn_purchaseorderproduct
owningteam team team_msdyn_purchaseorderproduct
owninguser systemuser user_msdyn_purchaseorderproduct
transactioncurrencyid transactioncurrency TransactionCurrency_msdyn_purchaseorderproduct

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_purchaseorderproduct_msdyn_inventoryjournal_POProduct msdyn_inventoryjournal msdyn_purchaseorderproduct
msdyn_msdyn_purchaseorderproduct_msdyn_purchaseorderreceiptproduct_POProduct msdyn_purchaseorderreceiptproduct msdyn_purchaseorderproduct
msdyn_purchaseorderproduct_ActivityPointers activitypointer regardingobjectid_msdyn_purchaseorderproduct
msdyn_purchaseorderproduct_Annotations annotation objectid_msdyn_purchaseorderproduct
msdyn_purchaseorderproduct_Appointments appointment regardingobjectid_msdyn_purchaseorderproduct_appointment
msdyn_purchaseorderproduct_AsyncOperations asyncoperation regardingobjectid_msdyn_purchaseorderproduct
msdyn_purchaseorderproduct_BulkDeleteFailures bulkdeletefailure regardingobjectid_msdyn_purchaseorderproduct
msdyn_purchaseorderproduct_connections1 connection record1id_msdyn_purchaseorderproduct
msdyn_purchaseorderproduct_connections2 connection record2id_msdyn_purchaseorderproduct
msdyn_purchaseorderproduct_Emails email regardingobjectid_msdyn_purchaseorderproduct_email
msdyn_purchaseorderproduct_Faxes fax regardingobjectid_msdyn_purchaseorderproduct_fax
msdyn_purchaseorderproduct_Letters letter regardingobjectid_msdyn_purchaseorderproduct_letter
msdyn_purchaseorderproduct_MailboxTrackingFolders mailboxtrackingfolder regardingobjectid_msdyn_purchaseorderproduct
msdyn_purchaseorderproduct_msdyn_approvals msdyn_approval regardingobjectid_msdyn_purchaseorderproduct_msdyn_approval
msdyn_purchaseorderproduct_msdyn_bookingalerts msdyn_bookingalert regardingobjectid_msdyn_purchaseorderproduct_msdyn_bookingalert
msdyn_purchaseorderproduct_PhoneCalls phonecall regardingobjectid_msdyn_purchaseorderproduct_phonecall
msdyn_purchaseorderproduct_PrincipalObjectAttributeAccesses principalobjectattributeaccess objectid_msdyn_purchaseorderproduct
msdyn_purchaseorderproduct_ProcessSession processsession regardingobjectid_msdyn_purchaseorderproduct
msdyn_purchaseorderproduct_RecurringAppointmentMasters recurringappointmentmaster regardingobjectid_msdyn_purchaseorderproduct_recurringappointmentmaster
msdyn_purchaseorderproduct_ServiceAppointments serviceappointment regardingobjectid_msdyn_purchaseorderproduct_serviceappointment
msdyn_purchaseorderproduct_SharePointDocumentLocations sharepointdocumentlocation regardingobjectid_msdyn_purchaseorderproduct
msdyn_purchaseorderproduct_SocialActivities socialactivity regardingobjectid_msdyn_purchaseorderproduct_socialactivity
msdyn_purchaseorderproduct_SyncErrors syncerror regardingobjectid_msdyn_purchaseorderproduct
msdyn_purchaseorderproduct_Tasks task regardingobjectid_msdyn_purchaseorderproduct_task


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

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


The following solutions include the msdyn_purchaseorderproduct 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