Cust.vwProductList

Output

Field Name	Notes

Field Name	Notes
SiteCode	2 digit code from the Site table referencing the site
CustomerCode
ProductCode
ProduceDescription
Vintage	The Product Vintage - If using variable unit of measure then this can be different on the stock table.
CountryCode	Country of Origin
SinglesPerUnit	Singles in a Case (e.g. Bottles in Case )
SingleSize	The single or bottle size in litres
StrengthABV	As a percentage
CommodityCode
TaxCode
BrandName
TransportAdjustmentsSign	Either + or -
TransportAdjustment	This is the percentage rate

Criteria

Will not display archived products.

Vision Warehousing