The Upsilon Commodity Code Enquiry option allows users to filter the Luckins Distributors Database by Luckins specified Commodity Codes.  The Commodity Code Enquiry is a three tier system whereby users select a major Commodity Code, a minor Commodity Code and are then presented with a list of items which match the selected criteria.

• Tier 1 - Major Commodity Code DataGrid
• Tier 2 - Minor Commodity Code DataGrid
• Tier 3 - Items DataGrid

The Upsilon Luckins Major Commodity Code grid allows you to browse, filter and sort the Commodity Code records contained within the Luckins database.

TIP: Clicking the Major Commodity Code field will drill-down to the Tier 2 - Minor Commodity Code records for the selected Major Commodity Code.

Toolbar

Toolbar Item	Description
	The Quick Search option can be used to quickly filter the grid. NOTE: Fields searched by the Quick Search option are Commodity Code and Description.
	The search button can be used if a more detailed search is required.  Using this option the grid can be filtered by any value in any field.
	The Export button is used to export the grid records to an external, downloadable data file.  Supported file formats are MS Excel, CSV and XML.  At time of export there are also options to specify which columns are included in the exported data along with other file type specific options.
	The Settings button can be used to customise the column layout of the grid by adding or subtracting grid columns.  The status of the grid can also be saved so that the required grid status can be loaded again at a later time.
	Refresh the grid.
	Calls context sensitive help system.

The Upsilon Luckins Commodity Code Minor grid allows you to browse, filter and sort minor Commodity Code records for the selected supplier record.

TIP: Clicking the product range minor field will drill-down to the item records for the selected Commodity Code Major / Minor combination.

Toolbar

Toolbar Item	Description
	The Quick Search option can be used to quickly filter the grid. NOTE: Fields searched by the Quick Search option are Commodity Code and Description.
	The search button can be used if a more detailed search is required.  Using this option the grid can be filtered by any value in any field.
	The Export button is used to export the grid records to an external, downloadable data file.  Supported file formats are MS Excel, CSV and XML.  At time of export there are also options to specify which columns are included in the exported data along with other file type specific options.
	The Settings button can be used to customise the column layout of the grid by adding or subtracting grid columns.  The status of the grid can also be saved so that the required grid status can be loaded again at a later time.
	Refresh the grid.
	Calls context sensitive help system.

The Upsilon Luckins Commodity Code Enquiry Items grid allows you to browse, filter and sort item records for the selected Commodity Code Major / Minor combination.

TIP: Clicking the magnifying glass icon will drill-down to the complete record information for the selected item record.

Toolbar

Toolbar Item	Description
	The Quick Search option can be used to quickly filter the grid. NOTE: Fields searched by the Quick Search option are Item Code, Catalogue Number 1, Catalogue Number 2 and Brand Name.
	The search button can be used if a more detailed search is required.  Using this option the grid can be filtered by any value in any field.
	The Export button is used to export the grid records to an external, downloadable data file.  Supported file formats are MS Excel, CSV and XML.  At time of export there are also options to specify which columns are included in the exported data along with other file type specific options.
	The Settings button can be used to customise the column layout of the grid by adding or subtracting grid columns.  The status of the grid can also be saved so that the required grid status can be loaded again at a later time.
	Refresh the grid.
	Calls context sensitive help system.