UNSPSC
Overview
The United Nations Standard Products and Services Code is a classification convention that is used to numerically identify all products and services. It is the most efficient, accurate and flexible classification system available today for achieving company-wide visibility of spend analysis, enabling procurement to deliver on cost-effectiveness demands and allowing full exploitation of electronic commerce capabilities. The UNSPSC was developed jointly by the UNDP (United Nations Development Program) and D & B (Dun & Bradstreet Corporation) in 1998.
The UNSPSC is a hierarchical classification with five levels. These levels allow analysis by drilling down or rolling up to analyze expenditures. Each level in the hierarchy has its own unique number.
XX Segment
The logical aggregation of families for analytical purposes
XX Family
A commonly recognized group of inter-related commodity categories
XX Class
A group of commodities sharing common characteristics
XX Commodity
A group of substitutable products or services
XX Business Function
The function performed by an organization in support of the commodity
A structural view of the code set would look as follows:
|
Hierarchy |
Category Number |
Name |
|
Segement |
43 |
Information Technology Broadcasting and Telecommunications Communications Devices |
|
Family |
20 |
Components for information technology or broadcasting or telecommunications Computer Equipment and Accessories |
|
Class |
15 |
Computers Computer accessories |
|
Commodity |
01 |
Computer switch boxes Docking stations |
|
Business Function |
14 |
Retail |
All UNSPSC entities are further identified with an 8-digit structured numeric code which both indicates its location in the taxonomy and uniquely identifies it. An additional 2-digit suffix indicates the business function identifier.
1WorldSync Content Solutions uses 8-digit commodity code, which is built by aggregating a Segment, Family, Class and Commodity two-digit codes.
UNSPSC Mapping
UNSPSC Mapping option provides extensive coverage - vast majority of 1WorldSync Content Solutions SKUs have an 8-digit UNSPSC commodity code and UNSPSC description.
It is 100% compliant with the latest UNDP UNSPSC classification which is updated twice a year.
Customer SKU number, the 1WorldSync Content Solutions SKU number and the manufacturer part number are mapped to the corresponding UNSPSC commodity code.
It links to DataSource Product Data Model Classes and Categories, together with, consistent product information content.
In order to provide the best coverage and accuracy of UNSPSC commodity codes (8-digits) to each of the SKUs in our extensive product data catalog, we ensure that the following requirements are met:
Completeness: all SKUs produced by 1WorldSync Content Solutions are assigned with a commodity code either instantaneously or, in the event that the classification cannot host the product, after a request to the UNDP UNSPSC to provide additional codes.
Compliance: all UNSPSC codes will comply with the latest version of the classification. 1WorldSync Content Solutions re-evaluates
its mapping processes and rules accordingly with each new version release,
and redelivers updated codes.
Flexibility: depending on its features, a product can be assigned more than one commodity code.
Database Structure
Unspsc_Versioned_Commodities
This table contains the list of UNSPSC Commodities for all versions the customer is subscribed to.
|
Field Name |
Type/Length |
Nullable |
Description |
|
CommodityCode |
varchar (8) |
not null |
Code of the commodity. |
|
CommodityName |
varchar (255) |
not null |
Name of the commodity. |
|
UnspscVersionID |
int |
not null |
Identifier of the UNSPSC version. References the UNSPSCVersionID column of the Unspsc_Versions table. |
|
Delivery: Full |
|||
Unspsc_Versions
This table contains the list of UNSPSC versions the customer is subscribed to.
|
Field Name |
Type/Length |
Nullable |
Description |
|
UnspscVersionID |
int |
not null |
Identifier of the UNSPSC version. References the UnspscVersionId column of the Unspsc_Versions table. |
|
UnspscVersion |
varchar (80) |
not null |
Name of the version. |
|
IsLatest |
bit |
not null |
Identifier of the latest UNSPSC version. |
|
Delivery: Full |
|||
Unspsc_Versioned_Links
The table contains the links between customer products and UNSPSC commodities for all versions the customer is subscribed to.
|
Field Name |
Type/Length |
Nullable |
Description |
|
ProdID |
varchar (40) |
not null |
Identifier of the customer product, references the ProdID column of the Catalog table. |
|
CommodityCode |
varchar (8) |
not null |
Code of the commodity, references the CommodityCode column of the Unspsc_Versioned_Commodities table. |
|
UnspscVersionID |
int |
not null |
Identifier of the UNSPSC version, references the UnspscVersionId column of the Unspsc_Versions table and the UnspscVersionId column of the Unspsc_Versioned_Commodities table. |
|
IsDefault |
bit |
not null |
Flag indicating whether the commodity (identified by CommodityCode) is default one for the product (identified by ProdID) within the UNSPSC version (identified by UnspscVersionId). |
|
Delivery: Full |
|||
Related Queries
SELECT l.ProdID,
l.CommodityCode,
vc.CommodityCode,
v.UnspscVersion
FROM cds_Unspsc_Versioned_Links l
JOIN cds_Unspsc_Versions v
ON v.UnspscVersionId = l.UnspscVersionId
JOIN cds_Unspsc_Versioned_Vommodities vc
ON vc.CommodityCode = l.CommodityCode
WHERE l.ProdID = 'PRODUCTID'