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