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