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
| // 新建视图 asr_sumloc_view
| select matnr,maktx,anfme, altme, memo from asr_loc_detl
| union all
| select matnr,maktx,anfme, unit as altme, memo from man_loc_detl
|
| // 新增表结构
| SET ANSI_NULLS ON
| GO
|
| SET QUOTED_IDENTIFIER ON
| GO
|
| SET ANSI_PADDING ON
| GO
|
| CREATE TABLE [dbo].[asr_wrk_loc_sync](
| [matnr] [varchar](255) NOT NULL,
| [qty] [decimal](24, 9) NOT NULL,
| [state] [varchar](10) NULL,
| [create_time] [datetime] NULL,
| [create_by] [bigint] NULL,
| [update_time] [datetime] NULL,
| [update_by] [bigint] NULL
| ) ON [PRIMARY]
|
| GO
|
| SET ANSI_PADDING OFF
| GO
|
| EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_wrk_loc_sync', @level2type=N'COLUMN',@level2name=N'matnr'
| GO
|
| EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_wrk_loc_sync', @level2type=N'COLUMN',@level2name=N'qty'
| GO
|
| EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态(N未上传,X上传失败)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_wrk_loc_sync', @level2type=N'COLUMN',@level2name=N'state'
| GO
|
|
