YtDHTz6b

1IF NOT EXISTS ( SELECT  *
2                FROM    sys.objects
3                WHERE   object_id = OBJECT_ID(N'DMSSalesmanStockRequestDetail')
4                        AND type IN ( N'U' ) )
5    BEGIN
6
7CREATE TABLE [dbo].[DMSSalesmanStockRequestDetail](
8		[CompanyID] [INT] NOT NULL ,
9		[LineNbr] [INT] IDENTITY(1, 1)NOT NULL ,
10		[RefNbr] [varchar](50) NOT NULL ,
11		[InventoryID] [INT] NOT NULL,
12		[SalesQty] [int] NULL,
13		[UnitPrice] [decimal](18, 2) NULL,
14		[TotalAmount] [decimal](18, 2) NULL,
15		[LotSerialNbr] [nvarchar](100) NULL,
16		[ExpirationDate] [DATETIME] NULL ,
17		[CreatedByID] [UNIQUEIDENTIFIER] NOT NULL ,
18		[CreatedByScreenID] [CHAR](8) NOT NULL ,
19		[CreatedDateTime] [DATETIME] NOT NULL ,
20		[LastModifiedByID] [UNIQUEIDENTIFIER] NOT NULL ,
21		[LastModifiedByScreenID] [CHAR](8) NOT NULL ,
22		[LastModifiedDateTime] [DATETIME] NOT NULL ,
23		[Tstamp] [TIMESTAMP] NOT NULL ,
24 CONSTRAINT [PK_DMSSalesmanStockRequestDetail] PRIMARY KEY CLUSTERED 
25(
26	[CompanyID] ASC,
27	[LineNbr] ASC,
28	[RefNbr] ASC
29)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
30) ON [PRIMARY]
31
32
33    END 
34GO