ok.. looks like we are not going to get a simpler xml..
How would you handle something like the following?
---------------------------------
<?xml version="1.0"?>
<NewDataSet>
<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="Status">
<xs:complexType>
<xs:attribute name="Code" type="xs:string" />
<xs:attribute name="Description" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="DeliveryStatus">
<xs:complexType>
<xs:attribute name="Code" type="xs:string" />
<xs:attribute name="Description" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="SAPPartner">
<xs:complexType>
<xs:attribute name="CodeofPartner" type="xs:string" />
<xs:attribute name="EmailAddress" type="xs:string" />
<xs:attribute name="ID" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="Prices">
<xs:complexType>
<xs:attribute name="Discount" type="xs:string" />
<xs:attribute name="Freight" type="xs:string" />
<xs:attribute name="Gross" type="xs:string" />
<xs:attribute name="Net" type="xs:string" />
<xs:attribute name="NetNoDiscount" type="xs:string" />
<xs:attribute name="Other" type="xs:string" />
<xs:attribute name="Tax" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="ABCVendorOrder">
<xs:complexType>
<xs:sequence>
<xs:element name="TransmissionHistory" type="xs:string" minOccurs="0" msdata:Ordinal="0" />
<xs:element ref="Status" minOccurs="0" maxOccurs="unbounded" />
<xs:element name="RejectionStatus" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="Code" type="xs:string" />
<xs:attribute name="Description" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element ref="DeliveryStatus" minOccurs="0" maxOccurs="unbounded" />
<xs:element name="CreditStatus" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="Code" type="xs:string" />
<xs:attribute name="Description" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="FreightPaymentMethod" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="Code" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="ShipMethod" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="Code" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="Department" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="Code" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="SalesClass" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="Code" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="Terms" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="Code" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="PricePage" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="Code" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="Vendor" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="CodeofPartner" type="xs:string" />
<xs:attribute name="EmailAddress" type="xs:string" />
<xs:attribute name="ID" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="SalesRep" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="CodeofPartner" type="xs:string" />
<xs:attribute name="EmailAddress" type="xs:string" />
<xs:attribute name="ID" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="SoldTo" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="CodeofPartner" type="xs:string" />
<xs:attribute name="EmailAddress" type="xs:string" />
<xs:attribute name="ID" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="ShipTo" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="CodeofPartner" type="xs:string" />
<xs:attribute name="EmailAddress" type="xs:string" />
<xs:attribute name="ID" type="xs:string" />
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="Identification" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="Date" type="xs:string" />
<xs:attribute name="FromOrg_ID" type="xs:string" />
<xs:attribute name="MessageProtocol_ID" type="xs:string" />
<xs:attribute name="Reference_ID" type="xs:string" />
<xs:attribute name="SenderOrg_ID" type="xs:string" />
<xs:attribute name="ToOrg_ID" type="xs:string" />
<xs:attribute name="TransmissionDate" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="SoldToAddress" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element ref="SAPPartner" minOccurs="0" maxOccurs="unbounded" />
</xs:sequence>
<xs:attribute name="AddressType" type="xs:string" />
<xs:attribute name="BusinessName" type="xs:string" />
<xs:attribute name="City" type="xs:string" />
<xs:attribute name="ContactName" type="xs:string" />
<xs:attribute name="CountryAbbreviation" type="xs:string" />
<xs:attribute name="Email" type="xs:string" />
<xs:attribute name="Fax" type="xs:string" />
<xs:attribute name="Line1" type="xs:string" />
<xs:attribute name="Line2" type="xs:string" />
<xs:attribute name="Phone" type="xs:string" />
<xs:attribute name="PostalCode" type="xs:string" />
<xs:attribute name="StateAbbreviation" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="ShipToAddress" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element ref="SAPPartner" minOccurs="0" maxOccurs="unbounded" />
</xs:sequence>
<xs:attribute name="AddressType" type="xs:string" />
<xs:attribute name="BusinessName" type="xs:string" />
<xs:attribute name="City" type="xs:string" />
<xs:attribute name="ContactName" type="xs:string" />
<xs:attribute name="CountryAbbreviation" type="xs:string" />
<xs:attribute name="Email" type="xs:string" />
<xs:attribute name="Fax" type="xs:string" />
<xs:attribute name="Line1" type="xs:string" />
<xs:attribute name="Line2" type="xs:string" />
<xs:attribute name="Phone" type="xs:string" />
<xs:attribute name="PostalCode" type="xs:string" />
<xs:attribute name="StateAbbreviation" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="Items" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="LineItem" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element ref="Status" minOccurs="0" maxOccurs="unbounded" />
<xs:element ref="DeliveryStatus" minOccurs="0" maxOccurs="unbounded" />
<xs:element ref="Prices" minOccurs="0" maxOccurs="unbounded" />
</xs:sequence>
<xs:attribute name="Comments" type="xs:string" />
<xs:attribute name="ConfirmedPieces" type="xs:string" />
<xs:attribute name="ConfirmedTrays" type="xs:string" />
<xs:attribute name="Description" type="xs:string" />
<xs:attribute name="IsUnlistedItem" type="xs:string" />
<xs:attribute name="Line" type="xs:string" />
<xs:attribute name="Material" type="xs:string" />
<xs:attribute name="OrderedPieces" type="xs:string" />
<xs:attribute name="OrderedTrays" type="xs:string" />
<xs:attribute name="PiecesPerTray" type="xs:string" />
<xs:attribute name="ScheduledShipDate" type="xs:string" />
<xs:attribute name="ShippedPieces" type="xs:string" />
<xs:attribute name="ShippedTrays" type="xs:string" />
<xs:attribute name="VendorDescription" type="xs:string" />
<xs:attribute name="VendorMaterial" type="xs:string" />
<xs:attribute name="WeekCode" type="xs:string" />
<xs:attribute name="WhereFoundFlag" type="xs:string" />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element ref="Prices" minOccurs="0" maxOccurs="unbounded" />
<xs:element name="Routing" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="Action" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="Password" type="xs:string" />
<xs:attribute name="TrackDocument" type="xs:string" />
<xs:attribute name="URL" type="xs:string" />
<xs:attribute name="User" type="xs:string" />
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="Attempts" type="xs:string" />
<xs:attribute name="Type" type="xs:string" />
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="CustomerPO" type="xs:string" />
<xs:attribute name="CustomerPODate" type="xs:string" />
<xs:attribute name="DistributionChannel" type="xs:string" />
<xs:attribute name="Division" type="xs:string" />
<xs:attribute name="IsBackorderedProductOK" type="xs:string" />
<xs:attribute name="IsPackageSizeSubstitutionOK" type="xs:string" />
<xs:attribute name="IsProductSubstitutionOK" type="xs:string" />
<xs:attribute name="OrderType" type="xs:string" />
<xs:attribute name="OrderedBy" type="xs:string" />
<xs:attribute name="RequestedShipDate" type="xs:string" />
<xs:attribute name="SAPCreatedBy" type="xs:string" />
<xs:attribute name="SAPLastUpdated" type="xs:string" />
<xs:attribute name="SAPLastUpdatedBy" type="xs:string" />
<xs:attribute name="SAPOrderCreated" type="xs:string" />
<xs:attribute name="SAPOrderID" type="xs:string" />
<xs:attribute name="SAPQuoteOrderID" type="xs:string" />
<xs:attribute name="SAPReferenceID" type="xs:string" />
<xs:attribute name="SalesOrg" type="xs:string" />
<xs:attribute name="SpecialInstructions" type="xs:string" />
<xs:attribute name="TermsDate" type="xs:string" />
<xs:attribute name="Total_LineItems" type="xs:string" />
<xs:attribute name="Total_pieces" type="xs:string" />
<xs:attribute name="Total_trays" type="xs:string" />
<xs:attribute name="VendorOrderID" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element ref="Status" />
<xs:element ref="DeliveryStatus" />
<xs:element ref="SAPPartner" />
<xs:element ref="Prices" />
<xs:element ref="ABCVendorOrder" />
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<ABCVendorOrder CustomerPO="" CustomerPODate="0001-01-01T00:00:00.0000000-05:00" DistributionChannel="C1" Division="Brokerage_Z3" IsBackorderedProductOK="true" IsPackageSizeSubstitutionOK="true" IsProductSubstitutionOK="true" OrderType="Standard_ZOR3" OrderedBy="" RequestedShipDate="2006-07-03T00:00:00.0000000-04:00" SAPCreatedBy="PUTZEDWA" SAPLastUpdated="0001-01-01T00:00:00.0000000-05:00" SAPLastUpdatedBy="PUTZEDWA" SAPOrderCreated="2006-04-20T22:41:21.0000000-04:00" SAPOrderID="1907441" SAPQuoteOrderID="0" SAPReferenceID="" SalesOrg="US21" SpecialInstructions="" TermsDate="0001-01-01T00:00:00.0000000-05:00" Total_LineItems="18" Total_pieces="7400" Total_trays="7400" VendorOrderID="">
<TransmissionHistory />
<Status Code="X" Description="Open Order" Name="Unknown" />
<RejectionStatus Code="A" Description="" Name="Not_Processed" />
<DeliveryStatus Code="X" Description="null Code" Name="Unknown" />
<CreditStatus Code="X" Description="Unknown Code Passed in: D" Name="Unknown" />
<FreightPaymentMethod Code="ZPP" Name="Prepaid_and_Add" />
<ShipMethod Code="15" Name="Fed Ex Standard" />
<Department Code="N" Name="PLANTS" />
<SalesClass Code="PT" Name="WIDGETS" />
<Terms Code="US02" Name="US/30 days net" />
<PricePage Code="N625" />
<Vendor CodeofPartner="ZV" EmailAddress="" ID="90000278" Name="EFG" />
<SalesRep CodeofPartner="Z2" EmailAddress="hiho@ABC.com" ID="228856" Name="JOE JONES" />
<SoldTo CodeofPartner="SP" EmailAddress="" ID="69221" Name="xxx INC" />
<ShipTo CodeofPartner="SH" EmailAddress="" ID="69221" Name="XXX INC" />
<Identification Date="2006-04-21T12:25:05.5662533-04:00" FromOrg_ID="ABC" MessageProtocol_ID="ABCPurchaseOrder_V2" Reference_ID="0b5b1846-346c-4ef9-913e-2cf63da664dc" SenderOrg_ID="ABC" ToOrg_ID="XYZ" TransmissionDate="2006-04-21T13:25:05.5662533-04:00" />
<SoldToAddress AddressType="SoldTo" BusinessName="AAA Comp" City="BOISE" ContactName="SMITH" CountryAbbreviation="US" Email="" Fax="(123) 456-7890" Line1="1234 MAIN ST" Line2="" Phone="(123) 456-7890" PostalCode="99999" StateAbbreviation="ID">
<SAPPartner CodeofPartner="SP" EmailAddress="" ID="69221" Name="BBBBB" />
</SoldToAddress>
<ShipToAddress AddressType="ShipTo" BusinessName="BBBBB" City="BOISE" ContactName="SMITH" CountryAbbreviation="US" Email="" Fax="(111) 222-3333" Line1="1234 MAIN ST" Line2="" Phone="(111) 222-3333" PostalCode="83703" StateAbbreviation="ID">
<SAPPartner CodeofPartner="SH" EmailAddress="" ID="69221" Name="BBBB" />
</ShipToAddress>
<Items>
<LineItem Comments="" ConfirmedPieces="100" ConfirmedTrays="-1" Description="PLANT AAA OASIS WDG" IsUnlistedItem="false" Line="10" Material="441922" OrderedPieces="100" OrderedTrays="-1" PiecesPerTray="1" ScheduledShipDate="2006-07-03T00:00:00.0000000-04:00" ShippedPieces="-1" ShippedTrays="-1" VendorDescription="" VendorMaterial="" WeekCode="" WhereFoundFlag="S">
<Status Code="A" Description="" Name="Not_Processed" />
<DeliveryStatus Code="X" Description="null Code" Name="Unknown" />
<Prices Discount="0" Freight="0" Gross="0.6400" Net="64.00" NetNoDiscount="0.6400" Other="0" Tax="0" />
</LineItem>
<LineItem Comments="" ConfirmedPieces="200" ConfirmedTrays="-1" Description="PLANT BBB OASIS WDG" IsUnlistedItem="false" Line="20" Material="362297" OrderedPieces="200" OrderedTrays="-1" PiecesPerTray="1" ScheduledShipDate="2006-07-03T00:00:00.0000000-04:00" ShippedPieces="-1" ShippedTrays="-1" VendorDescription="" VendorMaterial="" WeekCode="" WhereFoundFlag="S">
<Status Code="A" Description="" Name="Not_Processed" />
<DeliveryStatus Code="X" Description="null Code" Name="Unknown" />
<Prices Discount="0" Freight="0" Gross="0.6400" Net="128.00" NetNoDiscount="0.6400" Other="0" Tax="0" />
</LineItem>
<LineItem Comments="" ConfirmedPieces="100" ConfirmedTrays="-1" Description="PLANT CCC OASIS WDG" IsUnlistedItem="false" Line="30" Material="113419" OrderedPieces="100" OrderedTrays="-1" PiecesPerTray="1" ScheduledShipDate="2006-07-03T00:00:00.0000000-04:00" ShippedPieces="-1" ShippedTrays="-1" VendorDescription="" VendorMaterial="" WeekCode="" WhereFoundFlag="S">
<Status Code="A" Description="" Name="Not_Processed" />
<DeliveryStatus Code="X" Description="null Code" Name="Unknown" />
<Prices Discount="0" Freight="0" Gross="0.6400" Net="64.00" NetNoDiscount="0.6400" Other="0" Tax="0" />
</LineItem>
<LineItem Comments="" ConfirmedPieces="300" ConfirmedTrays="-1" Description="PLANT DDD OASIS WDG" IsUnlistedItem="false" Line="40" Material="100084" OrderedPieces="300" OrderedTrays="-1" PiecesPerTray="1" ScheduledShipDate="2006-07-03T00:00:00.0000000-04:00" ShippedPieces="-1" ShippedTrays="-1" VendorDescription="" VendorMaterial="" WeekCode="" WhereFoundFlag="S">
<Status Code="A" Description="" Name="Not_Processed" />
<DeliveryStatus Code="X" Description="null Code" Name="Unknown" />
<Prices Discount="0" Freight="0" Gross="0.6400" Net="192.00" NetNoDiscount="0.6400" Other="0" Tax="0" />
</LineItem>
</Items>
<Prices Discount="0" Freight="0" Gross="4736.00" Net="4736.00" NetNoDiscount="0" Other="0" Tax="0" />
<Routing Attempts="0" Type="HTTP">
<Action Password="bbb" TrackDocument="1" URL="http://00.00.00.100/FFA_Receive/NewOrder.aspx" User="ccc" />
</Routing>
</ABCVendorOrder>
</NewDataSet>
