Purchase Items

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

← Alle Beispiel-SQLs

Abfrage

SELECT
purDocType.name,
vendor.customer_no,
vendor.name
FROM pur_head as purHead
JOIN ltt_pur_doc_type as purDocType on purDocType.id = purHead.pur_doc_type_id
LEFT JOIN pur_item as purItem on purItem.pur_head_id = purHead.id
LEFT JOIN customer as vendor on vendor.id = purHead.vendor_id
WHERE purHead.tenant_id = :tenantId AND purHead.is_delete = 0;