msdyn_invoicelinetransaction EntityType

Transactions that are associated to an invoice line.

Entity Set Path
[organization URI]/api/data/v9.0/msdyn_invoicelinetransactions
Base Type
Display Name
Invoice 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 transaction.

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 name of the amount calculation method.

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 transaction 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_correction Edm.Boolean

Indicates if this transaction is correcting a previous transaction.

Display Name: Correction

Default Options
Value Label
1 Yes
0 No
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 Invoice line transaction.

Display Name: Description

msdyn_documentdate Edm.DateTimeOffset

Enter the date on which this invoice line detail was sent to the customer

Display Name: Document Date

msdyn_enddatetime Edm.DateTimeOffset

Date of invoiced transaction

Display Name: End Date/Time

msdyn_exchangeratedate Edm.DateTimeOffset

Display Name: Exchange Rate Date

msdyn_externaldescription Edm.String

The external description of the invoice line detail

Display Name: External Description

msdyn_invoiceamount Edm.Decimal

Amount to be invoiced. This is the line amount less the previously invoiced amount when this is a correction.

Display Name: Invoice Amount

Read Only
Is Computed
msdyn_invoiceamount_base Edm.Decimal

Value of the Invoice Amount in base currency.

Display Name: Invoice Amount (Base)

Read Only
Is Computed
msdyn_invoiceline Edm.String

(Deprecated) Shows the invoice line that this invoice line transaction is associated to.

Display Name: (Deprecated) Invoice Line

msdyn_invoicelinetransactionid Edm.Guid

Shows the entity instances.

Display Name: Invoice Line Detail

msdyn_percent Edm.Decimal

Relevant when amount calculation method on the invoice line transaction is "Multiply basis amount by percent"

Display Name: Percent

msdyn_previousamount Edm.Decimal

Amount that was previously invoiced if this is a correction.

Display Name: Previous Amount

msdyn_previousamount_base Edm.Decimal

Value of the Previous Amount in base currency.

Display Name: Previous Amount (Base)

Read Only
msdyn_price Edm.Decimal

Enter the price of the transaction.

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

Display Name: Quantity

msdyn_salescontractline Edm.String

(Deprecated) Shows the ID of the project contract line for this invoice line

Display Name: (Deprecated) Project Contract Line

msdyn_startdatetime Edm.DateTimeOffset

Enter the start date of the transaction.

Display Name: Start Date

msdyn_transactionclassification Edm.Int32

Transaction classification of the invoice line

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 of the invoice 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 Invoice Line Detail

Display Name: Status

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

Reason for the status of the Invoice 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 customer who this invoice will be sent to.

_msdyn_accountvendor_value msdyn_AccountVendor
_msdyn_bookableresource_value msdyn_bookableresource

Shows the resource.

_msdyn_contactcustomer_value msdyn_ContactCustomer

Select the customer who this invoice will be sent to.

_msdyn_contactvendor_value msdyn_ContactVendor
_msdyn_contractorganizationalunitid_value msdyn_contractorganizationalunitid

Select the organizational unit in charge of the related contract.

_msdyn_invoice_value msdyn_Invoice

The invoice to which this invoice line detail belongs.

_msdyn_invoicelineid_value msdyn_InvoiceLineId

Unique identifier for Invoice Line associated with Invoice Line Detail.

_msdyn_originalinvoicelinedetail_value msdyn_OriginalInvoiceLineDetail

The original transaction that is being corrected if this is a correction transaction.

_msdyn_pricelist_value msdyn_PriceList

Select the price list used for defaulting price on this transaction.

_msdyn_product_value msdyn_Product

Select the product on this invoice line transaction.

_msdyn_project_value msdyn_Project

Select the name of the project on which this transaction was created.

_msdyn_resourcecategory_value msdyn_ResourceCategory

Select the role that the user resource who logged this transaction worked as.

_msdyn_resourceorganizationalunitid_value msdyn_ResourceOrganizationalUnitId

Select the organizational unit at the time the entry was registered of the resource who performed the work.

_msdyn_salescontract_value msdyn_SalesContract

Select the name of the project contract that this invoice belongs to.

_msdyn_salescontractlineid_value msdyn_SalesContractLineId

Unique identifier for Order Line associated with Invoice Line Detail.

_msdyn_task_value msdyn_Task

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

_msdyn_transactioncategory_value msdyn_TransactionCategory

Select the category of the transaction.

_msdyn_unit_value msdyn_Unit

Select the unit of the transaction quantity.

_msdyn_unitschedule_value msdyn_UnitSchedule

Select the unit group of the invoice line transaction.

