SELECT dok_DataWyst AS [Data],
dok_NrPelny AS [Numer],
adr_Nazwa AS [Kontrahent],
dok_KwKarta AS [Kwota]
FROM dok__Dokument
LEFT JOIN adr__Ewid
ON adr_IdObiektu = dok_PlatnikId
AND adr_TypAdresu = 1
WHERE dok_KwKarta <> 0
AND dok_DataWyst BETWEEN {DR: data dokumentu: BIEZACY_DZIEN}
AND dok_MagId IN (
{CHL_DB: SELECT mag_Id,
mag_Nazwa
FROM sl_Magazyn
ORDER BY mag_Nazwa: Magazyn}
)
