3 -- Notes: used by salesOrder
4 -- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
5 -- See www.xtuple.com/CPAL for the full text of the software license.
8 quitem_linenumber AS f_linenumber,
9 0 AS coitem_subnumber, item_type,
10 item_number, (item_descrip1 || ' ' || item_descrip2) AS description,
11 warehous_code, '' AS enhanced_status,
12 quitem_scheddate AS coitem_scheddate,
13 quom.uom_name AS qty_uom,
14 quitem_qtyord AS coitem_qtyord,
15 0 AS qtyshipped, 0 AS qtyatshipping, 0 AS balance,
16 puom.uom_name AS price_uom,
17 quitem_price AS coitem_price,
18 ROUND((quitem_qtyord * quitem_qty_invuomratio) *
19 (quitem_price / quitem_price_invuomratio),2) AS extprice,
20 quitem_custprice AS coitem_custprice,
21 CASE WHEN (quitem_custprice = 0.0) THEN 100.0
22 ELSE ((1.0 - (quitem_price / quitem_custprice)) * 100.0)
23 END AS discountfromcust,
24 quitem_unitcost AS coitem_unitcost,
25 ROUND((quitem_qtyord * quitem_qty_invuomratio) *
26 ((quitem_price / quitem_price_invuomratio) - (quitem_unitcost / quitem_price_invuomratio)),2) AS margin,
27 CASE WHEN (quitem_price = 0.0) THEN 100.0
28 ELSE ((quitem_price - quitem_unitcost) / quitem_price)
30 CASE WHEN (quitem_custpn != '') THEN quitem_custpn
32 END AS item_number_cust,
33 (quitem_qtyord * quitem_qty_invuomratio * item_prodweight) AS prodweight,
34 (quitem_qtyord * quitem_qty_invuomratio * item_packweight) AS packweight,
36 'qty' AS coitem_qtyord_xtnumericrole,
37 'qty' AS qtyshipped_xtnumericrole,
38 'qty' AS balance_xtnumericrole,
39 'qty' AS qtyatshipping_xtnumericrole,
40 'qty' AS prodweight_xtnumericrole,
41 'qty' AS packweight_xtnumericrole,
42 'qty' AS itemsite_qtyonhand_xtnumericrole,
43 'salesprice' AS coitem_price_xtnumericrole,
44 'cost' AS coitem_unitcost_xtnumericrole,
45 'curr' AS margin_xtnumericrole,
46 'percent' AS marginpercent_xtnumericrole,
47 'curr' AS extprice_xtnumericrole
48 FROM item, uom AS quom, uom AS puom,
49 quitem LEFT OUTER JOIN (itemsite JOIN whsinfo ON (itemsite_warehous_id=warehous_id)) ON (quitem_itemsite_id=itemsite_id)
50 WHERE ( (quitem_item_id=item_id)
51 AND (quitem_qty_uom_id=quom.uom_id)
52 AND (quitem_price_uom_id=puom.uom_id)
53 AND (quitem_quhead_id=<? value("quhead_id") ?>) )
54 ORDER BY quitem_linenumber;