Kapanış Fişinde kuruş farkı- Edefter
SELECT EMF.ACCOUNTCODE AS SATIR_HESAP, EF.FICHENO AS FIS_NO, EF.DATE_ AS FIS_TARIHI, CONVERT(Decimal(30,10),EMF.DEBIT) AS DEBIT_HATALI, CONVERT(Decimal(30,10),EMF.CREDIT) AS CREDIT_HATALI, EMF.DEBIT, EMF.CREDIT from LG_305_01_EMFLINE EMF INNER JOIN LG_305_01_EMFICHE EF ON EMF.ACCFICHEREF=EF.LOGICALREF WHERE EMF.DEBIT<0.001 AND EMF.CREDIT<0.001 AND ((convert(binary(8), EMF.DEBIT)0x0000000000000000 AND convert(binary(8), EMF.CREDIT)=0x0000000000000000 ) OR (convert(binary(8), EMF.CREDIT)0x0000000000000000 AND convert(binary(8),EMF.DEBIT)=0x0000000000000000 ))
.JPG)
