Use this activity to define 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 defined.
- Column identity and description
- Mark if the column is mandatory or not.
- Define the data type. Use the column list to see valid values.
- Define the destination column in the external transaction storage. Available values are C1-C70 for strings, N1-N30 for numbers and D1-D20 for dates.
For each record type it is necessary to define the columns that the record type can handle. 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.
Record types must have been defined for the file type to be able to define details.
When the file type details have been defined then the file type can be tested. This requires a file template that is associated with the file type. Both the file type and the file template are necessary to be able to e.g. perform load of an external file. Use the External File Assistant or the External File Transactions page.