Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
HFM - Application Tables - DCE, DCN etc
660013
Member Posts: 1
Can anyone please explain what all the different types of Database Application tables are.
I'm am upgrading from 4.0.2 to 9.3.1 and have sql to check the base data is correct - it would be good to know what i was checking and the main tables to look at
Regards
Bryan
I'm am upgrading from 4.0.2 to 9.3.1 and have sql to check the base data is correct - it would be good to know what i was checking and the main tables to look at
Regards
Bryan
Answers
-
Bryan,
The DCE tables store <Entity Currency> and <Parent Currency> values and the related adjustments. The DCN tables store data for the remaining members of the value dimension. The DCT tables store the journal transactions - when the journals are posted, the data values flow to the DCE and/or DCN tables. Hope this helps!
Best Regards,
Bobby
This discussion has been closed.