Rapor üretici ile şu raporu ekleyiniz...XXX yazan yerlere firma numaranızı , XX yazan yerlere de dönem umaranızı ekleyiniz...
örnek 088 = XXX
01 = XX
SELECT
STL.LOGICALREF,
STL.DATE_ AS TARİH,
CC.DEFINITION_ AS ADI_SOYADI,
CC.TCKNO AS TC_Kimlik,
CC.TAXNR AS Vergi_Kimlik,
STOK.CODE AS 'Stok Kodu',
STL.VAT AS KDV_ORAN,
STL.VATMATRAH AS Vergiye_Tabii_Matrah,
(STL.VATMATRAH*((STL.VAT/100)+1))-STL.VATMATRAH AS 'Toplam Vergi',
STL.VATAMNT AS Tevkif_Edilen_KDV_Tutarı,
((STL.VATMATRAH*((STL.VAT/100)+1))-STL.VATMATRAH)-STL.VATAMNT AS 'Beyan Edilen KDV',
CASE (STL.CANDEDUCT)WHEN 1 THEN 'TEVKİFATLI'
WHEN 2 THEN 'TEVKİFATSIZ'
ELSE 'DİĞER'
END AS Tevkifat,
CONVERT(NVarchar,FTR.DEDUCTIONPART1)+'/'+CONVERT(NVarchar,FTR.DEDUCTIONPART2) AS 'Tevkifat Oranı'
FROM
LG_XXX_XX_STLINE AS STL JOIN LG_XXX_CLCARD AS CC ON CC.LOGICALREF=STL.CLIENTREF
JOIN LG_XXX_ITEMS AS STOK ON STOK.LOGICALREF=STL.STOCKREF JOIN LG_XXX_XX_INVOICE AS FTR
ON FTR.LOGICALREF=STL.INVOICEREF WHERE STOK.CODE LIKE '%770.%'