Issue #23507:initial commit

[xtuple] / foundation-database / public / tables / metasql / purchase-purchaserequests.mql

diff --git a/foundation-database/public/tables/metasql/purchase-purchaserequests.mql b/foundation-database/public/tables/metasql/purchase-purchaserequests.mql
index 840c413..5ca4799 100644 (file)
--- a/foundation-database/public/tables/metasql/purchase-purchaserequests.mql
+++ b/foundation-database/public/tables/metasql/purchase-purchaserequests.mql
@@ -5,6 +5,7 @@
 -- See www.xtuple.com/CPAL for the full text of the software license.
 
 SELECT pr_id, itemsite_id, itemsite_qtyonhand, itemsite_reorderlevel,
+       qtyNetable(itemsite_id) AS netableqoh, qtyNetable(itemsite_id, FALSE) AS nonnetableqoh,
        item_number, (item_descrip1 || ' ' || item_descrip2) AS description,
        pr.*,
        CASE WHEN (pr_order_type='W') THEN ('W/O ' || ( SELECT formatWoNumber(womatl_wo_id)