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

monetaryamount

Permits positive, negative, and zero values.

nonnegativemonetaryamount

Permits positive and zero values only.

positivemonetaryamount

Permits positive values only.

Important: Do not use the currencyamount data type in your data model. Do not use the corresponding CurrencyAmount Gosu or Java class. Use the monetaryamount data type instead.