Yardım Satınalma Raporu içerisine Muhasebe kodlarını getirme

SELECT
LEFT(CLCARD.DEFINITION_, 30)as [Soyadı (Unvanı)],
SUBSTRING(CLCARD.DEFINITION_, 31, LEN(CLCARD.DEFINITION_)) as [Adı (Unvanın Devamı)],
CASE WHEN LEN(CLCARD.LOGOID) > 10 THEN CLCARD.LOGOID ELSE '' END AS [Tc Kimlik No],
CLCARD.TAXNR as [Vergi Kimlik No],
STLINE.VATMATRAH [Vergiye Tabi Matrah],
(STLINE.VATMATRAH /100*18)-STLINE.VATAMNT  [Tevkif Tutarı(Kesinti Tutarı)],
STLINE.VAT [KDV %],
STLINE.DEDUCTIONPART1 AS [Pay],
STLINE.DEDUCTIONPART2 AS [Payda],
INVOICE.FICHENO [Fiş No],
CONVERT(nvarchar(20), INVOICE.DATE_,104) as Tarih,
CLCARD.CODE as [Cari Kod],

INVOICE.DOCODE [Evrak Numarası],
REPLACE(CONVERT(VARCHAR, CAST((STLINE.PRICE)* 1.0 AS MONEY), 1), '.', ',')  [Birim Fiyat],

REPLACE(CONVERT(VARCHAR, CAST((STLINE.VATAMNT)* 1.0 AS MONEY), 1), '.', ',')  [KDV Tutar],


STLINE.DEDUCTCODE AS [Kod] ,
CLCARD.TAXOFFICE as [Cari VDaire],
INVOICE.SPECODE as [Özel Kod],
EMUH.CODE as [Kod],
(SELECT CODE FROM LG_214_EMUHACC WHERE LOGICALREF=STLINE.VATACCREF) [Kdv Kodu],

INV.CODE as  [Stok Kodu]

FROM LG_000_01_INVOICE AS INVOICE WITH (NOLOCK)
RIGHT OUTER JOIN LG_000_01_STLINE AS STLINE ON INVOICE.LOGICALREF = STLINE.INVOICEREF
RIGHT OUTER JOIN LG_000_ITEMS INV ON INV.LOGICALREF=STLINE.STOCKREF
LEFT JOIN LG_000_SRVCARD SRV ON SRV.LOGICALREF=STLINE.STOCKREF
RIGHT OUTER JOIN LG_000_CLCARD CLCARD ON CLCARD.LOGICALREF=INVOICE.CLIENTREF
LEFT JOIN LG_000_EMUHACC EMUH ON EMUH.LOGICALREF=STLINE.ACCOUNTREF
RIGHT OUTER JOIN LG_000_UNITSETL UNT ON UNT.UNITSETREF=INV.UNITSETREF AND LINENR=1


WHERE(INVOICE.TRCODE IN(1,4,5,6,12,13,26))
AND INVOICE.DATE_ >= '2023-06-01 00:00:00.000'
AND INVOICE.DATE_ <= '2023-06-30 23:59:59.999'
AND STLINE.DEDUCTIONPART2 != ''
--AND STLINE.VAT != 0

order by INVOICE.FICHENO