LOGO İRSALİYELERİN TARİHİNİ FATURA TARİHLERİNE EŞİTLEME

--STLINE TARİHİ EŞİTLE
UPDATE INVDATEUPDT SET STLDATE=INVDATE FROM
(
SELECT     STL.DATE_ AS STLDATE,
          INV.DATE_ AS INVDATE
FROM     LG_201_01_STLINE AS STL
LEFT OUTER JOIN
LG_201_01_INVOICE AS INV ON INV.LOGICALREF=STL.INVOICEREF
WHERE     STL.INVOICEREF<>0 AND STL.DATE_<>INV.DATE_
)AS INVDATEUPDT
----------------------------------------------
--IRSALYE TARİHİ EŞİTLE
UPDATE STFICHEDATEUPD SET STFDATE=INVDATE FROM
(
SELECT     INV.DATE_ AS INVDATE,
          STF.DATE_ AS STFDATE
FROM     LG_201_01_INVOICE AS INV
LEFT OUTER JOIN
LG_201_01_STFICHE AS STF ON INV.LOGICALREF=STF.INVOICEREF
WHERE     STF.INVOICEREF<>0 AND STF.DATE_<>INV.DATE_
) AS STFICHEDATEUPD
*/