Understanding the Outbound Extraction Program

Each EDI outbound menu contains an Outbound Extraction option; for example, Request for Quote (RFQ), Sales (G47211) or Shipping Notice (G47215). The EDI Advanced Ship Notice Extraction programs (R47032) access report features that are specific to each EDI standard document supported in the software. Outbound Extraction, among other programs, displays a version list of report features. You can run an existing version, change an existing version, or add a version. You can also change the processing options and data selection options for that version.

You must copy the records from the application tables to the EDI outbound interface tables in the EDI system 47 by running programs such as Invoice Print (R42565) and Advanced Shipping Notice (R47032). When you run Outbound Extraction, the program retrieves data from the application tables for the EDI document and copies the data into the EDI outbound interface tables.

For example, the EDI Advanced Ship Notice Extraction program is one program that retrieves data from the application tables for the EDI document and copies the data into the EDI outbound interface tables. The EDI Advanced Ship Notice Extraction program also generates an audit report that lists which documents were processed and which completed successfully.

After the system copies the EDI outbound document data to the EDI outbound interface tables, run the EDI Response To RFQ, Outbound Flat File Conversion program (R47107C) to create a flat file if one does not exist, or to append to an existing flat file. Every field is written from the EDI interface tables to the flat file. The flat file conversion program converts the data from the EDI interface tables to a flat file format. The program uses double quotes as text qualifiers and commas (,) as field delimiters to indicate field data.