<?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="41977,7330592708" ReportOptions.Description.Text="" ReportOptions.LastChange="43846,6238614236" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;   showMessage(IntToSTr(&#60;KartNo&#62;));&#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ı"/>
    <item DataSet="cekiListesi" DataSetName="Çeki Listesi"/>
  </Datasets>
  <Variables>
    <item Name="BELGENO" Value="10"/>
    <item Name="KARTNO" Value="10"/>
    <item Name="DETAYKARTNO" Value="10"/>
    <item Name="CARIID" Value="1"/>
    <item Name="TARIH" Value="11.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 &#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" MacroCreate="True" MacroExpand="True" ReadOnly="False" Left="100" Top="200">
      <Parameters>
        <item Name="KARTNO" DataType="ftInteger" Expression="&#60;KARTNO&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <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, BRUTKDV - H.KDVTUTARI        &#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" MacroCreate="True" MacroExpand="True" ReadOnly="False" Left="100" Top="288">
      <Parameters>
        <item Name="KARTNO" DataType="ftInteger" Expression="&#60;İşlem Başlığı.&#34;KARTNO&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="cariQ" UserName="Cari Kart" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="baslikQ" 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 &#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" MacroCreate="True" MacroExpand="True" ReadOnly="False" Left="100" Top="400">
      <Parameters>
        <item Name="KARTNO" DataType="ftInteger" Expression="&#60;İşlem Başlığı.&#34;KARTNO&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="cekiListesi" UserName="Çeki Listesi" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="baslikQ" IgnoreDupParams="False" SQL.Text="SELECT &#13;&#10;  SERINO, STOKKODU, CINSI, R.KOD AS RENKKOD, R.ACIKLAMA AS RENK, LOTNO, KUTUNO, BRUT, DARA, BRUT - DARA AS NET&#13;&#10;from TBLFATURASERINODETAY D&#13;&#10;LEFT OUTER JOIN TBLFATURASERINOBASLIK SB ON SB.ID = D.BASLIKID&#13;&#10;LEFT OUTER JOIN TBLSATFATBASLIK FB ON FB.OZELKOD4 = SB.KOD&#13;&#10;LEFT OUTER JOIN TBLIPLIKCUVAL C ON C.SERINO = D.BARKOD&#13;&#10;LEFT OUTER JOIN TBLSTOKLAR ST ON ST.KARTNO = C.STOKID&#13;&#10;LEFT OUTER JOIN TBLBIRIMLEREX BX ON BX.KARTNO = ST.ANABIRIM&#13;&#10;LEFT OUTER JOIN TBLRENKLER R ON R.ID = C.RENKID&#13;&#10;WHERE FB.KARTNO = :KARTNO&#13;&#10;Order BY KUTUNO                                  " MacroCreate="True" MacroExpand="True" ReadOnly="False" Left="332" Top="104">
      <Parameters>
        <item Name="KARTNO" DataType="ftInteger" Expression="&#60;İşlem Başlığı.&#34;KARTNO&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
  </TfrxDataPage>
  <TfrxReportPage Name="Sayfa" PaperWidth="210" PaperHeight="400" PaperSize="256" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" Frame.Typ="0" EndlessHeight="True" MirrorMode="0" HGuides.Text="" VGuides.Text="">
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="26,45671" Left="0" Top="156" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="cekiListesi" DataSetName="Çeki Listesi" RowCount="0">
      <TfrxMemoView Name="ekiListesiCINSI" AllowVectorExport="True" Left="0" Top="3,77953" Width="245,66945" Height="18,89765" DataField="CINSI" DataSet="cekiListesi" DataSetName="Çeki Listesi" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Çeki Listesi.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="ekiListesiRENKKOD" AllowVectorExport="True" Left="245,66945" Top="3,77953" Width="71,81107" Height="18,89765" DataField="RENKKOD" DataSet="cekiListesi" DataSetName="Çeki Listesi" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Çeki Listesi.&#34;RENKKOD&#34;]"/>
      <TfrxMemoView Name="ekiListesiRENK" AllowVectorExport="True" Left="320,03958" Top="3,77953" Width="102,04731" Height="18,89765" DataField="RENK" DataSet="cekiListesi" DataSetName="Çeki Listesi" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Çeki Listesi.&#34;RENK&#34;]"/>
      <TfrxMemoView Name="ekiListesiLOTNO" AllowVectorExport="True" Left="427,08689" Top="3,77953" Width="117,16543" Height="18,89765" DataField="LOTNO" DataSet="cekiListesi" DataSetName="Çeki Listesi" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Çeki Listesi.&#34;LOTNO&#34;]"/>
      <TfrxMemoView Name="ekiListesiKUTUNO" AllowVectorExport="True" Left="544,25232" Top="3,77953" Width="90,70872" Height="18,89765" DataField="KUTUNO" DataSet="cekiListesi" DataSetName="Çeki Listesi" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Çeki Listesi.&#34;KUTUNO&#34;]"/>
      <TfrxMemoView Name="ekiListesiNET" AllowVectorExport="True" Left="634,96104" Top="3,77953" Width="79,37013" Height="18,89765" DataSet="cekiListesi" DataSetName="Çeki Listesi" DisplayFormat.FormatStr="#,#0.##0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Çeki Listesi.&#34;BRUT&#34;]"/>
    </TfrxMasterData>
    <TfrxReportTitle Name="ReportTitle1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="64,25201" Left="0" Top="16" Width="718,1107">
      <TfrxMemoView Name="CariKartFIRMAKODU" AllowVectorExport="True" Left="18,89765" Top="13,57483" Width="684,09493" Height="18,89765" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="PARADOX FATURA ÇEKİ LİSTESİ"/>
    </TfrxReportTitle>
    <TfrxPageHeader Name="PageHeader1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="34,01577" Left="0" Top="100" Width="718,1107">
      <TfrxMemoView Name="Memo1" AllowVectorExport="True" Left="0" Top="0" Width="245,66945" Height="18,89765" DataSet="cekiListesi" DataSetName="Çeki Listesi" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Cinsi"/>
      <TfrxMemoView Name="Memo2" AllowVectorExport="True" Left="245,66945" Top="0" Width="71,81107" Height="18,89765" DataSet="cekiListesi" DataSetName="Çeki Listesi" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Renk Kod"/>
      <TfrxMemoView Name="Memo3" AllowVectorExport="True" Left="320,03958" Top="0" Width="102,04731" Height="18,89765" DataSet="cekiListesi" DataSetName="Çeki Listesi" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Renk"/>
      <TfrxMemoView Name="Memo4" AllowVectorExport="True" Left="427,08689" Top="0" Width="117,16543" Height="18,89765" DataSet="cekiListesi" DataSetName="Çeki Listesi" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Lot No"/>
      <TfrxMemoView Name="Memo5" AllowVectorExport="True" Left="544,25232" Top="0" Width="90,70872" Height="18,89765" DataSet="cekiListesi" DataSetName="Çeki Listesi" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Kutu No"/>
      <TfrxMemoView Name="Memo6" AllowVectorExport="True" Left="634,96104" Top="0" Width="79,37013" Height="18,89765" DataSet="cekiListesi" DataSetName="Çeki Listesi" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="KG"/>
      <TfrxLineView Name="Line1" AllowVectorExport="True" Left="-0,22047" Top="26,45671" Width="718,1107" Height="0" Color="0" Frame.Typ="4"/>
    </TfrxPageHeader>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="83,14966" Left="0" Top="204" Width="718,1107">
      <TfrxLineView Name="Line2" AllowVectorExport="True" Left="536,69326" Top="7,55906" Width="181,41744" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo7" AllowVectorExport="True" Left="404,40971" Top="22,67718" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Toplam: "/>
      <TfrxMemoView Name="Memo8" AllowVectorExport="True" Left="634,96104" Top="22,67718" Width="79,37013" 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" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Çeki Listesi.&#34;BRUT&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo9" AllowVectorExport="True" Left="544,25232" Top="22,67718" Width="90,70872" Height="18,89765" DisplayFormat.FormatStr="#,#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[COUNT(MasterData1)]"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
