SELECT ITMFIL.ITEM_NO, ITEM_DESC_LIN_1, ITEM_DESC_LIN_2, ITEM_DESC_LIN_3, (ITEM_PRC_1 * 1.00000000) as 'RETAIL_PRC', ITEM_QTY_ON_HND, ITEM_QTY_COMMIT, ITEM_QTY_ON_BO, STK_UNIT_OF_MEAS, ITEM_ALT_UNIT_1, ITEM_ALT_UNIT_2, ITEM_PREFER_UNIT , STAFIL.STAT_QTY_ON_HND, STAFIL.STAT_QTY_COMMIT FROM (stafil LEFT OUTER JOIN itmfil ON stafil.STAT_ITEM_NO = itmfil.ITEM_NO) WHERE ITMAUXUF.TYP = 'E' AND ITMAUXUF.FLD_IDX = 10 AND ITMAUXUF.FLD_VALU = '002' AND ITEM_ON_WEB_FLG = 'Y' ORDER BY itmfil.ITEM_NO ASC [nativecode=S1000 [TOD][ODBC][GENESIS]Column ITMAUXUF.TYP undefined]