Tables details of Purchase Order Postings

anuprkl

Please tell me the name of the tables get affected during Purchase Order saved through Invoice update.

Thanks
Anup

daxdilip

Hi Anup,

These are some options to find the tables getting updated:

a. Go to Tools->Options->SQL Trace (You can use this to find the tables which are referred in DML statements)

b.If you know SQL Administration, you can use SQL Profiler to capture the SQL:StmtCompleted events and trace out it to a file and from that you can filter out the tables.



Thanks and Regards,
Dilip