Share
Reportwhat 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
You’re offline. This is a read only version of the page.
35
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (