Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

xml import (Global Data Syncronization)

Status
Not open for further replies.
GShen

GShen

MIS
Sep 26, 2002
561
US
Hi,
Just familiar with flat file to SQL DB and visa versa. Never did this for xml. Is there anyone out familiar with Global Data Sync ? It seems I can get file in xml format. I have a sample. Is there a way of importing into my sql database ? Do I need more info. from the provider ? They have packages which do this at a cost which gives you a bunch of bells and whistles which I do not need. I just want to import the file into a sql table. I can then write the code to what I want with it after that. I would need to somehow export a file also. Do I need more info. from them? Excel 2007 opens the file fine. I tried the wizard to no avail. I tried creating a new SSIS from scratch and I am running in circles, not sure what format I should call the input file. It is looking for an XSD, etc., etc. Am I wasting my time ? Is this feasible or they not giving me all the info. I need in order to get this to work.

Here is the sample the sent me.

<?xml version="1.0" encoding="UTF-8" ?>
- <sh:StandardBusinessDocument xmlns:sh=" xmlns:eanucc="urn:ean.ucc:2" xmlns:gdsn="urn:ean.ucc:gdsn:2" xmlns:xsi=" xsi:schemaLocation=" urn:ean.ucc:2 - <sh:StandardBusinessDocumentHeader>
<sh:HeaderVersion>2.2</sh:HeaderVersion>
- <sh:Sender>
<sh:Identifier Authority="EAN.UCC">0821620500004</sh:Identifier>
</sh:Sender>
- <sh:Receiver>
<sh:Identifier Authority="EAN.UCC">7216201001927</sh:Identifier>
</sh:Receiver>
- <sh:DocumentIdentification>
<sh:Standard>EAN.UCC</sh:Standard>
<sh:TypeVersion>2.1</sh:TypeVersion>
<sh:InstanceIdentifier>14360008640224100254</sh:InstanceIdentifier>
<sh:Type>catalogueItemNotification</sh:Type>
<sh:CreationDateAndTime>2006-12-27T13:16:20-05:00</sh:CreationDateAndTime>
</sh:DocumentIdentification>
</sh:StandardBusinessDocumentHeader>
- <eanucc:message>
- <entityIdentification>
<uniqueCreatorIdentification>03843063481886408648</uniqueCreatorIdentification>
- <contentOwner>
<gln>0821620500004</gln>
</contentOwner>
</entityIdentification>
- <eanucc:transaction>
- <entityIdentification>
<uniqueCreatorIdentification>14360008641514325292</uniqueCreatorIdentification>
- <contentOwner>
<gln>0821620000672</gln>
</contentOwner>
</entityIdentification>
- <command>
- <eanucc:documentCommand>
- <documentCommandHeader type="ADD">
- <entityIdentification>
<uniqueCreatorIdentification>14360008641514325292</uniqueCreatorIdentification>
- <contentOwner>
<gln>0821620000672</gln>
</contentOwner>
</entityIdentification>
</documentCommandHeader>
- <documentCommandOperand>
- <gdsn:catalogueItemNotification documentStatus="ORIGINAL" isReload="false" lastUpdateDate="2006-12-27" creationDateTime="2006-12-27T13:16:18-05:00" xsi:schemaLocation="urn:ean.ucc:2 - <contentVersion>
<versionIdentification>2.1</versionIdentification>
</contentVersion>
- <documentStructureVersion>
<versionIdentification>2.1</versionIdentification>
</documentStructureVersion>
- <catalogueItem>
<catalogueItemState state="REGISTERED" />
- <tradeItem xmlns:xsi=" <tradeItemUnitDescriptor>PALLET</tradeItemUnitDescriptor>
- <tradeItemIdentification>
<gtin>20821620007255</gtin>
</tradeItemIdentification>
- <nextLowerLevelTradeItemInformation>
<quantityOfChildren>1</quantityOfChildren>
<totalQuantityOfNextLowerLevelTradeItem>10</totalQuantityOfNextLowerLevelTradeItem>
- <childTradeItem>
<quantityofNextLowerLevelTradeItem>10</quantityofNextLowerLevelTradeItem>
- <tradeItemIdentification>
<gtin>10821620007258</gtin>
</tradeItemIdentification>
</childTradeItem>
</nextLowerLevelTradeItemInformation>
- <tradeItemInformation>
- <informationProviderOfTradeItem>
- <informationProvider>
<gln>0821620000672</gln>
- <additionalPartyIdentification>
<additionalPartyIdentificationValue>Party Id</additionalPartyIdentificationValue>
<additionalPartyIdentificationType>BUYER_ASSIGNED_IDENTIFIER_FOR_A_PARTY</additionalPartyIdentificationType>
</additionalPartyIdentification>
</informationProvider>
<nameOfInformationProvider>WWRE Supplier 01</nameOfInformationProvider>
</informationProviderOfTradeItem>
- <targetMarketInformation>
- <targetMarketCountryCode>
<countryISOCode>840</countryISOCode>
</targetMarketCountryCode>
- <targetMarketDescription>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>United States Of America</shortText>
</targetMarketDescription>
</targetMarketInformation>
- <classificationCategoryCode>
<classificationCategoryCode>10003254</classificationCategoryCode>
<classificationCategoryDefinition>GPC</classificationCategoryDefinition>
<classificationCategoryName>GPC</classificationCategoryName>
- <additionalClassification>
<additionalClassificationAgencyName>UDEX</additionalClassificationAgencyName>
<additionalClassificationCategoryCode>05.0139.0067</additionalClassificationCategoryCode>
<additionalClassificationCategoryDescription>UDEX_DESCRIPTION</additionalClassificationCategoryDescription>
</additionalClassification>
</classificationCategoryCode>
- <tradeItemDescriptionInformation>
<brandName>Test Product</brandName>
- <descriptionShort>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Test Production Description</shortText>
</description>
</descriptionShort>
- <functionalName>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Functional Name</shortText>
</description>
</functionalName>
- <tradeItemDescription>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Product Description Long</text>
</tradeItemDescription>
- <invoiceName>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Invoice Item Name</shortText>
</description>
</invoiceName>
<productRange>Product Range Description</productRange>
<subBrand>Product Sub Brand Name</subBrand>
<tradeItemGroupIdentificationCode>ItemGroupIdCode</tradeItemGroupIdentificationCode>
- <tradeItemGroupIdentificationDescription>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Item Group Identification Desc</shortText>
</description>
</tradeItemGroupIdentificationDescription>
<tradeItemFormDescription>Trade Item Form Description</tradeItemFormDescription>
- <variant>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Variant Description</shortText>
</description>
</variant>
</tradeItemDescriptionInformation>
- <tradingPartnerNeutralTradeItemInformation>
- <tradeItemUnitIndicator>
<isTradeItemABaseUnit>false</isTradeItemABaseUnit>
<isTradeItemAConsumerUnit>false</isTradeItemAConsumerUnit>
<isTradeItemADespatchUnit>true</isTradeItemADespatchUnit>
<isTradeItemAnInvoiceUnit>true</isTradeItemAnInvoiceUnit>
<isTradeItemAnOrderableUnit>true</isTradeItemAnOrderableUnit>
<isTradeItemAVariableUnit>false</isTradeItemAVariableUnit>
<priceByMeasureType>COUNT</priceByMeasureType>
</tradeItemUnitIndicator>
<barCodeType>COMPOSITE_COMPONENT_A</barCodeType>
- <brandOwnerOfTradeItem>
- <brandOwner>
<gln>0821620000672</gln>
- <additionalPartyIdentification>
<additionalPartyIdentificationValue>012345678</additionalPartyIdentificationValue>
<additionalPartyIdentificationType>DUNS</additionalPartyIdentificationType>
</additionalPartyIdentification>
</brandOwner>
<nameOfBrandOwner>Brand Owner Name</nameOfBrandOwner>
</brandOwnerOfTradeItem>
- <manufacturerOfTradeItem>
- <manufacturer>
<gln>0821620000672</gln>
- <additionalPartyIdentification>
<additionalPartyIdentificationValue>012345678</additionalPartyIdentificationValue>
<additionalPartyIdentificationType>DUNS</additionalPartyIdentificationType>
</additionalPartyIdentification>
</manufacturer>
<nameOfManufacturer>Manufacturer Name</nameOfManufacturer>
</manufacturerOfTradeItem>
- <organicTradeItemCharacteristics>
<organicClaimAgency>Organic Claim Agency Name</organicClaimAgency>
<organicTradeItemCode>1</organicTradeItemCode>
</organicTradeItemCharacteristics>
- <packagingMarking>
<isPackagingMarkedReturnable>false</isPackagingMarkedReturnable>
<isPackagingMarkedWithIngredients>false</isPackagingMarkedWithIngredients>
</packagingMarking>
- <packagingMaterial>
<packagingMaterialCode>2</packagingMaterialCode>
<packagingMaterialCodeListMaintenanceAgency>Packaging Material Code Agency</packagingMaterialCodeListMaintenanceAgency>
- <packagingMaterialCompositionQuantity>
- <measurementValue unitOfMeasure="PN">
<value>3</value>
</measurementValue>
</packagingMaterialCompositionQuantity>
- <packagingMaterialDescription>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Packaging Material Description</shortText>
</description>
</packagingMaterialDescription>
<packagingTermsAndCondition>PTC</packagingTermsAndCondition>
<depositValueEffectiveDate>2003-12-01</depositValueEffectiveDate>
<depositValueEndDate>2004-12-31</depositValueEndDate>
<returnablePackageDepositCode>07350000000054</returnablePackageDepositCode>
- <returnablePackageDepositAmount>
- <currencyCode>
<currencyISOCode>USD</currencyISOCode>
</currencyCode>
<monetaryAmount>1.50</monetaryAmount>
</returnablePackageDepositAmount>
</packagingMaterial>
- <packagingType>
<packagingTypeCode>AE</packagingTypeCode>
<packagingTypeDescription>Packaging Type Description</packagingTypeDescription>
</packagingType>
- <priceOnTradeItem>
- <retailPriceOnTradeItem>
- <currencyCode>
<currencyISOCode>USD</currencyISOCode>
</currencyCode>
<priceAmount>32.5</priceAmount>
</retailPriceOnTradeItem>
</priceOnTradeItem>
- <tradeItemCountryOfOrigin>
<countryISOCode>840</countryISOCode>
</tradeItemCountryOfOrigin>
- <tradeItemCoupon>
<couponFamilyCode>1</couponFamilyCode>
</tradeItemCoupon>
- <tradeItemDateInformation>
<effectiveDate>2003-12-13</effectiveDate>
<lastChangeDateTime>2003-12-17T09:30:47</lastChangeDateTime>
<publicationDate>2003-12-21</publicationDate>
<startAvailabilityDateTime>2003-12-25T09:30:47</startAvailabilityDateTime>
<consumerAvailabilityDateTime>2003-12-25T09:30:47</consumerAvailabilityDateTime>
<endAvailabilityDateTime>2003-12-31T09:30:47</endAvailabilityDateTime>
<firstOrderDate>2004-12-31</firstOrderDate>
<firstShipDate>2004-12-31</firstShipDate>
<lastOrderDate>2005-12-31</lastOrderDate>
<lastShipDate>2005-12-31</lastShipDate>
</tradeItemDateInformation>
- <tradeItemHandlingInformation>
<minimumTradeItemLifespanFromTimeOfArrival>1</minimumTradeItemLifespanFromTimeOfArrival>
<stackingFactor>1</stackingFactor>
- <stackingWeightMaximum>
- <measurementValue unitOfMeasure="LB">
<value>300</value>
</measurementValue>
</stackingWeightMaximum>
<minimumTradeItemLifespanFromTimeOfProduction>9000</minimumTradeItemLifespanFromTimeOfProduction>
</tradeItemHandlingInformation>
- <tradeItemHierarchy>
<quantityOfCompleteLayersContainedInATradeItem>1</quantityOfCompleteLayersContainedInATradeItem>
<quantityOfTradeItemsContainedInACompleteLayer>5</quantityOfTradeItemsContainedInACompleteLayer>
<quantityOfInnerPack>15</quantityOfInnerPack>
<quantityOfNextLevelTradeItemWithinInnerPack>1</quantityOfNextLevelTradeItemWithinInnerPack>
</tradeItemHierarchy>
- <tradeItemMarking>
<hasBatchNumber>true</hasBatchNumber>
<isNonSoldTradeItemReturnable>false</isNonSoldTradeItemReturnable>
<isTradeItemMarkedAsRecyclable>false</isTradeItemMarkedAsRecyclable>
</tradeItemMarking>
- <tradeItemMeasurements>
- <depth>
- <measurementValue unitOfMeasure="IN">
<value>9</value>
</measurementValue>
</depth>
- <grossWeight>
- <measurementValue unitOfMeasure="LB">
<value>300</value>
</measurementValue>
</grossWeight>
- <height>
- <measurementValue unitOfMeasure="IN">
<value>36</value>
</measurementValue>
</height>
<isNetContentDeclarationIndicated>false</isNetContentDeclarationIndicated>
- <width>
- <measurementValue unitOfMeasure="IN">
<value>32</value>
</measurementValue>
</width>
- <diameter>
- <measurementValue unitOfMeasure="IN">
<value>48</value>
</measurementValue>
</diameter>
- <drainedWeight>
- <measurementValue unitOfMeasure="LB">
<value>25</value>
</measurementValue>
</drainedWeight>
<genericIngredient>Generic Ingredient</genericIngredient>
- <genericIngredientStrength>
- <measurementValue unitOfMeasure="LB">
<value>1</value>
</measurementValue>
</genericIngredientStrength>
<ingredientStrength>IngredientStrength</ingredientStrength>
- <netContent>
- <measurementValue unitOfMeasure="PL">
<value>2500</value>
</measurementValue>
</netContent>
- <netWeight>
- <measurementValue unitOfMeasure="LB">
<value>280</value>
</measurementValue>
</netWeight>
- <pegMeasurements>
<pegHoleNumber>999</pegHoleNumber>
- <pegHorizontal>
- <measurementValue unitOfMeasure="IN">
<value>18</value>
</measurementValue>
</pegHorizontal>
- <pegVertical>
- <measurementValue unitOfMeasure="IN">
<value>3</value>
</measurementValue>
</pegVertical>
</pegMeasurements>
<priceComparisonContentType>PER_DOSE</priceComparisonContentType>
- <priceComparisonMeasurement>
- <measurementValue unitOfMeasure="PDO">
<value>25</value>
</measurementValue>
</priceComparisonMeasurement>
</tradeItemMeasurements>
- <tradeItemOrderInformation>
- <orderingLeadTime>
- <measurementValue unitOfMeasure="D">
<value>3</value>
</measurementValue>
</orderingLeadTime>
<orderQuantityMaximum>100</orderQuantityMaximum>
<orderQuantityMinimum>1</orderQuantityMinimum>
<orderQuantityMultiple>1</orderQuantityMultiple>
- <orderSizingFactor>
- <measurementValue unitOfMeasure="AS">
<value>24</value>
</measurementValue>
</orderSizingFactor>
<agreedMinimumBuyingQuantity>999</agreedMinimumBuyingQuantity>
<firstDeliveryDateTime>2004-12-31T00:00:00</firstDeliveryDateTime>
<isTradeItemReorderable>false</isTradeItemReorderable>
</tradeItemOrderInformation>
- <tradeItemPalletInformation>
<palletTypeCode>1</palletTypeCode>
<palletTermsAndConditions>1</palletTermsAndConditions>
</tradeItemPalletInformation>
- <cataloguePrice>
<effectiveStartDate>2003-08-13</effectiveStartDate>
<effectiveEndDate>2004-08-13</effectiveEndDate>
- <tradeItemPrice>
- <currencyCode>
<currencyISOCode>USD</currencyISOCode>
</currencyCode>
<value>24</value>
</tradeItemPrice>
</cataloguePrice>
- <suggestedRetailPrice>
<effectiveStartDate>2003-08-13</effectiveStartDate>
<effectiveEndDate>2004-08-13</effectiveEndDate>
- <tradeItemPrice>
- <currencyCode>
<currencyISOCode>USD</currencyISOCode>
</currencyCode>
<value>35</value>
</tradeItemPrice>
</suggestedRetailPrice>
- <tradeItemSizeDescription>
<sizeCodeListAgency>SCA</sizeCodeListAgency>
<sizeCodeValue>Code value</sizeCodeValue>
- <descriptiveSize>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Size description</shortText>
</descriptiveSize>
</tradeItemSizeDescription>
- <tradeItemTemperatureInformation>
- <deliveryToDistributionCenterTemperatureMaximum>
- <measurementValue unitOfMeasure="C">
<value>12</value>
</measurementValue>
</deliveryToDistributionCenterTemperatureMaximum>
- <deliveryToDistributionCenterTemperatureMinimum>
- <measurementValue unitOfMeasure="C">
<value>5</value>
</measurementValue>
</deliveryToDistributionCenterTemperatureMinimum>
- <deliveryToMarketTemperatureMaximum>
- <measurementValue unitOfMeasure="C">
<value>12</value>
</measurementValue>
</deliveryToMarketTemperatureMaximum>
- <deliveryToMarketTemperatureMinimum>
- <measurementValue unitOfMeasure="C">
<value>5</value>
</measurementValue>
</deliveryToMarketTemperatureMinimum>
- <storageHandlingTemperatureMaximum>
- <measurementValue unitOfMeasure="C">
<value>12</value>
</measurementValue>
</storageHandlingTemperatureMaximum>
- <storageHandlingTemperatureMinimum>
- <measurementValue unitOfMeasure="C">
<value>5</value>
</measurementValue>
</storageHandlingTemperatureMinimum>
- <storageHandlingHumidityMaximum>
- <measurementValue unitOfMeasure="P1">
<value>999</value>
</measurementValue>
</storageHandlingHumidityMaximum>
- <storageHandlingHumidityMinimum>
- <measurementValue unitOfMeasure="P1">
<value>999</value>
</measurementValue>
</storageHandlingHumidityMinimum>
</tradeItemTemperatureInformation>
- <tradeItemCountryOfAssembly>
<countryISOCode>840</countryISOCode>
</tradeItemCountryOfAssembly>
</tradingPartnerNeutralTradeItemInformation>
</tradeItemInformation>
- <extension>
- <wwre:itemDataExtension xsi:schemaLocation="urn:wwre:item:4 xmlns:wwre="urn:wwre:item:4">
- <tradeItemPriceInformation>
- <suggestedRetailPriceOfSubstituedTradeItem>
- <amount>
- <currencyCode>
<currencyISOCode>USD</currencyISOCode>
</currencyCode>
<monetaryAmount>25.75</monetaryAmount>
</amount>
</suggestedRetailPriceOfSubstituedTradeItem>
<supplierAdvertising>false</supplierAdvertising>
</tradeItemPriceInformation>
- <tradeItemDateInformation>
<lastSaleDate>2004-12-31</lastSaleDate>
<withdrawalDate>2004-12-31</withdrawalDate>
<expirationDate>2004-12-31</expirationDate>
</tradeItemDateInformation>
- <tradeItemInformation>
- <flavor>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Strong Cinnamon</text>
</description>
</flavor>
<isANewTradeItem>false</isANewTradeItem>
- <tradeItemCountryOfDelivery>
- <country>
<countryISOCode>840</countryISOCode>
</country>
</tradeItemCountryOfDelivery>
<eUR1Indicator>false</eUR1Indicator>
<eUR2Indicator>false</eUR2Indicator>
</tradeItemInformation>
- <tradeItemMarking>
<returnableTradeItemStartDate>2003-12-31</returnableTradeItemStartDate>
<returnableTradeItemEndDate>2004-12-31</returnableTradeItemEndDate>
</tradeItemMarking>
- <tradeItemMeasurements>
- <basePriceRelevantNetContent>
- <measurementValue unitOfMeasure="EA">
<value>18</value>
</measurementValue>
</basePriceRelevantNetContent>
<mgsOfEphedrine>12.1234</mgsOfEphedrine>
<mgsOfPsuedoEphedrine>12.1234</mgsOfPsuedoEphedrine>
- <gratisWeightOrVolume>
- <measurementValue unitOfMeasure="IN">
<value>18</value>
</measurementValue>
</gratisWeightOrVolume>
<gratisAdditionalOrIncluded>0</gratisAdditionalOrIncluded>
</tradeItemMeasurements>
- <tradeItemOrderInformation>
<reorderableLeadTime>999</reorderableLeadTime>
<minimumShip>999</minimumShip>
</tradeItemOrderInformation>
- <tradeItemHandlingInformation>
<minimumTradeItemLifespanFromTimeOfProductionType>2</minimumTradeItemLifespanFromTimeOfProductionType>
- <handlingInstructions>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Instruction Text</text>
</description>
</handlingInstructions>
<handlingInstructionsCodeAgency>Agency Name</handlingInstructionsCodeAgency>
</tradeItemHandlingInformation>
- <tradeItemMiscellaneousInformation>
<picturePath>URL for picture</picturePath>
- <freeFormComments>
- <longDescription>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<longText>Comment</longText>
</longDescription>
</freeFormComments>
</tradeItemMiscellaneousInformation>
</wwre:itemDataExtension>
- <wwre:fMCGItemDataExtension xsi:schemaLocation="urn:wwre:item:4 xmlns:wwre="urn:wwre:item:4">
<quantityOfPortions unitOfMeasure="CU">1</quantityOfPortions>
<quantityOfCalories unitOfMeasure="CU">3.14</quantityOfCalories>
<caloriesRDVPercentage>3.14</caloriesRDVPercentage>
<quantityOfCarbohydrates unitOfMeasure="CU">3.14</quantityOfCarbohydrates>
<carbohydratesRDVPercentage>3.14</carbohydratesRDVPercentage>
<quantityOfProtein unitOfMeasure="CU">3.14</quantityOfProtein>
<proteinRDVPercentage>3.14</proteinRDVPercentage>
<quantityOfTotalFat unitOfMeasure="APZ">3.14</quantityOfTotalFat>
<totalFatRDVPercentage>3.14</totalFatRDVPercentage>
<quantityOfSaturatedFat unitOfMeasure="CU">3.14</quantityOfSaturatedFat>
<saturatedFatRDVPercentage>3.14</saturatedFatRDVPercentage>
<quantityOfCholesterol unitOfMeasure="CU">3.14</quantityOfCholesterol>
<cholesterolRDVPercentage>3.14</cholesterolRDVPercentage>
<quantityOfDietaryFiber unitOfMeasure="CU">3.14</quantityOfDietaryFiber>
<dietaryFiberRDVPercentage>3.14</dietaryFiberRDVPercentage>
<quantityOfCalcium unitOfMeasure="CU">3.14</quantityOfCalcium>
<calciumRDVPercentage>3.14</calciumRDVPercentage>
<quantityOfIron unitOfMeasure="CU">3.14</quantityOfIron>
<ironRDVPercentage>3.14</ironRDVPercentage>
<quantityOfSodium unitOfMeasure="CU">3.14</quantityOfSodium>
<sodiumRDVPercentage>3.14</sodiumRDVPercentage>
</wwre:fMCGItemDataExtension>
- <wwre:transoraCRItemDataExtension xsi:schemaLocation="urn:wwre:item:4 xmlns:wwre="urn:wwre:item:4">
- <tradeItemPriceDateInformation>
- <cataloguePrice>
<unitOfMeasure>PL</unitOfMeasure>
<basisQuantity>125</basisQuantity>
</cataloguePrice>
- <suggestedRetailPrice>
<unitOfMeasure>PL</unitOfMeasure>
<basisQuantity>125</basisQuantity>
</suggestedRetailPrice>
</tradeItemPriceDateInformation>
- <packagingMaterial>
- <returnablePackageDepositDescription>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Description of returnable package deposit</text>
</description>
</returnablePackageDepositDescription>
</packagingMaterial>
- <tradeItemDateInformation>
<lastArrivalDate>2005-12-31</lastArrivalDate>
</tradeItemDateInformation>
- <privateInformation>
<isTradeItemBrandPrivateLabel>false</isTradeItemBrandPrivateLabel>
</privateInformation>
- <tradeItemDescriptionInformation>
- <ingredients>
- <language>
<languageISOCode />
</language>
<text>List Ingredients</text>
</ingredients>
</tradeItemDescriptionInformation>
- <tradeItemMeasurements>
- <netVolume>
<measurementValue unitOfMeasure="C8">18</measurementValue>
</netVolume>
</tradeItemMeasurements>
</wwre:transoraCRItemDataExtension>
- <gdsn:attributeValuePairExtension xsi:schemaLocation="urn:ean.ucc:2 ../schemas/ean.ucc/gdsn/AttributeValuePairExtension.xsd">
<value name="One">Attribute One Value</value>
</gdsn:attributeValuePairExtension>
</extension>
</tradeItem>
<dataRecipient>7216201001927</dataRecipient>
<sourceDataPool>0821620500004</sourceDataPool>
- <catalogueItemChildItemLink quantity="10">
- <catalogueItem>
<catalogueItemState state="REGISTERED" />
- <tradeItem xmlns:xsi=" <tradeItemUnitDescriptor>CASE</tradeItemUnitDescriptor>
- <tradeItemIdentification>
<gtin>10821620007258</gtin>
</tradeItemIdentification>
- <nextLowerLevelTradeItemInformation>
<quantityOfChildren>1</quantityOfChildren>
<totalQuantityOfNextLowerLevelTradeItem>4</totalQuantityOfNextLowerLevelTradeItem>
- <childTradeItem>
<quantityofNextLowerLevelTradeItem>4</quantityofNextLowerLevelTradeItem>
- <tradeItemIdentification>
<gtin>00821620007251</gtin>
</tradeItemIdentification>
</childTradeItem>
</nextLowerLevelTradeItemInformation>
- <tradeItemInformation>
- <informationProviderOfTradeItem>
- <informationProvider>
<gln>0821620000672</gln>
</informationProvider>
<nameOfInformationProvider>Information Provider Name</nameOfInformationProvider>
</informationProviderOfTradeItem>
- <targetMarketInformation>
- <targetMarketCountryCode>
<countryISOCode>840</countryISOCode>
</targetMarketCountryCode>
- <targetMarketDescription>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>United States Of America</shortText>
</targetMarketDescription>
</targetMarketInformation>
- <classificationCategoryCode>
<classificationCategoryCode>10003254</classificationCategoryCode>
<classificationCategoryDefinition>GPC</classificationCategoryDefinition>
<classificationCategoryName>GPC</classificationCategoryName>
- <additionalClassification>
<additionalClassificationAgencyName>UDEX</additionalClassificationAgencyName>
<additionalClassificationCategoryCode>05.0139.0067</additionalClassificationCategoryCode>
<additionalClassificationCategoryDescription>UDEX_DESCRIPTION</additionalClassificationCategoryDescription>
</additionalClassification>
- <gDSNTradeItemClassificationAttribute>
<eANUCCClassificationAttributeTypeCode>00000001</eANUCCClassificationAttributeTypeCode>
<eANUCCClassificationAttributeTypeName>Type Name</eANUCCClassificationAttributeTypeName>
<eANUCCClassificationAttributeTypeDefinition>Type</eANUCCClassificationAttributeTypeDefinition>
- <gDSNTradeItemClassificationAttributeValue>
<eANUCCClassificationAttributeValueCode>00000001</eANUCCClassificationAttributeValueCode>
<eANUCCClassificationAttributeValueName>Value</eANUCCClassificationAttributeValueName>
</gDSNTradeItemClassificationAttributeValue>
</gDSNTradeItemClassificationAttribute>
</classificationCategoryCode>
- <tradeItemDescriptionInformation>
<brandName>Test Product</brandName>
- <descriptionShort>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Test Production Description</shortText>
</description>
</descriptionShort>
- <functionalName>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Functional Name</shortText>
</description>
</functionalName>
- <tradeItemDescription>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Product Description Long</text>
</tradeItemDescription>
- <additionalTradeItemDescription>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Additional Item Description</text>
</additionalTradeItemDescription>
- <invoiceName>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Invoice Item Name</shortText>
</description>
</invoiceName>
<productRange>Product Range Description</productRange>
<subBrand>Product Sub Brand Name</subBrand>
<tradeItemGroupIdentificationCode>ItemGroupIdCode</tradeItemGroupIdentificationCode>
- <tradeItemGroupIdentificationDescription>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Item Group Identification Desc</shortText>
</description>
</tradeItemGroupIdentificationDescription>
<tradeItemFormDescription>Trade Item Form Description</tradeItemFormDescription>
- <variant>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Variant Description</shortText>
</description>
</variant>
</tradeItemDescriptionInformation>
- <tradingPartnerNeutralTradeItemInformation>
- <tradeItemUnitIndicator>
<isTradeItemABaseUnit>false</isTradeItemABaseUnit>
<isTradeItemAConsumerUnit>true</isTradeItemAConsumerUnit>
<isTradeItemADespatchUnit>true</isTradeItemADespatchUnit>
<isTradeItemAnInvoiceUnit>true</isTradeItemAnInvoiceUnit>
<isTradeItemAnOrderableUnit>true</isTradeItemAnOrderableUnit>
<isTradeItemAVariableUnit>false</isTradeItemAVariableUnit>
<priceByMeasureType>COUNT</priceByMeasureType>
</tradeItemUnitIndicator>
<barCodeType>COMPOSITE_COMPONENT_A</barCodeType>
- <brandOwnerOfTradeItem>
- <brandOwner>
<gln>0821620000672</gln>
</brandOwner>
<nameOfBrandOwner>Brand Owner Name</nameOfBrandOwner>
</brandOwnerOfTradeItem>
- <manufacturerOfTradeItem>
- <manufacturer>
<gln>0821620000672</gln>
- <additionalPartyIdentification>
<additionalPartyIdentificationValue>012345678</additionalPartyIdentificationValue>
<additionalPartyIdentificationType>DUNS</additionalPartyIdentificationType>
</additionalPartyIdentification>
</manufacturer>
<nameOfManufacturer>Manufacturer Name</nameOfManufacturer>
</manufacturerOfTradeItem>
- <materialSafetyData>
<materialSafetyDataSheetNumber>MSDN number</materialSafetyDataSheetNumber>
</materialSafetyData>
- <organicTradeItemCharacteristics>
<organicClaimAgency>Organic Claim Agency Name</organicClaimAgency>
<organicTradeItemCode>1</organicTradeItemCode>
</organicTradeItemCharacteristics>
- <packagingMarking>
<isPackagingMarkedReturnable>false</isPackagingMarkedReturnable>
<isPackagingMarkedWithIngredients>false</isPackagingMarkedWithIngredients>
</packagingMarking>
- <packagingMaterial>
<packagingMaterialCode>2</packagingMaterialCode>
<packagingMaterialCodeListMaintenanceAgency>Packaging Material Code Agency</packagingMaterialCodeListMaintenanceAgency>
- <packagingMaterialCompositionQuantity>
- <measurementValue unitOfMeasure="PN">
<value>3</value>
</measurementValue>
</packagingMaterialCompositionQuantity>
- <packagingMaterialDescription>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Packaging Material Description</shortText>
</description>
</packagingMaterialDescription>
<packagingTermsAndCondition>PTC</packagingTermsAndCondition>
<depositValueEffectiveDate>2003-12-01</depositValueEffectiveDate>
<depositValueEndDate>2004-12-31</depositValueEndDate>
<returnablePackageDepositCode>07350000000054</returnablePackageDepositCode>
- <returnablePackageDepositAmount>
- <currencyCode>
<currencyISOCode>USD</currencyISOCode>
</currencyCode>
<monetaryAmount>1.50</monetaryAmount>
</returnablePackageDepositAmount>
</packagingMaterial>
- <packagingType>
<packagingTypeCode>AE</packagingTypeCode>
<packagingTypeDescription>Packaging Type Description</packagingTypeDescription>
</packagingType>
- <priceOnTradeItem>
- <retailPriceOnTradeItem>
- <currencyCode>
<currencyISOCode>USD</currencyISOCode>
</currencyCode>
<priceAmount>32.5</priceAmount>
</retailPriceOnTradeItem>
</priceOnTradeItem>
- <tradeItemColorDescription>
<colorCodeListAgency>Str</colorCodeListAgency>
<colorCodeValue>Color</colorCodeValue>
- <colorDescription>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Color</text>
</description>
</colorDescription>
</tradeItemColorDescription>
- <tradeItemCountryOfOrigin>
<countryISOCode>840</countryISOCode>
</tradeItemCountryOfOrigin>
- <tradeItemCoupon>
<couponFamilyCode>1</couponFamilyCode>
</tradeItemCoupon>
- <tradeItemDateInformation>
<effectiveDate>2003-12-13</effectiveDate>
<lastChangeDateTime>2003-12-17T09:30:47</lastChangeDateTime>
<publicationDate>2003-12-21</publicationDate>
<startAvailabilityDateTime>2003-12-25T09:30:47</startAvailabilityDateTime>
<consumerAvailabilityDateTime>2003-12-25T09:30:47</consumerAvailabilityDateTime>
<endAvailabilityDateTime>2003-12-31T09:30:47</endAvailabilityDateTime>
<firstOrderDate>2004-12-31</firstOrderDate>
<firstShipDate>2004-12-31</firstShipDate>
<lastOrderDate>2005-12-31</lastOrderDate>
<lastShipDate>2005-12-31</lastShipDate>
</tradeItemDateInformation>
- <tradeItemHandlingInformation>
<minimumTradeItemLifespanFromTimeOfArrival>1</minimumTradeItemLifespanFromTimeOfArrival>
<stackingFactor>1</stackingFactor>
- <stackingWeightMaximum>
- <measurementValue unitOfMeasure="LB">
<value>300</value>
</measurementValue>
</stackingWeightMaximum>
<minimumTradeItemLifespanFromTimeOfProduction>9000</minimumTradeItemLifespanFromTimeOfProduction>
</tradeItemHandlingInformation>
- <tradeItemHazardousInformation>
<dangerousGoodsRegulationCode>A</dangerousGoodsRegulationCode>
- <flashPointTemperature>
- <measurementValue unitOfMeasure="FAH">
<value>150</value>
</measurementValue>
</flashPointTemperature>
- <hazardousInformationDetail>
<classOfDangerousGoods>1</classOfDangerousGoods>
<dangerousGoodsAMarginNumber>NOT_POSSIBLE</dangerousGoodsAMarginNumber>
<dangerousGoodsHazardousCode>1</dangerousGoodsHazardousCode>
<dangerousGoodsPackingGroup>DGP</dangerousGoodsPackingGroup>
<dangerousGoodsShippingName>Dangerous Good Shipping Name</dangerousGoodsShippingName>
<unitedNationsDangerousGoodsNumber>0</unitedNationsDangerousGoodsNumber>
- <dangerousGoodsTechnicalName>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Dangerous Good Name</text>
</dangerousGoodsTechnicalName>
</hazardousInformationDetail>
</tradeItemHazardousInformation>
- <tradeItemHierarchy>
<quantityOfInnerPack>15</quantityOfInnerPack>
<quantityOfNextLevelTradeItemWithinInnerPack>1</quantityOfNextLevelTradeItemWithinInnerPack>
</tradeItemHierarchy>
- <tradeItemMarking>
<hasBatchNumber>true</hasBatchNumber>
<isNonSoldTradeItemReturnable>false</isNonSoldTradeItemReturnable>
<isTradeItemMarkedAsRecyclable>false</isTradeItemMarkedAsRecyclable>
</tradeItemMarking>
- <tradeItemMeasurements>
- <depth>
- <measurementValue unitOfMeasure="IN">
<value>9</value>
</measurementValue>
</depth>
- <grossWeight>
- <measurementValue unitOfMeasure="LB">
<value>20</value>
</measurementValue>
</grossWeight>
- <height>
- <measurementValue unitOfMeasure="IN">
<value>36</value>
</measurementValue>
</height>
<isNetContentDeclarationIndicated>false</isNetContentDeclarationIndicated>
- <width>
- <measurementValue unitOfMeasure="IN">
<value>32</value>
</measurementValue>
</width>
- <diameter>
- <measurementValue unitOfMeasure="IN">
<value>48</value>
</measurementValue>
</diameter>
- <drainedWeight>
- <measurementValue unitOfMeasure="LB">
<value>25</value>
</measurementValue>
</drainedWeight>
<genericIngredient>Generic Ingredient</genericIngredient>
- <genericIngredientStrength>
- <measurementValue unitOfMeasure="LB">
<value>1</value>
</measurementValue>
</genericIngredientStrength>
<ingredientStrength>IngredientStrength</ingredientStrength>
- <netContent>
- <measurementValue unitOfMeasure="PL">
<value>2500</value>
</measurementValue>
</netContent>
- <netWeight>
- <measurementValue unitOfMeasure="LB">
<value>18</value>
</measurementValue>
</netWeight>
- <pegMeasurements>
<pegHoleNumber>999</pegHoleNumber>
- <pegHorizontal>
- <measurementValue unitOfMeasure="IN">
<value>18</value>
</measurementValue>
</pegHorizontal>
- <pegVertical>
- <measurementValue unitOfMeasure="IN">
<value>3</value>
</measurementValue>
</pegVertical>
</pegMeasurements>
<priceComparisonContentType>PER_DOSE</priceComparisonContentType>
- <priceComparisonMeasurement>
- <measurementValue unitOfMeasure="PDO">
<value>25</value>
</measurementValue>
</priceComparisonMeasurement>
</tradeItemMeasurements>
- <tradeItemOrderInformation>
- <orderingLeadTime>
- <measurementValue unitOfMeasure="D">
<value>3</value>
</measurementValue>
</orderingLeadTime>
<orderQuantityMaximum>100</orderQuantityMaximum>
<orderQuantityMinimum>1</orderQuantityMinimum>
<orderQuantityMultiple>1</orderQuantityMultiple>
- <orderSizingFactor>
- <measurementValue unitOfMeasure="AS">
<value>24</value>
</measurementValue>
</orderSizingFactor>
<agreedMinimumBuyingQuantity>999</agreedMinimumBuyingQuantity>
<firstDeliveryDateTime>2004-12-31T00:00:00</firstDeliveryDateTime>
<isTradeItemReorderable>false</isTradeItemReorderable>
</tradeItemOrderInformation>
- <tradeItemPalletInformation>
<palletTypeCode>1</palletTypeCode>
<palletTermsAndConditions>1</palletTermsAndConditions>
</tradeItemPalletInformation>
- <cataloguePrice>
<effectiveStartDate>2003-08-13</effectiveStartDate>
<effectiveEndDate>2004-08-13</effectiveEndDate>
- <tradeItemPrice>
- <currencyCode>
<currencyISOCode>USD</currencyISOCode>
</currencyCode>
<value>24</value>
</tradeItemPrice>
</cataloguePrice>
- <suggestedRetailPrice>
<effectiveStartDate>2003-08-13</effectiveStartDate>
<effectiveEndDate>2004-08-13</effectiveEndDate>
- <tradeItemPrice>
- <currencyCode>
<currencyISOCode>USD</currencyISOCode>
</currencyCode>
<value>35</value>
</tradeItemPrice>
</suggestedRetailPrice>
- <tradeItemSizeDescription>
<sizeCodeListAgency>SCA</sizeCodeListAgency>
<sizeCodeValue>Code value</sizeCodeValue>
- <descriptiveSize>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Size description</shortText>
</descriptiveSize>
</tradeItemSizeDescription>
- <tradeItemTemperatureInformation>
- <deliveryToDistributionCenterTemperatureMaximum>
- <measurementValue unitOfMeasure="C">
<value>45</value>
</measurementValue>
</deliveryToDistributionCenterTemperatureMaximum>
- <deliveryToDistributionCenterTemperatureMinimum>
- <measurementValue unitOfMeasure="C">
<value>23</value>
</measurementValue>
</deliveryToDistributionCenterTemperatureMinimum>
- <deliveryToMarketTemperatureMaximum>
- <measurementValue unitOfMeasure="C">
<value>45</value>
</measurementValue>
</deliveryToMarketTemperatureMaximum>
- <deliveryToMarketTemperatureMinimum>
- <measurementValue unitOfMeasure="C">
<value>23</value>
</measurementValue>
</deliveryToMarketTemperatureMinimum>
- <storageHandlingTemperatureMaximum>
- <measurementValue unitOfMeasure="C">
<value>45</value>
</measurementValue>
</storageHandlingTemperatureMaximum>
- <storageHandlingTemperatureMinimum>
- <measurementValue unitOfMeasure="C">
<value>23</value>
</measurementValue>
</storageHandlingTemperatureMinimum>
- <storageHandlingHumidityMaximum>
- <measurementValue unitOfMeasure="P1">
<value>999</value>
</measurementValue>
</storageHandlingHumidityMaximum>
- <storageHandlingHumidityMinimum>
- <measurementValue unitOfMeasure="P1">
<value>999</value>
</measurementValue>
</storageHandlingHumidityMinimum>
</tradeItemTemperatureInformation>
- <tradeItemCountryOfAssembly>
<countryISOCode>840</countryISOCode>
</tradeItemCountryOfAssembly>
</tradingPartnerNeutralTradeItemInformation>
</tradeItemInformation>
- <extension>
- <wwre:itemDataExtension xsi:schemaLocation="urn:wwre:item:4 xmlns:wwre="urn:wwre:item:4">
- <tradeItemPriceInformation>
- <suggestedRetailPriceOfSubstituedTradeItem>
- <amount>
- <currencyCode>
<currencyISOCode>USD</currencyISOCode>
</currencyCode>
<monetaryAmount>25.75</monetaryAmount>
</amount>
</suggestedRetailPriceOfSubstituedTradeItem>
<supplierAdvertising>false</supplierAdvertising>
</tradeItemPriceInformation>
- <tradeItemDateInformation>
<lastSaleDate>2004-12-31</lastSaleDate>
<withdrawalDate>2004-12-31</withdrawalDate>
<expirationDate>2004-12-31</expirationDate>
</tradeItemDateInformation>
- <tradeItemInformation>
- <flavor>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Strong Cinnamon</text>
</description>
</flavor>
<isANewTradeItem>false</isANewTradeItem>
- <tradeItemCountryOfDelivery>
- <country>
<countryISOCode>840</countryISOCode>
</country>
</tradeItemCountryOfDelivery>
<eUR1Indicator>false</eUR1Indicator>
<eUR2Indicator>false</eUR2Indicator>
</tradeItemInformation>
- <tradeItemMarking>
<returnableTradeItemStartDate>2003-12-31</returnableTradeItemStartDate>
<returnableTradeItemEndDate>2004-12-31</returnableTradeItemEndDate>
</tradeItemMarking>
- <tradeItemMeasurements>
- <basePriceRelevantNetContent>
- <measurementValue unitOfMeasure="EA">
<value>18</value>
</measurementValue>
</basePriceRelevantNetContent>
<mgsOfEphedrine>12.1234</mgsOfEphedrine>
<mgsOfPsuedoEphedrine>12.1234</mgsOfPsuedoEphedrine>
- <gratisWeightOrVolume>
- <measurementValue unitOfMeasure="IN">
<value>18</value>
</measurementValue>
</gratisWeightOrVolume>
<gratisAdditionalOrIncluded>0</gratisAdditionalOrIncluded>
</tradeItemMeasurements>
- <tradeItemOrderInformation>
<reorderableLeadTime>999</reorderableLeadTime>
<minimumShip>999</minimumShip>
</tradeItemOrderInformation>
- <tradeItemHandlingInformation>
<minimumTradeItemLifespanFromTimeOfProductionType>2</minimumTradeItemLifespanFromTimeOfProductionType>
- <handlingInstructions>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Instruction Text</text>
</description>
</handlingInstructions>
<handlingInstructionsCodeAgency>Agency Name</handlingInstructionsCodeAgency>
</tradeItemHandlingInformation>
- <tradeItemHazardousInformation>
<aerosolLevelHandling>Text</aerosolLevelHandling>
<flammableLevelHandling>Text</flammableLevelHandling>
</tradeItemHazardousInformation>
- <tradeItemMiscellaneousInformation>
<picturePath>URL for picture</picturePath>
- <freeFormComments>
- <longDescription>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<longText>Comment</longText>
</longDescription>
</freeFormComments>
</tradeItemMiscellaneousInformation>
</wwre:itemDataExtension>
- <wwre:transoraCRItemDataExtension xsi:schemaLocation="urn:wwre:item:4 xmlns:wwre="urn:wwre:item:4">
- <tradeItemPriceDateInformation>
- <cataloguePrice>
<unitOfMeasure>PL</unitOfMeasure>
<basisQuantity>125</basisQuantity>
</cataloguePrice>
- <suggestedRetailPrice>
<unitOfMeasure>PL</unitOfMeasure>
<basisQuantity>125</basisQuantity>
</suggestedRetailPrice>
</tradeItemPriceDateInformation>
- <packagingMaterial>
- <returnablePackageDepositDescription>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Description of returnable package deposit</text>
</description>
</returnablePackageDepositDescription>
</packagingMaterial>
- <tradeItemDateInformation>
<lastArrivalDate>2005-12-31</lastArrivalDate>
</tradeItemDateInformation>
- <privateInformation>
<isTradeItemBrandPrivateLabel>false</isTradeItemBrandPrivateLabel>
</privateInformation>
- <tradeItemDescriptionInformation>
- <ingredients>
- <language>
<languageISOCode />
</language>
<text>List Ingredients</text>
</ingredients>
</tradeItemDescriptionInformation>
- <tradeItemMeasurements>
- <netVolume>
<measurementValue unitOfMeasure="C8">18</measurementValue>
</netVolume>
</tradeItemMeasurements>
</wwre:transoraCRItemDataExtension>
- <gdsn:attributeValuePairExtension xsi:schemaLocation="urn:ean.ucc:2 ../schemas/ean.ucc/gdsn/AttributeValuePairExtension.xsd">
<value name="One">Attribute One Value</value>
</gdsn:attributeValuePairExtension>
</extension>
</tradeItem>
<dataRecipient>7216201001927</dataRecipient>
<sourceDataPool>0821620500004</sourceDataPool>
- <catalogueItemChildItemLink quantity="4">
- <catalogueItem>
<catalogueItemState state="REGISTERED" />
- <tradeItem xmlns:xsi=" <tradeItemUnitDescriptor>BASE_UNIT_OR_EACH</tradeItemUnitDescriptor>
- <tradeItemIdentification>
<gtin>00821620007251</gtin>
</tradeItemIdentification>
- <tradeItemInformation>
- <informationProviderOfTradeItem>
- <informationProvider>
<gln>0821620000672</gln>
- <additionalPartyIdentification>
<additionalPartyIdentificationValue>Party Id</additionalPartyIdentificationValue>
<additionalPartyIdentificationType>BUYER_ASSIGNED_IDENTIFIER_FOR_A_PARTY</additionalPartyIdentificationType>
</additionalPartyIdentification>
</informationProvider>
<nameOfInformationProvider>Information Provider Name</nameOfInformationProvider>
</informationProviderOfTradeItem>
- <targetMarketInformation>
- <targetMarketCountryCode>
<countryISOCode>840</countryISOCode>
</targetMarketCountryCode>
- <targetMarketDescription>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>United States Of America</shortText>
</targetMarketDescription>
</targetMarketInformation>
- <classificationCategoryCode>
<classificationCategoryCode>10003254</classificationCategoryCode>
<classificationCategoryDefinition>GPC</classificationCategoryDefinition>
<classificationCategoryName>GPC</classificationCategoryName>
- <additionalClassification>
<additionalClassificationAgencyName>UDEX</additionalClassificationAgencyName>
<additionalClassificationCategoryCode>05.0139.0067</additionalClassificationCategoryCode>
<additionalClassificationCategoryDescription>UDEX_DESCRIPTION</additionalClassificationCategoryDescription>
</additionalClassification>
- <gDSNTradeItemClassificationAttribute>
<eANUCCClassificationAttributeTypeCode>00000001</eANUCCClassificationAttributeTypeCode>
<eANUCCClassificationAttributeTypeName>Type</eANUCCClassificationAttributeTypeName>
<eANUCCClassificationAttributeTypeDefinition>Name</eANUCCClassificationAttributeTypeDefinition>
- <gDSNTradeItemClassificationAttributeValue>
<eANUCCClassificationAttributeValueCode>00000001</eANUCCClassificationAttributeValueCode>
<eANUCCClassificationAttributeValueName>Value</eANUCCClassificationAttributeValueName>
</gDSNTradeItemClassificationAttributeValue>
</gDSNTradeItemClassificationAttribute>
</classificationCategoryCode>
- <tradeItemDescriptionInformation>
<brandName>Test Product</brandName>
- <descriptionShort>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Test Production Description</shortText>
</description>
</descriptionShort>
- <functionalName>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Functional Name</shortText>
</description>
</functionalName>
- <tradeItemDescription>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Product Description Long</text>
</tradeItemDescription>
- <additionalTradeItemDescription>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Additional Item Description</text>
</additionalTradeItemDescription>
- <invoiceName>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Invoice Item Name</shortText>
</description>
</invoiceName>
<productRange>Product Range Description</productRange>
<subBrand>Product Sub Brand Name</subBrand>
<tradeItemGroupIdentificationCode>Item Group Id Code</tradeItemGroupIdentificationCode>
- <tradeItemGroupIdentificationDescription>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Item Group Identification Desc</shortText>
</description>
</tradeItemGroupIdentificationDescription>
<tradeItemFormDescription>Trade Item Form Description</tradeItemFormDescription>
- <variant>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Variant Description</shortText>
</description>
</variant>
</tradeItemDescriptionInformation>
- <tradingPartnerNeutralTradeItemInformation>
- <tradeItemUnitIndicator>
<isTradeItemABaseUnit>true</isTradeItemABaseUnit>
<isTradeItemAConsumerUnit>true</isTradeItemAConsumerUnit>
<isTradeItemADespatchUnit>true</isTradeItemADespatchUnit>
<isTradeItemAnInvoiceUnit>true</isTradeItemAnInvoiceUnit>
<isTradeItemAnOrderableUnit>true</isTradeItemAnOrderableUnit>
<isTradeItemAVariableUnit>false</isTradeItemAVariableUnit>
<priceByMeasureType>COUNT</priceByMeasureType>
</tradeItemUnitIndicator>
<barCodeType>COMPOSITE_COMPONENT_A</barCodeType>
- <brandOwnerOfTradeItem>
- <brandOwner>
<gln>0821620000672</gln>
- <additionalPartyIdentification>
<additionalPartyIdentificationValue>012345678</additionalPartyIdentificationValue>
<additionalPartyIdentificationType>DUNS</additionalPartyIdentificationType>
</additionalPartyIdentification>
</brandOwner>
<nameOfBrandOwner>Brand Owner Name</nameOfBrandOwner>
</brandOwnerOfTradeItem>
- <manufacturerOfTradeItem>
- <manufacturer>
<gln>0821620000672</gln>
- <additionalPartyIdentification>
<additionalPartyIdentificationValue>012345678</additionalPartyIdentificationValue>
<additionalPartyIdentificationType>DUNS</additionalPartyIdentificationType>
</additionalPartyIdentification>
</manufacturer>
<nameOfManufacturer>Manufacturer Name</nameOfManufacturer>
</manufacturerOfTradeItem>
- <materialSafetyData>
<materialSafetyDataSheetNumber>MSDN number</materialSafetyDataSheetNumber>
</materialSafetyData>
- <organicTradeItemCharacteristics>
<organicClaimAgency>Organic Claim Agency Name</organicClaimAgency>
<organicTradeItemCode>1</organicTradeItemCode>
</organicTradeItemCharacteristics>
- <packagingMarking>
<isPackagingMarkedReturnable>false</isPackagingMarkedReturnable>
<isPackagingMarkedWithIngredients>false</isPackagingMarkedWithIngredients>
</packagingMarking>
- <packagingMaterial>
<packagingMaterialCode>2</packagingMaterialCode>
<packagingMaterialCodeListMaintenanceAgency>Packaging Material Code Agency</packagingMaterialCodeListMaintenanceAgency>
- <packagingMaterialCompositionQuantity>
- <measurementValue unitOfMeasure="PN">
<value>3</value>
</measurementValue>
</packagingMaterialCompositionQuantity>
- <packagingMaterialDescription>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Packaging Material Description</shortText>
</description>
</packagingMaterialDescription>
<packagingTermsAndCondition>PTC</packagingTermsAndCondition>
<depositValueEffectiveDate>2003-12-01</depositValueEffectiveDate>
<depositValueEndDate>2004-12-31</depositValueEndDate>
<returnablePackageDepositCode>07350000000054</returnablePackageDepositCode>
- <returnablePackageDepositAmount>
- <currencyCode>
<currencyISOCode>USD</currencyISOCode>
</currencyCode>
<monetaryAmount>1.50</monetaryAmount>
</returnablePackageDepositAmount>
</packagingMaterial>
- <packagingType>
<packagingTypeCode>AE</packagingTypeCode>
<packagingTypeDescription>Packaging Type Description</packagingTypeDescription>
</packagingType>
- <priceOnTradeItem>
- <retailPriceOnTradeItem>
- <currencyCode>
<currencyISOCode>USD</currencyISOCode>
</currencyCode>
<priceAmount>32.5</priceAmount>
</retailPriceOnTradeItem>
</priceOnTradeItem>
- <tradeItemColorDescription>
<colorCodeListAgency>Str</colorCodeListAgency>
<colorCodeValue>Color</colorCodeValue>
- <colorDescription>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Color</text>
</description>
</colorDescription>
</tradeItemColorDescription>
- <tradeItemCountryOfOrigin>
<countryISOCode>840</countryISOCode>
</tradeItemCountryOfOrigin>
- <tradeItemCoupon>
<couponFamilyCode>1</couponFamilyCode>
</tradeItemCoupon>
- <tradeItemDateInformation>
<effectiveDate>2003-12-13</effectiveDate>
<lastChangeDateTime>2003-12-17T09:30:47</lastChangeDateTime>
<publicationDate>2003-12-21</publicationDate>
<startAvailabilityDateTime>2003-12-25T09:30:47</startAvailabilityDateTime>
<consumerAvailabilityDateTime>2003-12-25T09:30:47</consumerAvailabilityDateTime>
<endAvailabilityDateTime>2003-12-31T09:30:47</endAvailabilityDateTime>
<firstOrderDate>2004-12-31</firstOrderDate>
<firstShipDate>2004-12-31</firstShipDate>
<lastOrderDate>2005-12-31</lastOrderDate>
<lastShipDate>2005-12-31</lastShipDate>
</tradeItemDateInformation>
- <tradeItemHandlingInformation>
<minimumTradeItemLifespanFromTimeOfArrival>1</minimumTradeItemLifespanFromTimeOfArrival>
<stackingFactor>1</stackingFactor>
- <stackingWeightMaximum>
- <measurementValue unitOfMeasure="LB">
<value>300</value>
</measurementValue>
</stackingWeightMaximum>
<minimumTradeItemLifespanFromTimeOfProduction>9000</minimumTradeItemLifespanFromTimeOfProduction>
</tradeItemHandlingInformation>
- <tradeItemHazardousInformation>
<dangerousGoodsRegulationCode>A</dangerousGoodsRegulationCode>
- <flashPointTemperature>
- <measurementValue unitOfMeasure="FAH">
<value>150</value>
</measurementValue>
</flashPointTemperature>
- <hazardousInformationDetail>
<classOfDangerousGoods>1</classOfDangerousGoods>
<dangerousGoodsAMarginNumber>NOT_POSSIBLE</dangerousGoodsAMarginNumber>
<dangerousGoodsHazardousCode>1</dangerousGoodsHazardousCode>
<dangerousGoodsPackingGroup>DGP</dangerousGoodsPackingGroup>
<dangerousGoodsShippingName>Dangerous Good Shipping Name</dangerousGoodsShippingName>
<unitedNationsDangerousGoodsNumber>0</unitedNationsDangerousGoodsNumber>
- <dangerousGoodsTechnicalName>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Dangerous Good Name</text>
</dangerousGoodsTechnicalName>
</hazardousInformationDetail>
</tradeItemHazardousInformation>
- <tradeItemHierarchy>
<quantityOfInnerPack>15</quantityOfInnerPack>
<quantityOfNextLevelTradeItemWithinInnerPack>1</quantityOfNextLevelTradeItemWithinInnerPack>
</tradeItemHierarchy>
- <tradeItemMarking>
<hasBatchNumber>true</hasBatchNumber>
<isNonSoldTradeItemReturnable>false</isNonSoldTradeItemReturnable>
<isTradeItemMarkedAsRecyclable>false</isTradeItemMarkedAsRecyclable>
</tradeItemMarking>
- <tradeItemMeasurements>
- <depth>
- <measurementValue unitOfMeasure="IN">
<value>9</value>
</measurementValue>
</depth>
- <grossWeight>
- <measurementValue unitOfMeasure="LB">
<value>3</value>
</measurementValue>
</grossWeight>
- <height>
- <measurementValue unitOfMeasure="IN">
<value>36</value>
</measurementValue>
</height>
<isNetContentDeclarationIndicated>false</isNetContentDeclarationIndicated>
- <width>
- <measurementValue unitOfMeasure="IN">
<value>32</value>
</measurementValue>
</width>
- <diameter>
- <measurementValue unitOfMeasure="IN">
<value>48</value>
</measurementValue>
</diameter>
- <drainedWeight>
- <measurementValue unitOfMeasure="LB">
<value>25</value>
</measurementValue>
</drainedWeight>
<genericIngredient>Generic Ingredient</genericIngredient>
- <genericIngredientStrength>
- <measurementValue unitOfMeasure="LB">
<value>1</value>
</measurementValue>
</genericIngredientStrength>
<ingredientStrength>IngredientStrength</ingredientStrength>
- <netContent>
- <measurementValue unitOfMeasure="PL">
<value>2500</value>
</measurementValue>
</netContent>
- <netWeight>
- <measurementValue unitOfMeasure="LB">
<value>2</value>
</measurementValue>
</netWeight>
- <pegMeasurements>
<pegHoleNumber>999</pegHoleNumber>
- <pegHorizontal>
- <measurementValue unitOfMeasure="IN">
<value>18</value>
</measurementValue>
</pegHorizontal>
- <pegVertical>
- <measurementValue unitOfMeasure="IN">
<value>3</value>
</measurementValue>
</pegVertical>
</pegMeasurements>
<priceComparisonContentType>PER_DOSE</priceComparisonContentType>
- <priceComparisonMeasurement>
- <measurementValue unitOfMeasure="PDO">
<value>25</value>
</measurementValue>
</priceComparisonMeasurement>
</tradeItemMeasurements>
- <tradeItemOrderInformation>
- <orderingLeadTime>
- <measurementValue unitOfMeasure="D">
<value>3</value>
</measurementValue>
</orderingLeadTime>
<orderQuantityMaximum>100</orderQuantityMaximum>
<orderQuantityMinimum>1</orderQuantityMinimum>
<orderQuantityMultiple>1</orderQuantityMultiple>
- <orderSizingFactor>
- <measurementValue unitOfMeasure="AS">
<value>24</value>
</measurementValue>
</orderSizingFactor>
<agreedMinimumBuyingQuantity>999</agreedMinimumBuyingQuantity>
<firstDeliveryDateTime>2004-12-31T00:00:00</firstDeliveryDateTime>
<isTradeItemReorderable>false</isTradeItemReorderable>
</tradeItemOrderInformation>
- <tradeItemPalletInformation>
<palletTypeCode>1</palletTypeCode>
<palletTermsAndConditions>1</palletTermsAndConditions>
</tradeItemPalletInformation>
- <cataloguePrice>
<effectiveStartDate>2003-08-13</effectiveStartDate>
<effectiveEndDate>2004-08-13</effectiveEndDate>
- <tradeItemPrice>
- <currencyCode>
<currencyISOCode>USD</currencyISOCode>
</currencyCode>
<value>24</value>
</tradeItemPrice>
</cataloguePrice>
- <suggestedRetailPrice>
<effectiveStartDate>2003-08-13</effectiveStartDate>
<effectiveEndDate>2004-08-13</effectiveEndDate>
- <tradeItemPrice>
- <currencyCode>
<currencyISOCode>USD</currencyISOCode>
</currencyCode>
<value>35</value>
</tradeItemPrice>
</suggestedRetailPrice>
- <tradeItemSizeDescription>
<sizeCodeListAgency>SCA</sizeCodeListAgency>
<sizeCodeValue>Code value</sizeCodeValue>
- <descriptiveSize>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<shortText>Size description</shortText>
</descriptiveSize>
</tradeItemSizeDescription>
- <tradeItemTemperatureInformation>
- <deliveryToDistributionCenterTemperatureMaximum>
- <measurementValue unitOfMeasure="C">
<value>45</value>
</measurementValue>
</deliveryToDistributionCenterTemperatureMaximum>
- <deliveryToDistributionCenterTemperatureMinimum>
- <measurementValue unitOfMeasure="C">
<value>23</value>
</measurementValue>
</deliveryToDistributionCenterTemperatureMinimum>
- <deliveryToMarketTemperatureMaximum>
- <measurementValue unitOfMeasure="C">
<value>45</value>
</measurementValue>
</deliveryToMarketTemperatureMaximum>
- <deliveryToMarketTemperatureMinimum>
- <measurementValue unitOfMeasure="C">
<value>23</value>
</measurementValue>
</deliveryToMarketTemperatureMinimum>
- <storageHandlingTemperatureMaximum>
- <measurementValue unitOfMeasure="C">
<value>56</value>
</measurementValue>
</storageHandlingTemperatureMaximum>
- <storageHandlingTemperatureMinimum>
- <measurementValue unitOfMeasure="C">
<value>32</value>
</measurementValue>
</storageHandlingTemperatureMinimum>
- <storageHandlingHumidityMaximum>
- <measurementValue unitOfMeasure="P1">
<value>999</value>
</measurementValue>
</storageHandlingHumidityMaximum>
- <storageHandlingHumidityMinimum>
- <measurementValue unitOfMeasure="P1">
<value>999</value>
</measurementValue>
</storageHandlingHumidityMinimum>
</tradeItemTemperatureInformation>
- <tradeItemCountryOfAssembly>
<countryISOCode>840</countryISOCode>
</tradeItemCountryOfAssembly>
</tradingPartnerNeutralTradeItemInformation>
</tradeItemInformation>
- <extension>
- <wwre:itemDataExtension xsi:schemaLocation="urn:wwre:item:4 xmlns:wwre="urn:wwre:item:4">
- <tradeItemPriceInformation>
- <suggestedRetailPriceOfSubstituedTradeItem>
- <amount>
- <currencyCode>
<currencyISOCode>USD</currencyISOCode>
</currencyCode>
<monetaryAmount>25.75</monetaryAmount>
</amount>
</suggestedRetailPriceOfSubstituedTradeItem>
<supplierAdvertising>false</supplierAdvertising>
</tradeItemPriceInformation>
- <tradeItemDateInformation>
<lastSaleDate>2004-12-31</lastSaleDate>
<withdrawalDate>2004-12-31</withdrawalDate>
<expirationDate>2004-12-31</expirationDate>
</tradeItemDateInformation>
- <tradeItemInformation>
- <flavor>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Strong Cinnamon</text>
</description>
</flavor>
<isANewTradeItem>false</isANewTradeItem>
- <tradeItemCountryOfDelivery>
- <country>
<countryISOCode>840</countryISOCode>
</country>
</tradeItemCountryOfDelivery>
<eUR1Indicator>false</eUR1Indicator>
<eUR2Indicator>false</eUR2Indicator>
</tradeItemInformation>
- <tradeItemMarking>
<returnableTradeItemStartDate>2003-12-31</returnableTradeItemStartDate>
<returnableTradeItemEndDate>2004-12-31</returnableTradeItemEndDate>
</tradeItemMarking>
- <tradeItemMeasurements>
- <basePriceRelevantNetContent>
- <measurementValue unitOfMeasure="EA">
<value>18</value>
</measurementValue>
</basePriceRelevantNetContent>
<mgsOfEphedrine>12.1234</mgsOfEphedrine>
<mgsOfPsuedoEphedrine>12.1234</mgsOfPsuedoEphedrine>
- <gratisWeightOrVolume>
- <measurementValue unitOfMeasure="IN">
<value>18</value>
</measurementValue>
</gratisWeightOrVolume>
<gratisAdditionalOrIncluded>0</gratisAdditionalOrIncluded>
</tradeItemMeasurements>
- <tradeItemOrderInformation>
<reorderableLeadTime>999</reorderableLeadTime>
<minimumShip>999</minimumShip>
</tradeItemOrderInformation>
- <tradeItemHandlingInformation>
<minimumTradeItemLifespanFromTimeOfProductionType>2</minimumTradeItemLifespanFromTimeOfProductionType>
- <handlingInstructions>
- <description>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<text>Instruction Text</text>
</description>
</handlingInstructions>
<handlingInstructionsCodeAgency>Agency Name</handlingInstructionsCodeAgency>
</tradeItemHandlingInformation>
- <tradeItemHazardousInformation>
<aerosolLevelHandling>Text</aerosolLevelHandling>
<flammableLevelHandling>Text</flammableLevelHandling>
</tradeItemHazardousInformation>
- <tradeItemMiscellaneousInformation>
<picturePath>URL for picture</picturePath>
- <freeFormComments>
- <longDescription>
- <language>
<languageISOCode>en</languageISOCode>
</language>
<longText>Comment</longText>
</longDescription>
</freeFormComments>
</tradeItemMiscellaneousInformation>
</wwre:itemDataExtension>
- <wwre:fMCGItemDataExtension xsi:schemaLocation="urn:wwre:item:4 xmlns:wwre="urn:wwre:item:4">
<quantityOfPortions unitOfMeasure="CU">1</quantityOfPortions>
<quantityOfCalories unitOfMeasure="CU">3.14</quantityOfCalories>
<caloriesRDVPercentage>3.14</caloriesRDVPercentage>
<quantityOfCarbohydrates unitOfMeasure="CU">3.14</quantityOfCarbohydrates>
<carbohydratesRDVPercentage>3.14</carbohydratesRDVPercentage>
<quantityOfProtein unitOfMeasure="CU">3.14</quantityOfProtein>
<proteinRDVPercentage>3.14</proteinRDVPercentage>
<quantityOfTotalFat unitOfMeasure="APZ">3.14</quantityOfTotalFat>
<totalFatRDVPercentage>3.14</totalFatRDVPercentage>
<quantityOfSaturatedFat unitOfMeasure="CU">3.14</quantityOfSaturatedFat>
<saturatedFatRDVPercentage>3.14</saturatedFatRDVPercentage>
<quantityOfCholesterol unitOfMeasure="CU">3.14</quantityOfCholesterol>
<cholesterolRDVPercentage>3.14</cholesterolRDVPercentage>
<quantityOfDietaryFiber unitOfMeasure="CU">3.14</quantityOfDietaryFiber>
<dietaryFiberRDVPercentage>3.14</dietaryFiberRDVPercentage>
<quantityOfCalcium unitOfMeasure="CU">3.14</quantityOfCalcium>
<calciumRDVPercentage>3.14</calciumRDVPercentage>
<quantityOfIron unitOfMeasure="CU">3.14</quantityOfIron>
<ironRDVPercentage>3.14</ironRDVPercentage>
<quantityOfSodium unitOfMeasure="CU">3.14</quantityOfSodium>
<sodiumRDVPercentage>3.14</sodiumRDVPercentage>
</wwre:fMCGItemDataExtension>
- <wwre:transoraCRItemDataExtension xsi:schemaLocation="urn:wwre:item:4 xmlns:wwre="urn:wwre:item:4">
- <tradeItemPriceDateInformation>
- <cataloguePrice>
<unitOfMeasure>PL</unitOfMeasure>
<basisQuantity>125</basisQuantity>
</cataloguePrice>
- <suggestedRetailPrice>
<unitOfMeasure>PL</unit
 
