set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[TRGOnUpdateInvoice] 
   ON  [dbo].[InvoiceTbl] 
   after update
AS 
BEGIN
	SET NOCOUNT ON;
if update(FK_AccountSysCode) or update(FK_DocsysCode) or update(VisitorSyscode)
	if exists(select * from deleted where not ArchiveName is null and ArchiveName<>'') 
		raiserror (50209,16,1)
	else
		INSERT INTO [ChangeInvoiceTbl]
				   ([CustomerName]
				   ,[FK_AccountSysCode]
				   ,[Comment]
				   ,[InvoiceSerialNo]
				   ,[RecivedDate]
				   ,[DelivaredDate]
				   ,[PaymentDate]
				   ,[InvoiceDate]
				   ,[FK_DocsysCode]
				   ,[ArchiveName]
				   ,[UserNo]
				   ,[InvoiceNo]
				   ,[VisitorSyscode]
				   ,[VisitorPer]
				   ,[VisitorAmount]
				   ,[SysDate]
				   ,[Sign]
				   ,[Type]
				   ,[Amani]
				   ,[OnChangeUserId]
				   ,[OnChangeSysDate]
				   ,[IsUpDated])
			 select 
				   [CustomerName]
				   ,[FK_AccountSysCode]
				   ,[Comment]
				   ,[InvoiceSerialNo]
				   ,[RecivedDate]
				   ,[DelivaredDate]
				   ,[PaymentDate]
				   ,[InvoiceDate]
				   ,[FK_DocsysCode]
				   ,[ArchiveName]
				   ,[UserNo]
				   ,[InvoiceNo]
				   ,[VisitorSyscode]
				   ,[VisitorPer]
				   ,[VisitorAmount]
				   ,[SysDate]
				   ,[Sign]
				   ,[Type]
				   ,[Amani]
				   ,dbo.funuserid()
				   ,getdate()
				   ,1
			from deleted

END