Use this field level rule to perform the function of the MoveNum rule if an external record is found. Enter the external record search criteria after the MoveNum search criteria in the Data field. You can also enter a calculation after the external search criteria. This rule supports overflow.
The format mask must contain the input numeric format, followed by the output numeric format. These formats are in the form of X.Y, where X is the size of the number, including any commas, currency symbols, and decimal points, and Y represents the number of digits after the decimal point, such as:
10.2,12.2
The first pairing of X.Y describes the input. The second pairing describes the output. In this example, 10.2 is the description of the data in the extract record and the output for this would be 12 digits before and two digits after the decimal.
The format mask can contain any of these formats after the output numeric format:
|
Format |
Description |
|
L |
Left justify the number |
|
C |
Add commas |
|
B |
Translate BCD number to decimal |
|
Z |
Print number even if it equals zero (0) |
|
$ |
| Note | You cannot use the dollar sign ($) as the first character in the format mask because this conflicts with the use of this character in the Move_It rule. |
The data may contain a calculation to be performed upon the number obtained from the extract record. The calculation must be separated from the search criteria by a space, enclosed in parentheses, and contain spaces to separate each element (including parentheses) in the equation string.
An X in the calculation is replaced by the value moved from the extract file. You must place parentheses around each operator and its accompanying operands.
| Note | This rule does not support an OR condition in the search mask. You can, however, run multiple searches. |
© Copyright 2014, Oracle and/or its affiliates. All rights reserved. Legal notices.