<!DOCTYPE openRPTDef>
<report>
 <title>Items</title>
 <name>Items</name>
 <description></description>
 <grid>
  <snap/>
  <show/>
  <x>0.05</x>
  <y>0.05</y>
 </grid>
 <size>Letter</size>
 <portrait/>
 <topmargin>50</topmargin>
 <bottommargin>50</bottommargin>
 <rightmargin>50</rightmargin>
 <leftmargin>50</leftmargin>
 <querysource>
  <name>detail</name>
  <sql>SELECT
       &lt;? if exists("ListNumericItemNumbersFirst") ?>
         DISTINCT ON ( toNumeric(item_number, 999999999999999), item_number )
       &lt;? else ?>
         DISTINCT ON ( item_number )
       &lt;? endif ?>
       item_number,
       item_descrip1,
       item_descrip2,
       formatBoolYN(item_active) AS active,
       CASE WHEN (item_type='M') THEN 'Manufactured'
            WHEN (item_type='P') THEN 'Purchased'
            WHEN (item_type='F') THEN 'Phantom'
            WHEN (item_type='B') THEN 'Breeder'
            WHEN (item_type='C') THEN 'Co-Product'
            WHEN (item_type='Y') THEN 'By-Product'
            WHEN (item_type='R') THEN 'Reference'
            WHEN (item_type='T') THEN 'Tooling'
            WHEN (item_type='O') THEN 'Outside Process'
            WHEN (item_type='J') THEN 'Job'
            WHEN (item_type='K') THEN 'Kit'
            WHEN (item_type='L') THEN 'Planning'
            ELSE item_type
       END AS itemtype,
       iuom.uom_name AS invuom,
       itemcapuom(item_id) AS capuom,
       itemaltcapuom(item_id) AS altcapuom,
       puom.uom_name AS priceuom,
       puom.uom_name AS shipuom,
       formatRatio(itemcapinvrat(item_id)) AS capratio,
       formatRatio(itemaltcapinvrat(item_id)) AS altcapratio,
       formatRatio(iteminvpricerat(item_id)) AS shipratio,
       formatRatio(iteminvpricerat(item_id)) AS priceratio,
       formatBoolYN(item_sold) AS sold,
       formatBoolYN(item_exclusive) AS exclusive,
       formatBoolYN(item_picklist) AS picklist,
       formatBoolYN(item_config) AS configured,
       formatWeight(item_prodweight) AS prodweight,
       formatWeight(item_packweight) AS packweight,
       classcode_code
FROM item
  JOIN classcode ON (item_classcode_id=classcode_id)
  JOIN prodcat ON (item_prodcat_id=prodcat_id)
  JOIN uom iuom ON (item_inv_uom_id=iuom.uom_id)
  JOIN uom puom ON (item_price_uom_id=puom.uom_id)
&lt;? if exists("itemgrp_id") ?>
  JOIN itemgrpitem ON (item_id=itemgrpitem_item_id)
  JOIN itemgrp ON (itemgrp_id=itemgrpitem_itemgrp_id)
&lt;? endif ?>
&lt;? foreach("char_id_text_list") ?>
  LEFT OUTER JOIN charass charass_alias&lt;? literal("char_id_text_list") ?> 
    ON ((charass_alias&lt;? literal("char_id_text_list") ?>.charass_target_type='I') 
    AND  (charass_alias&lt;? literal("char_id_text_list") ?>.charass_target_id=item_id)
    AND  (charass_alias&lt;? literal("char_id_text_list") ?>.charass_char_id=&lt;? value("char_id_text_list") ?>))
  LEFT OUTER JOIN char char_alias&lt;? literal("char_id_text_list") ?> 
    ON (charass_alias&lt;? literal("char_id_text_list") ?>.charass_char_id=char_alias&lt;? literal("char_id_text_list") ?>.char_id)
