iaw1978
Member
Hi,
Using an extremely old version of JDE (7.2 maybe?) and trying to understand how to join a few tables and a few other questions ... trying to get the po/invoice number associated with each PV/OV in F0911 and for the most part understand the joins, but a few grey areas:
1) F0911 - what's the difference between GLKCO and GLCO?
F0911
LEFT JOIN
F0411
ON F0911.GLKCO = F0411.RPKCO AND
F0911.GLDCT = F0411.RPDCT AND
F0911.GLDOC = F0411.RPDOC
Is this right?
This would give me all for OV/PV that have no matching, then everything else would be a separate LEFT JOIN on F4311 to F43121 for OV/PV that have a PO?
Using an extremely old version of JDE (7.2 maybe?) and trying to understand how to join a few tables and a few other questions ... trying to get the po/invoice number associated with each PV/OV in F0911 and for the most part understand the joins, but a few grey areas:
1) F0911 - what's the difference between GLKCO and GLCO?
F0911
LEFT JOIN
F0411
ON F0911.GLKCO = F0411.RPKCO AND
F0911.GLDCT = F0411.RPDCT AND
F0911.GLDOC = F0411.RPDOC
Is this right?
This would give me all for OV/PV that have no matching, then everything else would be a separate LEFT JOIN on F4311 to F43121 for OV/PV that have a PO?