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 15.1101. 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: | 41000000 | Laboratory and Measuring and Observing and Testing Equipment |
| Family: | 41110000 | Measuring and observing and testing instruments |
| Class: | 41116200 | Patient point of care testing supplies and equipment |
| Commodity: | 41116201 | Glucose 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,307 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 - 23.0 | 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 |
