EDI X12 Parser

Parse and extract structured data from EDI X12 transaction sets.

Supported Transaction Sets

• - 810 -- Invoice
• 850 -- Purchase Order
• 856 -- Advance Ship Notice (ASN)

Parsing Approach

EDI files use ~ as segment terminator, * as element separator, and > or : as sub-element separator (check ISA-16).

Envelope Structure

CODEBLOCK0

Key ISA Fields (1-indexed)

• - ISA-05: Sender qualifier (12=UCS, ZZ=mutually defined, 08=UCC)
• ISA-06: Sender ID (left-padded to 15 chars)
• ISA-07: Receiver qualifier
• ISA-08: Receiver ID

850 Purchase Order

Segment	Key Fields
BEG	BEG-03=PO Number, BEG-05=PO Date
DTM

DTM-01=Qualifier (002=Delivery, 010=Requested Ship), DTM-02=Date |

| N1 | N1-01=Entity (ST=Ship-To, BY=Buyer, SF=Ship-From), N1-02=Name | | PO1 | PO1-02=Qty, PO1-04=Unit Price, PO1-07=UPC/SKU | | PID | PID-05=Description |

810 Invoice

Segment	Key Fields
BIG	BIG-01=Invoice Date, BIG-02=Invoice#, BIG-04=PO#
REF

REF-01=Qualifier (IA=Vendor#, BM=BOL#), REF-02=Value |

| N1 | N1-01=Entity (ST=Ship-To, RE=Remit-To) | | IT1 | IT1-02=Qty, IT1-04=Unit Price, IT1-07=UPC | | TDS | TDS-01=Total invoice amount (cents, divide by 100) |

856 ASN

Segment	Key Fields
BSN	BSN-02=Shipment ID, BSN-03=Date
HL

HL-03=Level (S=Shipment, O=Order, P=Pack, I=Item) |

| REF | REF-01=Qualifier (BM=BOL, IA=Vendor#, LO=Load#, AO=Appointment) | | PRF | PRF-01=PO Number | | MAN | MAN-02=SSCC-18 barcode | | LIN | LIN-03=UPC | | SN1 | SN1-02=Qty Shipped, SN1-03=UOM |

Walmart-Specific Notes

• - Walmart ISA receiver: qualifier 08, ID INLINECODE8
• REFIA = Walmart vendor number (required on 856)
• REFLO = Load number (new requirement)
• N1ST with UL qualifier = GLN for ship-to location
• MANGM = SSCC-18 (required per pallet on 856)

Output Format

When parsing, output a clean table:

CODEBLOCK1

For bulk parsing, output CSV with one row per line item.