UNSPSC Reference
| Purpose: | Provide relevant aspects of the UNSPSC taxonomy. |
Structure and Description:
| Column | Type | Column Content |
|---|
| Commodity Code | Integer(8) | UNSPSC commodity code |
| Commodity Title | Character Varying(150) | UNSPSC commodity title |
| Class Code | Integer(8) | UNSPSC class code |
| Class Title | Character Varying(150) | UNSPSC class title |
| Family Code | Integer(8) | UNSPSC family code |
| Family Title | Character Varying(150) | UNSPSC family title |
| Segment Code | Integer(8) | 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.1 | 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 |
