Field Relations (Export) (daxch0132s000)

	Field Relations (Export) (daxch0132s000) Use this session to create relations between ASCII Field fields and Infor LN table fields per batch in an exchange scheme. To create field relations, do as follows: Enter a serial number and the name of the ASCII Field field. Define under Based on how the ASCII Field field receives its value and select the appropriate Infor LN table field, condition or constant. Enter the element number of an array field, if the Infor LN field is defined as an array field in the data dictionary. Click Edit Text to create additional text for the field relation. Remarque The relation on table level is created in the Table Relations (Export) (daxch0531m000) session. Rubriques liées Introduction to the import module To use conditions in the exchange module Exchange Scheme The exchange scheme code. The exchange scheme is created in the Exchange Schemes (daxch0501m000) session. Batch The batch code in an exchange scheme. A batch is created in the Batches (daxch0104m000) session. Exp. Table Rel. A sequential number that identifies the table relation. It makes the table relation unique in the batch. Table The code of the table in Infor LN that contains the data that will be exported into an ASCII file during an export. The Infor LN table is specified in the Table Relations (Export) (daxch0531m000) session. ASCII File The code of the ASCII file that contains data from the Infor LN table during an export procedure. To copy fields of an ASCII file table automatically the ASCII file code must be the same as the code of the Infor LN table. This is an option if you do not have a data definition file of the ASCII file. Remarque The ASCII file code represents the logical ASCII file and it is created in the ASCII Files (daxch0102m000) session. Rubriques liées Relation between logical ASCII files and physical ASCII files Serial No. Enter a serial number to make the field relation unique in the table relation. The serial number is only used as an identifier and does not have to be sequential. Remarque The number is increased automatically: when you define a new field relation, Infor LN enters a number of value ten greater than the field relation with the highest value. Because numbers like 10, 20, 30, and so on are used, it is easy to insert field relations at a later stage. Text If this check box is selected, additional information is added to the field relation. The text is maintained in the text editor. Click Text to start the text editor. ASCII Field Enter the code of the ASCII file field that will contain data that is to be transferred from a field in the Infor LN table during an export procedure. Remarque The ASCII file code represents the logical ASCII file. It is created in the ASCII Files (daxch0102m000) session. Table Field If this check box is selected, the data transfer is based on the data in a Infor LN field. Remarque Select the Infor LN field in the following field. Table Field To export data into an ASCII file field, enter the code of the field in a Infor LN table. Rubriques liées Relation between logical ASCII files and physical ASCII files Array Element The element number of an array field. This field is only applicable if the Table Field field is defined as an array field in the data dictionary. The elements in an array can be filled individually. Remarque The element number cannot exceed the array depth. Condition If this check box is selected, the export process can be manipulated by using conditions. Remarque The conditions are created in the Conditions (daxch0114m000) session. Rubriques liées To use conditions in the exchange module Condition Enter the condition that is used in the transfer of data from the ASCII file field to the Infor LN table field. The return value of the condition will be used to fill the Infor LN table field. Remarque Condition are defined in the Conditions (daxch0114m000) session. Rubriques liées To use conditions in the exchange module Constant If this check box is selected, a constant value is loaded into the Infor LN table field. Constant Enter the value that will be assigned to the Infor LN table field during export. Remarque A constant can only be used if the Infor LN table field is left blank and no condition is used.