<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="5.4.6" DotMatrixReport="False" EngineOptions.SilentMode="True" EngineOptions.NewSilentMode="simSilent" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="OneNote 16'ya Gönder" PrintOptions.PrintOnSheet="0" ReportOptions.Author="Cüneyt ELİBOL" ReportOptions.CreateDate="41379" ReportOptions.Description.Text="" ReportOptions.LastChange="42969.7214180556" ScriptLanguage="PascalScript" ScriptText.Text="&#13;&#10;begin&#13;&#10;&#13;&#10;end.">
  <Datasets>
    <item DataSet="baslikQ" DataSetName="İşlem Başlığı"/>
    <item DataSet="detayQ" DataSetName="İşlem Detayları"/>
    <item DataSet="cariQ" DataSetName="Cari Kart"/>
    <item DataSet="KDVQ" DataSetName="KDV Grupları"/>
  </Datasets>
  <Variables>
    <item Name="CARIKARTNO" Value="1"/>
    <item Name="KARTNO" Value="1"/>
    <item Name="ODEMEKARTNO" Value="1"/>
    <item Name="NAKIT" Value="0"/>
    <item Name="VISA" Value="0"/>
    <item Name="FIRMAKODU"/>
    <item Name="FIRMAADI"/>
    <item Name="BAKIYE" Value="0"/>
  </Variables>
  <TfrxDataPage Name="PXData" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDQuery Name="baslikQ" UserName="İşlem Başlığı" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select &#13;&#10;  B.*, P.AD +' '+ P.SOYAD AS PERSONEL,  D.ACIKLAMA AS DEPO &#13;&#10;from TBLSATFATBASLIK B &#13;&#10;LEFT OUTER JOIN TBLPERSONEL P ON B.PERSONELID = P.KARTNO  &#13;&#10;LEFT OUTER JOIN TBLDEPOLAR D ON ISNULL(D.DELETED, 0) = 0 AND B.DEPOID = D.KARTNO  &#13;&#10;WHERE B.KARTNO = :KARTNO" PropData="05704C65667402740470546F700390000A506172616D657465727301010641204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B4B4152544E4F262336323B220000"/>
    <TfrxFDQuery Name="detayQ" UserName="İşlem Detayları" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="baslikQ" IgnoreDupParams="False" SQL.Text="Select &#13;&#10;  S.STOKKODU, S.CINSI, B.BIRIMADI,B.BARKOD, H.*,  Cast(0.000 AS Decimal(18, 4)) AS ISKONTO1TOPLAMI,  Cast(0.000 AS Decimal(18, 4)) AS ISKONTO2TOPLAMI,  &#13;&#10;  Cast(0.000 AS Decimal(18, 4)) AS ISKONTO3TOPLAMI, Cast(0.000 AS Decimal(18, 4)) AS ISKONTO4TOPLAMI,  Cast(0.000 AS Decimal(18, 4)) AS KDVDAHILFIYAT, &#13;&#10;  Cast(0.000 AS Decimal(18, 4)) AS KDVDAHILTUTAR &#13;&#10;From TBLSATFATHAREKET H &#13;&#10;LEFT OUTER JOIN TBLSTOKLAR S ON H.STOKID = S.KARTNO  &#13;&#10;LEFT OUTER JOIN TBLBIRIMLEREX B ON H.BIRIMID = B.KARTNO &#13;&#10;WHERE H.FATURAID = :KARTNO" PropData="05704C65667402740470546F7003F4000A506172616D65746572730101145F000000204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303BC4B0C59F6C656D204261C59F6CC4B1C49FC4B12E262333343B4B4152544E4F262333343B262336323B220000"/>
    <TfrxFDQuery Name="cariQ" UserName="Cari Kart" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="baslikQ" IgnoreDupParams="False" SQL.Text="Select * from TBLCARI  WHERE KARTNO = :CARIID" PropData="05704C65667402740470546F70023C0A506172616D65746572730101145F000000204E616D653D22434152494944222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303BC4B0C59F6C656D204261C59F6CC4B1C49FC4B12E262333343B434152494944262333343B262336323B220000"/>
    <TfrxFDQuery Name="KDVQ" UserName="KDV Grupları" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="baslikQ" IgnoreDupParams="False" SQL.Text="SELECT &#13;&#10;  KDV, ISNULL(SUM(MIKTARI * FIYATI - ISKONTOTOPLAMI), 0) AS KDVMATRAHI, &#13;&#10;  ISNULL(SUM(KDVTUTARI), 0) AS KDVTUTARI  &#13;&#10;FROM TBLSATFATHAREKET &#13;&#10;WHERE FATURAID = :KARTNO &#13;&#10;GROUP BY KDV" PropData="05704C65667402740470546F700348010A506172616D65746572730101145F000000204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303BC4B0C59F6C656D204261C59F6CC4B1C49FC4B12E262333343B4B4152544E4F262333343B262336323B220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="SAYFA" PaperWidth="210" PaperHeight="140" PaperSize="256" LeftMargin="0" RightMargin="0" TopMargin="0" BottomMargin="0" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="" OnBeforePrint="SAYFAOnBeforePrint">
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="22.67718" Left="0" Top="268.34663" Width="793.7013" ColumnWidth="0" ColumnGap="0" DataSet="detayQ" DataSetName="İşlem Detayları" RowCount="0">
      <TfrxMemoView Name="lemDetaylarCINSI" Left="43.7953" Top="3.77953" Width="309.92146" Height="15.11812" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" WordBreak="True" WordWrap="False" VAlign="vaCenter" Text="[İşlem Detayları.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="lemDetaylarMIKTARI" Left="360.17347" Top="3.77953" Width="49.13389" Height="15.11812" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="[İşlem Detayları.&#34;MIKTARI&#34;]"/>
      <TfrxMemoView Name="Memo1" Left="414.30736" Top="3.77953" Width="56.69295" Height="15.11812" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="[İşlem Detayları.&#34;BIRIMADI&#34;]"/>
      <TfrxMemoView Name="lemDetaylarFIYATI" Left="483.77984" Top="3.77953" Width="79.37013" Height="18.89765" DataField="FIYATI" DataSet="detayQ" DataSetName="İşlem Detayları" Text="[İşlem Detayları.&#34;FIYATI&#34;]"/>
      <TfrxMemoView Name="Memo2" Left="574.48856" Top="3.77953" Width="94.48825" Height="18.89765" Text="[&#60;İşlem Detayları.&#34;FIYATI&#34;&#62; * &#60;İşlem Detayları.&#34;MIKTARI&#34;&#62;]"/>
    </TfrxMasterData>
    <TfrxPageHeader Name="PageHeader1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="188.97637795" Left="0" Top="18.89765" Width="793.7013">
      <TfrxMemoView Name="Memo6" Left="646.29963" Top="77.5906" Width="71.81107" Height="18.89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" VAlign="vaCenter" Text="[Date] ">
        <Formats>
          <item FormatStr="dd.mm.yyyy" Kind="fkDateTime"/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo7" Left="646.41775" Top="100.26778" Width="94.48825" Height="18.89765" DisplayFormat.FormatStr="hh:nn" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" VAlign="vaCenter" Text="[Time]"/>
      <TfrxMemoView Name="Memo8" Left="646.29963" Top="125.28355" Width="204.09462" Height="18.89765" DataSet="baslikQ" DataSetName="İşlem Başlığı" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" VAlign="vaCenter" Text="[İşlem Başlığı.&#34;BELGENO&#34;]"/>
      <TfrxMemoView Name="Memo17" Left="37.57483" Top="83.26778" Width="257.00804" Height="49.13389" AllowHTMLTags="True" DataSet="baslikQ" DataSetName="İşlem Başlığı" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Cari Kart.&#34;FIRMAADI&#34;]"/>
    </TfrxPageHeader>
    <TfrxPageFooter Name="PageFooter1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="52.91342" Left="0" Top="351.49629" Width="793.7013"/>
  </TfrxReportPage>
</TfrxReport>
