Skip to Content

XPath mapping file in Jitterbit EDI

Introduction

A mapping file is a downloadable reference file containing the XPaths for all X12 EDI segment element codes in a map, and shows how the EDI backend maps raw X12 EDI files to xCBL. This XPath information can be used in your Integration Studio or Design Studio transformations.

The file is a plain text file with a .csv extension containing comma-separated fields.

Use the mapping file

To use the mapping file in an Integration Studio or Design Studio project, follow these steps:

  1. Download the mapping file for a document's workflow.
  2. Open the Transactions page and locate the document.
  3. Expand the entry to expose the Views pane.
  4. Click the first Raw link to open the X12 EDI content for the document.
  5. Click the second Raw link to open the same content converted to xCBL format.
  6. In the X12 EDI file, locate the field to be transformed and note the EDI element code.
  7. In the XPath mapping file, find the EDI element code and corresponding XPath. Use the xCBL version to confirm the XPath and mapped value match.

Example

In this example, equivalent fields are highlighted in samples of an X12 EDI file, the converted xCBL file, and an extract of the XPath mapping file.

X12 EDI file (Purchase Order, 850)

example_850.edi

ISA*00*          *00*          *12*7703844115CHQT *02*9050999992211  *200107*1214*U*00401*000000006*0*T*>
GS*PO*7703844115CHQT*9050999992211*20230924*12142024*6*X*004010
ST*850*0002
BEG*00*SA*99340993**20230924*60006342
REF*X9*881807
REF*IA*60006342
REF*CO*W138156910
REF*DP*25
DTM*010*20230924
TD5*****UPSN
N9*SD*8119
N1*BT*Jane Smith
N3*2 Woodbridge Ave
N4*Edison*NJ*08837
PER*BD**TE*555-555-5555
N1*ST*Jane Smith
N3*2 Woodbridge Ave
N4*Edison*NJ*08837
PER*BD**TE*555-555-5555
N1*SO*Jane Smith*93*8119
N1*PO*Home Depot*93*8119
PO1*06*2*EA*9.7*TE*SK*H2520*VN*H2520***UP*H2520***PI*H2520
PID*F*08***BOOK LISTING
DTM*038*20610467
TD5*****UPSN
CTT*1
SE*25*0002
GE*7*6
IEA*1*000000007

xCBL file

