<!DOCTYPE openRPTDef>
<report>
 <title>Quote</title>
 <name>Quote</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>head</name>
  <sql>SELECT quhead_number,
       quhead_shipvia,
       formatDate(quhead_quotedate) as f_orderdate,
       formatDate(quhead_packdate) as f_packdate,
       salesrep_name,
       formatScrap(quhead_commission) as f_commission,
       (terms_code||' - '||terms_descrip) as f_terms,
       cust_number,
       quhead_billtoname,
       formatAddr(quhead_billtoaddress1,
                  quhead_billtoaddress2,
                  quhead_billtoaddress3,
                 (quhead_billtocity || ', ' || quhead_billtostate || ' ' || quhead_billtozip),
                  quhead_billtocountry) AS f_billtoaddress,
       CASE WHEN(quhead_shipto_id=-1) THEN text('')
            ELSE (SELECT text(shipto_num) FROM shiptoinfo WHERE (shipto_id=quhead_shipto_id))
       END AS f_shiptonum,
       quhead_shiptoname,
       formatAddr(quhead_shiptoaddress1,
                  quhead_shiptoaddress2,
                  quhead_shiptoaddress3,
                 (quhead_shiptocity || ', ' || quhead_shiptostate || ' ' || quhead_shiptozipcode),
                  quhead_shiptocountry) AS f_shiptoaddress,
       quhead_custponumber,
       quhead_fob, saletype_code
FROM quhead
     LEFT OUTER JOIN custinfo ON (quhead_cust_id = cust_id)
     LEFT OUTER JOIN terms ON (quhead_terms_id = terms_id)
     LEFT OUTER JOIN salesrep ON (quhead_salesrep_id = salesrep_id)
     LEFT OUTER JOIN saletype ON (quhead_saletype_id = saletype_id)
WHERE (quhead_id = &lt;? value("quhead_id") ?>)
</sql>
 </querysource>
 <querysource>
  <name>notes</name>
  <sql>SELECT quhead_ordercomments,
       quhead_shipcomments
  FROM quhead
 WHERE (quhead_id=&lt;? value("quhead_id") ?>);</sql>
 </querysource>
 <querysource>
  <name>items</name>
  <sql>SELECT quitem_id,
       quitem_linenumber,
       quitem_custpn, 
       item_number,
       item_descrip1,
       --The following 2 lines are new in 2.3
       (select uom_name from uom where uom_id = quitem_qty_uom_id) AS uom_ordered,
       (select uom_name from uom where uom_id = quitem_price_uom_id) AS uom_pricing,
       warehous_code,
       formatQty(quitem_qtyord) as f_ordered,
       formatPrice(quitem_price) as f_price,
       --The following line was changed in 2.3 from:
       --formatExtprice(quitem_qtyord * (quitem_price / iteminvpricerat(item_id))) as f_extprice
       --To:
       formatExtprice((quitem_qtyord * quitem_qty_invuomratio) * (quitem_price / quitem_price_invuomratio)) as f_extprice,
       quitem_memo,
       char_name, 
       charass_value 
FROM quitem
     JOIN item ON (item_id=quitem_item_id)
     LEFT OUTER JOIN (itemsite JOIN whsinfo ON (itemsite_warehous_id=warehous_id)) ON (quitem_itemsite_id=itemsite_id)
     LEFT OUTER JOIN charass ON ((charass_target_id = quitem_id) 
                            AND (charass_target_type = 'QI'))
     LEFT OUTER JOIN char ON (charass_char_id = char_id)
WHERE (quitem_quhead_id=&lt;? value("quhead_id") ?>) 
ORDER BY quitem_linenumber;</sql>
 </querysource>
 <querysource>
  <name>totals</name>
  <sql>SELECT 1 as one,
       formatExtPrice(subtotal) AS f_subtotal,
       formatExtPrice(tax) AS f_tax,
       formatExtPrice(quhead_freight) AS f_freight,
       formatExtPrice(quhead_misc) AS f_misc,
       formatExtPrice(subtotal + tax + quhead_freight + quhead_misc) AS f_total
  FROM quhead,
       (SELECT SUM(ROUND((quitem_qtyord * quitem_qty_invuomratio) * (quitem_price / quitem_price_invuomratio),2)) AS subtotal
          FROM quitem
         WHERE (quitem_quhead_id=&lt;? value("quhead_id") ?>) ) AS subtot,
       (SELECT COALESCE(SUM(tax),0.0) AS tax 
        FROM (
          SELECT ROUND(SUM(taxdetail_tax),2) AS tax 
          FROM tax 
          JOIN calculateTaxDetailSummary('Q', &lt;? value("quhead_id") ?>, 'T') ON (taxdetail_tax_id=tax_id)
	GROUP BY tax_id) AS data) AS taxtot
       


 WHERE (quhead_id=&lt;? value("quhead_id") ?>);
