Add an FX Currency field to a table

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.

1. 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).

2. Click Submit.

Parent Topic:Setting up defaults required for FX Currency use

Related topics

Add conversion rates using a custom rate table

Configuring FX Currency global settings

Configuring FX Currency field behavior

Update a Currency Instance record