salesorderdetail EntityType
Description: Line item in a sales order.
Entity Set path: [organization URI]/api/data/v8.0/salesorderdetails
Base Type: crmbaseentity EntityType
Display Name: Order Product
Primary Key: salesorderdetailid
Primary Name Attribute: productidname
Properties
Single-valued navigation properties
Collection-valued navigation properties
Operations bound to salesorderdetail
Operations using the salesorderdetail entity type.
Properties
Properties represent fields of data stored in the entity. Some properties are not writable.
| Name | Type | Details |
|---|---|---|
_createdby_value |
Edm.Guid |
Description: Shows who created the record. Computed property Read-only property |
_createdonbehalfby_value |
Edm.Guid |
Description: Shows who created the record on behalf of another user. Computed property Read-only property |
_modifiedby_value |
Edm.Guid |
Description: Shows who last updated the record. Computed property Read-only property |
_modifiedonbehalfby_value |
Edm.Guid |
Description: Shows who last updated the record on behalf of another user. Computed property Read-only property |
_ownerid_value |
Edm.Guid |
Description: Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Read-only property |
_productid_value |
Edm.Guid |
Description: Choose the product to include on the order to link the product's pricing and other information to the parent order. Computed property Read-only property |
_salesorderid_value |
Edm.Guid |
Description: 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. Computed property Read-only property |
_salesrepid_value |
Edm.Guid |
Description: Choose the user responsible for the sale of the order product. Computed property Read-only property |
_transactioncurrencyid_value |
Edm.Guid |
Description: Choose the local currency for the record to make sure budgets are reported in the correct currency. Computed property Read-only property |
_uomid_value |
Edm.Guid |
Description: Choose the unit of measurement for the base unit quantity for this purchase, such as each or dozen. Computed property Read-only property |
baseamount |
Edm.Decimal |
Description: Shows the total price of the order product, based on the price per unit, volume discount, and quantity. Display Name: Amount |
baseamount_base |
Edm.Decimal |
Description: Shows the Amount field converted to the system's default base currency. The calculation uses the exchange rate specified in the Currencies area. Display Name: Amount (Base) Read-only property |
createdon |
Edm.DateTimeOffset |
Description: Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options. Display Name: Created On Read-only property |
description |
Edm.String |
Description: Type additional information to describe the order product, such as manufacturing details or acceptable substitutions. Display Name: Description |
exchangerate |
Edm.Decimal |
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 Read-only property |
extendedamount |
Edm.Decimal |
Description: 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 |
extendedamount_base |
Edm.Decimal |
Description: Shows the Extended Amount field converted to the system's default base currency. The calculation uses the exchange rate specified in the Currencies area. Display Name: Extended Amount (Base) Read-only property |
importsequencenumber |
Edm.Int32 |
Description: Unique identifier of the data import or data migration that created this record. Display Name: Import Sequence Number |
iscopied |
Edm.Boolean |
Description: Select whether the invoice line item is copied from another item or data source. Default Options: 1 : Yes Display Name: Copied |
ispriceoverridden |
Edm.Boolean |
Description: 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. Default Options: 1 : Override Price Display Name: Pricing |
isproductoverridden |
Edm.Boolean |
Description: Select whether the product exists in the Microsoft Dynamics CRM product catalog or is a write-in product specific to the order. Default Options: 1 : Write In Display Name: Select Product |
lineitemnumber |
Edm.Int32 |
Description: 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 |
manualdiscountamount |
Edm.Decimal |
Description: 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 |
manualdiscountamount_base |
Edm.Decimal |
Description: Shows the Manual Discount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Display Name: Manual Discount (Base) Read-only property |
modifiedon |
Edm.DateTimeOffset |
Description: Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options. Display Name: Modified On Read-only property |
overriddencreatedon |
Edm.DateTimeOffset |
Description: Date and time that the record was migrated. Display Name: Record Created On |
owningbusinessunit |
Edm.Guid |
Description: Unique identifier of the business unit that owns the order product. Display Name: Owning Business Unit Read-only property |
owninguser |
Edm.Guid |
Description: Unique identifier of the user who owns the order product. Display Name: Owning User Read-only property |
parentbundleid |
Edm.Guid |
Description: Choose the parent bundle associated with this product Display Name: Parent Bundle |
priceperunit |
Edm.Decimal |
Description: 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 |
priceperunit_base |
Edm.Decimal |
Description: Shows the Price Per Unit field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Display Name: Price Per Unit (Base) Read-only property |
pricingerrorcode |
Edm.Int32 |
Description: Select the type of pricing error, such as a missing or invalid product, or missing quantity. Default Options: 0 : None Display Name: Pricing Error |
productassociationid |
Edm.Guid |
Description: Unique identifier of the product line item association with bundle in the sales order Display Name: Bundle Item Association |
productdescription |
Edm.String |
Description: Type a name or description to identify the type of write-in product included in the order. Display Name: Write-In Product |
producttypecode |
Edm.Int32 |
Description: Product Type Default Options: 1 : Product Display Name: Product type |
propertyconfigurationstatus |
Edm.Int32 |
Description: Status of the property configuration. Default Options: 0 : Edit Display Name: Property Configuration |
quantity |
Edm.Decimal |
Description: Type the amount or quantity of the product ordered by the customer. Display Name: Quantity |
quantitybackordered |
Edm.Decimal |
Description: Type the amount or quantity of the product that is back ordered for the order. Display Name: Quantity Back Ordered |
quantitycancelled |
Edm.Decimal |
Description: Type the amount or quantity of the product that was canceled. Display Name: Quantity Canceled |
quantityshipped |
Edm.Decimal |
Description: Type the amount or quantity of the product that was shipped for the order. Display Name: Quantity Shipped |
requestdeliveryby |
Edm.DateTimeOffset |
Description: Enter the delivery date requested by the customer for the order product. Display Name: Requested Delivery Date |
salesorderdetailid |
Edm.Guid |
Description: Unique identifier of the product specified in the order. Display Name: Order Product |
salesorderispricelocked |
Edm.Boolean |
Description: Tells whether product pricing is locked for the order. Default Options: 1 : Yes Display Name: Order Is Price Locked Read-only property |
salesorderstatecode |
Edm.Int32 |
Description: Shows the status of the order that the order detail is associated with. Default Options: 0 : Active Display Name: Order Status Read-only property |
sequencenumber |
Edm.Int32 |
Description: Shows the ID of the data that maintains the sequence. Display Name: Sequence Number |
shipto_addressid |
Edm.Guid |
Description: Unique identifier of the shipping address. Display Name: Ship To Address ID |
shipto_city |
Edm.String |
Description: Type the city for the customer's shipping address. Display Name: Ship To City |
shipto_contactname |
Edm.String |
Description: Type the primary contact name at the customer's shipping address. Display Name: Ship To Contact Name |
shipto_country |
Edm.String |
Description: Type the country or region for the customer's shipping address. Display Name: Ship To Country/Region |
shipto_fax |
Edm.String |
Description: Type the fax number for the customer's shipping address. Display Name: Ship To Fax |
shipto_freighttermscode |
Edm.Int32 |
Description: Select the freight terms to make sure shipping orders are processed correctly. Default Options: 1 : FOB Display Name: Freight Terms |
shipto_line1 |
Edm.String |
Description: Type the first line of the customer's shipping address. Display Name: Ship To Street 1 |
shipto_line2 |
Edm.String |
Description: Type the second line of the customer's shipping address. Display Name: Ship To Street 2 |
shipto_line3 |
Edm.String |
Description: Type the third line of the shipping address. Display Name: Ship To Street 3 |
shipto_name |
Edm.String |
Description: Type a name for the customer's shipping address, such as "Headquarters" or "Field office", to identify the address. Display Name: Ship To Name |
shipto_postalcode |
Edm.String |
Description: Type the ZIP Code or postal code for the shipping address. Display Name: Ship To ZIP/Postal Code |
shipto_stateorprovince |
Edm.String |
Description: Type the state or province for the shipping address. Display Name: Ship To State/Province |
shipto_telephone |
Edm.String |
Description: Type the phone number for the customer's shipping address. Display Name: Ship To Phone |
tax |
Edm.Decimal |
Description: Type the tax amount for the order product. Display Name: Tax |
tax_base |
Edm.Decimal |
Description: Shows the Tax field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Display Name: Tax (Base) Read-only property |
timezoneruleversionnumber |
Edm.Int32 |
Description: For internal use only. Display Name: Time Zone Rule Version Number |
utcconversiontimezonecode |
Edm.Int32 |
Description: Time zone code that was in use when the record was created. Display Name: UTC Conversion Time Zone Code |
versionnumber |
Edm.Int64 |
Description: Version number of the sales order detail. Display Name: Version Number Read-only property |
volumediscountamount |
Edm.Decimal |
Description: 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 Read-only property |
volumediscountamount_base |
Edm.Decimal |
Description: Shows the Volume Discount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Display Name: Volume Discount (Base) Read-only property |
willcall |
Edm.Boolean |
Description: 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. Default Options: 1 : Will Call Display Name: Ship To |
Single-valued navigation properties
Single-valued navigation properties represent lookup fields where a single entity can be referenced.
| Name | Type | Partner |
|---|---|---|
createdby |
lk_salesorderdetailbase_createdby |
|
createdonbehalfby |
lk_salesorderdetail_createdonbehalfby |
|
modifiedby |
lk_salesorderdetailbase_modifiedby |
|
modifiedonbehalfby |
lk_salesorderdetail_modifiedonbehalfby |
|
parentbundleid_salesorderdetail |
salesorderdetail_parent_salesorderdetail |
|
productassociationid_productassociation |
productAssociation_salesorder_details |
|
productid |
product_order_details |
|
salesorderid |
order_details |
|
salesrepid |
system_user_salesorderdetail |
|
transactioncurrencyid |
transactioncurrency_salesorderdetail |
|
uomid |
unit_of_measurement_order_details |
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 |
|---|---|---|
SalesOrderDetail_AsyncOperations |
regardingobjectid_salesorderdetail |
|
SalesOrderDetail_BulkDeleteFailures |
regardingobjectid_salesorderdetail |
|
salesorderdetail_parent_salesorderdetail |
parentbundleid_salesorderdetail |
Operations bound to salesorderdetail
The following operations are bound to the salesorderdetail entity type.
| Name | Bound to |
|---|---|
Entity |
Operations using the salesorderdetail entity type.
The following operations use the salesorderdetail entity type in a parameter or return type.
| Name | How used | Description |
|---|---|---|
entity Parameter |
Retrieve all the property instances (dynamic property instances) for a product added to an opportunity, quote, order, or invoice. |
Zie ook
Overige resources
Web API Action Reference
Web API Function Reference
Web API Query Function Reference
Web API EnumType Reference
Web API ComplexType Reference
Web API Metadata EntityType Reference
Microsoft Dynamics CRM 2016 and Microsoft Dynamics CRM Online
Send comments about this topic to Microsoft.
© 2015 Microsoft. All rights reserved.