These are what I have found to be the most commonly used tables in PM. To see the most common vendor windows mapped out look here.
PM00200 – Vendor Master
PM00201 – Vendor Master Summary
PM00202 – Vendor Period Summary
PM00300 – Vendor Address Master
PM00400 – PM Key Master
PM10000 – Unposted Transactions
PM10100 – GL Distributions Work and Open
PM10200 – Apply To Work and Open
PM10300 – Unposted Payments
PM10400 – Unposted Manual Payments
PM20000 – Open Transactions
PM30200 – Paid Transactions History
PM30300 – Apply To History File
PM30600 – GL Distributions History
All check boxes in GP: unchecked is a 0 (zero) in the DB and checked is a 1.
All drop down menus on windows, just count down the selection in the drop down: the first item listed is a 1 in the DB, second a 2, etc.
DOCTYPE
1 – Invoice
2 – Finance Charge
3 – Misc Charge
4 – Return
5 – Credit Memo
6 – Payment
DISTTYPE
1 – Cash
2 – Payable
3 – Discount Available
4 – Discount Taken
5 – Finance Charge
6 – Purchase
7 – Trade Discount
8 – Miscellaneous Charge
9 – Freight
10 – Taxes
11 – Writeoffs
12 – Other
13 – GST Discount
14 – PPS Amount
PSTGSTUS
0 – Unposted
1 – Posted
CREDTLMT
0 – No Credit
1 – Unlimited
2 – Amoun