<!DOCTYPE openRPTDef>
<report>
 <title>Pick List</title>
 <name>PickList</name>
 <description></description>
 <size>Letter</size>
 <portrait/>
 <topmargin>50</topmargin>
 <bottommargin>28</bottommargin>
 <rightmargin>0</rightmargin>
 <leftmargin>0</leftmargin>
 <querysource>
  <name>Head</name>
  <sql>SELECT formatWoNumber(wo_id) AS wonumber, wo_prodnotes,
                item_number, uom_name, item_descrip1, item_descrip2,
                warehous_code, formatQty(wo_qtyord) AS qtyord,
                formatQty(wo_qtyrcv) AS qtyrcv,
                formatDate(wo_startdate) AS startdate,
                formatDate(wo_duedate) AS duedate
         FROM wo, itemsite, item, whsinfo, uom
         WHERE ((wo_itemsite_id=itemsite_id)
          AND (itemsite_item_id=item_id)
          AND (item_inv_uom_id=uom_id)
          AND (itemsite_warehous_id=warehous_id)
          AND (wo_id=&lt;? value("wo_id") ?>))
    </sql>
 </querysource>
 <querysource>
  <name>Detail</name>
  <sql>SELECT item_number,
       uom_name,
       item_descrip1,
       item_descrip2,
       formatQty(womatl_qtyreq) AS qtyreq,
       formatQty(womatl_qtyiss) AS qtyiss,
       formatQty(noNeg(womatl_qtyreq - womatl_qtyiss)) AS qtybalance,
       itemsite_location,
       CASE WHEN (womatl_issuemethod='S') THEN text('Push')
            WHEN (womatl_issuemethod='L') THEN text('Pull')
            WHEN (womatl_issuemethod='M') THEN text('Mixed')
            ELSE text(womatl_issuemethod)
       END AS f_issuemethod
  FROM womatl, itemsite, item, uom
 WHERE ((item_picklist)
   AND (womatl_itemsite_id=itemsite_id)
   AND (itemsite_item_id=item_id)
   AND (womatl_uom_id=uom_id)
   AND (womatl_wo_id=&lt;? value("wo_id") ?>) );
    </sql>
 </querysource>
 <rpthead>
  <height>246</height>
  <label>
   <rect>
    <x>45</x>
    <y>225</y>
    <width>300</width>
    <height>14</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Item Description</string>
  </label>
  <field>
   <rect>
    <x>196</x>
    <y>140</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <data>
    <query>Head</query>
    <column>qtyord</column>
   </data>
  </field>
  <field>
   <rect>
    <x>653</x>
    <y>65</y>
    <width>150</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>Head</query>
    <column>wonumber</column>
   </data>
  </field>
  <field>
   <rect>
    <x>196</x>
    <y>102</y>
    <width>300</width>
    <height>17</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>Head</query>
    <column>item_descrip2</column>
   </data>
  </field>
  <label>
   <rect>
    <x>494</x>
    <y>84</y>
    <width>154</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Date:</string>
  </label>
  <field>
   <rect>
    <x>653</x>
    <y>102</y>
    <width>130</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>Head</query>
    <column>startdate</column>
   </data>
  </field>
  <field>
   <rect>
    <x>653</x>
    <y>84</y>
    <width>130</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>Context Query</query>
    <column>report_date</column>
   </data>
  </field>
  <label>
   <rect>
    <x>494</x>
    <y>65</y>
    <width>154</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Work Order #:</string>
  </label>
  <label>
   <rect>
    <x>560</x>
    <y>204</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Qty. To Pick</string>
  </label>
  <field>
   <rect>
    <x>653</x>
    <y>121</y>
    <width>130</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>Head</query>
    <column>duedate</column>
   </data>
  </field>
  <label>
   <rect>
    <x>494</x>
    <y>121</y>
    <width>154</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Due Date:</string>
  </label>
  <field>
   <rect>
    <x>196</x>
    <y>65</y>
    <width>200</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>Head</query>
    <column>item_number</column>
   </data>
  </field>
  <label>
   <rect>
    <x>37</x>
    <y>121</y>
    <width>150</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Site:</string>
  </label>
  <label>
   <rect>
    <x>37</x>
    <y>65</y>
    <width>150</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Item:</string>
  </label>
  <label>
   <rect>
    <x>37</x>
    <y>158</y>
    <width>150</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Qty. Received:</string>
  </label>
  <label>
   <rect>
    <x>578</x>
    <y>18</y>
    <width>204</width>
    <height>40</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>20</size>
    <weight>bold</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Pick List</string>
  </label>
  <label>
   <rect>
    <x>681</x>
    <y>204</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Qty. Picked</string>
  </label>
  <label>
   <rect>
    <x>215</x>
    <y>205</y>
    <width>125</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Location</string>
  </label>
  <label>
   <rect>
    <x>354</x>
    <y>204</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Qty. Required</string>
  </label>
  <field>
   <rect>
    <x>196</x>
    <y>158</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <data>
    <query>Head</query>
    <column>qtyrcv</column>
   </data>
  </field>
  <field>
   <rect>
    <x>196</x>
    <y>84</y>
    <width>300</width>
    <height>17</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>Head</query>
    <column>item_descrip1</column>
   </data>
  </field>
  <field>
   <rect>
    <x>195</x>
    <y>120</y>
    <width>120</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>Head</query>
    <column>warehous_code</column>
   </data>
  </field>
  <label>
   <rect>
    <x>455</x>
    <y>220</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Issue Method</string>
  </label>
  <label>
   <rect>
    <x>45</x>
    <y>204</y>
    <width>150</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Item Number</string>
  </label>
  <line>
   <xstart>10</xstart>
   <ystart>240</ystart>
   <xend>822</xend>
   <yend>240</yend>
   <weight>2</weight>
  </line>
  <label>
   <rect>
    <x>37</x>
    <y>140</y>
    <width>150</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Qty. Ordered:</string>
  </label>
  <label>
   <rect>
    <x>457</x>
    <y>204</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Qty. Issued</string>
  </label>
  <label>
   <rect>
    <x>355</x>
    <y>220</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Issue UOM</string>
  </label>
  <label>
   <rect>
    <x>494</x>
    <y>102</y>
    <width>154</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Start Date:</string>
  </label>
 </rpthead>
 <pghead>
  <firstpage/>
  <height>6</height>
 </pghead>
 <pghead>
  <height>47</height>
  <label>
   <rect>
    <x>340</x>
    <y>20</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Issue UOM</string>
  </label>
  <label>
   <rect>
    <x>30</x>
    <y>5</y>
    <width>300</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Item Number</string>
  </label>
  <line>
   <xstart>10</xstart>
   <ystart>40</ystart>
   <xend>822</xend>
   <yend>40</yend>
   <weight>2</weight>
  </line>
  <label>
   <rect>
    <x>215</x>
    <y>5</y>
    <width>125</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Location</string>
  </label>
  <label>
   <rect>
    <x>440</x>
    <y>20</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Issue Method</string>
  </label>
  <label>
   <rect>
    <x>665</x>
    <y>5</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Qty. Picked</string>
  </label>
  <label>
   <rect>
    <x>440</x>
    <y>5</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Qty. Issued</string>
  </label>
  <label>
   <rect>
    <x>340</x>
    <y>5</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Qty. Required</string>
  </label>
  <label>
   <rect>
    <x>30</x>
    <y>25</y>
    <width>300</width>
    <height>14</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Item Description</string>
  </label>
  <label>
   <rect>
    <x>545</x>
    <y>5</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Qty. To Pick</string>
  </label>
 </pghead>
 <section>
  <name>detail</name>
  <detail>
   <key>
    <query>Detail</query>
   </key>
   <height>61</height>
   <field>
    <rect>
     <x>215</x>
     <y>0</y>
     <width>130</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>Detail</query>
     <column>itemsite_location</column>
    </data>
   </field>
   <field>
    <rect>
     <x>45</x>
     <y>0</y>
     <width>160</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>Detail</query>
     <column>item_number</column>
    </data>
   </field>
   <line>
    <xstart>680</xstart>
    <ystart>30</ystart>
    <xend>780</xend>
    <yend>30</yend>
    <weight>1</weight>
   </line>
   <field>
    <rect>
     <x>350</x>
     <y>0</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>Detail</query>
     <column>qtyreq</column>
    </data>
   </field>
   <field>
    <rect>
     <x>457</x>
     <y>0</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>Detail</query>
     <column>qtyiss</column>
    </data>
   </field>
   <field>
    <rect>
     <x>350</x>
     <y>20</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>Detail</query>
     <column>uom_name</column>
    </data>
   </field>
   <field>
    <rect>
     <x>46</x>
     <y>37</y>
     <width>300</width>
     <height>14</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>Detail</query>
     <column>item_descrip2</column>
    </data>
   </field>
   <field>
    <rect>
     <x>459</x>
     <y>20</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>Detail</query>
     <column>f_issuemethod</column>
    </data>
   </field>
   <line>
    <xstart>10</xstart>
    <ystart>55</ystart>
    <xend>822</xend>
    <yend>55</yend>
    <weight>0</weight>
   </line>
   <field>
    <rect>
     <x>569</x>
     <y>0</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>Detail</query>
     <column>qtybalance</column>
    </data>
   </field>
   <field>
    <rect>
     <x>45</x>
     <y>20</y>
     <width>300</width>
     <height>14</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>Detail</query>
     <column>item_descrip1</column>
    </data>
   </field>
  </detail>
 </section>
 <rptfoot>
  <height>57</height>
  <label>
   <rect>
    <x>46</x>
    <y>9</y>
    <width>139</width>
    <height>22</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>12</size>
    <weight>48</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Production Notes:</string>
  </label>
  <text>
   <rect>
    <x>46</x>
    <y>28</y>
    <width>746</width>
    <height>22</height>
   </rect>
   <bottompad>0</bottompad>
   <font>
    <face>Arial</face>
    <size>12</size>
    <weight>48</weight>
   </font>
   <left/>
   <top/>
   <data>
    <query>Head</query>
    <column>wo_prodnotes</column>
   </data>
  </text>
 </rptfoot>
</report>
