web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) what is the SQL table ...

Microsoft Dynamics GP (Archived)

what is the SQL table name for the SOP to POP process, which include the generated PO number and Original Sales order number?

(0) Share

Report

Report

Posted on by Sukie Sun

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

JGrebe 30 on at

Like (0)

Report

Re: what is the SQL table name for the SOP to POP process, which include the generated PO number and Original Sales order number?

SOP60100 is the SOP_POP Link

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Re: what is the SQL table name for the SOP to POP process, which include the generated PO number and Original Sales order number?

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.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans