These are what I have found to be the most commonly used tables in POP. To see the most common purchasing windows mapped out look here.
POP10100 – Purchase Order Unposted (header)
POP10110 – Purchase Order Unposted (line)
POP10150 – Purchase Order Comment (header)
POP10300 – Receipt Unposted (header)
POP10310 – Receipt Unposted (line)
POP10330 – Serial/Lot Unposted
POP10390 – Distribution Unposted
POP10500 – Receipt Line Quantities (line)
POP10550 – Line Item Comment (line)
POP10600 – Purchasing Shipment Invoice Apply
POP30100 – Purchase Order History (header)
POP30110 – Purchase Order History (line)
POP30300 – Receipt History (header)
POP30310 – Receipt History (line)
POP30330 – Serial/Lot History
POP30390 – Distribution 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.
POTYPE
1 – Standard
2 – Drop Ship
3 – Blanket
4 – Blanket Drop Ship
POLNESTA (PO Line Status)
1 – New
2 – Released
3 – Change Order
4 – Received
5 – Closed
6 – Cancelled
POSTATUS
1 – New
2 – Released
3 – Change Order
4 – Received
5 – Closed
6 – Cancelled
STATUS
0 – Unposted
1 – Posted
2 – Voided
STATGRP
0 – Voided
1 – Active
2 – Closed
DOCTYPE
1 – PO
2 – Receipt
POPTYPE
1 – Shipment
2 – Invoice
3 – Shipment/Invoice
4 – Return
5 – Return w/Credit
6 – Inventory Return
7 – Inventory Return w/Credit
DISTTYPE
1 – Purchases
2 – Trade Discounts
3 – Freight
4 – Miscellaneous
5 – Tax
6 – Discounts Available
7 – Accounts Payable
8 – Other
9 – Accrued
10 – Round