/*
Table: batchList

Columns:
    listID int (auto increment)
    upc varchar(13)
    batchID int
    salePrice dbms currency
    active bit
    pricemethod int
    quantity int

Depends on:
    batches (table)

Use:
This table has a list of items in a batch.
In most cases, salePrice maps to
products.special_price AND products.specialgroupprice,
pricemethod maps to products.specialpricemethod,
and quantity maps to products.specialquantity.

WFC has some weird exceptions. The main on is that 
upc can be a likecode, prefixed with 'LC'
*/