<!DOCTYPE openRPTDef>
<report>
 <title>Item Sites</title>
 <name>ItemSites</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 warehous_code,
       formatBoolYN(itemsite_active) AS active,
       item_number,
       item_descrip1,
       item_descrip2,
       formatBoolYN(itemsite_wosupply) AS supplied,
       formatBoolYN(itemsite_sold) AS sold,
       itemsite_soldranking,
       formatBoolYN(itemsite_stocked) AS stocked,
       formatBoolYN(itemsite_createpr) AS createpr,
       CASE WHEN (itemsite_controlmethod='N') THEN 'None'
            WHEN (itemsite_controlmethod='R') THEN 'Regular'
            WHEN (itemsite_controlmethod='L') THEN 'Lot #'
            WHEN (itemsite_controlmethod='S') THEN 'Serial #'
            ELSE '?'
       END AS controlmethod,
       formatBoolYN(itemsite_loccntrl) AS locationcontrol,
       CASE WHEN (itemsite_location_id=-1) THEN 'None'
            ELSE ( SELECT location_name
                     FROM location
                    WHERE (location_id=itemsite_location_id) )
       END AS defaultlocation,
       formatBoolYN(itemsite_useparams) AS enforceparams,
       formatBoolYN(itemsite_useparamsmanual) AS onmanualorders,
       formatQty(itemsite_reorderlevel) AS reorderlevel,
       formatQty(itemsite_ordertoqty) AS orderupto,
       formatQty(itemsite_multordqty) AS ordermult,
       formatQty(itemsite_safetystock) AS safetystock,
       itemsite_abcclass,
       itemsite_cyclecountfreq,
       itemsite_leadtime,
       itemsite_eventfence,
       formatQty(itemsite_qtyonhand) AS qoh,
       formatDate(itemsite_datelastused, 'Never') AS lastused,
       formatDate(itemsite_datelastcount, 'Never') AS lastcounted,
       CASE WHEN(itemsite_plancode_id=-1) THEN 'Error'
            ELSE (SELECT (plancode_code || '-' || plancode_name)
                    FROM plancode
                   WHERE (plancode_id=itemsite_plancode_id) )
       END AS plannercode
  FROM item, uom, itemsite, whsinfo
 WHERE ((itemsite_warehous_id=warehous_id)
         AND (itemsite_item_id=item_id)
         AND(item_inv_uom_id=uom_id)
       &lt;? if exists("search_pattern") ?>
         AND ((item_number ~* &lt;? value("search_pattern") ?>)
           OR (item_descrip1 || ' ' || item_descrip2 ~* &lt;? value("search_pattern") ?>)
           OR (warehous_code ~* &lt;? value("search_pattern") ?>))
       &lt;? endif ?>
       &lt;? if exists("item_id") ?>
         AND (item_id=&lt;? value("item_id") ?>)
       &lt;? endif ?>
       &lt;? if exists("classcode_id") ?>
         AND (item_classcode_id=&lt;? value("classcode_id") ?>)
       &lt;? endif ?>
       &lt;? if exists("itemgrp_id") ?>
         AND (item_id IN (SELECT itemgrpitem_item_id 
                          FROM itemgrpitem 
                          WHERE (itemgrpitem_itemgrp_id=&lt;? value("itemgrp_id") ?>)))
       &lt;? endif ?>
       &lt;? if exists("plancode_id") ?>
         AND (itemsite_plancode_id=&lt;? value("plancode_id") ?>)
       &lt;? endif ?>
       &lt;? if exists("costcat_id") ?>
         AND (itemsite_costcat_id=&lt;? value("costcat_id") ?>)
       &lt;? endif ?>
       &lt;? if exists("classcode_pattern") ?>
         AND (item_classcode_id IN (SELECT classcode_id 
                                    FROM classcode 
                                    WHERE (classcode_code ~ &lt;? value("classcode_pattern") ?>)))
       &lt;? endif ?>
       &lt;? if exists("itemgrp_pattern") ?>
         AND (item_id IN (SELECT itemgrpitem_item_id 
                          FROM itemgrpitem, itemgrp 
                          WHERE ( (itemgrpitem_itemgrp_id=itemgrp_id) 
                              AND (itemgrp_name ~ &lt;? value("itemgrp_pattern") ?>) ) ))
       &lt;? endif ?>
       &lt;? if exists("plancode_pattern") ?>
         AND (itemsite_plancode_id IN (SELECT plancode_id 
                                       FROM plancode 
                                       WHERE (plancode_code ~ &lt;? value("plancode_pattern") ?>)))
       &lt;? endif ?>
       &lt;? if exists("costcat_pattern") ?>
         AND (itemsite_costcat_id IN (SELECT costcat_id 
                                      FROM costcat 
                                      WHERE (costcat_code ~ &lt;? value("costcat_pattern") ?>)))
       &lt;? endif ?>
     &lt;? if exists("warehous_id") ?>
       AND (warehous_id=&lt;? value("warehous_id") ?>)
     &lt;? endif ?>
   &lt;? if not exists("showInactive") ?>
     AND (itemsite_active)
   &lt;? endif ?>
)
ORDER BY item_number, warehous_code;</sql>
 </querysource>
 <rpthead>
  <height>281</height>
  <label>
   <rect>
    <x>430</x>
    <y>254</y>
    <width>80</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Last Counted</string>
  </label>
  <label>
   <rect>
    <x>345</x>
    <y>254</y>
    <width>80</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Last Used</string>
  </label>
  <label>
   <rect>
    <x>330</x>
    <y>200</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Create P/Rs</string>
  </label>
  <label>
   <rect>
    <x>280</x>
    <y>229</y>
    <width>45</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Stocked</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>215</y>
    <width>35</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Active</string>
  </label>
  <label>
   <rect>
    <x>50</x>
    <y>245</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Planner Code</string>
  </label>
  <label>
   <rect>
    <x>580</x>
    <y>215</y>
    <width>80</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Order Up To</string>
  </label>
  <label>
   <rect>
    <x>670</x>
    <y>229</y>
    <width>55</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Lead Time</string>
  </label>
  <label>
   <rect>
    <x>280</x>
    <y>215</y>
    <width>45</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>330</x>
    <y>215</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Ranking</string>
  </label>
  <label>
   <rect>
    <x>670</x>
    <y>245</y>
    <width>55</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Event Fnc.</string>
  </label>
  <line>
   <xstart>5</xstart>
   <ystart>275</ystart>
   <xend>745</xend>
   <yend>275</yend>
   <weight>2</weight>
  </line>
  <label>
   <rect>
    <x>275</x>
    <y>254</y>
    <width>65</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>QOH</string>
  </label>
  <label>
   <rect>
    <x>490</x>
    <y>200</y>
    <width>85</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Enforce Params.</string>
  </label>
  <label>
   <rect>
    <x>375</x>
    <y>10</y>
    <width>350</width>
    <height>38</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>18</size>
    <weight>bold</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Item Sites</string>
  </label>
  <label>
   <rect>
    <x>580</x>
    <y>200</y>
    <width>80</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Reorder Lvl.</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>200</y>
    <width>35</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Site</string>
  </label>
  <label>
   <rect>
    <x>670</x>
    <y>215</y>
    <width>55</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Cycle Cnt.</string>
  </label>
  <label>
   <rect>
    <x>670</x>
    <y>200</y>
    <width>55</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>ABC Class</string>
  </label>
  <label>
   <rect>
    <x>280</x>
    <y>200</y>
    <width>45</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Supplied</string>
  </label>
  <label>
   <rect>
    <x>490</x>
    <y>215</y>
    <width>85</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>on Manual Ords.</string>
  </label>
  <label>
   <rect>
    <x>50</x>
    <y>215</y>
    <width>229</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Item Description</string>
  </label>
  <label>
   <rect>
    <x>50</x>
    <y>200</y>
    <width>229</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>409</x>
    <y>215</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Location Cntrl.</string>
  </label>
  <label>
   <rect>
    <x>409</x>
    <y>200</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Control Method</string>
  </label>
  <label>
   <rect>
    <x>409</x>
    <y>229</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Default Loc.</string>
  </label>
  <label>
   <rect>
    <x>580</x>
    <y>229</y>
    <width>80</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Order Mult.</string>
  </label>
  <label>
   <rect>
    <x>580</x>
    <y>245</y>
    <width>80</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Safety Stock</string>
  </label>
  <text>
   <rect>
    <x>10</x>
    <y>38</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>409</x>
    <y>15</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Location Cntrl.</string>
  </label>
  <label>
   <rect>
    <x>50</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>Planner Code</string>
  </label>
  <label>
   <rect>
    <x>490</x>
    <y>15</y>
    <width>85</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>on Manual Ords.</string>
  </label>
  <label>
   <rect>
    <x>409</x>
    <y>0</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Control Method</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>0</y>
    <width>35</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Site</string>
  </label>
  <label>
   <rect>
    <x>670</x>
    <y>15</y>
    <width>55</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Cycle Cnt.</string>
  </label>
  <label>
   <rect>
    <x>330</x>
    <y>15</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Ranking</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>15</y>
    <width>35</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Active</string>
  </label>
  <label>
   <rect>
    <x>330</x>
    <y>0</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Create P/Rs</string>
  </label>
  <label>
   <rect>
    <x>50</x>
    <y>15</y>
    <width>229</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Item Description</string>
  </label>
  <label>
   <rect>
    <x>409</x>
    <y>30</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Default Loc.</string>
  </label>
  <label>
   <rect>
    <x>50</x>
    <y>0</y>
    <width>229</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>670</x>
    <y>30</y>
    <width>55</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Lead Time</string>
  </label>
  <line>
   <xstart>5</xstart>
   <ystart>75</ystart>
   <xend>745</xend>
   <yend>75</yend>
   <weight>2</weight>
  </line>
  <label>
   <rect>
    <x>490</x>
    <y>0</y>
    <width>85</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Enforce Params.</string>
  </label>
  <label>
   <rect>
    <x>580</x>
    <y>15</y>
    <width>80</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Order Up To</string>
  </label>
  <label>
   <rect>
    <x>275</x>
    <y>55</y>
    <width>65</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>QOH</string>
  </label>
  <label>
   <rect>
    <x>670</x>
    <y>45</y>
    <width>55</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Event Fnc.</string>
  </label>
  <label>
   <rect>
    <x>580</x>
    <y>45</y>
    <width>80</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Safety Stock</string>
  </label>
  <label>
   <rect>
    <x>280</x>
    <y>15</y>
    <width>45</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>430</x>
    <y>55</y>
    <width>80</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Last Counted</string>
  </label>
  <label>
   <rect>
    <x>280</x>
    <y>30</y>
    <width>45</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Stocked</string>
  </label>
  <label>
   <rect>
    <x>670</x>
    <y>0</y>
    <width>55</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>ABC Class</string>
  </label>
  <label>
   <rect>
    <x>580</x>
    <y>30</y>
    <width>80</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Order Mult.</string>
  </label>
  <label>
   <rect>
    <x>345</x>
    <y>55</y>
    <width>80</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Last Used</string>
  </label>
  <label>
   <rect>
    <x>280</x>
    <y>0</y>
    <width>45</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Supplied</string>
  </label>
  <label>
   <rect>
    <x>580</x>
    <y>0</y>
    <width>80</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Reorder Lvl.</string>
  </label>
 </pghead>
 <section>
  <name>detail</name>
  <detail>
   <key>
    <query>detail</query>
   </key>
   <height>81</height>
   <field>
    <rect>
     <x>580</x>
     <y>15</y>
     <width>80</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>orderupto</column>
    </data>
   </field>
   <field>
    <rect>
     <x>490</x>
     <y>0</y>
     <width>85</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>enforceparams</column>
    </data>
   </field>
   <field>
    <rect>
     <x>10</x>
     <y>0</y>
     <width>35</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>warehous_code</column>
    </data>
   </field>
   <field>
    <rect>
     <x>260</x>
     <y>60</y>
     <width>80</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>qoh</column>
    </data>
   </field>
   <field>
    <rect>
     <x>430</x>
     <y>60</y>
     <width>80</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>lastcounted</column>
    </data>
   </field>
   <field>
    <rect>
     <x>580</x>
     <y>45</y>
     <width>80</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>safetystock</column>
    </data>
   </field>
   <field>
    <rect>
     <x>580</x>
     <y>0</y>
     <width>80</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>reorderlevel</column>
    </data>
   </field>
   <field>
    <rect>
     <x>409</x>
     <y>0</y>
     <width>75</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>controlmethod</column>
    </data>
   </field>
   <field>
    <rect>
     <x>50</x>
     <y>0</y>
     <width>229</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>item_number</column>
    </data>
   </field>
   <field>
    <rect>
     <x>280</x>
     <y>0</y>
     <width>45</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>supplied</column>
    </data>
   </field>
   <field>
    <rect>
     <x>330</x>
     <y>0</y>
     <width>75</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>createpr</column>
    </data>
   </field>
   <field>
    <rect>
     <x>280</x>
     <y>30</y>
     <width>45</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>stocked</column>
    </data>
   </field>
   <field>
    <rect>
     <x>330</x>
     <y>15</y>
     <width>75</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>itemsite_soldranking</column>
    </data>
   </field>
   <field>
    <rect>
     <x>409</x>
     <y>30</y>
     <width>75</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>defaultlocation</column>
    </data>
   </field>
   <field>
    <rect>
     <x>409</x>
     <y>15</y>
     <width>75</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>locationcontrol</column>
    </data>
   </field>
   <field>
    <rect>
     <x>10</x>
     <y>15</y>
     <width>35</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>active</column>
    </data>
   </field>
   <line>
    <xstart>5</xstart>
    <ystart>75</ystart>
    <xend>745</xend>
    <yend>75</yend>
    <weight>0</weight>
   </line>
   <field>
    <rect>
     <x>670</x>
     <y>15</y>
     <width>55</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>itemsite_cyclecountfreq</column>
    </data>
   </field>
   <field>
    <rect>
     <x>280</x>
     <y>15</y>
     <width>45</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>sold</column>
    </data>
   </field>
   <field>
    <rect>
     <x>50</x>
     <y>30</y>
     <width>229</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>item_descrip2</column>
    </data>
   </field>
   <field>
    <rect>
     <x>670</x>
     <y>0</y>
     <width>55</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>itemsite_abcclass</column>
    </data>
   </field>
   <field>
    <rect>
     <x>50</x>
     <y>15</y>
     <width>229</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>item_descrip1</column>
    </data>
   </field>
   <field>
    <rect>
     <x>490</x>
     <y>15</y>
     <width>85</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>onmanualorders</column>
    </data>
   </field>
   <field>
    <rect>
     <x>50</x>
     <y>45</y>
     <width>150</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>plannercode</column>
    </data>
   </field>
   <field>
    <rect>
     <x>345</x>
     <y>60</y>
     <width>80</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>lastused</column>
    </data>
   </field>
   <field>
    <rect>
     <x>670</x>
     <y>45</y>
     <width>55</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>itemsite_eventfence</column>
    </data>
   </field>
   <field>
    <rect>
     <x>580</x>
     <y>30</y>
     <width>80</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>ordermult</column>
    </data>
   </field>
   <field>
    <rect>
     <x>670</x>
     <y>30</y>
     <width>55</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>itemsite_leadtime</column>
    </data>
   </field>
  </detail>
 </section>
 <pgfoot>
  <height>16</height>
  <field>
   <rect>
    <x>90</x>
    <y>0</y>
    <width>100</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>
  <label>
   <rect>
    <x>0</x>
    <y>0</y>
    <width>85</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Report Date:</string>
  </label>
  <field>
   <rect>
    <x>705</x>
    <y>0</y>
    <width>40</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>
  <label>
   <rect>
    <x>615</x>
    <y>0</y>
    <width>85</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Page:</string>
  </label>
 </pgfoot>
</report>
