<?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.CreateDate="42646,5752583102" ReportOptions.Description.Text="" ReportOptions.LastChange="42648,6566916667" ScriptLanguage="PascalScript" ScriptText.Text="&#13;&#10;begin&#13;&#10;&#13;&#10;end.">
  <Datasets>
    <item DataSet="baslikQ" DataSetName="İş Emri Başlık Bilgileri"/>
    <item DataSet="detayQ" DataSetName="İş Emri Renk / Detay"/>
    <item DataSet="hammaddeQ" DataSetName="Hammaddeler"/>
    <item DataSet="fasoncuQ" DataSetName="Fasoncu"/>
  </Datasets>
  <Variables>
    <item Name="KARTNO" Value="1"/>
    <item Name="CARIID" Value="1"/>
    <item Name="TARIH" Value="30.09.2016"/>
    <item Name="DETAYKARTNO" Value="1"/>
  </Variables>
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDQuery Name="baslikQ" UserName="İş Emri Başlık Bilgileri" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SELECT &#13;&#10;  I.*, S.STOKKODU, S.CINSI, S.RESIM                   &#13;&#10;FROM TBLSTOKURETIMISEMRI I&#13;&#10;LEFT OUTER JOIN TBLSTOKURUNAGACI U ON U.ID = I.URUNAGACIID&#13;&#10;LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = U.CIKISSTOK&#13;&#10;WHERE I.ID = :ID                                                 " PropData="05704C65667402700470546F7002440A506172616D65746572730101063D204E616D653D224944222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B4B4152544E4F262336323B220000"/>
    <TfrxFDQuery Name="detayQ" UserName="İş Emri Renk / Detay" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SELECT &#13;&#10;  R.KOD AS RENKKOD, R.ACIKLAMA AS RENKACIKLAMA, &#13;&#10;  B.KOD AS BEDENKOD, B.ACIKLAMA AS BEDENACIKLAMA,&#13;&#10;  D.MIKTAR&#13;&#10;FROM TBLSTOKURETIMISEMRIDETAY D&#13;&#10;LEFT OUTER JOIN TBLRENKLER R ON R.ID = D.RENK&#13;&#10;LEFT OUTER JOIN TBLBEDENLER B ON B.ID = D.BEDEN&#13;&#10;WHERE D.BASLIKID = :ID                          " PropData="05704C65667403B4000470546F7002440A506172616D65746572730101063D204E616D653D224944222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B4B4152544E4F262336323B220000"/>
    <TfrxFDQuery Name="hammaddeQ" UserName="Hammaddeler" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SELECT &#13;&#10; S.STOKKODU, S.CINSI, SUM(UD.MIKTAR * D.MIKTAR) AS MIKTAR, BX.BIRIMADI&#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 = :ID    &#13;&#10;GROUP BY S.STOKKODU, S.CINSI, BIRIMADI&#13;&#10;  " PropData="05704C65667403F0000470546F7002440A506172616D65746572730101063D204E616D653D224944222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B4B4152544E4F262336323B220000"/>
    <TfrxFDQuery Name="fasoncuQ" UserName="Fasoncu" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select * from TBLCARI WHERE KARTNO =                                                                                   &#13;&#10;  (SELECT TOP 1 FASONCU FROM TBLSTOKURETIMISEMRIHAREKET WHERE ISEMRINO = :ID ORDER BY KAYITTARIHI DESC)  " PropData="05704C6566740338010470546F7002440A506172616D65746572730101063D204E616D653D224944222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B4B4152544E4F262336323B220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="20" Left="0" Top="294,80334" Width="718,1107" ColumnWidth="0" ColumnGap="0" RowCount="0"/>
    <TfrxPageFooter Name="PageFooter1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="37,7953" Left="0" Top="374,17347" Width="718,1107">
      <TfrxLineView Name="Line3" Left="7,55906" Top="3,77953" Width="706,77211" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo15" Left="7,55906" Top="11,33859" Width="702,99258" Height="18,89765" AllowHTMLTags="True" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="False" Text="[Date] Tarihinde &#60;b&#62;PARADOX&#60;/b&#62; (http://www.elibolyazilim.com) ile yazdırılmıştır"/>
    </TfrxPageFooter>
    <TfrxPageHeader Name="PageHeader1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="215,43321" Left="0" Top="18,89765" Width="718,1107">
      <TfrxMemoView Name="Memo1" Left="11,33859" Top="49,13389" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Tarih : "/>
      <TfrxMemoView Name="Memo3" Left="11,33859" Top="71,81104559" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Fasoncu : "/>
      <TfrxMemoView Name="Memo4" Left="11,33859" Top="139,84251969" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Miktarı : "/>
      <TfrxMemoView Name="EmriBalkBilgileriTARIH" Left="109,60637" Top="49,13389" Width="257,00804" Height="18,89765" DataField="TARIH" DataSet="baslikQ" DataSetName="İş Emri Başlık Bilgileri" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[İş Emri Başlık Bilgileri.&#34;TARIH&#34;]"/>
      <TfrxMemoView Name="EmriBalkBilgileriMIKTARI" Left="109,60637" Top="139,84251969" Width="79,37013" Height="18,89765" DataField="MIKTARI" DataSet="baslikQ" DataSetName="İş Emri Başlık Bilgileri" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[İş Emri Başlık Bilgileri.&#34;MIKTARI&#34;]"/>
      <TfrxMemoView Name="Memo5" Left="26,45671" Top="94,48825" Width="79,37013" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Stok Kodu : "/>
      <TfrxMemoView Name="Memo6" Left="26,45671" Top="117,16535433" Width="79,37013" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Cinsi : "/>
      <TfrxMemoView Name="EmriBalkBilgileriSTOKKODU" Left="109,60637" Top="94,48825" Width="253,22851" Height="18,89765" DataField="STOKKODU" DataSet="baslikQ" DataSetName="İş Emri Başlık Bilgileri" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[İş Emri Başlık Bilgileri.&#34;STOKKODU&#34;]"/>
      <TfrxMemoView Name="EmriBalkBilgileriCINSI" Left="109,60637" Top="117,16535433" Width="253,22851" Height="18,89765" DataField="CINSI" DataSet="baslikQ" DataSetName="İş Emri Başlık Bilgileri" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[İş Emri Başlık Bilgileri.&#34;CINSI&#34;]"/>
      <TfrxLineView Name="Line1" Left="7,55906" Top="211,65368" Width="702,99258" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo7" Left="11,33859" Top="3,77953" Width="699,21305" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="ERDİNÇ TEKSTİL - FASON ÇIKIŞ FİŞİ"/>
      <TfrxMemoView Name="FasoncuFIRMAADI" Left="109,60637" Top="71,81104559" Width="257,00804" Height="18,89765" DataField="FIRMAADI" DataSet="fasoncuQ" DataSetName="Fasoncu" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Fasoncu.&#34;FIRMAADI&#34;]"/>
      <TfrxPictureView Name="Picture1" Left="366,85065" Top="34,01577" Width="317,48052" Height="166,29932" DataField="RESIM" DataSet="baslikQ" DataSetName="İş Emri Başlık Bilgileri" HightQuality="False" Transparent="False" TransparentColor="16777215"/>
    </TfrxPageHeader>
  </TfrxReportPage>
</TfrxReport>
