Query "Sales Order Analysis"
The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines.
Properties
| Name | Value |
|---|---|
| QueryType | Normal |
| DataAccessIntent | ReadOnly |
| UsageCategory | ReportsAndAnalysis |
| Caption | Sales Order Performance Analysis |
| AboutTitle | Sales Order Performance Analysis |
| AboutText | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| DocumentNo | Sales_Header | Code[20] | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| Status | Sales_Header | Enum Microsoft.Sales.Document."Sales Document Status" | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| ExternalDocumentNo | Sales_Header | Code[35] | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| SalespersonCode | Sales_Header | Code[20] | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| OrderDate | Sales_Header | Date | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| DueDate | Sales_Header | Date | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| DocumentDate | Sales_Header | Date | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| PostingDate | Sales_Header | Date | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| SellToCustomerNo | Sales_Header | Code[20] | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| SellToCustomerName | Sales_Header | Text[100] | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| BillToCustomerNo | Sales_Header | Code[20] | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| BillToCustomerName | Sales_Header | Text[100] | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| Type | Sales_Line | Enum Microsoft.Sales.Document."Sales Line Type" | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| No | Sales_Line | Code[20] | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| Description | Sales_Line | Text[100] | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| Quantity | Sales_Line | Decimal | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| UnitOfMeasureCode | Sales_Line | Code[10] | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| LocationCode | Sales_Line | Code[10] | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| VariantCode | Sales_Line | Code[10] | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| LineDiscountAmount | Sales_Line | Decimal | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| InvDiscountAmount | Sales_Line | Decimal | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| Amount | Sales_Line | Decimal | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| AmountIncludingVAT | Sales_Line | Decimal | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| CurrencyCode | Sales_Line | Code[10] | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| PlannedDeliveryDate | Sales_Line | Date | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| PlannedShipmentDate | Sales_Line | Date | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| ShipmentDate | Sales_Line | Date | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| QuantityShipped | Sales_Line | Decimal | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| QuantityInvoiced | Sales_Line | Decimal | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| OutstandingQty | Sales_Line | Decimal | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| QtyShippedNotInvoiced | Sales_Line | Decimal | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| OutstandingQtyBase | Sales_Line | Decimal | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| QtyShippedNotInvdBase | Sales_Line | Decimal | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| OutstandingAmount | Sales_Line | Decimal | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| ShippedNotInvoiced | Sales_Line | Decimal | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| OutstandingAmountLCY | Sales_Line | Decimal | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| ShippedNotInvoicedLCY | Sales_Line | Decimal | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| ShortcutDimension1Code | Sales_Line | Code[20] | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| ShortcutDimension2Code | Sales_Line | Code[20] | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |
| Name | Salesperson_Purchaser | Text[50] | The Sales Order Performance Analysis is a query that joins data from Sales Header to Sales Lines. |