USE [master]
GO
/****** Object:  Database [Tenant_WMSDB_Main]    Script Date: 2024/10/12 15:11:04 ******/
CREATE DATABASE [Tenant_WMSDB_Main]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'Tenant_WMSDB_Main', FILENAME = N'F:\DB\Tenant_WMSDB_Main.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'Tenant_WMSDB_Main_log', FILENAME = N'F:\DB\Tenant_WMSDB_Main_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET COMPATIBILITY_LEVEL = 130
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Tenant_WMSDB_Main].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET ARITHABORT OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET  DISABLE_BROKER 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET RECOVERY FULL 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET  MULTI_USER 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET DB_CHAINING OFF 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET TARGET_RECOVERY_TIME = 60 SECONDS 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET DELAYED_DURABILITY = DISABLED 
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET ACCELERATED_DATABASE_RECOVERY = OFF  
GO
EXEC sys.sp_db_vardecimal_storage_format N'Tenant_WMSDB_Main', N'ON'
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET QUERY_STORE = OFF
GO
USE [Tenant_WMSDB_Main]
GO
/****** Object:  Table [dbo].[Dt_AreaInfo]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_AreaInfo](
	[AreaID] [int] IDENTITY(1,1) NOT NULL,
	[AreaCode] [nvarchar](50) NOT NULL,
	[AreaName] [nvarchar](50) NULL,
	[AreaType] [nvarchar](50) NULL,
	[AreaDesc] [nvarchar](max) NULL,
	[AreaStatus] [int] NULL,
	[CreateID] [int] NULL,
	[Creater] [nvarchar](50) NULL,
	[CreateDate] [datetime] NULL,
	[ModifyID] [int] NULL,
	[Modifier] [nvarchar](50) NULL,
	[ModifyDate] [datetime] NULL,
	[Spare1] [nvarchar](50) NULL,
	[Spare2] [nvarchar](50) NULL,
	[Spare3] [nvarchar](50) NULL,
	[Spare4] [nvarchar](50) NULL,
	[Spare5] [nvarchar](50) NULL,
 CONSTRAINT [PK_Dt_AreaInfo] PRIMARY KEY CLUSTERED 
(
	[AreaID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Dt_BillGroupStock]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_BillGroupStock](
	[GroupId] [int] IDENTITY(1,1) NOT NULL,
	[PalletCode] [nvarchar](50) NULL,
	[OrderNo] [nvarchar](50) NULL,
	[OrderType] [int] NULL,
	[OrderDetailId] [int] NULL,
	[MaterialNo] [nvarchar](50) NULL,
	[BatchNo] [nvarchar](50) NULL,
	[GroupType] [int] NULL,
	[GroupWay] [int] NULL,
	[IsFull] [bit] NULL,
	[LocationCode] [nvarchar](50) NULL,
	[State] [int] NULL,
	[Remark] [nvarchar](100) NULL,
	[CreateID] [int] NULL,
	[CreateDate] [datetime] NULL,
	[Creater] [nvarchar](50) NULL,
	[ModifyID] [int] NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [nvarchar](50) NULL,
	[Spare1] [nvarchar](100) NULL,
	[Spare2] [nvarchar](100) NULL,
	[Spare3] [nvarchar](100) NULL,
	[Spare4] [nvarchar](100) NULL,
	[Spare5] [nvarchar](100) NULL,
 CONSTRAINT [PK_Dt_BillGroupStock] PRIMARY KEY CLUSTERED 
(
	[GroupId] 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].[Dt_BillGroupStockDetail]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_BillGroupStockDetail](
	[GroupDetailId] [int] IDENTITY(1,1) NOT NULL,
	[GroupId] [int] NULL,
	[PalletCode] [nvarchar](50) NULL,
	[OrderNo] [nvarchar](50) NULL,
	[OrderDate] [datetime] NULL,
	[BatchNo] [nvarchar](50) NULL,
	[MaterialNo] [nvarchar](50) NULL,
	[MaterialName] [nvarchar](50) NULL,
	[OutBoxCode] [nvarchar](100) NULL,
	[InBoxCode] [nvarchar](100) NULL,
	[EmptyPalletCode] [nvarchar](100) NULL,
	[PalletUnit] [nvarchar](50) NULL,
	[PalletQuantity] [decimal](18, 2) NULL,
	[BasicUnit] [nvarchar](50) NULL,
	[BasicQuantity] [decimal](18, 2) NULL,
	[CreateID] [int] NULL,
	[CreateDate] [datetime] NULL,
	[Creater] [nvarchar](50) NULL,
	[ModifyID] [int] NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [nvarchar](50) NULL,
	[Spare1] [nvarchar](100) NULL,
	[Spare2] [nvarchar](100) NULL,
	[Spare3] [nvarchar](100) NULL,
	[Spare4] [nvarchar](100) NULL,
	[Spare5] [nvarchar](100) NULL,
 CONSTRAINT [PK_Dt_BillGroupStockDetail] PRIMARY KEY CLUSTERED 
(
	[GroupDetailId] 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].[Dt_InboundOrder]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_InboundOrder](
	[OrderId] [int] IDENTITY(1,1) NOT NULL,
	[InboundNo] [nvarchar](50) NULL,
	[InboundUpperNo] [nvarchar](50) NULL,
	[BatchNo] [nvarchar](50) NULL,
	[InboundDate] [datetime] NULL,
	[InboundType] [int] NULL,
	[InboundState] [int] NULL,
	[Remark] [varchar](100) NULL,
	[CreateID] [int] NULL,
	[CreateDate] [datetime] NULL,
	[Creater] [nvarchar](50) NULL,
	[ModifyID] [int] NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [nvarchar](50) NULL,
	[Spare1] [nvarchar](100) NULL,
	[Spare2] [nvarchar](100) NULL,
	[Spare3] [nvarchar](100) NULL,
	[Spare4] [nvarchar](100) NULL,
	[Spare5] [nvarchar](100) NULL,
 CONSTRAINT [PK_Dt_InboundOrder] PRIMARY KEY CLUSTERED 
(
	[OrderId] 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].[Dt_InboundOrderDetail]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_InboundOrderDetail](
	[OrderDetailId] [int] IDENTITY(1,1) NOT NULL,
	[OrderId] [int] NULL,
	[InboundNo] [nvarchar](50) NULL,
	[BatchNo] [nvarchar](50) NULL,
	[InboundType] [int] NULL,
	[InboundState] [int] NULL,
	[MaterialNo] [nvarchar](50) NULL,
	[MaterialName] [nvarchar](50) NULL,
	[PreInboundQuantity] [nvarchar](50) NULL,
	[ActualInboundQuantity] [nvarchar](50) NULL,
	[Unit] [nvarchar](50) NULL,
	[Remark] [nvarchar](100) NULL,
	[CreateID] [int] NULL,
	[CreateDate] [datetime] NULL,
	[Creater] [nvarchar](50) NULL,
	[ModifyID] [int] NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [nvarchar](50) NULL,
 CONSTRAINT [PK_Dt_InboundOrderDetail] PRIMARY KEY CLUSTERED 
(
	[OrderDetailId] 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].[Dt_InboundOrderProduction]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_InboundOrderProduction](
	[OrderId] [int] IDENTITY(1,1) NOT NULL,
	[ProductionNo] [nvarchar](50) NULL,
	[BatchNo] [nvarchar](50) NULL,
	[ProductionDate] [nvarchar](50) NULL,
	[ProductionType] [int] NULL,
	[ProductionState] [int] NULL,
	[SynchronizationFlag] [int] NULL,
	[Remark] [nvarchar](100) NULL,
	[CreateID] [int] NULL,
	[CreateDate] [datetime] NULL,
	[Creater] [nvarchar](50) NULL,
	[ModifyID] [int] NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [nvarchar](50) NULL,
	[Spare1] [nvarchar](100) NULL,
	[Spare2] [nvarchar](100) NULL,
	[Spare3] [nvarchar](100) NULL,
	[Spare4] [nvarchar](100) NULL,
	[Spare5] [nvarchar](100) NULL,
 CONSTRAINT [PK_Dt_InboundOrderProduction] PRIMARY KEY CLUSTERED 
(
	[OrderId] 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].[Dt_InboundOrderProductionDetail]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_InboundOrderProductionDetail](
	[OrderDetailId] [int] IDENTITY(1,1) NOT NULL,
	[OrderId] [int] NULL,
	[ProductionNo] [nvarchar](50) NULL,
	[BatchNo] [nvarchar](50) NULL,
	[ProductionType] [int] NULL,
	[InboundOrganize] [nvarchar](50) NULL,
	[ProductionOrganize] [nvarchar](50) NULL,
	[ProductionState] [int] NULL,
	[ProductionMatcode] [nvarchar](50) NULL,
	[ProductionName] [nvarchar](50) NULL,
	[ReceivableQuantity] [nvarchar](50) NULL,
	[ActualQuantity] [nvarchar](50) NULL,
	[ProductionUnit] [nvarchar](50) NULL,
	[Remark] [nvarchar](100) NULL,
	[CreateID] [int] NULL,
	[CreateDate] [datetime] NULL,
	[Creater] [nvarchar](50) NULL,
	[ModifyID] [int] NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [nvarchar](50) NULL,
	[Spare1] [nvarchar](100) NULL,
	[Spare2] [nvarchar](100) NULL,
	[Spare3] [nvarchar](100) NULL,
	[Spare4] [nvarchar](100) NULL,
	[Spare5] [nvarchar](100) NULL,
 CONSTRAINT [PK_Dt_InboundOrderProductionDetail] PRIMARY KEY CLUSTERED 
(
	[OrderDetailId] 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].[Dt_InboundOrderPurchase]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_InboundOrderPurchase](
	[OrderId] [int] IDENTITY(1,1) NOT NULL,
	[PurchaseNo] [nvarchar](50) NULL,
	[BatchNo] [nvarchar](50) NULL,
	[PurchaseType] [int] NULL,
	[PurchaseState] [int] NULL,
	[SynchronizationFlag] [int] NULL,
	[PurchaseDate] [nvarchar](50) NULL,
	[Remark] [nvarchar](100) NULL,
	[CreateID] [int] NULL,
	[CreateDate] [datetime] NULL,
	[Creater] [nvarchar](50) NULL,
	[ModifyID] [int] NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [nvarchar](50) NULL,
	[Spare1] [nvarchar](50) NULL,
	[Spare2] [nvarchar](50) NULL,
	[Spare3] [nvarchar](50) NULL,
	[Spare4] [nvarchar](50) NULL,
	[Spare5] [nvarchar](50) NULL,
 CONSTRAINT [PK_Dt_InboundOrderPurchase] PRIMARY KEY CLUSTERED 
(
	[OrderId] 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].[Dt_InboundOrderPurchaseDetail]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_InboundOrderPurchaseDetail](
	[OrderDetailId] [int] IDENTITY(1,1) NOT NULL,
	[OrderId] [int] NULL,
	[PurchaseNo] [nvarchar](50) NULL,
	[BatchNo] [nvarchar](50) NULL,
	[DeliveryDate] [datetime] NULL,
	[PurchaseSupplier] [nvarchar](50) NULL,
	[PurchaseOrganize] [nvarchar](50) NULL,
	[PurchaseType] [int] NULL,
	[PurchaseState] [int] NULL,
	[PurchaseMatcode] [nvarchar](50) NULL,
	[PurchaseName] [nvarchar](50) NULL,
	[PurchaseQty] [nvarchar](50) NULL,
	[PurchaseUnit] [nvarchar](50) NULL,
	[Remark] [nvarchar](50) NULL,
	[CreateID] [int] NULL,
	[CreateDate] [datetime] NULL,
	[Creater] [nvarchar](50) NULL,
	[ModifyID] [int] NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [nvarchar](50) NULL,
	[Spare1] [nvarchar](50) NULL,
	[Spare2] [nvarchar](50) NULL,
	[Spare3] [nvarchar](50) NULL,
	[Spare4] [nvarchar](50) NULL,
	[Spare5] [nvarchar](50) NULL,
 CONSTRAINT [PK_Dt_InboundOrderPurchaseDetail] PRIMARY KEY CLUSTERED 
(
	[OrderDetailId] 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].[Dt_LocationInfo]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_LocationInfo](
	[LocationID] [int] IDENTITY(1,1) NOT NULL,
	[RoadWayNO] [nvarchar](50) NOT NULL,
	[WareAreaCode] [nvarchar](50) NULL,
	[LocationCode] [nvarchar](50) NOT NULL,
	[LocationName] [nvarchar](100) NULL,
	[Line] [nvarchar](50) NULL,
	[Column] [nvarchar](50) NULL,
	[Layer] [nvarchar](50) NULL,
	[Roadway] [nvarchar](50) NULL,
	[Depth] [nvarchar](50) NULL,
	[SCNo] [nvarchar](50) NULL,
	[SClocationID] [nvarchar](50) NULL,
	[LocationType] [int] NULL,
	[IsLocked] [bit] NULL,
	[Status] [int] NULL,
	[LocationDesc] [nvarchar](max) NULL,
	[IsDelete] [bit] NULL,
	[Remark] [nvarchar](50) NULL,
	[CreateID] [int] NULL,
	[CreateDate] [datetime] NULL,
	[Creater] [nvarchar](50) NULL,
	[ModifyID] [int] NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [nvarchar](50) NULL,
	[Spare1] [nvarchar](100) NULL,
	[Spare2] [nvarchar](100) NULL,
	[Spare3] [nvarchar](100) NULL,
	[Spare4] [nvarchar](100) NULL,
	[Spare5] [nvarchar](100) NULL,
 CONSTRAINT [PK_Dt_LocationInfo] 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] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Dt_MaterielAttribute]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_MaterielAttribute](
	[AttributeID] [int] IDENTITY(1,1) NOT NULL,
	[MaterielID] [int] NULL,
	[AttributeCode] [nvarchar](50) NULL,
	[AttributeName] [nvarchar](50) NULL,
	[AttributeDesc] [nvarchar](max) NULL,
	[Stroagecon] [nvarchar](50) NULL,
	[Transpcon] [nvarchar](50) NULL,
	[Remark] [nvarchar](50) NULL,
	[CreateID] [int] NULL,
	[CreateDate] [datetime] NULL,
	[Creater] [nvarchar](50) NULL,
	[ModifyID] [int] NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [nvarchar](50) NULL,
	[Spare1] [nvarchar](100) NULL,
	[Spare2] [nvarchar](100) NULL,
	[Spare3] [nvarchar](100) NULL,
	[Spare4] [nvarchar](100) NULL,
	[Spare5] [nvarchar](100) NULL,
 CONSTRAINT [PK_Dt_MaterielAttribute] PRIMARY KEY CLUSTERED 
(
	[AttributeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Dt_MaterielInfo]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_MaterielInfo](
	[MaterielID] [int] IDENTITY(1,1) NOT NULL,
	[MaterielCode] [nvarchar](50) NULL,
	[WareAreaCode] [nvarchar](50) NULL,
	[MaterielName] [nvarchar](100) NULL,
	[Packspes] [nvarchar](40) NULL,
	[MaterielDesc] [nvarchar](max) NULL,
	[Attribute] [nvarchar](50) NULL,
	[Unit] [nvarchar](20) NULL,
	[Status] [int] NULL,
	[MinpackQty] [decimal](18, 2) NULL,
	[Mfacturer] [nvarchar](80) NULL,
	[Supplier] [nvarchar](80) NULL,
	[Netweight] [decimal](18, 2) NULL,
	[Grossweight] [decimal](18, 2) NULL,
	[Validity] [int] NULL,
	[Safety] [decimal](18, 2) NULL,
	[Remark] [nvarchar](100) NULL,
	[CreateID] [int] NULL,
	[CreateDate] [datetime] NULL,
	[Creater] [nvarchar](50) NULL,
	[ModifyID] [int] NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [nvarchar](50) NULL,
	[spare1] [nvarchar](100) NULL,
	[spare2] [nvarchar](100) NULL,
	[spare3] [nvarchar](100) NULL,
	[spare4] [nvarchar](100) NULL,
	[spare5] [nvarchar](100) NULL,
 CONSTRAINT [PK_Dt_MaterielInfo] PRIMARY KEY CLUSTERED 
(
	[MaterielID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Dt_OutOrder]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_OutOrder](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[OrderNumber] [varchar](255) NOT NULL,
	[OrderDate] [datetime] NOT NULL,
	[WarehouseId] [int] NOT NULL,
	[Status] [int] NOT NULL,
	[UpperOutOrderId] [int] NOT NULL,
	[Remarks] [varchar](255) NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[Creater] [varchar](255) NOT NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [varchar](255) NULL,
 CONSTRAINT [PK_Dt_OutOrder_Id] 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].[Dt_OutOrderAndStock]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_OutOrderAndStock](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[OutOrderId] [int] NOT NULL,
	[OutOrderDetailId] [int] NOT NULL,
	[GroupId] [int] NOT NULL,
	[GroupDetailId] [int] NOT NULL,
	[LocationCode] [varchar](255) NOT NULL,
	[OrderNumber] [varchar](255) NOT NULL,
	[BatchNumber] [varchar](255) NOT NULL,
	[OutboundQuantity] [decimal](18, 4) NOT NULL,
	[AllocatedQuantity] [decimal](18, 4) NOT NULL,
	[CompletedQuantity] [decimal](18, 4) NOT NULL,
	[PalletCode] [varchar](255) NOT NULL,
	[MaterialNo] [varchar](255) NOT NULL,
	[MaterialName] [varchar](255) NOT NULL,
	[State] [varchar](255) NOT NULL,
	[palletQuantity] [decimal](18, 4) NOT NULL,
	[Creater] [varchar](255) NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[Modifier] [varchar](255) NULL,
	[ModifyDate] [datetime] NULL,
 CONSTRAINT [PK_Dt_OutOrderAndStock_Id] 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].[Dt_OutOrderDetail]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_OutOrderDetail](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[OutOrderId] [int] NOT NULL,
	[MaterialId] [int] NOT NULL,
	[MaterialName] [varchar](255) NOT NULL,
	[BatchNumber] [varchar](255) NOT NULL,
	[OutboundQuantity] [decimal](18, 4) NOT NULL,
	[AllocatedQuantity] [decimal](18, 4) NULL,
	[CompletedQuantity] [decimal](18, 4) NULL,
	[UnitPrice] [decimal](18, 4) NULL,
	[TotalPrice] [decimal](18, 4) NULL,
	[Remarks] [varchar](255) NULL,
	[SpareField1] [varchar](255) NULL,
	[SpareField2] [varchar](255) NULL,
	[SpareField3] [varchar](255) NULL,
	[SpareField4] [varchar](255) NULL,
	[SpareField5] [varchar](255) NULL,
	[CreateDate] [datetime] NOT NULL,
	[Creater] [varchar](255) NOT NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [varchar](255) NULL,
 CONSTRAINT [PK_Dt_OutOrderDetail_Id] 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].[Dt_OutOrderProduction]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_OutOrderProduction](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[OrderNumber] [varchar](255) NOT NULL,
	[OrderDate] [datetime] NOT NULL,
	[WarehouseId] [int] NOT NULL,
	[Status] [int] NOT NULL,
	[Remarks] [varchar](255) NULL,
	[CreateDate] [datetime] NOT NULL,
	[Creater] [varchar](255) NOT NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [varchar](255) NULL,
 CONSTRAINT [PK_Dt_OutOrderProduction_Id] 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].[Dt_OutOrderProductionDetail]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_OutOrderProductionDetail](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[ProductionOutOrderId] [int] NOT NULL,
	[MaterialId] [int] NOT NULL,
	[Quantity] [decimal](18, 4) NOT NULL,
	[UnitPrice] [decimal](18, 4) NULL,
	[TotalPrice] [decimal](18, 4) NULL,
	[Remarks] [varchar](255) NULL,
	[BatchNumber] [varchar](255) NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[Creater] [varchar](255) NOT NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [varchar](255) NULL,
 CONSTRAINT [PK_Dt_OutOrderProductionDetail_Id] 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].[Dt_OutOrderSorting]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_OutOrderSorting](
	[SortingID] [int] IDENTITY(1,1) NOT NULL,
	[OrderID] [varchar](50) NOT NULL,
	[CustomerName] [varchar](100) NULL,
	[SortingDate] [datetime] NULL,
	[Picker] [varchar](50) NULL,
	[SortingStatus] [varchar](50) NULL,
	[MaterielCode] [varchar](50) NOT NULL,
	[MaterielName] [varchar](100) NULL,
	[Specification] [varchar](100) NULL,
	[Unit] [varchar](20) NULL,
	[RequiredQuantity] [int] NULL,
	[SortedQuantity] [int] NULL,
	[StockLocation] [varchar](50) NULL,
	[SortingOrder] [int] NULL,
	[SortingZone] [varchar](50) NULL,
	[SortingMethod] [varchar](50) NULL,
	[SortingRemarks] [varchar](500) NULL,
	[SortingCompletionTime] [datetime] NULL,
	[SortingDifference] [int] NULL,
	[DifferenceReason] [varchar](500) NULL,
	[Reviewer] [varchar](50) NULL,
	[ReviewResult] [varchar](50) NULL,
	[Comments] [varchar](500) NULL,
	[CreateID] [int] NOT NULL,
	[Creater] [varchar](255) NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[ModifyID] [int] NULL,
	[Modifier] [varchar](255) NULL,
	[ModifyDate] [datetime] NULL,
 CONSTRAINT [PK_Dt_OutOrderSorting_SortingID] PRIMARY KEY CLUSTERED 
(
	[SortingID] 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].[Dt_OutOrderTransfer]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_OutOrderTransfer](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[OrderNumber] [varchar](255) NOT NULL,
	[OrderDate] [datetime] NOT NULL,
	[SourceWarehouseId] [int] NOT NULL,
	[DestinationWarehouseId] [int] NOT NULL,
	[Status] [int] NOT NULL,
	[Remarks] [varchar](255) NULL,
	[CreateDate] [datetime] NOT NULL,
	[Creater] [varchar](255) NOT NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [varchar](255) NULL,
 CONSTRAINT [PK_Dt_OutOrderTransfer_Id] 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].[Dt_OutOrderTransferDetail]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_OutOrderTransferDetail](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[TransferOutOrderId] [int] NOT NULL,
	[MaterialId] [int] NOT NULL,
	[Quantity] [decimal](18, 4) NOT NULL,
	[UnitPrice] [decimal](18, 4) NULL,
	[TotalPrice] [decimal](18, 4) NULL,
	[Remarks] [varchar](255) NULL,
	[BatchNumber] [varchar](255) NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[Creater] [varchar](255) NOT NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [varchar](255) NULL,
 CONSTRAINT [PK_Dt_OutOrderTransferDetail_Id] 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].[Dt_RoadWayInfo]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_RoadWayInfo](
	[RoadwayID] [int] IDENTITY(1,1) NOT NULL,
	[RoadWayNO] [varchar](50) NULL,
	[WareAreaID] [int] NULL,
	[IsEnable] [bit] NULL,
	[Remark] [varchar](100) NULL,
	[CreateID] [int] NULL,
	[Creater] [nvarchar](50) NULL,
	[CreateDate] [datetime] NULL,
	[ModifyID] [int] NULL,
	[Modifier] [nvarchar](50) NULL,
	[ModifyDate] [datetime] NULL,
	[Spare1] [nvarchar](100) NULL,
	[Spare2] [nvarchar](100) NULL,
	[Spare3] [nvarchar](100) NULL,
	[Spare4] [nvarchar](100) NULL,
	[Spare5] [nvarchar](100) NULL,
 CONSTRAINT [PK_Dt_RoadWayInfo] PRIMARY KEY CLUSTERED 
(
	[RoadwayID] 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].[Dt_Strategy]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_Strategy](
	[StrategyId] [int] IDENTITY(1,1) NOT NULL,
	[StrategyCode] [nvarchar](50) NULL,
	[StrategyName] [nvarchar](50) NULL,
	[FiledSource] [nvarchar](50) NULL,
	[FieldName] [nvarchar](50) NULL,
	[SordOrder] [nvarchar](50) NULL,
	[ExecutionOrder] [int] NULL,
	[StrategyType] [nvarchar](50) NULL,
	[IsPreset] [bit] NULL,
	[Remark] [nvarchar](100) NULL,
	[CreateID] [int] NULL,
	[CreateDate] [datetime] NULL,
	[Creater] [nvarchar](50) NULL,
	[ModifyID] [int] NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [nvarchar](50) NULL,
	[Spare1] [nvarchar](100) NULL,
	[Spare2] [nvarchar](100) NULL,
	[Spare3] [nvarchar](100) NULL,
	[Spare4] [nvarchar](100) NULL,
	[Spare5] [nvarchar](100) NULL,
 CONSTRAINT [PK_Dt_Strategy] PRIMARY KEY CLUSTERED 
(
	[StrategyId] 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].[Dt_Task]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_Task](
	[TaskId] [int] IDENTITY(1,1) NOT NULL,
	[TaskNum] [int] NULL,
	[PalletCode] [nvarchar](50) NULL,
	[InboundNo] [nvarchar](50) NULL,
	[GroupID] [int] NULL,
	[GroupDetailId] [int] NULL,
	[Roadway] [nvarchar](50) NULL,
	[LocationCode] [nvarchar](50) NULL,
	[TaskType] [int] NULL,
	[TaskState] [int] NULL,
	[MaterialNo] [nvarchar](50) NULL,
	[SourceAddress] [nvarchar](50) NULL,
	[TargetAddress] [nvarchar](50) NULL,
	[CurrentAddress] [nvarchar](50) NULL,
	[NextAddress] [nvarchar](50) NULL,
	[Grade] [int] NULL,
	[Dispatchertime] [datetime] NULL,
	[Remark] [nvarchar](50) NULL,
	[CreateID] [int] NULL,
	[CreateDate] [datetime] NULL,
	[Creater] [nvarchar](50) NULL,
	[ModifyID] [int] NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [nvarchar](50) NULL,
	[Spare1] [nvarchar](100) NULL,
	[Spare2] [nvarchar](100) NULL,
	[Spare3] [nvarchar](100) NULL,
	[Spare4] [nvarchar](100) NULL,
	[Spare5] [nvarchar](100) NULL,
	[ErrorMessage] [nvarchar](500) NULL,
 CONSTRAINT [PK_Dt_Task] PRIMARY KEY CLUSTERED 
(
	[TaskId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
 CONSTRAINT [unique_task_barcode] UNIQUE NONCLUSTERED 
(
	[PalletCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
 CONSTRAINT [unique_task_num] UNIQUE NONCLUSTERED 
(
	[TaskNum] 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].[Dt_TaskExecuteDetail]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_TaskExecuteDetail](
	[TaskDetailId] [int] IDENTITY(1,1) NOT NULL,
	[TaskId] [int] NULL,
	[TaskNum] [nvarchar](50) NULL,
	[TaskState] [int] NULL,
	[IsManual] [bit] NULL,
	[Remark] [nvarchar](100) NULL,
	[CreateID] [int] NULL,
	[CreateDate] [datetime] NULL,
	[Creater] [nvarchar](50) NULL,
	[ModifyID] [int] NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [nvarchar](50) NULL,
	[Spare1] [nvarchar](100) NULL,
	[Spare2] [nvarchar](100) NULL,
	[Spare3] [nvarchar](100) NULL,
	[Spare4] [nvarchar](100) NULL,
	[Spare5] [nvarchar](100) NULL,
 CONSTRAINT [PK_Dt_TaskExecuteDetail] PRIMARY KEY CLUSTERED 
(
	[TaskDetailId] 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].[Dt_UnitInfo]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_UnitInfo](
	[UnitID] [int] IDENTITY(1,1) NOT NULL,
	[UnitCode] [nvarchar](20) NULL,
	[UnitName] [nvarchar](10) NULL,
	[PackUnit] [nvarchar](10) NULL,
	[PackUnitNum] [decimal](18, 2) NULL,
	[MinUnitNum] [decimal](18, 2) NULL,
	[UnitDesc] [nvarchar](max) NULL,
	[Remark] [nvarchar](50) NULL,
	[CreateID] [int] NULL,
	[CreateDate] [datetime] NULL,
	[Creater] [nvarchar](50) NULL,
	[ModifyID] [int] NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [nvarchar](50) NULL,
	[Spare1] [nvarchar](100) NULL,
	[Spare2] [nvarchar](100) NULL,
	[Spare3] [nvarchar](100) NULL,
	[Spare4] [nvarchar](100) NULL,
	[Spare5] [nvarchar](100) NULL,
 CONSTRAINT [PK_Dt_UnitInfo] PRIMARY KEY CLUSTERED 
(
	[UnitID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Dt_WareAreaInfo]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dt_WareAreaInfo](
	[WareAreaID] [int] IDENTITY(1,1) NOT NULL,
	[AreaID] [int] NULL,
	[WareAreaCode] [nvarchar](50) NOT NULL,
	[WareAreaName] [nvarchar](20) NULL,
	[WareAreaType] [nvarchar](50) NULL,
	[WareAreaDesc] [nvarchar](max) NULL,
	[Status] [int] NULL,
	[CreateID] [int] NULL,
	[Creater] [nvarchar](50) NULL,
	[CreateDate] [datetime] NULL,
	[ModifyID] [int] NULL,
	[Modifier] [nvarchar](50) NULL,
	[ModifyDate] [datetime] NULL,
	[Spare1] [nvarchar](100) NULL,
	[Spare2] [nvarchar](100) NULL,
	[Spare3] [nvarchar](100) NULL,
	[Spare4] [nvarchar](100) NULL,
	[Spare5] [nvarchar](100) NULL,
 CONSTRAINT [PK_Dt_WAREAREAINFO] PRIMARY KEY CLUSTERED 
(
	[WareAreaID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Sys_Department]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_Department](
	[DepartmentId] [int] IDENTITY(1,1) NOT NULL,
	[DepartmentName] [varchar](50) NULL,
	[DepartmentCode] [varchar](50) NULL,
	[ParentId] [int] NOT NULL,
	[DepartmentType] [varchar](50) NULL,
	[Enable] [int] NOT NULL,
	[Remark] [varchar](2000) NULL,
	[Creater] [varchar](255) NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[Modifier] [varchar](255) NULL,
	[ModifyDate] [datetime] NULL,
	[CreateID] [int] NULL,
	[ModifyID] [int] NULL,
 CONSTRAINT [PK_Sys_Department_DepartmentId] PRIMARY KEY CLUSTERED 
(
	[DepartmentId] 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].[Sys_Dictionary]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_Dictionary](
	[DicId] [int] IDENTITY(1,1) NOT NULL,
	[Config] [nvarchar](4000) NULL,
	[CreateDate] [datetime] NULL,
	[CreateID] [int] NULL,
	[Creater] [nvarchar](30) NULL,
	[DBServer] [nvarchar](4000) NULL,
	[DbSql] [nvarchar](4000) NULL,
	[DicName] [nvarchar](100) NOT NULL,
	[DicNo] [nvarchar](100) NOT NULL,
	[Enable] [tinyint] NOT NULL,
	[Modifier] [nvarchar](30) NULL,
	[ModifyDate] [datetime] NULL,
	[ModifyID] [int] NULL,
	[OrderNo] [int] NULL,
	[ParentId] [int] NOT NULL,
	[Remark] [nvarchar](2000) NULL,
	[systemType] [int] NULL,
 CONSTRAINT [PK_Sys_Dictionary_copy1] PRIMARY KEY CLUSTERED 
(
	[DicId] 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].[Sys_DictionaryList]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_DictionaryList](
	[DicListId] [int] IDENTITY(1,1) NOT NULL,
	[CreateDate] [datetime] NULL,
	[CreateID] [int] NULL,
	[Creater] [nvarchar](30) NULL,
	[DicName] [nvarchar](100) NULL,
	[DicValue] [nvarchar](100) NULL,
	[DicId] [int] NULL,
	[Enable] [tinyint] NULL,
	[Modifier] [nvarchar](30) NULL,
	[ModifyDate] [datetime] NULL,
	[ModifyID] [int] NULL,
	[OrderNo] [int] NULL,
	[Remark] [nvarchar](2000) NULL,
 CONSTRAINT [PK_Sys_DictionaryList] PRIMARY KEY CLUSTERED 
(
	[DicListId] 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].[Sys_ExteriorInterface]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_ExteriorInterface](
	[Id] [int] NOT NULL,
	[Url] [nvarchar](20) NOT NULL,
	[Port] [nvarchar](10) NOT NULL,
	[Route] [nvarchar](50) NOT NULL,
	[Method] [nvarchar](50) NOT NULL,
	[Request] [nvarchar](10) NOT NULL,
	[Authorized] [nvarchar](max) NOT NULL,
	[Remark] [nvarchar](max) NULL,
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] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Sys_Menu]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_Menu](
	[MenuId] [int] IDENTITY(1,1) NOT NULL,
	[MenuName] [nvarchar](50) NOT NULL,
	[Auth] [nvarchar](4000) NULL,
	[Icon] [nvarchar](50) NULL,
	[Description] [nvarchar](200) NULL,
	[Enable] [tinyint] NULL,
	[OrderNo] [int] NULL,
	[TableName] [nvarchar](200) NULL,
	[ParentId] [int] NOT NULL,
	[Url] [nvarchar](4000) NULL,
	[CreateDate] [datetime] NULL,
	[Creater] [nvarchar](50) NULL,
	[ModifyDate] [datetime] NULL,
	[Modifier] [nvarchar](50) NULL,
	[MenuType] [int] NULL,
	[CreateID] [int] NULL,
	[ModifyID] [int] NULL,
 CONSTRAINT [PK_Sys_Menu] PRIMARY KEY CLUSTERED 
(
	[MenuId] 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].[Sys_Role]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_Role](
	[RoleId] [int] IDENTITY(1,1) NOT NULL,
	[DeptId] [int] NULL,
	[Enable] [tinyint] NOT NULL,
	[ParentId] [int] NOT NULL,
	[RoleName] [varchar](50) NOT NULL,
	[Creater] [varchar](255) NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[Modifier] [varchar](255) NULL,
	[ModifyDate] [datetime] NULL,
	[CreateID] [int] NULL,
	[ModifyID] [int] NULL,
 CONSTRAINT [PK_Sys_Role_RoleId] PRIMARY KEY CLUSTERED 
(
	[RoleId] 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].[Sys_RoleAuth]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_RoleAuth](
	[AuthId] [int] IDENTITY(1,1) NOT NULL,
	[AuthValue] [varchar](500) NULL,
	[MenuId] [int] NOT NULL,
	[RoleId] [int] NULL,
	[UserId] [int] NULL,
	[Creater] [varchar](255) NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[Modifier] [varchar](255) NULL,
	[ModifyDate] [datetime] NULL,
 CONSTRAINT [PK_Sys_RoleAuth_AuthId] PRIMARY KEY CLUSTERED 
(
	[AuthId] 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].[Sys_Tenant]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_Tenant](
	[TenantId] [int] IDENTITY(1,1) NOT NULL,
	[TenantName] [varchar](200) NOT NULL,
	[TenantType] [int] NOT NULL,
	[DbType] [int] NOT NULL,
	[ConnectionString] [varchar](1000) NOT NULL,
	[Status] [int] NOT NULL,
	[Remark] [varchar](2000) NULL,
	[Creater] [varchar](255) NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[Modifier] [varchar](255) NULL,
	[ModifyDate] [datetime] NULL,
 CONSTRAINT [PK_Sys_Tenant_TenantId] PRIMARY KEY CLUSTERED 
(
	[TenantId] 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].[Sys_Test]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_Test](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[TestContent] [varchar](50) NOT NULL,
	[TestCount] [int] NOT NULL,
	[Creater] [varchar](255) NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[Modifier] [varchar](255) NULL,
	[ModifyDate] [datetime] NULL,
 CONSTRAINT [PK_Sys_Test_Id] 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].[Sys_User]    Script Date: 2024/10/12 15:11:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sys_User](
	[User_Id] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [varchar](100) NOT NULL,
	[Role_Id] [int] NOT NULL,
	[RoleName] [varchar](100) NULL,
	[PhoneNo] [varchar](11) NULL,
	[Remark] [varchar](200) NULL,
	[UserPwd] [varchar](200) NOT NULL,
	[UserTrueName] [varchar](100) NOT NULL,
	[DeptName] [varchar](100) NULL,
	[Dept_Id] [int] NULL,
	[Email] [varchar](100) NULL,
	[Enable] [tinyint] NOT NULL,
	[Gender] [int] NULL,
	[HeadImageUrl] [varchar](500) NULL,
	[LastModifyPwdDate] [datetime] NULL,
	[Address] [varchar](200) NULL,
	[AuditDate] [datetime] NULL,
	[AuditStatus] [int] NULL,
	[Auditor] [varchar](100) NULL,
	[Token] [varchar](500) NULL,
	[SystemType] [int] NOT NULL,
	[TenantId] [bigint] NULL,
	[Creater] [varchar](255) NOT NULL,
	[CreateDate] [datetime] NOT NULL,
	[Modifier] [varchar](255) NULL,
	[ModifyDate] [datetime] NULL,
	[ModifyID] [int] NULL,
	[CreateID] [int] NULL,
 CONSTRAINT [PK_Sys_User_User_Id] PRIMARY KEY CLUSTERED 
(
	[User_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
ALTER TABLE [dbo].[Sys_User] ADD  CONSTRAINT [DF__Sys_User__System__7F2BE32F]  DEFAULT ('0') FOR [SystemType]
GO
ALTER TABLE [dbo].[Sys_User] ADD  CONSTRAINT [DF__Sys_User__Tenant__00200768]  DEFAULT ('0') FOR [TenantId]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'区域ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AreaInfo', @level2type=N'COLUMN',@level2name=N'AreaID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'区域编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AreaInfo', @level2type=N'COLUMN',@level2name=N'AreaCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'区域名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AreaInfo', @level2type=N'COLUMN',@level2name=N'AreaName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'区域类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AreaInfo', @level2type=N'COLUMN',@level2name=N'AreaType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'区域描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AreaInfo', @level2type=N'COLUMN',@level2name=N'AreaDesc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'区域状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AreaInfo', @level2type=N'COLUMN',@level2name=N'AreaStatus'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'区域表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AreaInfo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库存ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStock', @level2type=N'COLUMN',@level2name=N'GroupId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'托盘条码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStock', @level2type=N'COLUMN',@level2name=N'PalletCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据编号（关联inbound_order）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStock', @level2type=N'COLUMN',@level2name=N'OrderNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1,入库 2,出库' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStock', @level2type=N'COLUMN',@level2name=N'OrderType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库存明细ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStock', @level2type=N'COLUMN',@level2name=N'OrderDetailId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStock', @level2type=N'COLUMN',@level2name=N'MaterialNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批次号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStock', @level2type=N'COLUMN',@level2name=N'BatchNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组盘类型  1,一次组盘  2,二次组盘(上架前，空托组过盘)   ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStock', @level2type=N'COLUMN',@level2name=N'GroupType'
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'Dt_BillGroupStock', @level2type=N'COLUMN',@level2name=N'GroupWay'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否满盘（如果已满盘不可二次组盘，人工确定是否满盘）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStock', @level2type=N'COLUMN',@level2name=N'IsFull'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStock', @level2type=N'COLUMN',@level2name=N'LocationCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库存状态：1，组盘暂存  2，组盘撤销  3，入库确认  4，已入库  5，已出库' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStock', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStock', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组盘表（库存）主表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStock'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库存明细ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStockDetail', @level2type=N'COLUMN',@level2name=N'GroupDetailId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'外健（关联主表ID）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStockDetail', @level2type=N'COLUMN',@level2name=N'GroupId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'托盘号（关联 BillGroupStock）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStockDetail', @level2type=N'COLUMN',@level2name=N'PalletCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStockDetail', @level2type=N'COLUMN',@level2name=N'OrderNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStockDetail', @level2type=N'COLUMN',@level2name=N'OrderDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批次号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStockDetail', @level2type=N'COLUMN',@level2name=N'BatchNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStockDetail', @level2type=N'COLUMN',@level2name=N'MaterialNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStockDetail', @level2type=N'COLUMN',@level2name=N'MaterialName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'外箱码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStockDetail', @level2type=N'COLUMN',@level2name=N'OutBoxCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'内箱码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStockDetail', @level2type=N'COLUMN',@level2name=N'InBoxCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'空托盘码（主表groupWay=4空托组码时记录托盘码）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStockDetail', @level2type=N'COLUMN',@level2name=N'EmptyPalletCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组盘单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStockDetail', @level2type=N'COLUMN',@level2name=N'PalletUnit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组盘数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStockDetail', @level2type=N'COLUMN',@level2name=N'PalletQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'基本单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStockDetail', @level2type=N'COLUMN',@level2name=N'BasicUnit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'基本计量（根据单位之间的换算逻辑自动换算）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStockDetail', @level2type=N'COLUMN',@level2name=N'BasicQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组盘表（库存）明细' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_BillGroupStockDetail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库单ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrder', @level2type=N'COLUMN',@level2name=N'OrderId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrder', @level2type=N'COLUMN',@level2name=N'InboundNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上游单据编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrder', @level2type=N'COLUMN',@level2name=N'InboundUpperNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批次号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrder', @level2type=N'COLUMN',@level2name=N'BatchNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrder', @level2type=N'COLUMN',@level2name=N'InboundDate'
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'Dt_InboundOrder', @level2type=N'COLUMN',@level2name=N'InboundType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据状态（0，未开始  1，组盘中  2，完成组盘 3，入库中  4，已入库 ）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrder', @level2type=N'COLUMN',@level2name=N'InboundState'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库单主表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrder'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库单明细ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderDetail', @level2type=N'COLUMN',@level2name=N'OrderDetailId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库单ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderDetail', @level2type=N'COLUMN',@level2name=N'OrderId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据编号（关联 inboundOrder表）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderDetail', @level2type=N'COLUMN',@level2name=N'InboundNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批次号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderDetail', @level2type=N'COLUMN',@level2name=N'BatchNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据类型（1，生产入库单  2，生产退料单 3，采购入库单 4，调拨入库单 5，销售退货单 6，空盘入库单 7，其他入库单）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderDetail', @level2type=N'COLUMN',@level2name=N'InboundType'
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'Dt_InboundOrderDetail', @level2type=N'COLUMN',@level2name=N'InboundState'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderDetail', @level2type=N'COLUMN',@level2name=N'MaterialNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderDetail', @level2type=N'COLUMN',@level2name=N'MaterialName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预计入库数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderDetail', @level2type=N'COLUMN',@level2name=N'PreInboundQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'实际入库数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderDetail', @level2type=N'COLUMN',@level2name=N'ActualInboundQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderDetail', @level2type=N'COLUMN',@level2name=N'Unit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderDetail', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库单明细' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderDetail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库单ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProduction', @level2type=N'COLUMN',@level2name=N'OrderId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProduction', @level2type=N'COLUMN',@level2name=N'ProductionNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批次号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProduction', @level2type=N'COLUMN',@level2name=N'BatchNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProduction', @level2type=N'COLUMN',@level2name=N'ProductionDate'
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'Dt_InboundOrderProduction', @level2type=N'COLUMN',@level2name=N'ProductionType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProduction', @level2type=N'COLUMN',@level2name=N'ProductionState'
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'Dt_InboundOrderProduction', @level2type=N'COLUMN',@level2name=N'SynchronizationFlag'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产入库主表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProduction'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库单明细ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'OrderDetailId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库单ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'OrderId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据编号 （关联inbound_order_production）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'ProductionNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批次号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'BatchNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'ProductionType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库组织' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'InboundOrganize'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产组织' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'ProductionOrganize'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'ProductionState'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'ProductionMatcode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'ProductionName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'应收数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'ReceivableQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'实收数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'ActualQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'ProductionUnit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产入库明细' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderProductionDetail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库单ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchase', @level2type=N'COLUMN',@level2name=N'OrderId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchase', @level2type=N'COLUMN',@level2name=N'PurchaseNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批次号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchase', @level2type=N'COLUMN',@level2name=N'BatchNo'
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'Dt_InboundOrderPurchase', @level2type=N'COLUMN',@level2name=N'PurchaseType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchase', @level2type=N'COLUMN',@level2name=N'PurchaseState'
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'Dt_InboundOrderPurchase', @level2type=N'COLUMN',@level2name=N'SynchronizationFlag'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'采购日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchase', @level2type=N'COLUMN',@level2name=N'PurchaseDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'采购入库主表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchase'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库明细ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchaseDetail', @level2type=N'COLUMN',@level2name=N'OrderDetailId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'入库单ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchaseDetail', @level2type=N'COLUMN',@level2name=N'OrderId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchaseDetail', @level2type=N'COLUMN',@level2name=N'PurchaseNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批次号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchaseDetail', @level2type=N'COLUMN',@level2name=N'BatchNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'交货日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchaseDetail', @level2type=N'COLUMN',@level2name=N'DeliveryDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'供应商' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchaseDetail', @level2type=N'COLUMN',@level2name=N'PurchaseSupplier'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'采购组织' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchaseDetail', @level2type=N'COLUMN',@level2name=N'PurchaseOrganize'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchaseDetail', @level2type=N'COLUMN',@level2name=N'PurchaseType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchaseDetail', @level2type=N'COLUMN',@level2name=N'PurchaseState'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchaseDetail', @level2type=N'COLUMN',@level2name=N'PurchaseMatcode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchaseDetail', @level2type=N'COLUMN',@level2name=N'PurchaseName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'应收数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchaseDetail', @level2type=N'COLUMN',@level2name=N'PurchaseQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'采购单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchaseDetail', @level2type=N'COLUMN',@level2name=N'PurchaseUnit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchaseDetail', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产入库明细' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_InboundOrderPurchaseDetail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'货位ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'LocationID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'巷道编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'RoadWayNO'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库区编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'WareAreaCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'货位编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'LocationCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'货位名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'LocationName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'行' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'Line'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'列' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'Column'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'层' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'Layer'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'巷道' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'Roadway'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'深度' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'Depth'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对应堆垛机号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'SCNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'堆垛机对应货位站台号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'SClocationID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'货位类型（1，单深  2，多深）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'LocationType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否被锁定' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'IsLocked'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'货位状态（0，空闲 1，有货 2，锁定 3，有货禁用 4，无货禁用）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'货位描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'LocationDesc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'IsDelete'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'货位表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_LocationInfo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'属性ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielAttribute', @level2type=N'COLUMN',@level2name=N'AttributeID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielAttribute', @level2type=N'COLUMN',@level2name=N'MaterielID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'属性编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielAttribute', @level2type=N'COLUMN',@level2name=N'AttributeCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料属性名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielAttribute', @level2type=N'COLUMN',@level2name=N'AttributeName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料属性描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielAttribute', @level2type=N'COLUMN',@level2name=N'AttributeDesc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'存储条件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielAttribute', @level2type=N'COLUMN',@level2name=N'Stroagecon'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'运输条件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielAttribute', @level2type=N'COLUMN',@level2name=N'Transpcon'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料属性表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielAttribute'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'MaterielID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'MaterielCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属库区' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'WareAreaCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'MaterielName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'包装规格' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'Packspes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'MaterielDesc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料属性' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'Attribute'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'计重单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'Unit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'当前状态（0，禁用 1，启用）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最小包装数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'MinpackQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产商' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'Mfacturer'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'供应商' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'Supplier'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'净重' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'Netweight'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'毛重' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'Grossweight'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'Validity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'安全库存' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'Safety'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料基本信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_MaterielInfo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键，自动增长' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrder', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出库单号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrder', @level2type=N'COLUMN',@level2name=N'OrderNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'	出库日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrder', @level2type=N'COLUMN',@level2name=N'OrderDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'仓库ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrder', @level2type=N'COLUMN',@level2name=N'WarehouseId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrder', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上有系统单据ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrder', @level2type=N'COLUMN',@level2name=N'UpperOutOrderId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'	备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrder', @level2type=N'COLUMN',@level2name=N'Remarks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'	创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrder', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrder', @level2type=N'COLUMN',@level2name=N'Creater'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrder', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrder', @level2type=N'COLUMN',@level2name=N'Modifier'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统出库订单头表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrder'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出库订单头ID（外键）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'OutOrderId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出库订单明细ID（外键）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'OutOrderDetailId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库存头ID（外键）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'GroupId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库存明细ID（外键）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'GroupDetailId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'货位编号（外键）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'LocationCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'OrderNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批次号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'BatchNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出库数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'OutboundQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分配数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'AllocatedQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'完成数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'CompletedQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'托盘号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'PalletCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'MaterialNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'MaterialName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库存状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库存数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'palletQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'Creater'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'Modifier'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出库订单库存数据明细表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderAndStock'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'	主键，自动增长' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出库单ID（外键）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'OutOrderId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'MaterialId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'	物料名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'MaterialName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批次号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'BatchNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出库数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'OutboundQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分配数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'AllocatedQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'完成数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'CompletedQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'UnitPrice'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'总价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'TotalPrice'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'Remarks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备用字段1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'SpareField1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备用字段2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'SpareField2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备用字段3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'SpareField3'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备用字段4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'SpareField4'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备用字段5' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'SpareField5'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'	创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'Creater'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail', @level2type=N'COLUMN',@level2name=N'Modifier'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统出库订单明细' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderDetail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键，自动增长' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProduction', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProduction', @level2type=N'COLUMN',@level2name=N'OrderNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProduction', @level2type=N'COLUMN',@level2name=N'OrderDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'仓库ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProduction', @level2type=N'COLUMN',@level2name=N'WarehouseId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProduction', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProduction', @level2type=N'COLUMN',@level2name=N'Remarks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'	创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProduction', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProduction', @level2type=N'COLUMN',@level2name=N'Creater'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProduction', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProduction', @level2type=N'COLUMN',@level2name=N'Modifier'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产出库单头表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProduction'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键，自动增长' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产出库单ID（外键）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'ProductionOutOrderId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'MaterialId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'	数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'Quantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'UnitPrice'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'总价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'TotalPrice'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'Remarks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批次号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'BatchNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'	创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'Creater'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProductionDetail', @level2type=N'COLUMN',@level2name=N'Modifier'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产出库单明细' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderProductionDetail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分拣单号，唯一标识分拣任务。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'SortingID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单号，关联出库订单编号。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'OrderID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户名称。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'CustomerName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分拣日期，分拣任务的执行日期。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'SortingDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分拣员，执行分拣任务的员工名称或编号。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'Picker'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分拣状态，分拣任务的状态（如：未开始、进行中、已完成、已取消）。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'SortingStatus'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品编码，产品的唯一标识码。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'MaterielCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品名称。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'MaterielName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'规格型号，产品的规格或型号。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'Specification'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位，产品的计量单位（如：件、箱、托盘）。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'Unit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'需求数量，订单中需要分拣的产品数量。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'RequiredQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分拣数量，实际分拣的产品数量。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'SortedQuantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库存位置，产品在仓库中的存储位置。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'StockLocation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分拣顺序，分拣任务的执行顺序。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'SortingOrder'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分拣区域，产品所在的仓库区域。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'SortingZone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分拣方式，分拣的方法（如：人工分拣、自动化分拣）。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'SortingMethod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分拣备注，分拣过程中的特殊说明或注意事项。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'SortingRemarks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分拣完成时间，分拣任务完成的具体时间。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'SortingCompletionTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'分拣差异，需求数量与分拣数量的差异。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'SortingDifference'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'差异原因，分拣差异的原因（如：库存不足、分拣错误）。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'DifferenceReason'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'复核员，对分拣结果进行复核的员工姓名或编号。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'Reviewer'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'复核结果，复核的结果（如：通过、需重新分拣）。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'ReviewResult'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注，其他需要记录的信息或特殊说明。' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'Comments'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'CreateID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'Creater'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'ModifyID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'Modifier'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出库分拣表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderSorting'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键，自动增长' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransfer', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransfer', @level2type=N'COLUMN',@level2name=N'OrderNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransfer', @level2type=N'COLUMN',@level2name=N'OrderDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'源仓库ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransfer', @level2type=N'COLUMN',@level2name=N'SourceWarehouseId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'目标仓库ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransfer', @level2type=N'COLUMN',@level2name=N'DestinationWarehouseId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransfer', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransfer', @level2type=N'COLUMN',@level2name=N'Remarks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'	创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransfer', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransfer', @level2type=N'COLUMN',@level2name=N'Creater'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransfer', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransfer', @level2type=N'COLUMN',@level2name=N'Modifier'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'调拨出库单头表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransfer'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键，自动增长' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransferDetail', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'调拨出库单ID（外键）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransferDetail', @level2type=N'COLUMN',@level2name=N'TransferOutOrderId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransferDetail', @level2type=N'COLUMN',@level2name=N'MaterialId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransferDetail', @level2type=N'COLUMN',@level2name=N'Quantity'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransferDetail', @level2type=N'COLUMN',@level2name=N'UnitPrice'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'总价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransferDetail', @level2type=N'COLUMN',@level2name=N'TotalPrice'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransferDetail', @level2type=N'COLUMN',@level2name=N'Remarks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批次号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransferDetail', @level2type=N'COLUMN',@level2name=N'BatchNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'	创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransferDetail', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransferDetail', @level2type=N'COLUMN',@level2name=N'Creater'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransferDetail', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransferDetail', @level2type=N'COLUMN',@level2name=N'Modifier'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'调拨出库单明细表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_OutOrderTransferDetail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'巷道ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_RoadWayInfo', @level2type=N'COLUMN',@level2name=N'RoadwayID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'巷道号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_RoadWayInfo', @level2type=N'COLUMN',@level2name=N'RoadWayNO'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库区ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_RoadWayInfo', @level2type=N'COLUMN',@level2name=N'WareAreaID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否启用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_RoadWayInfo', @level2type=N'COLUMN',@level2name=N'IsEnable'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_RoadWayInfo', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'巷道号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_RoadWayInfo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'策略编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Strategy', @level2type=N'COLUMN',@level2name=N'StrategyCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'策略名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Strategy', @level2type=N'COLUMN',@level2name=N'StrategyName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字段来源' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Strategy', @level2type=N'COLUMN',@level2name=N'FiledSource'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'规则字段' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Strategy', @level2type=N'COLUMN',@level2name=N'FieldName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序方式' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Strategy', @level2type=N'COLUMN',@level2name=N'SordOrder'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'规则执行顺序' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Strategy', @level2type=N'COLUMN',@level2name=N'ExecutionOrder'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'策略类型（1，入库  2，出库）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Strategy', @level2type=N'COLUMN',@level2name=N'StrategyType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否预设' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Strategy', @level2type=N'COLUMN',@level2name=N'IsPreset'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Strategy', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'策略表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Strategy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TaskNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'托盘编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'PalletCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'InboundNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库存ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'GroupID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组盘明细ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'GroupDetailId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'巷道' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Roadway'
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'Dt_Task', @level2type=N'COLUMN',@level2name=N'TaskType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务状态（0新建入库任务，   100GV入库执行中，  101 AGV入库完成，  102输送线入库执行中， 103输送线入库完成，  104堆垛机入库执行中， 105堆垛机入库完成，   106入库任务完成，107入库任务取消 ）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TaskState'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'物料编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'MaterialNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'起始地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'SourceAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'目标地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TargetAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'当前位置' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'CurrentAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下一地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'NextAddress'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'优先级' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Grade'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务下发时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Dispatchertime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'TaskNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'TaskState'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否人工操作' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'IsManual'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务执行明细表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_UnitInfo', @level2type=N'COLUMN',@level2name=N'UnitID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_UnitInfo', @level2type=N'COLUMN',@level2name=N'UnitCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_UnitInfo', @level2type=N'COLUMN',@level2name=N'UnitName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'包装单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_UnitInfo', @level2type=N'COLUMN',@level2name=N'PackUnit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'包装单位量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_UnitInfo', @level2type=N'COLUMN',@level2name=N'PackUnitNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最小单位量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_UnitInfo', @level2type=N'COLUMN',@level2name=N'MinUnitNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_UnitInfo', @level2type=N'COLUMN',@level2name=N'UnitDesc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_UnitInfo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库区代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_WareAreaInfo', @level2type=N'COLUMN',@level2name=N'WareAreaCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库区名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_WareAreaInfo', @level2type=N'COLUMN',@level2name=N'WareAreaName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库区类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_WareAreaInfo', @level2type=N'COLUMN',@level2name=N'WareAreaType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库区描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_WareAreaInfo', @level2type=N'COLUMN',@level2name=N'WareAreaDesc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_WareAreaInfo', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'库区表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_WareAreaInfo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组织ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'DepartmentId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组织名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'DepartmentName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组织编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'DepartmentCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上级组织' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'ParentId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'DepartmentType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否可用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'Enable'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'Creater'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'Modifier'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'组织架构' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_ExteriorInterface', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'IP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_ExteriorInterface', @level2type=N'COLUMN',@level2name=N'Url'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'端口' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_ExteriorInterface', @level2type=N'COLUMN',@level2name=N'Port'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'路由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_ExteriorInterface', @level2type=N'COLUMN',@level2name=N'Route'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'方法名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_ExteriorInterface', @level2type=N'COLUMN',@level2name=N'Method'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'请求方式' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_ExteriorInterface', @level2type=N'COLUMN',@level2name=N'Request'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'令牌' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_ExteriorInterface', @level2type=N'COLUMN',@level2name=N'Authorized'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_ExteriorInterface', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'RoleId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'DeptId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否启用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'Enable'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'ParentId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'RoleName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'Creater'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'Modifier'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色身份验证ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'AuthId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户权限' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'AuthValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'菜单ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'MenuId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'RoleId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'UserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'Creater'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'Modifier'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色身份验证管理' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'租户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'TenantId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'租户名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'TenantName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'租户类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'TenantType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据库类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'DbType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'连接字符串' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'ConnectionString'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'Creater'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'Modifier'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'租户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Test', @level2type=N'COLUMN',@level2name=N'Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'测试Content' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Test', @level2type=N'COLUMN',@level2name=N'TestContent'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'测试Count' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Test', @level2type=N'COLUMN',@level2name=N'TestCount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Test', @level2type=N'COLUMN',@level2name=N'Creater'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Test', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Test', @level2type=N'COLUMN',@level2name=N'Modifier'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Test', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'测试' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Test'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'User_Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'帐号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'UserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Role_Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'RoleName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'PhoneNo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'UserPwd'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'真实姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'UserTrueName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'DeptName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Dept_Id'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'邮箱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Email'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否可用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Enable'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Gender'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'头像' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'HeadImageUrl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后密码修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'LastModifyPwdDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Address'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'AuditDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'AuditStatus'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Auditor'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'令牌' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Token'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'SystemType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'租户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'TenantId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Creater'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Modifier'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'ModifyDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User'
GO
USE [master]
GO
ALTER DATABASE [Tenant_WMSDB_Main] SET  READ_WRITE 
GO
