| # 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, do as follows: 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. Note The relation on table level is created in the Table Relations (Import) (daxch0521m000) session. Related topics Introduction to the import module To use conditions in the exchange module 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. Note The ASCII file code represents the logical ASCII file. The ASCII file code is created in the ASCII Files (daxch0102m000) session. Related topics Introduction to the Exchange module 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. 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. Related topics Relation between logical ASCII files and physical ASCII files 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. Related topics To use conditions in the exchange module 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. Related topics To use conditions in the exchange module 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 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 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 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. 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. 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: The LN table field is a text field. The ASCII field is not of the type multiline text. The Text Number check box is not selected. 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 if: The LN field is a text field. The ASCII field is not a multiline text field. The Text Number check box is not selected. The Text Language is not filled in. 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: 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. Related topics To use conditions in the exchange module 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: 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. Related topics To use conditions in the exchange module To use audits in the exchange module |