Purchase Order (msdyn_purchaseorder) table/entity reference (Microsoft Dynamics 365 Field Service)

Article
2025-02-08

Record Purchase Orders pertaining to Work Orders or otherwise

Messages

The following table lists the messages for the Purchase Order (msdyn_purchaseorder) 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_purchaseorders(msdyn_purchaseorderid) 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_purchaseorders See Create	Create records
`CreateMultiple` Event: True	CreateMultiple	CreateMultipleRequest
`Delete` Event: True	`DELETE` /msdyn_purchaseorders(msdyn_purchaseorderid) 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_purchaseorders(msdyn_purchaseorderid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: True	`GET` /msdyn_purchaseorders 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_purchaseorders(msdyn_purchaseorderid) Update the `statecode` and `statuscode` properties.	SetStateRequest
`Update` Event: True	`PATCH` /msdyn_purchaseorders(msdyn_purchaseorderid) See Update	Update records
`UpdateMultiple` Event: True	UpdateMultiple	UpdateMultipleRequest
`Upsert` Event: False	`PATCH` /msdyn_purchaseorders(msdyn_purchaseorderid) 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 Purchase Order (msdyn_purchaseorder) table.

Property	Value
DisplayName	Purchase Order
DisplayCollectionName	Purchase Orders
SchemaName	`msdyn_purchaseorder`
CollectionSchemaName	`msdyn_purchaseorders`
EntitySetName	`msdyn_purchaseorders`
LogicalName	`msdyn_purchaseorder`
LogicalCollectionName	`msdyn_purchaseorders`
PrimaryIdAttribute	`msdyn_purchaseorderid`
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_Address1
msdyn_Address2
msdyn_Address3
msdyn_AddressName
msdyn_AmountBilled
msdyn_ApprovalStatus
msdyn_ApprovedRejectedBy
msdyn_AutoNumbering
msdyn_Booking
msdyn_City
msdyn_Country
msdyn_DateExpected
msdyn_InternalFlags
msdyn_Latitude
msdyn_Longitude
msdyn_name
msdyn_OrderedBy
msdyn_PaymentTerm
msdyn_PODate
msdyn_PostalCode
msdyn_purchaseorderId
msdyn_ReceivetoWarehouse
msdyn_RequestedByResource
msdyn_ShipTo
msdyn_ShipVia
msdyn_StateOrProvince
msdyn_SubStatus
msdyn_SystemStatus
msdyn_TotalAmount
msdyn_Vendor
msdyn_VendorNote
msdyn_WorkOrder
OverriddenCreatedOn
OwnerId
OwnerIdType
processid
stageid
statecode
statuscode
TimeZoneRuleVersionNumber
TransactionCurrencyId
traversedpath
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_Address1

Property	Value
Description
DisplayName	Street 1
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_address1`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

msdyn_Address2

Property	Value
Description
DisplayName	Street 2
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_address2`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

msdyn_Address3

Property	Value
Description
DisplayName	Street 3
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_address3`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

msdyn_AddressName

Property	Value
Description	Enter the location to ship the products of this PO to.
DisplayName	Address Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_addressname`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

msdyn_AmountBilled

Property	Value
Description
DisplayName	Amount Billed
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_amountbilled`
RequiredLevel	None
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	900000000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_ApprovalStatus

Property	Value
Description	Enter the current status of the approval.
DisplayName	Approval Status
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_approvalstatus`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`msdyn_poapprovalstatus`

msdyn_ApprovalStatus Choices/Options

Value	Label
690970000	Approved
690970001	Rejected

msdyn_ApprovedRejectedBy

Property	Value
Description	The user who approved or rejected this PO
DisplayName	Approved/Rejected By
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_approvedrejectedby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

msdyn_AutoNumbering

Property	Value
Description	Internal field used to generate the next name upon entity creation. It is optionally copied to the msdyn_name field.
DisplayName	Auto-Numbering
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_autonumbering`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

msdyn_Booking

Property	Value
Description	If purchase order is being ordered directly to a booking specify here. Note, when specified, by default all products will receive directly to booking.
DisplayName	Booking
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_booking`
RequiredLevel	None
Type	Lookup
Targets	bookableresourcebooking

msdyn_City

Property	Value
Description
DisplayName	City
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_city`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	80

msdyn_Country

Property	Value
Description
DisplayName	Country/Region
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_country`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	80

msdyn_DateExpected

Property	Value
Description	Enter the date you expect to receive your order. Note that products added once the date is specified here will automatically be set to this date.
DisplayName	Date Expected
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_dateexpected`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	True
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Auto
SourceTypeMask	0

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_Latitude

Property	Value
Description
DisplayName	Latitude
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_latitude`
RequiredLevel	None
Type	Double
ImeMode	Auto
MaxValue	90
MinValue	-90
Precision	5

msdyn_Longitude

Property	Value
Description
DisplayName	Longitude
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_longitude`
RequiredLevel	None
Type	Double
ImeMode	Auto
MaxValue	180
MinValue	-180
Precision	5

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	100

msdyn_OrderedBy

Property	Value
Description	Unique identifier for User associated with Purchase Order.
DisplayName	Ordered By
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_orderedby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

msdyn_PaymentTerm

Property	Value
Description	The payment terms for this PO
DisplayName	Payment Term
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_paymentterm`
RequiredLevel	None
Type	Lookup
Targets	msdyn_paymentterm

msdyn_PODate

Property	Value
Description	Shows the date you submitted your order to the vendor. Note this field is for information only.
DisplayName	Purchase Order Date
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_purchaseorderdate`
RequiredLevel	ApplicationRequired
Type	DateTime
CanChangeDateTimeBehavior	True
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Auto
SourceTypeMask	0

msdyn_PostalCode

Property	Value
Description
DisplayName	Postal Code
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_postalcode`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	20

msdyn_purchaseorderId

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

msdyn_ReceivetoWarehouse

Property	Value
Description	Warehouse where products of this PO will be received to
DisplayName	Receive to Warehouse
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_receivetowarehouse`
RequiredLevel	None
Type	Lookup
Targets	msdyn_warehouse

msdyn_RequestedByResource

Property	Value
Description	Resource that requested the purchase
DisplayName	Requested By Resource
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_requestedbyresource`
RequiredLevel	None
Type	Lookup
Targets	bookableresource

msdyn_ShipTo

Property	Value
Description	Enter the location to ship to. If the PO has been associated to a work order or a schedule, you can ship directly to the service account address.
DisplayName	Ship To
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_shipto`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`msdyn_poshiptotype`

msdyn_ShipTo Choices/Options

Value	Label
690970000	Site
690970001	Business Unit
690970002	Service Account
690970003	Other

msdyn_ShipVia

Property	Value
Description	Method of shipment by vendor
DisplayName	Ship Via
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_shipvia`
RequiredLevel	None
Type	Lookup
Targets	msdyn_shipvia

msdyn_StateOrProvince

Property	Value
Description
DisplayName	State Or Province
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_stateorprovince`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

msdyn_SubStatus

Property	Value
Description	Purchase Order Substatus
DisplayName	Substatus
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_substatus`
RequiredLevel	None
Type	Lookup
Targets	msdyn_purchaseordersubstatus

msdyn_SystemStatus

Property	Value
Description	Enter the current status of the purchase order.
DisplayName	System Status
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_systemstatus`
RequiredLevel	ApplicationRequired
Type	Picklist
DefaultFormValue	690970000
GlobalChoiceName	`msdyn_posystemstatus`

msdyn_SystemStatus Choices/Options

Value	Label
690970000	Draft
690970001	Submitted
690970002	Canceled
690970003	Products Received
690970004	Billed

msdyn_TotalAmount

Property	Value
Description	Total Amount (used by Field Service only)
DisplayName	Total Amount
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_totalamount`
RequiredLevel	None
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	922337203685477
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_Vendor

Property	Value
Description	Vendor you wish to purchase from
DisplayName	Vendor
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_vendor`
RequiredLevel	ApplicationRequired
Type	Lookup
Targets	account

msdyn_VendorNote

Property	Value
Description	If you wish to display a note for the vendor on this PO specify it here
DisplayName	Vendor Note
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_vendornote`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

msdyn_WorkOrder

Property	Value
Description	If purchase order is being ordered directly to a work order specify here. Note, when specified, by default all products will receive directly to work order.
DisplayName	Work Order
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_workorder`
RequiredLevel	None
Type	Lookup
Targets	msdyn_workorder

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

processid

Property	Value
Description	Contains the ID of the process associated with the entity.
DisplayName	Process Id
IsValidForForm	False
IsValidForRead	True
LogicalName	`processid`
RequiredLevel	None
Type	Uniqueidentifier

stageid

Property	Value
Description	Contains the ID of the stage where the entity is located.
DisplayName	Stage Id
IsValidForForm	False
IsValidForRead	True
LogicalName	`stageid`
RequiredLevel	None
Type	Uniqueidentifier

statecode

Property	Value
Description	Status of the Purchase Order
DisplayName	Status
IsValidForForm	True
IsValidForRead	True
LogicalName	`statecode`
RequiredLevel	SystemRequired
Type	State
DefaultFormValue
GlobalChoiceName	`msdyn_purchaseorder_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 Purchase Order
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	`statuscode`
RequiredLevel	None
Type	Status
DefaultFormValue
GlobalChoiceName	`msdyn_purchaseorder_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	ApplicationRequired
Type	Lookup
Targets	transactioncurrency

traversedpath

Property	Value
Description	Shows a comma-separated list of string values that represent the unique identifiers of stages in a business process flow instance in the order that they occur.
DisplayName	Traversed Path
IsValidForForm	False
IsValidForRead	True
LogicalName	`traversedpath`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1250

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_amountbilled_Base
msdyn_totalamount_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_amountbilled_Base

Property	Value
Description	Shows the value of the amount billed in the base currency.
DisplayName	Amount Billed (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_amountbilled_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)

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_account_msdyn_purchaseorder_Vendor
msdyn_bookableresource_msdyn_purchaseorder_RequestedByResource
msdyn_bookableresourcebooking_msdyn_purchaseorder_Booking
msdyn_msdyn_purchaseordersubstatus_msdyn_purchaseorder_SubStatus
msdyn_msdyn_shipvia_msdyn_purchaseorder_ShipVia
msdyn_msdyn_warehouse_msdyn_purchaseorder_ReceivetoWarehouse
msdyn_msdyn_workorder_msdyn_purchaseorder_WorkOrder

msdyn_account_msdyn_purchaseorder_Vendor

One-To-Many Relationship: account msdyn_account_msdyn_purchaseorder_Vendor

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

msdyn_bookableresource_msdyn_purchaseorder_RequestedByResource

One-To-Many Relationship: bookableresource msdyn_bookableresource_msdyn_purchaseorder_RequestedByResource

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

msdyn_bookableresourcebooking_msdyn_purchaseorder_Booking

One-To-Many Relationship: bookableresourcebooking msdyn_bookableresourcebooking_msdyn_purchaseorder_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_msdyn_purchaseordersubstatus_msdyn_purchaseorder_SubStatus

One-To-Many Relationship: msdyn_purchaseordersubstatus msdyn_msdyn_purchaseordersubstatus_msdyn_purchaseorder_SubStatus

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

msdyn_msdyn_shipvia_msdyn_purchaseorder_ShipVia

One-To-Many Relationship: msdyn_shipvia msdyn_msdyn_shipvia_msdyn_purchaseorder_ShipVia

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

msdyn_msdyn_warehouse_msdyn_purchaseorder_ReceivetoWarehouse

One-To-Many Relationship: msdyn_warehouse msdyn_msdyn_warehouse_msdyn_purchaseorder_ReceivetoWarehouse

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

msdyn_msdyn_workorder_msdyn_purchaseorder_WorkOrder

One-To-Many Relationship: msdyn_workorder msdyn_msdyn_workorder_msdyn_purchaseorder_WorkOrder

Property	Value
ReferencedEntity	`msdyn_workorder`
ReferencedAttribute	`msdyn_workorderid`
ReferencingAttribute	`msdyn_workorder`
ReferencingEntityNavigationPropertyName	`msdyn_workorder`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `RemoveLink` 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_purchaseorder_msdyn_purchaseorderbill_PurchaseOrder
msdyn_msdyn_purchaseorder_msdyn_purchaseorderproduct_PurchaseOrder
msdyn_msdyn_purchaseorder_msdyn_purchaseorderreceipt_PurchaseOrder
msdyn_msdyn_purchaseorder_msdyn_purchaseorderreceiptproduct_PurchaseOrder
msdyn_msdyn_purchaseorder_msdyn_rtv_OriginalPO
msdyn_purchaseorder_msdyn_bookingalerts

msdyn_msdyn_purchaseorder_msdyn_purchaseorderbill_PurchaseOrder

Many-To-One Relationship: msdyn_purchaseorderbill msdyn_msdyn_purchaseorder_msdyn_purchaseorderbill_PurchaseOrder

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

msdyn_msdyn_purchaseorder_msdyn_purchaseorderproduct_PurchaseOrder

Many-To-One Relationship: msdyn_purchaseorderproduct msdyn_msdyn_purchaseorder_msdyn_purchaseorderproduct_PurchaseOrder

Property	Value
ReferencingEntity	`msdyn_purchaseorderproduct`
ReferencingAttribute	`msdyn_purchaseorder`
ReferencedEntityNavigationPropertyName	`msdyn_msdyn_purchaseorder_msdyn_purchaseorderproduct_PurchaseOrder`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: Purchase Order MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_msdyn_purchaseorder_msdyn_purchaseorderreceipt_PurchaseOrder

Many-To-One Relationship: msdyn_purchaseorderreceipt msdyn_msdyn_purchaseorder_msdyn_purchaseorderreceipt_PurchaseOrder

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

msdyn_msdyn_purchaseorder_msdyn_purchaseorderreceiptproduct_PurchaseOrder

Many-To-One Relationship: msdyn_purchaseorderreceiptproduct msdyn_msdyn_purchaseorder_msdyn_purchaseorderreceiptproduct_PurchaseOrder

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

msdyn_msdyn_purchaseorder_msdyn_rtv_OriginalPO

Many-To-One Relationship: msdyn_rtv msdyn_msdyn_purchaseorder_msdyn_rtv_OriginalPO

Property	Value
ReferencingEntity	`msdyn_rtv`
ReferencingAttribute	`msdyn_originalpurchaseorder`
ReferencedEntityNavigationPropertyName	`msdyn_msdyn_purchaseorder_msdyn_rtv_OriginalPO`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseLabel` Group: `Details` Label: Original Purchase Order MenuId: null Order: 10000 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

msdyn_purchaseorder_msdyn_bookingalerts

Many-To-One Relationship: msdyn_bookingalert msdyn_purchaseorder_msdyn_bookingalerts

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

Share via