JDE Reference
47Electronic Data Interchange
Supply chainInbound and outbound EDI staging tables that exchange documents with trading partners
9 tables9 programs
Verified September 2026
Tables
Work Files · 9
- F47011One row per inbound EDI customer purchase order (X12 850) waiting to become a JDE sales order header; staging mirror of F4201.workfile
- F47012One row per line on an inbound EDI customer purchase order (850); staging mirror of the sales order detail F4211.workfile
- F47021One row per inbound EDI purchase order acknowledgment (X12 855) from a supplier, staged against a JDE purchase order header.workfile
- F47022One row per acknowledged purchase order line on an inbound 855; staging mirror of the PO detail F4311.workfile
- F47036One row per outbound advance ship notice (X12 856) at the shipment level, written by the R47032 extraction at the top hierarchy break.workfile
- F47037One row per hierarchy line of an outbound 856 (order, pack, or item level) under a shipment header; sales-order lines plus SSCC/UPC pack identifiers.workfile
- F47046One row per outbound EDI invoice (X12 810) header extracted from billed sales orders; the staging copy of what was billed to the customer.workfile
- F470461The additional-header companion to F47046: one row per outbound EDI invoice (810) carrying the invoice-level totals rolled up from the selected detail lines, the tax authorities and rates behind them, and the payment terms — none of which the base header holds.workfile
- F47047One row per line on an outbound EDI invoice (810); billed quantities and prices by sales order line, staged for transmission.workfile
Programs
- P03505A/R Simple Invoice Print - EDI — the JDE World DREAM Writer whose EDI version copies invoice information straight from the receivables ledger into the outbound EDI invoice files, bypassing the sales order path entirelyBatch UBE
- R47011EDI Inbound Purchase Order Edit/Create — the batch processor that turns customer purchase orders (X12 850) staged in the EDI interface tables into sales orders, with an audit report and Work Center errors for failed documentsBatch UBE
- R47021EDI Inbound PO Acknowledgment — the batch processor that receives supplier acknowledgments (X12 855) of your purchase orders, advances PO status, and prints a discrepancy report where the acknowledgment does not match the orderBatch UBE
- R47032EDI Advance Ship Notice Extraction — the batch job that extracts confirmed shipment data into the outbound 856 staging tables, writing one header row per shipment at the top hierarchy break plus the hierarchy lines beneath itBatch UBE
- R47041Inbound EDI Voucher Edit/Create — the batch processor that turns supplier invoices (X12 810) staged in the EDI invoice tables into A/P voucher and journal entry batch records for voucher batch processingBatch UBE
- R47042CEDI Invoice Extraction Conversion — the batch job that converts outbound EDI invoice records (X12 810 staged by Invoice Print) from the EDI invoice tables into the flat file handed to the EDI translatorBatch UBE
- R47047EDI Invoice Update as Sent — the batch job that flags extracted outbound EDI invoice (810) records as sent once the translator has picked them up, setting the processed flag so they are not re-extractedBatch UBE
- R47049EDI Invoice Outbound Purge — the batch job that removes outbound EDI invoice transactions from the EDI invoice tables once they have been marked as sent by EDI Invoice Update as Sent (R47047)Batch UBE
- R47131EDI Inbound Purchase Order Change Edit/Update — the batch processor that compares staged customer order changes (X12 860) against the open sales order, prints the discrepancy report, and advances or holds the order per its processing options; the change itself is applied in Sales Order Entry (P4210)Batch UBE