<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="4.15.6" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Varsayılan" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="41811,7232961574" ReportOptions.Description.Text="" ReportOptions.LastChange="41844,9132110301" ScriptLanguage="PascalScript" ScriptText.Text="&#13;&#10;begin&#13;&#10;&#13;&#10;end." PropData="044C65667403880203546F7002200844617461736574730101062720446174615365743D22666174757261512220446174615365744E616D653D22466174757261220001062E20446174615365743D2263617269512220446174615365744E616D653D224669726D612042696C67696C657269220000095661726961626C657301010619204E616D653D22434152494944222056616C75653D223536220000055374796C650100">
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TFrxFDQuery Name="faturaQ" UserName="Fatura" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select&#13;&#10; ISLEM, CARIID, ACIKLAMA, KARTNO, PERSONEL, TUTARI, BELGENO, TARIH, VADE,&#13;&#10; ODENEN, TUTARI - ODENEN AS KALAN, M2, CAST(GETDATE() - VADE AS INT) AS GUN,&#13;&#10; (Select COUNT(*) From TBLIHTARYAZILARI WITH(INDEX=TBLIHTARYAZILARI_INDEX) WHERE FATURATIPI = A.ISLEM AND KARTNO = A.KARTNO) AS IHTARSAYISI&#13;&#10;FROM(      &#13;&#10;SELECT&#13;&#10;   2 AS ISLEM, B.CARIID, B.ACIKLAMA, P.AD + ' ' + P.SOYAD AS PERSONEL, B.KARTNO, TUTARI AS TUTARI, BELGENO, TARIH,&#13;&#10;   B.VADE, Coalesce((Select SUM(TUTAR) From TBLFATURAKAPAT WHERE ISLEM = 2 AND BELGENO = B.KARTNO), 0) AS ODENEN, M2&#13;&#10;from TBLURETIMSATFATBASLIK B WITH(INDEX=TBLURETIMSATFATBASLIK_VADE)&#13;&#10;LEFT OUTER JOIN TBLCARI C WITH(INDEX=TBLCARI_KARTNO) ON B.CARIID = C.KARTNO&#13;&#10;LEFT OUTER JOIN TBLPERSONEL P WITH(INDEX=TBLPERSONEL_KARTNO) ON B.PERSONELID = P.KARTNO&#13;&#10;WHERE B.DELETED = 0 AND CARIID &#60;&#62; -1 AND VADE &#60; GETDATE()&#13;&#10;UNION ALL&#13;&#10;SELECT&#13;&#10;   0 AS ISLEM, B.CARIID, B.ACIKLAMA, P.AD + ' ' + P.SOYAD AS PERSONEL, B.KARTNO, TUTARI AS TUTARI, BELGENO, TARIH,&#13;&#10;   B.VADE, Coalesce((Select SUM(TUTAR) From TBLFATURAKAPAT WHERE ISLEM = 0 AND BELGENO = B.KARTNO), 0) AS ODENEN, 0&#13;&#10;from TBLSATFATBASLIK B WITH(INDEX=TBLSATFATBASLIK_VADE)&#13;&#10;LEFT OUTER JOIN TBLCARI C WITH(INDEX=TBLCARI_KARTNO) ON B.CARIID = C.KARTNO&#13;&#10;LEFT OUTER JOIN TBLPERSONEL P WITH(INDEX=TBLPERSONEL_KARTNO) ON B.PERSONELID = P.KARTNO&#13;&#10;WHERE B.DELETED = 0 AND CARIID &#60;&#62; -1 AND VADE &#60; GETDATE()&#13;&#10;UNION ALL&#13;&#10;SELECT&#13;&#10;   -1 AS ISLEM, B.KARTNO, 'DEVİR' AS ACIKLAMA, 'DEVİR' AS PERSONEL, -1, DEVIR AS TUTARI, 'DEVİR', &#13;&#10;   CAST('01.01.' + CAST(DATEPART(yyyy, GETDATE()) AS VARCHAR) AS DATETIME) AS TARIH,&#13;&#10;   CAST('01.01.' + CAST(DATEPART(yyyy, GETDATE()) AS VARCHAR) AS DATETIME) AS VADE,&#13;&#10;   Coalesce((Select SUM(TUTAR) From TBLFATURAKAPAT WHERE ISLEM = -1 AND BELGENO = B.KARTNO), 0) AS ODENEN, 0&#13;&#10;FROM TBLDEVIR B WITH(INDEX=TBLDEVIR_INDEX)&#13;&#10;LEFT JOIN TBLCARI C WITH(INDEX=TBLCARI_KARTNO) ON C.KARTNO = B.KARTNO&#13;&#10;LEFT JOIN TBLDOVIZLER DOVIZ ON DOVIZ.KARTNO = C.DOVIZID&#13;&#10;WHERE B.MODULID = 1                              &#13;&#10;)AS A" PropData="05704C65667402340470546F7002200A506172616D65746572730100"/>
    <TFrxFDQuery Name="cariQ" UserName="Firma Bilgileri" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select&#13;&#10;*&#13;&#10;FROM TBLCARI&#13;&#10;WHERE KARTNO = :CARIID                                                 " PropData="05704C65667402340470546F7002680A506172616D657465727301010652204E616D653D22434152494944222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B4661747572612E262333343B434152494944262333343B262336323B220000"/>
  </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" Height="185,19697" Left="0" Top="16" Width="718,1107">
      <TfrxMemoView Name="Memo2" Left="188,9765" Top="11,33859" Width="177,63791" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Fatura Ödeme İhbarnamesi"/>
      <TfrxMemoView Name="Memo3" Left="18,89765" Top="56,69295" Width="684,09493" Height="68,03154" ShowHint="False" AllowHTMLTags="True" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="Sayın&#13;&#10;  &#60;b&#62;[Firma Bilgileri.&#34;FIRMAUNVANI&#34;] &#60;/b&#62;&#13;&#10;  Aşağıda dökümü verilen faturalarınız ödenmemiştir.&#13;&#10;  Lütfen en kısa zamanda ödeyiniz.."/>
      <TfrxMemoView Name="Memo4" Left="18,89765" Top="158,74026" Width="83,14966" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Belge No"/>
      <TfrxMemoView Name="Memo5" Left="325,03958" Top="158,74026" Width="94,48825" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Tutarı"/>
      <TfrxMemoView Name="Memo6" Left="109,60637" Top="158,74026" Width="94,48825" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Tarih"/>
      <TfrxMemoView Name="Memo7" Left="211,65368" Top="158,74026" Width="94,48825" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Vade"/>
      <TfrxLineView Name="Line1" Left="15,11812" Top="181,41744" Width="411,96877" Height="0" ShowHint="False" Frame.Typ="4"/>
    </TfrxReportTitle>
    <TfrxMasterData Name="MasterData1" Height="26,45671" Left="0" Top="220" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="faturaQ" DataSetName="Fatura" RowCount="0">
      <TfrxMemoView Name="FaturaBilgileriBELGENO" Left="18,89765" Top="3,77953" Width="83,14966" Height="18,89765" ShowHint="False" DataField="BELGENO" DataSet="faturaQ" DataSetName="Fatura" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Fatura.&#34;BELGENO&#34;]"/>
      <TfrxMemoView Name="FaturaBilgileriTARIH" Left="109,60637" Top="0" Width="94,48825" Height="18,89765" ShowHint="False" DataField="TARIH" DataSet="faturaQ" DataSetName="Fatura" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Fatura.&#34;TARIH&#34;]"/>
      <TfrxMemoView Name="FaturaBilgileriVADE" Left="211,65368" Top="0" Width="94,48825" Height="18,89765" ShowHint="False" DataField="VADE" DataSet="faturaQ" DataSetName="Fatura" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Fatura.&#34;VADE&#34;]"/>
      <TfrxMemoView Name="FaturaBilgileriKALAN" Left="325,03958" Top="3,77953" Width="94,48825" Height="18,89765" ShowHint="False" DataField="KALAN" DataSet="faturaQ" DataSetName="Fatura" 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="[Fatura.&#34;KALAN&#34;]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="PageFooter1" Height="22,67718" Left="0" Top="348" Width="718,1107">
      <TfrxMemoView Name="Memo1" Left="642,5201" Top="0" Width="75,5906" Height="18,89765" ShowHint="False" HAlign="haRight" Text="[Page#]"/>
    </TfrxPageFooter>
    <TfrxReportSummary Name="ReportSummary1" Height="60,47248" Left="0" Top="268" Width="718,1107">
      <TfrxMemoView Name="Memo8" Left="325,03958" Top="18,89765" Width="94,48825" Height="18,89765" ShowHint="False" 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;Fatura.&#34;KALAN&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo9" Left="219,21274" Top="18,89765" Width="94,48825" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Genel Toplam"/>
      <TfrxLineView Name="Line2" Left="321,26005" Top="7,55906" Width="102,04731" Height="0" ShowHint="False" Frame.Typ="4"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
