<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="5.4.6" 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="43272,5346359954" ScriptLanguage="PascalScript" ScriptText.Text="&#13;&#10;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]);&#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]) 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;  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;&#13;&#10;end;&#13;&#10;&#13;&#10;VAR&#13;&#10;T1,T2:TDATETIME;&#13;&#10;begin&#13;&#10;   Input2Date('Tarih Aralığı Seç',T1,T2);&#13;&#10;   SetQueryParam('cariQ', 'CARIID', &#60;KARTNO&#62;);&#13;&#10;&#13;&#10;   SetQueryParam('ekstreQ', 'TARIH1',T1);&#13;&#10;   SetQueryParam('ekstreQ', 'TARIH2',T2);&#13;&#10;   SetQueryParam('ekstreQ', 'CARIID',&#60;KARTNO&#62;);&#13;&#10;&#13;&#10;   SetQueryParam('ekstreDetayQ', 'TARIH1',T1);&#13;&#10;   SetQueryParam('ekstreDetayQ', 'TARIH2',T2);&#13;&#10;   SetQueryParam('ekstreDetayQ', 'CARIID',&#60;KARTNO&#62;);&#13;&#10;&#13;&#10;   QueryLoadAllRecords(ekstreQ);&#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>
  <Variables>
    <item Name="KARTNO" Value="1"/>
    <item Name="CARIID" Value="1"/>
    <item Name="TARIH" Value="1"/>
    <item Name="DETAYKARTNO" Value="1"/>
  </Variables>
  <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, @T DECIMAL(18, 4) &#13;&#10;  &#13;&#10; SET @CARIID = :CARIID             &#13;&#10; SET @T1 = :TARIH1&#13;&#10; SET @T2 = :TARIH2            &#13;&#10;&#13;&#10; SET @T = ISNULL((SELECT SUM((ALACAK - BORC) * KUR) FROM CARIDOKUM WHERE CARIID =  @CARIID AND TARIH &#60; @T1), 0)&#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 TARIH BETWEEN @T1 AND @T2 &#13;&#10;UNION ALL&#13;&#10;SELECT &#13;&#10;  0, -1, @CARIID, @T1 - 1, 0, @T1 - 1, '', 'DEVİR', 'TL', &#13;&#10;  MONTH(@T1), YEAR(@T1), '', '', &#13;&#10;  CASE WHEN @T &#60; 0 THEN -1 * @T ELSE @T END, 1, &#13;&#10;  CASE WHEN @T &#60; 0 THEN 0 ELSE @T END,     &#13;&#10;  CASE WHEN @T &#60; 0 THEN -1 * @T ELSE 0 END, &#13;&#10;  CASE WHEN @T &#60; 0 THEN 0 ELSE @T END, &#13;&#10;  CASE WHEN @T &#60; 0 THEN -1 * @T ELSE 0 END, &#13;&#10;  CASE WHEN @T &#60; 0 THEN -1 * @T ELSE 0 END, &#13;&#10;  CASE WHEN @T &#60; 0 THEN 0 ELSE @T END                 &#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)  THEN NETTUTAR * ((KDV + 100.0000) / 100.0000) ELSE NULL END AS BORC, &#13;&#10;    CASE WHEN ISLEMTIPI IN (1, 3, 4, 12) 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;  ) 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;  &#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;  &#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;  &#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 ACIKLAMA, ISLEMTIPI, KARTNO, ISLEM, TARIH, BELGENO, 'NAKİT', NULL, NULL, NULL, NULL, BORC, ALACAK&#13;&#10;  FROM CARIDOKUM&#13;&#10;  WHERE ISLEMTIPI IN(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', NULL, NULL, NULL, NULL, 0, 0                                                               &#13;&#10; ) AS B &#13;&#10;WHERE ISLEMTIPI = :ISLEMTIPI AND KARTNO = :KARTNO  &#13;&#10;ORDER BY TARIH&#13;&#10;&#13;&#10;    " PropData="05704C65667402440470546F7002780A506172616D657465727301010641204E616D653D22434152494944222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B434152494944262336323B2200010624204E616D653D22544152494831222044617461547970653D2266744461746554696D652200010624204E616D653D22544152494832222044617461547970653D2266744461746554696D652200010626204E616D653D2249534C454D54495049222044617461547970653D226674556E6B6E6F776E2200010623204E616D653D224B4152544E4F222044617461547970653D226674556E6B6E6F776E220000"/>
    <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="05704C65667402440470546F7003C0000A506172616D657465727301010641204E616D653D22434152494944222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B4B4152544E4F262336323B220000"/>
  </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="Belge Bazlı 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="400,63018" 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" 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;]"/>
    </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;BORC&#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;ALACAK&#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;BORC&#34;&#62; - &#60;Ekstre.&#34;ALACAK&#34;&#62;,MasterData1))]"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
