Formatting Flat File Data for Inbound Documents

Depending on the capabilities of the translator software, you might have to ensure that data is formatted correctly to receive documents in JD Edwards EnterpriseOne application programs. Therefore, you must define how the data should be formatted in the flat file when you run the Inbound Flat File Conversion program (R47002C) from the flat file into the EDI inbound interface tables.

All fields must be correctly formatted for the Inbound Flat File Conversion program to correctly interpret each field and move it to the corresponding field in the appropriate inbound interface table. All fields must be placed in the flat file in the exact order in which they appear in the inbound interface table in which the data is converted. In addition, each field must be enclosed by a symbol that marks the start and end of the field. Typically, this symbol is a double quotation mark. Each field must also be separated from the next field with a field delimiter. Typically, this separator value is a comma. For example:

1,1,00001, ,3333,AA, ,850, , ,R,2, ,9102

Note: For inbound documents that you receive, you can use any field delimiter and text qualifier if it does not interfere with the interpretation of the fields. Use the processing options from the applicable conversion program to define the text qualifiers and field delimiters that the system uses.