ForumsMessage Boards
What tables hold Exchange Data Repository data
David Langschied, modified 3 Years ago.
What tables hold Exchange Data Repository data
Post Date: 7/7/20 (Silver, 61 Posts) Recent PostsAll,
I would like to be able to pull the PO number out of the EDI document (856). I tried to track it down, but have not gotten anywhere, yet. The EF record and field are in red below.
QAD 2017EE
edxrmt.p
┌──────────────────────────────────────────────────────────────────────────────┐
│ Ref ID: 07072020-000008628 │
│ File Seq: 660848 Modified: 07/07/20 EDI │
│ Passed │
│ TP ID: ADT129097247075921 │
│ TP Message Number: TP Doc ID: 856 │
│ Primary Reference: S0004708 Direction: Out │
│ Interchange Number: File Name: ShipNotice │
│ Group Number: Version: 1 │
│ TP Address: 129097247 TP Site: 075921424 │
│ Token List Values: │
┌───── EF Record Data ───────┐┌───────────────── EF Field Data ─────────────────┐
│ Seq Record Name ││ Seq Field Name Field Value │
│ ──── ────────────────── ││ ──── ──────────────────── ───────────────────── │
│ 1 Header ││ 17 Quantity UM EA │
│ 10 Shipment ││ 18 Cum Qty Ship 75183 │
│ 12 Ship Containers ││ 19 PO Number 55081699 │
│ 14 Ship Carrier ││ 20 PO Date │
│ 40 Item ││ 21 PO Line No │
└───────────────────────┘└─────────────────────────────────────────────────┘
Message place holder