RIS-SC-1008

Product Commodity Codes

Description

This query retrieves the SKU (ItemNumber) and Commodity Code for stock items that match certain criteria. It joins the StockItem table with the Stockitem_ExtendedProperties table to retrieve the Commodity Code associated with each stock item.
image 13
male female graphic designers interacting computer
female web designer taking notes office
How to generate the report: a step-by-step guide
  1. Select the Product Commodity Codes Report in the Query type drop-down menu.
  2. Click the Generate Report button.
  3. Select the Time Zone and click the Download (CSV file) button when downloading the report.

Summary

This query selects the ItemNumber (SKU) and CommodityCode from the StockItem table, joined with the Stockitem_ExtendedProperties table to fetch the Commodity Code. It filters the results to include only active and non-archived items with SKU starting with ‘BL-‘ and having a non-null Commodity Code.

Reported Values

The report returns the following values:
Column NameDescription
SKUThe SKU / Item Number of the stock item.
CommodityCodeThe commodity code associated with the stock item.