Max length of 14 on Decimal field type?

[Dan George]

Hi all - there is a field on a custom table in our instance that supports our Journal Entry process. The field is set to a max of 20 and type decimal but only allows entry of 14 digits. I've set the max length to 30 and 32 but with no effect. Is there some database restriction overriding the max length property of the decimal field type stopping at 14?

[Rahul Kathuria]

Hi Dan,

Adding a scale attribute might help. Please see this servicenow guru article for more details.

https://www.servicenowguru.com/system-definition/controlling-decimal-field-places/

Thanks

Rahul Kathuria

[Allen Andreas]

Hi,

Please see this thread which shows the limitation at 14 characters: https://community.servicenow.com/community?id=community_question&sys_id=db660fe1db1cdbc01dcaf3231f96...

Please mark reply as Helpful/Correct, if applicable. Thanks!

[sachin_namjoshi]

Check below to control decimal field places

https://www.servicenowguru.com/system-definition/controlling-decimal-field-places/

Regards,

Sachin

[Dan George]

Hi all - thank you for the prompt suggestions on this thread. I have opened a HI ticket regarding this issue.