Interface table and flat file considerations

If you use an object structure for exchanging data with interface tables or flat files, you must ensure that the object structure does not contain duplicate column names.

You must select the Flat Supported check box for any object structure that you intend to use for interface table or flat file integration scenarios. When this option is set, messages are checked to ensure that every column for every object in the object structure has a unique name. If duplicate column names exist, you can create an alias field name for on the of the duplicate names. Modifying the alias ensures that all column names are unique and the system can generate the interface table or flat file without errors. Interface tables require that all columns that are included in the corresponding object have an alias name of 18 or fewer characters.