set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
create TRIGGER [dbo].[TRGOnUpdateBankDetail]
   ON  [dbo].[ChangeBankDetailTbl] 
   after delete
AS 
BEGIN
	SET NOCOUNT ON;
insert into [ChangeBankDetailTbl]  ([Fk_DocDetailsyscode]
           ,[Number]
           ,[OnChangeUserId]
           ,[OnChangeSysDate]
           ,[IsUpDated])  
	 select [Fk_DocDetailsyscode],[Number]
           , dbo.funuserid(),getdate(),1 from deleted
END