Supplier UPC Look-Up System Wide (including ADC)

A distribution customer has multiple suppliers for one product, each with a unique UPC code.  They do not print labels on receipt but the items have the supplier UPC code on the items.  They want the ability to transact and look up the items by scanning or keying in the unique UPC.  The look up should search in the following order:

1. Product ID

2. Product Description

3. UPC code in Product file

4. UPC code in Product/Supplier file

5. Customer or Supplier product number (put this anywhere)