Understanding the Inbound Flat File Conversion Program (R47002C)

Each EDI inbound menu contains an Inbound Flat File Conversion option and each JD Edwards EnterpriseOne EDI document has its own unique set of EDI interface tables. The user can create a separate version of the Inbound Flat File Conversion program (R47002C) for each EDI document. The conversion program recognizes both the flat file that it is reading from and the record types (record type UDC 00/RD) within the flat file. Each flat file contains records of differing lengths, based on the EDI interface table record to which they correspond. The Flat File Conversion program uses the F47002 table to convert the flat file into the EDI interface tables. The Flat File Cross-Reference Table identifies which flat file the conversion program should read, based on the EDI document that you are receiving.

The conversion program reads each record in the flat file and maps the record data to each field of the EDI interface tables, based on the text qualifiers and field delimiters that are specified in the flat file.

The conversion program inserts the field data as one complete record in the EDI interface table. If the conversion program encounters an error while converting data, it withholds the data in error and continues conversion processing. If the data is successfully converted (and the conversion program is set to call), the conversion program automatically runs the EDI Request for Quote Edit/Create program (R47091) for that EDI document if you set the processing options in the conversion program to do so.

If the conversion program successfully converts all data and transfers it to the EDI interface tables, it automatically deletes the flat file after the conversion.