Field help (AOEFMT)
This column is only entered if the format is fixed length. For numeric amounts, the format entered is defined in the form of nnn or nnn.mmm, remembering that these numbers can be prefixed by < or > (left or right framing being completed with zeros, the right alignment must be used by default), prefixed or suffixed by the character + (mandatory sign before/after the number), and prefixed by the character * (the decimal separator must not appear). The grid below displays examples of the formatting for a given amount (the spaces are replaced here by #).
Format | Amount | Result of the formatting |
7.2 | 123.456 | ####123.45 |
7.2 | -123.456 | ### -123.45 |
>7.2 | 123.456 | 0000123.45 |
>7.2 | -123.456 | -000123.45 |
<7.2 | 123.456 | 123.45#### |
<7.2 | -123.456 | - 123.45### |
6.2+ | 123.456 | ###123.45+ |
>6 .2+ | 123.456 | 000123.45+ |
<6.2+ | -123.456 | 123.45-### |
For an alphanumeric format, the only formatting directives that are possible are < or > (left or right alignment, remembering that the character strings are completed with spaces).