The exchange scheme code.
The exchange scheme is created in the Exchange Schemes (daxch0501m000) session.
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.
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. Hinweis The relation on table level is created in the Table Relations (Import) (daxch0521m000) session.
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 Rel 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. Hinweis 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. Hinweis 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. Hinweis 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. Hinweis Select the ASCII file field in the following field. Field Value 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. Hinweis 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. Hinweis The conditions are created in the Conditions (daxch0114m000) session. 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. Hinweis 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. Hinweis 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. Hinweis Conversion tables are created in the Conversion Tables (daxch0105m000) session. Increment 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. Hinweis This field can only be filled if the Increment 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. Beispiel 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. Hinweis This field can only be used if the Increment 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. 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. Hinweis 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. This check box can only be selected if the LN table field is a text field and the Text Number check box is not selected. If the Append Text check box is not selected, 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 will be stored in that specific language during
an import. A language can be defined if:
Hinweis 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 if:
Overwrite field If this check box is selected, and an existing record is
overwritten, the LN field is overwritten if no condition has been specified, or the return
condition returns true. This condition is defined in the following field, if required. 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:
Hinweis 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. 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:
Hinweis This condition is of the Boolean type.
| |||