Specifying customized tables and table fields

Customized LN software can have specific conversion requirements. Therefore, the conversion table and conversion field definition sessions allow you to add customized tables and fields to the conversion cluster.

Use the CI Tables (tccri7522m000) and CI-Conversion Table Parameters (tccri7123s000) sessions to specify for each customized table:

  • The conversion type(s) to be performed on the table or field.
  • The priority of the table conversion (before or after other tables have been converted).
  • A condition to specify selective conversion of the data in the table. For example, if only rows of a specific type must be converted.
  • Whether a table must be converted by using a DLL instead of the standard conversion scripts. If so, you can indicate whether the DLL must be processed before, during, or after the standard conversion.

Use the CI Fields (tccri7521m000) and CI-Conversion Field Parameters (tccri7122s000) sessions to specify for each customized field:

  • The type of conversion in which the field must be processed.
  • The priority with which the field must be converted.
  • The conversion rule that indicates how the field must be processed. The conversion rules are described under "Conversion Rules."
  • The table fields, in the same table, where the related currency, customer, supplier, rate, and rate factor can be found. If this information is contained in a different table, you must provide a DLL to convert the table.
  • The field that contains the financial company number that is used for the conversion of the field. If a shared table contains a company field, for example, tfgld110.cono, this field must be used. The home currency amounts must be converted to the home currencies of this company instead of the company that is currently being processed. This parameter cannot be used in combination with the default currency rule. If no financial company is used for the table, this parameter can be left blank.
  • The Express in Base Currency field that can be used in combination with the Rate and the Rate Factor fields. This parameter can only be used in combination with the rate / rate factor rule. If no Express in Base Currency field is used in combination with the Rate field, this parameter can be left blank.

If the standard conversion rules cannot be used for a customized table or field, special conversion DLLs must be written and linked to the table.

Chapter 8, "Conversion Rules," lists the standard conversion rules and describes when and how you must provide special DLLs.