And then the JDE Order Detail File Is compared to that
SELECT DISTINCT SDKCOO,SDDOCO,SDDCTO,SDLNID,SDMCU
FROM ajdevjdta.F4211la
EXCEPTION JOIN ajdevmdta.F59912 ON
SDKCOO = CBKCOO
and SDDOCO = CBDOCO
and SDDCTO = CBDCTO
and SDLNID = CBLNID
and SDMCU = CBMCU
WHERE SDDOCO in
(select DISTINCT CCDOCO from ajdevmdta.F59911 where CCTYPE = 'AB')
and SDLNTY = 'S' and SDNXTR <= '560'
for READ ONLY
This is not returning any results
Yet there is differences in the Data (SDMCU<>CBMCU on 2 Lines of the
Order)
One difference That I have identified is the Line number types are
different Packed and Zoned could that be creating an issue
I changed and SDLNID = CBLNID to and char(SDLNID) = char(CBLNID) and
got the same result
Any help with this Sql Statement would be appreciated
This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.