UNSPSC Reference
| Purpose: | Provide relevant aspects of the UNSPSC taxonomy. |
| Table Name: | unspsc_reference |
Structure and Description:
| Column | Type | Column Content |
|---|
| commodity_code | Decimal(8,0) | UNSPSC commodity code |
| commodity_title | Character Varying(150) | UNSPSC commodity title |
| class_code | Decimal(8,0) | UNSPSC class code |
| class_title | Character Varying(150) | UNSPSC class title |
| family_code | Decimal(8,0) | UNSPSC family code |
| family_title | Character Varying(150) | UNSPSC family title |
| segment_code | Decimal(8,0) | UNSPSC segment code |
| segment_title | Character Varying(150) | UNSPSC segment title |
This file contains a listing of commodities in the United Nations Standard Products and Services Code (UNSPSC), version 23.0701. The UNSPSC is a four-level taxonomy for the classification of products and services, provided by the United Nations Development Programme. In the taxonomy, the Segment is the most general element and the Commodity is the most specific. One example is listed below:
| Segment: | 43000000 | Information Technology Broadcasting and Telecommunications |
| Family: | 43230000 | Software |
| Class: | 43232100 | Content authoring and editing software |
| Commodity: | 43232104 | Word processing software |
Each technology or tool example is classified under this taxonomy; the “Commodity Code” and “Commodity Title” columns in the Technology Skills and Tools Used files 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,262 rows of data in this file.
For more information, see:
File Structure Changes:
| Release Number | Description of Change |
|---|
| 20.1 | Added as a new file |
| 20.2 - 27.3 | No structure changes |
Data Example - unspsc_reference:
| commodity_code | commodity_title | class_code | class_title | family_code | family_title | segment_code | segment_title |
|---|
| 12131704 | Explosive initiators | 12131700 | Igniters | 12130000 | Explosive materials | 12000000 | Chemicals including Bio Chemicals and Gas Materials |
| 12131707 | Lighters | 12131700 | Igniters | 12130000 | Explosive materials | 12000000 | Chemicals including Bio Chemicals and Gas Materials |
| 14111513 | Ledger paper | 14111500 | Printing and writing paper | 14110000 | Paper products | 14000000 | Paper Materials and Products |
| 14111802 | Receipts or receipt books | 14111800 | Business use papers | 14110000 | Paper products | 14000000 | Paper Materials and Products |
