set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[TRGOnDeleteInvoice] 
   ON  [dbo].[InvoiceTbl] 
   after delete
AS 
BEGIN
	SET NOCOUNT ON;
	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()
           ,0
	from deleted

END