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; 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 |