You need to store the PDF of the business document and you need to store whatever metadata is necessary to allow you to search and retrieve that document from the historical archive later. You can put metadata in the PDF itself if you want, but I think you want metadata in the historical table set as well in the PDF. What metadata needs to be stored has to be decided by what business document is being stored and the ways in which it needs to be searched and retrieved. Again, I think you will find that trying to keep this historical archive in the running application is a futile effort. The security requirements are different. A running application should only keep a certain amount of data live, and data purge the older data. And this would present a problem because it would conflict with the legal requirements of some localities which can require the historical archive to persist for as long as 30 years. No sane running applications for business are going to keep 30 years of data in their operational system. The risk is too high, the security is too low, the performance will suffer, and trying to debug tables with massive amounts of data could be an impossible challenge.
-------------------- m2f -------------------- -- http://www.openobject.com/forum/viewtopic.php?p=31575#31575 -------------------- m2f -------------------- _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
