Currently, when we define a field with DataType.NUMBER
in an in-memory table (H2) it defines the column as DECIMAL(19,4).
This is a problem when we work with small numbers, like unit cost or unit prices, that have 5 or 6 decimal places (or more).
Is it possible to change the scale to use more decimals? If it is not, it is possible to create a Jira ticket to make it possible in future PFX releases?
Something like DataType.PRECISION_NUMBER that creates a DECIMAL(19,10).