cXML Order Request to UBL Order

["Marzka, Jeremy" <JMarzka@kaydon.com>]

Hi,

 

I am in the process of mapping trading partner documents in various formats to a UBL Order layout. The document I am currently working on is a cXML Order Request and I am not sure where to map the following header fields:

 

1. Order total
2. Third party billing
3. Drop ship PO/release
4. Payment terms
5. Ship Complete (For the header)

 

Any suggestions would be greatly appreciated. I’d also be interested to hear what your process is to find equivalent fields in UBL. It seems to me like there isn’t much documentation for the recommended use of the fields.

 

cXML

http://pastebin.com/f3b448f3

 

UBL

http://pastebin.com/f28fe62e3

 

cXML

<?xml version="1.0" encoding="utf-8"?>

<cXML version="1.2.007" payloadID="Payload1" timestamp="2002-08-01T09:35:09-0500" xml:lang="en">

  <Header>

    <From>

      <Credential domain="DUNS">

        <Identity>111111111</Identity>

      </Credential>

    </From>

    <To>

      <Credential domain="DUNS">

        <Identity>222222222</Identity>

      </Credential>

    </To>

    <Sender>

      <Credential domain="DUNS">

        <Identity>111111111</Identity>

        <SharedSecret />

      </Credential>

      <UserAgent />

    </Sender>

  </Header>

  <Request>

    <OrderRequest>

      <OrderRequestHeader orderID="Order1234" orderDate="2002-07-25T00:00:00-0500" type="new" shipComplete="yes">

        <Total>

          <Money currency="USD">74.09</Money>

        </Total>

        <ShipTo>

          <Address isoCountryCode="US">

            <Name xml:lang="en">TEST ACCOUNT</Name>

            <PostalAddress>

              <Street>123 MAIN STREET</Street>

              <Street>Suite 456</Street>

              <City>Muskegon</City>

              <State>MI</State>

              <PostalCode>49441</PostalCode>

              <Country isoCountryCode="US">US</Country>

            </PostalAddress>

          </Address>

        </ShipTo>

        <BillTo>

          <Address isoCountryCode="US" addressID="100">

            <Name xml:lang="en">Corp Test Account</Name>

            <PostalAddress>

              <Street>P.O. Box 1234</Street>

              <City>Ann Arbor</City>

              <State>MI</State>

              <PostalCode>44101</PostalCode>

              <Country isoCountryCode="US">US</Country>

            </PostalAddress>

          </Address>

        </BillTo>

        <Shipping>

          <Money currency="USD" />

          <Description xml:lang="en">U2</Description>

        </Shipping>

        <Contact>

          <Name xml:lang="en">BRCH MGR</Name>

          <Email>mail@mail.com</Email>

          <Phone>

            <TelephoneNumber>

              <CountryCode isoCountryCode="US" />

              <AreaOrCityCode>123</AreaOrCityCode>

              <Number>4567890</Number>

            </TelephoneNumber>

          </Phone>

          <Fax>

            <TelephoneNumber>

              <CountryCode isoCountryCode="US" />

              <AreaOrCityCode>123</AreaOrCityCode>

              <Number>4567890</Number>

            </TelephoneNumber>

          </Fax>

        </Contact>

        <Extrinsic name="SoldToName">PRGMR TEST BR</Extrinsic>

        <Extrinsic name="SoldToID">200</Extrinsic>

        <Extrinsic name="SoldToAddr">1234 State St.</Extrinsic>

        <Extrinsic name="SoldToCity">Grand Rapids</Extrinsic>

        <Extrinsic name="SoldToState">MI</Extrinsic>

        <Extrinsic name="SoldToPostalCode">49504</Extrinsic>

        <Extrinsic name="SoldToCountry">US</Extrinsic>

        <Extrinsic name="OrderType">RG</Extrinsic>

        <Extrinsic name="OEMCustomerID">12345</Extrinsic>

        <Extrinsic name="QuoteNumber">Quote1</Extrinsic>

        <Extrinsic name="ShippingPriority">C</Extrinsic>

        <Extrinsic name="PaymentTerms">NET 30</Extrinsic>

        <Extrinsic name="FOBCode">1</Extrinsic>

        <Extrinsic name="FOBDescription">Origin: Freight-Collect</Extrinsic>

        <Extrinsic name="SoldToName">PRGMR TEST BR</Extrinsic>

        <Extrinsic name="ThirdPartyID">abcde</Extrinsic>

        <Extrinsic name="ThirdPartyName">CustomerCustomer</Extrinsic>

        <Extrinsic name="ThirdPartyAddr">654 Henry St</Extrinsic>

        <Extrinsic name="ThirdPartyCity">Grand Rapids</Extrinsic>

        <Extrinsic name="ThirdPartyState">MI</Extrinsic>

        <Extrinsic name="ThirdPartyPostalCode">49504</Extrinsic>

        <Extrinsic name="ThirdPartyCountry">US</Extrinsic>

        <Extrinsic name="DropShipPO">DS_PONUM123</Extrinsic>

        <Extrinsic name="DropShipRelease">DS_RELNUM456</Extrinsic>

        <Extrinsic name="Rework">R</Extrinsic>

        <Extrinsic name="FaxShipNotice">Y</Extrinsic>

        <Extrinsic name="FaxShipNoticeTo">Joe Smith</Extrinsic>

        <Extrinsic name="Note">THIS IS A HEADER COMMENT 1</Extrinsic>

        <Extrinsic name="Note">THIS IS ANOTHER TEST COMMENT 2</Extrinsic>

        <Extrinsic name="Note">THIS IS ANOTHER TEST COMMENT 3</Extrinsic>

      </OrderRequestHeader>

      <ItemOut quantity="5" lineNumber="1" requestedDeliveryDate="2002-08-15T00:00:00-0500">

        <ItemID>

          <SupplierPartID>1234B7</SupplierPartID>

        </ItemID>

        <ItemDetail>

          <UnitPrice>

            <Money currency="USD">2.018</Money>

          </UnitPrice>

          <Description xml:lang="en">52385330000100</Description>

          <UnitOfMeasure>EA</UnitOfMeasure>

          <Classification domain="" />

          <ManufacturerPartID>1234B7</ManufacturerPartID>

          <Extrinsic name="CustomerPartID">3111526</Extrinsic>

          <Extrinsic name="UPC">001234509876</Extrinsic>

          <Extrinsic name="SupplierWarehouseID">ABC123</Extrinsic>

          <Extrinsic name="SupplierSourceCode">6</Extrinsic>

          <Extrinsic name="Note">LINE 1 / COMMENT 1</Extrinsic>

          <Extrinsic name="Note">LINE 1 / COMMENT 2</Extrinsic>

          <Extrinsic name="Note">LINE 1 / COMMENT 3</Extrinsic>

        </ItemDetail>

      </ItemOut>

      <ItemOut quantity="8" lineNumber="2" requestedDeliveryDate="2002-07-25T00:00:00-0500">

        <ItemID>

          <SupplierPartID>165L050</SupplierPartID>

        </ItemID>

        <ItemDetail>

          <UnitPrice>

            <Money currency="USD">8.0</Money>

          </UnitPrice>

          <Description xml:lang="en">CASE STUDY #9 - REPLY</Description>

          <UnitOfMeasure>EA</UnitOfMeasure>

          <Classification domain="" />

          <ManufacturerPartID>165L050</ManufacturerPartID>

          <Extrinsic name="CustomerPartID">3110975</Extrinsic>

          <Extrinsic name="UPC">001234523456</Extrinsic>

          <Extrinsic name="SupplierWarehouseID">ABC123</Extrinsic>

          <Extrinsic name="Note">LINE 2 / COMMENT 1</Extrinsic>

          <Extrinsic name="Note">LINE 2 / COMMENT 2</Extrinsic>

          <Extrinsic name="Note">LINE 2 / COMMENT 3</Extrinsic>

          <Extrinsic name="Note">LINE 2 / COMMENT 4</Extrinsic>

          <Extrinsic name="Note">LINE 2 / COMMENT 5</Extrinsic>

        </ItemDetail>

      </ItemOut>

    </OrderRequest>

  </Request>

