Upload file formats¶

Introduction¶

This section describes the valid file formats that can be uploaded with the Upload file for processing button on the Transactions page.

Examples are shown for each of the following supported file formats:

EDI (.edi)
EDIFACT (.edi)
TRADACOMS EDI (.edi)
XML (.xml)

In all examples, the following fields are highlighted:

Partner:
- Qualifier: AA
- ID: 0987654321WXYZ
Company:
- Qualifier: ZZ
- ID: 1234567890ABC

The examples are valid formats with dummy values. Partner and Company IDs must match those in your system. To find these, go to EDI > Admin, select a partner, then select EDI settings > Preferred ID:

Preferred ID

Example: EDI¶

example_EDI.edi

ISA*00*          *00*          *AA*0987654321WXYZ *ZZ*1234567890ABC  *200107*1214*U*00401*000000006*0*T*>
GS*PO*0987654321WXYZ*1234567890ABC*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

Example: EDIFACT¶

example_EDIFACT.edi

UNB+UNOA:2+0987654321WXYZ:AA+1234567890ABC:ZZ+230925:0158+1365++++1+EANCOM'UNH+1+ORDERS:D:96A:UN:EAN008'
BGM+220+2CZBKM5J+9'
DTM+137:20230925:102'
DTM+63:20230928:102'
DTM+64:20230924:102'
RFF+CR:AO5A4'
NAD+BY+5450534000024::9'
NAD+SU+8622560964::9'
NAD+DP+5450534007580::9+++++++GB'
NAD+IV+5450534007139::9++ACME LTD., UK BRANCH PRINCIPAL PLACE NOWHERE STREET+LONDON++EC1A 1AA+GB’
RFF+VA:GB727255821'
CUX+2:GBP:9'
LIN+1'
PIA+5+200258:SA'
QTY+21:120'
PRI+AAA:4.72'
LIN+2'PIA+5+200432:SA'
QTY+21:120'
PRI+AAA:4.9'
UNS+S'
CNT+2:2'
UNT+23+1'
UNZ+1+1365'

Example: TRADACOMS EDI¶

example_TRADACOMS.edi

STX=ANA:1+AA-0987654321WXYZ:ADITEST+ZZ-1234567890ABC: VENDOR NAME+9052204220:130233+000007+PASSWORD+ORDHDR+B'
MHD=1+ORDHDR:9'
TYP=0430'
SDT=5010000000000:000030034'
CDT=5013546018962'FIL=1630+1+070315'MTR=6'
MHD=2+ORDERS:9'
CLO=5000000000283:89828+EAST SOMEWHERE DEPOT'
ORD=70970::070315'
DIN=070321++0000'
OLD=1+5010210000000+114455441444:00893592:035921+12+60++++CRUSTY ROLLS:4 PACK'
OTR=1'
MTR=7'
MHD=3+ORDTLR:9'
OFT=1'
MTR=3'
END=3'

Example: XML¶

example_XML.xml

<?xml version="1.0" encoding="utf-8"?>
<Order xmlns="rrn:org.xcbl:schemas/xcbl/v4_0/ordermanagement/v1_0/ordermanagement.xsd" xmlns:core="rrn:org.xcbl:schemas/xcbl/v4_0/core/core.xsd" xmlns:dgs="http://www.w3.org/2000/09/xmldsig#" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 <OrderHeader>
   <OrderNumber>
     <BuyerOrderNumber>123</BuyerOrderNumber>
     <SellerOrderNumber>123</SellerOrderNumber>
   </OrderNumber>
   <OrderIssueDate>2023-01-01T00:00:00</OrderIssueDate>
   <OrderType>
     <core:OrderTypeCoded></core:OrderTypeCoded>
   </OrderType>
   <OrderCurrency>
     <core:CurrencyCoded>Other</core:CurrencyCoded>
     <core:CurrencyCodedOther></core:CurrencyCodedOther>
   </OrderCurrency>
   <OrderLanguage></OrderLanguage>
   <OrderParty>
     <BuyerParty>
       <core:PartyID>
         <core:Ident>ZZ-1234567890ABC</core:Ident>
       </core:PartyID>
     </BuyerParty>
     <SellerParty>
       <core:PartyID>
         <core:Ident>AA-0987654321WXYZ</core:Ident>
       </core:PartyID>
     </SellerParty>
   </OrderParty>
 </OrderHeader>
 <OrderDetail>
   <ListOfItemDetail>
   </ListOfItemDetail>
 </OrderDetail>
</Order>