Logo Trigger

• Logo
• 28 Kasım 2020 |
• Umutyazilim

Logo Trigger

CREATE TRIGGER [dbo].[KDVMUHAFIYET_031]
ON [dbo].[LG_031_01_STLINE]
AFTER INSERT, UPDATE
AS
BEGIN

DECLARE @CLIENTREF AS INT
DECLARE @LREF AS INT
DECLARE @FTTIP AS INT
DECLARE @STFICHEREF AS INT
DECLARE @UNVAN AS NVARCHAR(50)
DECLARE @VATEXCEPTCODE AS INT
DECLARE @VATEXCEPTREASON AS NVARCHAR(50)
SELECT @LREF = LOGICALREF, @FTTIP = TRCODE , @STFICHEREF = STFICHEREF FROM inserted

if @STFICHEREF > 0 AND @FTTIP = 8 OR @VATEXCEPTCODE > 0

begin

SELECT @VATEXCEPTCODE = STF.VATEXCEPTCODE, @VATEXCEPTREASON = STF.VATEXCEPTREASON FROM LG_031_01_STFICHE STF WHERE STF.LOGICALREF = @STFICHEREF

UPDATE LG_031_01_STLINE SET VATEXCEPTCODE = @VATEXCEPTCODE, VATEXCEPTREASON= @VATEXCEPTREASON WHERE LOGICALREF = @LREF