USE [master]
GO
/****** Object:  Database [dwms4]    Script Date: 2017/6/4 0:19:58 ******/
CREATE DATABASE [dwms4]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'dwms4', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL11.ELE\MSSQL\DATA\dwms4.mdf' , SIZE = 160768KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'dwms4_log', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL11.ELE\MSSQL\DATA\dwms4_log.ldf' , SIZE = 1785856KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [dwms4] SET COMPATIBILITY_LEVEL = 110
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [dwms4].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [dwms4] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [dwms4] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [dwms4] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [dwms4] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [dwms4] SET ARITHABORT OFF 
GO
ALTER DATABASE [dwms4] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [dwms4] SET AUTO_CREATE_STATISTICS ON 
GO
ALTER DATABASE [dwms4] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [dwms4] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [dwms4] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [dwms4] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [dwms4] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [dwms4] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [dwms4] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [dwms4] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [dwms4] SET  DISABLE_BROKER 
GO
ALTER DATABASE [dwms4] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [dwms4] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [dwms4] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [dwms4] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [dwms4] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [dwms4] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [dwms4] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [dwms4] SET RECOVERY FULL 
GO
ALTER DATABASE [dwms4] SET  MULTI_USER 
GO
ALTER DATABASE [dwms4] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [dwms4] SET DB_CHAINING OFF 
GO
ALTER DATABASE [dwms4] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [dwms4] SET TARGET_RECOVERY_TIME = 0 SECONDS 
GO
EXEC sys.sp_db_vardecimal_storage_format N'dwms4', N'ON'
GO
USE [dwms4]
GO
USE [dwms4]
GO
/****** Object:  Sequence [dbo].[seqOrderNo]    Script Date: 2017/6/4 0:19:59 ******/
CREATE SEQUENCE [dbo].[seqOrderNo] 
 AS [bigint]
 START WITH 0
 INCREMENT BY 1
 MINVALUE -9223372036854775808
 MAXVALUE 9223372036854775807
 CACHE 
