msdyn_opportunitylinetransaction EntityType

Sales estimate detail of an opportunity line (Deprecated in v3.0)

Entity Set Path
[organization URI]/api/data/v9.0/msdyn_opportunitylinetransactions
Base Type
Display Name
Opportunity Line Detail (Deprecated)
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_amount Edm.Decimal

Enter the amount on the estimate line.

Display Name: Amount

msdyn_amount_base Edm.Decimal

Value of the Amount in base currency.

Display Name: Amount (Base)

Read Only
msdyn_amountmethod Edm.Int32

Select the calculation method used to determine the amount on the estimate line.

Display Name: Amount Method

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

Display Name: Basis Amount

msdyn_basisamount_base Edm.Decimal

Value of the Basis Amount in base currency.

Display Name: Basis Amount (Base)

Read Only
msdyn_basisprice Edm.Decimal

Display Name: Basis Price

msdyn_basisprice_base Edm.Decimal

Value of the Basis Price in base currency.

Display Name: Basis Price (Base)

Read Only
msdyn_basisquantity Edm.Decimal

Enter the quantity used as basis for calculating quantity on this estimate line.

Display Name: Basis Quantity

msdyn_billingtype Edm.Int32

Select whether this estimate line would be charged to the customer or not. Only chargeable transactions will add to the invoice total when an invoices are created

Display Name: Billing Type

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

Select whether the customer identified on the opportunity was an account or a contact

Display Name: Customer Type

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

Type a description of the opportunity line estimate.

Display Name: description

msdyn_documentdate Edm.DateTimeOffset

Enter the document date. The document date is only relevant for actuals and invoiced transactions; does not apply to opportunity line estimates.

Display Name: Document Date

msdyn_enddatetime Edm.DateTimeOffset

Enter the end time of the opportunity line estimate.

Display Name: End Date Time

msdyn_exchangeratedate Edm.DateTimeOffset

Display Name: Exchange Rate Date

msdyn_opportunityline Edm.String

Shows the opportunity line that this estimate line belongs to.

Display Name: Opportunity Line

msdyn_opportunitylinetransactionid Edm.Guid

Shows the entity instances.

Display Name: Opportunity Line Detail

msdyn_percent Edm.Decimal

Relevant when amount calculation method on the opportunity line transactions is "Multiply basis amount by percent"

Display Name: Percent

msdyn_price Edm.Decimal

Enter the price on the estimate line.

Display Name: Price

msdyn_price_base Edm.Decimal

Value of the Price in base currency.

Display Name: Price (Base)

Read Only
msdyn_quantity Edm.Decimal

Enter the quantity of the opportunity estimate line.

Display Name: Quantity

msdyn_startdatetime Edm.DateTimeOffset

Enter the start date of the opportunity line estimate.

Display Name: Start Date Time

msdyn_transactionclassification Edm.Int32

Transaction classification of the Opportunity line 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

Transaction type for the opportunity line.

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
overriddencreatedon Edm.DateTimeOffset

Date and time that the record was migrated.

Display Name: Record Created On

statecode Edm.Int32

Status of the Opportunity Line Detail

Display Name: Status

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

Reason for the status of the Opportunity Line Detail

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 name of the customer to which this opportunity belongs.

_msdyn_accountvendor_value msdyn_AccountVendor
_msdyn_bookableresource_value msdyn_bookableresource

Shows the resource.

_msdyn_contactcustomer_value msdyn_ContactCustomer

Select the customer contact of this opportunity.

_msdyn_contactvendor_value msdyn_ContactVendor
_msdyn_pricelist_value msdyn_PriceList

Select the price list used on the opportunity line estimate.

_msdyn_product_value msdyn_Product

Select the product on the estimate line.

_msdyn_project_value msdyn_Project

Select the name of the Project that this estimate line is for.

_msdyn_resourcecategory_value msdyn_ResourceCategory

Select the role that is estimated to perform the work.

_msdyn_resourceorganizationalunitid_value msdyn_ResourceOrganizationalUnitId

Select the organizational unit of the resource who is estimated to perform the work.

_msdyn_task_value msdyn_Task

