DataSource Tables
Primary Catalog
Prod (cds_prod)
This table provides the list of delivered products (all in full file, new and updated in increment).
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID (PK) |
varchar(40) |
not null |
Unique product identifier.
|
|
CatID |
char(2) |
not null |
Category identifier |
|
MktID or Reserved15 |
varchar(10) |
not null |
Marketing text identifier (legacy field)
|
|
ImgID |
varchar(10) |
not null |
Image identifier (legacy field)
|
|
MfID |
varchar(10) |
not null |
Manufacturer identifier |
|
MfPN |
varchar(40) |
not null |
Manufacturer Part Number |
|
Delivery: Increment
|
|||
Catalog (cds_catalog or cds_catalog_info)
This table provides the list of delivered products (all in full file, new and updated in increment).
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID (PK) |
varchar (40) |
not null |
Unique product identifier.
|
|
StatusCode |
char(4) |
not null |
Product status identifier.
|
|
LastDeliveryDate |
char(10) |
null |
Date when a product was last delivered.
|
|
CreationDate |
char(10) |
null |
Date when 1WorldSync Content Solutions ProdID has been created. |
|
LastRequestDate |
char(10) |
null |
Date when a product was requested last time.
|
|
IsPartial |
bit |
not null |
Partial Product identifier. |
|
IsObsolete |
bit |
not null |
Obsolete Product identifier |
|
Delivery: full
|
|||
SKUStatus (cds_skustatus)
This table provides products’ status definition.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
StatusCode |
char(4) |
not null |
Product status identifier |
|
StatusName |
varchar(100) |
not null |
Product status definition |
|
Delivery: full |
|||
- Basic Categorization
Cctxx (cds_Cctxx)
This table is the vocabulary table which contains all classes and category names.
“xx” in the table name is for a language code which the data is delivered in.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ID |
char(2) |
not null |
Unique class / category identifier |
|
Description |
varchar(80) |
not null |
Class / Category name |
|
DefaultImageID |
varchar(10) |
null |
Generic image ID per category (legacy field) |
|
Delivery: full |
|||
- Searchable Attributes
Atr (cds_Atr)
This table provides the searchable attributes (either Product Line and Model or the full set of searchable attributes) per product.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID (PK) |
varchar(40) |
not null |
Unique product identifier.
|
|
CatID |
char(2) |
not null |
Category identifier |
|
AtrID |
varchar(10) |
not null |
Attribute identifier
|
|
ValID |
varchar(10) |
not null |
Value identifier
|
|
UnitID |
varchar(10) |
null |
Unit of measure identifier |
|
NNV |
double |
null |
Normalized Numeric Value – a numeric representation of value combined with the unit of measure. This field should be used for sorting and attribute comparison. |
|
Delivery: Increment
|
|||
Cat (cds_Cat)
This table provides the list of searchable attribute IDs per category.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
CatID |
char(2) |
not null |
Category identifier |
|
AtrID |
varchar(10) |
not null |
Attribute identifier |
|
Delivery: full |
|||
Vocxx (cds_Vocxx)
This is the vocabulary table for Attribute IDs, Value IDs, Unit IDs, and Manufacturer IDs..
“xx” in the table name is for a language code which the data is delivered in.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ID |
varchar(10) |
not null |
Entry identifier (AtrID, ValID, UnitID, MfID) |
|
Text |
varchar(255) |
not null |
Entry name (Attribute Name, Value Name, Unit Name, Manufacturer Name) |
|
Delivery: increment |
|||
- Product Lifecycle
Lifecycle (cds_Lifecycle)
This table provides lifecycle information provided by the manufacturers.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID (PK) |
varchar(40) |
not null |
Unique product identifier.
|
|
RegionCode |
char(2) |
not null |
The region the lifecycle information is for |
|
isDiscontinued |
varchar(10) |
null |
Discontinued product identifier
|
|
DiscontinuedDate |
varchar(10) |
null |
Date when the product became discontinued
|
|
ReleaseDate |
varchar(10) |
null |
Date when the product is released |
|
Delivery: Full
|
|||
Regions (cds_regions)
This table contains the list of regions for lifecycle information.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
RegionCode (PK) |
varchar (20) |
not null |
Unique identifier of the region. |
|
RegionName |
varchar (200) |
not null |
Name of the region. |
|
Delivery: Full |
|||
Specifications
- Standardized Description
Stdnxx (cds_stdnxx)
The standardized product description is provided in this table.
“xx” in the table name is for a language code which the data is delivered in.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID (PK) |
varchar(40) |
not null |
Unique product identifier.
|
|
Description |
varchar(2000) |
not null |
Standardized product description |
|
Delivery: Increment
|
|||
- Main Specifications
Mspecxx (cds_mspecxx)
This table provides the main product specifications that contain the most important product data information.
“xx” in the table name is for a language code which the data is delivered in.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID (PK) |
varchar(40) |
not null |
Unique product identifier.
|
|
HdrID (PK)
|
varchar(10) |
not null |
Specifications header identifier |
|
BodyID (PK) |
varchar(10) |
not null |
Specifications entry identifier |
|
DisplayOrder |
int |
not null |
Specifications position number |
|
Delivery: Increment
|
|||
Mvocxx (cds_Mvocxx)
This is the vocabulary table for Mspecxx. Each Hdrid, and Bodyid in Mspecxx can be translated into text by linking to this table.
“xx” in the table name is for a language code which the data is delivered in.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ID (PK) |
varchar(10) |
not null |
Mspecxx identifier (HDrID, BodyID) |
|
Text |
varchar(2000) |
not null |
Main specifications’ header name and the specifications |
|
Delivery: increment |
|||
- Extended Specifications
Especxx (cds_especxx)
This table provide the extended product specifications, i.e. this is the extended version of the main specifications including all product detailed information.
The extended specifications present data in three parts:
- Section
- Header
- Body
Each section may have multiple header / body pairs.
“xx” in the table name is for a language code which the data is delivered in.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID (PK) |
varchar(40) |
not null |
Unique product identifier.
|
|
SectID (PK) |
varchar(10) |
not null |
Specifications section identifier |
|
HdrID (PK)
|
varchar(10) |
not null |
Specifications header identifier |
|
BodyID (PK) |
varchar(10) |
not null |
Specifications entry identifier |
|
DisplayOrder |
int |
not null |
Specifications position number |
|
Delivery: Increment
|
|||
Evocxx (cds_Evocxx)
The Evocxx table is the vocabulary table for Especxx. Each Sectid, Hdrid, and Bodyid in Especxx can be translated into text by linking to Evocxx.
“xx” in the table name is for a language code which the data is delivered in.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ID (PK) |
varchar(10) |
not null |
Especxx identifier (SectID, HDrID, BodyID) |
|
Text |
varchar(2000) |
not null |
Extended specifications’ section andheader name and the specifications |
|
Delivery: increment |
|||
Related Products
- Related Products (Accessories) Links
Acc_Links (cds_acc_links)
This table provides the information about Accessory SKU-to-Parent SKU relationship.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID |
varchar(40) |
not null |
Accessory product identifier |
|
PProdID |
varchar(40) |
not null |
Accessory’s Parent Product identifier |
|
Delivery: Increment |
|||
Acc_Updates (cds_acc_updates)
This table contains the list of accessories whose compatibility information has changed since the last delivery.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID |
varchar(40) |
not null |
Accessory product identifier |
|
Delivery: Increment |
|||
- Compatibility Rules
Acc_Compatibility (cds_acccompat)
This table provides the information about Accessory SKU-to-Parent Product Line / Model relationship.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID |
varchar(40) |
not null |
Accessory product identifier |
|
PProductLine |
varchar(10) |
null |
Attribute value of a parent ProductLine related to this accessory |
|
PModel |
varchar(10) |
null |
Attribute value of a parent Model related to this accessory |
|
ComplementID |
int |
null |
Compatibility condition identifier – a reference to the table Acc_Compatibility_Complement_xx |
|
PCatID |
char(2) |
not null |
Category Code for the Accessory’s Parent Product |
|
PMfID |
varchar(10) |
not null |
Manufacturer identifier of the Accessory’s Parent Product |
|
Delivery: Increment |
|||
Acc_Compatibility_Complement_xx (cds_acccompat_complement_xx)
It specifies under what condition compatibility of an accessory with parent products is valid and may also provide additional information regarding compatibility.
“xx” in the table name is for a language code which the data is delivered in.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ComplementID |
int |
not null |
Compatibility condition identifier |
|
ApplicableCondition |
varchar(2000) |
null |
Text that describes when the accessory fits the parent product line or parent model. |
|
Details |
varchar(2000) |
null |
Text that provides additional details in certain cases. |
|
Delivery: Increment |
|||
Digital Content
Digital content provides the images, marketing text, key selling points, product features, what’s in the box and manufacturer’s PDFs.
Digital_Content (cds_digcontent)
The table Digital_Content contains the list of files located on the 1WorldSync Content Solutions’s content server, which are mapped to the customer’s product(s) and have been added / changed since the last delivery to the customer.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ContentGuid (PK) |
char (36) |
not null |
Unique identifier of the digital content item, a string representation of the unique identifier data type in MSSQL. For example,
|
|
MediaTypeID |
int |
not null |
Media type identifier — a reference to the digital_content_media_types file.
|
|
MimeType |
varchar(50) |
not null |
Mime type of the content file. For example, "image/jpeg" or "image/x-photoshop".
|
|
URL |
varchar(500) |
not null |
URL to the 1WorldSync Content Solutions’s digital content web site. The files can be downloaded using this URL.
|
|
Timestamp |
char(19) |
not null |
Date and time when the digital content item was last changed at 1WorldSync Content Solutions, in the YYYY-MM-DD HH:MI:SS format and the 24-hour notation.
|
|
Delivery: Increment
|
|||
Digital_Content_Media_Types (cds_digcontent_media_types)
This table contains all digital content media types that the customer can download.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
MediaTypeID (PK) |
int |
not null |
Unique identifier of the digital content media type. For example, "5", "15".
|
|
MediaType Description |
varchar (1000) |
not null |
Description of the digital content media type in English. For example, “Key Selling Points’, "1WS Product Image".
|
|
Delivery: Increment
|
|||
Digital_Content_Prod (cds_digcontent_prod)
It contains products which digital content links has changed since the last delivery to the customer or which have been remapped to another 1WorldSync Content Solutions’s SKU since the last delivery.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID (PK) |
varchar (40) |
not null |
Unique product identifier — a reference to an entry in cds_Catalog. |
|
Delivery: Increment |
|||
Digital_Content_Links (cds_digcontent_links)
It contains all links to digital content for all products listed in the Digital_Content_Prod table.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID |
varchar(40) |
not null |
Unique product identifier — a reference to the digital_content_prod file. |
|
ContentGuid |
char(36) |
not null |
Unique content item identifier — a reference to the digital_content file. |
|
Delivery: Increment |
|||
Digital_Content_Regions (cds_digcontent_regions)
This table contains the complete list of regions valid for the customer.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
RegionCode (PK) |
varchar (20) |
not null |
Unique identifier of the region. |
|
RegionName |
varchar (200) |
not null |
Name of the region. |
|
Delivery: Increment |
|||
Digital_Content_Region_Links (cds_digcontent_region_links)
It contains the information on the region the digital content item belongs to.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ContentGuid |
char (36) |
not null |
Unique digital content identifier — a reference to the digital_content file. |
|
RegionCode |
varchar (20) |
not null |
Unique region identifier — a reference to the digital_content_regions file. |
|
Delivery: Increment |
|||
Digital_Content_Languages (cds_digcontent_langs)
This table contains the complete list of languages the customer receives data in.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
LanguageCode (PK) |
varchar (20) |
not null |
Unique identifier of the language. |
|
LanguageName |
varchar (200) |
not null |
Name of the language. |
|
Delivery: Increment |
|||
Digital_Content_Language_Links (cds_digcontent_lang_links)
The table provides the information on the language the digital content item is delivered in.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ContentGuid |
char (36) |
not null |
Unique digital content identifier — a reference to the digital_content file. |
|
LanguageCode |
varchar (20) |
not null |
Unique language identifier — a reference to the digital_content_languages file. |
|
Delivery: Increment |
|||
Digital_Content_Meta (cds_digcontent_meta)
It contains the meta information of digital content links.
|
Field Name |
Type/Length |
Nullable |
Field Description |
|
ContentGuid |
char (36) |
not null |
Unique digital content identifier – a reference to the cds_Digital_Content table |
|
MetaAtrID |
int |
not null |
Meta/tag attribute identifier. |
|
MetaValueID |
int |
not null |
Meta/tag value identifier. |
|
Delivery: Increment |
|||
Digital_Content_Meta_Atr_Voc (cds_digcontent_meta_atrvoc)
Digital_Content_Meta_Atr_Voc table contains the list of meta/tag attributes.
|
Field Name |
Type/Length |
Nullable |
Field Description |
|
MetaAtrID |
int |
not null |
Unique meta/tag attribute identifier. |
|
LanguageCode |
varchar(20) |
not null |
Unique language identifier – a reference to the cds_Digital_Content_Languages table. |
|
MetaAtrName |
varchar(20) |
not null |
Meta/tag language-dependent attribute name. For example, “Image Type”, “Image Angle”, etc. |
|
Delivery: Increment |
|||
Digital_Content_Meta_Value_Voc (cds_digcontent_meta_valvoc)
Digital_Content_Meta_Value_Voc table contains the list of possible values of meta/tag attributes.
|
Field Name |
Type/Lenght |
Nullable |
Field Description |
|
MetaValueID |
int |
not null |
Unique meta/tag value identifier. |
|
LanguageCode |
varchar(20) |
not null |
Unique language identifier – a reference to the cds_Digital_Content_Languages table. |
|
MetaValueName |
varchar(20) |
not null |
Meta/tag language-dependent value. |
|
Delivery: Increment |
|||
Digital_Content_Text (cds_digcontent_text)
This table is intended for all text components existing in Digital Content, which includes:
- Marketing Description
• Key Selling Points (KSP)
• Product Features
• What’s In The Box
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ContentGuid (PK) |
char (36) |
not null |
Unique identifier of the digital content item.
|
|
LanguageCode |
Varchar(20) |
not null |
Unique language identifier
|
|
Region Code |
Varchar(20) |
not null |
Unique region identifier
|
|
MediaTypeID |
Int |
not null |
Unique identifier of the digital content media type: E.g., “4″ for Marketing Descriptions, or “5″ for Key Selling Points |
|
Text |
Ntext |
not null |
Text presented in XML format |
|
Timestamp |
char(19) |
not null |
Date and time when the digital content item was last changed. |
|
Delivery: Increment |
|||
Metamap / UPC (EAN)
Metamap (cds_metamap)
The metamap links distributor part numbers, UPC / EAN codes and Customer part numbers 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 or UPC / EAN code or Customer part number |
|
DistiID |
varchar(10) |
not null |
ID of a distributor or UPC / EAN account or Customer account identifier which name is provided in the table Distivoc. |
|
Delivery: Full |
|||
Distivoc (cds_distivoc)
This table is related to the table metamap and contains the distributors, UPC/EAN accounts, customer accounts and manufacturer names.
|
Field Name |
Type/Lenght |
Nullable |
Field Description |
|
ID |
varchar(10) |
not null |
Unique key for the distributor, UPC / EAN account, customer account or manufacturer |
|
Name |
varchar(50) |
not null |
Distributors, UPC/EAN accounts, customer accounts or manufacturer names. |
|
Delivery: Full |
|||
UNSPSC
Unspsc_Versioned_Commodities (cds_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 (cds_unspsc_versioned_commodities)
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 (cds_unspsc_versioned_commodities)
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 |
|||
Alternative Categorization
Alternative DataSource Categorization consists of five categorization levels.
Levels 1, 2, 3 and 4 are mandatory and every SKU will be assigned to at least one category on each level.
Level 5 is optional. It exists only for certain catalog segments where four categorization levels are not sufficient.
Alternative DataSource Categorization is provided in five tables.
Note: Alternative Categorization tables are also used to deliver 3rd-party classifications as ECCN, HTS, UK Trade Tariff.
Cct_Categories (cds_Cct_Categories)
This table contains all alternative categories and does not depend on the customer’s catalog.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
CatID (PK) |
varchar(40) |
not null |
Unique category identifier |
|
VersionID (PK) |
int(11) |
not null |
Categorization version identifier |
|
CategoryName |
varchar(300) |
null |
Name of the category |
|
CatKey |
varchar(40) |
null |
Non-hierarchical unique category identifier that does not change when a category is moved from one parent category to another. |
|
ParentCatID |
varchar(40) |
null |
Parent category identifier |
|
CategoryLevel |
int(11) |
null |
Level of the category |
|
DisplayOrder |
int(11) |
null |
Category position number |
|
Breadcrumbs |
varchar(2000) |
null |
Upper-level categories intended for browsing/reference purposes |
|
Notes |
varchar(300) |
null |
Category-specific notes |
|
isOptional |
bit |
null |
Indentifies extra/duplicating branches of the categorization tree |
|
isObsolete |
bit |
null |
Intended for old and/or mostly-dead technology categories like EDO RAM or Floppy Disks. |
|
Delivery: full |
|||
Cct_Products (cds_Cct_Products)
This table links the alternative categories to the products delivered in the customer’s catalog.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
ProdID (PK) |
varchar(40) |
not null |
Unique product identifier |
|
VersionID (PK) |
int(11) |
not null |
Categorization version identifier |
|
CatID (PK) |
varchar(40) |
not null |
Unique category identifier |
|
isPrimary |
bit |
null |
Primary category identifier |
|
Delivery: full |
|||
Cct_Version (cds_Cct_Version)
This table identifies the version of the delivered categorization.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
VersionID (PK) |
int(11) |
not null |
Categorization version identifier |
|
VersionDescription |
varchar(100) |
not null |
Categorization version |
|
SourceID |
int(11) |
not null |
Version source identifier. All versions of the same categorization will have the same SourceID. |
|
SourceDescription |
varchar(100) |
not null |
Name of the version’s source |
|
ReleaseDate |
char(10) |
null |
The date when the version was released |
|
isLatest |
bit |
null |
Latest version identifier |
|
Delivery: full |
|||
Cct_Vocabulary (cds_Cct_Vocabulary)
This table contains translations of category names to all languages a customer is subscribed to.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
CatID (PK) |
varchar(40) |
not null |
Unique category identifier |
|
VersionID (PK) |
int(11) |
not null |
Categorization version identifier |
|
LanguageID (PK) |
varchar(20) |
not null |
Language identifier |
|
CategoryName |
varchar(255) |
null |
Name of the category |
|
Delivery: full |
|||
Languages (cds_languages)
This table contains the list of languages the customer receives data in.
|
Field Name |
Type / Length |
Nullable |
Field Description |
|
LanguageID (PK) |
varchar (20) |
not null |
Unique identifier of the language. |
|
LanguageName |
varchar (200) |
not null |
Name of the language. |
|
Delivery: full |
|||