CREATE TABLE [dbo].[STROKI_2002] (
	[Sklad_code] [int] NOT NULL ,
	[Type_doc] [tinyint] NOT NULL ,
	[Doc_number] [varchar] ( 10 ) NOT NULL ,
	[Str_number] [smallint] NOT NULL ,
	[Towar_code] [varchar] ( 20 ) NOT NULL ,
	[Kol] [int] NULL ,
	[Sum_fact] [money] NULL ,
	[Sum_zak] [money] NULL ,
	[Sum_uch] [money] NULL ,
	[NSP] [tinyint] NULL ,
	[NDS_zak] [tinyint] NULL ,
	[Card_number] [varchar] ( 20 ) NULL ,
	[Discount] [real] NULL ,
	[NDS_prod] [tinyint] NULL ,
	[Dat] [smalldatetime] NOT NULL ,
	[Partner_code] [int] NULL ,
	[Filial_code] [int] NULL ,
	[Diler_code] [int] NULL ,
	[For_ost] AS (case [Type_doc] when  1  then [Kol] else (((-[Kol]))) end) 
) ON [PRIMARY]
GO

 CREATE  UNIQUE  INDEX [IX_STROKI_2002] ON [dbo].[STROKI_2002]([Type_doc], [Sklad_code], [Dat], [Doc_number], [Str_number]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_STROKI_2002_1] ON [dbo].[STROKI_2002]([Towar_code]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_STROKI_2002_2] ON [dbo].[STROKI_2002]([Partner_code]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[STROKI_2002] ADD 
	CONSTRAINT [FK_STROKI_2002_DOC_TYPE] FOREIGN KEY 
	([Type_doc]) REFERENCES [dbo].[DOC_TYPE] ([Type_doc]),
	CONSTRAINT [FK_STROKI_2002_DOCUMENT] FOREIGN KEY 
	(	[Type_doc],
		[Sklad_code],
		[Dat],
		[Doc_number]
	) REFERENCES [dbo].[DOCUMENT] (
		[Type_doc],
		[Sklad_code],
		[Dat],
		[Doc_number]
	) ON DELETE CASCADE  ON UPDATE CASCADE ,
	CONSTRAINT [FK_STROKI_2002_PARTNER] FOREIGN KEY 	(
		[Partner_code]
	) REFERENCES [dbo].[PARTNER] (
		[Partner_code]
	),
	CONSTRAINT [FK_STROKI_2002_SKLAD] FOREIGN KEY 
	(
		[Sklad_code]
	) REFERENCES [dbo].[SKLAD] (
		[Sklad_code]
	),
	CONSTRAINT [FK_STROKI_2002_TOWAR1] FOREIGN KEY 
	(
		[Towar_code]
	) REFERENCES [dbo].[TOWAR] (
		[Towar_code]
	)
GO