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'
