Transcription
IBM InfoSphere Global Data SynchronizationforMaster Data Management Collaborative EditionSupport for 1WorldSync v7.1 on Supply SideNote: Before using this information and the product it supports, read the information in “Notices” at the endof this document.29 Jan, 2016 Copyright International Business Machines Corporations 2016. All rights reserved. LicensedMaterials-Property of IBMUS Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contractwith IBM Corp.
Revision P001Version#12Initial-Description of Changeimpact assessment documentRemoved release info for v1Updated supported version of1WorldSync XML to v7.1Correct typos in Appendix AAdded ‘maximumStackingWeight’in Appendix B as ‘Remove’ typeCopyright IBM Corp. 2005, 20151
Table of Contents1. Introduction .32. Overview of Upgrade Process .43. Scope .53.1 Product Enhancements / Fixes .64. Appendix A: Global Attribute Changes . 75. Appendix B: Target Market Attribute Changes .96. Appendix C: Extension Attribute Changes . 257. Appendix D: Valid Value Changes. 268. Appendix E: Validation Rule Changes . 349. Appendix F: Attribute Collections . 3710. Appendix G: Workflow Changes . 3711. Appendix H: Attribute Validation Mapping File . 3812. Appendix I: Related Documentation . 4013. Appendix Z: Terms and Acronyms . 4114. Notices . 42Copyright IBM Corp. 2005, 20152
1.IntroductionThis document provides details of the support for 1WorldSync v7.1 XML specifications,product enhancements, installation and other updated information for IBM InfoSphere Global Data Synchronization (GDS).This document provides comprehensive details of what you can expect in this release. Newfeatures and changes to existing features by Global Data Synchronization Network (GDSN)and 1WorldSync, described in their specifications, that do not impact or are not handled byIBM Global Data Synchronization, are not a part of this release. Moreover, any updates tothese specifications (documents and schema) made after the versions referenced in thisimpact assessment document, as mentioned in the related documents section (referAppendix I), are not handled in this release.This release is meant for Global Data Synchronization Supply side customers. Customersare advised to read through the sections appropriate to their business andimplementation.Note:1. Deprecated core and extension attributes as per 1WorldSync specifications arenot deleted in this release. The decision to remove these attribute from specs isleft to the implementation team.2. Obsolete valid values for attributes are not removed from the correspondinglookup tables. The decision to remove these valid values from lookup tables isleft to the implementation team.3. Valid values that have changed in keys are also not handled in the migrationprovided with this release. This needs to be taken care of by the implementationteam. Such valid values are called out specifically in this document.4. The migration scripts provided with the release do not handle deletion of specattributes and valid values5. The migration procedure providedoverwrites the validation scripts. Anyimplementation specific or custom validations would need to be added back tothe respective scripts post migration.6. Data migration is not provided as core attributes have moved to extensions;implementation may not need those extensions.Copyright IBM Corp. 2005, 20153
2.Overview of Upgrade ProcessThis upgrade is provided to comply with 1WorldSync v7.1 XML specifications that arebased on GDSN’s BMS v3.1 specifications (also named as Major Release 3 or Mjr3). Apatch is made available on InfoSphere MDM Collaborative Edition V11.5 (current latestrelease of IBM MDM offering) that has a migration path to upgrade the datamodel andsupport messaging choreography as per 1WorldSync v7.1 XML specifications. The detailsof changes available in this release are documented in the sections given below Pleaseread through the sections to assess the upgrade impact.Perform the following steps to upgrade are: Install InfoSphere MDM Collaborative Edition V11.5 General Availability release. Install InfoSphere MDM Collaborative Edition V11.5.0 Fix Pack 1. Run GDS related migration scripts to update the data model (core attributes, validvalues and validations). Refer release notes of v11.5.0-FP001 for detailed steps. Update implementation specifics, if any, such as attribute mappings and validationsand populate new valid values for obsolete ones. This part is not OOTB and needsto be handled by implementation teams.Copyright IBM Corp. 2005, 20154
3.ScopeGlobal Data Synchronization Supply side needs to be upgraded to handle 1WorldSync v7.1specifications. Prior versions of Global Data Synchronization are compliant with 1Sync v6.8specifications and hence a migration path is required to upgrade datamodel andmessaging choreography to be compliant with 1WorldSync v7.1 XML specifications.Highlights of changes to upgrade from 1Sync v6.8 to 1worldSync v7.1 XML specifications:1. Attributes: Over 300 new extension attributes have been added. None of these aremandatory but some of these are dependent. The existing core attributeshave been updated and many attributes have been removed(sunset/obsolete). The class structure of 14 attributes has been changed. The definition of 14 attributes has been changed. For example, the data typeand definitions such as length and occurrence have been changed.2. Valid values Over 630 new codes and 10 code lists have been updated and some codeshave been removed (sunset/ obsolete). Some of these new codes mightrequire data migration before you can use them.3. Validations Over 30 new validations have been added and some existing validations havebeen updated. Some validations have been removed (sunset/ obsolete).4. There are a few minor changes in the existing messaging choreography.5. A new publication type message “HIERARCHY WITHDRAWAL” has been added.To comply with the above changes in the specification, the following product relatedchanges have been identified and included in this patch upgrade:1. Global attribute changes (refer Appendix A)2. Target market core attribute changes (refer Appendix B)3. Extension Attribute Changes (refer Appendix C)4. Valid Value Changes (refer Appendix D)5. Validation Rule Changes (refer Appendix E)6. Attribute Collections (refer Appendix F)7. GDS Workflow Changes (refer Appendix G)8. Reference attribute validation mapping file (refer Appendix H)9. Support for new publication type message “HIERARCHY WITHDRAWALCopyright IBM Corp. 2005, 20155
3.1Product Enhancements / e GDS Supply side that currentlysupports 1Sync v6.8 XML specification to becompliant with 1WorldSync v7.1 XMLspecificationCopyright IBM Corp. 2005, 20156
4.Appendix A: Global Attribute ChangesThis section contains the details of the changes to handle updates to global core attributesper 1WorldSync v7.1 specifications and schemas, and the impact of the changes. Details ofthese changes are presented in the following table.The changes have been classified under the following types: New: Attributes that have been added or introduced in this releaseUpdate: Attributes whose definition has been modified. For example, definition suchas minlength, maxlength, and occurrence.Remove: Attributes that have been removed from the specifications.The GDS out-of-the-box [OOTB] datamodel contents such as specs, mapping, validations,and lookup tables that handle attribute value population during XML creation have alsobeen modified.Table 1: Global attributesATTRIBUTE PATHGlobal Attributes Spec/packagingTypeCORE/FLEXCoreType[New /Remove /Update]RemoveCHANGESDetailsRemoved from spec, mappingand validationGlobal Attributes Spec/packagingType/codeRemoved“Packaing Type LookUp” lookuptable and“Packaing Type Spec” Specfrom datamodelGlobal Attributes Spec/packagingType/weightRetained “Weight UOM LookUp”lookup, used for otherattributesMigrationRequired[Yes / No]NoGlobal Local AttributesSpec/packagingType/weight/uomGlobal Attributes Spec/packagingType/weight/valueGlobal Attributes gationGlobal Attributes Spec/packagingType/packagingFunctionRemoved “Packaging Function”lookup table from datamodelGlobal Attributes Spec/packagingType/usableProductVolumeCopyright IBM Corp. 2005, 20157
Global Attributes Spec/packagingType/usableProductVolume/uomRetained “Volume UOM LookUp”lookup table, used for otherattributesGlobal Attributes Spec/packagingType/usableProductVolume/valueGlobal Attributes ptionGlobal Attributes ption/languageCodeGlobal Attributes ption/textGlobal Attributes ntGlobal Attributes ginAgencyGlobal Attributes Spec/SpecialItemCodeGlobal Attributes Spec/GTINName/textGlobal Attributes Spec/tradeItemCompositionDepth/valueGlobal Attributes Spec/tradeItemCompositionWidth/valueWrong location, removed fromglobal attributes specCoreRemoveNoLengthRemoved from spec and mappingRemoved “Special Item Code”lookup table from datamodelMax Length 140CoreCoreLengthTotal digits 31YesCoreLengthTotal digits 31YesYesCopyright IBM Corp. 2005, 20158
5. AppendixChangesB:TargetMarketAttributeThis section contains the details of the changes to handle updates to target market coreattributes per 1WorldSync v7.1 specifications and schemas, and the impact of the changes.Details of these changes are presented in the following table:The changes have been classified under the following types: New: Attributes that have been added or introduced in this release.Update: Attributes whose definition has been modified. For example, minlength,maxlength, and occurrence.Remove: Attributes that have been removed from the specification.The GDS out-of-the-box [OOTB] datamodel contents such as specs, mapping, validations,and lookup tables that handle attribute value population during XML creation have alsobeen modified.Table 2: Target market attributesATTRIBUTE PATHGlobal Local AttributesSpec/productDescription/textGlobal Local AttributesSpec/additionalDescription/textGlobal Local AttributesSpec/SubBrandCORE/FLEXCoreType[New /Remove /Update]UpdateCoreUpdateCoreUpdateGlobal Local AttributesSpec/color/codeGlobal Local AttributesSpec/color/description/textGlobal Local eCoreUpdateGlobal Local AttributesSpec/productSize/codeGlobal Local bal Local ateCoreUpdateCoreUpdateCHANGEDetailsUpdated spec attribute.Maxlength change from 178 to200.Updated spec attribute.Maxlength change from 350 to500.Updated spec attribute andmapping.1. Move from complex[language associated] tosimple [text] type.2. Move from Grouping tosingle node.3. Correct Maxlength from3000 to 70.Updated spec attribute.Maxlength change from 20 to 80.Updated spec attribute.Maxlength change from 70 to 80.MigrationRequired[Yes /No]YesYesYesExistingSubBrandnode isrenamedtoSubBrandOldYesYesUpdated spec attribute.Maxlength change from 3 to 35.Removed Regular ExpressionUpdated spec attribute.Maxlength change from 50 to 80.Updated spec attribute.Maxlength change from 35 to 80.YesUpdated spec attribute.Maxlength change from 70 to 250.YesYesYesCopyright IBM Corp. 2005, 20159
Global Local obal Local l Local AttributesSpec/alternateClassification/codeGlobal Local AttributesSpec/replacedItemGTINRemoved from spec, mapping andvalidationNoRemoved“Alternate Item Classification Scheme Code Lookup” lookup tablefrom datamodelCoreRemoveRemoved from spec, mapping andvalidationNoGlobal Local AttributesSpec/replacementItemGTINGlobal Local AttributesSpec/barCodeTypeCoreRemoveRemoved from spec, mapping andvalidationNoCoreRemoveNoGlobal Local AttributesSpec/EANUCCCoreRemoveRemoved from spec and mappingRemoved “Bar Code Lookup” lookuptable and “Bar code Spec” Specfrom datamodelRemoved from spec, mapping andvalidationNoGlobal Local lobal Local AttributesSpec/EANUCC/EANUCCTypeGlobal Local AttributesSpec/EANUCC/EANUCCCodeRemoved “EANUCC Type Lookup”lookup table from datamodel.Was used by“invoiceInfoUOMForInvoiceQuantities” in French Extension. Thisattribute is also obsoleteRemoved from spec and mappingGlobal Local AttributesSpec/groupCodeCoreRemoveNoGlobal Local AttributesSpec/groupDescriptionCoreRemoveRemoved from spec, mapping andvalidationNoCoreRemoveRemoved from spec, mapping andvalidationNoGlobal Local AttributesSpec/groupDescription/languageCodeGlobal Local AttributesSpec/groupDescription/textGlobal Local AttributesSpec/manufacturerGlobal Local AttributesSpec/manufacturer/glnGlobal Local AttributesSpec/manufacturer/nameGlobal Local tificationGLNCopyright IBM Corp. 2005, 201510
Global Local AttributesSpec/contactGLNCoreRemoveRemoved from spec and mappingNoGlobal Local AttributesSpec/materialSafetyDataSheetNumberGlobal Local AttributesSpec/organicCoreRemoveRemoved from spec and mappingNoCoreRemoveRemoved from spec, mapping andvalidationNoGlobal Local c ClaimAgency Code Lookup” lookup table and“Organic ClaimAgency Code Spec”Spec from datamodelRemoved“Organic TradeItem Code Lookup”lookup table and“Organic TradeItem Code Spec”Spec from datamodelGlobal Local AttributesSpec/organic/tradeItemCodeGlobal Local al Local moved from spec and mappingNoCoreRemoveNoGlobal Local AttributesSpec/packageMarksEthicalCoreRemoveGlobal Local reRemoveGlobal Local AttributesSpec/packagingMaterialCoreRemoveRemoved from spec and mappingRemoved“Package Mark Types Lookup”lookuptableand“Package Mark Types Spec”Specfrom datamodelRemoved from spec and mappingRemoved“Package Marks Ethical Lookup”lookup table and“Package Marks Ethical Spec”Spec from datamodelRemoved from spec and mappingRemoved“Package Marked Expiration DateType Code Lookup” lookup tablefrom datamodelRemoved from spec, mapping andvalidationGlobal Local ackaging Material Agency LookUp” lookup table from datamodelGlobal Local kaging Material Code AgencyLookup” lookup table and“Packaging Material Code AgencySpec” spec from datamodelGlobal Local AttributesSpec/packagingMaterial/compositionGlobal Local NoNoRemoved“Material Composition UOM LookUp” lookup table from datamodelGlobal Local AttributesSpec/packagingMaterialCopyright IBM Corp. 2005, 201511
/composition/valueGlobal Local Removed“PackagingMaterial Terms And Conditions Code Lookup” lookuptable from datamodelGlobal Local tiveDateGlobal Local teGlobal Local DepositCodeGlobal Local DepositAmountGlobal Local DepositAmount/currencyRetained “Currency LookUp”lookup table, used for otherattributesGlobal Local DepositAmount/valueGlobal Local DepositRegionGlobal Local yRetained “Target Market LookUp”lookup table, used for otherattributesGlobal Local Global Local DepositCodeOriginAgencyGlobal Local avelledToPointOfPkgRemoved“Average Distance Travelled To Point Of Packaging Code” lookuptable from datamodelGlobal Local AttributesCopyright IBM Corp. 2005, 201512
TimeGlobal Local PerformanceCodeRemoved“Packaging Material PerformanceCode” lookup table fromdatamodelGlobal Local ligationNameGlobal Local ligationNameGlobal Local pacityContentGlobal Local pacityContent/uomRetained“Size Metric UOM LookUp” lookuptable, used for other attributesGlobal Local pacityContent/valueGlobal Local ontainedQuantityRetained“Size Metric UOM LookUp” lookuptable, used for other attributesGlobal Local ontainedQuantity/uomGlobal Local ontainedQuantity/valueGlobal Local oveRemoved from spec, mapping andvalidationNoCoreRemoveRemoved from spec and mappingRetained “Target Market LookUp”lookup table, used for otherNoGlobal Local cipientGLNGlobal Local lobal Local AttributesSpec/countryOfOriginCopyright IBM Corp. 2005, 201513
attributesGlobal Local AttributesSpec/firstArrivalDateCoreRemoveRemoved from spec, mapping andvalidationNoGlobal Local AttributesSpec/lastArrivalDateCoreRemoveRemoved from spec, mapping andvalidationNoGlobal Local Global Local AttributesSpec/stackingFactorCoreRemoveRemoved from spec and mappingRemoved“Product Handling LookUp” lookuptable from datamodelRemoved from spec and mappingGlobal Local AttributesSpec/DangerousGoodsIndicatorGlobal Local AttributesSpec/hazardousMaterialCoreRemoveRemoved from spec and mappingNoCoreRemoveRemoved from spec, mapping andvalidationNoGlobal Local ulationCodeNoRemoved “Hazardous Type LookUp”lookup table and“Hazardous Type Spec” Spec fromdatamodelGlobal Local tureGlobal Local ture/uomRemoved “Temperature UOM LookUp”lookup table from datamodelGlobal Local ture/valueGlobal Local bal Local assCodeRemoved“Hazmat Class Code LookUp”lookup table from datamodelGlobal Local arginNumberGlobal Local zardousCodeRemoved“Hazard Code LookUp”lookup table from datamodelGlobal Local AttributesCopyright IBM Corp. 2005, 201514
Global Local ippingNameGlobal Local ippingName/languageCodeRetained“Languages Lookup”lookup table, used for otherattributesGlobal Local ippingName/textGlobal Local DangerousGoodsNumberGlobal Local chnicalNameGlobal Local chnicalName/languageCodeRetained“Languages Lookup”lookup table, used for otherattributesGlobal Local chnicalName/textGlobal Local ecialInstructionsGlobal Local ecialInstructions/languageCodeRetained“Languages Lookup”lookup table, used for otherattributesGlobal Local ecialInstructions/textGlobal Local tExplosiveMassGlobal Local tExplRetained“Weight UOM LookUp”lookup table, used for otherattributesCopyright IBM Corp. 2005, 201515
osiveMass/uomGlobal Local tExplosiveMass/valueGlobal Local ngerousGoodsClassificationCodeGlobal Local AdditionalInformationGlobal Local ages Lookup”lookup table, used for otherattributesGlobal Local AdditionalInformation/textGlobal Local ionCodeGlobal Local LimitedQuantitiesCodeGlobal Local ulationAgencyGlobal Local AttributesSpec/enericIngredientGlobal Local Removed from spec and mappingNoCoreRemoveRemoved from spec, mapping andvalidationNoGlobal Local AttributesSpec/genericIngredientStrength/uomGlobal Local al Local AttributesSpec/productStrengthRetained“Weight UOM LookUp”lookup table, used for otherattributesCoreRemoveRemoved from spec, mapping andvalidationNoGlobal Local AttributesCopyright IBM Corp. 2005, 201516
Spec/productStrength/uomGlobal Local AttributesSpec/productStrength/valueGlobal Local e UOM LookUp”lookup table, used for otherattributesCoreRemoveGlobal Local AttributesSpec/productStrengthBasis/uomGlobal Local AttributesSpec/productStrengthBasis/valueGlobal Local AttributesSpec/leadTimeRemoved from spec, mapping andvalidationNoRetained“Price UOM LookUp”lookup table, used for otherattributesCoreRemoveRemoved from spec, mapping andvalidationNoGlobal Local �MinimumProductLifeSpan LookUp”lookup table, used for otherattributesGlobal Local AttributesSpec/leadTime/uomGlobal Local AttributesSpec/leadTime/valueGlobal Local AttributesSpec/palletCodeCoreGlobal Local AttributesSpec/palletTermsAndConditionsCoreGlobal Local oved from spec and mappingNoRemoveRemoved“Pallet Type Codes LookUp”lookup table from datamodelRemoved from spec and mappingNoRemoveGlobal Local l Local AttributesSpec/retailPriceOnTradeItem/valueGlobal Local AttributesSpec/taxAmountRemoved“Pallet Terms And Conditions Code Lookup”lookuptablefromdatamodelRemoved from spec, mapping andvalidationNoRetained“Currency LookUp”lookup table, used for otherattributesCoreRemoveRemoved from spec, mapping andvalidationNoGlobal Local AttributesSpec/taxAmount/amountValueGlobal Local cy LookUp”lookup table, used for otherattributesCopyright IBM Corp. 2005, 201517
Global Local AttributesSpec/taxAmount/agencyCodeGlobal Local AttributesSpec/taxAmount/typeCodeGlobal Local AttributesSpec/taxAmount/typeDescriptionGlobal Local eGlobal Local AttributesSpec/taxRateCoreRemoveRemoved“Tax Applicability Codes LookUp”lookup table from datamodelRemoved from spec, mapping andvalidationNoGlobal Local AttributesSpec/taxRate/rateGlobal Local AttributesSpec/taxRate/agencyCodeGlobal Local AttributesSpec/taxRate/typeCodeGlobal Local AttributesSpec/taxRate/typeDescriptionGlobal Local bal Local emoveRemoved“Tax Applicability Codes LookUp”lookup table from datamodelRemoved from spec, mapping andvalidationNoGlobal Local RecipientGLNGlobal Local lobal Local eGlobal Local ed “Temperature UOM LookUp”lookup table from datamodeCoreRemoveRemoved from spec, mapping andvalidationNoGlobal Local RecipientGLNGlobal Local emoved “Temperature UOM LookUp”lookup table from datamodeCopyright IBM Corp. 2005, 201518
Global Local eGlobal Local oreRemoveRemoved from spec, mapping andvalidationNoGlobal Local ataRecipientGLNGlobal Local uomGlobal Local valueGlobal Local emoved “Temperature UOM LookUp”lookup table from datamodeCoreRemoveRemoved from spec, mapping andvalidationNoGlobal Local dataRecipientGLNGlobal Local uomGlobal Local valueGlobal Local AttributesSpec/storageHandlingTempMaxRemoved “Temperature UOM LookUp”lookup table from datamodeCoreRemoveGlobal Local AttributesSpec/storageHandlingTempMax/uomGlobal Local AttributesSpec/storageHandlingTempMax/valueGlobal Local AttributesSpec/storageHandlingTempMinGlobal Local AttributesNoRemoved “Temperature UOM LookUp”lookup table from datamodeCoreRemoveGlobal Local AttributesSpec/storageHandlingTempMin/uomGlobal Local AttributesSpec/storageHandlingTempMin/valueGlobal Local ed from spec, mapping andvalidationRemoved from spec, mapping andvalidationNoRemoved “Temperature UOM LookUp”lookup table from datamodeCoreRemoveRemoved from spec, mapping andvalidationNoRemovedCopyright IBM Corp. 2005, 201519
Spec/storageHandlingHumidityMaximum/uomGlobal Local eGlobal Local orage Handling Humidity UOM Lookup”lookuptablefromdatamodelCoreRemoveGlobal Local lobal Local eGlobal Local Global Local eGlobal Local AttributesSpec/campaignEndDateCoreGlobal Local AttributesSpec/campaignNameCoreNoRemoveRemoved from spec and mappingRemoved“Class Compliance Regulation Code Lookup”lookuptablefromdatamodelRemoved from spec and mappingRetained “Target Market LookUp”lookup table, used for otherattributesRemoved from spec and mappingRemoveRemoved from spec and mappingNoGlobal Local AttributesSpec/campaignName/languageCodeGlobal Local AttributesSpec/materialCompositionGlobal Local odeNoRemoved“Storage Handling Humidity UOM Lookup”lookuptablefromdatamodelCoreGlobal Local AttributesSpec/campaignName/textGlobal Local AttributesSpec/campaignStartDateRemoved from spec, mapping andvalidationNoNoRetained“Languages Lookup”lookup table, used for otherattributesCoreRemoveRemoved from spec and mappingNoCoreRemoveRemoved from spec, mapping andvalidationNoRemoved“Material Agency Code Lookup”lookup table from datamodelGlobal Local Global Local /languageCodeRetained“Languages Lookup”lookup table, used for otherattributesGlobal Local /textCopyright IBM Corp. 2005, 201520
Global Local ageGlobal Local bal Local Attribut
IBM InfoSphere Global Data Synchronization for Master Data Management Collaborative Edition Support for 1WorldSync v7.1 on Supply Side Note: Before using this information and the product it supports, read the information in "Notices" at the end of this document. 29 Jan, 2016
