msdyn_actual EntityType

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


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

Name Type Details
createdon Edm.DateTimeOffset

Date and time when the record was created.

Display Name: Created On

Read Only
exchangerate Edm.Decimal

Exchange rate for the currency associated with the entity with respect to the base currency.

Display Name: Exchange Rate

Read Only
importsequencenumber Edm.Int32

Sequence number of the import that created this record.

Display Name: Import Sequence Number

modifiedon Edm.DateTimeOffset

Date and time when the record was modified.

Display Name: Modified On

Read Only
msdyn_accountingdate Edm.DateTimeOffset

Display Name: Accounting Date

msdyn_actualid Edm.Guid

Unique identifier for entity instances

Display Name: Actual

msdyn_adjustmentstatus Edm.Int32

Shows the adjustment status ID of the transaction.

Display Name: Adjustment Status ID

Default Options
Value Label
192350000 In Process
192350001 Adjusted
192350002 Unadjustable
msdyn_amount Edm.Decimal

Enter the amount in transaction currency.

Display Name: Amount

msdyn_amount_base Edm.Decimal

Enter the value of the amount in the base (organization) currency.

Display Name: Amount (Base currency)

Read Only
msdyn_amountmethod Edm.Int32

Select the method by which the amount was computed.

Display Name: Amount Method ID

Default Options
Value Label
690970000 Tax Calculation
192350000 Multiply Quantity By Price
192350001 Fixed Price
192350002 Multiply Basis Quantity By Price
192350003 Multiply Basis Amount By Percent
msdyn_basisamount Edm.Decimal

Enter the cost amount of the sales transaction in the transaction currency.

Display Name: Basis Amount

msdyn_basisamount_base Edm.Decimal

Enter the cost amount of the sales transaction in the base (organization) currency.

Display Name: Basis Amount (Base currency)

Read Only
msdyn_basisprice Edm.Decimal

Enter the cost price of the sales transaction in transaction currency.

Display Name: Basis Price

msdyn_basisprice_base Edm.Decimal

Enter the cost price of the sales transaction in base (organization) currency.

Display Name: Basis Price (Base currency)

Read Only
msdyn_basisquantity Edm.Decimal

Enter the cost quantity of the sales transaction in the base (organization) currency.

Display Name: Basis Quantity

msdyn_billingstatus Edm.Int32

Select the billing status ID.

Display Name: Billing status

Default Options
Value Label
690970000 Work order closed - posted
192350004 Ready to Invoice
192350000 Unbilled Sales Created
192350001 Customer Invoice Created
192350002 Customer Invoice Posted
192350003 Canceled
msdyn_billingtype Edm.Int32

Select the billing type ID.

Display Name: Billing type ID

Default Options
Value Label
192350000 Non Chargeable
192350001 Chargeable
192350002 Complimentary
192350003 Not Available
msdyn_customertype Edm.Int32

Select the customer type ID.

Display Name: Customer type ID

Default Options
Value Label
192350001 Account
192350002 Contact
msdyn_description Edm.String

Type the record description.

Display Name: Description

msdyn_documentdate Edm.DateTimeOffset

Enter the transaction date of the business event.

Display Name: Document Date

msdyn_enddatetime Edm.DateTimeOffset

Enter the end date and time for this transaction.

Display Name: End Date/Time

msdyn_exchangeratedate Edm.DateTimeOffset

Enter the date of the exchange rate used for this transaction.

Display Name: Exchange Rate Date

msdyn_externaldescription Edm.String

The external description of the business transaction.

Display Name: External Description

msdyn_externalreferencedate Edm.DateTimeOffset

Stores a date from an external system, such as a journal entry voucher date from an ERP system

Display Name: External Reference Date

msdyn_externalreferenceid Edm.String

Stores an ID from an external system, such as the journal entry voucher number from an ERP system.

Display Name: External Reference ID

msdyn_isjournalized Edm.Boolean

Display Name: Is Journalized

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

Type of journal for resource cost.

Display Name: Journal Type

Default Options
Value Label
690970000 Working Hours
690970001 Break
690970002 Travel
690970003 Overtime
690970004 Business Closure
msdyn_percent Edm.Decimal

Enter the percent.

Display Name: Percent

msdyn_price Edm.Decimal

Enter the price in the transaction currency.

Display Name: Price

msdyn_price_base Edm.Decimal

Enter the price in the base (organization) currency.

Display Name: Price (Base)

Read Only
msdyn_producttype Edm.Int32

Display Name: Product Type

Default Options
Value Label
690970000 Inventory
690970001 Non-Inventory
690970002 Service
msdyn_quantity Edm.Decimal

Enter the quantity.

Display Name: Quantity

msdyn_salescontractline Edm.String

(Deprecated) Type the project contract line.

Display Name: (Deprecated) Project Contract Line

msdyn_startdatetime Edm.DateTimeOffset

