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; 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: | 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,300 rows of data in this file.
File Structure Changes:
| Release Number | Description of Change |
|---|
| 20.1 | Added as a new file |
| 20.2 - 20.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 |
