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'C:\Project\Demo\DB\Tenant_WMSDB_Main.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB ) LOG ON ( NAME = N'Tenant_WMSDB_Main_log', FILENAME = N'C:\Project\Demo\DB\Tenant_WMSDB_Main_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB ) WITH CATALOG_COLLATION = DATABASE_DEFAULT GO ALTER DATABASE [Tenant_WMSDB_Main] SET COMPATIBILITY_LEVEL = 150 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) 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