Application Development 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
Showing results for 
Search instead for 
Did you mean: 

Reg : currency field

Former Member
0 Kudos

Hi,

when i am creating table , when am adding currency field i need to mention the reference table

why we need to refere that table for currency field .

plz explain the reason .

1 ACCEPTED SOLUTION

Former Member
0 Kudos
4 REPLIES 4

Former Member
0 Kudos

Former Member
0 Kudos

Hi,

Whenever CURRENCY values are processed, there is a need to specify CURRENCY KEY, for example JPY(Japanese Yen), INR(Indian Rupees), USD(United States Dollar), etc.

The currency value will be stored in one field and the corresponding currency key in one field. Here, there is a need to mention the link between these fields.

That's why we are mentioning the currency key field as reference field.

The same rule is applicable for Quantity values. But here it is called as UNITS, for example KG(KiloGram), PT(PoinT), etc.

There is no need that reference field must be in the same table. Even it can be referred from other tables also.

Regards,

R.Nagarajan.

Former Member
0 Kudos

thanks a lot