GO
/****** Object:  Table [dbo].[t_Authority]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_Authority](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[auth_uplevel] [int] NULL,
	[auth_name] [nvarchar](50) NULL,
	[auth_link] [nvarchar](500) NULL,
	[auth_class] [nvarchar](250) NULL,
	[auth_public] [bit] NULL,
	[auth_desc] [nvarchar](100) NULL,
	[auth_marqueen] [bit] NULL,
	[auth_publicInfomation] [bit] NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_AUTHORITY] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_Department]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_Department](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[dep_name] [nvarchar](100) NULL,
	[dep_mastdept] [int] NULL,
	[dep_code] [nvarchar](100) NULL,
	[dep_desc] [nvarchar](200) NULL,
	[dep_type] [nvarchar](50) NULL,
	[dep_manager] [int] NULL,
	[create_time] [datetime] NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_DEPARTMENT] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_DeptEmp]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_DeptEmp](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[de_dept] [int] NULL,
	[de_employee] [int] NULL,
	[de_title] [nvarchar](50) NULL,
	[operater] [int] NULL,
	[dr] [bit] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_DEPTEMP] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_Employee]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_Employee](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[em_name] [nvarchar](10) NULL,
	[em_sex] [bit] NULL,
	[em_birthday] [smalldatetime] NULL,
	[em_education] [nvarchar](10) NULL,
	[em_dept] [nvarchar](10) NULL,
	[em_jobcode] [nvarchar](10) NULL,
	[em_politic] [nvarchar](20) NULL,
	[em_date_in_party] [smalldatetime] NULL,
	[em_date_work] [smalldatetime] NULL,
	[em_idnum] [nvarchar](30) NULL,
	[em_cellnum] [nvarchar](20) NULL,
	[em_email] [nvarchar](50) NULL,
	[em_account] [nvarchar](50) NULL,
	[em_passwd] [nvarchar](200) NULL,
	[em_profile] [nchar](50) NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
	[em_isOnline] [bit] NULL,
 CONSTRAINT [PK_T_EMPLOYEE] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_Filesmgr]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_Filesmgr](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[File_type] [int] NULL,
	[File_Project] [int] NULL,
	[File_ProjectDetail] [int] NULL,
	[File_Emp] [int] NULL,
	[file_Dept] [int] NULL,
	[file_dest] [nvarchar](200) NULL,
	[File_Desc] [nvarchar](50) NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_FILESMGR] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_GoodsType]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_GoodsType](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[goodsName] [nvarchar](255) NULL,
	[goodsDesc] [nvarchar](500) NULL,
	[create_time] [datetime] NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_GOODSTYPE] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_lesson]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_lesson](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[le_category] [int] NULL,
	[le_name] [nvarchar](100) NULL,
	[le_desc] [nvarchar](500) NULL,
	[le_startdate] [smalldatetime] NULL,
	[le_enddate] [smalldatetime] NULL,
	[le_location] [nvarchar](200) NULL,
	[le_xuefen] [int] NULL,
	[le_trainer] [nvarchar](100) NULL,
	[le_master] [int] NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_LESSON] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_lessonCategory]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_lessonCategory](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[lc_uplevel] [int] NOT NULL,
	[lc_name] [nvarchar](100) NULL,
	[lc_desc] [nvarchar](500) NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_LESSONCATEGORY] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_Log]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_Log](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[log_empid] [int] NULL,
	[log_account] [nvarchar](100) NULL,
	[log_sessionid] [nvarchar](200) NULL,
	[log_page] [nvarchar](200) NULL,
	[log_method] [nvarchar](100) NULL,
	[log_sql] [nvarchar](1000) NULL,
	[log_parameters] [nvarchar](2000) NULL,
	[log_exception] [nvarchar](4000) NULL,
	[log_clientip] [nvarchar](20) NULL,
	[log_browseinfo] [nvarchar](1000) NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_SQLLOG] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_node]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_node](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](50) NULL,
	[description] [nvarchar](250) NULL,
	[parentid] [int] NULL,
	[flag] [int] NULL,
	[operater] [int] NULL,
	[lastmodified] [datetime] NULL,
	[createtime] [datetime] NULL,
	[dr] [bit] NULL,
 CONSTRAINT [PK_t_node] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
 CONSTRAINT [Unique_t_node_name_parentid] UNIQUE NONCLUSTERED 
(
	[name] ASC,
	[parentid] ASC,
	[dr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_Project]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_Project](
	[pk_t_project] [int] IDENTITY(100,1) NOT NULL,
	[pj_name] [nvarchar](50) NULL,
	[pj_type] [nvarchar](50) NULL,
	[pj_dept] [int] NULL,
	[pj_nextDept] [int] NULL,
	[pj_master] [int] NULL,
	[pj_planStartDate] [smalldatetime] NULL,
	[pj_planEndDate] [smalldatetime] NULL,
	[pj_finishDate] [smalldatetime] NULL,
	[pj_percent] [int] NULL,
	[pj_status] [varchar](250) NULL,
	[pj_mem] [nvarchar](500) NULL,
	[pj_memPreSubmit] [nvarchar](500) NULL,
	[pj_mem4del] [nvarchar](500) NULL,
	[pj_memPreApprove] [nvarchar](500) NULL,
	[pj_memApprove] [nvarchar](500) NULL,
	[pj_memFinalApprove] [nvarchar](500) NULL,
	[pj_score] [numeric](18, 1) NULL,
	[pj_progress] [int] NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_PROJECT] PRIMARY KEY CLUSTERED 
(
	[pk_t_project] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[t_ProjectApproveList]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_ProjectApproveList](
	[pk_projectApproveList] [int] IDENTITY(100,1) NOT NULL,
	[pa_isProj] [bit] NULL,
	[pa_id] [int] NULL,
	[pa_emp] [int] NULL,
	[pa_dept] [int] NULL,
	[pa_pass] [bit] NULL,
	[pa_score] [numeric](10, 2) NULL,
	[pa_mem] [nvarchar](2000) NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_PROJECTAPPROVELIST] PRIMARY KEY CLUSTERED 
(
	[pk_projectApproveList] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_ProjectDetail]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_ProjectDetail](
	[pk_projDetail] [int] IDENTITY(100,1) NOT NULL,
	[pd_project] [int] NULL,
	[pd_year] [nvarchar](4) NULL,
	[pd_month] [nvarchar](2) NULL,
	[pd_planTarget] [nvarchar](50) NULL,
	[pd_finishedTarget] [nvarchar](50) NULL,
	[pd_percent] [int] NULL,
	[pd_status] [nvarchar](50) NULL,
	[pd_score] [numeric](18, 2) NULL,
	[pd_mem] [nvarchar](500) NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_PROJECTDETAIL] PRIMARY KEY CLUSTERED 
(
	[pk_projDetail] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_PublicNews]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_PublicNews](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[news_title] [nvarchar](200) NULL,
	[news_content] [nvarchar](4000) NULL,
	[news_alert] [bit] NULL,
	[news_authority] [int] NULL,
	[news_startdate] [datetime] NULL,
	[news_endDate] [datetime] NULL,
	[dr] [bit] NULL,
	[create_time] [smalldatetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_PUBLICNEWS] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_Role]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_Role](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[role_4Approve] [bit] NULL,
	[role_name] [nvarchar](50) NULL,
	[role_desc] [nvarchar](200) NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_ROLE] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_RoleAuthority]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_RoleAuthority](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[ra_role] [int] NULL,
	[ra_authority] [int] NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_ROLE_AUTHORITY] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_RoleEmp]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_RoleEmp](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[re_role] [int] NULL,
	[re_employee] [int] NULL,
	[operater] [int] NULL,
	[dr] [bit] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_ROLE_EMP] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_trainingDetail]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_trainingDetail](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[train_lesson] [int] NULL,
	[train_student] [int] NULL,
	[train_score] [int] NULL,
	[train_passed] [bit] NULL,
	[train_passedDate] [smalldatetime] NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_TRAININGDETAIL] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsDealLocation]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsDealLocation](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[locationFrom] [nvarchar](50) NULL,
	[locationTo] [nvarchar](50) NULL,
	[goodsId] [nvarchar](50) NULL,
	[batch] [nvarchar](50) NULL,
	[productDate] [nvarchar](50) NULL,
	[validDate] [nvarchar](50) NULL,
	[count] [decimal](18, 2) NULL,
	[outCount] [decimal](18, 2) NULL,
	[manufacturer] [nvarchar](200) NULL,
	[state] [int] NULL,
	[checkBy] [int] NULL,
	[description] [nvarchar](250) NULL,
	[printCnt] [int] NULL,
	[finishedTime] [datetime] NULL,
	[operater] [int] NULL,
	[lastmodified] [datetime] NULL,
	[createtime] [datetime] NULL,
	[dr] [bit] NULL,
 CONSTRAINT [PK_t_wmsDealLocation] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsGoods]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsGoods](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[goodsId] [nvarchar](50) NOT NULL,
	[goodsType] [int] NULL,
	[part] [int] NULL,
	[full_max] [decimal](18, 2) NULL,
	[bulkMax] [decimal](18, 2) NULL,
	[bulkMax1] [decimal](18, 2) NULL,
	[batchMax1] [decimal](18, 2) NULL,
	[batchMax2] [decimal](18, 2) NULL,
	[batchMax3] [decimal](18, 2) NULL,
	[batchMax4] [decimal](18, 2) NULL,
	[length] [decimal](18, 2) NULL,
	[width] [decimal](18, 2) NULL,
	[height] [decimal](18, 2) NULL,
	[validTermDays] [int] NULL,
	[bigCount] [decimal](18, 2) NULL,
	[operater] [int] NULL,
	[lastmodified] [datetime] NULL,
	[createtime] [datetime] NULL,
	[dr] [bit] NULL,
 CONSTRAINT [PK_wms_goods_infor_base] PRIMARY KEY CLUSTERED 
(
	[goodsId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsInRequest]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsInRequest](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[orderNo] [nvarchar](50) NOT NULL,
	[orderType] [int] NULL,
	[orderTypeName] [nvarchar](50) NULL,
	[vender] [nvarchar](250) NULL,
	[owner] [nvarchar](250) NULL,
	[state] [int] NULL,
	[orderDate] [date] NULL,
	[description] [nvarchar](250) NULL,
	[operater] [int] NULL,
	[lastmodified] [datetime] NULL,
	[createtime] [datetime] NULL,
	[dr] [bit] NULL,
 CONSTRAINT [PK_t_wmsInRequest] PRIMARY KEY CLUSTERED 
(
	[orderNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsInRequestDetail]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsInRequestDetail](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[orderNo] [nvarchar](50) NULL,
	[goodsId] [nvarchar](50) NOT NULL,
	[goodsName] [nvarchar](50) NULL,
	[cnt] [decimal](18, 0) NULL,
	[countIn] [decimal](18, 0) NULL,
	[productDate] [nvarchar](50) NULL,
	[batch] [nvarchar](50) NULL,
	[barcode] [nvarchar](50) NULL,
	[validDate] [nvarchar](50) NULL,
	[regeditCode] [nvarchar](50) NULL,
	[manufacturer] [nvarchar](250) NULL,
	[state] [int] NULL,
	[description] [nvarchar](250) NULL,
	[operater] [int] NULL,
	[lastmodified] [datetime] NULL,
	[createtime] [datetime] NULL,
	[dr] [bit] NULL,
 CONSTRAINT [PK_t_wmsInRequestDetail] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsLocation]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_wmsLocation](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[locationId] [nvarchar](50) NOT NULL,
	[locationId128] [nvarchar](250) NULL,
	[warehouse] [int] NULL,
	[channel] [varchar](50) NULL,
	[shelf] [varchar](50) NULL,
	[layer] [int] NULL,
	[col] [int] NULL,
	[elabId] [int] NULL,
	[elabAddress] [int] NULL,
	[height] [decimal](18, 2) NULL,
	[width] [decimal](18, 2) NULL,
	[length] [decimal](18, 2) NULL,
	[weight] [decimal](18, 2) NULL,
	[port] [int] NULL,
	[part] [varchar](50) NULL,
	[bigPart] [varchar](50) NULL,
	[goodsType] [int] NULL,
	[whType] [int] NULL,
	[whGoodsType] [int] NULL,
	[whVolType] [int] NULL,
	[volType] [int] NULL,
	[state] [int] NULL,
	[tranState] [int] NULL,
	[operater] [int] NULL,
	[lastmodified] [datetime] NULL,
	[createtime] [datetime] NULL,
	[dr] [bit] NULL,
 CONSTRAINT [PK_t_wmslocation] PRIMARY KEY CLUSTERED 
(
	[locationId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[t_wmsOutBox]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsOutBox](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[desk] [int] NOT NULL,
	[desk128] [nvarchar](50) NULL,
	[state] [int] NULL,
	[operater] [int] NULL,
	[dr] [bit] NULL,
	[createtime] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_t_wmsOutBox] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsOutDesk]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_wmsOutDesk](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[color] [int] NOT NULL,
	[deskName] [nvarchar](50) NOT NULL,
	[ip] [nvarchar](50) NOT NULL,
	[macaddress] [varchar](50) NULL,
	[remark] [nvarchar](250) NULL,
	[state] [int] NULL,
	[operater] [int] NULL,
	[dr] [bit] NULL,
	[createtime] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_t_wmsOutDesk] PRIMARY KEY CLUSTERED 
(
	[color] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[t_wmsOutDetail]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsOutDetail](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[orderNo] [nvarchar](50) NOT NULL,
	[goodsId] [nvarchar](50) NULL,
	[batch] [nvarchar](50) NULL,
	[count] [decimal](18, 2) NULL,
	[bulkCount] [decimal](18, 2) NULL,
	[batch1Count] [decimal](18, 2) NULL,
	[batch2Count] [decimal](18, 2) NULL,
	[boxcnt] [int] NULL,
	[productDate] [nvarchar](50) NULL,
	[validDate] [nvarchar](50) NULL,
	[state] [int] NULL,
	[whtype] [int] NULL,
	[description] [nvarchar](250) NULL,
	[operater] [int] NULL,
	[dr] [bit] NULL,
	[createtime] [datetime] NULL,
	[lastmodified] [datetime] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsOutPickDetail]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsOutPickDetail](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[pickOrderNo] [nvarchar](50) NOT NULL,
	[orderNo] [nvarchar](50) NULL,
	[customerId] [nvarchar](50) NULL,
	[customerName] [nvarchar](250) NULL,
	[goodsId] [nvarchar](50) NULL,
	[batch] [nvarchar](50) NULL,
	[count] [decimal](18, 2) NULL,
	[bulkCount] [decimal](18, 2) NULL,
	[batch1Count] [decimal](18, 2) NULL,
	[batch2Count] [decimal](18, 2) NULL,
	[boxcnt] [int] NULL,
	[productDate] [nvarchar](50) NULL,
	[validDate] [nvarchar](50) NULL,
	[state] [int] NULL,
	[whtype] [int] NULL,
	[description] [nvarchar](250) NULL,
	[confirmedCount] [decimal](18, 2) NULL,
	[checkedBy] [int] NULL,
	[validReason] [int] NULL,
	[validSolution] [int] NULL,
	[validRemark] [nvarchar](250) NULL,
	[solutionRemark] [nvarchar](250) NULL,
	[checkedTime] [datetime] NULL,
	[operater] [int] NULL,
	[dr] [bit] NULL,
	[createtime] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_t_wmsOutPickDetail] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsOutPickDetail_error]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsOutPickDetail_error](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[pickOrderNo] [nvarchar](50) NOT NULL,
	[orderNo] [nvarchar](50) NULL,
	[customerId] [nvarchar](50) NULL,
	[customerName] [nvarchar](250) NULL,
	[goodsId] [nvarchar](50) NULL,
	[batch] [nvarchar](50) NULL,
	[count] [decimal](18, 2) NULL,
	[bulkCount] [decimal](18, 2) NULL,
	[batch1Count] [decimal](18, 2) NULL,
	[batch2Count] [decimal](18, 2) NULL,
	[boxcnt] [int] NULL,
	[productDate] [nvarchar](50) NULL,
	[validDate] [nvarchar](50) NULL,
	[state] [int] NULL,
	[whtype] [int] NULL,
	[description] [nvarchar](250) NULL,
	[confirmedCount] [decimal](18, 2) NULL,
	[checkedBy] [int] NULL,
	[validReason] [int] NULL,
	[validSolution] [int] NULL,
	[validRemark] [nvarchar](250) NULL,
	[solutionRemark] [nvarchar](250) NULL,
	[checkedTime] [datetime] NULL,
	[operater] [int] NULL,
	[dr] [bit] NULL,
	[createtime] [datetime] NULL,
	[lastmodified] [datetime] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsOutPickDetail_tmp]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsOutPickDetail_tmp](
	[desk] [int] NULL,
	[orderState] [int] NULL,
	[waveOrder] [nvarchar](50) NULL,
	[id] [int] NOT NULL,
	[pickOrderNo] [nvarchar](50) NOT NULL,
	[orderNo] [nvarchar](50) NULL,
	[customerId] [nvarchar](50) NULL,
	[customerName] [nvarchar](250) NULL,
	[goodsId] [nvarchar](50) NULL,
	[batch] [nvarchar](50) NULL,
	[count] [decimal](18, 2) NULL,
	[bulkCount] [decimal](18, 2) NULL,
	[batch1Count] [decimal](18, 2) NULL,
	[batch2Count] [decimal](18, 2) NULL,
	[boxcnt] [int] NULL,
	[productDate] [nvarchar](50) NULL,
	[validDate] [nvarchar](50) NULL,
	[state] [int] NULL,
	[whtype] [int] NULL,
	[description] [nvarchar](250) NULL,
	[confirmedCount] [decimal](18, 2) NULL,
	[checkedBy] [int] NULL,
	[validReason] [int] NULL,
	[validSolution] [int] NULL,
	[validRemark] [nvarchar](250) NULL,
	[solutionRemark] [nvarchar](250) NULL,
	[checkedTime] [datetime] NULL,
	[operater] [int] NULL,
	[dr] [bit] NULL,
	[createtime] [datetime] NULL,
	[lastmodified] [datetime] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsOutPickLable]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsOutPickLable](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[pickOrderNo] [nvarchar](50) NOT NULL,
	[waveOrder] [nvarchar](50) NOT NULL,
	[color] [int] NOT NULL,
	[recordId] [int] NOT NULL,
	[count] [decimal](18, 0) NULL,
	[locationId] [nvarchar](50) NULL,
	[elabId] [int] NULL,
	[port] [int] NULL,
	[elabAddress] [int] NULL,
	[state] [int] NULL,
	[pickCount] [decimal](18, 0) NULL,
	[description] [nvarchar](250) NULL,
	[operater] [int] NULL,
	[dr] [bit] NULL,
	[createtime] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_t_wmsOutPickLable] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsOutPickLable_tmp]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsOutPickLable_tmp](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[pickOrderNo] [nvarchar](50) NOT NULL,
	[waveOrder] [nvarchar](50) NOT NULL,
	[color] [int] NOT NULL,
	[recordId] [int] NOT NULL,
	[count] [decimal](18, 0) NULL,
	[locationId] [nvarchar](50) NULL,
	[elabId] [int] NULL,
	[port] [int] NULL,
	[elabAddress] [int] NULL,
	[state] [int] NULL,
	[pickCount] [decimal](18, 0) NULL,
	[description] [nvarchar](250) NULL,
	[operater] [int] NULL,
	[dr] [bit] NULL,
	[createtime] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_t_wmsOutPickLable_tmp] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsOutPickRequest]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsOutPickRequest](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[pickOrderNo] [nvarchar](50) NOT NULL,
	[waveOrder] [nvarchar](250) NULL,
	[orderType] [int] NULL,
	[orderTypeName] [nvarchar](50) NULL,
	[customerId] [nvarchar](50) NULL,
	[customerName] [nvarchar](250) NULL,
	[desk] [int] NOT NULL,
	[boxCnt] [int] NULL,
	[bulkCnt] [decimal](18, 0) NULL,
	[volume] [decimal](18, 0) NULL,
	[state] [int] NULL,
	[orderDate] [date] NULL,
	[description] [nvarchar](250) NULL,
	[pickedBye] [int] NULL,
	[pickedTime] [datetime] NULL,
	[checkedby] [int] NULL,
	[checkedTime] [datetime] NULL,
	[waveStart] [datetime] NULL,
	[waveEnd] [datetime] NULL,
	[operater] [int] NULL,
	[dr] [bit] NULL,
	[createtime] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_t_wmsOutPickRequest] PRIMARY KEY CLUSTERED 
(
	[pickOrderNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsOutRequest]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_wmsOutRequest](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[orderNo] [nvarchar](50) NOT NULL,
	[orderType] [int] NULL,
	[orderTypeName] [varchar](20) NULL,
	[customerId] [nvarchar](50) NULL,
	[customerName] [nvarchar](200) NULL,
	[address] [nvarchar](250) NULL,
	[delivery] [nvarchar](50) NULL,
	[phone1] [nvarchar](50) NULL,
	[phone2] [nvarchar](50) NULL,
	[salesperson] [nvarchar](50) NULL,
	[contactperson] [nvarchar](50) NULL,
	[totalnumber] [int] NULL,
	[remark] [nvarchar](250) NULL,
	[orderDate] [date] NULL,
	[state] [int] NULL,
	[operater] [int] NULL,
	[dr] [bit] NULL,
	[createtime] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_t_wmsOutRequest] PRIMARY KEY CLUSTERED 
(
	[orderNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[t_wmsOutRequestDetail]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsOutRequestDetail](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[orderNo] [nvarchar](50) NOT NULL,
	[orderSn] [int] NOT NULL,
	[goodsId] [nvarchar](50) NULL,
	[batch] [nvarchar](50) NULL,
	[productDate] [nvarchar](50) NULL,
	[validDate] [nvarchar](50) NULL,
	[count] [decimal](18, 2) NULL,
	[saleDate] [datetime] NULL,
	[state] [int] NULL,
	[whtype] [int] NULL,
	[description] [nvarchar](250) NULL,
	[operater] [int] NULL,
	[dr] [bit] NULL,
	[createtime] [datetime] NULL,
	[lastmodified] [datetime] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsOutValidationException]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsOutValidationException](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[pickDetail] [bit] NULL,
	[waveOrder] [nvarchar](50) NULL,
	[pickOrder] [nvarchar](50) NULL,
	[exception] [int] NULL,
	[exceptionRemark] [nvarchar](250) NULL,
	[exceptionLink] [nvarchar](250) NULL,
	[resolveRemark] [nvarchar](250) NULL,
	[resove] [int] NULL,
	[validatedBy] [int] NULL,
	[resolveBy] [int] NULL,
	[pickedBy] [int] NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_t_wmsOutValidationException] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsReceive]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsReceive](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[orderNo] [nvarchar](50) NOT NULL,
	[state] [int] NULL,
	[description] [nvarchar](250) NULL,
	[operater] [int] NULL,
	[lastmodified] [datetime] NULL,
	[createtime] [datetime] NULL,
	[dr] [bit] NULL,
 CONSTRAINT [PK_t_wmsReceive] PRIMARY KEY CLUSTERED 
(
	[orderNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsReceiveDetail]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsReceiveDetail](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[orderNo] [nvarchar](50) NULL,
	[goodsId] [nvarchar](50) NULL,
	[batch] [nvarchar](200) NULL,
	[productDate] [nvarchar](200) NULL,
	[valideDate] [nvarchar](200) NULL,
	[purCount] [decimal](18, 2) NULL,
	[arriveCount] [decimal](18, 2) NULL,
	[receiveCount] [decimal](18, 2) NULL,
	[checkCount] [decimal](18, 2) NULL,
	[rejectReason] [nvarchar](200) NULL,
	[receiveDate] [datetime] NULL,
	[receivedby] [nvarchar](50) NULL,
	[state] [int] NULL,
	[batchState] [int] NULL,
	[picState] [int] NULL,
	[receiveResult] [nvarchar](50) NULL,
	[description] [nvarchar](250) NULL,
	[operater] [int] NULL,
	[lastmodified] [datetime] NULL,
	[createtime] [datetime] NULL,
	[dr] [bit] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsStock]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsStock](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[goodsId] [nvarchar](50) NOT NULL,
	[batch] [nvarchar](200) NOT NULL,
	[locationId] [nvarchar](50) NOT NULL,
	[productDate] [nvarchar](50) NULL,
	[validDate] [nvarchar](50) NULL,
	[validationTerm] [int] NOT NULL,
	[count] [decimal](18, 2) NULL,
	[countLock] [decimal](18, 2) NULL,
	[countOut] [decimal](18, 2) NULL,
	[state] [int] NULL,
	[operater] [int] NULL,
	[lastmodified] [datetime] NULL,
	[createtime] [datetime] NULL,
	[dr] [bit] NULL,
 CONSTRAINT [PK_t_wmsStock] PRIMARY KEY CLUSTERED 
(
	[locationId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsStockRecord]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsStockRecord](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[id128] [nvarchar](200) NULL,
	[orderNo] [nvarchar](50) NOT NULL,
	[goodsId] [nvarchar](50) NOT NULL,
	[batch] [nvarchar](200) NULL,
	[locationId] [nvarchar](50) NOT NULL,
	[count] [decimal](18, 2) NULL,
	[direction] [int] NOT NULL,
	[validDate] [nvarchar](50) NULL,
	[productDate] [nvarchar](50) NULL,
	[regeditCode] [nvarchar](50) NULL,
	[description] [nvarchar](250) NULL,
	[printcnt] [int] NULL,
	[operater] [int] NULL,
	[lastmodified] [datetime] NULL,
	[createtime] [datetime] NULL,
	[dr] [bit] NULL,
 CONSTRAINT [PK_wmsStockRecord] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_workplan]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_workplan](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[wp_date] [smalldatetime] NULL,
	[wp_emp] [int] NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_WORKPLAN] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_workplanDetail]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_workplanDetail](
	[id] [int] IDENTITY(100,1) NOT NULL,
	[wpd_workplan] [int] NULL,
	[wpd_number] [int] NULL,
	[wpd_content] [nvarchar](1500) NULL,
	[wpd_mem] [nvarchar](500) NULL,
	[dr] [bit] NULL,
	[operater] [int] NULL,
	[create_time] [datetime] NULL,
	[lastmodified] [datetime] NULL,
 CONSTRAINT [PK_T_WORKPLANDETAIL] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  View [dbo].[v_erpGoods]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_erpGoods]
AS
SELECT   entid, GoodsId, goodsName, manufacturer, spec, unit, type, regeditCode, bigCount, middleCount, address, station, 
                weight, drug_code, isDouChk, barCode, Logogram, chang, kuan, gao, curCycle, isImport
FROM      custErp.dbo.v_erpGoods AS v_erpGoods_1

GO
/****** Object:  View [dbo].[v_wmsGoods]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_wmsGoods]
AS
SELECT   dbo.t_wmsGoods.ID, dbo.t_wmsGoods.goodsId, dbo.t_wmsGoods.goodsType, dbo.t_wmsGoods.part, 
                dbo.t_wmsGoods.full_max, dbo.t_wmsGoods.bulkMax, dbo.t_wmsGoods.bulkMax1, dbo.t_wmsGoods.batchMax1, 
                dbo.t_wmsGoods.batchMax2, dbo.t_wmsGoods.batchMax3, dbo.t_wmsGoods.batchMax4, dbo.t_wmsGoods.length, 
                dbo.t_wmsGoods.width, dbo.t_wmsGoods.height, dbo.t_wmsGoods.validTermDays, 
                dbo.t_node.name AS goodsTypeName, dbo.t_wmsGoods.dr, dbo.t_wmsGoods.createtime, 
                dbo.t_wmsGoods.lastmodified, dbo.t_wmsGoods.operater, dbo.v_erpGoods.goodsName, dbo.v_erpGoods.manufacturer, 
                dbo.v_erpGoods.spec, dbo.v_erpGoods.unit, dbo.v_erpGoods.regeditCode, dbo.v_erpGoods.middleCount, 
                dbo.v_erpGoods.bigCount, dbo.v_erpGoods.address, dbo.v_erpGoods.station, dbo.v_erpGoods.weight, 
                dbo.v_erpGoods.drug_code, dbo.v_erpGoods.isDouChk, dbo.v_erpGoods.barCode, dbo.v_erpGoods.chang, 
                dbo.v_erpGoods.kuan, dbo.v_erpGoods.gao, dbo.v_erpGoods.curCycle, dbo.v_erpGoods.isImport, 
                dbo.v_erpGoods.type
FROM      dbo.t_wmsGoods INNER JOIN
                dbo.v_erpGoods ON dbo.t_wmsGoods.goodsId = dbo.v_erpGoods.GoodsId LEFT OUTER JOIN
                dbo.t_node ON dbo.t_wmsGoods.goodsType = dbo.t_node.id

GO
/****** Object:  View [dbo].[v_stockOutDetail_wms]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockOutDetail_wms]
AS
SELECT   dbo.t_wmsOutDetail.*, dbo.v_wmsGoods.goodsTypeName, dbo.v_wmsGoods.goodsName, 
                dbo.v_wmsGoods.manufacturer, dbo.v_wmsGoods.spec, dbo.v_wmsGoods.unit, dbo.v_wmsGoods.regeditCode, 
                dbo.v_wmsGoods.barCode, dbo.v_wmsGoods.type, dbo.v_wmsGoods.bigCount
FROM      dbo.t_wmsOutDetail INNER JOIN
                dbo.v_wmsGoods ON dbo.t_wmsOutDetail.goodsId = dbo.v_wmsGoods.goodsId

GO
/****** Object:  View [dbo].[v_stockOutBulkInCurrentWave]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockOutBulkInCurrentWave]
AS
SELECT   dbo.t_wmsOutPickLable_tmp.id, dbo.t_wmsOutPickLable_tmp.pickOrderNo, dbo.t_wmsOutPickLable_tmp.waveOrder, 
                dbo.t_wmsOutPickLable_tmp.recordId, dbo.t_wmsOutPickLable_tmp.count, dbo.t_wmsOutPickLable_tmp.locationId, 
                dbo.t_wmsOutPickLable_tmp.elabId, dbo.t_wmsOutPickLable_tmp.port, dbo.t_wmsOutPickLable_tmp.elabAddress, 
                dbo.t_wmsOutPickLable_tmp.state, dbo.t_wmsOutPickLable_tmp.pickCount, dbo.t_wmsOutPickLable_tmp.description, 
                dbo.t_wmsOutPickLable_tmp.operater, dbo.t_wmsOutPickLable_tmp.dr, dbo.t_wmsOutPickLable_tmp.createtime, 
                dbo.t_wmsOutPickLable_tmp.lastmodified, dbo.v_wmsGoods.manufacturer, dbo.v_wmsGoods.goodsName, 
                dbo.v_wmsGoods.spec, dbo.v_wmsGoods.unit, dbo.v_wmsGoods.regeditCode, dbo.v_wmsGoods.drug_code, 
                dbo.v_wmsGoods.barCode, dbo.v_wmsGoods.goodsTypeName, dbo.t_wmsOutDesk.deskName AS colorName, 
                dbo.t_wmsOutPickRequest.customerName, dbo.t_wmsOutPickRequest.customerId, dbo.t_wmsStockRecord.productDate, 
                dbo.t_wmsStockRecord.validDate, dbo.t_wmsStockRecord.batch, dbo.t_wmsStockRecord.goodsId, 
                dbo.t_wmsOutPickLable_tmp.color, 0 AS isLightUp, 0 AS isPicked, dbo.v_wmsGoods.type
FROM      dbo.t_wmsOutPickLable_tmp LEFT OUTER JOIN
                dbo.t_wmsStockRecord ON dbo.t_wmsOutPickLable_tmp.recordId = dbo.t_wmsStockRecord.id LEFT OUTER JOIN
                dbo.t_wmsOutPickRequest ON dbo.t_wmsOutPickLable_tmp.pickOrderNo = dbo.t_wmsOutPickRequest.pickOrderNo AND 
                dbo.t_wmsOutPickLable_tmp.waveOrder = dbo.t_wmsOutPickRequest.waveOrder LEFT OUTER JOIN
                dbo.v_wmsGoods ON dbo.t_wmsStockRecord.goodsId = dbo.v_wmsGoods.goodsId LEFT OUTER JOIN
                dbo.t_wmsOutDesk ON dbo.t_wmsOutPickLable_tmp.color = dbo.t_wmsOutDesk.color

GO
/****** Object:  View [dbo].[v_stockOutWavePickDetail]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockOutWavePickDetail]
AS
SELECT   dbo.t_wmsOutPickRequest.waveOrder, dbo.t_wmsOutPickRequest.pickOrderNo, dbo.v_wmsGoods.goodsName, 
                dbo.v_wmsGoods.manufacturer, dbo.v_wmsGoods.spec, dbo.v_wmsGoods.unit, dbo.v_wmsGoods.regeditCode, 
                dbo.v_wmsGoods.drug_code, dbo.v_wmsGoods.barCode, dbo.v_wmsGoods.type, 
                dbo.t_wmsOutPickRequest.customerName, dbo.t_wmsOutPickRequest.customerId, dbo.t_wmsStockRecord.count, 
                dbo.t_wmsStockRecord.locationId, dbo.t_wmsStockRecord.batch, dbo.t_wmsStockRecord.goodsId, 
                dbo.t_wmsStockRecord.validDate, dbo.t_wmsStockRecord.productDate, dbo.t_wmsLocation.volType, 
                dbo.t_wmsLocation.elabId, dbo.t_wmsLocation.elabAddress, dbo.t_wmsStockRecord.id
FROM      dbo.t_wmsStockRecord LEFT OUTER JOIN
                dbo.t_wmsLocation ON dbo.t_wmsStockRecord.locationId = dbo.t_wmsLocation.locationId LEFT OUTER JOIN
                dbo.v_wmsGoods ON dbo.t_wmsStockRecord.goodsId = dbo.v_wmsGoods.goodsId RIGHT OUTER JOIN
                dbo.t_wmsOutPickRequest ON dbo.t_wmsStockRecord.orderNo = dbo.t_wmsOutPickRequest.pickOrderNo

GO
/****** Object:  View [dbo].[v_stockGoods]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockGoods]
AS
SELECT   dbo.t_wmsLocation.elabId, dbo.t_wmsLocation.elabAddress, dbo.t_wmsLocation.port, dbo.v_wmsGoods.bulkMax, 
                dbo.v_wmsGoods.bulkMax1, dbo.v_wmsGoods.batchMax1, dbo.v_wmsGoods.batchMax2, 
                dbo.v_wmsGoods.goodsName, dbo.v_wmsGoods.bigCount, dbo.t_wmsStock.id, dbo.t_wmsStock.goodsId, 
                dbo.t_wmsStock.batch, dbo.t_wmsStock.locationId, dbo.t_wmsStock.productDate, dbo.t_wmsStock.validDate, 
                dbo.t_wmsStock.validationTerm, dbo.t_wmsStock.count, dbo.t_wmsStock.countLock, dbo.t_wmsStock.countOut, 
                dbo.t_wmsStock.state, dbo.t_wmsStock.operater, dbo.t_wmsStock.lastmodified, dbo.t_wmsStock.createtime, 
                dbo.t_wmsStock.dr, dbo.t_wmsLocation.whVolType, dbo.t_wmsLocation.volType, dbo.v_wmsGoods.goodsTypeName, 
                dbo.v_wmsGoods.goodsType
FROM      dbo.t_wmsStock INNER JOIN
                dbo.t_wmsLocation ON dbo.t_wmsStock.locationId = dbo.t_wmsLocation.locationId INNER JOIN
                dbo.v_wmsGoods ON dbo.t_wmsStock.goodsId = dbo.v_wmsGoods.goodsId

GO
/****** Object:  View [dbo].[v_stockOutPickDetail]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockOutPickDetail]
AS
SELECT   dbo.t_wmsOutPickDetail.id, dbo.t_wmsOutPickDetail.pickOrderNo, dbo.t_wmsOutPickDetail.orderNo, 
                dbo.t_wmsOutPickDetail.customerId, dbo.t_wmsOutPickDetail.customerName, dbo.t_wmsOutPickDetail.goodsId, 
                dbo.t_wmsOutPickDetail.batch, dbo.t_wmsOutPickDetail.count, dbo.t_wmsOutPickDetail.bulkCount, 
                dbo.t_wmsOutPickDetail.batch1Count, dbo.t_wmsOutPickDetail.batch2Count, dbo.t_wmsOutPickDetail.boxcnt, 
                dbo.t_wmsOutPickDetail.productDate, dbo.t_wmsOutPickDetail.validDate, dbo.t_wmsOutPickDetail.state, 
                dbo.t_wmsOutPickDetail.whtype, dbo.t_wmsOutPickDetail.description, dbo.t_wmsOutPickDetail.confirmedCount, 
                dbo.t_wmsOutPickDetail.checkedBy, dbo.t_wmsOutPickDetail.validReason, dbo.t_wmsOutPickDetail.validSolution, 
                dbo.t_wmsOutPickDetail.validRemark, dbo.t_wmsOutPickDetail.solutionRemark, dbo.t_wmsOutPickDetail.checkedTime, 
                dbo.t_wmsOutPickDetail.operater, dbo.t_wmsOutPickDetail.dr, dbo.t_wmsOutPickDetail.createtime, 
                dbo.t_wmsOutPickDetail.lastmodified, dbo.v_wmsGoods.manufacturer, dbo.v_wmsGoods.goodsName, 
                dbo.v_wmsGoods.spec, dbo.v_wmsGoods.unit, dbo.v_wmsGoods.regeditCode, dbo.v_wmsGoods.bigCount, 
                dbo.v_wmsGoods.address, dbo.v_wmsGoods.barCode, dbo.v_wmsGoods.type
FROM      dbo.t_wmsOutPickDetail INNER JOIN
                dbo.v_wmsGoods ON dbo.t_wmsOutPickDetail.goodsId = dbo.v_wmsGoods.goodsId

GO
/****** Object:  View [dbo].[v_reportStockRecord]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_reportStockRecord]
AS
SELECT   a.id, a.id128 AS locationCode, a.orderNo, a.goodsId, a.batch, a.locationId, a.count, a.direction, a.validDate, 
                a.productDate, a.description, a.operater, a.lastmodified, a.createtime, a.dr, b.bigCount, b.unit, b.spec, b.manufacturer, 
                b.goodsName, CAST(a.count / b.bigCount AS decimal(18, 2)) AS box, b.type, b.regeditCode
FROM      dbo.t_wmsStockRecord AS a INNER JOIN
                dbo.v_wmsGoods AS b ON a.goodsId = b.goodsId

GO
/****** Object:  View [dbo].[v_stockInRequest_Available]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockInRequest_Available]
AS
SELECT   orderNo, orderTypeName, customID, orderDate, entid, orgid, remark AS DESCRIPTION, state, owner, vender
FROM      custErp.dbo.v_stockInRequest AS a
WHERE   (state = 0 OR
                state = 1) AND (NOT EXISTS
                    (SELECT   1 AS Expr1
                     FROM      dbo.t_wmsInRequest
                     WHERE   (orderNo = a.orderNo)))

GO
/****** Object:  View [dbo].[v_stockInRequestDetail_Available]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockInRequestDetail_Available]
AS
SELECT   dbo.v_stockInRequest_Available.orderNo, a.orderNoSn, a.goodsName, a.spec, a.unit, a.type, a.regeditCode, a.bigCount, 
                a.middleCount, a.address, a.station, a.weight, a.drug_code, a.isDouChk, a.barCode, a.curCycle, a.isImport, a.orderType, 
                a.goodsId, a.batch, a.productDate, a.count, a.addDate, a.State, a.manufacturer, a.price, a.validDate
FROM      custErp.dbo.v_stockInRequestDetail AS a INNER JOIN
                dbo.v_stockInRequest_Available ON a.orderNo = dbo.v_stockInRequest_Available.orderNo

GO
/****** Object:  View [dbo].[v_stockOutPickDetailValidation]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockOutPickDetailValidation]
AS
SELECT   dbo.t_wmsOutPickDetail_tmp.desk, dbo.t_wmsOutPickDetail_tmp.orderState, dbo.t_wmsOutPickDetail_tmp.waveOrder, 
                dbo.t_wmsOutPickDetail_tmp.id, dbo.t_wmsOutPickDetail_tmp.pickOrderNo, dbo.t_wmsOutPickDetail_tmp.orderNo, 
                dbo.t_wmsOutPickDetail_tmp.customerId, dbo.t_wmsOutPickDetail_tmp.customerName, 
                dbo.t_wmsOutPickDetail_tmp.goodsId, dbo.t_wmsOutPickDetail_tmp.batch, dbo.t_wmsOutPickDetail_tmp.count, 
                dbo.t_wmsOutPickDetail_tmp.bulkCount, dbo.t_wmsOutPickDetail_tmp.batch1Count, 
                dbo.t_wmsOutPickDetail_tmp.batch2Count, dbo.t_wmsOutPickDetail_tmp.boxcnt, 
                dbo.t_wmsOutPickDetail_tmp.productDate, dbo.t_wmsOutPickDetail_tmp.validDate, dbo.t_wmsOutPickDetail_tmp.state, 
                dbo.t_wmsOutPickDetail_tmp.whtype, dbo.t_wmsOutPickDetail_tmp.description, 
                dbo.t_wmsOutPickDetail_tmp.confirmedCount, dbo.t_wmsOutPickDetail_tmp.checkedBy, 
                dbo.t_wmsOutPickDetail_tmp.validRemark, dbo.t_wmsOutPickDetail_tmp.validReason, 
                dbo.t_wmsOutPickDetail_tmp.checkedTime, dbo.t_wmsOutPickDetail_tmp.operater, dbo.t_wmsOutPickDetail_tmp.dr, 
                dbo.t_wmsOutPickDetail_tmp.createtime, dbo.t_wmsOutPickDetail_tmp.lastmodified, dbo.v_wmsGoods.goodsName, 
                dbo.v_wmsGoods.manufacturer, dbo.v_wmsGoods.spec, dbo.v_wmsGoods.unit, dbo.v_wmsGoods.regeditCode, 
                dbo.v_wmsGoods.bigCount, dbo.v_wmsGoods.barCode, dbo.v_wmsGoods.drug_code, dbo.v_wmsGoods.type, 
                dbo.v_wmsGoods.isImport, dbo.v_wmsGoods.goodsTypeName, dbo.t_wmsOutPickDetail_tmp.solutionRemark, 
                dbo.t_wmsOutPickDetail_tmp.validSolution, t_node_1.name AS validResult, dbo.t_node.name AS solution
FROM      dbo.t_node AS t_node_1 RIGHT OUTER JOIN
                dbo.t_wmsOutPickDetail_tmp ON t_node_1.id = dbo.t_wmsOutPickDetail_tmp.validReason LEFT OUTER JOIN
                dbo.t_node ON dbo.t_wmsOutPickDetail_tmp.validSolution = dbo.t_node.id LEFT OUTER JOIN
                dbo.v_wmsGoods ON dbo.t_wmsOutPickDetail_tmp.goodsId = dbo.v_wmsGoods.goodsId

GO
/****** Object:  View [dbo].[v_stockOutLablePickDetail]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockOutLablePickDetail]
AS
SELECT   dbo.t_wmsStockRecord.goodsId, dbo.t_wmsStockRecord.batch, dbo.t_wmsOutPickLable.pickOrderNo, 
                dbo.t_wmsOutPickRequest.waveOrder, dbo.t_wmsStockRecord.count, dbo.t_wmsOutDesk.deskName, 
                dbo.t_wmsOutDesk.color, dbo.t_wmsOutPickLable.state, dbo.t_wmsStockRecord.productDate, 
                dbo.t_wmsStockRecord.validDate, dbo.t_wmsOutPickLable.recordId, dbo.t_wmsOutPickLable.port, 
                dbo.t_wmsOutPickLable.locationId, dbo.t_wmsOutPickLable.pickCount, dbo.t_wmsOutPickLable.elabId, 
                dbo.t_wmsOutPickLable.elabAddress
FROM      dbo.t_wmsStockRecord INNER JOIN
                dbo.t_wmsOutPickLable ON dbo.t_wmsStockRecord.id = dbo.t_wmsOutPickLable.recordId INNER JOIN
                dbo.t_wmsOutDesk INNER JOIN
                dbo.t_wmsOutPickRequest ON dbo.t_wmsOutDesk.id = dbo.t_wmsOutPickRequest.desk ON 
                dbo.t_wmsOutPickLable.pickOrderNo = dbo.t_wmsOutPickRequest.pickOrderNo

GO
/****** Object:  View [dbo].[v_stockOutCheckDetail]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockOutCheckDetail]
AS
SELECT   dbo.v_wmsGoods.goodsName, dbo.v_wmsGoods.manufacturer, dbo.v_wmsGoods.spec, dbo.v_wmsGoods.unit, 
                dbo.v_wmsGoods.regeditCode, dbo.v_wmsGoods.barCode, SUM(dbo.v_stockOutLablePickDetail.count) AS count, 
                dbo.v_stockOutLablePickDetail.productDate, dbo.v_stockOutLablePickDetail.validDate, 
                dbo.v_stockOutLablePickDetail.deskName
FROM      dbo.v_wmsGoods INNER JOIN
                dbo.v_stockOutLablePickDetail ON dbo.v_wmsGoods.goodsId = dbo.v_stockOutLablePickDetail.goodsId
GROUP BY dbo.v_wmsGoods.goodsName, dbo.v_wmsGoods.manufacturer, dbo.v_wmsGoods.spec, dbo.v_wmsGoods.unit, 
                dbo.v_wmsGoods.regeditCode, dbo.v_wmsGoods.barCode, dbo.v_stockOutLablePickDetail.productDate, 
                dbo.v_stockOutLablePickDetail.validDate, dbo.v_stockOutLablePickDetail.deskName

GO
/****** Object:  View [dbo].[v_stockInRequestDetail_wms]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockInRequestDetail_wms]
AS
SELECT   dbo.t_wmsInRequestDetail.id, dbo.t_wmsInRequestDetail.orderNo, dbo.t_wmsInRequestDetail.goodsId, 
                dbo.t_wmsInRequestDetail.cnt, dbo.t_wmsInRequestDetail.countIn, dbo.t_wmsInRequestDetail.state, 
                dbo.t_wmsInRequestDetail.description, dbo.t_wmsInRequestDetail.operater, dbo.v_wmsGoods.goodsType, 
                dbo.v_wmsGoods.full_max, dbo.v_wmsGoods.bulkMax, dbo.v_wmsGoods.bulkMax1, dbo.v_wmsGoods.batchMax1, 
                dbo.v_wmsGoods.length, dbo.v_wmsGoods.width, dbo.v_wmsGoods.height, dbo.v_wmsGoods.validTermDays, 
                dbo.v_wmsGoods.goodsTypeName, dbo.v_wmsGoods.goodsName, dbo.v_wmsGoods.spec, dbo.v_wmsGoods.unit, 
                dbo.v_wmsGoods.address, dbo.v_wmsGoods.weight, dbo.v_wmsGoods.curCycle, dbo.t_wmsInRequestDetail.batch, 
                dbo.t_wmsInRequestDetail.validDate, dbo.t_wmsInRequestDetail.productDate, dbo.t_wmsInRequestDetail.dr, 
                dbo.t_wmsInRequestDetail.lastmodified, dbo.t_wmsInRequestDetail.createtime, dbo.v_wmsGoods.barCode, 
                dbo.v_wmsGoods.bigCount, dbo.v_wmsGoods.type, dbo.v_wmsGoods.batchMax2, dbo.v_wmsGoods.manufacturer, 
                dbo.v_wmsGoods.regeditCode
FROM      dbo.t_wmsInRequestDetail LEFT OUTER JOIN
                dbo.v_wmsGoods ON dbo.t_wmsInRequestDetail.goodsId = dbo.v_wmsGoods.goodsId

GO
/****** Object:  View [dbo].[v_stockOutValidationException]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockOutValidationException]
AS
SELECT   dbo.t_wmsOutPickDetail_tmp.desk, dbo.t_wmsOutPickDetail_tmp.orderState, dbo.t_wmsOutPickDetail_tmp.waveOrder, 
                dbo.t_wmsOutPickDetail_tmp.id, dbo.t_wmsOutPickDetail_tmp.pickOrderNo, dbo.t_wmsOutPickDetail_tmp.orderNo, 
                dbo.t_wmsOutPickDetail_tmp.customerId, dbo.t_wmsOutPickDetail_tmp.customerName, 
                dbo.t_wmsOutPickDetail_tmp.goodsId, dbo.t_wmsOutPickDetail_tmp.batch, dbo.t_wmsOutPickDetail_tmp.count, 
                dbo.t_wmsOutPickDetail_tmp.bulkCount, dbo.t_wmsOutPickDetail_tmp.batch1Count, 
                dbo.t_wmsOutPickDetail_tmp.batch2Count, dbo.t_wmsOutPickDetail_tmp.boxcnt, 
                dbo.t_wmsOutPickDetail_tmp.productDate, dbo.t_wmsOutPickDetail_tmp.validDate, dbo.t_wmsOutPickDetail_tmp.state, 
                dbo.t_wmsOutPickDetail_tmp.whtype, dbo.t_wmsOutPickDetail_tmp.description, 
                dbo.t_wmsOutPickDetail_tmp.confirmedCount, dbo.t_wmsOutPickDetail_tmp.checkedBy, 
                dbo.t_wmsOutPickDetail_tmp.validRemark, dbo.t_wmsOutPickDetail_tmp.validReason, 
                dbo.t_wmsOutPickDetail_tmp.checkedTime, dbo.t_wmsOutPickDetail_tmp.operater, dbo.t_wmsOutPickDetail_tmp.dr, 
                dbo.t_wmsOutPickDetail_tmp.createtime, dbo.t_wmsOutPickDetail_tmp.lastmodified, dbo.t_wmsStockRecord.locationId, 
                dbo.t_wmsOutDesk.deskName AS color, dbo.t_wmsStockRecord.count AS pickCount, dbo.v_wmsGoods.goodsName, 
                dbo.v_wmsGoods.manufacturer, dbo.v_wmsGoods.spec, dbo.v_wmsGoods.unit, dbo.v_wmsGoods.regeditCode, 
                dbo.v_wmsGoods.bigCount, dbo.v_wmsGoods.type, dbo.v_wmsGoods.barCode, t_node_1.name AS exception, 
                t_node_1.description AS exceptionDesc, dbo.t_wmsOutPickDetail_tmp.validSolution, 
                dbo.t_wmsOutPickDetail_tmp.solutionRemark, dbo.t_node.name AS solution
FROM      dbo.t_wmsOutPickDetail_tmp LEFT OUTER JOIN
                dbo.t_node ON dbo.t_wmsOutPickDetail_tmp.validSolution = dbo.t_node.id LEFT OUTER JOIN
                dbo.t_node AS t_node_1 ON dbo.t_wmsOutPickDetail_tmp.validReason = t_node_1.id LEFT OUTER JOIN
                dbo.v_wmsGoods ON dbo.t_wmsOutPickDetail_tmp.goodsId = dbo.v_wmsGoods.goodsId LEFT OUTER JOIN
                dbo.t_wmsStockRecord ON dbo.t_wmsOutPickDetail_tmp.batch = dbo.t_wmsStockRecord.batch AND 
                dbo.t_wmsOutPickDetail_tmp.goodsId = dbo.t_wmsStockRecord.goodsId AND 
                dbo.t_wmsOutPickDetail_tmp.pickOrderNo = dbo.t_wmsStockRecord.orderNo LEFT OUTER JOIN
                dbo.t_wmsOutDesk ON dbo.t_wmsOutDesk.id = dbo.t_wmsOutPickDetail_tmp.desk
WHERE   (dbo.t_wmsOutPickDetail_tmp.state >= 7)

GO
/****** Object:  View [dbo].[v_stockOutDetailByCust]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockOutDetailByCust]
AS
SELECT   TOP (100) PERCENT a.orderNo, a.customerId, b.goodsId, b.batch, SUM(b.count) AS count, SUM(b.count) 
                - FLOOR(SUM(b.count) / c.bigCount) * c.bigCount AS bulkCount, FLOOR(SUM(b.count) / c.bigCount) 
                * c.bigCount AS batch1Count, FLOOR(SUM(b.count) / c.bigCount) AS boxcnt, c.bigCount, a.customerName, b.whtype, 
                b.productDate, b.validDate, GETDATE() AS lastmodified, 'true' AS dr, - 1 AS id, 0 AS batch2Count, '' AS pickOrderNo, 
                0 AS state, '' AS description, - 1 AS operater, GETDATE() AS createtime
FROM      dbo.t_wmsOutRequest AS a INNER JOIN
                dbo.t_wmsOutDetail AS b ON a.orderNo = b.orderNo INNER JOIN
                dbo.v_wmsGoods AS c ON b.goodsId = c.goodsId
WHERE   (a.orderType = 0) AND (a.state = 1) AND (NOT EXISTS
                    (SELECT   1 AS Expr1
                     FROM      dbo.t_wmsOutPickDetail
                     WHERE   (orderNo = a.orderNo)))
GROUP BY a.orderNo, a.customerId, b.goodsId, b.batch, c.bigCount, a.customerName, b.whtype, b.productDate, 
                b.validDate
ORDER BY a.customerId

GO
/****** Object:  View [dbo].[v_stockOutRequest_Available]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockOutRequest_Available]
AS
SELECT   TOP (100) orderNo, 0 AS orderType, orderTypeName, customerId, customerName, address, delivery, phone1, phone2, 
                salesperson, contactperson, totalnumber, remark, orderDate
FROM      custErp.dbo.v_stockOutRequest AS a
WHERE   (NOT EXISTS
                    (SELECT   1 AS Expr1
                     FROM      dbo.t_wmsOutRequest
                     WHERE   (orderNo = a.orderNo)))

GO
/****** Object:  View [dbo].[v_stockOutRequestDetail_available]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockOutRequestDetail_available]
AS
SELECT   orderNo, orderSn, goodsId, batch, productDate, validDate, Count, saleDate, state, whtype
FROM      custErp.dbo.v_stockOutRequestDetail AS a
WHERE   EXISTS
                    (SELECT   1 AS Expr1
                     FROM      dbo.v_stockOutRequest_Available
                     WHERE   (orderNo = a.orderNo))

GO
/****** Object:  View [dbo].[v_stockOutDetail_available]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockOutDetail_available]
AS
SELECT   a.orderNo, a.goodsId, a.batch, a.productDate, a.validDate, SUM(a.Count) AS count, SUM(a.Count) - FLOOR(SUM(a.Count) 
                / b.bigCount) * b.bigCount AS bulkCount, FLOOR(SUM(a.Count) / b.bigCount) * b.bigCount AS batch1Count, 
                FLOOR(SUM(a.Count) / b.bigCount) AS boxcnt, b.bigCount, a.whtype, a.state
FROM      dbo.v_stockOutRequestDetail_available AS a INNER JOIN
                dbo.v_wmsGoods AS b ON a.goodsId = b.goodsId
GROUP BY a.orderNo, a.goodsId, a.batch, a.productDate, a.validDate, a.whtype, b.bigCount, a.state

GO
/****** Object:  View [dbo].[v_stockOutRequestPick]    Script Date: 2017/6/4 0:19:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockOutRequestPick]
AS
SELECT   dbo.t_wmsOutRequest.orderNo, dbo.t_wmsOutRequest.orderType, dbo.t_wmsOutRequest.orderTypeName, 
                dbo.t_wmsOutRequest.customerId, dbo.t_wmsOutRequest.customerName, dbo.t_wmsOutRequest.address, 
                dbo.t_wmsOutRequest.delivery, dbo.t_wmsOutRequest.phone1, dbo.t_wmsOutRequest.phone2, 
                dbo.t_wmsOutRequest.salesperson, dbo.t_wmsOutRequest.contactperson, dbo.t_wmsOutRequest.totalnumber, 
                dbo.t_wmsOutRequest.remark, dbo.t_wmsOutRequest.orderDate, dbo.t_wmsOutRequest.state, 
                dbo.t_wmsOutRequest.operater, dbo.t_wmsOutRequest.dr, dbo.t_wmsOutRequest.createtime, 
                dbo.t_wmsOutRequest.lastmodified, dbo.t_wmsOutRequest.id, dbo.t_wmsOutPickDetail.pickOrderNo, 
                dbo.t_wmsOutPickRequest.waveOrder, dbo.t_wmsOutPickRequest.state AS pickOrderState, 
                dbo.t_wmsOutPickDetail.state AS goodsPickState, dbo.t_wmsOutPickDetail.goodsId, dbo.t_wmsOutPickDetail.batch, 
                dbo.t_wmsOutPickDetail.count, dbo.t_wmsOutPickDetail.bulkCount, dbo.t_wmsOutPickDetail.batch1Count, 
                dbo.t_wmsOutPickDetail.batch2Count, dbo.t_wmsOutPickDetail.boxcnt, dbo.t_wmsOutPickDetail.productDate, 
                dbo.t_wmsOutPickDetail.validDate, dbo.v_wmsGoods.goodsName, dbo.v_wmsGoods.manufacturer, 
                dbo.v_wmsGoods.spec, dbo.v_wmsGoods.regeditCode, dbo.v_wmsGoods.unit, dbo.v_wmsGoods.type, 
                dbo.v_wmsGoods.barCode, dbo.v_wmsGoods.goodsType, dbo.v_wmsGoods.goodsTypeName
FROM      dbo.t_wmsOutRequest LEFT OUTER JOIN
                dbo.t_wmsOutPickDetail ON dbo.t_wmsOutRequest.orderNo = dbo.t_wmsOutPickDetail.orderNo LEFT OUTER JOIN
                dbo.t_wmsOutPickRequest ON 
                dbo.t_wmsOutPickDetail.pickOrderNo = dbo.t_wmsOutPickRequest.pickOrderNo LEFT OUTER JOIN
                dbo.v_wmsGoods ON dbo.t_wmsOutPickDetail.goodsId = dbo.v_wmsGoods.goodsId

GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_t_wmsStock]    Script Date: 2017/6/4 0:19:59 ******/
CREATE NONCLUSTERED INDEX [IX_t_wmsStock] ON [dbo].[t_wmsStock]
(
	[goodsId] ASC,
	[batch] ASC,
	[locationId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
ALTER TABLE [dbo].[t_Authority] ADD  CONSTRAINT [DF_t_Authority_auth_public]  DEFAULT ((0)) FOR [auth_public]
GO
ALTER TABLE [dbo].[t_Authority] ADD  CONSTRAINT [DF_t_Authority_auth_marqueen]  DEFAULT ((0)) FOR [auth_marqueen]
GO
ALTER TABLE [dbo].[t_Authority] ADD  CONSTRAINT [DF_t_Authority_auth_publicInfomation]  DEFAULT ((0)) FOR [auth_publicInfomation]
GO
ALTER TABLE [dbo].[t_Authority] ADD  CONSTRAINT [DF__t_Authority__dr__436BFEE3]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_Authority] ADD  CONSTRAINT [DF__t_Authori__creat__4460231C]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_Department] ADD  CONSTRAINT [DF__t_Departm__creat__4A18FC72]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_Department] ADD  CONSTRAINT [DF__t_Department__dr__4B0D20AB]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_DeptEmp] ADD  CONSTRAINT [DF__t_DeptEmp__dr__3B95D2F1]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_DeptEmp] ADD  CONSTRAINT [DF__t_DeptEmp__creat__3C89F72A]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_Employee] ADD  CONSTRAINT [DF__t_Employee__dr__0B5CAFEA]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_Employee] ADD  CONSTRAINT [DF__t_Employe__creat__0C50D423]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_Employee] ADD  CONSTRAINT [DF__t_Employe__em_is__398D8EEE]  DEFAULT ((0)) FOR [em_isOnline]
GO
ALTER TABLE [dbo].[t_Filesmgr] ADD  CONSTRAINT [DF__t_Filesmgr__dr__2E70E1FD]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_Filesmgr] ADD  CONSTRAINT [DF__t_Filesmg__creat__2F650636]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_GoodsType] ADD  CONSTRAINT [DF_t_GoodsType_create_time]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_GoodsType] ADD  CONSTRAINT [DF_t_GoodsType_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_lesson] ADD  CONSTRAINT [DF__t_lesson__dr__00750D23]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_lesson] ADD  CONSTRAINT [DF__t_lesson__create__0169315C]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_lessonCategory] ADD  CONSTRAINT [DF__t_lessonC__lc_up__7BB05806]  DEFAULT ((0)) FOR [lc_uplevel]
GO
ALTER TABLE [dbo].[t_lessonCategory] ADD  CONSTRAINT [DF__t_lessonCate__dr__7CA47C3F]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_lessonCategory] ADD  CONSTRAINT [DF__t_lessonC__creat__7D98A078]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_Log] ADD  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_Log] ADD  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_node] ADD  CONSTRAINT [DF_t_node_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_node] ADD  CONSTRAINT [DF_t_node_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_Project] ADD  CONSTRAINT [DF__t_Project__dr__324172E1]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_Project] ADD  CONSTRAINT [DF__t_Project__creat__3335971A]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_ProjectApproveList] ADD  CONSTRAINT [DF_t_ProjectApproveList_pa_pass]  DEFAULT ((0)) FOR [pa_pass]
GO
ALTER TABLE [dbo].[t_ProjectApproveList] ADD  CONSTRAINT [DF__t_ProjectApp__dr__4707859D]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_ProjectApproveList] ADD  CONSTRAINT [DF__t_Project__creat__47FBA9D6]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_ProjectDetail] ADD  CONSTRAINT [DF__t_ProjectDet__dr__361203C5]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_ProjectDetail] ADD  CONSTRAINT [DF__t_Project__creat__370627FE]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_PublicNews] ADD  CONSTRAINT [DF_t_PublicNews_news_alert]  DEFAULT ((0)) FOR [news_alert]
GO
ALTER TABLE [dbo].[t_PublicNews] ADD  CONSTRAINT [DF__t_PublicNews__dr__67A95F59]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_PublicNews] ADD  CONSTRAINT [DF__t_PublicN__creat__689D8392]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_Role] ADD  CONSTRAINT [DF_t_Role_role_4Approve]  DEFAULT ((0)) FOR [role_4Approve]
GO
ALTER TABLE [dbo].[t_Role] ADD  CONSTRAINT [DF__t_Role__dr__0F2D40CE]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_Role] ADD  CONSTRAINT [DF__t_Role__create_t__10216507]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_RoleAuthority] ADD  CONSTRAINT [DF_t_RoleAuthority_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_RoleAuthority] ADD  CONSTRAINT [DF__t_RoleAut__CREAT__473C8FC7]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_RoleEmp] ADD  CONSTRAINT [DF__t_RoleEmp__dr__16CE6296]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_RoleEmp] ADD  CONSTRAINT [DF__t_RoleEmp__creat__17C286CF]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_trainingDetail] ADD  CONSTRAINT [DF__t_trainin__train__1293BD5E]  DEFAULT ((0)) FOR [train_passed]
GO
ALTER TABLE [dbo].[t_trainingDetail] ADD  CONSTRAINT [DF__t_trainingDe__dr__1387E197]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_trainingDetail] ADD  CONSTRAINT [DF__t_trainin__creat__147C05D0]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_wmsDealLocation] ADD  CONSTRAINT [DF_t_wmsDealLocation_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsDealLocation] ADD  CONSTRAINT [DF_t_wmsDealLocation_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsGoods] ADD  CONSTRAINT [DF_t_wmsGoods_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsGoods] ADD  CONSTRAINT [DF_t_wmsGoods_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsInRequest] ADD  CONSTRAINT [DF_t_wmsInRequest_orderType]  DEFAULT ((0)) FOR [orderType]
GO
ALTER TABLE [dbo].[t_wmsInRequest] ADD  CONSTRAINT [DF_t_wmsInRequest_state]  DEFAULT ((0)) FOR [state]
GO
ALTER TABLE [dbo].[t_wmsInRequest] ADD  CONSTRAINT [DF_t_wmsInRequest_endDate]  DEFAULT (getdate()) FOR [orderDate]
GO
ALTER TABLE [dbo].[t_wmsInRequest] ADD  CONSTRAINT [DF_t_wmsInRequest_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsInRequest] ADD  CONSTRAINT [DF_t_wmsInRequest_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsInRequestDetail] ADD  CONSTRAINT [DF_t_wmsInRequestDetail_state]  DEFAULT ((0)) FOR [state]
GO
ALTER TABLE [dbo].[t_wmsInRequestDetail] ADD  CONSTRAINT [DF_t_wmsInRequestDetail_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsInRequestDetail] ADD  CONSTRAINT [DF_t_wmsInRequestDetail_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsLocation] ADD  CONSTRAINT [DF_t_wmsLocation_state]  DEFAULT ((1)) FOR [state]
GO
ALTER TABLE [dbo].[t_wmsLocation] ADD  CONSTRAINT [DF_t_location_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsLocation] ADD  CONSTRAINT [DF_t_location_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsOutBox] ADD  CONSTRAINT [DF_t_wmsOutBox_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsOutBox] ADD  CONSTRAINT [DF_t_wmsOutBox_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsOutDesk] ADD  CONSTRAINT [DF_t_wmsOutDesk_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsOutDesk] ADD  CONSTRAINT [DF_t_wmsOutDesk_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsOutDetail] ADD  CONSTRAINT [DF_t_wmsOutDetail_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsOutDetail] ADD  CONSTRAINT [DF_t_wmsOutDetail_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsOutPickDetail] ADD  CONSTRAINT [DF_t_wmsOutPickDetail_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsOutPickDetail] ADD  CONSTRAINT [DF_t_wmsOutPickDetail_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsOutPickLable] ADD  CONSTRAINT [DF_t_wmsOutPickLable_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsOutPickLable] ADD  CONSTRAINT [DF_t_wmsOutPickLable_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsOutPickLable_tmp] ADD  CONSTRAINT [DF_t_wmsOutPickLable_tmp_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsOutPickLable_tmp] ADD  CONSTRAINT [DF_t_wmsOutPickLable_tmp_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsOutPickRequest] ADD  CONSTRAINT [DF_t_wmsOutPickRequest_orderDate]  DEFAULT (getdate()) FOR [orderDate]
GO
ALTER TABLE [dbo].[t_wmsOutPickRequest] ADD  CONSTRAINT [DF_t_wmsOutPickRequest_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsOutPickRequest] ADD  CONSTRAINT [DF_t_wmsOutPickRequest_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsOutRequest] ADD  CONSTRAINT [DF_t_wmsOutRequest_orderType]  DEFAULT ((0)) FOR [orderType]
GO
ALTER TABLE [dbo].[t_wmsOutRequest] ADD  CONSTRAINT [DF_t_wmsOutRequest_orderDate]  DEFAULT (getdate()) FOR [orderDate]
GO
ALTER TABLE [dbo].[t_wmsOutRequest] ADD  CONSTRAINT [DF_t_wmsOutRequest_state]  DEFAULT ((0)) FOR [state]
GO
ALTER TABLE [dbo].[t_wmsOutRequest] ADD  CONSTRAINT [DF_t_wmsOutRequest_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsOutRequest] ADD  CONSTRAINT [DF_t_wmsOutRequest_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsOutRequestDetail] ADD  CONSTRAINT [DF_t_wmsOutRequestDetail_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsOutRequestDetail] ADD  CONSTRAINT [DF_t_wmsOutRequestDetail_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsOutValidationException] ADD  CONSTRAINT [DF__t_wmsOutValidation_dr__0F2D40CE]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsOutValidationException] ADD  CONSTRAINT [DF__t_wmsOutValidationException_create_t__10216507]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_wmsReceive] ADD  CONSTRAINT [DF_t_wmsReceive_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsReceive] ADD  CONSTRAINT [DF_t_wmsReceive_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsReceiveDetail] ADD  CONSTRAINT [DF_t_wmsReceiveDetail_state]  DEFAULT ((0)) FOR [state]
GO
ALTER TABLE [dbo].[t_wmsReceiveDetail] ADD  CONSTRAINT [DF_t_wmsReceiveDetail_batchState]  DEFAULT ((0)) FOR [batchState]
GO
ALTER TABLE [dbo].[t_wmsReceiveDetail] ADD  CONSTRAINT [DF_t_wmsReceiveDetail_picState]  DEFAULT ((0)) FOR [picState]
GO
ALTER TABLE [dbo].[t_wmsReceiveDetail] ADD  CONSTRAINT [DF_t_wmsReceiveDetail_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsReceiveDetail] ADD  CONSTRAINT [DF_t_wmsReceiveDetail_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsStock] ADD  CONSTRAINT [DF_t_wmsStock_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsStock] ADD  CONSTRAINT [DF_t_wmsStock_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_wmsStockRecord] ADD  CONSTRAINT [DF_t_wmsStockRecord_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsStockRecord] ADD  CONSTRAINT [DF_t_wmsStockRecord_dr]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_workplan] ADD  CONSTRAINT [DF__t_workplan__dr__5E1FF51F]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_workplan] ADD  CONSTRAINT [DF__t_workpla__creat__5F141958]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_workplanDetail] ADD  CONSTRAINT [DF__t_workplanDe__dr__5A4F643B]  DEFAULT ((1)) FOR [dr]
GO
ALTER TABLE [dbo].[t_workplanDetail] ADD  CONSTRAINT [DF__t_workpla__creat__5B438874]  DEFAULT (getdate()) FOR [create_time]
GO
ALTER TABLE [dbo].[t_wmsStock]  WITH CHECK ADD  CONSTRAINT [FK_t_wmsStock_t_wmsLocation] FOREIGN KEY([locationId])
REFERENCES [dbo].[t_wmsLocation] ([locationId])
GO
ALTER TABLE [dbo].[t_wmsStock] CHECK CONSTRAINT [FK_t_wmsStock_t_wmsLocation]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效天数  有效期减去生产日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_wmsGoods', @level2type=N'COLUMN',@level2name=N'validTermDays'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0,锁定 1 空闲 2 被使用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_wmsLocation', @level2type=N'COLUMN',@level2name=N'state'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0 释放 1被占用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_wmsLocation', @level2type=N'COLUMN',@level2name=N'tranState'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1 等待收货  2 等待验收 3 拒收 4第一个人验收完毕   5验收完毕,等待上架 6上架完毕 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_wmsReceive', @level2type=N'COLUMN',@level2name=N'state'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0 等待上架 1 收货完成 2验收' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_wmsReceiveDetail', @level2type=N'COLUMN',@level2name=N'state'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[41] 4[37] 2[17] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "v_erpGoods_1"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 145
               Right = 204
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 1590
         Table = 2820
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_erpGoods'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_erpGoods'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[41] 4[20] 2[21] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "b"
            Begin Extent = 
               Top = 6
               Left = 238
               Bottom = 215
               Right = 449
            End
            DisplayFlags = 280
            TopColumn = 22
         End
         Begin Table = "a"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 145
               Right = 200
            End
            DisplayFlags = 280
            TopColumn = 9
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_reportStockRecord'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_reportStockRecord'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[36] 4[25] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "t_wmsStock"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 145
               Right = 213
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_wmsLocation"
            Begin Extent = 
               Top = 27
               Left = 289
               Bottom = 166
               Right = 461
            End
            DisplayFlags = 280
            TopColumn = 20
         End
         Begin Table = "v_wmsGoods"
            Begin Extent = 
               Top = 0
               Left = 608
               Bottom = 304
               Right = 798
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockGoods'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockGoods'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[41] 4[21] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "a"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 306
               Right = 223
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 1725
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockInRequest_Available'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockInRequest_Available'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[42] 4[42] 2[16] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "a"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 360
               Right = 291
            End
            DisplayFlags = 280
            TopColumn = 12
         End
         Begin Table = "v_stockInRequest_Available"
            Begin Extent = 
               Top = 0
               Left = 413
               Bottom = 262
               Right = 722
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 2910
         Alias = 2280
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockInRequestDetail_Available'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockInRequestDetail_Available'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[57] 4[14] 2[30] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "t_wmsInRequestDetail"
            Begin Extent = 
               Top = 6
               Left = 8
               Bottom = 278
               Right = 270
            End
            DisplayFlags = 280
            TopColumn = 3
         End
         Begin Table = "v_wmsGoods"
            Begin Extent = 
               Top = 0
               Left = 362
               Bottom = 288
               Right = 654
            End
            DisplayFlags = 280
            TopColumn = 15
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockInRequestDetail_wms'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockInRequestDetail_wms'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[51] 4[3] 2[40] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "t_wmsOutPickLable_tmp"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 340
               Right = 245
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_wmsStockRecord"
            Begin Extent = 
               Top = 61
               Left = 320
               Bottom = 349
               Right = 555
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_wmsOutPickRequest"
            Begin Extent = 
               Top = 39
               Left = 1013
               Bottom = 339
               Right = 1212
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "v_wmsGoods"
            Begin Extent = 
               Top = 13
               Left = 697
               Bottom = 397
               Right = 887
            End
            DisplayFlags = 280
            TopColumn = 22
         End
         Begin Table = "t_wmsOutDesk"
            Begin Extent = 
               Top = 56
               Left = 1278
               Bottom = 344
               Right = 1439
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutBulkInCurrentWave'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N' = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutBulkInCurrentWave'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutBulkInCurrentWave'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[28] 4[40] 2[16] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "v_wmsGoods"
            Begin Extent = 
               Top = 13
               Left = 353
               Bottom = 314
               Right = 543
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "v_stockOutLablePickDetail"
            Begin Extent = 
               Top = 0
               Left = 68
               Bottom = 311
               Right = 250
            End
            DisplayFlags = 280
            TopColumn = 1
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 12
         Column = 4650
         Alias = 900
         Table = 3660
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutCheckDetail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutCheckDetail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "a"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 328
               Right = 216
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "b"
            Begin Extent = 
               Top = 6
               Left = 254
               Bottom = 340
               Right = 460
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutDetail_available'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutDetail_available'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "t_wmsOutDetail"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 145
               Right = 200
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "v_wmsGoods"
            Begin Extent = 
               Top = 6
               Left = 238
               Bottom = 339
               Right = 412
            End
            DisplayFlags = 280
            TopColumn = 16
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutDetail_wms'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutDetail_wms'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[51] 4[3] 2[44] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = -71
      End
      Begin Tables = 
         Begin Table = "a"
            Begin Extent = 
               Top = 6
               Left = 109
               Bottom = 145
               Right = 310
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "b"
            Begin Extent = 
               Top = 16
               Left = 373
               Bottom = 225
               Right = 648
            End
            DisplayFlags = 280
            TopColumn = 4
         End
         Begin Table = "c"
            Begin Extent = 
               Top = 6
               Left = 753
               Bottom = 178
               Right = 943
            End
            DisplayFlags = 280
            TopColumn = 23
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 2775
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutDetailByCust'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutDetailByCust'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[44] 4[35] 2[21] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = -35
         Left = 0
      End
      Begin Tables = 
         Begin Table = "t_wmsStockRecord"
            Begin Extent = 
               Top = 5
               Left = 582
               Bottom = 288
               Right = 838
            End
            DisplayFlags = 280
            TopColumn = 6
         End
         Begin Table = "t_wmsOutPickLable"
            Begin Extent = 
               Top = 33
               Left = 27
               Bottom = 326
               Right = 251
            End
            DisplayFlags = 280
            TopColumn = 3
         End
         Begin Table = "t_wmsOutDesk"
            Begin Extent = 
               Top = 235
               Left = 530
               Bottom = 485
               Right = 758
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_wmsOutPickRequest"
            Begin Extent = 
               Top = 43
               Left = 310
               Bottom = 271
               Right = 547
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 4035
         Alias = 900
         Table = 3735
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutLablePickDetail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutLablePickDetail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[14] 4[68] 2[10] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "t_wmsOutPickDetail"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 526
               Right = 255
            End
            DisplayFlags = 280
            TopColumn = 4
         End
         Begin Table = "v_wmsGoods"
            Begin Extent = 
               Top = 0
               Left = 432
               Bottom = 329
               Right = 622
            End
            DisplayFlags = 280
            TopColumn = 25
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 3255
         Alias = 4380
         Table = 5040
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutPickDetail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutPickDetail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[41] 4[11] 2[30] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "v_wmsGoods"
            Begin Extent = 
               Top = 0
               Left = 445
               Bottom = 213
               Right = 635
            End
            DisplayFlags = 280
            TopColumn = 14
         End
         Begin Table = "t_wmsOutPickDetail_tmp"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 323
               Right = 325
            End
            DisplayFlags = 280
            TopColumn = 18
         End
         Begin Table = "t_node"
            Begin Extent = 
               Top = 122
               Left = 1173
               Bottom = 261
               Right = 1334
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_node_1"
            Begin Extent = 
               Top = 65
               Left = 911
               Bottom = 204
               Right = 1072
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutPickDetailValidation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutPickDetailValidation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[35] 4[21] 2[26] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "a"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 154
               Right = 223
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutRequest_Available'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutRequest_Available'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "a"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 145
               Right = 200
            End
            DisplayFlags = 280
            TopColumn = 6
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutRequestDetail_available'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutRequestDetail_available'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[41] 4[3] 2[42] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "t_wmsOutPickRequest"
            Begin Extent = 
               Top = 30
               Left = 639
               Bottom = 229
               Right = 884
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_wmsOutPickDetail"
            Begin Extent = 
               Top = 24
               Left = 329
               Bottom = 360
               Right = 550
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_wmsOutRequest"
            Begin Extent = 
               Top = 28
               Left = 23
               Bottom = 167
               Right = 208
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "v_wmsGoods"
            Begin Extent = 
               Top = 33
               Left = 1038
               Bottom = 325
               Right = 1263
            End
            DisplayFlags = 280
            TopColumn = 27
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutRequestPick'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutRequestPick'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[45] 4[13] 2[30] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "t_wmsOutPickDetail_tmp"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 494
               Right = 326
            End
            DisplayFlags = 280
            TopColumn = 9
         End
         Begin Table = "t_node_1"
            Begin Extent = 
               Top = 35
               Left = 1257
               Bottom = 174
               Right = 1418
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "v_wmsGoods"
            Begin Extent = 
               Top = 6
               Left = 1003
               Bottom = 281
               Right = 1193
            End
            DisplayFlags = 280
            TopColumn = 28
         End
         Begin Table = "t_wmsStockRecord"
            Begin Extent = 
               Top = 87
               Left = 488
               Bottom = 573
               Right = 684
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_wmsOutDesk"
            Begin Extent = 
               Top = 144
               Left = 838
               Bottom = 453
               Right = 999
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_node"
            Begin Extent = 
               Top = 229
               Left = 1258
               Bottom = 368
               Right = 1419
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutValidationException'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N'         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutValidationException'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=2 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutValidationException'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[47] 4[9] 2[30] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "t_wmsStockRecord"
            Begin Extent = 
               Top = 0
               Left = 393
               Bottom = 303
               Right = 601
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_wmsLocation"
            Begin Extent = 
               Top = 127
               Left = 693
               Bottom = 373
               Right = 865
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "v_wmsGoods"
            Begin Extent = 
               Top = 15
               Left = 1142
               Bottom = 355
               Right = 1332
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_wmsOutPickRequest"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 340
               Right = 281
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutWavePickDetail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutWavePickDetail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[37] 4[30] 2[32] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = -192
         Left = 0
      End
      Begin Tables = 
         Begin Table = "t_wmsGoods"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 274
               Right = 252
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "v_erpGoods"
            Begin Extent = 
               Top = 0
               Left = 710
               Bottom = 316
               Right = 876
            End
            DisplayFlags = 280
            TopColumn = 9
         End
         Begin Table = "t_node"
            Begin Extent = 
               Top = 66
               Left = 410
               Bottom = 205
               Right = 571
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 4065
         Alias = 4860
         Table = 3615
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_wmsGoods'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_wmsGoods'
GO
USE [master]
GO
ALTER DATABASE [dwms4] SET  READ_WRITE 
GO