&lt;? endforeach ?>
&lt;? foreach("char_id_list_list") ?>
  LEFT OUTER JOIN charass charass_alias&lt;? literal("char_id_list_list") ?> 
    ON ((charass_alias&lt;? literal("char_id_list_list") ?>.charass_target_type='I') 
    AND  (charass_alias&lt;? literal("char_id_list_list") ?>.charass_target_id=item_id)
    AND  (charass_alias&lt;? literal("char_id_list_list") ?>.charass_char_id=&lt;? value("char_id_list_list") ?>))
  LEFT OUTER JOIN char char_alias&lt;? literal("char_id_list_list") ?> 
    ON (charass_alias&lt;? literal("char_id_list_list") ?>.charass_char_id=char_alias&lt;? literal("char_id_list_list") ?>.char_id)
&lt;? endforeach ?>
&lt;? foreach("char_id_date_list") ?>
  LEFT OUTER JOIN charass charass_alias&lt;? literal("char_id_date_list") ?> 
    ON ((charass_alias&lt;? literal("char_id_date_list") ?>.charass_target_type='I') 
    AND  (charass_alias&lt;? literal("char_id_date_list") ?>.charass_target_id=item_id)
    AND  (charass_alias&lt;? literal("char_id_date_list") ?>.charass_char_id=&lt;? value("char_id_date_list") ?>))
  LEFT OUTER JOIN char char_alias&lt;? literal("char_id_date_list") ?> 
    ON (charass_alias&lt;? literal("char_id_date_list") ?>.charass_char_id=char_alias&lt;? literal("char_id_date_list") ?>.char_id)
&lt;? endforeach ?>
WHERE ( true
&lt;? if exists("search_pattern") ?>
 AND ( (item_number ~* &lt;? value("search_pattern") ?>)
       OR  (item_descrip1 || item_descrip2 ~* &lt;? value("search_pattern") ?>) )
&lt;? endif ?>
&lt;? if exists("showPurchased") ?>
 AND (item_type IN ('P', 'O'))
&lt;? elseif exists("showManufactured") ?>
 AND (item_type IN ('M', 'F', 'B','K'))
&lt;? elseif exists("showSold") ?>
 AND (item_sold)
&lt;? endif ?>
&lt;? if exists("item_type") ?>
 AND (item_type=&lt;? value("item_type") ?>)
&lt;? endif ?>
&lt;? if not exists("showInactive") ?>
 AND (item_active)
&lt;? endif ?>
&lt;? if exists("classcode_id") ?>
 AND (item_classcode_id=&lt;? value("classcode_id") ?>)
&lt;? endif ?>
&lt;? if exists("prodcat_id") ?>
 AND (item_prodcat_id=&lt;? value("prodcat_id") ?>)
&lt;? endif ?>
&lt;? if exists("freightclass_id") ?>
 AND (item_freightclass_id=&lt;? value("freightclass_id") ?>)
&lt;? endif ?>
&lt;? if exists("itemgrp_id") ?>
 AND (itemgrp_id=&lt;? value("itemgrp_id") ?>)
&lt;? endif ?>
&lt;? if exists("item_number_pattern") ?>
 AND (item_number ~* &lt;? value("item_number_pattern") ?>)
&lt;? endif ?>
&lt;? if exists("item_descrip_pattern") ?>
 AND (item_descrip1 || item_descrip2 ~* &lt;? value("item_descrip_pattern") ?>)
&lt;? endif ?>
&lt;? if exists("classcode_pattern") ?>
 AND (classcode_code ~* &lt;? value("classcode_pattern") ?>)
&lt;? endif ?>
&lt;? if exists("prodcat_pattern") ?>
 AND (prodcat_code  ~* &lt;? value("prodcat_pattern") ?>)
&lt;? endif ?>
&lt;? if exists("freightclass_pattern") ?>
 AND (freightclass_code ~* &lt;? value("freightclass_pattern") ?>)
&lt;? endif ?>
&lt;? literal("charClause") ?>
) ORDER BY
&lt;? if exists("ListNumericItemNumbersFirst") ?>
 toNumeric(item_number, 999999999999999),