_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_invoicelinetransaction_createdby
createdonbehalfby systemuser lk_msdyn_invoicelinetransaction_createdonbehalfby
modifiedby systemuser lk_msdyn_invoicelinetransaction_modifiedby
modifiedonbehalfby systemuser lk_msdyn_invoicelinetransaction_modifiedonbehalfby
msdyn_AccountCustomer account msdyn_account_msdyn_invoicelinetransaction_AccountCustomer
msdyn_AccountVendor account msdyn_account_msdyn_invoicelinetransaction_AccountVendor
msdyn_bookableresource bookableresource msdyn_bookableresource_msdyn_invoicelinetransaction_bookableresource
msdyn_ContactCustomer contact msdyn_contact_msdyn_invoicelinetransaction_ContactCustomer
msdyn_ContactVendor contact msdyn_contact_msdyn_invoicelinetransaction_ContactVendor
msdyn_contractorganizationalunitid msdyn_organizationalunit msdyn_msdyn_organizationalunit_msdyn_invoicelinetransaction_ContractOrganizationalUnitId
msdyn_Invoice invoice msdyn_invoice_msdyn_invoicelinetransaction_Invoice
msdyn_InvoiceLineId invoicedetail msdyn_invoicedetail_msdyn_invoicelinetransactio
msdyn_OriginalInvoiceLineDetail msdyn_invoicelinetransaction msdyn_msdyn_invoicelinetransaction_msdyn_invoicelinetransaction_OriginalInvoiceLineDetail
msdyn_PriceList pricelevel msdyn_pricelevel_msdyn_invoicelinetransaction_PriceList
msdyn_Product product msdyn_product_msdyn_invoicelinetransaction_Product
msdyn_Project msdyn_project msdyn_msdyn_project_msdyn_invoicelinetransaction_Project
msdyn_ResourceCategory bookableresourcecategory msdyn_bookableresourcecategory_msdyn_invoicelinetransaction_ResourceCategory
msdyn_ResourceOrganizationalUnitId msdyn_organizationalunit msdyn_organizationalunit_invoicelinetransaction
msdyn_SalesContract salesorder msdyn_salesorder_msdyn_invoicelinetransaction_SalesContract
msdyn_SalesContractLineId salesorderdetail msdyn_salesorderdetail_msdyn_invoicelinetransac
msdyn_Task msdyn_projecttask msdyn_msdyn_projecttask_msdyn_invoicelinetransaction_Task
msdyn_TransactionCategory msdyn_transactioncategory msdyn_msdyn_transactioncategory_msdyn_invoicelinetransaction_TransactionCategory
msdyn_Unit uom msdyn_uom_msdyn_invoicelinetransaction_Unit
msdyn_UnitSchedule uomschedule msdyn_uomschedule_msdyn_invoicelinetransaction_UnitSchedule
ownerid principal owner_msdyn_invoicelinetransaction
owningbusinessunit businessunit business_unit_msdyn_invoicelinetransaction
owningteam team team_msdyn_invoicelinetransaction
owninguser systemuser user_msdyn_invoicelinetransaction
transactioncurrencyid transactioncurrency TransactionCurrency_msdyn_invoicelinetransaction

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_invoicelinetransaction_Annotations annotation objectid_msdyn_invoicelinetransaction
msdyn_invoicelinetransaction_AsyncOperations asyncoperation regardingobjectid_msdyn_invoicelinetransaction
msdyn_invoicelinetransaction_BulkDeleteFailures bulkdeletefailure regardingobjectid_msdyn_invoicelinetransaction
msdyn_invoicelinetransaction_DuplicateBaseRecord duplicaterecord baserecordid_msdyn_invoicelinetransaction
msdyn_invoicelinetransaction_DuplicateMatchingRecord duplicaterecord duplicaterecordid_msdyn_invoicelinetransaction
msdyn_invoicelinetransaction_MailboxTrackingFolders mailboxtrackingfolder regardingobjectid_msdyn_invoicelinetransaction
msdyn_invoicelinetransaction_PrincipalObjectAttributeAccesses principalobjectattributeaccess objectid_msdyn_invoicelinetransaction
msdyn_invoicelinetransaction_ProcessSession processsession regardingobjectid_msdyn_invoicelinetransaction
msdyn_invoicelinetransaction_SyncErrors syncerror regardingobjectid_msdyn_invoicelinetransaction
msdyn_msdyn_invoicelinetransaction_msdyn_invoicelinetransaction_OriginalInvoiceLineDetail msdyn_invoicelinetransaction msdyn_OriginalInvoiceLineDetail


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