Announcements
No record found.
what is the SQL table name for the SOP to POP process, which include the generated PO number and Original Sales order number? I am using GP2010.
thanks
*This post is locked for comments
SOP60100 is the SOP_POP Link
Hi Sukie - can you be a bit more specific? What are youtrying to achieve?
The SOP to POP link table is SOP60100
The SOP Tables are:
SOP Work Transactions - SOP10100 (Headers) and SOP10200 (Lines)
SOPHistory Transactions - SOP30200 (Headers) and SOP30300 (Lines)
The POP Tables are:
POP PO Work - POP10100 (Headers) and POP10110 (Lines)
POP PO History - PP30100 (Headers) and POP30110 (Lines)
POP Receipts Work - POP10300 (Headers) and POP10310 (Lines)
POP Receipts History - POP30300 (Headers) and POP30310 (Lines)
Hope this helps.
Ian.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
