UNSPSC Reference

Purpose:Provide relevant aspects of the UNSPSC taxonomy.
Table Name:unspsc_reference
Structure and Description:
ColumnTypeColumn Content
commodity_codeDecimal(8,0)UNSPSC commodity code
commodity_titleCharacter Varying(150)UNSPSC commodity title
class_codeDecimal(8,0)UNSPSC class code
class_titleCharacter Varying(150)UNSPSC class title
family_codeDecimal(8,0)UNSPSC family code
family_titleCharacter Varying(150)UNSPSC family title
segment_codeDecimal(8,0)UNSPSC segment code
segment_titleCharacter Varying(150)UNSPSC segment title

This file contains a listing of commodities in the United Nations Standard Products and Services Code (UNSPSC), version 15.1101. The UNSPSC is a four-level taxonomy for the classification of products and services, provided by the United Nations Development Programme; more information can be found at the UNSPSC web site (http://www.unspsc.org/). In the taxonomy, the Segment is the most general element and the Commodity is the most specific. One example is listed below:

Segment:41000000Laboratory and Measuring and Observing and Testing Equipment
Family:41110000Measuring and observing and testing instruments
Class:41116200Patient point of care testing supplies and equipment
Commodity:41116201Glucose monitors or meters

Each T2 example is classified under this taxonomy; the “Commodity Code” and “Commodity Title” columns in the Tools and Technology file can be used as a cross-reference into this file.

The file is displayed in 8 tab delimited fields with the columns named Commodity Code, Commodity Title, Class Code, Class Title, Family Code, Family Title, Segment Code, and Segment Title. The 8 fields are represented by one row. There are a total of 4,300 rows of data in this file.

File Structure Changes:
Release NumberDescription of Change
20.1Added as a new file
20.2 - 20.3No structure changes

Data Example - unspsc_reference:
commodity_​codecommodity_​titleclass_​codeclass_​titlefamily_​codefamily_​titlesegment_​codesegment_​title
12131704Explosive initiators12131700Igniters12130000Explosive materials12000000Chemicals including Bio Chemicals and Gas Materials
12131707Lighters12131700Igniters12130000Explosive materials12000000Chemicals including Bio Chemicals and Gas Materials
14111513Ledger paper14111500Printing and writing paper14110000Paper products14000000Paper Materials and Products
14111802Receipts or receipt books14111800Business use papers14110000Paper products14000000Paper Materials and Products