/* v1.0.1 */
|
--表结构变更
|
alter table dbo.asr_loc_detl add mat_status varchar(10);
|
alter table dbo.asr_wrk_detl add mat_status varchar(10);
|
/* v1.0.2 2021.03.05 */
|
--表结构变更
|
CREATE TABLE [dbo].[asr_loc_normal](
|
[matnr] [varchar](50) NOT NULL,
|
[maktx] [nvarchar](50) NULL,
|
[lgnum] [varchar](255) NULL,
|
[type] [varchar](50) NULL,
|
[mnemonic] [varchar](255) NULL,
|
[supplier] [varchar](255) NULL,
|
[warehouse] [varchar](255) NULL,
|
[brand] [varchar](255) NULL,
|
[anfme] [decimal](24, 9) NULL,
|
[altme] [nvarchar](50) NULL,
|
[bname] [nvarchar](50) NULL,
|
[memo] [varchar](600) NULL,
|
[modi_user] [bigint] NULL,
|
[modi_time] [datetime] NULL,
|
[appe_user] [bigint] NULL,
|
[appe_time] [datetime] NULL,
|
[state] [varchar](10) NULL,
|
CONSTRAINT [PK_asr_loc_normal] PRIMARY KEY CLUSTERED
|
(
|
[matnr] ASC
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
) ON [PRIMARY]
|
