NaomiP
4Penny.net
Points: 7600

10/16/2024 11:06:40 AM

POP Receipts with Dists

Normally, a receivings view has three tables

SELECT rct.POPRCTNM, rct.VENDORID, rcl.ITEMNMBR, rlq.QTYSHPPD, rlq.QTYINVCD, rlq.PONUMBER, rcl.PURPVIDX
    FROM pop10300 rct
        JOIN pop10310 rcl ON rcl.POPRCTNM = rct.POPRCTNM
        JOIN pop10500 rlq ON rlq.POPRCTNM = rcl.POPRCTNM AND rlq.RCPTLNNM = rcl.RCPTLNNM

But if you want distributions, I don't see where you can have the lines because there is no link from the lines to the dists. 

 

4Penny.net
Version: All
Section: 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