10 ms·
> I have never seen a Money type nor anything like DEC64 in a real commercial system, its all floats or ints/longs for pennies. I've been working in ERP land f
by RaftPeople 11mo ago
> I have never seen a Money type nor anything like DEC64 in a real commercial system, its all floats or ints/longs for pennies.
I've been working in ERP land for a long time working with many different commercial systems of different sizes and market share and I've only seen NUMERIC/DECIMAL types used in DB for things like Price, Cost, Amount etc.
The only time I've ever seen floating point is for storage of non-money type values, like latitude and longitude of store locations.
Examples of a few top systems:
SAP - Packed decimal
Oracle NetSuite - Decimal
Microsoft Dynamics - Decimal/Numeric
Infor - Decimal/Numeric