Field Relations (Import) (daxch0122s000)
Use this session to create relations between logical ASCII file fields and LN table fields per batch in an exchange scheme.
To create field relations, use the General tab to define the general parameters of the fields relation.
- Enter a serial number and select a LN table field. If the LN table field is defined as an array, you have to define an array element number field in the data dictionary.
- Define, under Based on , how the LN table field receives its value, and select the appropriate ASCII File field, condition, constant, or increment if required.
Use the Text/Conditions tab to define text parameters and to set update or overwrite permissions and the appropriate condition. Define, under Text Settings , the language of the text and additional parameters. Define, under Permitted Operations , the update and overwrite permissions and the appropriate conditions, if required. Click Text to create additional text for the field relations.
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.