Currency columns for a form
Where a field in a form typically has one corresponding column in the main data table, the currency field has several columns and, therefore, a unique naming convention to distinguish the extra columns. Whereas typical fields follow the naming convention described in The main data table for a form (all columns in each table or view are named with a C followed by the unique ID for the field within the form), the currency field is named with a C followed by the unique ID for the currency field and a unique suffix for each additional currency column stored in the database.
The currency suffixes used to name the additional currency columns are defined in the following table.
Suffixes used for currency columns
Currency Column Represented
Code associated with decimal value
Timestamp or Date established as the conversion date
Type of currency being used (USD, EUR, JPY, and so on)
Value of specified type of functional currency
For example, the columns for a currency field might be called C536870913V, C536870913C, C536870913D, or C536870913USD.