<?xml version="1.0" encoding="iso-8859-1"?>
<FORM>
  <TSQD>
    <Properties>
      <Descryption>Zestawienie cennik</Descryption>
      <Title>Zestawienie cennik</Title>
      <InternalId>{3F448000-0365-47B2-9C3A-F78A53668EC9}</InternalId>
      <UseDefaultDataBase>True</UseDefaultDataBase>
      <UseFilters>True</UseFilters>
      <ShowFilters>True</ShowFilters>
      <ShowParams>True</ShowParams>
      <SQBReadOnly>False</SQBReadOnly>
      <SQBType>sqtQuery</SQBType>
      <SQL>&quot;SELECT &quot;,&quot;k.symbol, k.nazwa,&quot;,&quot;t.symbol as symbol_tow, t.nazwa as nazwa_tow, &quot;,&quot;t.info as info_tow,&quot;,&quot;tt.data_ceny,&quot;,&quot;tt.cena, zrodlo,&quot;,&quot;w.symbol as waluta &quot;,&quot;FROM tt_am01 tt&quot;,&quot;join kontrah k on k.guid = tt.kontrguid&quot;,&quot;join TowrNg t on t.GUID = tt.idntowr&quot;,&quot;join waluty w on w.idn = tt.waluta&quot;,&quot;order by k.symbol, t.symbol&quot;,&quot;limit 100000;&quot;</SQL>
      <SQLInit>&quot;CALL fr_ht_zest(&apos;AMICUS_CENNIK&apos;, &apos;&apos;, &apos;&apos;, &apos;&apos;, &apos;&apos;, &apos;#oddnia#&apos;,&apos;#dodnia#&apos;, &apos;&apos;, &apos;&apos;, &apos;&apos;, &apos;&apos;,&apos;&apos;);&quot;,,</SQLInit>
    </Properties>
    <FieldDefsCollection>
      <CollectionItems.>
        <TFieldDefsItem>
          <DataType>ftString</DataType>
          <FieldName>symbol</FieldName>
          <FieldIndex>0</FieldIndex>
          <DisplayLabel>symbol</DisplayLabel>
          <DisplayWidth>38</DisplayWidth>
          <Size>38</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftString</DataType>
          <FieldName>nazwa</FieldName>
          <FieldIndex>1</FieldIndex>
          <DisplayLabel>nazwa</DisplayLabel>
          <DisplayWidth>40</DisplayWidth>
          <Size>250</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftString</DataType>
          <FieldName>symbol_tow</FieldName>
          <FieldIndex>2</FieldIndex>
          <DisplayLabel>symbol tow</DisplayLabel>
          <DisplayWidth>38</DisplayWidth>
          <Size>38</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftString</DataType>
          <FieldName>nazwa_tow</FieldName>
          <FieldIndex>3</FieldIndex>
          <DisplayLabel>nazwa tow</DisplayLabel>
          <DisplayWidth>40</DisplayWidth>
          <Size>150</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftString</DataType>
          <FieldName>info_tow</FieldName>
          <FieldIndex>4</FieldIndex>
          <DisplayLabel>info tow</DisplayLabel>
          <DisplayWidth>15</DisplayWidth>
          <Size>255</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftString</DataType>
          <FieldName>data_ceny</FieldName>
          <FieldIndex>5</FieldIndex>
          <DisplayLabel>Data ceny</DisplayLabel>
          <DisplayWidth>10</DisplayWidth>
          <Size>10</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftFMTBcd</DataType>
          <FieldName>cena</FieldName>
          <FieldIndex>6</FieldIndex>
          <Alignment>taRightJustify</Alignment>
          <DisplayLabel>cena</DisplayLabel>
          <DisplayWidth>14</DisplayWidth>
          <Size>2</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftInteger</DataType>
          <FieldName>waluta</FieldName>
          <FieldIndex>7</FieldIndex>
          <Alignment>taRightJustify</Alignment>
          <DisplayLabel>waluta</DisplayLabel>
          <DisplayWidth>6</DisplayWidth>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftString</DataType>
          <FieldName>zrodlo</FieldName>
          <FieldIndex>8</FieldIndex>
          <DisplayLabel>zrodlo</DisplayLabel>
          <DisplayWidth>10</DisplayWidth>
          <Size>10</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
      </CollectionItems.>
    </FieldDefsCollection>
    <Params/>
    <ParamsHash>
      <CollectionItems.>
        <TSQBParamPersist>
          <DataType>ftDate</DataType>
          <Name>oddnia</Name>
          <ParamType>ptInput</ParamType>
          <IfEditorEmptyValue>
            <DataType>ftDate</DataType>
            <ParamType>ptInput</ParamType>
            <EmptyValue>(NULL)</EmptyValue>
            <Example>2026-08-24</Example>
          </IfEditorEmptyValue>
          <IfSQLEmptyValue>
            <DataType>ftDate</DataType>
            <ParamType>ptInput</ParamType>
            <EmptyValue>(NULL)</EmptyValue>
            <Example>CURRENT_DATE</Example>
          </IfSQLEmptyValue>
          <ParamValue>(NULL)</ParamValue>
          <ParamText>(NULL)</ParamText>
          <DisplayLabel>Od dnia</DisplayLabel>
        </TSQBParamPersist>
        <TSQBParamPersist>
          <DataType>ftDate</DataType>
          <Name>dodnia</Name>
          <ParamType>ptInput</ParamType>
          <IfEditorEmptyValue>
            <DataType>ftDate</DataType>
            <ParamType>ptInput</ParamType>
            <EmptyValue>(NULL)</EmptyValue>
            <Example>2026-08-24</Example>
          </IfEditorEmptyValue>
          <IfSQLEmptyValue>
            <DataType>ftDate</DataType>
            <ParamType>ptInput</ParamType>
            <EmptyValue>(NULL)</EmptyValue>
            <Example>CURRENT_DATE</Example>
          </IfSQLEmptyValue>
          <ParamValue>(NULL)</ParamValue>
          <ParamText>(NULL)</ParamText>
          <DisplayLabel>Do dnia</DisplayLabel>
        </TSQBParamPersist>
      </CollectionItems.>
    </ParamsHash>
    <FilterConteners>
      <Stored_Name>&amp;lt;domy&#x9C;lny&amp;gt;</Stored_Name>
      <Stored_Type>200</Stored_Type>
      <Stored_Version>6.0</Stored_Version>
      <Filters>
        <CollectionItems.>
          <TFilterItem>
            <Active>True</Active>
            <Name>Field1</Name>
            <ValueAArrayStrIN>VERDE</ValueAArrayStrIN>
            <ValueDown>VERDE</ValueDown>
            <AvaibleFlags>ffEqu,ffIN,ffLike,ffLikeBegin</AvaibleFlags>
            <FieldName>symbol</FieldName>
            <DisplayLabel>symbol kontr.</DisplayLabel>
            <AliasName>tt</AliasName>
            <LookUpFieldName>symbol</LookUpFieldName>
            <LookUpResultFieldName>symbol</LookUpResultFieldName>
            <LookUpSQL>select distinct symbol from tt_am01 order by symbol;
</LookUpSQL>
            <SQLLookUp>&quot;select distinct symbol from tt_am01 order by symbol;&quot;</SQLLookUp>
            <Flag>ffIN</Flag>
            <ValueArrayIN>
              <CollectionItems.>
                <TVarItem>
                  <Value>VERDE</Value>
                </TVarItem>
              </CollectionItems.>
            </ValueArrayIN>
          </TFilterItem>
        </CollectionItems.>
      </Filters>
      <SaveProfileAfterDlg>False</SaveProfileAfterDlg>
      <ExtraValues>
        <Test>0</Test>
      </ExtraValues>
    </FilterConteners>
  </TSQD>
</FORM>
