1WorldSync Attribute Mapping
The following table lists how attributes in 1WorldSync map to attributes in MDM.
1WorldSync Attribute |
MDM Data Type |
Sync Profile Attribute |
Repository Attribute |
Xpath in 1WorldSync message |
---|---|---|---|---|
Global Trade Item Number |
String |
|
|
|
Information Provider |
String |
|
|
|
Effective Date |
Date |
|
|
|
GTIN Name |
String |
|
|
|
NA |
String |
|
|
|
Product Type |
String |
|
|
|
Brand Name |
String |
|
|
|
Brand Owner GLN |
String |
|
|
|
Net Content |
Decimal |
|
|
|
Net Content UOM |
String |
|
|
|
Alternate Item Classification Code |
String |
|
|
|
Packaging Type |
String |
|
|
|
Qty of Next Level Item(s) |
String |
|
|
|
Packaging Information Height |
Float |
PACKAGING_HEIGHT |
PACKAGING_HEIGHT |
|
Packaging Information Height UOM |
Varchar |
PACKAGING_HEIGHT_UOM |
PACKAGING_HEIGHT_UOM |
|
Packaging Information Depth |
Float |
PACKAGING_DEPTH |
PACKAGING_DEPTH |
|
Packaging Information Depth UOM |
Varchar |
PACKAGING_DEPTH_UOM |
PACKAGING_DEPTH_UOM |
|
Packaging Information Width |
Float |
PACKAGING_WIDTH |
PACKAGING_WIDTH |
|
Packaging Information Width UOM |
Varchar |
PACKAGING_WIDTH_UOM |
PACKAGING_WIDTH_UOM |
|
Inner Pack |
String |
|
|
|
Product Form |
String |
|
|
|
Base Unit Indicator |
Boolean |
|
|
|
Consumer Unit Indicator |
Boolean |
|
|
|
Variable Weight Trade Item |
Boolean |
|
|
|
Num of Complete Layers Cont in Item/GTIN Pallet Hi |
Integer |
|
|
|
Num of Items in a Complete Layer/GTIN Pallet Ti |
Integer |
|
|
|
Storage/Handling Temp Max |
Decimal |
|
|
|
Storage/Handling Temp UOM |
String |
|
|
|
Storage/Handling Temp Min |
Decimal |
|
|
|
Storage/Handling Temp UOM |
String |
|
|
|
Own Label/Private Label |
Boolean |
|
|
|
Number of Items/Pallet |
Integer |
|
|
|
Target Market |
String |
|
|
|
Target Market Description |
String |
|
|
|
NA |
String |
|
|
|
EANUCC Code |
String |
|
|
|
EANUCC Type |
String |
|
|
|
Manufacturer GLN |
String |
|
|
|
Sub Brand |
String |
|
|
|
Functional Name |
String |
|
|
|
Variant |
String |
|
|
|
Country of Origin |
String |
|
|
|
Is Private |
Boolean |
|
|
|
Primary Delivery Method |
String |
|
|
|
Coupon Family Code |
Integer |
|
|
|
Has Batch Number |
Boolean |
|
|
|
Net Content Declared |
Boolean |
|
|
|
Product Strength |
Decimal |
|
|
|
Product Strength UOM |
String |
|
|
|
Product Strength Basis |
Decimal |
|
|
|
Product Strength Basis UOM |
String |
|
|
|
Product Size Code |
String |
|
|
|
Product Size Code Maintenance Agency |
String |
|
|
|
Product Description |
String |
|
|
|
Product Color Description |
String |
|
|
|
Min Product Lifespan from Arrival |
Integer |
|
|
|
Additional Description |
String |
|
|
|
Order Sizing Factor |
String |
|
|
|
Lead Time |
Integer |
|
|
|
Order Quantity Multiple |
Integer |
|
|
|
Min Order Quantity |
Integer |
|
|
|
Max Order Quantity |
Integer |
|
|
|
Start Availability Date |
Date |
|
|
|
End Availability Date |
Date |
|
|
|
First Ship Date |
Date |
|
|
|
Last Ship Date |
Date |
|
|
|
Height |
Decimal |
|
|
|
Height UOM |
String |
|
|
|
Width |
Decimal |
|
|
|
Width UOM |
String |
|
|
|
Depth |
Decimal |
|
|
|
Depth UOM |
String |
|
|
|
Non GTIN Pallet Height |
Decimal |
|
|
|
Non GTIN Pallet Height UOM |
String |
|
|
|
Diameter |
Decimal |
|
|
|
Diameter UOM |
String |
|
|
|
Drained Weight |
Decimal |
|
|
|
Drained Weight UOM |
String |
|
|
|
Gross Weight |
Decimal |
|
|
|
Gross Weight UOM |
String |
|
|
|
Non GTIN Pallet Gross Weight |
Decimal |
|
|
|
Non GTIN Pallet Gross Weight UOM |
String |
|
|
|
Net Weight |
Decimal |
|
|
|
Net Weight UOM |
String |
|
|
|
Packaging Material Composition |
String |
|
|
|
Packaging Material Composition UOM |
String |
|
|
|
Peg Horizontal |
Decimal |
|
|
|
Peg Horizontal UOM |
String |
|
|
|
Peg Vertical |
Decimal |
|
|
|
Peg Vertical UOM |
String |
|
|
|
Volume |
Decimal |
|
|
|
Volume UOM |
String |
|
|
|
Percentage of Alcohol per Volume |
Decimal |
|
|
|
Packaging Material Code |
String |
|
|
|
Product Marked with Ingredients |
Boolean |
|
|
|
Product Marked Recyclable |
Boolean |
|
|
|
Packaging Marked Returnable |
Boolean |
|
|
|
Dispatch Unit Indicator |
Boolean |
|
|
|
Invoice Unit Indicator |
Boolean |
|
|
|
Ordering Unit Indicator |
Boolean |
|
|
|
Handling Instruction Code |
String |
|
|
|
Max Stacking Weight |
Decimal |
|
|
|
Max Stacking Weight UOM |
String |
|
|
|
Stacking Factor |
Integer |
|
|
|
Pallet Code |
String |
|
|
|
Pallet Terms and Conditions |
String |
|
|
|
Dangerous Goods Hazardous Code |
String |
|
|
|
Dangerous Goods Class Code |
String |
|
|
|
Dangerous Goods Regulation Code |
String |
|
|
|
U.N. Dangerous Goods Number |
String |
|
|
|
Dangerous Goods Packing Group |
String |
|
|
|
Dangerous Goods Shipping Name |
String |
|
|
|
Dangerous Goods Technical Name |
String |
|
|
|
Flash Point Temperature |
Decimal |
|
|
|
Flash Point Temperature UOM |
String |
|
|
|
Hazmat Special Instructions |
String |
|
|
|
Trade Item Group Code |
String |
|
|
|
Trade Item Group Description |
String |
|
|
|
Pricing On Product |
Boolean |
|
|
|
Material Safety Data Sheet Number |
String |
|
|
|
Number of Layers Per Pallet/Non GTIN Pallet Hi |
Integer |
|
|
|
Number of Trade Items Per Pallet Layer/Non GTIN Pallet Ti |
Integer |
|
|
|
Alternate Item Classification Scheme |
String |
|
|
|
Color |
String |
|
|
|
Color Code Maintenance Agency |
String |
|
|
|
List Price |
Decimal |
|
|
|
List Price Currency |
String |
|
|
|
List Price Basis Per Unit |
Decimal |
|
|
|
List Price Basis Per Unit UOM |
String |
|
|
|
Suggested Retail Price |
Amount |
|
|
|
Suggested Retail Price Currency |
String |
|
|
|
Suggested Retail Price Basis Per Unit |
Decimal |
|
|
|
Suggested Retail Price Basis Per Unit UOM |
String |
|
|
|
Right of Return for Non-Sold Trade Item |
Boolean |
|
|
|
Tax Rate |
Decimal |
|
|
|
Tax (Rate) Type Code |
String |
|
|
|
Alternate Item Number |
String |
|
|
|
Alternate Item Identification Maintenance Agency |
String |
|
|
|
Replaced by GTIN |
String |
|
|
|
Organic Trade Item Code |
String |
|
|
|
Degree of Original Wort |
String |
|
|
|
Fat Content UOM |
String |
|
|
|
Fat Content Basis of Measure UOM |
String |
|
|
|
Units Per Consumer Unit |
Integer |
|
|
|
Total Units per Case |
Integer |
|
|
|
Pricing Item Indicator |
Boolean |
|
|
|
NA |
Date |
|
|
|
First Order Date |
Date |
|
|
|
Last Order Date |
Date |
|
|
|
Global Classification Code |
String |
|
|
|
Pricing Pack |
Decimal |
|
|
|
List Price Effective Start Date |
Date |
|
|
|
List Price Effective End Date |
Date |
|
|
|
Special Item Code |
String |
|
|
|
Feature Benefit |
String |
|
|
|
Is Raw Material Irradiated |
String |
|
|
|
Is Ingredient Irradiated |
String |
|
|
|
Peg Hole Number |
Integer |
|
|
|
Barcode Type |
String |
|
|
|
Country of Assembly |
String |
|
|
|
Variable Trade Item Type |
String |
|
|
|
Campaign End Date |
Date |
|
|
|
Campaign Name |
String |
|
|
|
Campaign Start Date |
Date |
|
|
|
Marketing Message |
String |
|
|
|
Season Calendar Year |
Integer |
|
|
|
Season Name |
String |
|
|
|
Season Parameter |
String |
|
|
|
Seasonal Start Date |
Date |
|
|
|
Seasonal End Date |
Date |
|
|
|
Target Consumer Age |
String |
|
|
|
Target Consumer Gender |
String |
|
|
|
Feature Benefit |
String |
|
|
|
Compliance Regulation Code |
String |
|
|
|
Import Classification Type |
String |
|
|
|
Import Classification Value |
String |
|
|
|
Max DC Delivery Temp |
Decimal |
|
|
|
Max DC Delivery Temp UOM |
String |
|
|
|
Max Market Delivery Temp |
Decimal |
|
|
|
Max Market Delivery Temp UOM |
String |
|
|
|
Max Storage Humidity |
Decimal |
|
|
|
Min DC Delivery Temp |
Decimal |
|
|
|
Min Market Delivery Temp |
Decimal |
|
|
|
Min Storage Humidity |
Decimal |
|
|
|
Product Range |
String |
|
|
|
Inner Pack |
String |
|
|
|
Composition Width |
Decimal |
|
|
|
Composition Width UOM |
String |
|
|
|
Descriptive Size Dim |
String |
|
|
|
Material Code |
String |
|
|
|
Material Content |
String |
|
|
|
Material Percentage |
Decimal |
|
|
|
Material Weight |
Integer |
|
|
|
Material Weight UOM |
String |
|
|
|
Organic Claim Agency |
String |
|
|
|
Size Dimension |
Decimal |
|
|
|
Size Dimension UOM |
String |
|
|
|
Size Group |
String |
|
|
|
Size System |
String |
|
|
|
Size Type |
String |
|
|
|
Thread Count |
String |
|
|
|
Consumer Availability Date |
Date |
|
|
|
End Date of Exclusivity |
Date |
|
|
|
End Date of Max Buying Qty |
Date |
|
|
|
End Date of Min Buying Qty |
Date |
|
|
|
First Delivery Date |
Date |
|
|
|
Start Date of Max Buying Qty |
Date |
|
|
|
Start Date of Min Buying Qty |
Date |
|
|
|
Deposit Value End Date |
Date |
|
|
|
Deposit Value Start Date |
Date |
|
|
|
Offer On Pack |
String |
|
|
|
Package Marks Diet Allergen |
String |
|
|
|
Package Marks Environment |
String |
|
|
|
Package Marks Ethical |
String |
|
|
|
Package Marks Free From |
String |
|
|
|
Packaging Marked Expiration Date Type |
String |
|
|
|
Packaging Marked Recyclable Scheme |
String |
|
|
|
Returnable Package Deposit Amount |
Amount |
|
|
|
Returnable Package Deposit Code |
String |
|
|
|
Security Tag Location |
String |
|
|
|
Security Tag Type |
String |
|
|
|
Terms or Conditions Code |
Varchar |
|
|
|
Generic Ingredient |
String |
|
|
|
Generic Ingredient Strength |
String |
|
|
|
Generic Ingredient Strength UOM |
String |
|
|
|
Goods Pick Up Lead Time |
Decimal |
|
|
|
Goods Pick Up Lead Time UOM |
String |
|
|
|
Invoice Name |
String |
|
|
|
Is Size Based Pricing |
Boolean |
|
|
|
Is Trade Item Reorderable |
Boolean |
|
|
|
Ordering UOM |
String |
|
|
|
Selling UOM |
String |
|
|
|
Max Buying Quantity |
Integer |
|
|
|
Min Buying Quantity |
Integer |
|
|
|
Price By Measure Type |
String |
|
|
|
Price Comparison Measurement |
Decimal |
|
|
|
Price Comparison Measurement UOM |
String |
|
|
|
Retail Price On Trade Item |
Amount |
|
|
|
Price Comparison Content Type |
String |
|
|
|
Suggested Retail Price Effective End Date |
Date |
|
|
|
Suggested Retail Price Effective Start Date |
Date |
|
|
|
Tax Amount |
Amount |
|
|
|
Tax Amount Currency |
String |
|
|
|
Tax (Rate) Type Agency |
String |
|
|
|
Tax (Rate) Type Description |
String |
|
|
|
Finish Description |
String |
|
|
|
Min Product Lifespan from Production |
String |
|
|
|
Retail Price On Trade Item Currency |
String |
|
|
|
Returnable Package Deposit Currency |
String |
|
|
|
Tax (Amount) Type Description |
String |
|
|
|
Tax (Amount) Type Agency |
String |
|
|
|
Tax (Amount) Type Code |
String |
|
|
|
Material Agency Code |
String |
|
|
|
Is Barcode Symbology Derivable |
Boolean |
|
|
|
Lead Time UOM |
String |
|
|
|
TM Subdivision |
String |
|
|
|
Party Receiving Private Data |
String |
|
|
|
GTIN Variation Registry |
Boolean |
|
|
|
Manufacturer Name |
String |
|
|
|
Green Dot Indicator |
Boolean |
|
|
|
Order Sizing Factor UOM |
String |
|
|
|
GLN Of Ship From Party |
String |
|
|
|
Name Of Ship From Party |
String |
|
|
|
Uniform Resource Identifier |
String |
|
|
|
Link File Name |
String |
|
|
|
File Format Name |
String |
|
|
|
File Effective Start Date |
Date |
|
|
|
File Effective End Date |
Date |
|
|
|
Link Content Description |
String |
|
|
|
File Format Description |
String |
|
|
|
Consumer Usage Storage Instructions |
String |
|
|
|
Layer Height |
Decimal |
|
|
|
Layer Height UOM |
String |
|
|
|
Type Of Information |
String |
|
|
|
Is Trade Item Packed Irregularly? |
String |
|
|
|
Item Composition Depth |
Decimal |
|
|
|
Item Composition Depth UOM |
Varchar |
ITEM_COMPOSITION_DEPTH_UOM |
ITEM_COMPOSITION_DEPTH_UOM |
|
Package Marks Hygienic |
String |
|
|
|
Tax Rate Applicability Code |
String |
|
|
|
Tax Amount Applicability Code |
String |
|
|
|
Clamp Pressure |
Decimal |
|
|
|
Clamp Pressure UOM |
String |
|
|
|
Orientation Type |
String |
|
|
|
Orientation Preference Sequence |
Integer |
|
|
|
Nesting Direction |
String |
|
|
|
Nesting Type |
String |
|
|
|
Has Display Ready Packaging? |
String |
|
|
|
Electrical Usage Trade Item Classification Agency |
String |
|
|
|
Electrical Usage Trade Item Classification Name |
String |
|
|
|
Electrical Usage Subclassification Name |
String |
|
|
|
Display Dimension Type Code |
String |
|
|
|
Dimension Depth |
Integer |
|
|
|
Dimension Depth UOM |
String |
|
|
|
Dimension Width |
Integer |
|
|
|
Dimension Width UOM |
String |
|
|
|
Dimension Height |
Integer |
|
|
|
Dimension Height UOM |
String |
|
|
|
Warranty Effective Date Type |
String |
|
|
|
Warranty Type |
String |
|
|
|
Warranty Constraint |
String |
|
|
|
Warranty Period |
Integer |
|
|
|
Warranty Information Description |
String |
|
|
|
Is Product A Pesticide? |
String |
|
|
|
Is Product Aerosol? |
String |
|
|
|
Is Product Chemical Not Intended For Human Consumption? |
String |
|
|
|
Percentage Of Plastic Components Made From a Plant Based Material |
Integer |
|
|
|
Is Product Subject To A Manufacturer Take Back Program? |
String |
|
|
|
Manufacturer Take Back Program Fee |
Integer |
|
|
|
Packaging Marked Recyclable Scheme |
String |
|
|
|
Trade Item Default Time Limit Of Auto Power Down Function Value |
Date |
|
|
|
Trade Item Default Time Limit Of Auto Power Down Function UOM |
String |
|
|
|
Electrical Usage Agency Code |
String |
|
|
|
Is Trade Item Auto Powered Down Enabled When Shipped To Customer |
String |
|
|
|
Electrical Usage Class Code |
String |
|
|
|
Electrical Usage Sub Class Code |
String |
|
|
|
Maximum Energy Usage Time Period |
Decimal |
|
|
|
Maximum Energy Usage Time Period UOM |
String |
|
|
|
Electrical Usage Class Screen Area Value |
String |
|
|
|
Electrical Usage Class Screen Area UOM |
String |
|
|
|
Electrical Usage Class Resolution Code |
String |
|
|
|
Electrical Usage Class Mode Code |
String |
|
|
|
Manufacturer Take Back Program Currency |
String |
|
|
|
Warranty Condition Effective Date Type |
String |
|
|
|
Warranty Period UOM |
String |
|
|
|
Country of Last Provenance/Processing |
String |
|
|
|
Trade Channel |
String |
|
|
|
Is Hazardous Component Broken Down Easily For Recycling |
String |
|
|
|
Percent Of Product Components Labeled For Disassembly And Recycling |
Decimal |
|
|
|
Is Product Disassembly By Recycling Facility Completed Using Standard Tools |
String |
|
|
|
Is Product RPPC Compliant in Target Market |
String |
|
|
|
Product RoHS Compliance Code |
String |
|
|
|
Is Product Considered Universal Waste? |
String |
|
|
|
Can Product Be Easily Upgraded Or Maintained By Consumer |
String |
|
|
|
Materials That Fail RoHS Compliance |
String |
|
|
|
Link File Name |
String |
|
|
|