Dataset: SalesOrderDetail
Dataset properties
| Property | Value |
| Data source name | AdventureWorks |
| Referenced data set | |
| Command type | Query |
Parameters
| Name |
| @SalesOrderNumber |
Fields
| Name | Source column | Data type | Caption | Value | Is calculated field |
| SalesOrderDetailID | SalesOrderDetailID | System.Int32 | |||
| OrderQty | OrderQty | System.Int16 | |||
| UnitPrice | UnitPrice | System.Decimal | |||
| UnitPriceDiscount | UnitPriceDiscount | System.Decimal | |||
| LineTotal | LineTotal | System.Decimal | |||
| CarrierTrackingNumber | CarrierTrackingNumber | System.String | |||
| SalesOrderID | SalesOrderID | System.Int32 | |||
| Name | Name | System.String | |||
| ProductNumber | ProductNumber | System.String |
Filters
Query
SELECT SOD.SalesOrderDetailID, SOD.OrderQty, SOD.UnitPrice, CASE WHEN SOD.UnitPriceDiscount IS NULL THEN 0 ELSE SOD.UnitPriceDiscount END AS UnitPriceDiscount, SOD.LineTotal, SOD.CarrierTrackingNumber, SOD.SalesOrderID, P.Name, P.ProductNumber FROM Sales.SalesOrderDetail SOD INNER JOIN Production.Product P ON SOD.ProductID = P.ProductID INNER JOIN Sales.SalesOrderHeader SOH ON SOD.SalesOrderID = SOH.SalesOrderID WHERE (SOH.SalesOrderNumber = @SalesOrderNumber) ORDER BY SOD.SalesOrderDetailID |
See also