topic Re: Document Currency Fields in Application Development and Automation Discussions

Document Currency Fields

Former Member — Thu, 07 Jul 2005 13:52:26 GMT

Is there any way, programmatically, that one can determine the difference between a normal currency field and a document currency field (ie. a currency field but not in local currency)?

Re: Document Currency Fields

Former Member — Thu, 07 Jul 2005 15:27:13 GMT

if you are looking for the exchange rate, use the TCURR transparent table to look it up based on the from/to currencies (fields FCURR, TCURR)... you can multiply your non-local currency by the exchange rate (field UKURS) to convert it to the local currency amount

Re: Document Currency Fields

Former Member — Thu, 07 Jul 2005 15:48:06 GMT

Michael,

Thanks for the reply although this isn't exactly what i'm after. When I extract data from a table, I can determine that a field is a currency field by it's field type. When I extract that data into my own application/database, I do not know whether that is in local currency or not. I wanted to know if there was any way one could programmatically check whether a field was in local currency or not...for any given table??