Line item in a sales order.
- Entity Set Path
- [organization URI]/api/data/v9.0/salesorderdetails
- Base Type
- Display Name
- Order Line
- Primary Key
- Primary Key Attribute
- Operations Supported
- POST GET PATCH DELETE
Properties represent fields of data stored in the entity.Some properties are read-only.
Shows the total price of the order product, based on the price per unit, volume discount, and quantity.
Display Name: Amount
Value of the Amount in base currency.
Display Name: Amount (Base)
Date and time when the record was created.
Display Name: Created On
Type additional information to describe the order product, such as manufacturing details or acceptable substitutions.
Display Name: Description
Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
Display Name: Exchange Rate
Shows the total amount due for the order product, based on the sum of the unit price, quantity, discounts, and tax.
Display Name: Extended Amount
Value of the Extended Amount in base currency.
Display Name: Extended Amount (Base)
Sequence number of the import that created this record.
Display Name: Import Sequence Number
Select whether the invoice line item is copied from another item or data source.
Display Name: Copied
Select whether the price per unit is fixed at the value in the specified price list or can be overridden by users who have edit rights to the order product.
Display Name: Pricing
Select whether the product exists in the Microsoft Dynamics 365 product catalog or is a write-in product specific to the order.
Display Name: Select Product
Type the line item number for the order product to easily identify the product in the order and make sure it's listed in the correct sequence.
Display Name: Line Item Number
Type the manual discount amount for the order product to deduct any negotiated or other savings from the product total on the order.
Display Name: Manual Discount
Value of the Manual Discount in base currency.
Display Name: Manual Discount (Base)
Date and time when the record was modified.
Display Name: Modified On
Billing method for the project contract line. Valid values are Time and Material and Fixed Price
Display Name: Billing Method
Select the billing start date for the project contract line.
Display Name: Billing Start Date
Enter the amount the customer has set aside or is willing to pay for the project contract component.
Display Name: Budget Amount
Value of the Budget Amount in base currency.
Display Name: Budget Amount (Base)
Shows the total cost price of the product based on the cost price per unit and quantity.
Display Name: Cost Amount
Value of the Cost Amount in base currency.
Display Name: Cost Amount (Base)
Cost price per unit of the product. The default is the cost price of the product.
Display Name: Cost Price Per Unit
Value of the Cost Price Per Unit in base currency.
Display Name: Cost Price Per Unit (Base)
Select whether to include expenses in the project contract line.
Display Name: Include Expense
Select whether to include fees in the project contract line.
Display Name: Include Fee
Select whether to include materials in the project contract line.
Display Name: Include Material
Select whether to include time transactions in the project contract line.
Display Name: Include Time
The field to distinguish the order lines to be of project service or field service
Display Name: Line Type
Shows the quote line related to the project contract line.
Display Name: Quote Line
Date and time that the record was migrated.
Display Name: Record Created On
Choose the parent bundle associated with this product
Display Name: Parent Bundle
Type the price per unit of the order product. The default is the value in the price list specified on the order for existing products.
Display Name: Price Per Unit
Value of the Price Per Unit in base currency.
Display Name: Price Per Unit (Base)
Select the type of pricing error, such as a missing or invalid product, or missing quantity.
Display Name: Pricing Error
Unique identifier of the product line item association with bundle in the sales order
Display Name: Bundle Item Association
Type a name or description to identify the type of write-in product included in the order.
Display Name: Write-In Product
Calculated field that will be populated by name and description of the product.
Display Name: Product Name
Display Name: Product type
Status of the property configuration.
Display Name: Property Configuration
Type the amount or quantity of the product ordered by the customer.
Display Name: Quantity
Type the amount or quantity of the product that is back ordered for the order.
Display Name: Quantity Back Ordered
Type the amount or quantity of the product that was canceled.
Display Name: Quantity Canceled
Type the amount or quantity of the product that was shipped for the order.
Display Name: Quantity Shipped
Enter the delivery date requested by the customer for the order product.
Display Name: Requested Delivery Date
Unique identifier of the product specified in the order.
Display Name: Order Product
Tells whether product pricing is locked for the order.
Display Name: Order Is Price Locked
Shows the status of the order that the order detail is associated with.
Display Name: Order Status
Shows the ID of the data that maintains the sequence.
Display Name: Sequence Number
Unique identifier of the shipping address.
Display Name: Ship To Address ID
Type the city for the customer's shipping address.
Display Name: Ship To City
Type the primary contact name at the customer's shipping address.
Display Name: Ship To Contact Name
Type the country or region for the customer's shipping address.
Display Name: Ship To Country/Region
Type the fax number for the customer's shipping address.
Display Name: Ship To Fax
Select the freight terms to make sure shipping orders are processed correctly.
Display Name: Freight Terms
Type the first line of the customer's shipping address.
Display Name: Ship To Street 1
Type the second line of the customer's shipping address.
Display Name: Ship To Street 2
Type the third line of the shipping address.
Display Name: Ship To Street 3
Type a name for the customer's shipping address, such as "Headquarters" or "Field office", to identify the address.
Display Name: Ship To Name
Type the ZIP Code or postal code for the shipping address.
Display Name: Ship To ZIP/Postal Code
Type the state or province for the shipping address.
Display Name: Ship To State/Province
Type the phone number for the customer's shipping address.
Display Name: Ship To Phone
Type the tax amount for the order product.
Display Name: Tax
Value of the Tax in base currency.
Display Name: Tax (Base)
For internal use only.
Display Name: Time Zone Rule Version Number
Time zone code that was in use when the record was created.
Display Name: UTC Conversion Time Zone Code
Display Name: Version Number
Shows the discount amount per unit if a specified volume is purchased. Configure volume discounts in the Product Catalog in the Settings area.
Display Name: Volume Discount
Value of the Volume Discount in base currency.
Display Name: Volume Discount (Base)
Select whether the order product should be shipped to the specified address or held until the customer calls with further pick up or delivery instructions.
Display Name: Ship To
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|
Shows who created the record.
Shows who created the record on behalf of another user.
Shows who last updated the record.
Shows who last updated the record on behalf of another user.
Select a Agreement for this order line
Select the frequency for the automatic invoice creation job to create the invoice.
Select the project of the project contract line.
Unique identifier for the business unit that owns the record
Unique identifier for the team that owns the record.
Unique identifier for the user that owns the record.
Choose the product to include on the order to link the product's pricing and other information to the parent order.
Shows the order for the product. The ID is used to link product pricing and other details to the total amounts and other information on the order.
Choose the user responsible for the sale of the order product.
Choose the local currency for the record to make sure budgets are reported in the correct currency.
Choose the unit of measurement for the base unit quantity for this purchase, such as each or dozen.
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.
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.
The following operations can be used with the salesorderdetail entity type.
The following solutions include the salesorderdetail entity type.
|Field Service||Microsoft Dynamics 365 for Field Service allows organizations of any size to deliver intelligent, world class field service, managing all aspects of the end-to-end field service management cycle. Features include scheduling, mobile, asset management, inventory control, customer notifications, and resource utilization controls that help maximize efficiency and minimize costs.|
|Sales||Dynamics 365 workload for sales.|
|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.|