| Field Relations (Import) (daxch0522m000) |  |
| Use this session to list the available relations between logical ASCII file fields and ERP LN table fields per batch in an exchange scheme. Create the table field relations in the details session. Use the Create Default Import Field Relations command on the application menu to create the field relations automatically. Use this option if the definition file of the ASCII file is not available. Tip If you want to create the field relations automatically, make sure that the code of the ASCII file is identical to the ERP LN table code. Note The relation on table level is created in the Table Relations (Import) (daxch0521m000) session. Related topics Introduction to the import module Relation between logical ASCII files and physical ASCII files To use conditions in the exchange module
Fields | Description
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.
Table Relation (Import) | A sequential number that identifies the table relation. It makes the table relation unique in the batch.
Table | The code of the ERP LN table that contains data from the ASCII file during an import.
ASCII File | The code of the ASCII file that contains data that is transferred to a ERP LN table in an import. To generate the field relations automatically, it is necessary that the code of the ASCII file is the same as the code of the ERP LN table. This is an option if you do not have a data definition file of the ASCII file. Note The ASCII file code represents the logical ASCII file and it is created in the ASCII Files (daxch0102m000) session. Related topics Introduction to the Exchange module
Ser. No. | The serial number that makes the field relation unique in the table relation. The serial number is only used as an identifier and does not have to be sequential. Note Use an interval so that table fields can be added later.
Table Field | The code of the field in the ERP LN table, that is filled with data from a field in an ASCII file, during an import procedure.
Arr. Ele. | The element number of an array field. This field is only applicable if the ERP LN field is defined as an array field in the data dictionary. The elements in an array can be filled individually. Note The element number cannot exceed the array depth.
Based on | This field indicates how the data is transferred from ASCII file fields to ERP LN fields. Use the Based on groupbox on the General tab in the details session to define the method of the data transfer. ERP LN fields can be filled based on: Field value Condition Constant Increment Default Note For more information, refer to the field help in the details session.
ASCII Field | The code of the ASCII file field that contains data that is written to a field in the ERP LN table during an import procedure. If the import is done based on increment, and if the field is part of an index. Note The ASCII file code represents the logical ASCII file. It is created in the ASCII Files (daxch0102m000) session. The index is specified in the sort on index field in the Table Relations (Import) (daxch0121s000) session. The import is based on increment if the Increment Value check box in the Field Relations (Import) (daxch0122s000) session is selected. Related topics Relation between logical ASCII files and physical ASCII files
Cond. | The condition that is used in the transfer of data from the ASCII file field to the ERP LN table field. Use this field only if the data transfer to the ERP LN table field is based on conditions. Note Conditions are defined in the Conditions (daxch0114m000) session. Related topics To use conditions in the exchange module
Start Value | This field defines the initial serial value of the table field relation. The start value is filled by Exchange if one of the higher-level fields in the index changes. Note This field is only filled if the field relation is based on increment.
Constant | You can specify a fixed value in this field if the Based on field has one of the values Fixed value, Increment, or Conv. table. You can specify a fixed value in this field . You can use the character # to represent the current date if the ERP LN table field is of type date. Note You cannot use this field if a field condition is used or if the field Based on is filled with Rel.table and the field name is filled.
Conversion | The conversion code to modify data before it is transferred to the ERP LN table field. Note Conversions are defined in the Conversion Tables (daxch0105m000) session.
Text | If this check box is selected, additional information is added to the field relation. The text is maintained in the text editor.