example_850.xml
<Order>
  <OrderHeader>
    <OrderNumber>
      <BuyerOrderNumber>99340993</BuyerOrderNumber>
    </OrderNumber>
    <OrderIssueDate>2023-09-24T00:00:00</OrderIssueDate>
    <OrderReferences>
      <ContractReferences>
        <core:Contract>
          <core:ContractID>
            <core:Ident>60006342</core:Ident>
          </core:ContractID>
        </core:Contract>
      </ContractReferences>
      <OtherOrderReferences>
        <core:ReferenceCoded>
          <core:ReferenceTypeCoded>InternalControlNumber</core:ReferenceTypeCoded>
          <core:PrimaryReference>
            <core:RefNum>121521807</core:RefNum>
          </core:PrimaryReference>
        </core:ReferenceCoded>
        <core:ReferenceCoded>
          <core:ReferenceTypeCoded>InternalVendorNumber</core:ReferenceTypeCoded>
          <core:PrimaryReference>
            <core:RefNum>60006342</core:RefNum>
          </core:PrimaryReference>
        </core:ReferenceCoded>
        <core:ReferenceCoded>
          <core:ReferenceTypeCoded>CustomerOrderNumber</core:ReferenceTypeCoded>
          <core:PrimaryReference>
            <core:RefNum>W138156910</core:RefNum>
          </core:PrimaryReference>
        </core:ReferenceCoded>
        <core:ReferenceCoded>
          <core:ReferenceTypeCoded>DepartmentNumber</core:ReferenceTypeCoded>
          <core:PrimaryReference>
            <core:RefNum>25</core:RefNum>
          </core:PrimaryReference>
        </core:ReferenceCoded>
        <core:ReferenceCoded>
          <core:ReferenceTypeCoded>SubdayNumber</core:ReferenceTypeCoded>
          <core:PrimaryReference>
            <core:RefNum>8119</core:RefNum>
          </core:PrimaryReference>
        </core:ReferenceCoded>
      </OtherOrderReferences>
    </OrderReferences>
    <Purpose>
      <core:PurposeCoded>Other</core:PurposeCoded>
      <core:PurposeCodedOther>00</core:PurposeCodedOther>
    </Purpose>
    <OrderType>
      <core:OrderTypeCoded>Other</core:OrderTypeCoded>
      <core:OrderTypeCodedOther>SA</core:OrderTypeCodedOther>
    </OrderType>
    <OrderCurrency>
      <core:CurrencyCoded>Other</core:CurrencyCoded>
      <core:CurrencyCodedOther />
    </OrderCurrency>
    <OrderLanguage />
    <OrderDates>
      <ListOfDateCoded>
        <core:DateCoded>
          <core:DateQualifier>
            <core:DateQualifierCoded>RequestedShip</core:DateQualifierCoded>
          </core:DateQualifier>
          <core:Date>2023-09-11T00:00:00</core:Date>
        </core:DateCoded>
      </ListOfDateCoded>
      <RequestedShipByDate>2023-09-11T00:00:00</RequestedShipByDate>
    </OrderDates>
    <OrderParty>
      <BillToParty>
        <core:NameAddress>
          <core:Name1>Jane Smith</core:Name1>
          <core:Street>2 Woodbridge Ave</core:Street>
          <core:City>Edison</core:City>
          <core:Region>
            <core:RegionCoded>Other</core:RegionCoded>
            <core:RegionCodedOther>NJ</core:RegionCodedOther>
          </core:Region>
          <core:PostalCode>08837</core:PostalCode>
        </core:NameAddress>
        <core:PrimaryContact>
          <core:ContactFunction>
            <core:ContactFunctionCodedOther>BuyerNameOrDepartment</core:ContactFunctionCodedOther>
          </core:ContactFunction>
          <core:ListOfContactNumber>
            <core:ContactNumber>
              <core:ContactNumberTypeCoded>TelephoneNumber</core:ContactNumberTypeCoded>
              <core:ContactNumberValue>555-555-5555</core:ContactNumberValue>
            </core:ContactNumber>
          </core:ListOfContactNumber>
        </core:PrimaryContact>
      </BillToParty>

XPath mapping file (extract)

This table shows part of a sample mapping file downloaded from a partner's workflow. Rows not relevant to this example are omitted.

ShortName LongName XPath DataType
BEG01 Transaction Set Purpose Code Order/OrderHeader/Purpose[core:PurposeCoded='Other']/core:PurposeCodedOther string
BEG02 Purchase Order Type Code Order/OrderHeader/ListOfNameValueSet/core:NameValueSet[core:SetName='HeaderReferences']/core:ListOfNameValuePair/core:NameValuePair[core:Name='POType']/core:Value string
BEG03 Purchase Order Number Order/OrderHeader/OrderNumber/BuyerOrderNumber string
BEG05 Order Issue Date Order/OrderHeader/OrderIssueDate Date
BEG06 Contract Number Order/OrderHeader/OrderReferences/ContractReferences/core:Contract/core:ContractID/core:Ident string
BT-N102 Bill To Party Name Order/OrderHeader/OrderParty/BillToParty/core:NameAddress/core:Name1 string
BT-N103 Bill To Party Identification Code Qualifier Order/OrderHeader/ListOfNameValueSet/core:NameValueSet[core:SetName='PartyReferences']/core:ListOfNameValuePair/core:NameValuePair[core:Name='BillToPartyPartyIdentificationCodeQualifier']/core:Value string
BT-N104 Bill To Party Identification Code Order/OrderHeader/OrderParty/BillToParty/core:PartyID/core:Ident string
BT-N301 Bill To Party Address Line 1 Order/OrderHeader/OrderParty/BillToParty/core:NameAddress/core:Street string
BT-N302 Bill To Party Address Line 2 Order/OrderHeader/OrderParty/BillToParty/core:NameAddress/core:StreetSupplement1 string
BT-N401 Bill To Party City Order/OrderHeader/OrderParty/BillToParty/core:NameAddress/core:City string
BT-N402 Bill To Party State or Province Code Order/OrderHeader/OrderParty/BillToParty/core:NameAddress/core:Region[core:RegionCoded='Other']/core:RegionCodedOther string
BT-N403 Bill To Party Postal Code Order/OrderHeader/OrderParty/BillToParty/core:NameAddress/core:PostalCode string

Video

Jitterbit EDI XPath mapping tutorial