The Table Conversion command allows data to be passed through a cross-reference table for conversion in a rule. (See the Cross Reference Tables chapter for more detailed information.)
Conversion Table – the name of the cross-reference table to be used for the data conversion.
Source Variable – contains the value to be looked up in the cross-reference table. Choose from:
Memory Variable – displays next to the Rule Command window. Drag a memory variable and drop it on the Source Variable text box.
Record/Field – displays next to the Rule Command window. Navigate down through a record to reveal the fields. Drag a field and drop it on the Source Variable text box.
System Variable – displays next to the Rule Command window. Drag a system variable and drop it on the Source Variable text box.
Destination Variable – holds the value that is returned by the cross-reference table lookup.
Memory Variable – displays next to the Rule Command window. Drag a memory variable and drop it on the Destination Variable text box.
Record/Field – displays next to the Rule Command window. Navigate down through a record to reveal the fields. Drag a field and drop it on the Destination Variable text box.
System Variable – displays next to the Rule Command window. Drag a system variable and drop it on the Destination Variable text box.
Status Variable – a memory variable that holds a value indicating whether the lookup was successful. If the source variable was found in the table, a value of true (No Error = 01) is returned. If the source variable was not found, a value of false is returned.
Failure, Return – allows you to return a default value into the destination if the source variable was not found in the table. That default value may be returned to a:
Memory Variable – the Memory Variables window displays next to the Rule Command window. Drag a memory variable and drop it on the On Failure, Return text box.
Record/Field – displays next to the Rule Command window. Navigate down through a record to reveal the fields. Drag a field and drop it on the On Failure, Return text box.
Constant – enter a value in the text box on the Constant Value window that displays and select OK. The value is automatically entered in the On Failure, Return text box.
Or it may leave the destination empty:
Empty Value
No default value is returned.
Failure, Generate – allows you to choose whether or not to generate an error message if the variable was not found in the table. If you choose to generate an error message, the program writes the message to the trace file and the log file. If you choose not to generate an error message, nothing is written to these files. Choose from:
Error Message
No Error Message