Select the name of the project task for which this estimate line was created.

_msdyn_transactioncategory_value msdyn_TransactionCategory

Select the category of the transaction.

_msdyn_unit_value msdyn_Unit

Select the unit of the estimate quantity.

_msdyn_unitschedule_value msdyn_UnitSchedule

Select the unit group of the opportunity line estimate.

_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_opportunitylinetransaction_createdby
createdonbehalfby systemuser lk_msdyn_opportunitylinetransaction_createdonbehalfby
modifiedby systemuser lk_msdyn_opportunitylinetransaction_modifiedby
modifiedonbehalfby systemuser lk_msdyn_opportunitylinetransaction_modifiedonbehalfby
msdyn_AccountCustomer account msdyn_account_msdyn_opportunitylinetransaction_AccountCustomer
msdyn_AccountVendor account msdyn_account_msdyn_opportunitylinetransaction_AccountVendor
msdyn_bookableresource bookableresource msdyn_bookableresource_msdyn_opportunitylinetransaction_bookableresource
msdyn_ContactCustomer contact msdyn_contact_msdyn_opportunitylinetransaction_ContactCustomer
msdyn_ContactVendor contact msdyn_contact_msdyn_opportunitylinetransaction_ContactVendor
msdyn_PriceList pricelevel msdyn_pricelevel_msdyn_opportunitylinetransaction_PriceList
msdyn_Product product msdyn_product_msdyn_opportunitylinetransaction_Product
msdyn_Project msdyn_project msdyn_msdyn_project_msdyn_opportunitylinetransaction_Project
msdyn_ResourceCategory bookableresourcecategory msdyn_bookableresourcecategory_msdyn_opportunitylinetransaction_ResourceCategory
msdyn_ResourceOrganizationalUnitId msdyn_organizationalunit msdyn_organizationalunit_opportunitylinedetail
msdyn_Task msdyn_projecttask msdyn_msdyn_projecttask_msdyn_opportunitylinetransaction_Task
msdyn_TransactionCategory msdyn_transactioncategory msdyn_msdyn_transactioncategory_msdyn_opportunitylinetransaction_TransactionCategory
msdyn_Unit uom msdyn_uom_msdyn_opportunitylinetransaction_Unit
msdyn_UnitSchedule uomschedule msdyn_uomschedule_msdyn_opportunitylinetransaction_UnitSchedule
ownerid principal owner_msdyn_opportunitylinetransaction
owningbusinessunit businessunit business_unit_msdyn_opportunitylinetransaction
owningteam team team_msdyn_opportunitylinetransaction
owninguser systemuser user_msdyn_opportunitylinetransaction
transactioncurrencyid transactioncurrency TransactionCurrency_msdyn_opportunitylinetransaction

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_opportunitylinetransaction_Annotations annotation objectid_msdyn_opportunitylinetransaction
msdyn_opportunitylinetransaction_AsyncOperations asyncoperation regardingobjectid_msdyn_opportunitylinetransaction
msdyn_opportunitylinetransaction_BulkDeleteFailures bulkdeletefailure regardingobjectid_msdyn_opportunitylinetransaction
msdyn_opportunitylinetransaction_DuplicateBaseRecord duplicaterecord baserecordid_msdyn_opportunitylinetransaction
msdyn_opportunitylinetransaction_DuplicateMatchingRecord duplicaterecord duplicaterecordid_msdyn_opportunitylinetransaction
msdyn_opportunitylinetransaction_MailboxTrackingFolders mailboxtrackingfolder regardingobjectid_msdyn_opportunitylinetransaction
msdyn_opportunitylinetransaction_PrincipalObjectAttributeAccesses principalobjectattributeaccess objectid_msdyn_opportunitylinetransaction
msdyn_opportunitylinetransaction_ProcessSession processsession regardingobjectid_msdyn_opportunitylinetransaction
msdyn_opportunitylinetransaction_SyncErrors syncerror regardingobjectid_msdyn_opportunitylinetransaction


The following operations can be used with the msdyn_opportunitylinetransaction 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_opportunitylinetransaction 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