These are what I have found to be the most commonly used tables in SOP. In SOP the unposted/work transactions are in SOP10100 and SOP10200. Historical records move to SOP30200 and SOP30300. Like most windows in GP, transaction level voids and posted transaction in the Sales Transaction Entry Window do not move to history automatically and distributions do not pass thru to GL. You actually have to close the window to complete the posting process for transaction level posting. I usually recommend batch level posting and if you are constantly voiding transactions throughout the day just close the Sales Transaction Entry Window periodically to move all those transactions to history. To see the most common sales windows mapped out look here.
SOP10100 – Unposted Transactions (header)
SOP10200 – Unposted Transactions (line)
SOP10101 – Commissions Unposted & History
SOP10102 – GL Distributions Unposted & History
SOP10103 – Payment Unposted & History
SOP10106 – User Defined Unposted & History
SOP10107 – Tracking #s Unposted & History
SOP10202 – Line Comment Unposted & History
SOP30200 – Historical Transactions (header)
SOP30300 – Historical Transactions (line)
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.
SOPTYPE
1 – Quote
2 – Order
3 – Invoice
4 – Return
5 – Back Order
6 – Fulfillment Order
VOIDSTTS
0 – Not Voided
1 – Voided
DROPSHIP
0 – No Drop Ship
1 – Drop Ship
NONINVEN
0 – Inventory item
1 – Non-inventory item
PYMTTYPE
1 – Cash Deposit
2 – Check Deposit
3 – Credit Card Deposit
4 – Cash Payment
5 – Check Payment
6 – Credit Card Payment