same improvement was addressed as LEP-841.
Details got addressed at https://www.liferay.com/community/forums/-/message_boards/message/7459432.
Any application or portlet dealing with currencies should really use the java BigDecimal class. Thus It would be nice for the Service-Builder to support data-type BigDecimal.
1) provide data type called big_decimal in service-builder DTD
<column name="field6" type="big_decimal" convert-null="false" />
<column name="field7" type="big_decimal" convert-null="true" />
It would be better to add two elements for type BigDecimal in service-builder.
constraint-precision: the precision
constraint-scale: the scale
It can be presented as
<column name="salary" type="big_decimal"
constraint-precision="5" constraint-scale="2" convert-null="false" />
2) add new data type in Liferay core called BigDecimalType, where specifies default value;
3) map big_decimal into NUMERIC or DECIMAL as part of SQL scripts
4) map big_decimal into data type BigDecimalType