Enter the start date and time.

Display Name: Start Date/Time

msdyn_transactionclassification Edm.Int32

Shows the transaction classification of this transaction.

Display Name: Transaction Class

Default Options
Value Label
690970000 Commission
690970001 Additional
192350000 Time
192350001 Expense
192350002 Material
192350003 Milestone
192350004 Fee
690970002 Tax
msdyn_transactiontypecode Edm.Int32

Shows the transaction type of this transaction.

Display Name: Transaction Type

Default Options
Value Label
192350000 Cost
192350004 Project Contract
192350005 Unbilled Sales
192350006 Billed Sales
192350007 Resourcing Unit Cost
192350008 Inter-Organizational Sales
msdyn_vendortype Edm.Int32

Display Name: Vendor Type

Default Options
Value Label
192350001 Account
192350002 Contact
msdyn_worklocation Edm.Int32

Display Name: Work Location

Default Options
Value Label
690970000 Onsite
690970001 Facility
690970002 Location Agnostic
overriddencreatedon Edm.DateTimeOffset

Date and time that the record was migrated.

Display Name: Record Created On

statecode Edm.Int32

Status of the Actual

Display Name: Status

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

Reason for the status of the Actual

Display Name: Status Reason

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

For internal use only.

Display Name: Time Zone Rule Version Number

utcconversiontimezonecode Edm.Int32

Time zone code that was in use when the record was created.

Display Name: UTC Conversion Time Zone Code

versionnumber Edm.Int64

Version Number

Display Name: Version Number

Read Only

Lookup Properties

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

Name Single-valued navigation property Description
_createdby_value createdby

Unique identifier of the user who created the record.

_createdonbehalfby_value createdonbehalfby

Unique identifier of the delegate user who created the record.

_modifiedby_value modifiedby

Unique identifier of the user who modified the record.

_modifiedonbehalfby_value modifiedonbehalfby

Unique identifier of the delegate user who modified the record.

_msdyn_accountcustomer_value msdyn_AccountCustomer

Select the customer.

_msdyn_accountvendor_value msdyn_AccountVendor
_msdyn_agreement_value msdyn_Agreement
_msdyn_bookableresource_value msdyn_bookableresource

Shows the bookable resource for which the actual is recorded.

_msdyn_contactcustomer_value msdyn_ContactCustomer

Select the customer contact.

_msdyn_contactvendor_value msdyn_ContactVendor
_msdyn_contractorganizationalunitid_value msdyn_contractorganizationalunitid

Select the organizational unit ID for the contract.

_msdyn_incidenttype_value msdyn_IncidentType
_msdyn_invoice_value msdyn_Invoice

The unique identifier of an invoice.

_msdyn_pricelist_value msdyn_PriceList

Select the price list.

_msdyn_product_value msdyn_Product

Select the product ID.

_msdyn_project_value msdyn_Project

Select the project ID.

_msdyn_resourcecategory_value msdyn_ResourceCategory

Select the role ID of the resource performing the work.

_msdyn_resourceorganizationalunitid_value msdyn_ResourceOrganizationalUnitId

Organizational unit at the time the actual was registered of the resource who performed the work.

_msdyn_salescontract_value msdyn_SalesContract

Select the project contract.

_msdyn_salescontractlineid_value msdyn_SalesContractLineId

Unique identifier for Project Contract Line associated with Actual.

_msdyn_serviceaccount_value msdyn_ServiceAccount

Account that was serviced

_msdyn_serviceterritory_value msdyn_ServiceTerritory
_msdyn_task_value msdyn_Task

Select the task.

_msdyn_taxcode_value msdyn_TaxCode
_msdyn_transactioncategory_value msdyn_TransactionCategory

Select the transaction category.

_msdyn_unit_value msdyn_Unit

Select the unit of measure.

_msdyn_unitschedule_value msdyn_UnitSchedule

Select the unit schedule.

_msdyn_warehouse_value msdyn_Warehouse
_msdyn_workorder_value msdyn_WorkOrder
_msdyn_workordertype_value msdyn_WorkOrderType
_ownerid_value ownerid

Owner Id

_owningbusinessunit_value owningbusinessunit

Unique identifier for the business unit that owns the record

_owningteam_value owningteam

Unique identifier for the team that owns the record.

_owninguser_value owninguser

Unique identifier for the user that owns the record.

_transactioncurrencyid_value transactioncurrencyid

Shows the currency associated with the entity.

Single-valued navigation properties

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

