· 7 years ago · Sep 20, 2018, 10:26 AM
1IF NOT EXISTS ( SELECT *
2 FROM sys.objects
3 WHERE object_id = OBJECT_ID(N'DMSSalesmanStockRequestHeader')
4 AND type IN ( N'U' ) )
5 BEGIN
6
7CREATE TABLE [dbo].[DMSSalesmanStockRequestHeader](
8 [CompanyID] [INT] NOT NULL ,
9 [LineNbr] [INT] IDENTITY(1, 1) NOT NULL ,
10 [RefNbr] [varchar](50) NULL ,
11 [AimRefNbr] [varchar](50) NULL ,
12 [Status] [char](1) NULL,
13 [Hold] [bit] NULL,
14 [TranDate] [datetime2](0) NULL,
15 [TranDesc] [nvarchar](256) NULL,
16 [TranReason] [char](1) NULL,
17 [LocationID] [int] NULL,
18 [ToLocationID] [int] NULL,
19 [Payment] [decimal](19, 0) NULL,
20 [Total] [decimal](19, 0) NULL,
21 [EmployeeCD] [varchar](15) NULL,
22 [DistributorCD] [nvarchar](50) NULL,
23 [CreatedByID] [UNIQUEIDENTIFIER] NOT NULL ,
24 [CreatedByScreenID] [CHAR](8) NOT NULL ,
25 [CreatedDateTime] [DATETIME] NOT NULL ,
26 [LastModifiedByID] [UNIQUEIDENTIFIER] NOT NULL ,
27 [LastModifiedByScreenID] [CHAR](8) NOT NULL ,
28 [LastModifiedDateTime] [DATETIME] NOT NULL ,
29 [Tstamp] [TIMESTAMP] NOT NULL ,
30 [SiteID] INT NULL,
31 [INTranRefNbr] [varchar](50) NULL
32 CONSTRAINT [PK_DMSSalesmanStockRequestHeader] PRIMARY KEY CLUSTERED
33(
34 [CompanyID] ASC,
35 [LineNbr] ASC
36)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
37) ON [PRIMARY]
38
39 END
40GO