Query "Purch. Order Perf. Analysis"
The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data.
Properties
| Name | Value |
|---|---|
| QueryType | Normal |
| DataAccessIntent | ReadOnly |
| UsageCategory | ReportsAndAnalysis |
| Caption | Purchase Order Performance Analysis |
| AboutTitle | About Purchase Order Performance Analysis |
| AboutText | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| DocumentNo | PurchaseHeader | Code[20] | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| Status | PurchaseHeader | Enum Microsoft.Purchases.Document."Purchase Document Status" | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| VendorOrderNo | PurchaseHeader | Code[35] | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| PurchaserCode | PurchaseHeader | Code[20] | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| OrderDate | PurchaseHeader | Date | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| DueDate | PurchaseHeader | Date | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| DocumentDate | PurchaseHeader | Date | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| PostingDate | PurchaseHeader | Date | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| BuyFromVendorNo | PurchaseHeader | Code[20] | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| BuyFromVendorName | PurchaseHeader | Text[100] | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| PayToVendorNo | PurchaseHeader | Code[20] | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| PayToVendorName | PurchaseHeader | Text[100] | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| Type | PurchaseLine | Enum Microsoft.Purchases.Document."Purchase Line Type" | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| No | PurchaseLine | Code[20] | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| Description | PurchaseLine | Text[100] | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| Quantity | PurchaseLine | Decimal | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| UnitOfMeasureCode | PurchaseLine | Code[10] | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| LocationCode | PurchaseLine | Code[10] | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| VariantCode | PurchaseLine | Code[10] | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| LineDiscountAmount | PurchaseLine | Decimal | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| InvDiscountAmount | PurchaseLine | Decimal | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| Amount | PurchaseLine | Decimal | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| AmountIncludingVAT | PurchaseLine | Decimal | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| CurrencyCode | PurchaseLine | Code[10] | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| RequestedReceiptDate | PurchaseLine | Date | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| PromisedReceiptDate | PurchaseLine | Date | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| ExpectedReceiptDate | PurchaseLine | Date | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| QuantityReceived | PurchaseLine | Decimal | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| QuantityInvoiced | PurchaseLine | Decimal | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| OutstandingQuantity | PurchaseLine | Decimal | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| QtyRcdNotInvoiced | PurchaseLine | Decimal | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| OutstandingQtyBase | PurchaseLine | Decimal | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| QtyRcdNotInvoicedBase | PurchaseLine | Decimal | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| OutstandingAmount | PurchaseLine | Decimal | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| AmtRcdNotInvoiced | PurchaseLine | Decimal | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| OutstandingAmountLCY | PurchaseLine | Decimal | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| AmtRcdNotInvoicedLCY | PurchaseLine | Decimal | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| ShortcutDimension1Code | PurchaseLine | Code[20] | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| ShortcutDimension2Code | PurchaseLine | Code[20] | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |
| PurchaserName | SalespersonPurchaser | Text[50] | The Purchase Order Performance Analysis is a query that joins data from purchase order lines with vendor master data. |