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:

Download the mapping file for a document's workflow.
Open the Transactions page and locate the document.
Expand the entry to expose the Views pane.
Click the first Raw link to open the X12 EDI content for the document.
Click the second Raw link to open the same content converted to xCBL format.
In the X12 EDI file, locate the field to be transformed and note the EDI element code.
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