msdyn_quotelinetransaction EntityType

Sales estimate detail of a quote line.

Entity Set Path
[organization URI]/api/data/v9.0/msdyn_quotelinetransactions
Base Type
Display Name
Quote Line Detail
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 quote line estimate.

Display Name: Amount

msdyn_amount_after_tax Edm.Decimal

Display Name: amount_after_tax

Read Only
Is Computed
msdyn_amount_after_tax_base Edm.Decimal

Value of the amount_after_tax in base currency.

Display Name: amount_after_tax (Base)

Read Only
Is Computed
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 for the amount on the estimate line. Valid methods are: Multiply Quantity By Price, Fixed Price, Multiply Basis Quantity By Price, Multiply Basis Amount By Percent

Display Name: Amount calculation 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

Display Name: Basis Quantity

msdyn_billingtype Edm.Int32

Select whether this quote line estimate will be charged to the customer or not. Only chargeable transactions will add to the invoice total

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 is an account or a contact

Display Name: Customer Type

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

Type the name of the custom entity.

Display Name: Description

msdyn_documentdate Edm.DateTimeOffset

Enter the date that the invoice is sent to the customer. Only relevant on invoice and invoice line transactions

Display Name: Document Date

msdyn_enddatetime Edm.DateTimeOffset

Enter the end date of the work being estimated on the quote line estimate.

Display Name: End Date Time

msdyn_exchangeratedate Edm.DateTimeOffset

Display Name: Exchange Rate Date

msdyn_isdataimport Edm.Boolean

Indicates if this record was created via import. It's purpose is to support data import.

Display Name: isdataimport

Default Options
Value Label
1 Yes
0 No
msdyn_percent Edm.Decimal

Enter the amount, in percent, to multiply the basis by. This field is relevant when the amount calculation method is "Multiply basis amount by percent."

Display Name: Percent

msdyn_price Edm.Decimal

Enter the price on the quote line estimate.

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 on the quote line estimate.

Display Name: Quantity

msdyn_quoteline Edm.String

Type the quote line to which this estimate line belongs to.

Display Name: Quote Line

msdyn_quotelinetransactionid Edm.Guid

Unique identifier for entity instances

Display Name: Quote Line Detail

msdyn_startdatetime Edm.DateTimeOffset

Enter the estimated start of the work being estimated on the quote line estimate.

Display Name: Start Date Time

msdyn_tax Edm.Decimal

Display Name: Tax

msdyn_tax_base Edm.Decimal

Value of the tax in base currency.

Display Name: tax (Base)

Read Only
msdyn_transactionclassification Edm.Int32

Transaction classification for the quote line

Display Name: Transaction Class

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

Shows the transaction type for this quote 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 Quote Line Detail

Display Name: Status

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

Reason for the status of the Quote 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 account.

_msdyn_accountvendor_value msdyn_AccountVendor
_msdyn_bookableresource_value msdyn_bookableresource

Shows the resource.

_msdyn_contactcustomer_value msdyn_ContactCustomer

Select the contact customer on the quote.

_msdyn_contactvendor_value msdyn_ContactVendor
_msdyn_origin_value msdyn_Origin

Points to the quote line detail that originated an entry. For example, a revenue entry points to its related cost entry.

_msdyn_pricelist_value msdyn_PriceList

Select the price List used to default price on the estimate line.

_msdyn_product_value msdyn_Product

Select the product on the quote line estimate.

_msdyn_project_value msdyn_Project

Select the project being referenced by the quote line estimate.

_msdyn_quoteid_value msdyn_QuoteId

Select the denormalized reference to the quote. This is used for performance improvements and to allow the use of Power BI on a quote.

_msdyn_resourcecategory_value msdyn_ResourceCategory

Select the role on the quote line estimate.

_msdyn_resourceorganizationalunitid_value msdyn_ResourceOrganizationalUnitId

Select the organizational unit of the resource who should perform the work.

_msdyn_task_value msdyn_Task

Select the project work breakdown structure (WBS) task referenced by the quote line estimate.

_msdyn_transactioncategory_value msdyn_TransactionCategory

Select the category on the quote line estimate.

_msdyn_unit_value msdyn_Unit

