Use this activity to view external file type details, i.e. detailed column definitions for each record type in the file type definition.
Using the External File Column Definition command, below details can be viewed.
- Column identity and description
- View if the column is mandatory or not.
- View the data type.
- View the destination column in the external transaction storage. Available values are C1-C70 for strings, N1-N30 for numbers and D1-D20 for dates.
To handle each record type there are columns. When file template details are defined for a specific file type then the details must specify how to handle each referenced record type and column.
None.
External file type and external file template definitions can be used to process e.g. an input file, either by using the External File Assistant or the External File Transactions pages.