Exchange Rate Fields in the Conversion Audit Table

This table describes how exchange rate fields appear in the F0086 table:

Exchange Rate Field	Description
AUCRR Currency Conversion Exchange Rate	The exchange rate used to convert the original base currency amount to the new base currency. This rate is retrieved from the F0015 table.
AUCRRB Currency Exchange Rate - Before	The exchange rate on the original transaction before the conversion. This rate was either retrieved from the F0015 table or entered manually as an override rate during data entry. If the original transaction was domestic only, this field is blank.
AUCERA Currency Exchange Rate - After	The exchange rate on the original transaction after the conversion. If the original transaction was domestic only, this is the rate used to convert the original domestic amount to the new base currency amount. This rate is retrieved from the F0015 table and is the same as the rate in the AUCRR field. If the original transaction was foreign and the transaction currency is different from the new base company currency, this is a calculated rate between the converted domestic amount and the foreign amount. To derive the calculated rate, the foreign amount is divided by the converted domestic amount. If the original transaction was foreign and the transaction currency is the same as the new base company currency, this field is blank. The transaction is now domestic only.

Exchange Rate Field

Description

AUCRR

Currency Conversion Exchange Rate

The exchange rate used to convert the original base currency amount to the new base currency. This rate is retrieved from the F0015 table.

AUCRRB

Currency Exchange Rate - Before

The exchange rate on the original transaction before the conversion.

This rate was either retrieved from the F0015 table or entered manually as an override rate during data entry. If the original transaction was domestic only, this field is blank.

AUCERA

Currency Exchange Rate - After

The exchange rate on the original transaction after the conversion.

If the original transaction was domestic only, this is the rate used to convert the original domestic amount to the new base currency amount. This rate is retrieved from the F0015 table and is the same as the rate in the AUCRR field.

If the original transaction was foreign and the transaction currency is different from the new base company currency, this is a calculated rate between the converted domestic amount and the foreign amount. To derive the calculated rate, the foreign amount is divided by the converted domestic amount.

If the original transaction was foreign and the transaction currency is the same as the new base company currency, this field is blank. The transaction is now domestic only.