sid1996
2008-01-14 21:09:02 UTC
Hello
Could someone confirm, or disconfim, my theory that the tables
InventSumDateTable and InventSumDateTrans are only used for temporary data.
For example, the report Physical inventory by inventory dimension creates
records in these tables, however, it's deleted after it's finished. If the
report is aborted for some reason, the records created will not be deleted,
and I therefore presume that all the records in these tables could be deleted
in order to get rid rid of a lot of temporary data.
The question is whether these tables also contain information that is not of
the temporary kind? Is it safe to delete all records from these tables, or do
they contain data which cannot be deleted without losing vital information?
Thanks in advance,
Tobias Nyström
Could someone confirm, or disconfim, my theory that the tables
InventSumDateTable and InventSumDateTrans are only used for temporary data.
For example, the report Physical inventory by inventory dimension creates
records in these tables, however, it's deleted after it's finished. If the
report is aborted for some reason, the records created will not be deleted,
and I therefore presume that all the records in these tables could be deleted
in order to get rid rid of a lot of temporary data.
The question is whether these tables also contain information that is not of
the temporary kind? Is it safe to delete all records from these tables, or do
they contain data which cannot be deleted without losing vital information?
Thanks in advance,
Tobias Nyström