E Arşiv Faturası kilit Açma

12 Ekim 2023 Perşembe

-- GÖNDERİLDİ yapmak

UPDATE LG_007_01_EARCHIVEDET SET EARCHIVESTATUS=6

WHERE INVOICEREF IN (SELECT TOP 1 LOGICALREF FROM LG_007_01_INVOICE WHERE FICHENO='GID2023000000123')

 

-- GÖNDERİLMEDİ yapmak

UPDATE LG_007_01_EARCHIVEDET SET EARCHIVESTATUS=0

WHERE INVOICEREF IN (SELECT TOP 1 LOGICALREF FROM LG_007_01_INVOICE WHERE FICHENO='GID2023000000123')