/* 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]