Before using and configuring an FX Currency field, you first add it an existing table, or to a new one, in System Definition > Tables.

Before you begin

Role required: admin

About this task

For example, you create a new custom table, named transactions, that stores transactional information and contains an FX Currency field called cost.

Procedure

  1. Follow the normal procedures to add a table, or access an existing table.
    To learn more about creating and modifying tables in an instance, see Create a table.
  2. In the Columns section, use the Table Columns embedded list to add columns to the table.
  3. In the Column label field, enter the column name.
    For example, cost.
  4. In the Type field, select FX Currency as the field type.

    FX Currency field

  5. As needed, enter other required parameters.
    Note: Do not change the Max length value for FX Currency in custom tables. Max length must be 32 (default).
  6. Click Submit.