<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="5.3.16" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Varsayılan" PrintOptions.PrintOnSheet="0" ReportOptions.Author="Cüneyt ELİBOL" ReportOptions.CreateDate="42863" ReportOptions.Description.Text="" ReportOptions.LastChange="42863,7304270949" ScriptLanguage="PascalScript" ScriptText.Text="&#13;&#10;begin&#13;&#10;                              &#13;&#10;end.">
  <Datasets>
    <item DataSet="detayQ" DataSetName="Alanlar"/>
    <item DataSet="baslikQ" DataSetName="İş Emri"/>
  </Datasets>
  <TfrxDataPage Name="PXData" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDQuery Name="detayQ" UserName="Alanlar" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text=" SELECT  &#13;&#10;  'HAMMADDE' AS ISLEM, S.STOKKODU, S.CINSI, SUM(UD.MIKTAR * D.MIKTAR) AS MIKTAR, BX.BIRIMADI, ISNULL(S.MALIYET, BX.ALISFIYATI1) AS MALIYETF, &#13;&#10;  SUM(UD.MIKTAR * D.MIKTAR) * S.MALIYET AS TUTARI &#13;&#10; FROM TBLSTOKURETIMISEMRIDETAY D &#13;&#10; LEFT OUTER JOIN TBLSTOKURETIMISEMRI I ON D.BASLIKID = I.ID &#13;&#10; LEFT OUTER JOIN TBLSTOKURUNAGACI U ON U.ID = I.URUNAGACIID &#13;&#10; LEFT OUTER JOIN TBLSTOKURUNAGACIDETAY UD ON UD.BASLIKID = U.ID AND UD.BEDENID IN(-1, D.BEDEN) AND UD.RENKID IN(-1, D.RENK) &#13;&#10; LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = UD.DETAYID &#13;&#10; LEFT OUTER JOIN TBLBIRIMLEREX BX WITH(INDEX=TBLBIRIMLEREX_KARTNO) ON S.ANABIRIM = BX.KARTNO &#13;&#10; WHERE D.BASLIKID = :ISEMRIID   &#13;&#10; GROUP BY S.STOKKODU, S.CINSI, BIRIMADI, S.MALIYET, ALISFIYATI1 &#13;&#10; UNION ALL &#13;&#10; SELECT  &#13;&#10;   'FASON', 'FASON ÜCRETİ', 'FASON ÜCRETİ', NULL, NULL, SUM(TUTARI), SUM(TUTARI)  &#13;&#10; FROM TBLSTOKURETIMISEMRIHAREKET  &#13;&#10; WHERE ISEMRINO = :ISEMRIID   " PropData="05704C656674023C0470546F7002780A506172616D657465727301010625204E616D653D224953454D52494944222044617461547970653D226674496E74656765722200010625204E616D653D224953454D52494944222044617461547970653D226674496E7465676572220000"/>
    <TfrxFDQuery Name="baslikQ" UserName="İş Emri" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select&#13;&#10;  TARIH, BELGENO, B.ACIKLAMA, S.STOKKODU, S.CINSI, B.MIKTARI,S.RESIM,                  &#13;&#10;  0.000 AS HAMMADDEGIDERI, 0.000 AS FASONUCRETI, 0.000 AS MALIYET&#13;&#10;from TBLSTOKURETIMISEMRI B&#13;&#10;LEFT OUTER JOIN TBLSTOKURUNAGACI UA ON UA.ID = B.URUNAGACIID&#13;&#10;LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = UA.CIKISSTOK&#13;&#10;WHERE B.ID = :ISEMRIID                &#13;&#10;  " PropData="05704C656674023C0470546F7002280A506172616D657465727301010625204E616D653D224953454D52494944222044617461547970653D226674496E7465676572220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="SAYFA" PaperWidth="210" PaperHeight="297" PaperSize="256" LeftMargin="5" RightMargin="5" TopMargin="5" BottomMargin="5" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxPageHeader Name="HEADER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="232,28355" Left="0" Top="18,89765" Width="755,906">
      <TfrxMemoView Name="BASLIK" Left="4,76376" Top="2,44094" Width="451,41713" Height="25" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="PARADOX Rapor"/>
      <TfrxMemoView Name="TARIH" Left="4,56648" Top="32,55906" Width="125" Height="20" Text="[Date]"/>
      <TfrxLineView Name="BASLIKCIZGI" Left="1" Top="230,28355" Width="800" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="ISLEMBASLIK" Left="37,7953" Top="207,28355" Width="100" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="İşlem"/>
      <TfrxMemoView Name="STOKKODUBASLIK" Left="139,01577" Top="207,28355" Width="100" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Stok Kodu"/>
      <TfrxMemoView Name="CINSIBASLIK" Left="237,23624" Top="207,28355" Width="220,94496" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Cinsi"/>
      <TfrxMemoView Name="MIKTARBASLIK" Left="462,40167" Top="207,28355" Width="58,42517" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Miktar"/>
      <TfrxMemoView Name="BIRIMADIBASLIK" Left="522,04731" Top="207,28355" Width="65,98423" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Birim"/>
      <TfrxMemoView Name="MALIYETFBASLIK" Left="589,25201" Top="207,28355" Width="60,47243118" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Fiyatı"/>
      <TfrxMemoView Name="TUTARIBASLIK" Left="652,67718" Top="207,28355" Width="102,04726118" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Tutarı"/>
      <TfrxMemoView Name="Memo1" Left="2,33859" Top="207,87415" Width="34,01577" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="S.No"/>
      <TfrxMemoView Name="Memo3" Left="7,55906" Top="71,81107" Width="102,04731" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Belge No : "/>
      <TfrxMemoView Name="Memo4" Left="7,55906" Top="93,04731" Width="102,04731" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Açıklama : "/>
      <TfrxMemoView Name="Memo5" Left="7,55906" Top="114,141732283465" Width="102,04731" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Çıkış Stok : "/>
      <TfrxMemoView Name="Memo6" Left="7,55906" Top="135,307086614173" Width="102,04731" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Çıkış Miktarı : "/>
      <TfrxPictureView Name="Picture1" Left="461,10266" Top="0" Width="287,24428" Height="188,9765" Center="True" DataField="RESIM" DataSet="baslikQ" DataSetName="İş Emri" HightQuality="False" Transparent="False" TransparentColor="16777215"/>
      <TfrxMemoView Name="Memo13" Left="113,3859" Top="71,81107" Width="257,00804" Height="18,89765" DataField="BELGENO" DataSet="baslikQ" DataSetName="İş Emri" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[İş Emri.&#34;BELGENO&#34;]"/>
      <TfrxMemoView Name="Memo14" Left="113,3859" Top="93,04731" Width="343,93723" Height="18,89765" DataField="ACIKLAMA" DataSet="baslikQ" DataSetName="İş Emri" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[İş Emri.&#34;ACIKLAMA&#34;]"/>
      <TfrxMemoView Name="Memo15" Left="113,3859" Top="114,14173228" Width="343,93723" Height="18,89765" DataField="CINSI" DataSet="baslikQ" DataSetName="İş Emri" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[İş Emri.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="Memo16" Left="113,3859" Top="135,30708661" Width="79,37013" Height="18,89765" DataField="MIKTARI" DataSet="baslikQ" DataSetName="İş Emri" DisplayFormat.FormatStr="#,#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[İş Emri.&#34;MIKTARI&#34;]"/>
    </TfrxPageHeader>
    <TfrxMasterData Name="MASTERDATA" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="17,22047" Left="0" Top="313,70099" Width="755,906" ColumnWidth="0" ColumnGap="0" DataSet="detayQ" DataSetName="Alanlar" RowCount="0">
      <TfrxMemoView Name="ISLEMVIEW" Left="37,7953" Top="1" Width="100" Height="16,22047" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;ISLEM&#34;]"/>
      <TfrxMemoView Name="STOKKODUVIEW" Left="139,01577" Top="1" Width="100" Height="16,22047" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;STOKKODU&#34;]"/>
      <TfrxMemoView Name="CINSIVIEW" Left="237,23624" Top="1" Width="220,94496" Height="16,22047" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="MIKTARVIEW" Left="462,40167" Top="1" Width="58,42517" Height="16,22047" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;MIKTAR&#34;]"/>
      <TfrxMemoView Name="BIRIMADIVIEW" Left="522,04731" Top="1" Width="65,98423" Height="16,22047" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;BIRIMADI&#34;]"/>
      <TfrxMemoView Name="MALIYETFVIEW" Left="589,25201" Top="1" Width="60,47243118" Height="16,22047" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;MALIYETF&#34;]"/>
      <TfrxMemoView Name="TUTARIVIEW" Left="652,67718" Top="1" Width="102,04726118" Height="16,22047" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;TUTARI&#34;]"/>
      <TfrxMemoView Name="Memo2" Left="2,33859" Top="1" Width="34,01577" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Line#]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="FOOTER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="40" Left="0" Top="532,91373" Width="755,906">
      <TfrxLineView Name="FOOTERCIZGI" Left="1" Top="1" Width="800" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="FOOTERBASLIK" Left="35" Top="10" Width="650" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="PARADOX ile [date] Tarihinde Yazdırılmıştır"/>
      <TfrxMemoView Name="FOOTERSAYFA" Left="670" Top="10" Width="120" Height="25" Text="Sayfa:  [Page#] / [TotalPages#]"/>
    </TfrxPageFooter>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="117,16543" Left="0" Top="393,07112" Width="755,906">
      <TfrxMemoView Name="Memo9" Left="462,40167" Top="43,0865385" Width="58,42517" Height="18,89765" DataSet="baslikQ" DataSetName="İş Emri" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;TUTARI&#34;&#62;,MASTERDATA) / &#60;İş Emri.&#34;MIKTARI&#34;&#62;]"/>
      <TfrxMemoView Name="Memo12" Left="351,49629" Top="43,0865385" Width="102,04731" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Ürün Maliyeti : "/>
      <TfrxLineView Name="Line1" Left="3,77953" Top="7,55906" Width="748,34694" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo7" Left="385,51206" Top="15,11812" Width="68,03154" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Toplamlar"/>
      <TfrxMemoView Name="Memo8" Left="462,40167" Top="15,11812" Width="58,42517" Height="18,89765" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;MIKTAR&#34;&#62;)]"/>
      <TfrxSysMemoView Name="SysMemo1" Left="652,67718" Top="15,11812" Width="102,04726118" Height="18,89765" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;TUTARI&#34;&#62;,MASTERDATA)]"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
