These are what I have found to be the most commonly used Company and System tables.
Company Tables:
SY00500 – Batch Master
SY01200 – Internet Addresses
SY03000 – Shipping Methods Master
SY03300 – Payment Terms Master
SY03900 – Record Notes Master
SY05000 – Activity Tracking
System Tables:
ACTIVITY – User Activity
SY00800 – Batch Activity
SY00801 – Resource Activity
TempDB
dex_lock – Locked Tickets
dex_session – Dex Sessions
BCHSTTUS
If you get the batch is interrupted error most of the time you will just need to change the batch status in SY0500. See query here.
0 – Available/Good to Go
1 – Marked
2 – Available
3 – Marked
4 – Marked
5 – Marked
6 – Marked
7 – Interrupted While Posting
110 – Printing Checks