Sales Item Profits

SQL-Vorlage aus der reybex-Standardbibliothek – für BAS23-Exportjobs und Ad-hoc-Tests.

← Alle Beispiel-SQLs

Abfrage

SELECT salesDocType.name,
salesHead.docNumber,
salesHead.docDate,
salesItem.shortDescription,
material.matCode,
material.sku,
material.name,
(salesItem.quantity * salesDocType.multiplier) as salesItem_quantity,
salesItem.purPrice,
salesItem.purValueForPurPrice,
salesItem.averagePrice,
salesItem.purValueForAveragePrice,
salesItem.lastPurPrice,
salesItem.purValueForLastPurPrice,
salesItem.aquisitionPrice,
salesItem.purValueForAquisitionPrice,
salesItem.costPrice,
salesItem.purValueForCostPrice,
salesItem.profit
FROM SalesHead salesHead
JOIN salesHead.items as salesItem
JOIN salesHead.docType as salesDocType
LEFT JOIN salesItem.material as material
WHERE salesHead.tenant_id = :tenantId
AND salesHead.isDelete = 0
AND salesItem.isDelete = 0
ORDER BY salesHead.dateCreated DESC, salesHead.docNumber DESC, salesItem.position, salesItem.isSetHead;