Assure DQ

 View Only
  • 1.  ER - Max Digits for Numeric Fields

    Posted 09-01-2020 12:17

    Does anyone know what the MAX Size you can define for a numeric field in ER.  I want to display the Foreign Currency Rate in ER.  Max I've seen on a file provided was 43,42



  • 2.  RE: ER - Max Digits for Numeric Fields

    Employee
    Posted 09-02-2020 09:31

    Hi Brenda, the limit is at the database level, because the number will be stored in the database. For example, Oracle supports up to 38 digits precision.  Anything beyond that limit, you might want to consider storing it as a string.