msdyn_actual Entity Reference

Added by: Universal Resource Scheduling Solution

Messages

Message Web API Operation SDK Assembly
Assign PATCH [org URI]/api/data/v9.0/msdyn_actuals(msdyn_actualid)
Update ownerid property.
AssignRequest
Create POST [org URI]/api/data/v9.0/msdyn_actuals
See Create
CreateRequest or
Create
Delete DELETE [org URI]/api/data/v9.0/msdyn_actuals(msdyn_actualid)
See Delete
DeleteRequest or
Delete
GrantAccess GrantAccess Action GrantAccessRequest
IsValidStateTransition IsValidStateTransition Function IsValidStateTransitionRequest
ModifyAccess ModifyAccess Action ModifyAccessRequest
Retrieve GET [org URI]/api/data/v9.0/msdyn_actuals(msdyn_actualid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveMultiple GET [org URI]/api/data/v9.0/msdyn_actuals
See Query Data
RetrieveMultipleRequest or
RetrieveMultiple
RetrievePrincipalAccess RetrievePrincipalAccess Function RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccess Function RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess RevokeAccess Action RevokeAccessRequest
SetState PATCH [org URI]/api/data/v9.0/msdyn_actuals(msdyn_actualid)
Update statecode and statuscode properties.
SetStateRequest
Update PATCH [org URI]/api/data/v9.0/msdyn_actuals(msdyn_actualid)
See Update
UpdateRequest or
Update

Entity Properties

Property Value
CollectionSchemaName msdyn_actuals
DisplayCollectionName Actuals
DisplayName Actual
EntitySetName msdyn_actuals
IsBPFEntity False
LogicalCollectionName msdyn_actuals
LogicalName msdyn_actual
OwnershipType UserOwned
PrimaryIdAttribute msdyn_actualid
PrimaryNameAttribute msdyn_description
SchemaName msdyn_actual

Writable attributes

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

ImportSequenceNumber

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

msdyn_AccountCustomer

Property Value
Description Select the customer.
DisplayName Customer ID
IsValidForForm True
IsValidForRead True
LogicalName msdyn_accountcustomer
RequiredLevel None
Targets account
Type Lookup

msdyn_AccountingDate

Property Value
DateTimeBehavior UserLocal
Description
DisplayName Accounting Date
Format DateOnly
IsValidForForm True
IsValidForRead True
LogicalName msdyn_accountingdate
RequiredLevel None
Type DateTime

msdyn_AccountVendor

Property Value
Description
DisplayName Vendor
IsValidForForm True
IsValidForRead True
LogicalName msdyn_accountvendor
RequiredLevel None
Targets account
Type Lookup

msdyn_actualId

Property Value
Description Unique identifier for entity instances
DisplayName Actual
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName msdyn_actualid
RequiredLevel SystemRequired
Type Uniqueidentifier

msdyn_AdjustmentStatus

Property Value
Description Shows the adjustment status ID of the transaction.
DisplayName Adjustment Status ID
IsValidForForm True
IsValidForRead True
LogicalName msdyn_adjustmentstatus
RequiredLevel None
Type Picklist

msdyn_AdjustmentStatus Options

Value Label
192350000 In Process
192350001 Adjusted
192350002 Unadjustable

msdyn_Agreement

Added by: Field Service Solution

Property Value
Description
DisplayName Agreement
IsValidForForm True
IsValidForRead True
LogicalName msdyn_agreement
RequiredLevel None
Targets msdyn_agreement
Type Lookup

msdyn_Amount

Property Value
Description Enter the amount in transaction currency.
DisplayName Amount
IsValidForForm True
IsValidForRead True
LogicalName msdyn_amount
MaxValue 1000000000
MinValue -1000000000
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

msdyn_AmountMethod

Property Value
Description Select the method by which the amount was computed.
DisplayName Amount Method ID
IsValidForForm True
IsValidForRead True
LogicalName msdyn_amountmethod
RequiredLevel None
Type Picklist

msdyn_AmountMethod Options

Value Label
192350000 Multiply Quantity By Price
192350001 Fixed Price
192350002 Multiply Basis Quantity By Price
192350003 Multiply Basis Amount By Percent
690970000 Tax Calculation

msdyn_BasisAmount

Property Value
Description Enter the cost amount of the sales transaction in the transaction currency.
DisplayName Basis Amount
IsValidForForm True
IsValidForRead True
LogicalName msdyn_basisamount
MaxValue 1000000000
MinValue -1000000000
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

msdyn_BasisPrice

Property Value
Description Enter the cost price of the sales transaction in transaction currency.
DisplayName Basis Price
IsValidForForm True
IsValidForRead True
LogicalName msdyn_basisprice
MaxValue 1000000000
MinValue -1000000000
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

msdyn_BasisQuantity

Property Value
Description Enter the cost quantity of the sales transaction in the base (organization) currency.
DisplayName Basis Quantity
IsValidForForm True
IsValidForRead True
LogicalName msdyn_basisquantity
MaxValue 1000000000
MinValue -1000000000
Precision 2
RequiredLevel None
Type Decimal

msdyn_BillingStatus

Property Value
Description Select the billing status ID.
DisplayName Billing status
IsValidForForm True
IsValidForRead True
LogicalName msdyn_billingstatus
RequiredLevel None
Type Picklist

msdyn_BillingStatus Options

Value Label
192350000 Unbilled Sales Created
192350001 Customer Invoice Created
192350002 Customer Invoice Posted
192350003 Canceled
192350004 Ready to Invoice
690970000 Work order closed - posted

msdyn_BillingType

Property Value
Description Select the billing type ID.
DisplayName Billing type ID
IsValidForForm True
IsValidForRead True
LogicalName msdyn_billingtype
RequiredLevel None
Type Picklist

msdyn_BillingType Options

Value Label
192350000 Non Chargeable
192350001 Chargeable
192350002 Complimentary
192350003 Not Available

msdyn_bookableresource

Property Value
Description Shows the bookable resource for which the actual is recorded.
DisplayName Bookable Resource
IsValidForForm True
IsValidForRead True
LogicalName msdyn_bookableresource
RequiredLevel None
Targets bookableresource
Type Lookup

msdyn_ContactCustomer

Property Value
Description Select the customer contact.
DisplayName Customer contact ID
IsValidForForm True
IsValidForRead True
LogicalName msdyn_contactcustomer
RequiredLevel None
Targets contact
Type Lookup

msdyn_ContactVendor

Property Value
Description
DisplayName Vendor
IsValidForForm True
IsValidForRead True
LogicalName msdyn_contactvendor
RequiredLevel None
Targets contact
Type Lookup

msdyn_contractorganizationalunitid

Added by: Project Service Automation Solution

Property Value
Description Select the organizational unit ID for the contract.
DisplayName Contracting Unit
IsValidForForm True
IsValidForRead True
LogicalName msdyn_contractorganizationalunitid
RequiredLevel None
Targets msdyn_organizationalunit
Type Lookup

msdyn_CustomerType

Property Value
Description Select the customer type ID.
DisplayName Customer type ID
IsValidForForm True
IsValidForRead True
LogicalName msdyn_customertype
RequiredLevel None
Type Picklist

msdyn_CustomerType Options

Value Label
192350001 Account
192350002 Contact

msdyn_description

Property Value
Description Type the record description.
DisplayName Description
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName msdyn_description
MaxLength 200
RequiredLevel None
Type String

msdyn_DocumentDate

Property Value
DateTimeBehavior UserLocal
Description Enter the transaction date of the business event.
DisplayName Document Date
Format DateOnly
IsValidForForm True
IsValidForRead True
LogicalName msdyn_documentdate
RequiredLevel ApplicationRequired
Type DateTime

msdyn_EndDateTime

Property Value
DateTimeBehavior UserLocal
Description Enter the end date and time for this transaction.
DisplayName End Date/Time
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName msdyn_enddatetime
RequiredLevel ApplicationRequired
Type DateTime

msdyn_ExchangeRateDate

Property Value
DateTimeBehavior UserLocal
Description Enter the date of the exchange rate used for this transaction.
DisplayName Exchange Rate Date
Format DateOnly
IsValidForForm True
IsValidForRead True
LogicalName msdyn_exchangeratedate
RequiredLevel None
Type DateTime

msdyn_externaldescription

Property Value
Description The external description of the business transaction.
DisplayName External Description
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName msdyn_externaldescription
MaxLength 200
RequiredLevel None
Type String

msdyn_ExternalReferenceDate

Property Value
DateTimeBehavior UserLocal
Description Stores a date from an external system, such as a journal entry voucher date from an ERP system
DisplayName External Reference Date
Format DateOnly
IsValidForForm True
IsValidForRead True
LogicalName msdyn_externalreferencedate
RequiredLevel None
Type DateTime

msdyn_ExternalReferenceID

Property Value
Description Stores an ID from an external system, such as the journal entry voucher number from an ERP system.
DisplayName External Reference ID
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName msdyn_externalreferenceid
MaxLength 100
RequiredLevel None
Type String

msdyn_IncidentType

Added by: Field Service Solution

Property Value
Description
DisplayName Incident Type
IsValidForForm True
IsValidForRead True
LogicalName msdyn_incidenttype
RequiredLevel None
Targets msdyn_incidenttype
Type Lookup

msdyn_Invoice

Property Value
Description The unique identifier of an invoice.
DisplayName Invoice
IsValidForForm True
IsValidForRead True
LogicalName msdyn_invoice
RequiredLevel None
Targets invoice
Type Lookup

msdyn_IsJournalized

Property Value
Description
DisplayName Is Journalized
IsValidForForm True
IsValidForRead True
LogicalName msdyn_isjournalized
RequiredLevel None
Type Boolean

msdyn_IsJournalized Options

Value Label
1 Yes
0 No

DefaultValue: False

msdyn_JournalType

Added by: Field Service Solution

Property Value
Description Type of journal for resource cost.
DisplayName Journal Type
IsValidForForm True
IsValidForRead True
LogicalName msdyn_journaltype
RequiredLevel None
Type Picklist

msdyn_JournalType Options

Value Label
690970000 Working Hours
690970001 Break
690970002 Travel
690970003 Overtime
690970004 Business Closure

msdyn_Percent

Property Value
Description Enter the percent.
DisplayName Percent
IsValidForForm True
IsValidForRead True
LogicalName msdyn_percent
MaxValue 1000000000
MinValue -1000000000
Precision 2
RequiredLevel None
Type Decimal

msdyn_Price

Property Value
Description Enter the price in the transaction currency.
DisplayName Price
IsValidForForm True
IsValidForRead True
LogicalName msdyn_price
MaxValue 1000000000
MinValue -1000000000
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

msdyn_PriceList

Property Value
Description Select the price list.
DisplayName Price list ID
IsValidForForm True
IsValidForRead True
LogicalName msdyn_pricelist
RequiredLevel None
Targets pricelevel
Type Lookup

msdyn_Product

Property Value
Description Select the product ID.
DisplayName Product ID
IsValidForForm True
IsValidForRead True
LogicalName msdyn_product
RequiredLevel None
Targets product
Type Lookup

msdyn_ProductType

Added by: Field Service Solution

Property Value
Description
DisplayName Product Type
IsValidForForm True
IsValidForRead True
LogicalName msdyn_producttype
RequiredLevel None
Type Picklist

msdyn_ProductType Options

Value Label
690970000 Inventory
690970001 Non-Inventory
690970002 Service

msdyn_Project

Added by: Project Service Automation Solution

Property Value
Description Select the project ID.
DisplayName Project ID
IsValidForForm True
IsValidForRead True
LogicalName msdyn_project
RequiredLevel None
Targets msdyn_project
Type Lookup

msdyn_Quantity

Property Value
Description Enter the quantity.
DisplayName Quantity
IsValidForForm True
IsValidForRead True
LogicalName msdyn_quantity
MaxValue 1000000000
MinValue -1000000000
Precision 2
RequiredLevel None
Type Decimal

msdyn_ResourceCategory

Added by: Project Service Automation Solution

Property Value
Description Select the role ID of the resource performing the work.
DisplayName Resource role ID
IsValidForForm True
IsValidForRead True
LogicalName msdyn_resourcecategory
RequiredLevel None
Targets bookableresourcecategory
Type Lookup

msdyn_ResourceOrganizationalUnitId

Added by: Project Service Automation Solution

Property Value
Description Organizational unit at the time the actual was registered of the resource who performed the work.
DisplayName Resourcing Unit
IsValidForForm True
IsValidForRead True
LogicalName msdyn_resourceorganizationalunitid
RequiredLevel Recommended
Targets msdyn_organizationalunit
Type Lookup

msdyn_SalesContract

Property Value
Description Select the project contract.
DisplayName Project Contract ID
IsValidForForm True
IsValidForRead True
LogicalName msdyn_salescontract
RequiredLevel None
Targets salesorder
Type Lookup

msdyn_SalesContractLine

Property Value
Description (Deprecated) Type the project contract line.
DisplayName (Deprecated) Project Contract Line
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName msdyn_salescontractline
MaxLength 100
RequiredLevel None
Type String

msdyn_SalesContractLineId

Added by: Project Service Automation Solution

Property Value
Description Unique identifier for Project Contract Line associated with Actual.
DisplayName Project Contract Line
IsValidForForm True
IsValidForRead True
LogicalName msdyn_salescontractlineid
RequiredLevel None
Targets salesorderdetail
Type Lookup

msdyn_ServiceAccount

Added by: Field Service Solution

Property Value
Description Account that was serviced
DisplayName Service Account
IsValidForForm True
IsValidForRead True
LogicalName msdyn_serviceaccount
RequiredLevel None
Targets account
Type Lookup

msdyn_ServiceTerritory

Added by: Field Service Solution

Property Value
Description
DisplayName Service Territory
IsValidForForm True
IsValidForRead True
LogicalName msdyn_serviceterritory
RequiredLevel None
Targets territory
Type Lookup

msdyn_StartDateTime

Property Value
DateTimeBehavior UserLocal
Description Enter the start date and time.
DisplayName Start Date/Time
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName msdyn_startdatetime
RequiredLevel ApplicationRequired
Type DateTime

msdyn_Task

Added by: Project Service Automation Solution

Property Value
Description Select the task.
DisplayName Task ID
IsValidForForm True
IsValidForRead True
LogicalName msdyn_task
RequiredLevel None
Targets msdyn_projecttask
Type Lookup

msdyn_TaxCode

Added by: Field Service Solution

Property Value
Description
DisplayName Tax Code
IsValidForForm True
IsValidForRead True
LogicalName msdyn_taxcode
RequiredLevel None
Targets msdyn_taxcode
Type Lookup

msdyn_TransactionCategory

Added by: Project Service Automation Solution

Property Value
Description Select the transaction category.
DisplayName Transaction category ID
IsValidForForm True
IsValidForRead True
LogicalName msdyn_transactioncategory
RequiredLevel None
Targets msdyn_transactioncategory
Type Lookup

msdyn_TransactionClassification

Property Value
Description Shows the transaction classification of this transaction.
DisplayName Transaction Class
IsValidForForm True
IsValidForRead True
LogicalName msdyn_transactionclassification
RequiredLevel ApplicationRequired
Type Picklist

msdyn_TransactionClassification Options

Value Label
192350000 Time
192350001 Expense
192350002 Material
192350003 Milestone
192350004 Fee
690970000 Commission
690970001 Additional
690970002 Tax

msdyn_TransactionTypeCode

Property Value
Description Shows the transaction type of this transaction.
DisplayName Transaction Type
IsValidForForm True
IsValidForRead True
LogicalName msdyn_transactiontypecode
RequiredLevel ApplicationRequired
Type Picklist

msdyn_TransactionTypeCode Options

Value Label
192350000 Cost
192350004 Project Contract
192350005 Unbilled Sales
192350006 Billed Sales
192350007 Resourcing Unit Cost
192350008 Inter-Organizational Sales

msdyn_Unit

Property Value
Description Select the unit of measure.
DisplayName Unit of measure
IsValidForForm True
IsValidForRead True
LogicalName msdyn_unit
RequiredLevel None
Targets uom
Type Lookup

msdyn_UnitSchedule

Property Value
Description Select the unit schedule.
DisplayName Unit Schedule
IsValidForForm True
IsValidForRead True
LogicalName msdyn_unitschedule
RequiredLevel None
Targets uomschedule
Type Lookup

msdyn_VendorType

Property Value
Description
DisplayName Vendor Type
IsValidForForm True
IsValidForRead True
LogicalName msdyn_vendortype
RequiredLevel None
Type Picklist

msdyn_VendorType Options

Value Label
192350001 Account
192350002 Contact

msdyn_Warehouse

Added by: Field Service Solution

Property Value
Description
DisplayName Warehouse
IsValidForForm True
IsValidForRead True
LogicalName msdyn_warehouse
RequiredLevel None
Targets msdyn_warehouse
Type Lookup

msdyn_WorkLocation

Added by: Field Service Solution

Property Value
Description
DisplayName Work Location
IsValidForForm True
IsValidForRead True
LogicalName msdyn_worklocation
RequiredLevel None
Type Picklist

msdyn_WorkLocation Options

Value Label
690970000 Onsite
690970001 Facility
690970002 Location Agnostic

msdyn_WorkOrder

Added by: Field Service Solution

Property Value
Description
DisplayName Work Order
IsValidForForm True
IsValidForRead True
LogicalName msdyn_workorder
RequiredLevel None
Targets msdyn_workorder
Type Lookup

msdyn_WorkOrderType

Added by: Field Service Solution

Property Value
Description
DisplayName Work Order Type
IsValidForForm True
IsValidForRead True
LogicalName msdyn_workordertype
RequiredLevel None
Targets msdyn_workordertype
Type Lookup

OverriddenCreatedOn

Property Value
DateTimeBehavior UserLocal
Description Date and time that the record was migrated.
DisplayName Record Created On
Format DateOnly
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName overriddencreatedon
RequiredLevel None
Type DateTime

OwnerId

Added by: Active Solution Solution

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

OwnerIdType

Added by: Active Solution Solution

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

statecode

Property Value
Description Status of the Actual
DisplayName Status
IsValidForCreate False
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State

statecode Options

Value Label DefaultStatus InvariantName
0 Active 1 Active
1 Inactive 2 Inactive

statuscode

Property Value
Description Reason for the status of the Actual
DisplayName Status Reason
IsValidForForm True
IsValidForRead True
LogicalName statuscode
RequiredLevel None
Type Status

statuscode Options

Value Label State
1 Active 0
2 Inactive 1

TimeZoneRuleVersionNumber

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

TransactionCurrencyId

Added by: Active Solution Solution

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

UTCConversionTimeZoneCode

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

Read-only attributes

These attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.

CreatedBy

Added by: Active Solution Solution

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

CreatedByName

Added by: Active Solution Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyname
MaxLength 100
RequiredLevel None
Type String

CreatedByYomiName

Added by: Active Solution Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

CreatedOn

Property Value
DateTimeBehavior UserLocal
Description Date and time when the record was created.
DisplayName Created On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime

CreatedOnBehalfBy

Added by: Active Solution Solution

Property Value
Description Unique identifier of the delegate user who created the record.
DisplayName Created By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedOnBehalfByName

Added by: Active Solution Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

CreatedOnBehalfByYomiName

Added by: Active Solution Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

ExchangeRate

Added by: Active Solution Solution

Property Value
Description Exchange rate for the currency associated with the entity with respect to the base currency.
DisplayName Exchange Rate
IsValidForForm True
IsValidForRead True
LogicalName exchangerate
MaxValue 100000000000
MinValue 0.0000000001
Precision 10
RequiredLevel None
Type Decimal

ModifiedBy

Added by: Active Solution Solution

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

ModifiedByName

Added by: Active Solution Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedByYomiName

Added by: Active Solution Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

ModifiedOn

Property Value
DateTimeBehavior UserLocal
Description Date and time when the record was modified.
DisplayName Modified On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime

ModifiedOnBehalfBy

Added by: Active Solution Solution

Property Value
Description Unique identifier of the delegate user who modified the record.
DisplayName Modified By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedOnBehalfByName

Added by: Active Solution Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedOnBehalfByYomiName

Added by: Active Solution Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

msdyn_AccountCustomerName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_accountcustomername
MaxLength 160
RequiredLevel None
Type String

msdyn_AccountCustomerYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_accountcustomeryominame
MaxLength 160
RequiredLevel None
Type String

msdyn_AccountVendorName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_accountvendorname
MaxLength 160
RequiredLevel None
Type String

msdyn_AccountVendorYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_accountvendoryominame
MaxLength 160
RequiredLevel None
Type String

msdyn_AgreementName

Added by: Field Service Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_agreementname
MaxLength 100
RequiredLevel None
Type String

msdyn_amount_Base

Property Value
Description Enter the value of the amount in the base (organization) currency.
DisplayName Amount (Base currency)
IsValidForForm True
IsValidForRead True
LogicalName msdyn_amount_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

msdyn_basisamount_Base

Property Value
Description Enter the cost amount of the sales transaction in the base (organization) currency.
DisplayName Basis Amount (Base currency)
IsValidForForm True
IsValidForRead True
LogicalName msdyn_basisamount_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

msdyn_basisprice_Base

Property Value
Description Enter the cost price of the sales transaction in base (organization) currency.
DisplayName Basis Price (Base currency)
IsValidForForm True
IsValidForRead True
LogicalName msdyn_basisprice_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

msdyn_bookableresourceName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_bookableresourcename
MaxLength 100
RequiredLevel None
Type String

msdyn_ContactCustomerName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_contactcustomername
MaxLength 160
RequiredLevel None
Type String

msdyn_ContactCustomerYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_contactcustomeryominame
MaxLength 450
RequiredLevel None
Type String

msdyn_ContactVendorName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_contactvendorname
MaxLength 160
RequiredLevel None
Type String

msdyn_ContactVendorYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_contactvendoryominame
MaxLength 450
RequiredLevel None
Type String

msdyn_contractorganizationalunitidName

Added by: Project Service Automation Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_contractorganizationalunitidname
MaxLength 100
RequiredLevel None
Type String

msdyn_IncidentTypeName

Added by: Field Service Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_incidenttypename
MaxLength 100
RequiredLevel None
Type String

msdyn_InvoiceName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_invoicename
MaxLength 300
RequiredLevel None
Type String

msdyn_price_Base

Property Value
Description Enter the price in the base (organization) currency.
DisplayName Price (Base)
IsValidForForm True
IsValidForRead True
LogicalName msdyn_price_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

msdyn_PriceListName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_pricelistname
MaxLength 100
RequiredLevel None
Type String

msdyn_ProductName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_productname
MaxLength 100
RequiredLevel None
Type String

msdyn_ProjectName

Added by: Project Service Automation Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_projectname
MaxLength 200
RequiredLevel None
Type String

msdyn_ResourceCategoryName

Added by: Project Service Automation Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_resourcecategoryname
MaxLength 100
RequiredLevel None
Type String

msdyn_ResourceOrganizationalUnitIdName

Added by: Project Service Automation Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_resourceorganizationalunitidname
MaxLength 100
RequiredLevel None
Type String

msdyn_SalesContractLineIdName

Added by: Project Service Automation Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_salescontractlineidname
MaxLength 100
RequiredLevel None
Type String

msdyn_SalesContractName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_salescontractname
MaxLength 300
RequiredLevel None
Type String

msdyn_ServiceAccountName

Added by: Field Service Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_serviceaccountname
MaxLength 160
RequiredLevel None
Type String

msdyn_ServiceAccountYomiName

Added by: Field Service Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_serviceaccountyominame
MaxLength 160
RequiredLevel None
Type String

msdyn_ServiceTerritoryName

Added by: Field Service Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_serviceterritoryname
MaxLength 200
RequiredLevel None
Type String

msdyn_TaskName

Added by: Project Service Automation Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_taskname
MaxLength 450
RequiredLevel None
Type String

msdyn_TaxCodeName

Added by: Field Service Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_taxcodename
MaxLength 100
RequiredLevel None
Type String

msdyn_TransactionCategoryName

Added by: Project Service Automation Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_transactioncategoryname
MaxLength 100
RequiredLevel None
Type String

msdyn_UnitName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_unitname
MaxLength 100
RequiredLevel None
Type String

msdyn_UnitScheduleName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_unitschedulename
MaxLength 200
RequiredLevel None
Type String

msdyn_WarehouseName

Added by: Field Service Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_warehousename
MaxLength 100
RequiredLevel None
Type String

msdyn_WorkOrderName

Added by: Field Service Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_workordername
MaxLength 100
RequiredLevel None
Type String

msdyn_WorkOrderTypeName

Added by: Field Service Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_workordertypename
MaxLength 100
RequiredLevel None
Type String

OwnerIdName

Added by: Active Solution Solution

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

OwnerIdYomiName

Added by: Active Solution Solution

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

OwningBusinessUnit

Added by: Active Solution Solution

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

OwningTeam

Added by: Active Solution Solution

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

OwningUser

Added by: Active Solution Solution

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

TransactionCurrencyIdName

Added by: Active Solution Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName transactioncurrencyidname
MaxLength 100
RequiredLevel None
Type String

VersionNumber

Added by: Active Solution Solution

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

One-To-Many Relationships

Listed by SchemaName.

msdyn_actual_SyncErrors

Added by: System Solution Solution

Same as syncerror entity msdyn_actual_SyncErrors Many-To-One relationship.

Property Value
ReferencingEntity syncerror
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName msdyn_actual_SyncErrors
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

msdyn_actual_DuplicateMatchingRecord

Added by: System Solution Solution

Same as duplicaterecord entity msdyn_actual_DuplicateMatchingRecord Many-To-One relationship.

Property Value
ReferencingEntity duplicaterecord
ReferencingAttribute duplicaterecordid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName msdyn_actual_DuplicateMatchingRecord
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

msdyn_actual_DuplicateBaseRecord

Added by: System Solution Solution

Same as duplicaterecord entity msdyn_actual_DuplicateBaseRecord Many-To-One relationship.

Property Value
ReferencingEntity duplicaterecord
ReferencingAttribute baserecordid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName msdyn_actual_DuplicateBaseRecord
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

msdyn_actual_AsyncOperations

Added by: System Solution Solution

Same as asyncoperation entity msdyn_actual_AsyncOperations Many-To-One relationship.

Property Value
ReferencingEntity asyncoperation
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName msdyn_actual_AsyncOperations
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

msdyn_actual_MailboxTrackingFolders

Added by: System Solution Solution

Same as mailboxtrackingfolder entity msdyn_actual_MailboxTrackingFolders Many-To-One relationship.

Property Value
ReferencingEntity mailboxtrackingfolder
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName msdyn_actual_MailboxTrackingFolders
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

msdyn_actual_ProcessSession

Added by: System Solution Solution

Same as processsession entity msdyn_actual_ProcessSession Many-To-One relationship.

Property Value
ReferencingEntity processsession
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName msdyn_actual_ProcessSession
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

msdyn_actual_BulkDeleteFailures

Added by: System Solution Solution

Same as bulkdeletefailure entity msdyn_actual_BulkDeleteFailures Many-To-One relationship.

Property Value
ReferencingEntity bulkdeletefailure
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName msdyn_actual_BulkDeleteFailures
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

msdyn_actual_PrincipalObjectAttributeAccesses

Added by: System Solution Solution

Same as principalobjectattributeaccess entity msdyn_actual_PrincipalObjectAttributeAccesses Many-To-One relationship.

Property Value
ReferencingEntity principalobjectattributeaccess
ReferencingAttribute objectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName msdyn_actual_PrincipalObjectAttributeAccesses
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

msdyn_actual_Annotations

Added by: System Solution Solution

Same as annotation entity msdyn_actual_Annotations Many-To-One relationship.

Property Value
ReferencingEntity annotation
ReferencingAttribute objectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName msdyn_actual_Annotations
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: NoCascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

Many-To-One Relationships

Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related entity. Listed by SchemaName.

lk_msdyn_actual_createdby

Added by: System Solution Solution

See systemuser Entity lk_msdyn_actual_createdby One-To-Many relationship.

lk_msdyn_actual_createdonbehalfby

Added by: System Solution Solution

See systemuser Entity lk_msdyn_actual_createdonbehalfby One-To-Many relationship.

lk_msdyn_actual_modifiedby

Added by: System Solution Solution

See systemuser Entity lk_msdyn_actual_modifiedby One-To-Many relationship.

lk_msdyn_actual_modifiedonbehalfby

Added by: System Solution Solution

See systemuser Entity lk_msdyn_actual_modifiedonbehalfby One-To-Many relationship.

user_msdyn_actual

Added by: System Solution Solution

See systemuser Entity user_msdyn_actual One-To-Many relationship.

team_msdyn_actual

Added by: System Solution Solution

See team Entity team_msdyn_actual One-To-Many relationship.

business_unit_msdyn_actual

Added by: System Solution Solution

See businessunit Entity business_unit_msdyn_actual One-To-Many relationship.

TransactionCurrency_msdyn_actual

Added by: System Solution Solution

See transactioncurrency Entity TransactionCurrency_msdyn_actual One-To-Many relationship.

msdyn_account_msdyn_actual_AccountCustomer

Added by: System Solution Solution

See account Entity msdyn_account_msdyn_actual_AccountCustomer One-To-Many relationship.

msdyn_account_msdyn_actual_AccountVendor

Added by: System Solution Solution

See account Entity msdyn_account_msdyn_actual_AccountVendor One-To-Many relationship.

msdyn_bookableresource_msdyn_actual_bookableresource

Added by: Scheduling Solution

See bookableresource Entity msdyn_bookableresource_msdyn_actual_bookableresource One-To-Many relationship.

msdyn_contact_msdyn_actual_ContactCustomer

Added by: System Solution Solution

See contact Entity msdyn_contact_msdyn_actual_ContactCustomer One-To-Many relationship.

msdyn_contact_msdyn_actual_ContactVendor

Added by: System Solution Solution

See contact Entity msdyn_contact_msdyn_actual_ContactVendor One-To-Many relationship.

msdyn_invoice_msdyn_actual_Invoice

Added by: Sales Solution

See invoice Entity msdyn_invoice_msdyn_actual_Invoice One-To-Many relationship.

msdyn_pricelevel_msdyn_actual_PriceList

Added by: Product Management Solution

See pricelevel Entity msdyn_pricelevel_msdyn_actual_PriceList One-To-Many relationship.

msdyn_product_msdyn_actual_Product

Added by: Product Management Solution

See product Entity msdyn_product_msdyn_actual_Product One-To-Many relationship.

msdyn_salesorder_msdyn_actual_SalesContract

Added by: Sales Solution

See salesorder Entity msdyn_salesorder_msdyn_actual_SalesContract One-To-Many relationship.

msdyn_uom_msdyn_actual_Unit

Added by: Product Management Solution

See uom Entity msdyn_uom_msdyn_actual_Unit One-To-Many relationship.

msdyn_uomschedule_msdyn_actual_UnitSchedule

Added by: Product Management Solution

See uomschedule Entity msdyn_uomschedule_msdyn_actual_UnitSchedule One-To-Many relationship.

msdyn_bookableresourcecategory_msdyn_actual_ResourceCategory

Added by: Scheduling Solution

See bookableresourcecategory Entity msdyn_bookableresourcecategory_msdyn_actual_ResourceCategory One-To-Many relationship.

msdyn_msdyn_organizationalunit_msdyn_actual_ContractOrganizationalUnitId

See msdyn_organizationalunit Entity msdyn_msdyn_organizationalunit_msdyn_actual_ContractOrganizationalUnitId One-To-Many relationship.

msdyn_msdyn_project_msdyn_actual_Project

Added by: Project Service Automation Solution

See msdyn_project Entity msdyn_msdyn_project_msdyn_actual_Project One-To-Many relationship.

msdyn_msdyn_projecttask_msdyn_actual_Task

Added by: Project Service Automation Solution

See msdyn_projecttask Entity msdyn_msdyn_projecttask_msdyn_actual_Task One-To-Many relationship.

msdyn_msdyn_transactioncategory_msdyn_actual_TransactionCategory

Added by: Project Service Automation Solution

See msdyn_transactioncategory Entity msdyn_msdyn_transactioncategory_msdyn_actual_TransactionCategory One-To-Many relationship.

msdyn_organizationalunit_actual

See msdyn_organizationalunit Entity msdyn_organizationalunit_actual One-To-Many relationship.

msdyn_salesorderdetail_msdyn_actual

Added by: Sales Solution

See salesorderdetail Entity msdyn_salesorderdetail_msdyn_actual One-To-Many relationship.

msdyn_account_msdyn_actual_ServiceAccount

Added by: System Solution Solution

See account Entity msdyn_account_msdyn_actual_ServiceAccount One-To-Many relationship.

msdyn_msdyn_agreement_msdyn_actual_Agreement

Added by: Field Service Solution

See msdyn_agreement Entity msdyn_msdyn_agreement_msdyn_actual_Agreement One-To-Many relationship.

msdyn_msdyn_incidenttype_msdyn_actual_IncidentType

Added by: Field Service Solution

See msdyn_incidenttype Entity msdyn_msdyn_incidenttype_msdyn_actual_IncidentType One-To-Many relationship.

msdyn_msdyn_taxcode_msdyn_actual_TaxCode

Added by: Field Service Solution

See msdyn_taxcode Entity msdyn_msdyn_taxcode_msdyn_actual_TaxCode One-To-Many relationship.

msdyn_msdyn_warehouse_msdyn_actual_Warehouse

Added by: Field Service Solution

See msdyn_warehouse Entity msdyn_msdyn_warehouse_msdyn_actual_Warehouse One-To-Many relationship.

msdyn_msdyn_workorder_msdyn_actual_WorkOrder

Added by: Field Service Solution

See msdyn_workorder Entity msdyn_msdyn_workorder_msdyn_actual_WorkOrder One-To-Many relationship.

msdyn_msdyn_workordertype_msdyn_actual_WorkOrderType

Added by: Field Service Solution

See msdyn_workordertype Entity msdyn_msdyn_workordertype_msdyn_actual_WorkOrderType One-To-Many relationship.

msdyn_territory_msdyn_actual_ServiceTerritory

Added by: Application Common Solution

See territory Entity msdyn_territory_msdyn_actual_ServiceTerritory One-To-Many relationship.

See also

About the Entity Reference
Programming reference for Dynamics 365 Customer Engagement
Web API Reference
msdyn_actual EntityType