Menu Close

SOP Tables

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 

If you write queries in SOP10100/SOP10200 and SOP30200/SOP30300 remember that the same SOPNUMBE can exist for 2 different SOPTYPEs. I rarely see it happen, but it can, where that same SOPNUMBE is in their twice for 2 different SOPTYPEs so when you write your query you may want to key it to both SOPNUMBE and SOPTYPE not to get a duplicate. E.g. where sop10100.sopnumbe = sop10200.sopnumbe AND sop10100.soptype = sop10200.soptype

Leave a Reply

Your email address will not be published. Required fields are marked *