When fields are defined in the LANSA Repository, an edit code can be assigned in order to specify the format of the data when it is displayed. The edit codes used in the Repository are the same edit codes used by LANSA Client.
If your output is not in the format expected, a change to the edit code may be all that is required to fix it. You can see the edit code that has been assigned by pressing F1 when you have highlighted the field in the Query Window.
Here is how an amount of 5987.63 would be displayed with the edit codes currently supported by LANSA Client: