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

Record all services proposed and performed for work order

Messages

The following table lists the messages for the Work Order Service (msdyn_workorderservice) 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_workorderservices(msdyn_workorderserviceid) 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_workorderservices See Create	Create records
CreateMultiple Event: True	CreateMultiple	CreateMultipleRequest
Delete Event: True	DELETE /msdyn_workorderservices(msdyn_workorderserviceid) 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_workorderservices(msdyn_workorderserviceid) See Retrieve	Retrieve records
RetrieveMultiple Event: True	GET /msdyn_workorderservices 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_workorderservices(msdyn_workorderserviceid) Update the statecode and statuscode properties.	SetStateRequest
Update Event: True	PATCH /msdyn_workorderservices(msdyn_workorderserviceid) See Update	Update records
UpdateMultiple Event: True	UpdateMultiple	UpdateMultipleRequest
Upsert Event: False	PATCH /msdyn_workorderservices(msdyn_workorderserviceid) 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 Service (msdyn_workorderservice) table.

Property	Value
DisplayName	Work Order Service
DisplayCollectionName	Work Order Services
SchemaName	msdyn_workorderservice
CollectionSchemaName	msdyn_workorderservices
EntitySetName	msdyn_workorderservices
LogicalName	msdyn_workorderservice
LogicalCollectionName	msdyn_workorderservices
PrimaryIdAttribute	msdyn_workorderserviceid
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_AgreementBookingService
• msdyn_Booking
• msdyn_CalculatedUnitAmount
• msdyn_CommissionCosts
• msdyn_CustomerAsset
• msdyn_Description
• msdyn_DisableEntitlement
• msdyn_DiscountAmount
• msdyn_DiscountPercent
• msdyn_Duration
• msdyn_DurationToBill
• msdyn_Entitlement
• msdyn_EstimateCalculatedUnitAmount
• msdyn_EstimateDiscountAmount
• msdyn_EstimateDiscountPercent
• msdyn_EstimateDuration
• msdyn_EstimateSubtotal
• msdyn_EstimateTotalAmount
• msdyn_EstimateTotalCost
• msdyn_EstimateUnitAmount
• msdyn_EstimateUnitCost
• msdyn_InternalDescription
• msdyn_InternalFlags
• msdyn_LineOrder
• msdyn_LineStatus
• msdyn_MinimumChargeAmount
• msdyn_MinimumChargeDuration
• msdyn_name
• msdyn_PriceList
• msdyn_Service
• msdyn_Subtotal
• msdyn_Taxable
• msdyn_TotalAmount
• msdyn_TotalCost
• msdyn_Unit
• msdyn_UnitAmount
• msdyn_UnitCost
• msdyn_WorkOrder
• msdyn_WorkOrderIncident
• msdyn_workorderserviceId
• 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 service. 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_AgreementBookingService

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

msdyn_Booking

Property	Value
Description	Shows the resource booking detail where this product was added.
DisplayName	Booking
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_booking
RequiredLevel	None
Type	Lookup
Targets	bookableresourcebooking

msdyn_CalculatedUnitAmount

Property	Value
Description	Shows the sale amount per unit calculated by the system considering the minimum charge, if applicable.
DisplayName	Calculated Unit Amount
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_calculatedunitamount
RequiredLevel	None
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_CommissionCosts

Property	Value
Description	Enter the commission costs associated with this service. 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 Service.
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 service as presented to the customer. The value defaults to the description defined on the service.
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 service.
DisplayName	Disable Entitlement
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_disableentitlement
RequiredLevel	None
Type	Boolean
GlobalChoiceName	msdyn_msdyn_workorderservice_msdyn_disableentitlement
DefaultValue	False
True Label	Yes
False Label	No

msdyn_DiscountAmount

Property	Value
Description	Specify any discount amount on this service. 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 service. 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	1000000000
MinValue	0
Precision	2

msdyn_Duration

Property	Value
Description	Shows the actual duration of service.
DisplayName	Duration
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_duration
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

msdyn_DurationToBill

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	Duration To Bill
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_durationtobill
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

msdyn_Entitlement

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

msdyn_EstimateCalculatedUnitAmount

Property	Value
Description	Shows the estimated sale amount per unit calculated by the system considering the initial charge (if applicable).
DisplayName	Estimate Calculated Unit Amount
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_estimatecalculatedunitamount
RequiredLevel	None
Type	Money
ImeMode	Auto
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

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	1000000000
MinValue	0
Precision	2

msdyn_EstimateDuration

Property	Value
Description	Enter the estimated duration of this service.
DisplayName	Estimate Duration
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_estimateduration
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

msdyn_EstimateSubtotal

Property	Value
Description	Shows the total amount for this service, 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 service, 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 service.
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 service.
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
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_MinimumChargeAmount

Property	Value
Description	Enter the amount charged as a minimum charge.
DisplayName	Minimum Charge Amount
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_minimumchargeamount
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	1000000000
MinValue	0
Precision	2
PrecisionSource	1 (Organization.PricingDecimalPrecision)

msdyn_MinimumChargeDuration

