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.

Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.