koschate
23rd May 2011, 13:05
Hi All,

can anyone help me with two questions regarding the historical tables tdsls050/051

Is it correct, that records only will be added in these tables and never any record will be updated or deleted?
Can I use the field "trdt - Transaction Date" as criteria to find out when new records are inserted?

Thanks in advance
Ralf

User33
23rd May 2011, 14:32
As I know, you are right, records are only added in tables tdsls050/051. So you can use transaction date, and transaction time (tdsls051.trtm) as well.

You also have tdsls051.ckor, which indicates which kinbd of transaction happende (see link below:

http://www.baanboard.com/baanboard/archive/index.php/t-5627.html


I hope this will help you.