Why does HEAT change large numbers (10+ digits) to a default value of 2147483647?

Version 1

    Details

    Why does HEAT change large numbers (10+ digits) to a default value of 2147483647?


    Resolution

     

    The integer data type is limited to signed 32 bit integers, i.e., 2^31 - 1 = 2147483647.

     

    There is nothing we can do about this on the HEAT side as it is a 32 bit limitation.

     

    If a greater than 10 digit number is needed, for example an 11 digit number field, the best option would be to create this field as Text and assign a numeric only mask of 99999999999.