</sql>
 </querysource>
 <querysource>
  <name>logo</name>
  <sql>SELECT image_data 
FROM image 
WHERE ((image_name='logo'));</sql>
 </querysource>
 <querysource>
  <name>currency_info</name>
  <sql>--this was added in version 2.3
SELECT curr_name,
       curr_symbol,
       curr_abbr
FROM quhead, curr_symbol
WHERE ( (quhead_curr_id = curr_id)
  AND   (quhead_id = &lt;? value("quhead_id") ?>) );</sql>
 </querysource>
 <querysource>
  <name>address</name>
  <sql>SELECT warehous_descrip,
       formatAddr(addr_line1,
                  addr_line2,
                  addr_line3,
                 (addr_city || '  ' || addr_state || '  ' || addr_postalcode),
                  addr_country) AS warehouse_address
FROM whsinfo, 
     addr, 
     quhead
WHERE ( (addr_id = warehous_addr_id)
  AND   (quhead_warehous_id = warehous_id)
  AND   (quhead_id=&lt;? value("quhead_id") ?>) );</sql>
 </querysource>
 <querysource>
  <name>contact_fax_phone</name>
  <sql>SELECT cntct_fax,
       cntct_phone
FROM cntct, quhead, custinfo
WHERE ( (cust_id = quhead_cust_id)
  AND   (cust_cntct_id = cntct_id)
  AND   (quhead_id = &lt;? value("quhead_id") ?>) );
