Forum Stats

  • 3,836,865 Users
  • 2,262,198 Discussions
  • 7,900,131 Comments

Discussions

HFM - Application Tables - DCE, DCN etc

660013
660013 Member Posts: 1
edited Sep 16, 2008 10:36AM in Financial Consolidation
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
Tagged:

Answers

  • 586070
    586070 Member Posts: 41
    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.