Increase limits of decimal column type in CDS

[SohailKhan]

The decimal field type only lets you use values between -100 million and 100 million.

This is way too small for the data we want to import - any financial reporting solution will find this limit difficult to work work.

Please increase the size of this column type to be in the 10s or even 100 billions range.

[engferno]

I think also here is not only to increase the amount that handled, but to what level of precision. Storing $903,392,340.39435834838 is not supported. Currency truncates after 4 decimals, and while that works for some cases, those decimals are important in aggregations at financial institutions where millions of decimal transactions are at stake.

I shouldn't have to resort to storing as text or splitting amongst 2 separate columns to store the integer and decimal portions...

[NHelgren]

@SohailKhan Currency provides a much larger value maximum.

@engferno How many decimal places are you looking for?

[NHelgren]

Currency supports up to +/- 2 trillion

[NHelgren]

Review is in progress to extend the max and min values for Decimal as a data type.