Hi,

I'm migrating a FireBird ER to EDB and would like to know which data type is the best to represent the following values:

For monetary values we use a domain "CURRENCY" that is defined as NUMERIC(15,4).

For percent values we have domain called "PERCENT" that is defined as NUMERIC(3,2)

For Quantities (materials and goods), a domain  "QTY" that is also defined as NUMERIC(15,4).

Anyone could share some advice please?

Regards,
Mario

Mario,

EDB doesn't implement domains, but all you have to do is to replace your domains with the following type declarations:

"CURRENCY" -> NUMERIC(15,4)
"PERCENT" -> NUMERIC(3,2)
"QTY" -> NUMERIC(15,4)

Also, you can interchange NUMERIC and DECIMAL if you like, because in EDB they are equivalent, and always use 19 precision digits no matter what you indicate, so you can also declare then as:

"CURRENCY" -> DECIMAL(19,4)
"PERCENT" -> DECIMAL(19,2)
"QTY" -> DECIMAL(19,4)

and still achieve the same result.


--
Fernando Dias
[Team Elevate]

Thanks Fernando!

Regards,
Mario