1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
| USE [Jiepei_WMS]
| GO
|
| CREATE TABLE [dbo].[WMInInventoryInfo](
| [Id] [int] IDENTITY(1,1) NOT NULL,
| [InInventoryId] [int] NOT NULL,
| [ProductId] [int] NOT NULL,
| [WareHouseId] [int] NOT NULL,
| [PurchaseUnit] [varchar](10) NOT NULL,
| [Price] [decimal](18, 2) NOT NULL,
| [Quantity] [decimal](18, 2) NOT NULL,
| [CheckNum] [decimal](18, 2) NOT NULL,
| [PurchaseNum] [decimal](18, 2) NULL,
| [StorageNum] [decimal](18, 2) NULL,
| [Remark] [nvarchar](500) NULL,
| [LocationId] [int] NOT NULL,
| [InTime] [datetime] NOT NULL,
| [CreateTime] [datetime] NULL,
| CONSTRAINT [PK_WMInInventoryInfo] PRIMARY KEY CLUSTERED
| (
| [Id] ASC
| )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
| ) ON [PRIMARY]
| GO
|
| EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Èë¿âµ¥Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WMInInventoryInfo', @level2type=N'COLUMN',@level2name=N'InInventoryId'
| GO
|
| EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÉÌÆ·Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WMInInventoryInfo', @level2type=N'COLUMN',@level2name=N'ProductId'
| GO
|
| EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'²Ö¿âId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WMInInventoryInfo', @level2type=N'COLUMN',@level2name=N'WareHouseId'
| GO
|
| EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'²É¹ºµ¥Î»' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WMInInventoryInfo', @level2type=N'COLUMN',@level2name=N'PurchaseUnit'
| GO
|
| EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'µ¥¼Û' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WMInInventoryInfo', @level2type=N'COLUMN',@level2name=N'Price'
| GO
|
| EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÊýÁ¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WMInInventoryInfo', @level2type=N'COLUMN',@level2name=N'Quantity'
| GO
|
| EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÉóºËÊýÁ¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WMInInventoryInfo', @level2type=N'COLUMN',@level2name=N'CheckNum'
| GO
|
| EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'²É¹ºÊýÁ¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WMInInventoryInfo', @level2type=N'COLUMN',@level2name=N'PurchaseNum'
| GO
|
| EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Èë¿âÊýÁ¿' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WMInInventoryInfo', @level2type=N'COLUMN',@level2name=N'StorageNum'
| GO
|
| EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'±¸×¢' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WMInInventoryInfo', @level2type=N'COLUMN',@level2name=N'Remark'
| GO
|
| EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿âλId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WMInInventoryInfo', @level2type=N'COLUMN',@level2name=N'LocationId'
| GO
|
| EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Èë¿âʱ¼ä' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WMInInventoryInfo', @level2type=N'COLUMN',@level2name=N'InTime'
| GO
|
| EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'´´½¨Ê±¼ä' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'WMInInventoryInfo', @level2type=N'COLUMN',@level2name=N'CreateTime'
| GO
|
|
