Back
/*
Table: vendorItems

Columns:
    upc varchar
    sku varchar
    brand varchar
    description varchar
    size varchar
    units int
    cost dbms currency
    saleCost dbms currency
    vendorDept int
    vendorID int

Depends on:
    vendors (table)
    vendorDepartments (table)

Use:
This table has items from vendors. Cost
and vendor department margin are used to 
calculate SRPs, but the other fields are useful
for making shelf tags.

Size relates to an indivdual product.
Units relates to a case. So a case of beer has 24
units, each with a size of 12 oz.

Cost represents the unit cost. Cost times units 
should then equal the case cost. Sale Cost is
for storing temporary special prices.

upc corresponds to products.upc. Multiple vendorItems
records may map to one products record if an item
is available from more than one vendor or under 
several SKUs from the one vendor. sku should 
uniquely identify an item for the purpose of ordering
it from the vendor. If the vendor does not have SKUs
you have to assign some. The field is wide enough
to hold a UPC; putting your UPC or the vendor's UPC
in the SKU field may be a simple solution to assigning
SKUs.
*/
Back