The most likely reason for that is the accuracy of the Decimal datatype in OutSystems. It supports until 8 decimal digits and your fields in SQL have 20 decimal digits. Try to reduce the number precision to 8 digits and try if the Integration studio will import them correctly.

On this link has the details about the numbers precision in OutSystems (C#):

The most likely reason for that is the accuracy of the Decimal datatype in OutSystems. It supports until 8 decimal digits and your fields in SQL have 20 decimal digits. Try to reduce the number precision to 8 digits and try if the Integration studio will import them correctly.

On this link has the details about the numbers precision in OutSystems (C#):

Why does Integration Studio convert decimal datatype fields from External SQL Database into Text datatype in Outsystems?

See the attached screenshot for exampe.

Thanks in advance!

Hi Rossi,

Thanks for the answer, it might be the case but sadly I can't modify the SQL Tables as it belongs to my client. If i override the conversion to decimal, will it have any impact?

Having decimal data type sometimes make a trouble. In my project, i prefer double, instead of decimal in the physical table design, and change Outsystems datatype to currency.

I think you can switch to Decimal having no issues, unless you need more than 8 decimal places which doesn't make so much sense only if you are doing scientific calculations.

The fields will be cut to 8 decimal places: 9,12345678 instead of having 20 decimal places: 9,12345678901234567890.

The most likely reason for that is the accuracy of the Decimal datatype in OutSystems. It supports until 8 decimal digits and your fields in SQL have 20 decimal digits. Try to reduce the number precision to 8 digits and try if the Integration studio will import them correctly.

On this link has the details about the numbers precision in OutSystems (C#):

Why does Integration Studio convert decimal datatype fields from External SQL Database into Text datatype in Outsystems?

See the attached screenshot for exampe.

Thanks in advance!

Hi Rossi,

Thanks for the answer, it might be the case but sadly I can't modify the SQL Tables as it belongs to my client. If i override the conversion to decimal, will it have any impact?