<?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="41977,7330592708" ReportOptions.Description.Text="" ReportOptions.LastChange="42998,7617732292" ScriptLanguage="PascalScript" ScriptText.Text="procedure reportOnStartReport(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;&#13;&#10;end;&#13;&#10;&#13;&#10;begin&#13;&#10;  // ShowMessage('Kart No: ' + IntToStr(&#60;BelgeNo&#62;));&#13;&#10;end." OnStartReport="reportOnStartReport">
  <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="bankaQ" DataSetName="Banka"/>
  </Datasets>
  <Variables>
    <item Name="BELGENO" Value="79"/>
    <item Name="KARTNO" Value="79"/>
    <item Name="CARIID" Value="5"/>
    <item Name="TARIH" Value="22.08.2017"/>
  </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, ISNULL(DV.ACIKLAMA, 'TL') AS DOVIZSEMBOL   &#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;LEFT OUTER JOIN TBLDOVIZLER DV ON DV.KARTNO = B.DOVIZID    &#13;&#10;WHERE B.KARTNO = :KARTNO" PropData="05704C65667402640470546F7003C8000A506172616D657465727301010642204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B42656C67654E6F262336323B220000"/>
    <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" PropData="05704C65667402640470546F700320010A506172616D65746572730101145F000000204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303BC4B0C59F6C656D204261C59F6CC4B1C49FC4B12E262333343B4B4152544E4F262333343B262336323B220000"/>
    <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="05704C65667402640470546F7002640A506172616D65746572730101145F000000204E616D653D22434152494944222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303BC4B0C59F6C656D204261C59F6CC4B1C49FC4B12E262333343B434152494944262333343B262336323B220000"/>
    <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="05704C65667402640470546F700390010A506172616D65746572730101145F000000204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303BC4B0C59F6C656D204261C59F6CC4B1C49FC4B12E262333343B4B4152544E4F262333343B262336323B220000"/>
    <TfrxFDQuery Name="bankaQ" UserName="Banka" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SELECT * FROM TBLCARIBANKALAR WHERE CARIKARTNO = :CARIID                                                                                                               " PropData="05704C65667403B8000470546F7002680A506172616D65746572730101145F000000204E616D653D22434152494944222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303BC4B0C59F6C656D204261C59F6CC4B1C49FC4B12E262333343B434152494944262333343B262336323B220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Sayfa" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxDetailData Name="DetailData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="22,67718" Left="0" Top="638,74057" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="detayQ" DataSetName="İşlem Detayları" RowCount="0">
      <TfrxMemoView Name="lemDetaylarCINSI" Left="7,55906" Top="0" Width="188,9765" Height="22,67716535" DataField="CINSI" DataSet="detayQ" DataSetName="İşlem Detayları" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="13" GapX="5" ParentFont="False" VAlign="vaCenter" Text="[İşlem Detayları.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="lemDetaylarMIKTARI" Left="324,66141732" Top="0" Width="112,2519685" Height="22,67716535" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="15" GapX="8" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="[İşlem Detayları.&#34;MIKTARI&#34;] [İşlem Detayları.&#34;BIRIMADI&#34;]"/>
      <TfrxMemoView Name="lemDetaylarFIYATI" Left="437,20501" Top="0" Width="102,80314961" Height="22,67716535" DataField="FIYATI" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.DecimalSeparator="," DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="14" GapX="8" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="[İşlem Detayları.&#34;FIYATI&#34;]"/>
      <TfrxMemoView Name="Memo4" Left="612,04762" Top="0" Width="95,24409449" Height="22,67716535" DataSet="detayQ" DataSetName="İşlem Detayları" DisplayFormat.DecimalSeparator="," DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="15" GapX="8" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="[&#60;İşlem Detayları.&#34;MIKTARI&#34;&#62; * &#60;İşlem Detayları.&#34;FIYATI&#34;&#62;]"/>
      <TfrxMemoView Name="Memo9" Left="196,53556" Top="0" Width="71,81107" Height="22,67716535" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="14" GapX="8" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[İşlem Detayları.&#34;STOKKODU&#34;]"/>
      <TfrxMemoView Name="Memo3" Left="267,90569" Top="0" Width="56,69295" Height="22,67716535" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text=""/>
      <TfrxMemoView Name="Memo33" Left="540,47279" Top="0" Width="71,81107" Height="22,67716535" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text=""/>
    </TfrxDetailData>
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="401,38582677" Left="0" Top="215,43321" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="baslikQ" DataSetName="İşlem Başlığı" RowCount="0">
      <TfrxShapeView Name="Shape2" Left="7,55906" Top="188,9765" Width="699,21305" Height="162,51968503937"/>
      <TfrxShapeView Name="Shape1" Left="7,55906" Top="41,57483" Width="699,21305" Height="132,28355"/>
      <TfrxMemoView Name="CariKartFIRMAUNVANI" Left="7,55906" Top="11,33859" Width="774,80365" Height="26,45671" StretchMode="smActualHeight" DataField="FIRMAUNVANI" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-24" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="False" Text="[Cari Kart.&#34;FIRMAUNVANI&#34;]"/>
      <TfrxMemoView Name="CariKartADRES" Left="34,01577" Top="60,47248" Width="377,953" Height="41,57483" StretchMode="smActualHeight" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-37" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Proforma Invoice"/>
      <TfrxMemoView Name="Memo1" Left="34,01577" Top="124,72449" Width="113,3859" Height="18,89765" Text="Date: [İşlem Başlığı.&#34;TARIH&#34;]"/>
      <TfrxMemoView Name="Memo2" Left="158,74026" Top="124,72449" Width="166,29932" Height="18,89765" Text="Invoice No: [İşlem Başlığı.&#34;BELGENO&#34;]"/>
      <TfrxMemoView Name="Memo10" Left="434,64595" Top="68,03154" Width="309,92146" Height="18,89765" Text="Tel: 0086-757-82263621"/>
      <TfrxMemoView Name="Memo11" Left="434,64595" Top="90,7086614173228" Width="309,92146" Height="18,89765" Text="Fax: 0086-757-82263612   ADD: Floor 20"/>
      <TfrxMemoView Name="Memo12" Left="434,64595" Top="113,385826771654" Width="309,92146" Height="18,89765" Text="Building T8, Smart City, Ji hua 1 road"/>
      <TfrxMemoView Name="Memo13" Left="434,64595" Top="136,062992125984" Width="309,92146" Height="18,89765" Text="Changcheng diatrict, Fosha, China"/>
      <TfrxMemoView Name="Memo14" Left="37,7953" Top="207,87415" Width="302,3624" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="TALYA İTHALAT İHRACAT LOJİSTİK"/>
      <TfrxMemoView Name="Memo21" Left="37,7953" Top="241,88992" Width="321,26005" Height="56,69295" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="ADRES: İNCİLİPINAR MAH. 7 NOLU SK.&#13;&#10;KAPLAMA İŞ MRK. KAT: 3 NO: 12&#13;&#10;GAZİANTEP"/>
      <TfrxMemoView Name="Memo22" Left="393,07112" Top="207,87415" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="SENT TO:"/>
      <TfrxMemoView Name="Memo23" Left="393,07112" Top="238,11039" Width="287,24428" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="NAME: [Cari Kart.&#34;FIRMAUNVANI&#34;]"/>
      <TfrxMemoView Name="Memo24" Left="393,07112" Top="260,78740157" Width="328,81911" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="AC NO: [Banka.&#34;HESAPNO&#34;]"/>
      <TfrxMemoView Name="Memo25" Left="393,07112" Top="283,46456693" Width="328,81911" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="SWIFT: [Banka.&#34;SWIFTKOD&#34;]"/>
      <TfrxMemoView Name="Memo26" Left="393,07112" Top="306,14173228" Width="302,3624" Height="22,67718" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="BANK NAME: [Banka.&#34;BANKAADI&#34;]"/>
      <TfrxLineView Name="Line1" Left="370,39394" Top="191,97637795" Width="0" Height="162,141732283465" Color="0" Frame.Typ="1"/>
      <TfrxMemoView Name="Memo27" Left="7,55906" Top="351,49606299" Width="260,78757" Height="45,35433071" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="11" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="FUL DESCRIPTION OF GOODS"/>
      <TfrxMemoView Name="Memo28" Left="267,90569" Top="351,49606299" Width="56,69295" Height="45,35433071" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="11" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text=""/>
      <TfrxMemoView Name="Memo29" Left="324,66141732" Top="351,49606299" Width="112,2519685" Height="40,81889764" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="11" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="QTY"/>
      <TfrxMemoView Name="Memo30" Left="437,20501" Top="351,49606299" Width="102,80314961" Height="45,35433071" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="11" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="UNIT PRICE"/>
      <TfrxMemoView Name="Memo31" Left="540,47279" Top="351,49606299" Width="71,81107" Height="45,35433071" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="11" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text=""/>
      <TfrxMemoView Name="Memo32" Left="612,04762" Top="351,49606299" Width="95,244094488189" Height="45,35433071" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="11" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="TOTAL"/>
    </TfrxMasterData>
    <TfrxReportTitle Name="ReportTitle1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="136,06308" Left="0" Top="18,89765" Width="718,1107"/>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="136,06308" Left="0" Top="721,89023" Width="718,1107">
      <TfrxMemoView Name="Memo8" Left="612,04762" Top="7,55899409" Width="95,24409449" Height="18,89765" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[İşlem Başlığı.&#34;TUTARI&#34;] [İşlem Başlığı.&#34;DOVIZSEMBOL&#34;]"/>
      <TfrxMemoView Name="Memo20" Left="359,05535" Top="7,55899409" Width="249,44898" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="TOTAL VALUE AND CURRENCY"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
