msdyn_transactioncategorypricelevel EntityType

List of prices by category on a price list.

Entity Set Path
[organization URI]/api/data/v9.0/msdyn_transactioncategorypricelevels
Base Type
Display Name
Transaction Category Price
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_description Edm.String

Type the name of the custom entity.

Display Name: Description

msdyn_percent Edm.Decimal

Enter the mark up on cost when creating billable transactions from cost transactions. This field is relevant only when the price calculation is "Markup over cost."

Display Name: Percent

msdyn_price Edm.Decimal

Enter the price of the transaction category.

Display Name: Price

msdyn_price_base Edm.Decimal

Value of the Price in base currency.

Display Name: Price (Base)

Read Only
msdyn_pricecalculation Edm.Int32

Select the method used to determine the sales or bill rate of expenses in this category. Valid values are Price per unit, At cost or Markup over cost.

Display Name: Price Calculation

Default Options
Value Label
192350000 Price per unit
192350001 At cost
192350002 Markup percentage
msdyn_transactioncategorypricelevelid Edm.Guid

Unique identifier for entity instances

Display Name: Transaction Category Price

overriddencreatedon Edm.DateTimeOffset

Date and time that the record was migrated.

Display Name: Record Created On

statecode Edm.Int32

Status of the Transaction Category Price

Display Name: Status

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

Reason for the status of the Transaction Category Price

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_pricelist_value msdyn_PriceList

Select the price list that this price list line belongs to.

_msdyn_transactioncategory_value msdyn_TransactionCategory

Select the transaction category whose price is being setup

_msdyn_unit_value msdyn_Unit

Select the units that transactions of this category can be expressed in.

_msdyn_unitschedule_value msdyn_UnitSchedule

Select the unit schedule that determines in which units the category can be priced.

_organizationid_value organizationid

Unique identifier for the organization

_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_transactioncategorypricelevel_createdby
createdonbehalfby systemuser lk_msdyn_transactioncategorypricelevel_createdonbehalfby
modifiedby systemuser lk_msdyn_transactioncategorypricelevel_modifiedby
modifiedonbehalfby systemuser lk_msdyn_transactioncategorypricelevel_modifiedonbehalfby
msdyn_PriceList pricelevel msdyn_pricelevel_msdyn_transactioncategorypricelevel_PriceList
msdyn_TransactionCategory msdyn_transactioncategory msdyn_msdyn_transactioncategory_msdyn_transactioncategorypricelevel_TransactionCategory
msdyn_Unit uom msdyn_uom_msdyn_transactioncategorypricelevel_Unit
msdyn_UnitSchedule uomschedule msdyn_uomschedule_msdyn_transactioncategorypricelevel_UnitSchedule
organizationid organization organization_msdyn_transactioncategorypricelevel
transactioncurrencyid transactioncurrency TransactionCurrency_msdyn_transactioncategorypricelevel

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_transactioncategorypricelevel_Annotations annotation objectid_msdyn_transactioncategorypricelevel
msdyn_transactioncategorypricelevel_AsyncOperations asyncoperation regardingobjectid_msdyn_transactioncategorypricelevel
msdyn_transactioncategorypricelevel_BulkDeleteFailures bulkdeletefailure regardingobjectid_msdyn_transactioncategorypricelevel
msdyn_transactioncategorypricelevel_DuplicateBaseRecord duplicaterecord baserecordid_msdyn_transactioncategorypricelevel
msdyn_transactioncategorypricelevel_DuplicateMatchingRecord duplicaterecord duplicaterecordid_msdyn_transactioncategorypricelevel
msdyn_transactioncategorypricelevel_MailboxTrackingFolders mailboxtrackingfolder regardingobjectid_msdyn_transactioncategorypricelevel
msdyn_transactioncategorypricelevel_PrincipalObjectAttributeAccesses principalobjectattributeaccess objectid_msdyn_transactioncategorypricelevel
msdyn_transactioncategorypricelevel_ProcessSession processsession regardingobjectid_msdyn_transactioncategorypricelevel
msdyn_transactioncategorypricelevel_SyncErrors syncerror regardingobjectid_msdyn_transactioncategorypricelevel


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

Name Binding
IsValidStateTransition Not Bound


The following solutions include the msdyn_transactioncategorypricelevel 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