<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="5.1.9" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Varsayılan" PrintOptions.PrintOnSheet="0" ReportOptions.Author="Cüneyt ELİBOL" ReportOptions.CreateDate="41974" ReportOptions.Description.Text="" ReportOptions.LastChange="41974,6668973264" ScriptLanguage="PascalScript" ScriptText.Text="procedure frxROnStartReport(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;  ekstreQ.Active:= True;&#13;&#10;  CalcCariHesapDetay(ekstreQ);  &#13;&#10;end;&#13;&#10;&#13;&#10;begin&#13;&#10;&#13;&#10;end." OnStartReport="frxROnStartReport">
  <Datasets>
    <item DataSet="ekstreQ" DataSetName="EKstre Bilgileri"/>
    <item DataSet="cariQ" DataSetName="Cari Kart"/>
  </Datasets>
  <TfrxDataPage Name="PXData" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDQuery Name="ekstreQ" UserName="EKstre Bilgileri" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SET DATEFORMAT DMY &#13;&#10; SELECT  &#13;&#10; CARIDOKUM.ID, CARIDOKUM.CARIID, CARIDOKUM.KAYITTARIHI, CARIDOKUM.KARTNO, :TARIH1 AS TARIH, 'NAKİL' AS BELGENO,  &#13;&#10; 'NAKİL' AS ISLEM, CARIDOKUM.DOVIZ, DATEPART(MONTH, GetDate()) AS AY, DATEPART(year, GetDate()) AS YIL,  &#13;&#10; CARIDOKUM.TLDURUM, CARIDOKUM.CARIDURUM, SUM(TUTARI) AS TUTARI, -1 AS ISLEMTIPI, 1 AS KUR,  &#13;&#10; SUM(ALACAK) AS ALACAK, SUM(BORC) AS BORC, SUM(TLALACAK) AS TLALACAK, SUM(TLBORC) AS TLBORC,  &#13;&#10; SUM(CARIBORC) AS CARIBORC, SUM(CARIALACAK) AS CARIALACAK &#13;&#10; FROM CARIDOKUM  LEFT OUTER JOIN TBLCARI ON TBLCARI.KARTNO = CARIDOKUM.CARIID &#13;&#10; Where CARIID = :CARIID AND TARIH &#60; :TARIH1            &#13;&#10; GROUP BY &#13;&#10;   CARIDOKUM.ID, CARIDOKUM.CARIID, CARIDOKUM.KAYITTARIHI, CARIDOKUM.KARTNO, &#13;&#10;   CARIDOKUM.DOVIZ, CARIDOKUM.TLDURUM, CARIDOKUM.CARIDURUM, CARIDOKUM.TARIH &#13;&#10; UNION ALL &#13;&#10; SELECT  &#13;&#10;   CARIDOKUM.ID, CARIDOKUM.CARIID, CARIDOKUM.KAYITTARIHI, CARIDOKUM.KARTNO,  CARIDOKUM.TARIH, CARIDOKUM.BELGENO, CARIDOKUM.ISLEM, CARIDOKUM.DOVIZ,  &#13;&#10;   CARIDOKUM.AY, CARIDOKUM.YIL,  CARIDOKUM.TLDURUM, CARIDOKUM.CARIDURUM, TUTARI, ISLEMTIPI, KUR, ALACAK, BORC, TLALACAK, TLBORC, CARIBORC, CARIALACAK &#13;&#10; FROM CARIDOKUM  LEFT OUTER JOIN TBLCARI ON TBLCARI.KARTNO = CARIDOKUM.CARIID &#13;&#10; Where CARIID = :CARIID AND TARIH &#62;= :TARIH1 AND TARIH &#60;= :TARIH2  &#13;&#10; ORDER BY TARIH, KAYITTARIHI " PropData="05704C65667402640470546F7003D4000A506172616D657465727301010620204E616D653D22544152494831222044617461547970653D226674446174652200010623204E616D653D22434152494944222044617461547970653D226674496E74656765722200010620204E616D653D22544152494831222044617461547970653D226674446174652200010623204E616D653D22434152494944222044617461547970653D226674496E74656765722200010620204E616D653D22544152494831222044617461547970653D226674446174652200010620204E616D653D22544152494832222044617461547970653D22667444617465220000"/>
    <TfrxFDQuery Name="cariQ" UserName="Cari Kart" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select * from TBLCARI&#13;&#10;WHERE KARTNO = :KARTNO                                                 " PropData="05704C65667402680470546F7002540A506172616D657465727301010623204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="SAYFA" PaperWidth="210" PaperHeight="297" PaperSize="256" LeftMargin="0" RightMargin="0" TopMargin="0" BottomMargin="0" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="22,67718" Left="0" Top="211,65368" Width="793,7013" ColumnWidth="0" ColumnGap="0" DataSet="ekstreQ" DataSetName="EKstre Bilgileri" RowCount="0">
      <TfrxMemoView Name="CariEkstreDkmTARIH" Left="8,76376" Top="0" Width="83,14961118" Height="18,89765" DataField="TARIH" DataSet="ekstreQ" DataSetName="EKstre Bilgileri" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[EKstre Bilgileri.&#34;TARIH&#34;]"/>
      <TfrxMemoView Name="CariEkstreDkmBELGENO" Left="94,48825" Top="0" Width="128,50402" Height="18,89765" DataField="BELGENO" DataSet="ekstreQ" DataSetName="EKstre Bilgileri" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[EKstre Bilgileri.&#34;BELGENO&#34;]"/>
      <TfrxMemoView Name="CariEkstreDkmISLEM" Left="226,7718" Top="0" Width="151,1812" Height="18,89765" DataSet="ekstreQ" DataSetName="EKstre Bilgileri" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[EKstre Bilgileri.&#34;ISLEM&#34;]"/>
      <TfrxMemoView Name="Memo12" Left="381,73253" Top="0" Width="102,04731" Height="18,89765" DataSet="ekstreQ" DataSetName="EKstre Bilgileri" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[EKstre Bilgileri.&#34;BORC&#34;]"/>
      <TfrxMemoView Name="CariEkstreDkmALACAK" Left="488,88219" Top="0" Width="102,04731" Height="18,89765" DataSet="ekstreQ" DataSetName="EKstre Bilgileri" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[EKstre Bilgileri.&#34;ALACAK&#34;]"/>
      <TfrxMemoView Name="Memo11" Left="612,28386" Top="0" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[EKstre Bilgileri.&#34;CARIDURUM&#34;]"/>
    </TfrxMasterData>
    <TfrxPageHeader Name="PageHeader1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="132,28355" Left="0" Top="18,89765" Width="793,7013">
      <TfrxMemoView Name="Memo2" Left="3,77953" Top="3,77953" 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 Hesap Ekstresi"/>
      <TfrxMemoView Name="Memo3" Left="616,06339" Top="25,23624" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Date]"/>
      <TfrxLineView Name="Line1" Left="0,77953" Top="127,13389" Width="710,55164" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo5" Left="4,55906" Top="30,23624" 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="Memo6" Left="4,55906" Top="52,35436" 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="Memo7" Left="226,7718" Top="107,25201" Width="120,94496" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="İşlem"/>
      <TfrxMemoView Name="Memo9" Left="8,76376" Top="107,25201" Width="83,14961118" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Tarih"/>
      <TfrxMemoView Name="Memo10" Left="94,48825" Top="107,25201" Width="128,50402" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Belge No"/>
      <TfrxMemoView Name="Memo4" Left="381,73253" Top="107,25201" Width="102,04731" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Borç"/>
      <TfrxMemoView Name="Memo8" Left="488,88219" Top="107,25201" Width="102,04731" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Alacak"/>
      <TfrxMemoView Name="firmaKoduLabel" Left="102,04731" Top="30,23624" 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="102,04731" Top="52,35436" 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="Memo13" Left="612,28386" Top="107,25201" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Durum"/>
    </TfrxPageHeader>
    <TfrxPageFooter Name="PageFooter1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="56,69295" Left="0" Top="366,61441" Width="793,7013">
      <TfrxLineView Name="Line2" Left="7,55906" Top="7,55906" Width="702,99258" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo1" Left="15,11812" Top="18,89765" Width="340,1577" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="PARADOX ile [Date] Tarihinde yazdırılmıştır"/>
      <TfrxMemoView Name="Memo14" Left="593,38621" Top="18,89765" Width="117,16543" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="Sayfa: [Page] / [TotalPages#]"/>
    </TfrxPageFooter>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="49,13389" Left="0" Top="294,80334" Width="793,7013">
      <TfrxLineView Name="Line3" Left="7,55906" Top="5" Width="702,99258" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo15" Left="381,73253" Top="11,77953" Width="102,04731" Height="18,89765" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Ekstre Bilgileri.&#34;BORC&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo16" Left="488,88219" Top="11,77953" Width="102,04731" Height="18,89765" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Ekstre Bilgileri.&#34;ALACAK&#34;&#62;,MasterData1)]"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
