Pad decimals with zeros

Pad decimals with zeros is an option that you can select when defining character fields on a form definition. In the Field dialog, click the Options tab.

When the format of a character field includes a decimal of a variable length, for example N(3).N(1-3), this option adds zeros on the right side of the decimal point until the maximum format is reached. In addition, no decimal appears in the output file.

Example:

A character field has the format N(3).N(1-3), and the value to be represented is 123.4. Without Pad decimals with zeros, the number is represented in the transaction (output data) as 123.4. With the option selected, the number is represented as 123400.

When you choose this option, it is particularly important that you test your output before going into production. Ensure that no step in the process is distorting the transferred value in an unwanted way. For example, make sure that the result of the above example would be 123400, rather than 1234.

Amount field (a different sort of option, which does not conflict with Pad decimals with zeros, for fields containing decimals)

Pad characters in the output data

Specifying a decimal for a character field

Character field and Options for character fields