Adding Currency Fields to the Schema

To add a field that stores amount in Budget Currency :

• Set afm_flds.numeric_format='BudgetCurrency'.

To add a field that stores amount in Payment Currency :

• Set afm_flds.numeric_format='PaymentCurrency'.

To add a field that stores the Payment Currency value (required if you have a field or fields in the same table that store amount in Payment Currency):

• Set afm_flds.afm_type='Currency'.

The typical convention is to have two fields with the afm_flds.afm_type='Currency' per table containing costs, one designating currency_budget and one designating currency_payment. However, note that you have the flexibility the field name does NOT have to be currency_payment as long as the field's AFM Type is Currency. For example, invoice.currency_invoice (Currency Invoice) is set up as currency_payment.