Name Type Partner
createdby systemuser lk_msdyn_actual_createdby
createdonbehalfby systemuser lk_msdyn_actual_createdonbehalfby
modifiedby systemuser lk_msdyn_actual_modifiedby
modifiedonbehalfby systemuser lk_msdyn_actual_modifiedonbehalfby
msdyn_AccountCustomer account msdyn_account_msdyn_actual_AccountCustomer
msdyn_AccountVendor account msdyn_account_msdyn_actual_AccountVendor
msdyn_Agreement msdyn_agreement msdyn_msdyn_agreement_msdyn_actual_Agreement
msdyn_bookableresource bookableresource msdyn_bookableresource_msdyn_actual_bookableresource
msdyn_ContactCustomer contact msdyn_contact_msdyn_actual_ContactCustomer
msdyn_ContactVendor contact msdyn_contact_msdyn_actual_ContactVendor
msdyn_contractorganizationalunitid msdyn_organizationalunit msdyn_msdyn_organizationalunit_msdyn_actual_ContractOrganizationalUnitId
msdyn_IncidentType msdyn_incidenttype msdyn_msdyn_incidenttype_msdyn_actual_IncidentType
msdyn_Invoice invoice msdyn_invoice_msdyn_actual_Invoice
msdyn_PriceList pricelevel msdyn_pricelevel_msdyn_actual_PriceList
msdyn_Product product msdyn_product_msdyn_actual_Product
msdyn_Project msdyn_project msdyn_msdyn_project_msdyn_actual_Project
msdyn_ResourceCategory bookableresourcecategory msdyn_bookableresourcecategory_msdyn_actual_ResourceCategory
msdyn_ResourceOrganizationalUnitId msdyn_organizationalunit msdyn_organizationalunit_actual
msdyn_SalesContract salesorder msdyn_salesorder_msdyn_actual_SalesContract
msdyn_SalesContractLineId salesorderdetail msdyn_salesorderdetail_msdyn_actual
msdyn_ServiceAccount account msdyn_account_msdyn_actual_ServiceAccount
msdyn_ServiceTerritory territory msdyn_territory_msdyn_actual_ServiceTerritory
msdyn_Task msdyn_projecttask msdyn_msdyn_projecttask_msdyn_actual_Task
msdyn_TaxCode msdyn_taxcode msdyn_msdyn_taxcode_msdyn_actual_TaxCode
msdyn_TransactionCategory msdyn_transactioncategory msdyn_msdyn_transactioncategory_msdyn_actual_TransactionCategory
msdyn_Unit uom msdyn_uom_msdyn_actual_Unit
msdyn_UnitSchedule uomschedule msdyn_uomschedule_msdyn_actual_UnitSchedule
msdyn_Warehouse msdyn_warehouse msdyn_msdyn_warehouse_msdyn_actual_Warehouse
msdyn_WorkOrder msdyn_workorder msdyn_msdyn_workorder_msdyn_actual_WorkOrder
msdyn_WorkOrderType msdyn_workordertype msdyn_msdyn_workordertype_msdyn_actual_WorkOrderType
ownerid principal owner_msdyn_actual
owningbusinessunit businessunit business_unit_msdyn_actual
owningteam team team_msdyn_actual
owninguser systemuser user_msdyn_actual
transactioncurrencyid transactioncurrency TransactionCurrency_msdyn_actual

Collection-valued navigation properties

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

Name Type Partner
msdyn_actual_Annotations annotation objectid_msdyn_actual
msdyn_actual_AsyncOperations asyncoperation regardingobjectid_msdyn_actual
msdyn_actual_BulkDeleteFailures bulkdeletefailure regardingobjectid_msdyn_actual
msdyn_actual_DuplicateBaseRecord duplicaterecord baserecordid_msdyn_actual
msdyn_actual_DuplicateMatchingRecord duplicaterecord duplicaterecordid_msdyn_actual
msdyn_actual_MailboxTrackingFolders mailboxtrackingfolder regardingobjectid_msdyn_actual
msdyn_actual_PrincipalObjectAttributeAccesses principalobjectattributeaccess objectid_msdyn_actual
msdyn_actual_ProcessSession processsession regardingobjectid_msdyn_actual
msdyn_actual_SyncErrors syncerror regardingobjectid_msdyn_actual


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

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


The following solutions include the msdyn_actual entity type.

Name Description
Field Service Microsoft Dynamics 365 for Field Service allows organizations of any size to deliver intelligent, world class field service, managing all aspects of the end-to-end field service management cycle. Features include scheduling, mobile, asset management, inventory control, customer notifications, and resource utilization controls that help maximize efficiency and minimize costs.
Universal Resource Scheduling The Universal Resource Scheduling solution provides the infrastructure to express resource requirements for any entity in the system and help staff those requirements with resources based on the availability and applicability of the resource for the requirement.
Project Service Automation Microsoft Dynamics 365 for Project Service Automation is an end-to-end solution that helps sales and delivery teams engage customers and deliver billable projects on time and within budget. Project Service gives you the tools you need to: Estimate, quote, and contract work; Plan and assign resources; Enable team collaboration; Capture time, expense, and progress data for real-time insights and accurate invoicing.

See also