&lt;? endif ?>
 item_number;</sql>
 </querysource>
 <rpthead>
  <height>241</height>
  <label>
   <rect>
    <x>10</x>
    <y>160</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Item Number</string>
  </label>
  <label>
   <rect>
    <x>565</x>
    <y>205</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Configured</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>203</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Item Type</string>
  </label>
  <label>
   <rect>
    <x>640</x>
    <y>160</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Packaging Weight</string>
  </label>
  <label>
   <rect>
    <x>565</x>
    <y>160</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Sold</string>
  </label>
  <label>
   <rect>
    <x>275</x>
    <y>220</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Shipping UOM</string>
  </label>
  <label>
   <rect>
    <x>275</x>
    <y>203</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Price UOM</string>
  </label>
  <label>
   <rect>
    <x>104</x>
    <y>220</y>
    <width>66</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Class Code</string>
  </label>
  <label>
   <rect>
    <x>565</x>
    <y>190</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Pick List</string>
  </label>
  <label>
   <rect>
    <x>400</x>
    <y>190</y>
    <width>150</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Alt. Capacity/Inventory Ratio</string>
  </label>
  <label>
   <rect>
    <x>400</x>
    <y>220</y>
    <width>150</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Shipping/Inventory Ratio</string>
  </label>
  <label>
   <rect>
    <x>275</x>
    <y>160</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Inventory UOM</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>190</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Description 2</string>
  </label>
  <label>
   <rect>
    <x>275</x>
    <y>190</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Alt. Capacity UOM</string>
  </label>
  <label>
   <rect>
    <x>400</x>
    <y>175</y>
    <width>150</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Capacity/Inventory Ratio</string>
  </label>
  <label>
   <rect>
    <x>275</x>
    <y>175</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Capacity UOM</string>
  </label>
  <label>
   <rect>
    <x>565</x>
    <y>175</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Exclusive</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>220</y>
    <width>50</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Active</string>
  </label>
  <label>
   <rect>
    <x>640</x>
    <y>175</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Product Weight</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>175</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Description 1</string>
  </label>
  <label>
   <rect>
    <x>400</x>
    <y>203</y>
    <width>150</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Price/Inventory Ratio</string>
  </label>
  <line>
   <xstart>5</xstart>
   <ystart>235</ystart>
   <xend>745</xend>
   <yend>235</yend>
   <weight>2</weight>
  </line>
  <label>
   <rect>
    <x>385</x>
    <y>5</y>
    <width>356</width>
    <height>37</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>18</size>
    <weight>bold</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Items</string>
  </label>
  <text>
   <rect>
    <x>10</x>
    <y>28</y>
    <width>725</width>
    <height>15</height>
   </rect>
   <bottompad>12</bottompad>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <top/>
   <data>
    <query>Parameter Query</query>
    <column>filter</column>
   </data>
  </text>
 </rpthead>
 <pghead>
  <firstpage/>
  <height>6</height>
 </pghead>
 <pghead>
  <height>81</height>
  <label>
   <rect>
    <x>565</x>
    <y>45</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Configured</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>15</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Description 1</string>
  </label>
  <line>
   <xstart>5</xstart>
   <ystart>75</ystart>
   <xend>745</xend>
   <yend>75</yend>
   <weight>2</weight>
  </line>
  <label>
   <rect>
    <x>400</x>
    <y>15</y>
    <width>150</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Capacity/Inventory Ratio</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>30</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Description 2</string>
  </label>
  <label>
   <rect>
    <x>275</x>
    <y>0</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Inventory UOM</string>
  </label>
  <label>
   <rect>
    <x>275</x>
    <y>45</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Price UOM</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>60</y>
    <width>50</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Active</string>
  </label>
  <label>
   <rect>
    <x>275</x>
    <y>15</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Capacity UOM</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>0</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Item Number</string>
  </label>
  <label>
   <rect>
    <x>565</x>
    <y>15</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Exclusive</string>
  </label>
  <label>
   <rect>
    <x>400</x>
    <y>45</y>
    <width>150</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Price/Inventory Ratio</string>
  </label>
  <label>
   <rect>
    <x>275</x>
    <y>30</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Alt. Capacity UOM</string>
  </label>
  <label>
   <rect>
    <x>400</x>
    <y>60</y>
    <width>150</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Shipping/Inventory Ratio</string>
  </label>
  <label>
   <rect>
    <x>640</x>
    <y>0</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Packaging Weight</string>
  </label>
  <label>
   <rect>
    <x>400</x>
    <y>30</y>
    <width>150</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Alt. Capacity/Inventory Ratio</string>
  </label>
  <label>
   <rect>
    <x>640</x>
    <y>15</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Product Weight</string>
  </label>
  <label>
   <rect>
    <x>104</x>
    <y>60</y>
    <width>66</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Class Code</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>45</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Item Type</string>
  </label>
  <label>
   <rect>
    <x>565</x>
    <y>30</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Pick List</string>
  </label>
  <label>
   <rect>
    <x>565</x>
    <y>0</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Sold</string>
  </label>
  <label>
   <rect>
    <x>275</x>
    <y>60</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Shipping UOM</string>
  </label>
 </pghead>
 <section>
  <name>unnamed</name>
  <detail>
   <key>
    <query>detail</query>
   </key>
   <height>81</height>
   <field>
    <rect>
     <x>565</x>
     <y>30</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>picklist</column>
    </data>
   </field>
   <field>
    <rect>
     <x>10</x>
     <y>15</y>
     <width>250</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>item_descrip1</column>
    </data>
   </field>
   <field>
    <rect>
     <x>565</x>
     <y>15</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>exclusive</column>
    </data>
   </field>
   <field>
    <rect>
     <x>433</x>
     <y>45</y>
     <width>90</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>priceratio</column>
    </data>
   </field>
   <field>
    <rect>
     <x>10</x>
     <y>45</y>
     <width>250</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>itemtype</column>
    </data>
   </field>
   <field>
    <rect>
     <x>640</x>
     <y>0</y>
     <width>100</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>packweight</column>
    </data>
   </field>
   <field>
    <rect>
     <x>10</x>
     <y>30</y>
     <width>250</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>item_descrip2</column>
    </data>
   </field>
   <field>
    <rect>
     <x>433</x>
     <y>30</y>
     <width>90</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>altcapratio</column>
    </data>
   </field>
   <field>
    <rect>
     <x>275</x>
     <y>60</y>
     <width>100</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>shipuom</column>
    </data>
   </field>
   <field>
    <rect>
     <x>10</x>
     <y>0</y>
     <width>250</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>item_number</column>
    </data>
   </field>
   <line>
    <xstart>5</xstart>
    <ystart>75</ystart>
    <xend>745</xend>
    <yend>75</yend>
    <weight>0</weight>
   </line>
   <field>
    <rect>
     <x>565</x>
     <y>0</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>sold</column>
    </data>
   </field>
   <field>
    <rect>
     <x>565</x>
     <y>45</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>configured</column>
    </data>
   </field>
   <field>
    <rect>
     <x>275</x>
     <y>45</y>
     <width>100</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>priceuom</column>
    </data>
   </field>
   <field>
    <rect>
     <x>275</x>
     <y>0</y>
     <width>100</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>invuom</column>
    </data>
   </field>
   <field>
    <rect>
     <x>10</x>
     <y>60</y>
     <width>50</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>active</column>
    </data>
   </field>
   <field>
    <rect>
     <x>433</x>
     <y>15</y>
     <width>90</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>capratio</column>
    </data>
   </field>
   <field>
    <rect>
     <x>104</x>
     <y>60</y>
     <width>66</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>classcode_code</column>
    </data>
   </field>
   <field>
    <rect>
     <x>275</x>
     <y>30</y>
     <width>100</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>altcapuom</column>
    </data>
   </field>
   <field>
    <rect>
     <x>275</x>
     <y>15</y>
     <width>100</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>capuom</column>
    </data>
   </field>
   <field>
    <rect>
     <x>640</x>
     <y>15</y>
     <width>100</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>prodweight</column>
    </data>
   </field>
   <field>
    <rect>
     <x>433</x>
     <y>60</y>
     <width>90</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>40</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>shipratio</column>
    </data>
   </field>
  </detail>
 </section>
 <pgfoot>
  <height>16</height>
  <label>
   <rect>
    <x>0</x>
    <y>0</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Report Date:</string>
  </label>
  <label>
   <rect>
    <x>635</x>
    <y>0</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Page:</string>
  </label>
  <field>
   <rect>
    <x>80</x>
    <y>0</y>
    <width>140</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>Context Query</query>
    <column>report_date</column>
   </data>
  </field>
  <field>
   <rect>
    <x>715</x>
    <y>0</y>
    <width>30</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>Context Query</query>
    <column>page_number</column>
   </data>
  </field>
 </pgfoot>
</report>
