Money data types
Monetary amounts, such as $12 US Dollars, have two components: a currency (such as US Dollars) and a value (such as 12). Every monetary amount must have both components in order to be valid.
To simplify working with monetary amounts, PolicyCenter uses the data types list below. Each data type has two components: a currency component and an amount component. Whenever an entity field uses one of these data types, the field is mapped to two columns in the corresponding database table: a currency column and a value column.
Money data type |
Description |
|---|---|
|
Permits positive, negative, and zero values. |
|
Permits positive and zero values only. |
|
Permits positive values only. |
currencyamount data type
in your data model. Do not use the corresponding CurrencyAmount Gosu or Java
class. Use the monetaryamount data type instead.