Sort by date Sort by votes
You use xml source adapter
XML Source adapter

- Drag and drop a Data Flow task from the toolbox

- Double-click on the added task

- Double-click on the XML Source in the data flow toolbox

- Double-click added component on the diagram

Thanks and Regards,
Siva
 
Upvote 0 Downvote
Siva,
I had a few days off... :)
I have already done what you said before. However, getting to where I was with your method was much faster. I am still stuck once I got to where you left me off. It is looking for either a schema or an XSD file. When I went to generate the xsd file I get the following error:

Unable to infer the XSD file from the XML file. The XML file contains multiple namespaces.

If you cut and paste the code I have in there, you will probably get the same error.

Any suggestions ?

Remember when... everything worked and there was a reason for it?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Editing Mappings Data Types in SSIS
Replies
0
Views
307
grnzbra
grnzbra
grnzbra
  • Locked
  • Question
Excel Import Maps 255 Char Max
Replies
0
Views
296
grnzbra
grnzbra
kfschaefer0727
  • Locked
  • Question
New to SSIS - Create pkg to validate data, does it exists in a table
Replies
0
Views
270
kfschaefer0727
kfschaefer0727
appelq
  • Locked
  • Question
SSIS import from CSV is truncating the Decimal 1
Replies
2
Views
421
appelq
appelq
Vronsky
  • Locked
  • Question
SSIS importing flat file (CSV)
Replies
0
Views
263
Vronsky
Vronsky

Part and Inventory Search

Sponsor

Back
Top