Understanding the Inbound Flat File Conversion Program

You use the Inbound Flat File Conversion program (R47002C) to import flat files into JD Edwards EnterpriseOne interface tables. You can create a separate version of the Inbound Flat File Conversion program for each interface table. This program recognizes both the flat file from which it reads and the record types user-defined code (UDC) (00/RD) within the flat file. Each flat file contains records of differing lengths, based on the interface table record to which they correspond. The Inbound Flat File Conversion program uses the Flat File Cross-Reference Table (F47002) to convert the flat file into the interface tables. The F47002 table indicates to the conversion program which flat file to read from and which interface table to use, based on the transaction type that you are receiving.

The conversion program reads each record in the flat file and maps the record data into each field of the 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 interface table. If the conversion program encounters an error while converting data, it withholds the data in error and continues processing the conversion. If the data is successfully converted, the system automatically starts the transaction process for that interface table, provided that you set the processing options in the conversion program to do so.

See Setting Processing Options for the Inbound Flat File Conversion Program (R47002C).