Tuesday, May 2, 2017

ReqLogic - Update GP PO Requisition Date with Reqlogic Requisition Date

UPDATE       POP10100
SET                REQTNDT = XW_ReqHdr.ReqDate
FROM            POP10110 INNER JOIN
                         POP10100 ON POP10110.PONUMBER = POP10100.PONUMBER LEFT OUTER JOIN
                         XW_ReqHdr ON POP10110.Source_Document_Number = XW_ReqHdr.ReqNbr
WHERE        XW_ReqHdr.ReqDate > '1900-01-01'

No comments:

Post a Comment