Select the unit that the quantity is estimated in on this quote line estimate.

_msdyn_unitschedule_value msdyn_UnitSchedule

Select the unit schedule associated with the estimate line.

_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_quotelinetransaction_createdby
createdonbehalfby systemuser lk_msdyn_quotelinetransaction_createdonbehalfby
modifiedby systemuser lk_msdyn_quotelinetransaction_modifiedby
modifiedonbehalfby systemuser lk_msdyn_quotelinetransaction_modifiedonbehalfby
msdyn_AccountCustomer account msdyn_account_msdyn_quotelinetransaction_AccountCustomer
msdyn_AccountVendor account msdyn_account_msdyn_quotelinetransaction_AccountVendor
msdyn_bookableresource bookableresource msdyn_bookableresource_msdyn_quotelinetransaction_bookableresource
msdyn_ContactCustomer contact msdyn_contact_msdyn_quotelinetransaction_ContactCustomer
msdyn_ContactVendor contact msdyn_contact_msdyn_quotelinetransaction_ContactVendor
msdyn_Origin msdyn_quotelinetransaction msdyn_msdyn_quotelinetransaction_msdyn_quotelinetransaction_Origin
msdyn_PriceList pricelevel msdyn_pricelevel_msdyn_quotelinetransaction_PriceList
msdyn_Product product msdyn_product_msdyn_quotelinetransaction_Product
msdyn_Project msdyn_project msdyn_msdyn_project_msdyn_quotelinetransaction_Project
msdyn_QuoteId quote msdyn_quote_msdyn_quotelinetransaction
msdyn_ResourceCategory bookableresourcecategory msdyn_bookableresourcecategory_msdyn_quotelinetransaction_ResourceCategory
msdyn_ResourceOrganizationalUnitId msdyn_organizationalunit msdyn_organizationalunit_quotelinetransaction
msdyn_Task msdyn_projecttask msdyn_msdyn_projecttask_msdyn_quotelinetransaction_Task
msdyn_TransactionCategory msdyn_transactioncategory msdyn_msdyn_transactioncategory_msdyn_quotelinetransaction_TransactionCategory
msdyn_Unit uom msdyn_uom_msdyn_quotelinetransaction_Unit
msdyn_UnitSchedule uomschedule msdyn_uomschedule_msdyn_quotelinetransaction_UnitSchedule
ownerid principal owner_msdyn_quotelinetransaction
owningbusinessunit businessunit business_unit_msdyn_quotelinetransaction
owningteam team team_msdyn_quotelinetransaction
owninguser systemuser user_msdyn_quotelinetransaction
transactioncurrencyid transactioncurrency TransactionCurrency_msdyn_quotelinetransaction

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_msdyn_quotelinetransaction_msdyn_quotelineanalyticsbreakdown_QuoteLineDetail msdyn_quotelineanalyticsbreakdown msdyn_QuoteLineDetail
msdyn_msdyn_quotelinetransaction_msdyn_quotelinetransaction_Origin msdyn_quotelinetransaction msdyn_Origin
msdyn_quotelinetransaction_Annotations annotation objectid_msdyn_quotelinetransaction
msdyn_quotelinetransaction_AsyncOperations asyncoperation regardingobjectid_msdyn_quotelinetransaction
msdyn_quotelinetransaction_BulkDeleteFailures bulkdeletefailure regardingobjectid_msdyn_quotelinetransaction
msdyn_quotelinetransaction_DuplicateBaseRecord duplicaterecord baserecordid_msdyn_quotelinetransaction
msdyn_quotelinetransaction_DuplicateMatchingRecord duplicaterecord duplicaterecordid_msdyn_quotelinetransaction
msdyn_quotelinetransaction_MailboxTrackingFolders mailboxtrackingfolder regardingobjectid_msdyn_quotelinetransaction
msdyn_quotelinetransaction_PrincipalObjectAttributeAccesses principalobjectattributeaccess objectid_msdyn_quotelinetransaction
msdyn_quotelinetransaction_ProcessSession processsession regardingobjectid_msdyn_quotelinetransaction
msdyn_quotelinetransaction_SyncErrors syncerror regardingobjectid_msdyn_quotelinetransaction


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