Field Relations (Import) (daxch0522m000)

Field Information

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 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 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 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.

Serial 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 LN table, that is filled with data from a field in an ASCII file, during an import procedure.

Array Element

The element number of an array field. This field is only applicable if the 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 LN fields. Use the Based on groupbox on the General tab in the details session to define the method of the data transfer.

LN fields can be filled based on:

1. Field value
2. Condition
3. Constant
4. Increment
5. 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 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.

Condition

The condition that is used in the transfer of data from the ASCII file field to the LN table field.

Use this field only if the data transfer to the LN table field is based on conditions.

Note: Conditions are defined in the Conditions (daxch0114m000) session.

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 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 Table

The conversion code to modify data before it is transferred to the LN table field.

Note: Conversions are defined in the Conversion Tables (daxch0105m000) session.

Field Rel. Text

If this check box is selected, additional information is added to the field relation. The text is maintained in the text editor.