qq|SELECT
p.id, p.partnumber, p.description, p.lastcost AS sellprice, p.listprice,
p.unit, p.assembly, p.onhand, p.formel,
- p.notes AS partnotes, p.notes AS longdescription, p.not_discountable,
+ p.not_discountable,
p.inventory_accno_id, p.price_factor_id,
- p.ean,
+ p.ean, p.notes,
pfac.factor AS price_factor,