Money Fields

The Money field data type is used to indicate that the field contains a monetary value.  

Money Field in Palette Window

Define the Money Field

Drag and drop the Money field from the Palette window onto the Fields Pane.  The Field Properties window will open, which provides the means for configuring the field.  Enter the field information such as field name, display name, etc., by clicking in the field and typing the information.  

Use Currency Properties

There are two currency properties that can be set to define how the value displays in the money field.  The Currency property defines how the value entered into the money field will display.  For example, 3748 would display as 3,748 if USD was entered in the Currency property and 3.748 would display if EUR was entered in the Currency property.  It also defines the currency precision, meaning the number of places to display after the decimal.  The AsCurrency table contains the precision information for each currency and can be edited through the Currency editor in the Admin Explorer.

The Default Currency property defines the currency that will display in the drop down box if multiple currencies are available for the money field.  It also defines the default format for the value in the money field.

Currency Options in Field Properties Window