USE [master]
GO
/****** Object:  Database [custErp]    Script Date: 2017/5/20 0:44:00 ******/
CREATE DATABASE [custErp]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'custErp', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL11.ELE\MSSQL\DATA\custErp.mdf' , SIZE = 9216KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'custErp_log', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL11.ELE\MSSQL\DATA\custErp_log.ldf' , SIZE = 5696KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [custErp] SET COMPATIBILITY_LEVEL = 110
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [custErp].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [custErp] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [custErp] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [custErp] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [custErp] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [custErp] SET ARITHABORT OFF 
GO
ALTER DATABASE [custErp] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [custErp] SET AUTO_CREATE_STATISTICS ON 
GO
ALTER DATABASE [custErp] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [custErp] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [custErp] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [custErp] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [custErp] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [custErp] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [custErp] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [custErp] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [custErp] SET  DISABLE_BROKER 
GO
ALTER DATABASE [custErp] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [custErp] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [custErp] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [custErp] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [custErp] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [custErp] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [custErp] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [custErp] SET RECOVERY FULL 
GO
ALTER DATABASE [custErp] SET  MULTI_USER 
GO
ALTER DATABASE [custErp] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [custErp] SET DB_CHAINING OFF 
GO
ALTER DATABASE [custErp] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [custErp] SET TARGET_RECOVERY_TIME = 0 SECONDS 
GO
EXEC sys.sp_db_vardecimal_storage_format N'custErp', N'ON'
GO
USE [custErp]
GO
/****** Object:  Table [dbo].[t_erp_purch]    Script Date: 2017/5/20 0:44:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_erp_purch](
	[pur_order] [nvarchar](50) NOT NULL,
	[order_type] [varchar](20) NULL,
	[custom_id] [char](11) NOT NULL,
	[end_date] [datetime] NULL,
	[entid] [char](11) NOT NULL,
	[orgid] [char](11) NOT NULL,
	[remark] [varchar](200) NULL,
	[state] [int] NULL,
 CONSTRAINT [PK_t_erp_purch] PRIMARY KEY CLUSTERED 
(
	[pur_order] 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_erp_purch_d]    Script Date: 2017/5/20 0:44:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_erp_purch_d](
	[pur_order] [char](15) NOT NULL,
	[pur_order_sn] [int] NOT NULL,
	[order_type] [varchar](20) NOT NULL,
	[goods_id] [char](11) NOT NULL,
	[batch] [varchar](50) NULL,
	[product_date] [char](10) NULL,
	[save_date] [char](10) NULL,
	[count] [decimal](18, 2) NOT NULL,
	[add_date] [char](19) NOT NULL,
	[State] [int] NOT NULL,
	[ProductCompany] [varchar](50) NULL,
	[entid] [char](11) NOT NULL,
	[orgid] [char](11) NOT NULL,
	[oppcontid] [char](11) NOT NULL,
	[price] [decimal](18, 3) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[t_erp_sale]    Script Date: 2017/5/20 0:44:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_erp_sale](
	[sale_order] [char](15) NOT NULL,
	[order_type] [varchar](20) NULL,
	[custor_id] [char](11) NULL,
	[custor_name] [varchar](200) NULL,
	[Delivery] [varchar](20) NULL,
	[Send_address] [varchar](200) NULL,
	[Tel_1] [varchar](200) NULL,
	[Tel_2] [varchar](200) NULL,
	[Receive_man] [varchar](200) NULL,
	[Salse_people] [varchar](200) NULL,
	[Total_num] [int] NULL,
	[entid] [char](11) NULL,
	[orgid] [char](11) NULL,
	[end_date] [char](10) NULL,
	[Remark] [varchar](200) NULL,
	[check_state] [int] NULL,
	[InState] [varchar](10) NULL,
	[total_money] [decimal](18, 3) NULL,
	[create_date] [datetime] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[t_erp_sale_d]    Script Date: 2017/5/20 0:44:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_erp_sale_d](
	[sale_order] [char](15) NOT NULL,
	[sale_order_sn] [int] NOT NULL,
	[order_type] [varchar](20) NULL,
	[goods_id] [char](11) NULL,
	[batch] [varchar](50) NULL,
	[product_date] [char](10) NULL,
	[save_date] [char](10) NULL,
	[Count] [decimal](18, 2) NULL,
	[add_date] [nchar](19) NULL,
	[state] [int] NULL,
	[entid] [char](11) NULL,
	[orgid] [char](11) NULL,
	[oppcontid] [char](11) NULL,
	[whtype] [int] NULL,
	[whname] [varchar](20) NULL,
	[SuppliersId] [char](11) NULL,
	[create_date] [datetime] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Table_1]    Script Date: 2017/5/20 0:44:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_1](
	[id] [int] NULL
) ON [PRIMARY]

GO
/****** Object:  View [dbo].[v_bussinessDoc]    Script Date: 2017/5/20 0:44:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_bussinessDoc]
AS
SELECT   a.EntId, a.BusinessId, a.BusinessCode, a.BusinessName, a.Address, ISNULL(b.DftAddress, c.DftAddress) 
                AS DftAddress
FROM      race_yfk.dbo.BUSINESSDOC AS a WITH (nolock) LEFT OUTER JOIN
                race_yfk.dbo.SUPPLYDOC AS b WITH (nolock) ON a.BusinessId = b.SuppliersId AND a.EntId = b.EntId LEFT OUTER JOIN
                race_yfk.dbo.CLIENTDOC AS c WITH (nolock) ON a.BusinessId = c.ClientId AND a.EntId = c.EntId

GO
/****** Object:  View [dbo].[v_orgDoc]    Script Date: 2017/5/20 0:44:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_orgDoc]
AS
SELECT   ORGID, ORGCODE, ENTID, ORGNAME
FROM      race_yfk.dbo.ORGDOC AS ORGDOC_1 WITH (nolock)
WHERE   (BEACTIVE = 'Y')

GO
/****** Object:  View [dbo].[v_stockInRequest]    Script Date: 2017/5/20 0:44:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockInRequest]
AS
SELECT   dbo.t_erp_purch.pur_order AS orderNo, dbo.t_erp_purch.order_type AS orderTypeName, 
                dbo.t_erp_purch.custom_id AS customID, dbo.t_erp_purch.end_date AS orderDate, dbo.t_erp_purch.entid, 
                dbo.t_erp_purch.orgid, dbo.t_erp_purch.remark, dbo.t_erp_purch.state, dbo.v_orgDoc.ORGNAME AS owner, 
                dbo.v_bussinessDoc.BusinessName AS vender
FROM      dbo.t_erp_purch INNER JOIN
                dbo.v_orgDoc ON dbo.t_erp_purch.orgid = dbo.v_orgDoc.ORGID INNER JOIN
                dbo.v_bussinessDoc ON dbo.t_erp_purch.custom_id = dbo.v_bussinessDoc.BusinessId

GO
/****** Object:  View [dbo].[v_erpGoods]    Script Date: 2017/5/20 0:44:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_erpGoods]
AS
SELECT   a.EntId AS entid, a.GoodsId, a.GoodsName AS goodsName, a.Manufacturer AS manufacturer, a.GoodsSpec AS spec, 
                c.unit, b.Formula AS type, b.ApprovalNo AS regeditCode, a.K_Junit AS bigCount, a.K_Bunit AS middleCount, 
                a.Place AS address, b.StorageTerm AS station, c.Weight AS weight, '' AS drug_code, b.IsDouChk AS isDouChk, 
                a.BarCode AS barCode, a.Logogram, a.chang, a.kuan, a.gao, b.CurCycle AS curCycle, b.Isimport AS isImport
FROM      race_yfk.dbo.GOODSDOC AS a WITH (nolock) INNER JOIN
                race_yfk.dbo.GOODSATTR AS b WITH (nolock) ON a.GoodsId = b.GoodsId AND a.EntId = b.EntId INNER JOIN
                race_yfk.dbo.PGPRICE AS c WITH (nolock) ON a.GoodsId = c.GoodsId AND a.EntId = c.EntId AND c.IsBase = 'Y'

GO
/****** Object:  View [dbo].[v_stockInRequestDetail]    Script Date: 2017/5/20 0:44:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockInRequestDetail]
AS
SELECT   dbo.v_erpGoods.goodsName, dbo.v_erpGoods.spec, dbo.v_erpGoods.unit, dbo.v_erpGoods.type, 
                dbo.v_erpGoods.regeditCode, dbo.v_erpGoods.bigCount, dbo.v_erpGoods.middleCount, 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.curCycle, dbo.v_erpGoods.isImport, 
                dbo.t_erp_purch_d.pur_order AS orderNo, dbo.t_erp_purch_d.pur_order_sn AS orderNoSn, 
                dbo.t_erp_purch_d.order_type AS orderType, dbo.t_erp_purch_d.goods_id AS goodsId, dbo.t_erp_purch_d.batch, 
                dbo.t_erp_purch_d.product_date AS productDate, dbo.t_erp_purch_d.save_date AS validDate, dbo.t_erp_purch_d.count, 
                dbo.t_erp_purch_d.add_date AS addDate, dbo.t_erp_purch_d.State, dbo.t_erp_purch_d.price, 
                dbo.v_erpGoods.manufacturer
FROM      dbo.t_erp_purch_d INNER JOIN
                dbo.v_erpGoods ON dbo.t_erp_purch_d.goods_id = dbo.v_erpGoods.GoodsId

GO
/****** Object:  View [dbo].[v_stockOutRequest]    Script Date: 2017/5/20 0:44:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockOutRequest]
AS
SELECT   sale_order AS orderNo, order_type AS orderTypeName, custor_id AS customerId, custor_name AS customerName, 
                Send_address AS address, Delivery AS delivery, Tel_1 AS phone1, Tel_2 AS phone2, Salse_people AS salesperson, 
                Receive_man AS contactperson, Total_num AS totalnumber, Remark AS remark, end_date AS orderDate
FROM      dbo.t_erp_sale

GO
/****** Object:  View [dbo].[v_stockOutRequestDetail]    Script Date: 2017/5/20 0:44:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[v_stockOutRequestDetail]
AS
SELECT   sale_order AS orderNo, sale_order_sn AS orderSn, goods_id AS goodsId, RTRIM(LTRIM(batch)) AS batch, 
                product_date AS productDate, save_date AS validDate, Count, add_date AS saleDate, state, whtype
FROM      dbo.t_erp_sale_d

GO
ALTER TABLE [dbo].[t_erp_sale_d] ADD  CONSTRAINT [DF_t_erp_sale_d_whtype]  DEFAULT ((0)) FOR [whtype]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1 等待收货 2 正在收货 3 收货完毕 4 拒收' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N't_erp_purch', @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[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 = 219
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "b"
            Begin Extent = 
               Top = 6
               Left = 257
               Bottom = 145
               Right = 438
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "c"
            Begin Extent = 
               Top = 6
               Left = 476
               Bottom = 145
               Right = 657
            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_bussinessDoc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_bussinessDoc'
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[27] 4[43] 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 = "a"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 145
               Right = 229
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "b"
            Begin Extent = 
               Top = 6
               Left = 267
               Bottom = 145
               Right = 449
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "c"
            Begin Extent = 
               Top = 5
               Left = 613
               Bottom = 144
               Right = 769
            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 = 2715
         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_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 = "ORGDOC_1"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 145
               Right = 233
            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_orgDoc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_orgDoc'
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_erp_purch"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 145
               Right = 190
            End
            DisplayFlags = 280
            TopColumn = 1
         End
         Begin Table = "v_orgDoc"
            Begin Extent = 
               Top = 6
               Left = 228
               Bottom = 145
               Right = 381
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "v_bussinessDoc"
            Begin Extent = 
               Top = 2
               Left = 442
               Bottom = 141
               Right = 616
            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'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockInRequest'
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[42] 2[25] 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_erp_purch_d"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 237
               Right = 227
            End
            DisplayFlags = 280
            TopColumn = 7
         End
         Begin Table = "v_erpGoods"
            Begin Extent = 
               Top = 7
               Left = 502
               Bottom = 215
               Right = 676
            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 = 2010
         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'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockInRequestDetail'
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 = "t_erp_sale"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 340
               Right = 204
            End
            DisplayFlags = 280
            TopColumn = 5
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 3165
         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'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutRequest'
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[16] 2[24] 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_erp_sale_d"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 340
               Right = 309
            End
            DisplayFlags = 280
            TopColumn = 3
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 3150
         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'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'v_stockOutRequestDetail'
GO
USE [master]
GO
ALTER DATABASE [custErp] SET  READ_WRITE 
GO