<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="5.3.16" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Varsayılan" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="42521,4398687269" ReportOptions.Description.Text="" ReportOptions.LastChange="42783,6927910301" ScriptLanguage="PascalScript" ScriptText.Text="procedure MasterData1OnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin   &#13;&#10;  DetailData1.Visible:= (ekstreDetayQ.RecordCount &#62; 0) and (&#60;Ekstre.&#34;ISLEMTIPI&#34;&#62; in [2, 3, 4, 5, 157, 158, 238, 242, 243, 239, 257]);&#13;&#10;  DetailData2.Visible:= (ekstreDetayQ.RecordCount &#62; 0) and (&#60;Ekstre.&#34;ISLEMTIPI&#34;&#62; in [0, 1, 11, 12]);&#13;&#10;&#13;&#10;  Header1.Visible:= DetailData1.Visible;&#13;&#10;  Footer1.Visible:= DetailData1.Visible;&#13;&#10;&#13;&#10;  Header2.Visible:= DetailData2.Visible;&#13;&#10;  Footer2.Visible:= DetailData2.Visible;     &#13;&#10;end;&#13;&#10;&#13;&#10;procedure Footer1OnBeforePrint(Sender: TfrxComponent);&#13;&#10;Var&#13;&#10;  S, T: String;&#13;&#10;  V: Variant;                         &#13;&#10;  R: Real;&#13;&#10;begin&#13;&#10;  if not (&#60;Detay.&#34;ISLEMTIPI&#34;&#62; in [2,3,4,5, 157, 158, 242, 243]) Then Exit;&#13;&#10;    &#13;&#10;  Case &#60;Detay.&#34;ISLEMTIPI&#34;&#62; Of&#13;&#10;      2: T:= 'SATFAT';&#13;&#10;      3: T:= 'ALFAT';&#13;&#10;      4: T:= 'SATFATIADE';&#13;&#10;      5: T:= 'ALFATIADE';&#13;&#10;    157: T:= 'SATIRS';&#13;&#10;    158: T:= 'ALIRS';&#13;&#10;    242: T:= 'SATIRSIADE';&#13;&#10;    243: T:= 'ALIRSIADE';        &#13;&#10;  End;&#13;&#10;  S:= 'SELECT ISNULL(SATIRISKONTOSU, 0) + ' + &#13;&#10;    ' ISNULL(ALTISKONTO1, 0) + ISNULL(ALTISKONTO2, 0) FROM TBL' + T + 'BASLIK ' + &#13;&#10;    ' WHERE KARTNO = ' + IntToStr(&#60;Detay.&#34;KARTNO&#34;&#62;);&#13;&#10;  V:= GetDBValue(S);&#13;&#10;&#13;&#10;  R:= 0;                 &#13;&#10;  if VarToStr(V) &#60;&#62; '' Then&#13;&#10;    R:= V;&#13;&#10;&#13;&#10;  if R &#60;&#62; 0 Then                                                               &#13;&#10;    Memo21.Text:= FormatFloat('#,#0.#0', R)&#13;&#10;  Else&#13;&#10;    Memo21.Text:= '';&#13;&#10;&#13;&#10;  S:= 'SELECT KDV FROM TBL' + T + 'BASLIK ' + &#13;&#10;    ' WHERE KARTNO = ' + IntToStr(&#60;Detay.&#34;KARTNO&#34;&#62;);&#13;&#10;  V:= GetDBValue(S);&#13;&#10;&#13;&#10;  R:= 0;                 &#13;&#10;  if VarToStr(V) &#60;&#62; '' Then&#13;&#10;    R:= V;&#13;&#10;&#13;&#10;  if R &#60;&#62; 0 Then                                                               &#13;&#10;    Memo23.Text:= FormatFloat('#,#0.#0', R)&#13;&#10;  Else&#13;&#10;    Memo23.Text:= '';             &#13;&#10;end;&#13;&#10;&#13;&#10;procedure EkstreTLALACAKOnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;     if &#60;Ekstre.&#34;ISLEMTIPI&#34;&#62; &#60; 0 Then&#13;&#10;    EkstreTLALACAK.Text:= ''&#13;&#10;  else                  &#13;&#10;    EkstreTLALACAK.Text:= '[IIF(&#60;Ekstre.&#34;BORC&#34;&#62; &#62; 0, &#60;Ekstre.&#34;BORC&#34;&#62;, &#60;Ekstre.&#34;ALACAK&#34;&#62;)]'&#13;&#10;        end;&#13;&#10;&#13;&#10;procedure DetailData1OnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;end;&#13;&#10;&#13;&#10;begin&#13;&#10;  QueryLoadAllRecords(ekstreQ);&#13;&#10;    &#13;&#10;  ekstreQ.Active:= True;&#13;&#10;  CalcCariHesapDetay(ekstreQ);         &#13;&#10;end.  ">
  <Datasets>
    <item DataSet="ekstreQ" DataSetName="Ekstre"/>
    <item DataSet="ekstreDetayQ" DataSetName="Detay"/>
    <item DataSet="cariQ" DataSetName="Cari Kart"/>
  </Datasets>
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDQuery Name="ekstreQ" UserName="Ekstre" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text=" SET DATEFORMAT DMY &#13;&#10;  &#13;&#10; DECLARE @CARIID INT, @T1 DATETIME, @T2 DATETIME &#13;&#10;  &#13;&#10; SET @CARIID = :CARIID             &#13;&#10; SET @T1 = :TARIH1&#13;&#10; SET @T2 = :TARIH2            &#13;&#10;&#13;&#10;SELECT &#13;&#10;  ID, ISLEMTIPI, CARIID, KAYITTARIHI, KARTNO,  TARIH, BELGENO, ISLEM, DOVIZ,&#13;&#10;  AY, YIL,  TLDURUM, CARIDURUM, TUTARI,KUR, ALACAK, BORC, TLALACAK, TLBORC, CARIBORC, CARIALACAK&#13;&#10;FROM CARIDOKUM &#13;&#10;WHERE CARIID =  @CARIID AND CONVERT(VARCHAR, TARIH, 104) BETWEEN @T1 AND @T2 &#13;&#10;UNION ALL&#13;&#10;SELECT &#13;&#10;    0, -1, @CARIID, @T1 - 1, 0, @T1 - 1, '', 'DEVİR', 'TL', MONTH(@T1-1), YEAR(@T1-1), '', '',&#13;&#10;	0, 1, SUM(ALACAK), SUM(BORC), SUM(TLALACAK), SUM(TLBORC), SUM(CARIBORC), SUM(CARIALACAK)&#13;&#10;FROM CARIDOKUM&#13;&#10;WHERE CARIID = @CARIID AND TARIH &#60; @T1&#13;&#10;ORDER BY TARIH                                " PropData="05704C65667402440470546F7002300A506172616D657465727301010623204E616D653D22434152494944222044617461547970653D226674496E74656765722200010624204E616D653D22544152494831222044617461547970653D2266744461746554696D652200010624204E616D653D22544152494832222044617461547970653D2266744461746554696D65220000"/>
    <TfrxFDQuery Name="ekstreDetayQ" UserName="Detay" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Filtered="True" Master="ekstreQ" IgnoreDupParams="False" SQL.Text="SET DATEFORMAT DMY &#13;&#10;&#13;&#10;DECLARE @CARIID INT, @T1 DATETIME, @T2 DATETIME&#13;&#10;  &#13;&#10;SET @CARIID = :CARIID                  &#13;&#10;SET @T1 = :TARIH1                                           &#13;&#10;SET @T2 = :TARIH2                  &#13;&#10;       &#13;&#10;SELECT * FROM( &#13;&#10;   SELECT   &#13;&#10;     ACIKLAMA, ISLEMTIPI, KARTNO, ISLEM, TARIH, BELGENO, STOKKODU, CINSI, MIKTARI, BIRIMADI, NETFIYAT * ((KDV + 100.0000) / 100.0000) AS FIYATI,  &#13;&#10;     CASE WHEN ISLEMTIPI IN (0, 2, 5, 11, 20, 257, 157, 243)  THEN NETTUTAR * ((KDV + 100.0000) / 100.0000) ELSE NULL END AS BORC,  &#13;&#10;     CASE WHEN ISLEMTIPI IN (1, 3, 4, 12, 239, 158, 242) THEN NETTUTAR * ((KDV + 100.0000) / 100.0000) ELSE NULL END AS ALACAK  &#13;&#10;   FROM(  &#13;&#10;   SELECT   &#13;&#10;     H.ACIKLAMA, 2 AS ISLEMTIPI, B.KARTNO, 'SATIŞ' AS ISLEM, B.TARIH, B.BELGENO, S.STOKKODU, S.CINSI,   &#13;&#10;     H.MIKTARI, BR.BIRIMADI, H.KDV,   &#13;&#10;     H.FIYATI,   &#13;&#10;     ROUND(dbo.ISKONTODUS(dbo.ISKONTODUS(H.MIKTARI * H.FIYATI - H.ISKONTOTOPLAMI, B.ALTISKONTO1Y), B.ALTISKONTO2Y) /  &#13;&#10;        CASE when ISNULL(H.MIKTARI, 0) = 0 THEN 1 ELSE H.MIKTARI END, 4) AS NETFIYAT,   &#13;&#10;     H.FIYATI * H.MIKTARI AS TUTARI,  &#13;&#10;     ROUND(dbo.ISKONTODUS(dbo.ISKONTODUS(H.MIKTARI * H.FIYATI - H.ISKONTOTOPLAMI, B.ALTISKONTO1Y), B.ALTISKONTO2Y), 4) AS NETTUTAR  &#13;&#10;   FROM TBLSATFATHAREKET H  &#13;&#10;   LEFT OUTER JOIN TBLSATFATBASLIK B WITH(INDEX=TBLSATFATBASLIK_KARTNO) ON B.KARTNO = H.FATURAID  &#13;&#10;   LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = H.STOKID  &#13;&#10;   LEFT OUTER JOIN TBLBIRIMLEREX BR WITH(INDEX=TBLBIRIMLEREX_KARTNO) ON BR.KARTNO = H.BIRIMID  &#13;&#10;   WHERE ISNULL(B.DELETED, 0) = 0 AND B.CARIID = @CARIID AND B.TARIH BETWEEN @T1 AND @T2  &#13;&#10;  UNION ALL &#13;&#10;  SELECT   &#13;&#10;     H.ACIKLAMA, 3, B.KARTNO, 'ALIŞ' AS ISLEM, B.TARIH, B.BELGENO, S.STOKKODU, S.CINSI,   &#13;&#10;     H.MIKTARI, BR.BIRIMADI, H.KDV,   &#13;&#10;     H.FIYATI,   &#13;&#10;     ROUND(dbo.ISKONTODUS(dbo.ISKONTODUS(H.MIKTARI * H.FIYATI - H.ISKONTOTOPLAMI, B.ALTISKONTO1Y), B.ALTISKONTO2Y) /  &#13;&#10;         CASE when ISNULL(H.MIKTARI, 0) = 0 THEN 1 ELSE H.MIKTARI END, 4) AS NETFIYAT, &#13;&#10;     H.FIYATI * H.MIKTARI AS TUTARI,  &#13;&#10;     ROUND(dbo.ISKONTODUS(dbo.ISKONTODUS(H.MIKTARI * H.FIYATI - H.ISKONTOTOPLAMI, B.ALTISKONTO1Y), B.ALTISKONTO2Y), 4) AS NETTUTAR  &#13;&#10;   FROM TBLALFATHAREKET H  &#13;&#10;   LEFT OUTER JOIN TBLALFATBASLIK B WITH(INDEX=TBLALFATBASLIK_KARTNO) ON B.KARTNO = H.FATURAID  &#13;&#10;   LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = H.STOKID  &#13;&#10;   LEFT OUTER JOIN TBLBIRIMLEREX BR WITH(INDEX=TBLBIRIMLEREX_KARTNO) ON BR.KARTNO = H.BIRIMID  &#13;&#10;   WHERE ISNULL(B.DELETED, 0) = 0 AND B.CARIID = @CARIID AND B.TARIH BETWEEN @T1 AND @T2  &#13;&#10;  UNION ALL &#13;&#10;  SELECT   &#13;&#10;     H.ACIKLAMA, 4, B.KARTNO, 'SATIŞ İADE' AS ISLEM, B.TARIH, B.BELGENO, S.STOKKODU, S.CINSI,   &#13;&#10;     H.MIKTARI, BR.BIRIMADI, H.KDV,   &#13;&#10;     H.FIYATI,   &#13;&#10;     ROUND(dbo.ISKONTODUS(dbo.ISKONTODUS(H.MIKTARI * H.FIYATI - H.ISKONTOTOPLAMI, B.ALTISKONTO1Y), B.ALTISKONTO2Y) /  &#13;&#10;         CASE when ISNULL(H.MIKTARI, 0) = 0 THEN 1 ELSE H.MIKTARI END, 4) AS NETFIYAT, &#13;&#10;     H.FIYATI * H.MIKTARI AS TUTARI,  &#13;&#10;     ROUND(dbo.ISKONTODUS(dbo.ISKONTODUS(H.MIKTARI * H.FIYATI - H.ISKONTOTOPLAMI, B.ALTISKONTO1Y), B.ALTISKONTO2Y), 4) AS NETTUTAR  &#13;&#10;   FROM TBLSATFATIADEHAREKET H  &#13;&#10;   LEFT OUTER JOIN TBLSATFATIADEBASLIK B WITH(INDEX=TBLSATFATIADEBASLIK_KARTNO) ON B.KARTNO = H.FATURAID  &#13;&#10;   LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = H.STOKID  &#13;&#10;   LEFT OUTER JOIN TBLBIRIMLEREX BR WITH(INDEX=TBLBIRIMLEREX_KARTNO) ON BR.KARTNO = H.BIRIMID  &#13;&#10;   WHERE ISNULL(B.DELETED, 0) = 0 AND B.CARIID = @CARIID AND B.TARIH BETWEEN @T1 AND @T2  &#13;&#10;  UNION ALL &#13;&#10;  SELECT   &#13;&#10;     H.ACIKLAMA, 5 AS ISLEMTIPI, B.KARTNO, 'ALIŞ İADE' AS ISLEM, B.TARIH, B.BELGENO, S.STOKKODU, S.CINSI,   &#13;&#10;     H.MIKTARI, BR.BIRIMADI, H.KDV,   &#13;&#10;     H.FIYATI,   &#13;&#10;     ROUND(dbo.ISKONTODUS(dbo.ISKONTODUS(H.MIKTARI * H.FIYATI - H.ISKONTOTOPLAMI, B.ALTISKONTO1Y), B.ALTISKONTO2Y) /  &#13;&#10;         CASE when ISNULL(H.MIKTARI, 0) = 0 THEN 1 ELSE H.MIKTARI END, 4) AS NETFIYAT, &#13;&#10;     H.FIYATI * H.MIKTARI AS TUTARI,  &#13;&#10;     ROUND(dbo.ISKONTODUS(dbo.ISKONTODUS(H.MIKTARI * H.FIYATI - H.ISKONTOTOPLAMI, B.ALTISKONTO1Y), B.ALTISKONTO2Y), 4) AS NETTUTAR  &#13;&#10;   FROM TBLALFATIADEHAREKET H  &#13;&#10;   LEFT OUTER JOIN TBLALFATIADEBASLIK B WITH(INDEX=TBLALFATIADEBASLIK_KARTNO) ON B.KARTNO = H.FATURAID  &#13;&#10;   LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = H.STOKID  &#13;&#10;   LEFT OUTER JOIN TBLBIRIMLEREX BR WITH(INDEX=TBLBIRIMLEREX_KARTNO) ON BR.KARTNO = H.BIRIMID  &#13;&#10;   WHERE ISNULL(B.DELETED, 0) = 0 AND B.CARIID = @CARIID AND B.TARIH BETWEEN @T1 AND @T2  &#13;&#10;&#13;&#10;  UNION ALL  &#13;&#10;  SELECT   &#13;&#10;    H.ACIKLAMA, 157 AS ISLEMTIPI, B.KARTNO, 'SATIŞ İRSALİYESİ' AS ISLEM, B.TARIH, B.BELGENO, S.STOKKODU, S.CINSI,   &#13;&#10;    H.MIKTARI, BR.BIRIMADI, H.KDV,   &#13;&#10;    H.FIYATI,   &#13;&#10;    ROUND(dbo.ISKONTODUS(dbo.ISKONTODUS(H.MIKTARI * H.FIYATI - H.ISKONTOTOPLAMI, B.ALTISKONTO1Y), B.ALTISKONTO2Y) /  &#13;&#10;       CASE when ISNULL(H.MIKTARI, 0) = 0 THEN 1 ELSE H.MIKTARI END, 4) AS NETFIYAT,   &#13;&#10;    H.FIYATI * H.MIKTARI AS TUTARI,  &#13;&#10;    ROUND(dbo.ISKONTODUS(dbo.ISKONTODUS(H.MIKTARI * H.FIYATI - H.ISKONTOTOPLAMI, B.ALTISKONTO1Y), B.ALTISKONTO2Y), 4) AS NETTUTAR  &#13;&#10;  FROM TBLSATIRSHAREKET H  &#13;&#10;  LEFT OUTER JOIN TBLSATIRSBASLIK B WITH(INDEX=TBLSATIRSBASLIK_KARTNO) ON B.KARTNO = H.FATURAID  &#13;&#10;  LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = H.STOKID  &#13;&#10;  LEFT OUTER JOIN TBLBIRIMLEREX BR WITH(INDEX=TBLBIRIMLEREX_KARTNO) ON BR.KARTNO = H.BIRIMID  &#13;&#10;  WHERE ISNULL(B.DELETED, 0) = 0 AND ISNULL(B.FATURALASTI, 0) = 0 AND B.CARIID = @CARIID AND B.TARIH BETWEEN @T1 AND @T2  &#13;&#10;  UNION ALL  &#13;&#10;  SELECT   &#13;&#10;    H.ACIKLAMA, 158, B.KARTNO, 'ALIŞ İRSALİYESİ' AS ISLEM, B.TARIH, B.BELGENO, S.STOKKODU, S.CINSI,   &#13;&#10;    H.MIKTARI, BR.BIRIMADI, H.KDV,   &#13;&#10;    H.FIYATI,   &#13;&#10;    ROUND(dbo.ISKONTODUS(dbo.ISKONTODUS(H.MIKTARI * H.FIYATI - H.ISKONTOTOPLAMI, B.ALTISKONTO1Y), B.ALTISKONTO2Y) /  &#13;&#10;        CASE when ISNULL(H.MIKTARI, 0) = 0 THEN 1 ELSE H.MIKTARI END, 4) AS NETFIYAT,   &#13;&#10;    H.FIYATI * H.MIKTARI AS TUTARI,  &#13;&#10;    ROUND(dbo.ISKONTODUS(dbo.ISKONTODUS(H.MIKTARI * H.FIYATI - H.ISKONTOTOPLAMI, B.ALTISKONTO1Y), B.ALTISKONTO2Y), 4) AS NETTUTAR  &#13;&#10;  FROM TBLALIRSHAREKET H  &#13;&#10;  LEFT OUTER JOIN TBLALIRSBASLIK B WITH(INDEX=TBLALIRSBASLIK_KARTNO) ON B.KARTNO = H.FATURAID  &#13;&#10;  LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = H.STOKID  &#13;&#10;  LEFT OUTER JOIN TBLBIRIMLEREX BR WITH(INDEX=TBLBIRIMLEREX_KARTNO) ON BR.KARTNO = H.BIRIMID  &#13;&#10;  WHERE ISNULL(B.DELETED, 0) = 0 AND ISNULL(B.FATURALASTI, 0) = 0 AND B.CARIID = @CARIID AND B.TARIH BETWEEN @T1 AND @T2  &#13;&#10;  UNION ALL   &#13;&#10;  SELECT   &#13;&#10;    H.ACIKLAMA, 242, B.KARTNO, 'SATIŞ İADE İRSALİYESİ' AS ISLEM, B.TARIH, B.BELGENO, S.STOKKODU, S.CINSI,   &#13;&#10;    H.MIKTARI, BR.BIRIMADI, H.KDV,   &#13;&#10;    H.FIYATI,   &#13;&#10;    ROUND(dbo.ISKONTODUS(dbo.ISKONTODUS(H.MIKTARI * H.FIYATI - H.ISKONTOTOPLAMI, B.ALTISKONTO1Y), B.ALTISKONTO2Y) /  &#13;&#10;        CASE when ISNULL(H.MIKTARI, 0) = 0 THEN 1 ELSE H.MIKTARI END, 4) AS NETFIYAT,   &#13;&#10;    H.FIYATI * H.MIKTARI AS TUTARI,  &#13;&#10;    ROUND(dbo.ISKONTODUS(dbo.ISKONTODUS(H.MIKTARI * H.FIYATI - H.ISKONTOTOPLAMI, B.ALTISKONTO1Y), B.ALTISKONTO2Y), 4) AS NETTUTAR  &#13;&#10;  FROM TBLSATIRSIADEHAREKET H  &#13;&#10;  LEFT OUTER JOIN TBLSATIRSIADEBASLIK B WITH(INDEX=TBLSATIRSIADEBASLIK_KARTNO) ON B.KARTNO = H.FATURAID  &#13;&#10;  LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = H.STOKID  &#13;&#10;  LEFT OUTER JOIN TBLBIRIMLEREX BR WITH(INDEX=TBLBIRIMLEREX_KARTNO) ON BR.KARTNO = H.BIRIMID  &#13;&#10;  WHERE ISNULL(B.DELETED, 0) = 0 AND ISNULL(B.FATURALASTI, 0) = 0 AND B.CARIID = @CARIID AND B.TARIH BETWEEN @T1 AND @T2  &#13;&#10;  UNION ALL   &#13;&#10;  SELECT   &#13;&#10;    H.ACIKLAMA, 243 AS ISLEMTIPI, B.KARTNO, 'ALIŞ İADE İRSALİYESİ' AS ISLEM, B.TARIH, B.BELGENO, S.STOKKODU, S.CINSI,   &#13;&#10;    H.MIKTARI, BR.BIRIMADI, H.KDV,   &#13;&#10;    H.FIYATI,   &#13;&#10;    ROUND(dbo.ISKONTODUS(dbo.ISKONTODUS(H.MIKTARI * H.FIYATI - H.ISKONTOTOPLAMI, B.ALTISKONTO1Y), B.ALTISKONTO2Y) /  &#13;&#10;        CASE when ISNULL(H.MIKTARI, 0) = 0 THEN 1 ELSE H.MIKTARI END, 4) AS NETFIYAT,   &#13;&#10;    H.FIYATI * H.MIKTARI AS TUTARI,  &#13;&#10;    ROUND(dbo.ISKONTODUS(dbo.ISKONTODUS(H.MIKTARI * H.FIYATI - H.ISKONTOTOPLAMI, B.ALTISKONTO1Y), B.ALTISKONTO2Y), 4) AS NETTUTAR  &#13;&#10;  FROM TBLALIRSIADEHAREKET H  &#13;&#10;  LEFT OUTER JOIN TBLALIRSIADEBASLIK B WITH(INDEX=TBLALIRSIADEBASLIK_KARTNO) ON B.KARTNO = H.FATURAID  &#13;&#10;  LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = H.STOKID  &#13;&#10;  LEFT OUTER JOIN TBLBIRIMLEREX BR WITH(INDEX=TBLBIRIMLEREX_KARTNO) ON BR.KARTNO = H.BIRIMID  &#13;&#10;  WHERE ISNULL(B.DELETED, 0) = 0 AND ISNULL(B.FATURALASTI, 0) = 0 AND B.CARIID = @CARIID AND B.TARIH BETWEEN @T1 AND @T2 &#13;&#10;&#13;&#10;   ) AS A  &#13;&#10;   UNION ALL  &#13;&#10;   SELECT   &#13;&#10;     H.ACIKLAMA, 1, B.KARTNO, 'TAHSİLAT', TARIH, BELGENO, 'TAHSİLAT',   &#13;&#10;     CASE H.ISLEM   &#13;&#10;       WHEN 0 THEN 'NAKİT'  &#13;&#10;       WHEN 1 THEN 'ÇEK'  &#13;&#10;       WHEN 2 THEN 'SENET'  &#13;&#10;       WHEN 3 THEN 'VİSA'  &#13;&#10;       WHEN 7 THEN 'DEKONT'  &#13;&#10;     END + '\' + H.ACIKLAMA, NULL, NULL, NULL,  &#13;&#10;     NULL, H.TUTAR &#13;&#10;   FROM TBLCARIGIRISDETAY H  &#13;&#10;   LEFT OUTER JOIN TBLCARIGIRIS B WITH(INDEX=TBLCARIGIRIS_KARTNO) ON B.KARTNO = H.BASLIKID  &#13;&#10;   WHERE ISNULL(B.DELETED, 0) = 0 AND B.CARIID = @CARIID AND B.TARIH BETWEEN @T1 AND @T2  &#13;&#10;  UNION ALL &#13;&#10;   SELECT   &#13;&#10;     H.ACIKLAMA, 0, B.KARTNO, 'ÖDEME', TARIH, BELGENO, 'ÖDEME',   &#13;&#10;     CASE H.ISLEM   &#13;&#10;       WHEN 0 THEN 'NAKİT'  &#13;&#10;       WHEN 1 THEN 'ÇEK'  &#13;&#10;       WHEN 2 THEN 'SENET'  &#13;&#10;       WHEN 3 THEN 'VİSA'  &#13;&#10;       WHEN 4 THEN 'ŞAHSİ ÇEK'  &#13;&#10;       WHEN 5 THEN 'ŞAHSİ SENET'  &#13;&#10;       WHEN 6 THEN 'ŞAHSİ VİSA'  &#13;&#10;       WHEN 7 THEN 'DEKONT'  &#13;&#10;       WHEN 9 THEN 'ÇEK'  &#13;&#10;       WHEN 4 THEN 'SENET'  &#13;&#10;     END + '\' + H.ACIKLAMA, NULL, NULL, NULL,  &#13;&#10;     H.TUTAR, NULL &#13;&#10;   FROM TBLCARICIKISDETAY H  &#13;&#10;   LEFT OUTER JOIN TBLCARICIKIS B WITH(INDEX=TBLCARICIKIS_KARTNO) ON B.KARTNO = H.BASLIKID  &#13;&#10;   WHERE ISNULL(B.DELETED, 0) = 0 AND B.CARIID = @CARIID AND B.TARIH BETWEEN @T1 AND @T2  &#13;&#10;  UNION ALL &#13;&#10;  SELECT   &#13;&#10;     H.ACIKLAMA, 11, B.KARTNO, 'ÖDEME İADE', TARIH, BELGENO, 'ÖDEME İADE',   &#13;&#10;     CASE H.ISLEM   &#13;&#10;       WHEN 0 THEN 'NAKİT'  &#13;&#10;       WHEN 1 THEN 'ÇEK'  &#13;&#10;       WHEN 2 THEN 'SENET'  &#13;&#10;       WHEN 3 THEN 'VİSA'  &#13;&#10;       WHEN 4 THEN 'ŞAHSİ ÇEK'  &#13;&#10;       WHEN 5 THEN 'ŞAHSİ SENET'  &#13;&#10;       WHEN 6 THEN 'ŞAHSİ VİSA'  &#13;&#10;       WHEN 7 THEN 'DEKONT'  &#13;&#10;       WHEN 9 THEN 'ÇEK'  &#13;&#10;       WHEN 4 THEN 'SENET'  &#13;&#10;     END + '\' + H.ACIKLAMA, NULL, NULL, NULL,  &#13;&#10;     NULL, H.TUTAR &#13;&#10;   FROM TBLCARICIKISIADEDETAY H  &#13;&#10;   LEFT OUTER JOIN TBLCARICIKISIADE B WITH(INDEX=TBLCARICIKISIADE_KARTNO) ON B.KARTNO = H.BASLIKID  &#13;&#10;   WHERE ISNULL(B.DELETED, 0) = 0 AND B.CARIID = @CARIID AND B.TARIH BETWEEN @T1 AND @T2  &#13;&#10;  UNION ALL &#13;&#10;  SELECT   &#13;&#10;     H.ACIKLAMA, 12, B.KARTNO, 'TAHSİLAT İADE', TARIH, BELGENO, 'TAHSİLAT İADE',   &#13;&#10;     CASE H.ISLEM   &#13;&#10;       WHEN 0 THEN 'NAKİT'  &#13;&#10;       WHEN 1 THEN 'ÇEK'  &#13;&#10;       WHEN 2 THEN 'SENET'  &#13;&#10;       WHEN 3 THEN 'VİSA'  &#13;&#10;       WHEN 4 THEN 'ŞAHSİ ÇEK'  &#13;&#10;       WHEN 5 THEN 'ŞAHSİ SENET'  &#13;&#10;       WHEN 6 THEN 'ŞAHSİ VİSA'  &#13;&#10;       WHEN 7 THEN 'DEKONT'  &#13;&#10;       WHEN 9 THEN 'ÇEK'  &#13;&#10;       WHEN 4 THEN 'SENET'  &#13;&#10;     END + '\' + H.ACIKLAMA, NULL, NULL, NULL,  &#13;&#10;     H.TUTAR, NULL &#13;&#10;   FROM TBLCARIGIRISIADEDETAY H  &#13;&#10;   LEFT OUTER JOIN TBLCARIGIRISIADE B WITH(INDEX=TBLCARIGIRISIADE_KARTNO) ON B.KARTNO = H.BASLIKID  &#13;&#10;   WHERE ISNULL(B.DELETED, 0) = 0 AND B.CARIID = @CARIID AND B.TARIH BETWEEN @T1 AND @T2  &#13;&#10; UNION ALL &#13;&#10; Select &#13;&#10;     'FASON', B.ISLEM, B.ID,  &#13;&#10;     CASE B.ISLEM WHEN 238 THEN 'FASONA GİDİŞ' ELSE 'FASONDAN GİRİŞ' END, B.TARIH, B.BELGENO, STOKKODU, CINSI, &#13;&#10;     D.MIKTAR - ISNULL((SELECT SUM(MIKTAR) FROM TBLSTOKURETIMISEMRIHAREKETISLEMSIZGELEN WHERE BASLIKID = B.ID AND RENK = D.RENK AND BEDEN = D.BEDEN), 0) -  &#13;&#10;      ISNULL((SELECT SUM(MIKTAR) FROM TBLSTOKURETIMISEMRIHAREKETARIZALIGELEN WHERE BASLIKID = B.ID AND RENK = D.RENK AND BEDEN = D.BEDEN), 0) AS MIKTAR,  &#13;&#10;     BR.BIRIMADI, B.PARCAUCRETI, NULL AS BORC,  &#13;&#10;     (D.MIKTAR - ISNULL((SELECT SUM(MIKTAR) FROM TBLSTOKURETIMISEMRIHAREKETISLEMSIZGELEN WHERE BASLIKID = B.ID AND RENK = D.RENK AND BEDEN = D.BEDEN), 0) -  &#13;&#10;     ISNULL((SELECT SUM(MIKTAR) FROM TBLSTOKURETIMISEMRIHAREKETARIZALIGELEN WHERE BASLIKID = B.ID AND RENK = D.RENK AND BEDEN = D.BEDEN), 0)) * B.PARCAUCRETI AS ALACAK &#13;&#10;   From TBLSTOKURETIMISEMRIHAREKETDETAY D &#13;&#10;   LEFT OUTER JOIN TBLSTOKURETIMISEMRIHAREKET B ON B.ID = D.BASLIKID &#13;&#10;   LEFT OUTER JOIN TBLSTOKURETIMISEMRI IE ON IE.ID = B.ISEMRINO &#13;&#10;   LEFT OUTER JOIN TBLSTOKURUNAGACI UA ON UA.ID = IE.URUNAGACIID &#13;&#10;   LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = UA.CIKISSTOK &#13;&#10; LEFT OUTER JOIN TBLBIRIMLEREX BR WITH(INDEX=TBLBIRIMLEREX_KARTNO) ON BR.KARTNO = S.ANABIRIM &#13;&#10; WHERE B.ISLEM IN(238, 239) AND FASONCU = @CARIID AND B.TARIH BETWEEN @T1 AND @T2  &#13;&#10; UNION ALL &#13;&#10; Select &#13;&#10;   'FASON ARIZA', 257, B.ID, 'FASON ARIZA', B.TARIH, B.BELGENO, STOKKODU, CINSI, MIKTAR, &#13;&#10;   BR.BIRIMADI, D.FIYATI, MIKTAR * D.FIYATI AS BORC, NULL AS ALACAK &#13;&#10; From TBLSTOKURETIMISEMRIHAREKETARIZALIGELEN D &#13;&#10; LEFT OUTER JOIN TBLSTOKURETIMISEMRIHAREKET B ON B.ID = D.BASLIKID &#13;&#10; LEFT OUTER JOIN TBLSTOKURETIMISEMRI IE ON IE.ID = B.ISEMRINO &#13;&#10; LEFT OUTER JOIN TBLSTOKURUNAGACI UA ON UA.ID = IE.URUNAGACIID &#13;&#10; LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = UA.CIKISSTOK &#13;&#10; LEFT OUTER JOIN TBLBIRIMLEREX BR WITH(INDEX=TBLBIRIMLEREX_KARTNO) ON BR.KARTNO = S.ANABIRIM &#13;&#10; WHERE D.MIKTAR &#62; 0 AND B.ISLEM = 239  AND FASONCU = @CARIID AND B.TARIH BETWEEN @T1 AND @T2  &#13;&#10; UNION ALL &#13;&#10; SELECT ACIKLAMA, ISLEMTIPI, KARTNO, ISLEM, TARIH, BELGENO, 'NAKİT', NULL, NULL, NULL, NULL, BORC, ALACAK &#13;&#10;   FROM CARIDOKUM &#13;&#10;   WHERE ISLEMTIPI IN(-1, 20, 21, 184) AND CARIID = @CARIID AND TARIH BETWEEN @T1 AND @T2  &#13;&#10;UNION ALL&#13;&#10;SELECT &#13;&#10;   'DEVİR', -1, 0, 'DEVİR', @T1 - 1, 'DEVİR', 'NAKİT', NULL, NULL, NULL, NULL, NULL, NULL&#13;&#10;) AS B &#13;&#10;WHERE ISLEMTIPI = :ISLEMTIPI AND KARTNO = :KARTNO                                                                                                         &#13;&#10;ORDER BY TARIH&#13;&#10;    " PropData="05704C65667402440470546F7002780A506172616D657465727301010623204E616D653D22434152494944222044617461547970653D226674496E74656765722200010624204E616D653D22544152494831222044617461547970653D2266744461746554696D652200010624204E616D653D22544152494832222044617461547970653D2266744461746554696D652200010626204E616D653D2249534C454D54495049222044617461547970653D226674556E6B6E6F776E2200010623204E616D653D224B4152544E4F222044617461547970653D226674556E6B6E6F776E220000"/>
    <TfrxFDQuery Name="cariQ" UserName="Cari Kart" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select * from TBLCARI&#13;&#10;WHERE KARTNO = :CARIID                                                                                  " PropData="05704C65667402440470546F7003C0000A506172616D657465727301010623204E616D653D22434152494944222044617461547970653D226674496E7465676572220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxReportTitle Name="ReportTitle1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="139,84261" Left="0" Top="16" Width="718,1107">
      <TfrxMemoView Name="Memo13" Left="18,89765" Top="15,11812" Width="706,77211" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="PARADOX Detaylı Hesap Ekstresi"/>
      <TfrxMemoView Name="Memo14" Left="631,18151" Top="36,57483" Width="75,5906" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Date]"/>
      <TfrxMemoView Name="Memo15" Left="19,67718" Top="41,57483" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Firma Kodu"/>
      <TfrxMemoView Name="Memo16" Left="19,67718" Top="63,69295" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Bakiye"/>
      <TfrxMemoView Name="firmaKoduLabel" Left="117,16543" Top="41,57483" Width="510,23655" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Cari Kart.&#34;FIRMAKODU&#34;], [Cari Kart.&#34;FIRMAADI&#34;]"/>
      <TfrxMemoView Name="bakiyeLabel" Left="117,16543" Top="63,69295" Width="427,08689" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[FormatBakiye(&#60;Cari Kart.&#34;BAKIYE&#34;&#62;)]"/>
      <TfrxMemoView Name="Memo17" Left="2,11812" Top="109,60637" Width="79,37013" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Tarih"/>
      <TfrxMemoView Name="Memo18" Left="83,14966" Top="109,60637" Width="400,63018" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="İşlem"/>
      <TfrxMemoView Name="Memo19" Left="502,67749" Top="109,60637" Width="79,37013" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Tutarı"/>
      <TfrxMemoView Name="Memo20" Left="608,50433" Top="109,60637" Width="105,82684" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Durum"/>
      <TfrxLineView Name="Line8" Left="3,33859" Top="132,28355" Width="714,33117" Height="0" Color="0" Frame.Style="fsDouble" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo1" Left="593,26809" Top="64,25201" Width="113,3859" Height="18,89765" HAlign="haRight" Text="Sayfa: [Page#] / [TotalPages#]"/>
    </TfrxReportTitle>
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="22,67718" Left="0" Top="176" Width="718,1107" OnBeforePrint="MasterData1OnBeforePrint" ColumnWidth="0" ColumnGap="0" DataSet="ekstreQ" DataSetName="Ekstre" RowCount="0">
      <TfrxMemoView Name="Memo32" Align="baClient" Left="0" Top="0" Width="718,1107" Height="22,67718" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Fill.BackColor="-16777216" ParentFont="False" Text=""/>
      <TfrxMemoView Name="EkstreTARIH" Left="2,11812" Top="2,33859" Width="79,37013" Height="18,89765" DataField="TARIH" DataSet="ekstreQ" DataSetName="Ekstre" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Ekstre.&#34;TARIH&#34;]"/>
      <TfrxMemoView Name="EkstreISLEM" Left="83,14966" Top="2,33859" Width="272,12616" Height="18,89765" DataField="ISLEM" DataSet="ekstreQ" DataSetName="Ekstre" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Ekstre.&#34;ISLEM&#34;]"/>
      <TfrxMemoView Name="EkstreTLALACAK" Left="502,67749" Top="2,33859" Width="79,37013" Height="18,89765" OnBeforePrint="EkstreTLALACAKOnBeforePrint" DataSet="ekstreQ" DataSetName="Ekstre" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[IIF(&#60;Ekstre.&#34;BORC&#34;&#62; &#62; 0, &#60;Ekstre.&#34;BORC&#34;&#62;, &#60;Ekstre.&#34;ALACAK&#34;&#62;)]"/>
      <TfrxMemoView Name="EkstreCARIDURUM" Left="608,50433" Top="2,33859" Width="98,26778" Height="18,89765" DataField="CARIDURUM" DataSet="ekstreQ" DataSetName="Ekstre" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Ekstre.&#34;CARIDURUM&#34;]"/>
      <TfrxMemoView Name="EkstreBELGENO" Left="362,83488" Top="2,33859" Width="136,06308" Height="18,89765" DataField="BELGENO" DataSet="ekstreQ" DataSetName="Ekstre" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Ekstre.&#34;BELGENO&#34;]"/>
    </TfrxMasterData>
    <TfrxDetailData Name="DetailData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="17,00787402" Left="0" Top="284" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="ekstreDetayQ" DataSetName="Detay" RowCount="0">
      <TfrxMemoView Name="DetaySTOKKODU" Left="56,69295" Top="0" Width="83,14966" Height="18,89765" DataField="STOKKODU" DataSet="ekstreDetayQ" DataSetName="Detay" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Detay.&#34;STOKKODU&#34;]"/>
      <TfrxMemoView Name="DetayCINSI" Left="143,96073" Top="0" Width="291,02381" Height="18,89765" DataField="CINSI" DataSet="ekstreDetayQ" DataSetName="Detay" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Detay.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="DetayMIKTARI" Left="437,7483" Top="0" Width="71,81107" Height="18,89765" DataField="MIKTARI" DataSet="ekstreDetayQ" DataSetName="Detay" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Detay.&#34;MIKTARI&#34;]"/>
      <TfrxMemoView Name="DetayFIYATI" Left="512,55937" Top="0" Width="71,81107" Height="18,89765" DataField="FIYATI" DataSet="ekstreDetayQ" DataSetName="Detay" DisplayFormat.FormatStr="#,#0.###0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Detay.&#34;FIYATI&#34;]"/>
      <TfrxMemoView Name="Memo7" Left="585,82715" Top="0" Width="94,48825" Height="18,89765" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[&#60;Detay.&#34;MIKTARI&#34;&#62; * &#60;Detay.&#34;FIYATI&#34;&#62;]"/>
    </TfrxDetailData>
    <TfrxHeader Name="Header1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="45,35436" Left="0" Top="220" Width="718,1107">
      <TfrxLineView Name="Line1" Left="45,77953" Top="7,55906" Width="634,96104" Height="0" Color="0" Frame.Style="fsDouble" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo2" Left="56,69295" Top="18,89765" Width="83,14966" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="1" ParentFont="False" Text="Stok Kodu"/>
      <TfrxMemoView Name="Memo3" Left="143,96073" Top="18,89765" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="1" ParentFont="False" Text="Cinsi"/>
      <TfrxMemoView Name="Memo4" Left="437,7483" Top="18,89765" Width="71,81107" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Miktar"/>
      <TfrxMemoView Name="Memo5" Left="512,55937" Top="18,89765" Width="71,81107" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Fiyat"/>
      <TfrxMemoView Name="Memo6" Left="585,82715" Top="18,89765" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Tutar"/>
      <TfrxLineView Name="Line2" Left="45,77953" Top="41,57483" Width="634,96104" Height="0" Color="0" Frame.Typ="4"/>
    </TfrxHeader>
    <TfrxFooter Name="Footer1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="45,35436" Left="0" Top="320" Width="718,1107" OnBeforePrint="Footer1OnBeforePrint">
      <TfrxLineView Name="Line3" Left="45,77953" Top="7,55906" Width="634,96104" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxLineView Name="Line4" Left="45,77953" Top="38,13389" Width="634,96104" Height="0" Color="0" Frame.Style="fsDouble" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo10" Left="49,13389" Top="13,67718" Width="49,13389" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Miktar: "/>
      <TfrxMemoView Name="Memo11" Left="101,82684" Top="13,67718" Width="60,47248" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Detay.&#34;MIKTARI&#34;&#62;,DetailData1)]"/>
      <TfrxMemoView Name="Memo12" Left="181,41744" Top="13,67718" Width="60,47248" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="1" HAlign="haRight" ParentFont="False" Text="İskonto: "/>
      <TfrxMemoView Name="Memo21" Left="245,22851" Top="13,67718" Width="90,70872" Height="18,89765" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text=""/>
      <TfrxMemoView Name="Memo22" Left="340,1577" Top="13,67718" Width="41,57483" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="1" ParentFont="False" Text="KDV : "/>
      <TfrxMemoView Name="Memo23" Left="387,07112" Top="13,67718" Width="86,92919" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text=""/>
      <TfrxMemoView Name="Memo24" Left="479,3389" Top="13,67718" Width="86,92919" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="1" ParentFont="False" Text="Fatura Tutarı : "/>
      <TfrxMemoView Name="Memo25" Left="585,82715" Top="13,67718" Width="94,48825" Height="18,89765" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[IIF(&#60;Ekstre.&#34;BORC&#34;&#62; &#62; 0, &#60;Ekstre.&#34;BORC&#34;&#62;, &#60;Ekstre.&#34;ALACAK&#34;&#62;)]"/>
    </TfrxFooter>
    <TfrxHeader Name="Header2" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="45,35436" Left="0" Top="384" Width="718,1107">
      <TfrxMemoView Name="Memo8" Left="41,57483" Top="11,77953" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Açıklama"/>
      <TfrxMemoView Name="Memo9" Left="593,38621" Top="8" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Tutarı"/>
      <TfrxLineView Name="Line5" Left="45,77953" Top="5,55906" Width="634,96104" Height="0" Color="0" Frame.Style="fsDouble" Frame.Typ="4"/>
      <TfrxLineView Name="Line6" Left="45,77953" Top="34,01577" Width="634,96104" Height="0" Color="0" Frame.Typ="4"/>
    </TfrxHeader>
    <TfrxDetailData Name="DetailData2" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="17,007874015748" Left="0" Top="448" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="ekstreDetayQ" DataSetName="Detay" RowCount="0">
      <TfrxMemoView Name="DetayCINSI1" Left="41,57483" Top="0" Width="400,63018" Height="18,89765" DataField="CINSI" DataSet="ekstreDetayQ" DataSetName="Detay" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Detay.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="DetayALACAK" Left="593,38621" Top="0" Width="79,37013" Height="18,89765" DataSet="ekstreDetayQ" DataSetName="Detay" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[IIF(&#60;Detay.&#34;BORC&#34;&#62; &#62; 0, &#60;Detay.&#34;BORC&#34;&#62;, &#60;Detay.&#34;ALACAK&#34;&#62;)]"/>
    </TfrxDetailData>
    <TfrxFooter Name="Footer2" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="22,67718" Left="0" Top="484" Width="718,1107">
      <TfrxLineView Name="Line7" Left="3,77953" Top="7,55906" Width="710,55164" Height="0" Color="0" Frame.Typ="4"/>
    </TfrxFooter>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="117,16543" Left="0" Top="528" Width="718,1107">
      <TfrxLineView Name="Line9" Left="3,77953" Top="11,33859" Width="710,55164" Height="0" Color="0" Frame.Style="fsDouble" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo26" Left="608,50433" Top="18,89765" Width="94,48825" Height="18,89765" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Ekstre.&#34;CARIBORC&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo27" Left="608,50433" Top="49,13389" Width="94,48825" Height="18,89765" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Ekstre.&#34;CARIALACAK&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo28" Left="496,44125" Top="18,89765" Width="109,60637" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Toplam Borç : "/>
      <TfrxMemoView Name="Memo29" Left="496,44125" Top="49,13389" Width="109,60637" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Toplam Alacak : "/>
      <TfrxLineView Name="Line10" Left="487,55937" Top="75,5906" Width="226,7718" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo30" Left="496,44125" Top="90,70872" Width="109,60637" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="BAKİYE : "/>
      <TfrxMemoView Name="Memo31" Left="608,50433" Top="90,70872" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[FormatBakiye(SUM(&#60;Ekstre.&#34;CARIBORC&#34;&#62; - &#60;Ekstre.&#34;CARIALACAK&#34;&#62;,MasterData1))]"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
