jjmundt 3/18/2019 9:35:25 AM

SQL link from CM20202 to POP10500?

I'm a .NET developer and am largely a novice with the GP table structures, so hopefully this makes sense..

All of our invoices are processed through the Bank Rec tables - specifically CM20202.  Payments are batched into that table and then an external, third-party application reads and processes the records for payment.  I have another application - an app that I'm writing - that needs to pull the record of some of those payments, tie them back to their corresponding Purchase Order, and send that information to another third-party site.

So as that third-party application processes transactions, I would like to read something from that CM20202 record - probably DOCNUMBR, since it appears to be unique - and work backwards.  I believe the data I need for the Purchase Order lines is stored in POP10500, and I believe it contains the line items and receipts for each transaction processed against a PO.

What I need to know is this...is there a way to build a join back from CM20202 to POP10500?

If this doesn't make sense, ask a question and I'll try to clarify.  I'm as much trying to understand how stuff works as solve my problem.

Thanks in advance!!

Joel

Version: GP 2015
Section: Dynamics GP, SQL Scripts


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3