Field Relations (Import) (daxch0122s000)

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 LN table name that must contain data from the ASCII file.

ASCII File

The code of the ASCII file that contains data that is transferred to a LN table during an import procedure.

Note: The ASCII file code represents the logical ASCII file. The ASCII file code is created in the ASCII Files (daxch0102m000) session.

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.

Note: 

The number is increased automatically: when you define a new field relation, 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.

Table Field

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

Field Value

If this check box is selected,, the data transfer is based on the data in an ASCII file field.

Note: Select the ASCII file field in the following field.

ASCII Field

Enter the code of the ASCII file field that contains data that is transferred to a field in the LN table during an import procedure.

Conversion

Enter a conversion code.

To modify data in a field relation, use a conversion code before the data of an ASCII file field is transferred to the LN table field.

Note: Conversion tables are created in the Conversion Tables (daxch0105m000) session.

Condition

If this check box is selected, the import process can be manipulated by using conditions.

Note: The conditions are created in the Conditions (daxch0114m000) session.

Field Condition

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

The return value of the condition will be used to fill the LN table field.

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

Conversion

Enter a conversion code.

Use a conversion code to modify data in a field relation before the return value of a condition is transferred to the LN table field.

Note: Conversion tables are created in the Conversion Tables (daxch0105m000) session.

Constant

If this check box is selected, a constant value is loaded into the LN table field.

Constant

The value that will be assigned to the LN table field during import.

Conversion

Enter a conversion code.

Use a conversion code to modify data in a field relation before the constant value is transferred to the LN table field.

Note: Conversion tables are created in the Conversion Tables (daxch0105m000) session.

Increment Value

If this check box is selected,, the import is based on increment.

Start Value

Enter the initial serial number of the field relation in a table relation that starts the data transfer. The start value is filled by LN if one of the higher-level fields in the index changes.

Note: This field can only be filled if the Increment Value check box on the General tab of the Field Relations (Import) (daxch0122s000) session under Based on is selected.

Increment Value

Define a value to update the start value of the field relation during an import process.

Example

If the start value is 25 and the increment value is 10, the values used for the LN table fields are 25, 35, 45, and so on.

Note: This field can only be used if the Increment Value check box on the General tab of the Table Relations (Import) (daxch0121s000) session under Based on is selected.

Default

If this check box is selected,, the default value, as defined in the data dictionary, is transferred to the LN table field.

Field Rel. Text

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

Click Text to start the text editor.

Text Number

If this check box is selected, the physical ASCII file field contains a text number.

Do not select this check box if the physical ASCII file contains a number that must be converted into the contents of a text number.

Note: This check box can only be selected if the LN table field has a text domain and the ASCII file is numeric.

Append Text

If this check box is selected, the text to be imported is appended to the existing text.

You can only select this check box if the LN table field is a text field and the Text Number check box is cleared.

If the Append Text check box is cleared, new text is copied to a new text record and the text number is written to the current record.

Text Language

The language code of the text in the ASCII file field. If a language is defined, the text is stored in that specific language during an import.

A language can be defined in these situations:

• The LN table field is a text field.
• The ASCII field is not of the type multiline text.
• The Text Number check box is cleared.

Note: The language is defined in the Software Languages (ttaad1110s000) session.

Text Lang. Field

Enter the name of the ASCII file field that can be used to define the language if it is not known at the time of setting up the exchange scheme.

A Text Language field can be defined in these situations:

• The LN field is a text field.
• The ASCII field is not a multiline text field.
• The Text Number check box is cleared.
• The Text Language is not filled.

Overwrite field

If this check box is selected, and an existing record is overwritten, the LN field is overwritten if no condition is specified, or the return condition returns true.

This condition is defined in the following field, if required.

Overwrite Condition

Enter a condition code. If an existing record is inserted, then the value of the field is overwritten if the return value of the overwrite condition is true.

You can automatically generate a condition if you click Create/Edit. In that case, the condition for overwriting code contains the ASCII file code with the extension .OVR.

Preconditions for the over write condition:

• Type of action is insert.
• All ASCII fields are filled.
• Record does already exist.
• LN table fields are filled with this record.

Note: The condition must be of the Boolean type.

Update Field

If this check box is selected, a record is updated when the return value of the update condition is true.

Update Condition

Enter a condition code. The field is updated when the return value of the update condition is true.

Records that must be updated with an import based on indicators, or based on audit, start with the letter u. You can automatically generate a condition if you click Create/Edit. In that case, the condition for overwriting code contains the ASCII file code with the extension .UPD.

Precondition for the update condition:

• Type of action is update (old values).
• ASCII file fields are filled: primary key fields of the source table on the export site and values that are changed.
• The record that must be updated exists.
• LN table fields are filled with an existing record.

Note: This condition is of the Boolean type.