Use this activity to view current parameter values for an external load but also to modify and/or define new parameter values to be used when the input or output process is executed.
There are two main cases when this activity can be used:
If the an external output file is processed by accessing the general output method External_File_Utility_API.Create_External_Output, then the associated parameter values are mainly used to define select criteria when reading data from a source view. The parameter value can be specified according to the following:
Critera | Notation |
Equal | 1010 |
Not equal | != |
Larger than | > |
Less than | < |
Larger than or equal to | >= |
Less than or equal to | <= |
LIKE | 10% |
NOT LIKE | !10% |
IN | 1010;1020;1030 |
NOT IN | !1010;1020;1030 |
BETWEEN | 1010..1030 |
NOT BETWEEN | !1010..1030 |
The external load must refer to a parameter set that has parameters associated with it.
After having modified the parameter values the steps in the input or output process can be executed.
External File Transactions
External File Parameters
- The parameters associated with the parameter set, defined in the external load header, have predefined default values. In some cases the default values will be translated from fictive values to real values before the parameters are defined as a part of the external load. One example here is the value "<COMPANY>" that will be translated to the current default company for the current user.
- An execution has been made via the External File Assistant or via a standard interface like e.g. the External Supplier Invoices Interface in Invoice. The parameter values supplied at that point will be the ones displayed in the dialog.