</sql>
 </querysource>
 <rpthead>
  <height>427</height>
  <image>
   <rect>
    <x>275</x>
    <y>5</y>
    <width>238</width>
    <height>100</height>
   </rect>
   <mode>stretch</mode>
   <data>
    <query>logo</query>
    <column>image_data</column>
   </data>
  </image>
  <text>
   <rect>
    <x>10</x>
    <y>25</y>
    <width>265</width>
    <height>15</height>
   </rect>
   <bottompad>10</bottompad>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <top/>
   <data>
    <query>address</query>
    <column>warehouse_address</column>
   </data>
  </text>
  <field>
   <rect>
    <x>100</x>
    <y>175</y>
    <width>206</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>cust_number</column>
   </data>
  </field>
  <field>
   <rect>
    <x>440</x>
    <y>215</y>
    <width>300</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>quhead_shiptoname</column>
   </data>
  </field>
  <label>
   <rect>
    <x>360</x>
    <y>145</y>
    <width>103</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Pack Date:</string>
  </label>
  <field>
   <rect>
    <x>55</x>
    <y>325</y>
    <width>121</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>contact_fax_phone</query>
    <column>cntct_phone</column>
   </data>
  </field>
  <label>
   <rect>
    <x>360</x>
    <y>160</y>
    <width>103</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Terms:</string>
  </label>
  <label>
   <rect>
    <x>580</x>
    <y>5</y>
    <width>126</width>
    <height>42</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>18</size>
    <weight>bold</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Quote</string>
  </label>
  <field>
   <rect>
    <x>55</x>
    <y>215</y>
    <width>285</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>quhead_billtoname</column>
   </data>
  </field>
  <field>
   <rect>
    <x>208</x>
    <y>325</y>
    <width>121</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>contact_fax_phone</query>
    <column>cntct_fax</column>
   </data>
  </field>
  <field>
   <rect>
    <x>440</x>
    <y>190</y>
    <width>206</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_shiptonum</column>
   </data>
  </field>
  <field>
   <rect>
    <x>100</x>
    <y>130</y>
    <width>206</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>quhead_number</column>
   </data>
  </field>
  <label>
   <rect>
    <x>155</x>
    <y>415</y>
    <width>103</width>
    <height>11</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Description</string>
  </label>
  <label>
   <rect>
    <x>655</x>
    <y>415</y>
    <width>103</width>
    <height>11</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Extended Price</string>
  </label>
  <field>
   <rect>
    <x>440</x>
    <y>145</y>
    <width>103</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_packdate</column>
   </data>
  </field>
  <label>
   <rect>
    <x>360</x>
    <y>190</y>
    <width>103</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Ship-To #:</string>
  </label>
  <label>
   <rect>
    <x>390</x>
    <y>350</y>
    <width>103</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Ship Via:</string>
  </label>
  <field>
   <rect>
    <x>100</x>
    <y>160</y>
    <width>206</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>saletype_code</column>
   </data>
  </field>
  <label>
   <rect>
    <x>440</x>
    <y>415</y>
    <width>112</width>
    <height>11</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Qty Ordered, UOM</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>215</y>
    <width>52</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Bill To:</string>
  </label>
  <label>
   <rect>
    <x>360</x>
    <y>130</y>
    <width>103</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Order Date:</string>
  </label>
  <label>
   <rect>
    <x>0</x>
    <y>415</y>
    <width>50</width>
    <height>11</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Line #</string>
  </label>
  <label>
   <rect>
    <x>180</x>
    <y>325</y>
    <width>52</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Fax:</string>
  </label>
  <label>
   <rect>
    <x>30</x>
    <y>350</y>
    <width>103</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Customer PO #:</string>
  </label>
  <field>
   <rect>
    <x>100</x>
    <y>145</y>
    <width>206</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>salesrep_name</column>
   </data>
  </field>
  <label>
   <rect>
    <x>560</x>
    <y>415</y>
    <width>103</width>
    <height>11</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>175</y>
    <width>103</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Customer #:</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>325</y>
    <width>52</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Phone:</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>130</y>
    <width>103</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Order #:</string>
  </label>
  <label>
   <rect>
    <x>360</x>
    <y>215</y>
    <width>56</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Ship To:</string>
  </label>
  <field>
   <rect>
    <x>440</x>
    <y>130</y>
    <width>103</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_orderdate</column>
   </data>
  </field>
  <label>
   <rect>
    <x>10</x>
    <y>160</y>
    <width>103</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Sale Type:</string>
  </label>
  <label>
   <rect>
    <x>50</x>
    <y>415</y>
    <width>103</width>
    <height>11</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Item</string>
  </label>
  <label>
   <rect>
    <x>385</x>
    <y>415</y>
    <width>50</width>
    <height>11</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Site</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>145</y>
    <width>103</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Sales Rep.:</string>
  </label>
  <field>
   <rect>
    <x>505</x>
    <y>350</y>
    <width>206</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>quhead_shipvia</column>
   </data>
  </field>
  <field>
   <rect>
    <x>140</x>
    <y>370</y>
    <width>206</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>quhead_fob</column>
   </data>
  </field>
  <label>
   <rect>
    <x>30</x>
    <y>370</y>
    <width>103</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>F.O.B.:</string>
  </label>
  <field>
   <rect>
    <x>440</x>
    <y>160</y>
    <width>262</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_terms</column>
   </data>
  </field>
  <text>
   <rect>
    <x>55</x>
    <y>233</y>
    <width>300</width>
    <height>15</height>
   </rect>
   <bottompad>0</bottompad>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_billtoaddress</column>
   </data>
  </text>
  <field>
   <rect>
    <x>140</x>
    <y>350</y>
    <width>206</width>
    <height>21</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>quhead_custponumber</column>
   </data>
  </field>
  <field>
   <rect>
    <x>10</x>
    <y>5</y>
    <width>257</width>
    <height>19</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>address</query>
    <column>warehous_descrip</column>
   </data>
  </field>
  <text>
   <rect>
    <x>440</x>
    <y>233</y>
    <width>300</width>
    <height>15</height>
   </rect>
   <bottompad>0</bottompad>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_shiptoaddress</column>
   </data>
  </text>
 </rpthead>
 <section>
  <name>lineitems</name>
  <group>
   <name>lineitems</name>
   <column>quitem_linenumber</column>
   <head>
    <height>32</height>
    <field>
     <rect>
      <x>155</x>
      <y>0</y>
      <width>225</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>bold</weight>
     </font>
     <left/>
     <vcenter/>
     <data>
      <query>items</query>
      <column>item_descrip1</column>
     </data>
    </field>
    <line>
     <xstart>5</xstart>
     <ystart>0</ystart>
     <xend>783</xend>
     <yend>0</yend>
     <weight>2</weight>
    </line>
    <field>
     <rect>
      <x>665</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>items</query>
      <column>f_extprice</column>
     </data>
    </field>
    <label>
     <rect>
      <x>385</x>
      <y>15</y>
      <width>125</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>Option Description:</string>
    </label>
    <field>
     <rect>
      <x>5</x>
      <y>0</y>
      <width>25</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>bold</weight>
     </font>
     <hcenter/>
     <vcenter/>
     <data>
      <query>items</query>
      <column>quitem_linenumber</column>
     </data>
    </field>
    <field>
     <rect>
      <x>385</x>
      <y>0</y>
      <width>50</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>bold</weight>
     </font>
     <hcenter/>
     <vcenter/>
     <data>
      <query>items</query>
      <column>warehous_code</column>
     </data>
    </field>
    <field>
     <rect>
      <x>640</x>
      <y>0</y>
      <width>37</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>bold</weight>
     </font>
     <left/>
     <vcenter/>
     <data>
      <query>items</query>
      <column>uom_pricing</column>
     </data>
    </field>
    <field>
     <rect>
      <x>525</x>
      <y>0</y>
      <width>37</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>bold</weight>
     </font>
     <left/>
     <vcenter/>
     <data>
      <query>items</query>
      <column>uom_ordered</column>
     </data>
    </field>
    <label>
     <rect>
      <x>155</x>
      <y>15</y>
      <width>85</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>Options:</string>
    </label>
    <field>
     <rect>
      <x>45</x>
      <y>0</y>
      <width>103</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>bold</weight>
     </font>
     <left/>
     <vcenter/>
     <data>
      <query>items</query>
      <column>item_number</column>
     </data>
    </field>
    <field>
     <rect>
      <x>565</x>
      <y>0</y>
      <width>72</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>bold</weight>
     </font>
     <right/>
     <vcenter/>
     <data>
      <query>items</query>
      <column>f_price</column>
     </data>
    </field>
    <field>
     <rect>
      <x>440</x>
      <y>0</y>
      <width>77</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>bold</weight>
     </font>
     <right/>
     <vcenter/>
     <data>
      <query>items</query>
      <column>f_ordered</column>
     </data>
    </field>
   </head>
   <foot>
    <height>33.8828</height>
    <label>
     <rect>
      <x>155</x>
      <y>0</y>
      <width>130</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>Additional Description:</string>
    </label>
    <text>
     <rect>
      <x>290</x>
      <y>0</y>
      <width>454.347</width>
      <height>13.2412</height>
     </rect>
     <bottompad>10</bottompad>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>bold</weight>
     </font>
     <left/>
     <top/>
     <data>
      <query>items</query>
      <column>quitem_memo</column>
     </data>
    </text>
    <label>
     <rect>
      <x>196.342</x>
      <y>15.3707</y>
      <width>85.6497</width>
      <height>15.665</height>
     </rect>
     <font>
      <face>Sans Serif</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <left/>
     <top/>
     <string>Customer P/N:</string>
    </label>
    <text>
     <rect>
      <x>289.596</x>
      <y>15.5884</y>
      <width>199</width>
      <height>17.1</height>
     </rect>
     <bottompad>0</bottompad>
     <font>
      <face>Sans Serif</face>
      <size>8</size>
      <weight>bold</weight>
     </font>
     <left/>
     <top/>
     <data>
      <query>items</query>
      <column>quitem_custpn</column>
     </data>
    </text>
   </foot>
  </group>
  <detail>
   <key>
    <query>items</query>
   </key>
   <height>18</height>
   <field>
    <rect>
     <x>385</x>
     <y>0</y>
     <width>300</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>items</query>
     <column>charass_value</column>
    </data>
   </field>
   <field>
    <rect>
     <x>208</x>
     <y>0</y>
     <width>165</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>items</query>
     <column>char_name</column>
    </data>
   </field>
  </detail>
 </section>
 <section>
  <name>items</name>
  <group>
   <name>items</name>
   <column>one</column>
   <foot>
    <height>87</height>
    <label>
     <rect>
      <x>565</x>
      <y>50</y>
      <width>103</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <right/>
     <vcenter/>
     <string>Tax:</string>
    </label>
    <field>
     <rect>
      <x>670</x>
      <y>65</y>
      <width>75</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>bold</weight>
     </font>
     <right/>
     <vcenter/>
     <data>
      <query>totals</query>
      <column>f_total</column>
     </data>
    </field>
    <label>
     <rect>
      <x>565</x>
      <y>35</y>
      <width>103</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <right/>
     <vcenter/>
     <string>Freight:</string>
    </label>
    <field>
     <rect>
      <x>670</x>
      <y>50</y>
      <width>75</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>bold</weight>
     </font>
     <right/>
     <vcenter/>
     <data>
      <query>totals</query>
      <column>f_tax</column>
     </data>
    </field>
    <label>
     <rect>
      <x>565</x>
      <y>20</y>
      <width>103</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <right/>
     <vcenter/>
     <string>Misc. Charges:</string>
    </label>
    <field>
     <rect>
      <x>670</x>
      <y>35</y>
      <width>75</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>bold</weight>
     </font>
     <right/>
     <vcenter/>
     <data>
      <query>totals</query>
      <column>f_freight</column>
     </data>
    </field>
    <field>
     <rect>
      <x>670</x>
      <y>20</y>
      <width>75</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>bold</weight>
     </font>
     <right/>
     <vcenter/>
     <data>
      <query>totals</query>
      <column>f_misc</column>
     </data>
    </field>
    <label>
     <rect>
      <x>565</x>
      <y>5</y>
      <width>103</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <right/>
     <vcenter/>
     <string>Sub-Total:</string>
    </label>
    <label>
     <rect>
      <x>565</x>
      <y>65</y>
      <width>103</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <right/>
     <vcenter/>
     <string>Total:</string>
    </label>
    <label>
     <rect>
      <x>10</x>
      <y>10</y>
      <width>208</width>
      <height>18</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>10</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>Note, this quotation is priced in:</string>
    </label>
    <field>
     <rect>
      <x>204</x>
      <y>10</y>
      <width>206</width>
      <height>18</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>10</size>
      <weight>bold</weight>
     </font>
     <left/>
     <vcenter/>
     <data>
      <query>currency_info</query>
      <column>curr_name</column>
     </data>
    </field>
    <field>
     <rect>
      <x>670</x>
      <y>5</y>
      <width>75</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>bold</weight>
     </font>
     <right/>
     <vcenter/>
     <data>
      <query>totals</query>
      <column>f_subtotal</column>
     </data>
    </field>
   </foot>
  </group>
  <detail>
   <key>
    <query>items</query>
   </key>
   <height>7</height>
  </detail>
 </section>
 <section>
  <name>notes</name>
  <detail>
   <key>
    <query>notes</query>
   </key>
   <height>32</height>
   <label>
    <rect>
     <x>10</x>
     <y>5</y>
     <width>132</width>
     <height>18</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <string>Order Comments:</string>
   </label>
   <text>
    <rect>
     <x>155</x>
     <y>5</y>
     <width>591</width>
     <height>18</height>
    </rect>
    <bottompad>5</bottompad>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>notes</query>
     <column>quhead_ordercomments</column>
    </data>
   </text>
  </detail>
 </section>
 <section>
  <name>extdescrip</name>
  <detail>
   <key>
    <query>notes</query>
   </key>
   <height>32</height>
   <label>
    <rect>
     <x>10</x>
     <y>5</y>
     <width>132</width>
     <height>18</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <string>Shipping Comments:</string>
   </label>
   <text>
    <rect>
     <x>155</x>
     <y>5</y>
     <width>591</width>
     <height>21</height>
    </rect>
    <bottompad>5</bottompad>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>notes</query>
     <column>quhead_shipcomments</column>
    </data>
   </text>
  </detail>
 </section>
 <pgfoot>
  <height>29</height>
  <field>
   <rect>
    <x>705</x>
    <y>0</y>
    <width>42</width>
    <height>11</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>
  <field>
   <rect>
    <x>85</x>
    <y>0</y>
    <width>103</width>
    <height>11</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>10</x>
    <y>0</y>
    <width>103</width>
    <height>11</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Quote Date:</string>
  </label>
  <label>
   <rect>
    <x>600</x>
    <y>0</y>
    <width>103</width>
    <height>11</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Page:</string>
  </label>
 </pgfoot>
</report>