Property	Value
Description	Enter the duration of up to how long the minimum charge applies.
DisplayName	Minimum Charge Duration
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_minimumchargeduration
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

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 service
DisplayName	Price List
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_pricelist
RequiredLevel	ApplicationRequired
Type	Lookup
Targets	pricelevel

msdyn_Service

Property	Value
Description	Service proposed or used for this work order
DisplayName	Service
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_service
RequiredLevel	ApplicationRequired
Type	Lookup
Targets	product

msdyn_Subtotal

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

msdyn_Taxable

Property	Value
Description	Specify if service 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_workorderservice_msdyn_taxable
DefaultValue	False
True Label	Yes
False Label	No

msdyn_TotalAmount

Property	Value
Description
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 service. 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 final quantity for this service
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	None
Type	Money
ImeMode	Disabled
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_WorkOrder

Property	Value
Description	The work order this service relates to
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_workorderserviceId

Property	Value
Description	Shows the entity instances.
DisplayName	Work Order Service
IsValidForForm	False
IsValidForRead	True
LogicalName	msdyn_workorderserviceid
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 Service
DisplayName	Status
IsValidForForm	True
IsValidForRead	True
LogicalName	statecode
RequiredLevel	SystemRequired
Type	State
DefaultFormValue
GlobalChoiceName	msdyn_workorderservice_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 Service
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	statuscode
RequiredLevel	None
Type	Status
DefaultFormValue
GlobalChoiceName	msdyn_workorderservice_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_calculatedunitamount_Base
• msdyn_commissioncosts_Base
• msdyn_discountamount_Base
• msdyn_estimatecalculatedunitamount_Base
• msdyn_estimatediscountamount_Base
• msdyn_estimatesubtotal_Base
• msdyn_estimatetotalamount_Base
• msdyn_estimatetotalcost_Base
• msdyn_estimateunitamount_Base
• msdyn_estimateunitcost_Base
• msdyn_minimumchargeamount_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_calculatedunitamount_Base

Property	Value
Description	Shows the value of the calculated unit amount in the base currency.
DisplayName	Calculated Unit Amount (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_calculatedunitamount_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_estimatecalculatedunitamount_Base

Property	Value
Description	Shows the value of the estimate calculated unit amount in the base currency.
DisplayName	Estimate Calculated Unit Amount (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_estimatecalculatedunitamount_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_minimumchargeamount_Base

Property	Value
Description	Shows the value of the minimum charge amount in the base currency.
DisplayName	Minimum Charge Amount (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	msdyn_minimumchargeamount_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_workorderservice_Booking
• msdyn_entitlement_msdyn_workorderservice_entitlement
• msdyn_msdyn_agreementbookingservice_msdyn_workorderservice_AgreementBookingService
• msdyn_msdyn_customerasset_msdyn_workorderservice_CustomerAsset
• msdyn_msdyn_workorder_msdyn_workorderservice_WorkOrder
• msdyn_msdyn_workorderincident_msdyn_workorderservice_WorkOrderIncident
• msdyn_product_msdyn_workorderservice_Service

msdyn_bookableresourcebooking_msdyn_workorderservice_Booking

One-To-Many Relationship: bookableresourcebooking msdyn_bookableresourcebooking_msdyn_workorderservice_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_workorderservice_entitlement

One-To-Many Relationship: entitlement msdyn_entitlement_msdyn_workorderservice_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_agreementbookingservice_msdyn_workorderservice_AgreementBookingService

One-To-Many Relationship: msdyn_agreementbookingservice msdyn_msdyn_agreementbookingservice_msdyn_workorderservice_AgreementBookingService

Property	Value
ReferencedEntity	msdyn_agreementbookingservice
ReferencedAttribute	msdyn_agreementbookingserviceid
ReferencingAttribute	msdyn_agreementbookingservice
ReferencingEntityNavigationPropertyName	msdyn_agreementbookingservice
IsHierarchical
CascadeConfiguration	Archive: NoCascade Assign: NoCascade Delete: RemoveLink Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade

msdyn_msdyn_customerasset_msdyn_workorderservice_CustomerAsset

One-To-Many Relationship: msdyn_customerasset msdyn_msdyn_customerasset_msdyn_workorderservice_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_workorder_msdyn_workorderservice_WorkOrder

One-To-Many Relationship: msdyn_workorder msdyn_msdyn_workorder_msdyn_workorderservice_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_workorderservice_WorkOrderIncident

One-To-Many Relationship: msdyn_workorderincident msdyn_msdyn_workorderincident_msdyn_workorderservice_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_workorderservice_Service

One-To-Many Relationship: product msdyn_product_msdyn_workorderservice_Service

Property	Value
ReferencedEntity	product
ReferencedAttribute	productid
ReferencingAttribute	msdyn_service
ReferencingEntityNavigationPropertyName	msdyn_service
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_workorderservice_msdyn_bookingalerts

Many-To-One Relationship: msdyn_bookingalert msdyn_workorderservice_msdyn_bookingalerts

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

See also

Dataverse table/entity reference
Dataverse Web API Reference