360 Secure SkillHub
360 安全技能中心

Edi Parser

核心功能为解析EDI X12的810发票、850采购单、856发货通知，提取ISA/GS信封及交易段的结构化数据，识别PO号、金额、SKU等关键字段，适配沃尔玛等零售供应商合规要求。典型场景包括零售供应链数据处理、合规校验。输入为EDI X12文件，输出支持结构化表格或批量行项目CSV。

npfaerber
npfaerber
热度 55.66
最近更新 2026-05-11 17:27:47
分类：效率依赖：读写文件 / 内部调用大模型应用场景：数据处理 / 文件转换

安装技能

复制下面的话术发给你的 Agent，它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill： npx secure-skills-cli add edi-parser
Metadata
name
edi-parser
description
Parse EDI X12 files (810 Invoice, 850 Purchase Order, 856 ASN). Extract structured data from ISA/GS envelopes, transaction sets, and segments. Use when working with EDI files, Walmart/retail supplier compliance, or extracting PO, invoice, and shipment data from X12 format.

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

ISA*QQ*SenderID*RR*ReceiverID*Date*Time*:*Version*Control#*AckReq*Mode*SubSep~
  GS*FuncCode*SenderCode*ReceiverCode*Date*Time*GroupControl*Standard*Version~
    ST*TransactionSet*Control#~
      ... segments ...
    SE*SegmentCount*Control#~
  GE*TransactionCount*GroupControl~
IEA*GroupCount*InterchangeControl~

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 925485US00
  • REF*IA = Walmart vendor number (required on 856)
  • REF*LO = Load number (new requirement)
  • N1*ST with UL qualifier = GLN for ship-to location
  • MAN*GM = SSCC-18 (required per pallet on 856)

Output Format

When parsing, output a clean table:

| Field | Value |
|-------|-------|
| Transaction | 856 ASN |
| ISA Sender | 12 / 1234567890 |
| ISA Receiver | 08 / 925485US00 |
| PO# | 0123456789 |
| Ship Date | 2026-02-16 |
| Items | 16 line items |

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