<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="4.13.1" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Varsayılan" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="41440,6437714005" ReportOptions.Description.Text="" ReportOptions.LastChange="41584,6940732407" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;&#13;&#10;end." PropData="044C65667403900103546F700380010844617461736574730101142F00000020446174615365743D22706B74512220446174615365744E616D653D2247C3B66E646572696D204C697374657369220001062420446174615365743D2263617269512220446174615365744E616D653D224669726D61220001062820446174615365743D226B6F6C694E6F512220446174615365744E616D653D224B6F6C696C6572220001062720446174615365743D227365766B512220446174615365744E616D653D225365766B69796174220000095661726961626C65730100055374796C650100">
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TFrxFDQuery Name="pktQ" UserName="Gönderim Listesi" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="koliNoQ" IgnoreDupParams="False" SQL.Text="Select&#13;&#10; KOLINO,  K.KOD AS KALITE, E.ACIKLAMA, S.MIKTARI, (E.EN * E.BOY * S.MIKTARI) / 10000.00 AS M2    &#13;&#10;From TBLSEVKIYATKOLI S WITH(INDEX=TBLSEVKIYATKOLI_SEVKIYATNO)&#13;&#10;LEFT OUTER JOIN TBLKALITELER K ON K.ID = S.KALITEID&#13;&#10;LEFT OUTER JOIN TBLEBATLAR E ON E.ID = S.EBATID&#13;&#10;WHERE SEVKIYATNO = :SEVKIYATNO AND KOLINO = :KOLINO                                                                                                                                  &#13;&#10;    " PropData="05704C65667402480470546F7003B0000A506172616D657465727301010627204E616D653D225345564B495941544E4F222044617461547970653D226674496E74656765722200010623204E616D653D224B4F4C494E4F222044617461547970653D226674496E7465676572220000"/>
    <TFrxFDQuery Name="cariQ" UserName="Firma" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select&#13;&#10;  :SEVKIYATNO AS SEVKIYATKARTNO, P.AD + ' ' + P.SOYAD AS PERSONEL, C.*,&#13;&#10;  (Select BARKOD From TBLSEVKIYATEMRIBASLIK WITH(INDEX=TBLSEVKIYATEMRIBASLIK_KARTNO) WHERE KARTNO = :SEVKIYATNO) AS SEVKBARKOD,                                  &#13;&#10;  (Select SEVKADRESI FROM TBLURETIMALSIPBASLIK WHERE KARTNO = &#13;&#10;     (Select SIPARISID From TBLSEVKIYATEMRIBASLIK WITH(INDEX=TBLSEVKIYATEMRIBASLIK_KARTNO) WHERE KARTNO = :SEVKIYATNO)) AS SEVKADRESI                              &#13;&#10;From TBLCARI C WITH(INDEX=TBLCARI_KARTNO)&#13;&#10;LEFT OUTER JOIN TBLPERSONEL P ON P.KARTNO = C.SORUMLUPERSONEL    &#13;&#10;WHERE C.KARTNO = (Select CARIID From TBLSEVKIYATEMRIBASLIK WITH(INDEX=TBLSEVKIYATEMRIBASLIK_KARTNO) WHERE KARTNO = :SEVKIYATNO)&#13;&#10;    " PropData="05704C65667402480470546F7002180A506172616D657465727301010627204E616D653D225345564B495941544E4F222044617461547970653D226674496E74656765722200010627204E616D653D225345564B495941544E4F222044617461547970653D226674496E74656765722200010627204E616D653D225345564B495941544E4F222044617461547970653D226674496E74656765722200010627204E616D653D225345564B495941544E4F222044617461547970653D226674496E7465676572220000"/>
    <TFrxFDQuery Name="koliNoQ" UserName="Koliler" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select&#13;&#10;  KOLINO,&#13;&#10;  SUM(M2) AS M2, SUM(KG) AS KG FROM(&#13;&#10;Select&#13;&#10;  KOLINO, MIKTARI,&#13;&#10;  MIKTARI * (Select Round(EN * BOY / 10000.00, 2) FROM TBLEBATLAR WHERE ID = S.EBATID) AS M2,&#13;&#10;  MIKTARI * (Select EN * BOY / 10000.00 FROM TBLEBATLAR WHERE ID = S.EBATID) * &#13;&#10;     (Select GRAMAJ / 1000.00 FROM TBLKALITELER WHERE ID = S.KALITEID) AS KG&#13;&#10;From TBLSEVKIYATKOLI S WITH(INDEX=TBLSEVKIYATKOLI_SEVKIYATNO)&#13;&#10;&#13;&#10;WHERE SEVKIYATNO = :SEVKIYATNO     &#13;&#10;)AS A&#13;&#10;Group By KOLINO    " PropData="05704C65667402480470546F70026C0A506172616D65746572730101065D204E616D653D225345564B495941544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B4669726D612E262333343B5345564B495941544B4152544E4F262333343B262336323B220000"/>
    <TFrxFDQuery Name="sevkQ" UserName="Sevkiyat" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SELECT&#13;&#10;  B.TARIH,                                &#13;&#10;  TBLKALITELER.KOD AS KALITE,&#13;&#10;  TBLRENKLER.KOD AS RENK,&#13;&#10;  TBLEBATLAR.KOD AS EBAT,&#13;&#10;  TBLDESENLER.KOD AS DESEN,&#13;&#10;  H.MIKTARI&#13;&#10;FROM TBLSEVKIYATEMRIHAREKET H&#13;&#10;INNER JOIN TBLSEVKIYATEMRIBASLIK B WITH(INDEX=TBLSEVKIYATEMRIBASLIK_KARTNO) ON B.KARTNO = H.FATURAID                                                                                                                               &#13;&#10;INNER JOIN TBLKALITELER ON (H.KALITEID = TBLKALITELER.ID)&#13;&#10;INNER JOIN TBLEBATLAR ON (H.EBATID = TBLEBATLAR.ID)&#13;&#10;INNER JOIN TBLDESENLER ON (H.DESENID = TBLDESENLER.ID)&#13;&#10;INNER JOIN TBLRENKLER ON (H.RENKID = TBLRENKLER.ID)  &#13;&#10;WHERE H.FATURAID = :SEVKIYATNO                      " PropData="05704C65667402480470546F7003FC000A506172616D65746572730101065D204E616D653D225345564B495941544E4F222044617461547970653D226674496E7465676572222045787072657373696F6E3D22262336303B4669726D612E262333343B5345564B495941544B4152544E4F262333343B262336323B220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="190" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxMasterData Name="MasterData1" Height="147,40167" Left="0" Top="18,89765" Width="718,1107" ColumnWidth="718,110236220472" ColumnGap="3,77952755905512" DataSet="koliNoQ" DataSetName="Koliler" RowCount="0" StartNewPage="True">
      <TfrxLineView Name="Line2" Left="3,77953" Top="142,92919" Width="706,77211" Height="0" ShowHint="False" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo3" Left="7,55906" Top="3,77953" Width="340,1577" Height="86,92919" ShowHint="False" Text="[Firma.&#34;SEVKADRESI&#34;]"/>
      <TfrxMemoView Name="Memo4" Left="3,77953" Top="124,26778" Width="86,92919" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Kalite"/>
      <TfrxMemoView Name="Memo6" Left="177,63791" Top="124,26778" Width="71,81107" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Ebat"/>
      <TfrxMemoView Name="Memo8" Left="461,10266" Top="124,26778" Width="60,47248" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Miktar"/>
      <TfrxMemoView Name="FirmaFIRMAADI" Left="503,45702" Top="3,77953" Width="211,65368" Height="18,89765" ShowHint="False" DataField="FIRMAADI" DataSet="cariQ" DataSetName="Firma" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Arial" Font.Style="1" ParentFont="False" VAlign="vaCenter" Text="[Firma.&#34;FIRMAADI&#34;]"/>
      <TfrxMemoView Name="Memo9" Left="351,49629" Top="3,77953" Width="147,40167" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Rechnungsempfänger: "/>
      <TfrxMemoView Name="Memo10" Left="351,49629" Top="22,67718" Width="147,40167" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Müşteri ID :"/>
      <TfrxMemoView Name="FirmaFIRMAKODU" Left="503,45702" Top="22,67718" Width="211,65368" Height="18,89765" ShowHint="False" DataField="FIRMAKODU" DataSet="cariQ" DataSetName="Firma" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Firma.&#34;FIRMAKODU&#34;]"/>
      <TfrxMemoView Name="Memo11" Left="351,49629" Top="41,5748031496063" Width="147,40167" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Tarih : "/>
      <TfrxMemoView Name="SevkiyatTARIH" Left="503,45702" Top="41,5748031496063" Width="211,65368" Height="18,89765" ShowHint="False" DataField="TARIH" DataSet="sevkQ" DataSetName="Sevkiyat" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Sevkiyat.&#34;TARIH&#34;]"/>
      <TfrxMemoView Name="Memo12" Left="351,49629" Top="60,4724409448819" Width="147,40167" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Verkäufer: "/>
      <TfrxMemoView Name="FirmaPERSONEL" Left="503,45702" Top="60,4724409448819" Width="211,65368" Height="18,89765" ShowHint="False" DataField="PERSONEL" DataSet="cariQ" DataSetName="Firma" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Firma.&#34;PERSONEL&#34;]"/>
      <TfrxMemoView Name="Memo1" Left="351,49629" Top="79,3700787401575" Width="147,40167" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Paket Nr.: "/>
      <TfrxMemoView Name="KolilerKOLINO1" Left="503,45702" Top="79,3700787401575" Width="79,37013" Height="18,89765" ShowHint="False" DataField="KOLINO" DataSet="koliNoQ" DataSetName="Koliler" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Koliler.&#34;KOLINO&#34;]"/>
    </TfrxMasterData>
    <TfrxDetailData Name="DetailData1" Height="18,89765" Left="0" Top="188,9765" Width="718,1107" Columns="1" ColumnWidth="359,055118110236" ColumnGap="3,77952755905512" DataSet="pktQ" DataSetName="Gönderim Listesi" KeepFooter="True" RowCount="0">
      <TfrxMemoView Name="GnderimListesiKALITE" Left="7,55906" Top="0" Width="162,51979" Height="18,89765" ShowHint="False" DataField="KALITE" DataSet="pktQ" DataSetName="Gönderim Listesi" Text="[Gönderim Listesi.&#34;KALITE&#34;]"/>
      <TfrxMemoView Name="GnderimListesiACIKLAMA" Left="177,63791" Top="0" Width="279,68522" Height="18,89765" ShowHint="False" DataField="ACIKLAMA" DataSet="pktQ" DataSetName="Gönderim Listesi" Text="[Gönderim Listesi.&#34;ACIKLAMA&#34;]"/>
      <TfrxMemoView Name="GnderimListesiMIKTARI" Left="461,10266" Top="0" Width="60,47248" Height="18,89765" ShowHint="False" DataField="MIKTARI" DataSet="pktQ" DataSetName="Gönderim Listesi" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Gönderim Listesi.&#34;MIKTARI&#34;]"/>
      <TfrxMemoView Name="GnderimListesiM2" Left="525,35467" Top="0" Width="90,70872" Height="18,89765" ShowHint="False" DataField="M2" DataSet="pktQ" DataSetName="Gönderim Listesi" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Gönderim Listesi.&#34;M2&#34;]"/>
    </TfrxDetailData>
    <TfrxColumnFooter Name="ColumnFooter1" Height="37,7953" Left="0" Top="268,34663" Width="718,1107">
      <TfrxMemoView Name="Memo2" Left="461,10266" Top="12" Width="60,47248" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Gönderim Listesi.&#34;MIKTARI&#34;&#62;,DetailData1)]"/>
      <TfrxMemoView Name="Memo5" Left="525,35467" Top="12" Width="90,70872" Height="18,89765" ShowHint="False" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Gönderim Listesi.&#34;M2&#34;&#62;,DetailData1)]"/>
      <TfrxLineView Name="Line1" Left="449,5436" Top="6,77953" Width="177,63791" Height="0" ShowHint="False" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo7" Left="405,37817" Top="12" Width="41,57483" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Total"/>
    </TfrxColumnFooter>
  </TfrxReportPage>
</TfrxReport>
