3

In some rare, but necessary instances we need to store numbers larger than 1,000,000,000,000 or have more decimal places than 10. SQL Server is capable of using a precision of up to 38 (see here: https://learn.microsoft.com/en-us/sql/t-sql/data-types/decimal-and-numeric-transact-sql?view=sql-server-ver16). In theory that means that Dataverse should be able to support that as well. Please allow us to specify the precision and scale when creating decimal and money columns. We can kind-of do that now using the 'Min/Max' settings along with the 'Decimal Places' but it only allows up to a precision of ~22. Please consider expanding this to support a precision up to 38.

Category: General
STATUS DETAILS
New