USE [xtyasrs]
|
GO
|
|
/****** Object: Table [dbo].[asr_loc_normal_log] Script Date: 2021/6/21 16:27:31 ******/
|
SET ANSI_NULLS ON
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
GO
|
|
SET ANSI_PADDING ON
|
GO
|
|
CREATE TABLE [dbo].[asr_loc_normal_log](
|
[create_time] [datetime] NULL,
|
[update_time] [datetime] NULL,
|
[create_user] [bigint] NULL,
|
[update_user] [bigint] NULL,
|
[warehouse] [varchar](255) NULL,
|
[matnr] [varchar](50) NULL,
|
[maktx] [varchar](max) NULL,
|
[anfme] [decimal](24, 9) NULL,
|
[lgnum] [varchar](255) NULL,
|
[type] [varchar](50) NULL,
|
[mnemonic] [varchar](255) NULL,
|
[supplier] [varchar](255) NULL,
|
[memo] [varchar](600) NULL,
|
[io_type] [int] NULL
|
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
|
|
GO
|
|
SET ANSI_PADDING OFF
|
GO
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出入库类型(1入库,2出库,3修改,4删除)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'asr_loc_normal_log', @level2type=N'COLUMN',@level2name=N'io_type'
|
GO
|
