Metamap

Description

Metamap is an additional service provided to DataSource customers for mapping SKUs to distributor part numbers. DataSource customers may receive distributors' part numbers from one or multiple distributors (depending on the contract terms) for the products delivered to the customer by 1WorldSync and based on distributors' catalog available at 1WorldSync.

Metamap is mostly useful to the customers with SupplierBase (Synchro) or CategoryBase or full market PUSH accounts. These types of accounts have DataSource SKUID as the primary key identifier (ProdID) as opposed to CatalogBase (PULL) accounts which have their own internal part number (Customer PN) as the primary key (ProdID).

 

Database Structure

The distributor part numbers are delivered in the tables Metamap and Distivoc.

 

Metamap table

This table provides the information on the distributor part numbers linked to DataSource SKUIDs.

Field Name	Type/Lenght	Nullable	Field Description
ProdID	varchar(40)	not null	Unique product key
DistiSKU	varchar(40)	not null	Distributor part number
DistiID	varchar(10)	not null	ID of a distributor which name is provided in the table Distivoc
Delivery: Full

 

Metamap example

The part numbers in the metamap table for HP Pro Slate 10 EE G1 tablet: 

ProdID	DistiSKU	DistiID
S15414187	11710743	C00030
S15414187	37215Y	C00040
S15414187	4166169	C00055

 

 

Distivoc table

This table is related to the table metamap and contains the distributors' names.

Field Name	Type/Lenght	Nullable	Field Description
ID	varchar(10)	not null	Unique key for the distributor
Name	varchar(50)	not null	Distributors' names.
Delivery: Full

 

Distivoc example

Here are the names for DistiIDs provided in Metamap Example above.

ID	Name
C00030	Tech Data Metamapping US
C00040	Ingram Metamapping US
C00055	Synnex Metamapping US

 

Sample Query

SELECT m.prodid,
       m.distisku AS DistributorPN
FROM   cds_metamap m
WHERE  m.prodid = 'PRODUCTID'
       AND m.distiid = 'Distributor ID'