AX2662

Data conversions

You can set up data conversions for a table, such as to perform currency conversions. For example, the data in a table may be stored using U.S. dollars, but you want to report on it in Canadian dollars or British pounds.

Data is converted on-the-fly, when the query request (Axiom query or GetData function) includes a conversion target. The converted data is not physically stored in the database. Data conversions are similar to calculated fields in this sense.