Retail Merchandising System (MOSC)

MOSC Banner

Totals of foreign currencies

edited May 4, 2015 9:12AM in Retail Merchandising System (MOSC) 2 commentsAnswered

Hi All,

I want to make total of all the tender which has been done in foreign currencies.So I imported "SA_TRAN_TENDER" , "SA_TRAN_HEAD" , "SA_STORE_DAY".Where "SA_TRAN_TENDER " have the column named "ORIG_CURRENCY" and "ORIG_CURR_AMT"  which contain the amount and type of foreign currency.


But the problem is when I try to add parameters to Realms for "SA_TRAN_TENDER" in page no.6 ,then there is no such column name "ORIG_CURRENCY" and "ORIG_CURR_AMT"  is showing , so then how can I make totals of it.


Do any body know why it is not showing those columns , Is it because of improper join ,if yes please help me to get it in right way.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center