This documentation supports the 9.0 version of Remedy Action Request System.

To view the latest version, select the version from the Product version menu.

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

Suffix

Currency Column Represented

V

Decimal value

C

Code associated with decimal value

D

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.

Was this page helpful? Yes No Submitting... Thank you

Comments