msdyn_expense EntityType

Main container that holds expense information.

Entity Set Path
[organization URI]/api/data/v9.0/msdyn_expenses
Base Type
crmbaseentity
Display Name
Expense
Primary Key
msdyn_expenseid
Primary Key Attribute
msdyn_name
Operations Supported
POST GET PATCH DELETE

Properties

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

Enter the total amount for expense.

Display Name: Amount

msdyn_amount_base Edm.Decimal

Value of the Amount in base currency.

Display Name: Amount (Base)

Read Only
msdyn_expenseid Edm.Guid

Shows the entity instances.

Display Name: Expense

msdyn_expensestatus Edm.Int32

Shows the status of the expense entry.

Display Name: Expense Status

Default Options
Value Label
192350000 Draft
192350001 Submitted
192350002 Approved
192350003 Rejected
192350004 Posted
192350005 Paid
msdyn_externaldescription Edm.String

The external comments of the expense entry.

Display Name: External Comments

msdyn_name Edm.String

Enter the expense's purpose.

Display Name: Expense Purpose

msdyn_salestaxamount Edm.Decimal

Enter the sales tax amount.

Display Name: Sales tax amount

msdyn_salestaxamount_base Edm.Decimal

Value of the Sales tax amount in base currency.

Display Name: Sales tax amount (Base)

Read Only
msdyn_targetexpensestatus Edm.Int32

Shows the status that the record will be transitioned to asynchronously. Currently, this is only implemented from submission to approved.

Display Name: Target Expense Status

Default Options
Value Label
192350000 Draft
192350001 Submitted
192350002 Approved
192350003 Rejected
192350004 Posted
192350005 Paid
msdyn_totalamount Edm.Decimal

Shows the total amount of the expense entry.

Display Name: Total Amount

Read Only
Is Computed
msdyn_totalamount_base Edm.Decimal

Enter the value of the total amount in the base currency.

Display Name: Total Amount (Base)

Read Only
Is Computed
msdyn_transactiondate Edm.DateTimeOffset

Enter the date of the expense transaction.

Display Name: Transaction Date

overriddencreatedon Edm.DateTimeOffset

Date and time that the record was migrated.

Display Name: Record Created On

processid Edm.Guid

Contains the id of the process associated with the entity.

Display Name: Process Id

statecode Edm.Int32

Status of the Expense

Display Name: Status

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

Reason for the status of the Expense

Display Name: Status Reason

Default Options
Value Label
867380000 Draft
867380001 Rejected
867380002 Submitted
867380003 Approved
867380004 Posted
867380005 Paid
timezoneruleversionnumber Edm.Int32

For internal use only.

Display Name: Time Zone Rule Version Number

traversedpath Edm.String

A comma separated list of string values representing the unique identifiers of stages in a Business Process Flow Instance in the order that they occur.

Display Name: Traversed Path

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_bookableresource_value msdyn_bookableresource

Shows the bookable resource..

_msdyn_expensecategory_value msdyn_ExpenseCategory

Enter the expense category.

_msdyn_manager_value msdyn_manager

Select the manager of the expense user. This field is used for approval.

_msdyn_project_value msdyn_Project

Enter the project.

_msdyn_resourceorganizationalunitid_value msdyn_ResourceOrganizationalUnitId

Select the organizational unit at the time the entry was registered of the resource who had the expense.

_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.

_stageid_value stageid

Contains the id of the stage where the entity is located.

_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_expense_createdby
createdonbehalfby systemuser lk_msdyn_expense_createdonbehalfby
modifiedby systemuser lk_msdyn_expense_modifiedby
modifiedonbehalfby systemuser lk_msdyn_expense_modifiedonbehalfby
msdyn_bookableresource bookableresource msdyn_bookableresource_msdyn_expense_bookableresource
msdyn_ExpenseCategory msdyn_expensecategory msdyn_msdyn_expensecategory_msdyn_expense_ExpenseCategory
msdyn_manager systemuser msdyn_systemuser_msdyn_expense_manager
msdyn_Project msdyn_project msdyn_msdyn_project_msdyn_expense_Project
msdyn_ResourceOrganizationalUnitId msdyn_organizationalunit msdyn_organizationalunit_expense
ownerid principal owner_msdyn_expense
owningbusinessunit businessunit business_unit_msdyn_expense
owningteam team team_msdyn_expense
owninguser systemuser user_msdyn_expense
stageid processstage processstage_msdyn_expense
transactioncurrencyid transactioncurrency TransactionCurrency_msdyn_expense

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_expense_Annotations annotation objectid_msdyn_expense
msdyn_expense_AsyncOperations asyncoperation regardingobjectid_msdyn_expense
msdyn_expense_BulkDeleteFailures bulkdeletefailure regardingobjectid_msdyn_expense
msdyn_expense_DuplicateBaseRecord duplicaterecord baserecordid_msdyn_expense
msdyn_expense_DuplicateMatchingRecord duplicaterecord duplicaterecordid_msdyn_expense
msdyn_expense_MailboxTrackingFolders mailboxtrackingfolder regardingobjectid_msdyn_expense
msdyn_expense_PrincipalObjectAttributeAccesses principalobjectattributeaccess objectid_msdyn_expense
msdyn_expense_ProcessSession processsession regardingobjectid_msdyn_expense
msdyn_expense_SharePointDocumentLocations sharepointdocumentlocation regardingobjectid_msdyn_expense
msdyn_expense_SyncErrors syncerror regardingobjectid_msdyn_expense
msdyn_msdyn_expense_msdyn_expensereceipt_ExpenseId msdyn_expensereceipt msdyn_ExpenseId
msdyn_msdyn_expense_msdyn_projectapproval_ExpenseEntry msdyn_projectapproval msdyn_ExpenseEntry

Operations

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

Name Binding
GrantAccess Not Bound
IsValidStateTransition Not Bound
ModifyAccess Not Bound
msdyn_ExpenseApproveAction Entity
msdyn_ExpenseRejectAction Entity
msdyn_ExpenseSubmitAction Entity
RetrievePrincipalAccess Not Bound
RetrieveSharedPrincipalsAndAccess Not Bound
RevokeAccess Not Bound

Solutions

The following solutions include the msdyn_expense entity type.

Name Description
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