Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Document Currency Fields

Former Member

‎2005 Jul 07 2:52 PM

0 Likes
3,085

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)?

2 REPLIES 2
Read only

Former Member

‎2005 Jul 07 4:27 PM

0 Likes
1,119

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

Read only

Former Member

‎2005 Jul 07 4:48 PM

0 Likes
1,119

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??