Add an FX Currency field to a table

  • Rversion finale: Australia
  • Mis à jour 12 mars 2026
  • 1 minute de lecture

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

    Avant de commencer

    Role required: admin

    Pourquoi et quand exécuter cette tâche

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

    Procédure

    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.
      Remarque :
      Do not change the Max length value for FX Currency in custom tables. Max length must be 32 (default).
    6. Click Submit.