CODEWITHSUNDEEP
dynamicdynamics-gpeconnect
Ramya
Ramya

Reputation: 103

whic Table contain currency decimal name in Microsoft Dynamic GP

Which table currency decimal values contain.Please provide Microsoft dynamic gp table name. By using this way we can set the Decimal values in GP Tools->setup->Financial->Multicurrency.

Upvotes: 0

Views: 475

Answers (2)

Josh P
Josh P

Reputation: 56

USE TWO

SELECT * 
FROM sysobjects o, syscolumns c
WHERE o.id = c.id AND o.type = 'U' 
AND c.name = 'DECPLCUR'
ORDER BY o.name

The above sql script will give you all the tables that have the decimal places field in the 'TWO' test company database.

Upvotes: 0

Zia
Zia

Reputation: 921

look in the table CM20200 for column DECPLCUR , it contains decimal places for a currency id

Upvotes: 0

Related Questions