</cXML>

 

UBL:

<?xml version="1.0" encoding="utf-8"?>

<Order xmlns:cbc="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2"

            xmlns:cac="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2"

            xmlns="urn:oasis:names:specification:ubl:schema:xsd:Order-2">

 

  <cbc:UBLVersionID>2.0</cbc:UBLVersionID>   

 

  <cbc:ID>Order1234</cbc:ID>

 

  <cbc:IssueDate>2002-07-25</cbc:IssueDate>

 

  <cbc:Note>THIS IS A HEADER COMMENT 1</cbc:Note>

  <cbc:Note>THIS IS ANOTHER TEST COMMENT 2</cbc:Note>

  <cbc:Note>THIS IS ANOTHER TEST COMMENT 3</cbc:Note>

 

  <cbc:CustomerReference>OrderRef1</cbc:CustomerReference>

 

  <cac:QuotationDocumentReference>

    <cbc:ID>Quote1</cbc:ID>

  </cac:QuotationDocumentReference>

 

  <cac:AdditionalDocumentReference>

            <cbc:ID>Payload1</cbc:ID>

  </cac:AdditionalDocumentReference>

 

  <cac:BuyerCustomerParty>

    <cbc:CustomerAssignedAccountID>200</cbc:CustomerAssignedAccountID>

    <cbc:AdditionalAccountID>12345</cbc:AdditionalAccountID>

    <cac:Party>

              <cac:PartyIdentification>

                <cbc:ID schemeURI="http://www.dnb.com/US/duns_update/">111111111</cbc:ID>

              </cac:PartyIdentification>   

      <cac:PartyName>

            <cbc:Name>PRGMR TEST BR</cbc:Name>

      </cac:PartyName>

      <cac:PostalAddress>

        <cbc:CityName>Grand Rapids</cbc:CityName>

        <cbc:PostalZone>49504</cbc:PostalZone>

        <cbc:CountrySubentityCode>MI</cbc:CountrySubentityCode>

        <cac:AddressLine>

          <cbc:Line>1234 State St.</cbc:Line>

        </cac:AddressLine>

        <cac:Country>

          <cbc:IdentificationCode>US</cbc:IdentificationCode>

        </cac:Country>

      </cac:PostalAddress>

      <cac:Contact>

        <cbc:Name>BRCH MGR</cbc:Name>

        <cbc:Telephone>1234567890</cbc:Telephone>

        <cbc:Telefax>1234567890</cbc:Telefax>

        <cbc:ElectronicMail>mail@mail.com</cbc:ElectronicMail>

      </cac:Contact>

    </cac:Party>

  </cac:BuyerCustomerParty>

 

  <cac:SellerSupplierParty>

            <cac:Party>

              <cac:PartyIdentification>

                <cbc:ID schemeURI="http://www.dnb.com/US/duns_update/">222222222</cbc:ID>

              </cac:PartyIdentification>

            </cac:Party>

  </cac:SellerSupplierParty>

 

  <cac:AccountingCustomerParty>

    <cbc:CustomerAssignedAccountID>100</cbc:CustomerAssignedAccountID>

    <cac:Party>

      <cac:PartyName>

            <cbc:Name>Corp Test Account</cbc:Name>

      </cac:PartyName>

      <cac:PostalAddress>

        <cbc:CityName>Ann Arbor</cbc:CityName>

        <cbc:PostalZone>44101</cbc:PostalZone>

        <cbc:CountrySubentityCode>MI</cbc:CountrySubentityCode>

        <cac:AddressLine>

          <cbc:Line>P.O. Box 1234</cbc:Line>

        </cac:AddressLine>

        <cac:Country>

          <cbc:IdentificationCode>US</cbc:IdentificationCode>

        </cac:Country>

      </cac:PostalAddress>

    </cac:Party>

  </cac:AccountingCustomerParty>

 

  <cac:Delivery>

    <cac:RequestedDeliveryPeriod>

      <cbc:EndDate>2010-12-30</cbc:EndDate>

    </cac:RequestedDeliveryPeriod>

    <cac:DeliveryParty>

      <cac:PostalAddress>

        <cbc:ID>1234</cbc:ID>

        <cbc:CityName>Muskegon</cbc:CityName>

        <cbc:PostalZone>49441</cbc:PostalZone>

        <cbc:CountrySubentityCode>MI</cbc:CountrySubentityCode>

        <cac:AddressLine>

          <cbc:Line>TEST ACCOUNT</cbc:Line>

        </cac:AddressLine>

        <cac:AddressLine>

          <cbc:Line>123 MAIN STREET</cbc:Line>

        </cac:AddressLine>

        <cac:AddressLine>

          <cbc:Line>Suite 456</cbc:Line>

        </cac:AddressLine>

        <cac:Country>

          <cbc:IdentificationCode>US</cbc:IdentificationCode>

        </cac:Country>

      </cac:PostalAddress>

      <cac:Contact>

        <cbc:Name>Joe Smith</cbc:Name>

        <cbc:Telefax>1234567890</cbc:Telefax>

      </cac:Contact>

    </cac:DeliveryParty>

    <cac:Despatch>

      <cac:DespatchParty>

        <cac:PartyName>

          <cbc:Name>UPS Ground</cbc:Name>

        </cac:PartyName>

      </cac:DespatchParty>

    </cac:Despatch>

  </cac:Delivery>

 

  <cac:DeliveryTerms>

    <cbc:ID>FOB</cbc:ID>

    <cbc:SpecialTerms>Origin: Freight-Collect</cbc:SpecialTerms>

  </cac:DeliveryTerms>

 

  <cac:OrderLine>

    <cac:LineItem>

      <cbc:ID>1</cbc:ID>

      <cbc:Note>LINE 1 / COMMENT 1

      LINE 1 / COMMENT 2

      LINE 1 / COMMENT 3</cbc:Note>

      <cbc:Quantity unitCode="EA">5</cbc:Quantity>

      <cac:Delivery>

        <cac:RequestedDeliveryPeriod>

          <cbc:EndDate>2002-08-15</cbc:EndDate>

        </cac:RequestedDeliveryPeriod>

      </cac:Delivery>

      <cac:Price>

        <cbc:PriceAmount currencyID="USD">2.018</cbc:PriceAmount>

      </cac:Price>

      <cac:Item>

        <cbc:Description>52385330000100</cbc:Description>

        <cac:BuyersItemIdentification>

          <cbc:ID>3111526</cbc:ID>

        </cac:BuyersItemIdentification>

        <cac:SellersItemIdentification>

          <cbc:ID>1234B7</cbc:ID>

        </cac:SellersItemIdentification>

        <cac:StandardItemIdentification>

          <cbc:ID>001234509876</cbc:ID>

        </cac:StandardItemIdentification>

        <cac:ManufacturerParty>

          <cac:PartyIdentification>

            <cbc:ID>ABC123</cbc:ID>

          </cac:PartyIdentification>

        </cac:ManufacturerParty>

      </cac:Item>

    </cac:LineItem>

  </cac:OrderLine>

 

  <cac:OrderLine>

    <cac:LineItem>

      <cbc:ID>2</cbc:ID>

      <cbc:Note>LINE 2 / COMMENT 1

      LINE 2 / COMMENT 2

      LINE 2 / COMMENT 3

      LINE 2 / COMMENT 4

      LINE 2 / COMMENT 5</cbc:Note>

      <cbc:Quantity unitCode="EA">8</cbc:Quantity>

      <cac:Delivery>

        <cac:RequestedDeliveryPeriod>

          <cbc:EndDate>2002-07-25</cbc:EndDate>

        </cac:RequestedDeliveryPeriod>

      </cac:Delivery>

      <cac:Price>

        <cbc:PriceAmount currencyID="USD">8.00</cbc:PriceAmount>

      </cac:Price>

      <cac:Item>

        <cbc:Description>CASE STUDY #9 - REPLY</cbc:Description>

        <cac:BuyersItemIdentification>

          <cbc:ID>3110975</cbc:ID>

        </cac:BuyersItemIdentification>

        <cac:SellersItemIdentification>

          <cbc:ID>165L050</cbc:ID>

        </cac:SellersItemIdentification>

        <cac:StandardItemIdentification>

          <cbc:ID>001234523456</cbc:ID>

        </cac:StandardItemIdentification>

        <cac:ManufacturerParty>

          <cac:PartyIdentification>

            <cbc:ID>ABC123</cbc:ID>

          </cac:PartyIdentification>

        </cac:ManufacturerParty>

      </cac:Item>

    </cac:LineItem>

  </cac:OrderLine>

</Order>

 

Thanks

Jeremy