SalesOrderDetail
This is a table representing the SalesOrderDetail entities in Dynamics CRM.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier of the sales order detail. |
| BaseAmount | Double | True |
Price of the order product before discounts are applied and taxes are added. |
| BaseAmount_Base | Double | True |
Base currency equivalent of the price of the order product before discounts are applied and taxes are added. |
| CreatedBy_Id | String | True |
Unique identifier of the user who created the order product. |
| CreatedBy_LogicalName | String | True | |
| CreatedBy_Name | String | True | |
| CreatedOn | Datetime | True |
Date and time when the order product was created. |
| CreatedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who created the salesorderdetail. |
| CreatedOnBehalfBy_LogicalName | String | True | |
| CreatedOnBehalfBy_Name | String | True | |
| Description | String | False |
Description of the order product. |
| ExchangeRate | Double | True |
Exchange rate for the currency associated with the sales order detail with respect to the base currency. |
| ExtendedAmount | Double | True |
Subtotal of the order product after discounts are applied and taxes are added. |
| ExtendedAmount_Base | Double | True |
Base currency equivalent of the subtotal of the order product after discounts are applied and taxes are added. |
| ImportSequenceNumber | Integer | False |
Unique identifier of the data import or data migration that created this record. |
| IsCopied | Boolean | False |
Information that specifies whether the line was copied from a quote. |
| IsPriceOverridden | Boolean | False |
Information that specifies whether to override product catalog pricing. |
| IsProductOverridden | Boolean | False |
Information that specifies whether the product is a write-in product or an existing product. |
| LineItemNumber | Integer | False |
Line item number for the order product. |
| ManualDiscountAmount | Double | False |
Customized discount amount for the order product. |
| ManualDiscountAmount_Base | Double | True |
Base currency equivalent of the customized discount amount for the order product. |
| ModifiedBy_Id | String | True |
Unique identifier of the user who last modified the order product. |
| ModifiedBy_LogicalName | String | True | |
| ModifiedBy_Name | String | True | |
| ModifiedOn | Datetime | True |
Date and time when the order product was last modified. |
| ModifiedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who last modified the salesorderdetail. |
| ModifiedOnBehalfBy_LogicalName | String | True | |
| ModifiedOnBehalfBy_Name | String | True | |
| OverriddenCreatedOn | Datetime | False |
Date and time that the record was migrated. |
| OwnerId_Id | String | True |
Unique identifier of the user or team who owns the sales order detail. |
| OwnerId_LogicalName | String | True | |
| OwnerId_Name | String | True | |
| OwningBusinessUnit | String | True |
Unique identifier of the business unit that owns the order product. |
| OwningUser | String | True |
Unique identifier of the user who owns the order product. |
| PricePerUnit | Double | False |
Price per unit for the order product. |
| PricePerUnit_Base | Double | True |
Base currency equivalent of the price per unit for the order product. |
| PricingErrorCode | String | False |
Pricing error for the order product. |
| ProductDescription | String | False |
Product description for the order product. |
| ProductId_Id | String | False |
Unique identifier of the product associated with the order product. |
| ProductId_LogicalName | String | False | |
| ProductId_Name | String | False | |
| Quantity | Double | False |
Quantity specified for the order product. |
| QuantityBackordered | Double | False |
Quantity that has been backordered for the order product. |
| QuantityCancelled | Double | False |
Quantity that was canceled for the order product. |
| QuantityShipped | Double | False |
Quantity shipped for the product specified on the order. |
| RequestDeliveryBy | Datetime | False |
Requested delivery date for the order product. |
| SalesOrderDetailId | String | False |
Unique identifier of the product specified in the order. |
| SalesOrderId_Id | String | False |
Unique identifier of the order that is associated with the order product. |
| SalesOrderId_LogicalName | String | False | |
| SalesOrderId_Name | String | False | |
| SalesOrderIsPriceLocked | Boolean | True |
Information that specifies whether the order product pricing is locked. |
| SalesOrderStateCode | String | True |
Status of the order product. |
| SalesRepId_Id | String | False |
Unique identifier of the salesperson associated with the order product. |
| SalesRepId_LogicalName | String | False | |
| SalesRepId_Name | String | False | |
| ShipTo_AddressId | String | False |
Unique identifier of the shipping address. |
| ShipTo_City | String | False |
City name in the shipping address. |
| ShipTo_ContactName | String | False |
Contact name for the shipping address. |
| ShipTo_Country | String | False |
Country/region name in the shipping address. |
| ShipTo_Fax | String | False |
Fax number for the shipping address. |
| ShipTo_FreightTermsCode | String | False |
Freight terms for the shipping address. |
| ShipTo_Line1 | String | False |
First line for entering shipping address information. |
| ShipTo_Line2 | String | False |
Second line for entering shipping address information. |
| ShipTo_Line3 | String | False |
Third line for entering shipping address information. |
| ShipTo_Name | String | False |
Name to enter for the shipping address. |
| ShipTo_PostalCode | String | False |
ZIP Code or postal code in the shipping address. |
| ShipTo_StateOrProvince | String | False |
State or province in the shipping address. |
| ShipTo_Telephone | String | False |
Telephone number associated with the shipping address. |
| Tax | Double | False |
Tax amount for the order product. |
| Tax_Base | Double | True |
Base currency equivalent of the tax amount for the order product. |
| TimeZoneRuleVersionNumber | Integer | False |
For internal use only. |
| TransactionCurrencyId_Id | String | True |
Unique identifier of the currency associated with the sales order detail. |
| TransactionCurrencyId_LogicalName | String | True | |
| TransactionCurrencyId_Name | String | True | |
| UoMId_Id | String | False |
Unique identifier for the unit that is associated with the order product. |
| UoMId_LogicalName | String | False | |
| UoMId_Name | String | False | |
| UTCConversionTimeZoneCode | Integer | False |
Time zone code that was in use when the record was created. |
| VolumeDiscountAmount | Double | True |
Volume discount amount for the order product. |
| VolumeDiscountAmount_Base | Double | True |
Base currency equivalent of the volume discount amount for the order product. |
| WillCall | Boolean | False |
Specifies whether the customer will call for the ordered products or the products are to be shipped. |