The infor.show_value function is used to display the general values. If the value cannot be stored in the general format, then you can query for the original value that could not be resolved as a number or timestamp.


select infor.show_value(property, 'general')
select infor.show_value(property, 'original')

The first parameter is the property name. Use double quotes around property names that begin with digits or include spaces.

The second parameter is general or original. General format displays the general format of the value as decimal(38,15). Original value displays a string value. If the actual value from the payload is a number, date or timestamp and stored in the general format, then it is not displayed on a request for the original format. Only values that could not be stored in the general format are stored in the original string format.