declare @i int
 
set @i =  0 
 
select @i = @i +  1 
from t_PayHistoryInActs
order by PaymentDate asc

CREATE TABLE [dbo].[t_PayHistoryInActs] (
	[InItemId] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[Date] [datetime] NOT NULL ,
	[DocumentId] [int] NOT NULL ,
	[OperationId] [int] NOT NULL ,
	[ItemId] [int] NOT NULL ,
	[DocumentNo] [char] ( 24 ) NOT NULL ,
	[DocumentDate] [datetime] NOT NULL ,
	[PermitId] [int] NULL ,
	[OrderId] [int] NULL ,
	[CompanyId] [int] NOT NULL ,
	[CustomerId] [int] NOT NULL ,
	[TradeshopId] [int] NOT NULL ,
	[SaleRepId] [int] NOT NULL ,
	[DDate] [datetime] NOT NULL ,
	[PaymentTermId] [int] NOT NULL ,
	[DelayPayment] [int] NOT NULL ,
	[DelayType] [smallint] NOT NULL ,
	[PaymentDate] [datetime] NOT NULL ,
	[FirstPayment] [datetime] NULL ,
	[LastPayment] [datetime] NULL ,
	[FixPayment] [datetime] NULL ,
	[PayDelay] [int] NOT NULL ,
	[Amount] [money] NOT NULL ,
	[LeftAmount] [money] NOT NULL ,
	[PayPercent] [int] NOT NULL ,
	[OnControl] [bit] NOT NULL 
) ON [PRIMARY]
GO

 CREATE  CLUSTERED  INDEX [IX_PayHistoryInActs_Date] ON [dbo].[t_PayHistoryInActs]([Date]) WITH  FILLFACTOR =  80  ON [PRIMARY]
GO

ALTER TABLE [dbo].[t_PayHistoryInActs] WITH NOCHECK ADD 
	CONSTRAINT [PK_PayHistoryInActs] PRIMARY KEY  NONCLUSTERED 
	(
		[InItemId]
	)  ON [PRIMARY] ,
	CONSTRAINT [AK_PayHistoryInActs_UniqueDocumentItem] UNIQUE  NONCLUSTERED 
	(
		[DocumentId],
		[OperationId],
		[ItemId]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_PayHistoryInActs_PayDelay] ON [dbo].[t_PayHistoryInActs]([PayDelay]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_PayHistoryInActs_PayPercent] ON [dbo].[t_PayHistoryInActs]([PayPercent]) ON [PRIMARY]
GO