USE [master]
GO
/****** Object:  Database [dwms4]    Script Date: 2017/6/15 0:18:33 ******/
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 = 196608KB , 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 = 3164032KB , 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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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_wmsOutLog]    Script Date: 2017/6/15 0:18:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsOutLog](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[orderNo] [nvarchar](50) NULL,
	[pickOrderNo] [nvarchar](50) NULL,
	[goodsId] [nvarchar](50) NULL,
	[batch] [nvarchar](50) NULL,
	[orderState] [int] NULL,
	[pickState] [int] NULL,
	[bulkPickState] [int] NULL,
	[batchPickState] [int] NULL,
	[operater] [int] NULL,
	[lastmodified] [datetime] NULL,
	[createtime] [datetime] NULL,
	[dr] [bit] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[t_wmsOutPickDetail]    Script Date: 2017/6/15 0:18:33 ******/
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,
	[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,
	[bulkPickState] [int] NULL,
	[batchPickState] [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----obsoleted]    Script Date: 2017/6/15 0:18:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[t_wmsOutPickDetail_error----obsoleted](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[orderNo] [nvarchar](500) NULL,
	[pickOrderNo] [nvarchar](50) NOT 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,
	[bulkPickState] [int] NULL,
	[batchPickState] [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/15 0:18:33 ******/
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,
	[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,
	[bulkPickState] [int] NULL,
	[batchPickState] [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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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,
	[bulkPickState] [int] NULL,
	[batchPickState] [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/15 0:18:33 ******/
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,
	[pickOrderNo] [nvarchar](50) 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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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,
	[description] [nvarchar](250) 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/15 0:18:33 ******/
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,
	[oldCount] [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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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, 
                dbo.t_wmsOutPickRequest.batchPickState, dbo.t_wmsOutPickRequest.state, dbo.t_wmsOutPickRequest.bulkPickState, 
                dbo.v_wmsGoods.batchMax1, dbo.v_wmsGoods.batchMax2, dbo.v_wmsGoods.batchMax3, 
                dbo.v_wmsGoods.batchMax4, dbo.v_wmsGoods.goodsTypeName, dbo.v_wmsGoods.bigCount
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/15 0:18:33 ******/
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.count - dbo.t_wmsStock.countOut AS avCount, 
                dbo.t_wmsStock.countLock, dbo.t_wmsStock.countOut, 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, dbo.v_wmsGoods.manufacturer, 
                dbo.v_wmsGoods.spec, dbo.v_wmsGoods.unit, dbo.v_wmsGoods.regeditCode, dbo.v_wmsGoods.drug_code, 
                dbo.t_wmsLocation.whType, dbo.t_wmsLocation.state AS locState, dbo.t_wmsStock.state, 
                dbo.t_wmsLocation.warehouse, dbo.v_wmsGoods.batchMax3
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/15 0:18:33 ******/
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.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, dbo.t_wmsOutPickDetail.batchPickState, dbo.t_wmsOutPickDetail.bulkPickState, 
                dbo.v_wmsGoods.bulkMax, dbo.v_wmsGoods.bulkMax1, dbo.v_wmsGoods.batchMax1, dbo.v_wmsGoods.batchMax2, 
                dbo.v_wmsGoods.goodsTypeName
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/15 0:18:33 ******/
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 LEFT OUTER JOIN
                dbo.v_wmsGoods AS b ON a.goodsId = b.goodsId

GO
/****** Object:  View [dbo].[v_stockInRequest_Available]    Script Date: 2017/6/15 0:18:33 ******/
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/15 0:18:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockInRequestDetail_Available]
AS
SELECT   dbo.v_stockInRequest_Available.orderNo, 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.addDate, a.State, a.manufacturer, a.price, a.validDate, SUM(a.count) AS count
FROM      custErp.dbo.v_stockInRequestDetail AS a INNER JOIN
                dbo.v_stockInRequest_Available ON a.orderNo = dbo.v_stockInRequest_Available.orderNo
GROUP BY dbo.v_stockInRequest_Available.orderNo, 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.addDate, a.State, a.manufacturer, a.price, a.validDate

GO
/****** Object:  View [dbo].[v_stockInRequestDetail_Available_good]    Script Date: 2017/6/15 0:18:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockInRequestDetail_Available_good]
AS
SELECT   orderNo, goodsName, spec, unit, type, regeditCode, bigCount, middleCount, address, station, weight, drug_code, 
                isDouChk, barCode, curCycle, isImport, orderType, goodsId, batch, productDate, addDate, State, manufacturer, price, 
                validDate, count
FROM      dbo.v_stockInRequestDetail_Available AS a
WHERE   (NOT EXISTS
                    (SELECT   1 AS Expr1
                     FROM      dbo.v_stockInRequestDetail_Available AS b
                     WHERE   (orderNo = a.orderNo)
                     GROUP BY goodsId, batch
                     HAVING   (COUNT(1) > 1)))

GO
/****** Object:  View [dbo].[v_stockInRequestDetail_Available_bad]    Script Date: 2017/6/15 0:18:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockInRequestDetail_Available_bad]
AS
SELECT   a.orderNo, 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.addDate, a.State, a.manufacturer, a.price, a.validDate, a.count AS cnt, dbo.v_wmsGoods.full_max, 
                dbo.v_wmsGoods.bulkMax, dbo.v_wmsGoods.bulkMax1, dbo.v_wmsGoods.batchMax1, dbo.v_wmsGoods.batchMax2, 
                dbo.v_wmsGoods.batchMax3, dbo.v_wmsGoods.batchMax4, dbo.v_wmsGoods.length, dbo.v_wmsGoods.height, 
                dbo.v_wmsGoods.width, dbo.v_wmsGoods.goodsTypeName, dbo.v_wmsGoods.manufacturer AS Expr1, 
                dbo.v_wmsGoods.spec AS Expr2, dbo.v_wmsGoods.unit AS Expr3, dbo.v_wmsGoods.regeditCode AS Expr4
FROM      dbo.v_stockInRequestDetail_Available AS a LEFT OUTER JOIN
                dbo.v_wmsGoods ON a.goodsId = dbo.v_wmsGoods.goodsId
WHERE   EXISTS
                    (SELECT   1 AS Expr1
                     FROM      dbo.v_stockInRequestDetail_Available AS b
                     WHERE   (orderNo = a.orderNo)
                     GROUP BY goodsId, batch
                     HAVING   (COUNT(1) > 1))

GO
/****** Object:  View [dbo].[v_stockInRequest_Available_bad]    Script Date: 2017/6/15 0:18:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockInRequest_Available_bad]
AS
SELECT   orderNo, orderTypeName, customID, orderDate, entid, orgid, DESCRIPTION, state, owner, vender
FROM      dbo.v_stockInRequest_Available AS a
WHERE   EXISTS
                    (SELECT   1 AS Expr1
                     FROM      dbo.v_stockInRequestDetail_Available AS b
                     WHERE   (orderNo = a.orderNo)
                     GROUP BY goodsId, batch
                     HAVING   (COUNT(1) > 1))

GO
/****** Object:  View [dbo].[v_stockInRequest_Available_good]    Script Date: 2017/6/15 0:18:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockInRequest_Available_good]
AS
SELECT   orderNo, orderTypeName, customID, orderDate, entid, orgid, DESCRIPTION, state, owner, vender
FROM      dbo.v_stockInRequest_Available AS a
WHERE   (NOT EXISTS
                    (SELECT   1 AS Expr1
                     FROM      dbo.v_stockInRequestDetail_Available AS b
                     WHERE   (orderNo = a.orderNo)
                     GROUP BY goodsId, batch
                     HAVING   (COUNT(1) > 1)))

GO
/****** Object:  View [dbo].[v_stockOutPickDetailValidation]    Script Date: 2017/6/15 0:18:33 ******/
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.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, 
                dbo.t_wmsOutPickDetail_tmp.bulkPickState, dbo.t_wmsOutPickDetail_tmp.batchPickState
FROM      dbo.t_wmsOutPickDetail_tmp LEFT OUTER JOIN
                dbo.t_node AS t_node_1 ON dbo.t_wmsOutPickDetail_tmp.validReason = t_node_1.id 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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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.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, 
                dbo.t_wmsOutPickDetail_tmp.bulkPickState, dbo.t_wmsOutPickDetail_tmp.batchPickState
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.bulkPickState = 3) OR
                (dbo.t_wmsOutPickDetail_tmp.bulkPickState = 4)

GO
/****** Object:  View [dbo].[v_stockOutDetailByCust]    Script Date: 2017/6/15 0:18:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockOutDetailByCust]
AS
SELECT   TOP (100) PERCENT 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   (pickOrderNo = a.pickOrderNo)))
GROUP BY 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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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/15 0:18:33 ******/
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, 
                dbo.t_wmsOutPickDetail.bulkPickState, dbo.t_wmsOutPickDetail.batchPickState, 
                dbo.t_wmsOutPickRequest.bulkCnt
FROM      dbo.t_wmsOutRequest LEFT OUTER JOIN
                dbo.t_wmsOutPickDetail ON 
                dbo.t_wmsOutRequest.pickOrderNo = dbo.t_wmsOutPickDetail.pickOrderNo 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
/****** Object:  View [dbo].[v_freeLocationByGroup]    Script Date: 2017/6/15 0:18:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_freeLocationByGroup]
AS
SELECT   TOP (100) PERCENT COUNT(l.id) AS 空余数量, dbo.t_node.name AS goodType, l.volType
FROM      dbo.t_wmsLocation AS l LEFT OUTER JOIN
                dbo.t_node ON l.goodsType = dbo.t_node.id
WHERE   (1 = 1) AND (NOT EXISTS
                    (SELECT   1 AS Expr1
                     FROM      dbo.t_wmsStock
                     WHERE   (locationId = l.locationId)))
GROUP BY l.goodsType, l.volType, dbo.t_node.name

GO
/****** Object:  View [dbo].[v_freeLocations]    Script Date: 2017/6/15 0:18:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_freeLocations]
AS
SELECT   id, locationId, locationId128, warehouse, channel, shelf, layer, col, elabId, elabAddress, height, width, length, weight, 
                port, part, bigPart, goodsType, whType, whGoodsType, whVolType, volType, state, tranState, operater, lastmodified, 
                createtime, dr
FROM      dbo.t_wmsLocation
WHERE   (NOT EXISTS
                    (SELECT   1 AS Expr1
                     FROM      dbo.t_wmsStock
                     WHERE   (dbo.t_wmsLocation.locationId = locationId)))

GO
/****** Object:  View [dbo].[v_location]    Script Date: 2017/6/15 0:18:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_location]
AS
SELECT   dbo.t_wmsLocation.id, dbo.t_wmsLocation.locationId, dbo.t_wmsLocation.locationId128, dbo.t_wmsLocation.warehouse, 
                dbo.t_wmsLocation.channel, dbo.t_wmsLocation.shelf, dbo.t_wmsLocation.layer, dbo.t_wmsLocation.col, 
                dbo.t_wmsLocation.elabId, dbo.t_wmsLocation.elabAddress, dbo.t_wmsLocation.height, dbo.t_wmsLocation.width, 
                dbo.t_wmsLocation.length, dbo.t_wmsLocation.weight, dbo.t_wmsLocation.port, dbo.t_wmsLocation.part, 
                dbo.t_wmsLocation.bigPart, dbo.t_wmsLocation.goodsType, dbo.t_wmsLocation.whType, 
                dbo.t_wmsLocation.whGoodsType, dbo.t_wmsLocation.whVolType, dbo.t_wmsLocation.volType, 
                dbo.t_wmsLocation.state, dbo.t_wmsLocation.tranState, dbo.t_wmsLocation.operater, dbo.t_wmsLocation.lastmodified, 
                dbo.t_wmsLocation.createtime, dbo.t_wmsLocation.dr, dbo.t_node.name AS whouseName, 
                t_node_1.name AS goodsTypeName
FROM      dbo.t_wmsLocation LEFT OUTER JOIN
                dbo.t_node AS t_node_1 ON dbo.t_wmsLocation.goodsType = t_node_1.id LEFT OUTER JOIN
                dbo.t_node ON dbo.t_wmsLocation.id = dbo.t_node.id AND dbo.t_wmsLocation.warehouse = dbo.t_node.id

GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_2_1_dwms4dbot_wmsGoods]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_2_1_dwms4dbot_wmsGoods] ON [dbo].[t_wmsGoods]
(
	[dr] ASC
)
INCLUDE ( 	[goodsId]) 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
/****** Object:  Index [IDX_2452_2451_dwms4dbot_wmsInRequest]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_2452_2451_dwms4dbot_wmsInRequest] ON [dbo].[t_wmsInRequest]
(
	[id] 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
/****** Object:  Index [IDX_3012_3011_dwms4dbot_wmsInRequest]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_3012_3011_dwms4dbot_wmsInRequest] ON [dbo].[t_wmsInRequest]
(
	[dr] ASC,
	[orderDate] 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
/****** Object:  Index [IDX_3015_3014_dwms4dbot_wmsInRequest]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_3015_3014_dwms4dbot_wmsInRequest] ON [dbo].[t_wmsInRequest]
(
	[state] ASC,
	[dr] ASC,
	[orderDate] 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_2442_2441_dwms4dbot_wmsInRequestDetail]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_2442_2441_dwms4dbot_wmsInRequestDetail] ON [dbo].[t_wmsInRequestDetail]
(
	[orderNo] 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
/****** Object:  Index [IDX_4_3_dwms4dbot_wmsLocation]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_4_3_dwms4dbot_wmsLocation] ON [dbo].[t_wmsLocation]
(
	[dr] 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
/****** Object:  Index [IDX_48_47_dwms4t_wmsLocation]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_48_47_dwms4t_wmsLocation] ON [dbo].[t_wmsLocation]
(
	[state] ASC,
	[goodsType] ASC,
	[volType] 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_48_49_dwms4t_wmsLocation]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_48_49_dwms4t_wmsLocation] ON [dbo].[t_wmsLocation]
(
	[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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_2414_2413_dwms4dbot_wmsOutDetail]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_2414_2413_dwms4dbot_wmsOutDetail] ON [dbo].[t_wmsOutDetail]
(
	[orderNo] ASC
)
INCLUDE ( 	[id],
	[goodsId],
	[batch],
	[count],
	[bulkCount],
	[batch1Count],
	[batch2Count],
	[boxcnt],
	[productDate],
	[validDate],
	[state],
	[whtype],
	[description],
	[operater],
	[dr],
	[createtime],
	[lastmodified]) 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_2416_2415_dwms4dbot_wmsOutDetail]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_2416_2415_dwms4dbot_wmsOutDetail] ON [dbo].[t_wmsOutDetail]
(
	[orderNo] ASC
)
INCLUDE ( 	[goodsId],
	[batch],
	[count],
	[productDate],
	[validDate],
	[whtype]) 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_2422_2421_dwms4dbot_wmsOutDetail]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_2422_2421_dwms4dbot_wmsOutDetail] ON [dbo].[t_wmsOutDetail]
(
	[orderNo] 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_2410_2409_dwms4dbot_wmsOutPickDetail]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_2410_2409_dwms4dbot_wmsOutPickDetail] ON [dbo].[t_wmsOutPickDetail]
(
	[pickOrderNo] 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_2691_2690_dwms4dbot_wmsOutPickDetail]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_2691_2690_dwms4dbot_wmsOutPickDetail] ON [dbo].[t_wmsOutPickDetail]
(
	[pickOrderNo] ASC
)
INCLUDE ( 	[id]) 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_3796_3795_dwms4dbot_wmsOutPickDetail]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_3796_3795_dwms4dbot_wmsOutPickDetail] ON [dbo].[t_wmsOutPickDetail]
(
	[pickOrderNo] ASC
)
INCLUDE ( 	[id],
	[count],
	[bulkCount]) 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_2_1_dwms4dbot_wmsOutPickLable]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_2_1_dwms4dbot_wmsOutPickLable] ON [dbo].[t_wmsOutPickLable]
(
	[pickOrderNo] ASC
)
INCLUDE ( 	[recordId],
	[locationId],
	[elabId],
	[port],
	[elabAddress],
	[state],
	[pickCount]) 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
/****** Object:  Index [IDX_2815_2814_dwms4dbot_wmsOutPickRequest]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_2815_2814_dwms4dbot_wmsOutPickRequest] ON [dbo].[t_wmsOutPickRequest]
(
	[id] 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_2955_2954_dwms4dbot_wmsOutPickRequest]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_2955_2954_dwms4dbot_wmsOutPickRequest] ON [dbo].[t_wmsOutPickRequest]
(
	[waveOrder] ASC
)
INCLUDE ( 	[pickOrderNo]) 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_3007_3006_dwms4dbot_wmsOutPickRequest]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_3007_3006_dwms4dbot_wmsOutPickRequest] ON [dbo].[t_wmsOutPickRequest]
(
	[waveOrder] ASC
)
INCLUDE ( 	[pickOrderNo],
	[desk],
	[bulkPickState]) 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_3492_3491_dwms4dbot_wmsOutPickRequest]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_3492_3491_dwms4dbot_wmsOutPickRequest] ON [dbo].[t_wmsOutPickRequest]
(
	[orderType] ASC,
	[state] ASC,
	[dr] ASC
)
INCLUDE ( 	[id],
	[pickOrderNo],
	[waveOrder],
	[orderTypeName],
	[customerId],
	[customerName],
	[desk],
	[boxCnt],
	[bulkCnt],
	[volume],
	[bulkPickState],
	[batchPickState],
	[orderDate],
	[description],
	[pickedBye],
	[pickedTime],
	[checkedby],
	[checkedTime],
	[waveStart],
	[waveEnd],
	[operater],
	[createtime],
	[lastmodified]) 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_3792_3791_dwms4dbot_wmsOutPickRequest]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_3792_3791_dwms4dbot_wmsOutPickRequest] ON [dbo].[t_wmsOutPickRequest]
(
	[waveOrder] ASC
)
INCLUDE ( 	[pickOrderNo],
	[customerId],
	[customerName]) 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_3825_3824_dwms4dbot_wmsOutPickRequest]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_3825_3824_dwms4dbot_wmsOutPickRequest] ON [dbo].[t_wmsOutPickRequest]
(
	[orderType] ASC,
	[state] ASC
)
INCLUDE ( 	[id],
	[pickOrderNo],
	[waveOrder],
	[orderTypeName],
	[customerId],
	[customerName],
	[desk],
	[boxCnt],
	[bulkCnt],
	[volume],
	[bulkPickState],
	[batchPickState],
	[orderDate],
	[description],
	[pickedBye],
	[pickedTime],
	[checkedby],
	[checkedTime],
	[waveStart],
	[waveEnd],
	[operater],
	[dr],
	[createtime],
	[lastmodified]) 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
/****** Object:  Index [IDX_2428_2427_dwms4dbot_wmsOutRequest]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_2428_2427_dwms4dbot_wmsOutRequest] ON [dbo].[t_wmsOutRequest]
(
	[orderType] ASC,
	[orderDate] 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
/****** Object:  Index [IDX_2430_2429_dwms4dbot_wmsOutRequest]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_2430_2429_dwms4dbot_wmsOutRequest] ON [dbo].[t_wmsOutRequest]
(
	[id] 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_2495_2494_dwms4dbot_wmsOutRequest]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_2495_2494_dwms4dbot_wmsOutRequest] ON [dbo].[t_wmsOutRequest]
(
	[orderType] ASC,
	[state] ASC
)
INCLUDE ( 	[orderNo],
	[customerId],
	[customerName]) 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_2993_2992_dwms4dbot_wmsStock]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_2993_2992_dwms4dbot_wmsStock] ON [dbo].[t_wmsStock]
(
	[goodsId] ASC,
	[batch] ASC
)
INCLUDE ( 	[id],
	[locationId],
	[productDate],
	[validDate],
	[lastmodified],
	[createtime],
	[dr],
	[validationTerm],
	[count],
	[countLock],
	[countOut],
	[state],
	[operater]) 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
/****** Object:  Index [IDX_48_47_dwms4dbot_wmsStock]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_48_47_dwms4dbot_wmsStock] ON [dbo].[t_wmsStock]
(
	[id] 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IX_t_wmsStock]    Script Date: 2017/6/15 0:18:33 ******/
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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_111_110_dwms4dbot_wmsStockRecord]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_111_110_dwms4dbot_wmsStockRecord] ON [dbo].[t_wmsStockRecord]
(
	[orderNo] 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
SET ANSI_PADDING ON

GO
/****** Object:  Index [IDX_2_1_dwms4dbot_wmsStockRecord]    Script Date: 2017/6/15 0:18:33 ******/
CREATE NONCLUSTERED INDEX [IDX_2_1_dwms4dbot_wmsStockRecord] ON [dbo].[t_wmsStockRecord]
(
	[orderNo] ASC,
	[goodsId] ASC,
	[batch] ASC
)
INCLUDE ( 	[locationId],
	[count]) 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_wmsOutLog] ADD  CONSTRAINT [DF_t_wmsOutLog_createtime]  DEFAULT (getdate()) FOR [createtime]
GO
ALTER TABLE [dbo].[t_wmsOutLog] ADD  CONSTRAINT [DF_t_wmsOutLog_dr]  DEFAULT ((1)) FOR [dr]
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[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 = "l"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 340
               Right = 226
            End
            DisplayFlags = 280
            TopColumn = 14
         End
         Begin Table = "t_node"
            Begin Extent = 
               Top = 6
               Left = 264
               Bottom = 145
               Right = 441
            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_freeLocationByGroup'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_freeLocationByGroup'
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_wmsLocation"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 145
               Right = 210
            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_freeLocations'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_freeLocations'
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_wmsLocation"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 214
               Right = 210
            End
            DisplayFlags = 280
            TopColumn = 15
         End
         Begin Table = "t_node"
            Begin Extent = 
               Top = 114
               Left = 299
               Bottom = 253
               Right = 460
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_node_1"
            Begin Extent = 
               Top = 6
               Left = 447
               Bottom = 145
               Right = 608
            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_location'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_location'
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[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 = "a"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 221
               Right = 200
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "b"
            Begin Extent = 
               Top = 6
               Left = 238
               Bottom = 215
               Right = 449
            End
            DisplayFlags = 280
            TopColumn = 22
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 1530
         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[35] 4[36] 2[12] 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 = 319
               Right = 213
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_wmsLocation"
            Begin Extent = 
               Top = 27
               Left = 289
               Bottom = 322
               Right = 461
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "v_wmsGoods"
            Begin Extent = 
               Top = 0
               Left = 608
               Bottom = 326
               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 = 3585
         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[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 = 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_stockInRequest_Available_bad'
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_bad'
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 = 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_stockInRequest_Available_good'
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_good'
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[32] 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 = 360
               Right = 291
            End
            DisplayFlags = 280
            TopColumn = 7
         End
         Begin Table = "v_stockInRequest_Available"
            Begin Extent = 
               Top = 0
               Left = 413
               Bottom = 358
               Right = 722
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 12
         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[41] 4[37] 2[14] 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 = 219
               Right = 204
            End
            DisplayFlags = 280
            TopColumn = 13
         End
         Begin Table = "v_wmsGoods"
            Begin Extent = 
               Top = 18
               Left = 395
               Bottom = 219
               Right = 585
            End
            DisplayFlags = 280
            TopColumn = 32
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 2505
         Alias = 3465
         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_bad'
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_bad'
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 = 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 = 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_Available_good'
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_good'
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[31] 4[28] 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 = -71
      End
      Begin Tables = 
         Begin Table = "a"
            Begin Extent = 
               Top = 6
               Left = 109
               Bottom = 372
               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 = 0
         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 = -50
         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 = 5
         End
         Begin Table = "t_wmsOutDesk"
            Begin Extent = 
               Top = 310
               Left = 479
               Bottom = 560
               Right = 707
            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[42] 4[42] 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 = 3
         End
         Begin Table = "v_wmsGoods"
            Begin Extent = 
               Top = 0
               Left = 432
               Bottom = 329
               Right = 622
            End
            DisplayFlags = 280
            TopColumn = 0
         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[50] 4[10] 2[35] 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_node_1"
            Begin Extent = 
               Top = 65
               Left = 911
               Bottom = 204
               Right = 1072
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_wmsOutPickDetail_tmp"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 323
               Right = 325
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_node"
            Begin Extent = 
               Top = 122
               Left = 1173
               Bottom = 261
               Right = 1334
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "v_wmsGoods"
            Begin Extent = 
               Top = 0
               Left = 445
               Bottom = 213
               Right = 635
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 4875
         Alias = 3420
         Table = 4410
         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[53] 4[21] 2[14] 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_wmsOutRequest"
            Begin Extent = 
               Top = 28
               Left = 23
               Bottom = 349
               Right = 232
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_wmsOutPickDetail"
            Begin Extent = 
               Top = 90
               Left = 336
               Bottom = 426
               Right = 557
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_wmsOutPickRequest"
            Begin Extent = 
               Top = 219
               Left = 723
               Bottom = 703
               Right = 968
            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 = 3720
         Alias = 2865
         Table = 3465
         Output = 690
         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[50] 4[30] 2[13] 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 = 10
         End
         Begin Table = "t_node"
            Begin Extent = 
               Top = 229
               Left = 1258
               Bottom = 368
               Right = 1419
            End
            DisplayFlags = 280
            TopColumn = 0
         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
      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 = 4845
         Alias = 3765
         Table = 4695
         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[43] 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_wmsStockRecord"
            Begin Extent = 
               Top = 0
               Left = 393
               Bottom = 303
               Right = 601
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "t_wmsLocation"
            Begin Extent = 
               Top = 52
               Left = 699
               Bottom = 298
               Right = 871
            End
            DisplayFlags = 280
            TopColumn = 17
         End
         Begin Table = "v_wmsGoods"
            Begin Extent = 
               Top = 15
               Left = 1142
               Bottom = 355
               Right = 1332
            End
            DisplayFlags = 280
            TopColumn = 18
         End
         Begin Table = "t_wmsOutPickRequest"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 340
               Right = 281
            End
            DisplayFlags = 280
            TopColumn = 1
         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