<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="6.4.11" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Varsayılan" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="43846,6243161111" ReportOptions.Description.Text="" ReportOptions.LastChange="43846,6344584722" ScriptLanguage="PascalScript" ScriptText.Text="begin&#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="BELGENO" Value="49"/>
    <item Name="KARTNO" Value="49"/>
    <item Name="DETAYKARTNO" Value="49"/>
    <item Name="CARIID" Value="1"/>
    <item Name="TARIH" Value="18.11.2019"/>
  </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 B.*, P.AD +' '+ P.SOYAD AS PERSONEL, &#13;&#10; D.ACIKLAMA AS DEPO from TBLSATFATIADEBASLIK B 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               " MacroCreate="True" MacroExpand="True" ReadOnly="False" Left="100" Top="200">
      <Parameters>
        <item Name="KARTNO" DataType="ftInteger" Expression="&#60;BELGENO&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="detayQ" UserName="İşlem Detayları" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="baslikQ" IgnoreDupParams="False" SQL.Text="Select S.STOKKODU, S.CINSI, B.BIRIMADI,B.BARKOD, H.*, &#13;&#10; Cast(0.000 AS Decimal(18, 4)) AS ISKONTO1TOPLAMI,  Cast(0.000 AS Decimal(18, 4)) AS ISKONTO2TOPLAMI,  Cast(0.000 AS Decimal(18, 4)) AS ISKONTO3TOPLAMI, Cast(0.000 AS Decimal(18, 4)) AS ISKONTO4TOPLAMI, &#13;&#10; Cast(0.000 AS Decimal(18, 4)) AS KDVDAHILFIYAT, Cast(0.000 AS Decimal(18, 4)) AS KDVDAHILTUTAR From TBLSATFATIADEHAREKET H 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               " MacroCreate="True" MacroExpand="True" ReadOnly="False" Left="100" Top="300">
      <Parameters>
        <item Name="KARTNO" DataType="ftInteger"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="cariQ" UserName="Cari Kart" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select * from TBLCARI  WHERE KARTNO = :CARIID" MacroCreate="True" MacroExpand="True" ReadOnly="False" Left="100" Top="100">
      <Parameters>
        <item Name="CARIID" DataType="ftInteger" Expression="&#60;İşlem Başlığı.&#34;CARIID&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="KDVQ" UserName="KDV Grupları" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="baslikQ" IgnoreDupParams="False" SQL.Text="SELECT KDV, SUM(MIKTARI * FIYATI - ISKONTOTOPLAMI) AS KDVMATRAHI, SUM(KDVTUTARI) AS KDVTUTARI &#13;&#10; FROM TBLSTOKLAR WHERE FATURAID = :KARTNO GROUP BY KDV" MacroCreate="True" MacroExpand="True" ReadOnly="False" Left="100" Top="400">
      <Parameters>
        <item Name="KARTNO" DataType="ftInteger"/>
      </Parameters>
    </TfrxFDQuery>
  </TfrxDataPage>
  <TfrxReportPage Name="Sayfa" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" Frame.Typ="0" MirrorMode="0" HGuides.Text="" VGuides.Text="">
    <TfrxReportTitle Name="ReportTitle1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="83,14966" Left="0" Top="16" Width="718,1107" OnBeforePrint="ReportTitle1OnBeforePrint">
      <TfrxMemoView Name="Memo1" AllowVectorExport="True" Left="15,11812" Top="7,55906" Width="56,69295" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Firma : "/>
      <TfrxMemoView Name="Memo2" AllowVectorExport="True" Left="15,11812" Top="27,7953" Width="56,69295" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Tarih : "/>
      <TfrxMemoView Name="Memo3" AllowVectorExport="True" Left="15,11812" Top="49,03154" Width="56,69295" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Belge No : "/>
      <TfrxMemoView Name="CariKartFIRMAADI" IndexTag="1" AllowVectorExport="True" Left="79,37013" Top="7,55906" Width="400,63018" Height="18,89765" DataField="FIRMAADI" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Cari Kart.&#34;FIRMAADI&#34;]"/>
      <TfrxMemoView Name="Memo4" IndexTag="1" AllowVectorExport="True" Left="79,37013" Top="27,7953" Width="400,63018" Height="18,89765" DataField="TARIH" DataSet="baslikQ" DataSetName="İşlem Başlığı" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[İşlem Başlığı.&#34;TARIH&#34;]"/>
      <TfrxMemoView Name="Memo5" IndexTag="1" AllowVectorExport="True" Left="79,37013" Top="49,03154" Width="400,63018" Height="18,89765" DataField="BELGENO" DataSet="baslikQ" DataSetName="İşlem Başlığı" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[İşlem Başlığı.&#34;BELGENO&#34;]"/>
    </TfrxReportTitle>
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="22,67718" Left="0" Top="172" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="detayQ" DataSetName="İşlem Detayları" RowCount="0">
      <TfrxMemoView Name="lemDetaylarCINSI" IndexTag="1" AllowVectorExport="True" Left="124,72449" Top="3,77953" Width="495,11843" Height="18,89765" DataField="CINSI" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" WordBreak="True" WordWrap="False" Text="[İşlem Detayları.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="lemDetaylarBARKOD" IndexTag="1" AllowVectorExport="True" Left="3,77953" Top="3,77953" Width="120,94496" Height="18,89765" DataField="BARKOD" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" WordBreak="True" WordWrap="False" Text="[İşlem Detayları.&#34;BARKOD&#34;]"/>
      <TfrxMemoView Name="lemDetaylarMIKTARI" IndexTag="1" AllowVectorExport="True" Left="619,84292" Top="3,77953" Width="79,37013" Height="18,89765" DataField="MIKTARI" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordBreak="True" WordWrap="False" Text="[İşlem Detayları.&#34;MIKTARI&#34;]"/>
    </TfrxMasterData>
    <TfrxPageHeader Name="PageHeader1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="30,23624" Left="0" Top="120" Width="718,1107">
      <TfrxMemoView Name="Memo6" IndexTag="1" AllowVectorExport="True" Left="124,72449" Top="2,77953" Width="272,12616" Height="18,89765" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" WordBreak="True" WordWrap="False" Text="Cinsi"/>
      <TfrxMemoView Name="Memo7" IndexTag="1" AllowVectorExport="True" Left="3,77953" Top="2,77953" Width="120,94496" Height="18,89765" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" WordBreak="True" WordWrap="False" Text="Barkod"/>
      <TfrxMemoView Name="Memo8" IndexTag="1" AllowVectorExport="True" Left="619,84292" Top="2,77953" Width="79,37013" Height="18,89765" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" WordBreak="True" WordWrap="False" Text="Miktarı"/>
      <TfrxLineView Name="Line1" AllowVectorExport="True" Left="3,77953" Top="27,01577" Width="695,43307087" Height="0" Color="0" Frame.Typ="4"/>
    </TfrxPageHeader>
  </TfrxReportPage>
</TfrxReport>
