1. Accounts Payable Implementation Guide
  2. Setting Data Selection for the Copy to Outbound EDI Files Report

Setting Data Selection for the Copy to Outbound EDI Files Report

Five worktables are used in the processing of Outbound EDI transactions:

  • F47056W - EDI Payment Order Header - Work.

  • F470561W - EDI Payment Order Bank N & A - Work.

  • F470562W - EDI Payment Order Vendor N & A - Work.

  • F470563W - EDI Payment Order Payee N & A - Work.

  • F47057W - EDI Payment Order Remittance Advice - Work.

The following fields are common to the five tables used by the Copy to Outbound EDI Files program (R47057) and are the only fields you should use for data selection or data sequencing. If you use any other fields for data selection or data sequencing, the report will stop and you will receive an error message.

  • EDI Document Company

  • EDI Document Number

  • EDI Doc Ty

  • EDI Line Number

  • EDI Successfully Processed

  • EDI Batch Number

  • Batch Number

  • Batch Type

  • Document Company

  • Company

  • Business Unit

  • Payment/Item Number

  • Match Doc Type

  • Pmt/Itm Pay Itm

  • Address Number

  • Transaction Originator

  • User ID

  • Program ID

  • Work Stn ID

  • Date Updated

  • Time of Day

Other fields exist that are common to all five worktables, but contain different values depending on whether they are contained in a header worktable or a detail worktable. Those fields should not be used for data selection. Use only the common fields.