msdyn_orderlinetransaction EntityType

Sales estimate detail of an project contract line.

Entity Set Path
[organization URI]/api/data/v9.0/msdyn_orderlinetransactions
Base Type
crmbaseentity
Display Name
Project Contract Line Detail
Primary Key
msdyn_orderlinetransactionid
Primary Key Attribute
msdyn_description
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_accountingdate Edm.DateTimeOffset

Display Name: Accounting Date

msdyn_amount Edm.Decimal

Enter the amount on the project contract 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 amount calculation method used for this project contract estimate line. Valid values are: 0: Multiply Quantity By Price 1: Fixed Price 2: Multiply Basis Quantity By Price 3: Multiply Basis Amount By Percent

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

Display Name: Basis Quantity

msdyn_billingtype Edm.Int32

Select whether this project contract line estimate will be charged to the customer or not. Only chargeable project contract line estimates 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 was a 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 project contract line estimate

Display Name: Description

msdyn_documentdate Edm.DateTimeOffset

Enter the document date.

Display Name: Document Date

msdyn_enddatetime Edm.DateTimeOffset

Enter the end date on the project contract line estimate.

Display Name: End Date/Time

msdyn_exchangeratedate Edm.DateTimeOffset

Display Name: Exchange Rate Date

msdyn_orderlinetransactionid Edm.Guid

Shows the project contract line that this estimate line belongs to.

Display Name: Project contract line estimate

msdyn_percent Edm.Decimal

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

Display Name: Percent

msdyn_price Edm.Decimal

Enter the price on the project contract 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 of the project contract line estimate.

Display Name: Quantity

msdyn_salescontractline Edm.String

Shows the project contract line that this project contract line estimate will be mapped to for operating margin calculations.

Display Name: Project Contract Line

msdyn_startdatetime Edm.DateTimeOffset

Enter the estimate start date of the portion of work that is being estimated on the project contract estimate line.

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 of the Project Contract line transaction

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

Transaction type of the Project Contract line 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
overriddencreatedon Edm.DateTimeOffset

Date and time that the record was migrated.

Display Name: Record Created On

statecode Edm.Int32

Status of the Estimate Details

Display Name: Status

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

Reason for the status of the Estimate Details

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 who this contract belongs to.

_msdyn_accountvendor_value msdyn_AccountVendor
_msdyn_bookableresource_value msdyn_bookableresource

Shows the resource.

_msdyn_contactcustomer_value msdyn_ContactCustomer

Select the customer contact of this Project Contract.

_msdyn_contactvendor_value msdyn_ContactVendor
_msdyn_origin_value msdyn_Origin

Foreign key to the detail line that originated this entry. For example, revenue line points to it's related cost line.

_msdyn_pricelist_value msdyn_PriceList

Select the price list used for defaulting price on this project contract line estimate.

_msdyn_product_value msdyn_Product

Select the product on this project contract line estimate.

_msdyn_project_value msdyn_Project

Select the name of the project on the project contract estimate line.

_msdyn_resourcecategory_value msdyn_ResourceCategory

Select the name of the role that is estimated to perform this work.

_msdyn_resourceorganizationalunitid_value msdyn_ResourceOrganizationalUnitId

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

_msdyn_salescontract_value msdyn_SalesContract

Select the project contract that this estimate line is for.

_msdyn_task_value msdyn_Task

Select the name of the work breakdown structure (WBS) task on the project contract line estimate.

_msdyn_transactioncategory_value msdyn_TransactionCategory

Select the transaction category on the project contract line estimate.

_msdyn_unit_value msdyn_Unit

Select the unit on the project contract line estimate.

_msdyn_unitschedule_value msdyn_UnitSchedule

Select the unit schedule of the project contract 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_orderlinetransaction_createdby
createdonbehalfby systemuser lk_msdyn_orderlinetransaction_createdonbehalfby
modifiedby systemuser lk_msdyn_orderlinetransaction_modifiedby
modifiedonbehalfby systemuser lk_msdyn_orderlinetransaction_modifiedonbehalfby
msdyn_AccountCustomer account msdyn_account_msdyn_orderlinetransaction_AccountCustomer
msdyn_AccountVendor account msdyn_account_msdyn_orderlinetransaction_AccountVendor
msdyn_bookableresource bookableresource msdyn_bookableresource_msdyn_orderlinetransaction_bookableresource
msdyn_ContactCustomer contact msdyn_contact_msdyn_orderlinetransaction_ContactCustomer
msdyn_ContactVendor contact msdyn_contact_msdyn_orderlinetransaction_ContactVendor
msdyn_Origin msdyn_orderlinetransaction msdyn_msdyn_orderlinetransaction_msdyn_orderlinetransaction_Origin
msdyn_PriceList pricelevel msdyn_pricelevel_msdyn_orderlinetransaction_PriceList
msdyn_Product product msdyn_product_msdyn_orderlinetransaction_Product
msdyn_Project msdyn_project msdyn_msdyn_project_msdyn_orderlinetransaction_Project
msdyn_ResourceCategory bookableresourcecategory msdyn_bookableresourcecategory_msdyn_orderlinetransaction_ResourceCategory
msdyn_ResourceOrganizationalUnitId msdyn_organizationalunit msdyn_organizationalunit_orderlinetransaction
msdyn_SalesContract salesorder msdyn_salesorder_msdyn_orderlinetransaction_SalesContract
msdyn_Task msdyn_projecttask msdyn_msdyn_projecttask_msdyn_orderlinetransaction_Task
msdyn_TransactionCategory msdyn_transactioncategory msdyn_msdyn_transactioncategory_msdyn_orderlinetransaction_TransactionCategory
msdyn_Unit uom msdyn_uom_msdyn_orderlinetransaction_Unit
msdyn_UnitSchedule uomschedule msdyn_uomschedule_msdyn_orderlinetransaction_UnitSchedule
ownerid principal owner_msdyn_orderlinetransaction
owningbusinessunit businessunit business_unit_msdyn_orderlinetransaction
owningteam team team_msdyn_orderlinetransaction
owninguser systemuser user_msdyn_orderlinetransaction
transactioncurrencyid transactioncurrency TransactionCurrency_msdyn_orderlinetransaction

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_orderlinetransaction_msdyn_orderlinetransaction_Origin msdyn_orderlinetransaction msdyn_Origin
msdyn_orderlinetransaction_Annotations annotation objectid_msdyn_orderlinetransaction
msdyn_orderlinetransaction_AsyncOperations asyncoperation regardingobjectid_msdyn_orderlinetransaction
msdyn_orderlinetransaction_BulkDeleteFailures bulkdeletefailure regardingobjectid_msdyn_orderlinetransaction
msdyn_orderlinetransaction_DuplicateBaseRecord duplicaterecord baserecordid_msdyn_orderlinetransaction
msdyn_orderlinetransaction_DuplicateMatchingRecord duplicaterecord duplicaterecordid_msdyn_orderlinetransaction
msdyn_orderlinetransaction_MailboxTrackingFolders mailboxtrackingfolder regardingobjectid_msdyn_orderlinetransaction
msdyn_orderlinetransaction_PrincipalObjectAttributeAccesses principalobjectattributeaccess objectid_msdyn_orderlinetransaction
msdyn_orderlinetransaction_ProcessSession processsession regardingobjectid_msdyn_orderlinetransaction
msdyn_orderlinetransaction_SyncErrors syncerror regardingobjectid_msdyn_orderlinetransaction

Operations

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

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

Solutions

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