ÿþUSE [master] GO /****** Object: Database [WMS_TC] Script Date: 2025/4/16 21:37:22 ******/ CREATE DATABASE [WMS_TC] CONTAINMENT = NONE ON PRIMARY ( NAME = N'WMS_TC', FILENAME = N'E:\TCDB\UseDB\WMS_TC.mdf' , SIZE = 1449984KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB ) LOG ON ( NAME = N'WMS_TC_log', FILENAME = N'E:\TCDB\UseDB\WMS_TC_log.ldf' , SIZE = 4202496KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB ) WITH CATALOG_COLLATION = DATABASE_DEFAULT GO ALTER DATABASE [WMS_TC] SET COMPATIBILITY_LEVEL = 150 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [WMS_TC].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [WMS_TC] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [WMS_TC] SET ANSI_NULLS OFF GO ALTER DATABASE [WMS_TC] SET ANSI_PADDING OFF GO ALTER DATABASE [WMS_TC] SET ANSI_WARNINGS OFF GO ALTER DATABASE [WMS_TC] SET ARITHABORT OFF GO ALTER DATABASE [WMS_TC] SET AUTO_CLOSE OFF GO ALTER DATABASE [WMS_TC] SET AUTO_SHRINK OFF GO ALTER DATABASE [WMS_TC] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [WMS_TC] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [WMS_TC] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [WMS_TC] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [WMS_TC] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [WMS_TC] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [WMS_TC] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [WMS_TC] SET DISABLE_BROKER GO ALTER DATABASE [WMS_TC] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [WMS_TC] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [WMS_TC] SET TRUSTWORTHY OFF GO ALTER DATABASE [WMS_TC] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [WMS_TC] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [WMS_TC] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [WMS_TC] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [WMS_TC] SET RECOVERY FULL GO ALTER DATABASE [WMS_TC] SET MULTI_USER GO ALTER DATABASE [WMS_TC] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [WMS_TC] SET DB_CHAINING OFF GO ALTER DATABASE [WMS_TC] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) GO ALTER DATABASE [WMS_TC] SET TARGET_RECOVERY_TIME = 60 SECONDS GO ALTER DATABASE [WMS_TC] SET DELAYED_DURABILITY = DISABLED GO ALTER DATABASE [WMS_TC] SET QUERY_STORE = OFF GO USE [WMS_TC] GO USE [WMS_TC] GO /****** Object: Sequence [dbo].[SeqTaskNum] Script Date: 2025/4/16 21:37:22 ******/ CREATE SEQUENCE [dbo].[SeqTaskNum] AS [int] START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 100000000 CYCLE CACHE GO /****** Object: Table [dbo].[Dt_AnalysisRuleConfig] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_AnalysisRuleConfig]( [Id] [int] IDENTITY(1,1) NOT NULL, [AnalysisCode] [varchar](20) NOT NULL, [AnalysisName] [varchar](20) NOT NULL, [StartStr] [varchar](20) NULL, [EndStr] [varchar](20) NULL, [SplitStr] [varchar](20) NOT NULL, [Format] [varchar](100) NOT NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_AnalysisRuleConfig_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_ApiInfo] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ApiInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [ApiCode] [varchar](50) NOT NULL, [ApiName] [varchar](50) NULL, [ApiAddress] [varchar](200) NULL, [Remark] [varchar](50) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_ApiInfo_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_ApprovalFlow] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ApprovalFlow]( [Id] [int] IDENTITY(1,1) NOT NULL, [FlowCode] [varchar](50) NOT NULL, [FlowName] [varchar](50) NOT NULL, [FlowDes] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_ApprovalFlow_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_ApprovalNode] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ApprovalNode]( [Id] [int] IDENTITY(1,1) NOT NULL, [FlowId] [int] NOT NULL, [NodeName] [varchar](50) NOT NULL, [NodeType] [int] NOT NULL, [ApproverRole] [int] NOT NULL, [NodeSequence] [int] NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_ApprovalNode_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_ApprovalTask] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ApprovalTask]( [Id] [int] IDENTITY(1,1) NOT NULL, [FlowId] [int] NOT NULL, [NodeId] [int] NOT NULL, [ApplicantUserId] [int] NOT NULL, [ApplicantUserName] [varchar](255) NOT NULL, [Status] [int] NOT NULL, [OpinionContent] [varchar](200) NULL, [AuditUser] [varchar](50) NOT NULL, [SourceKey] [int] NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_ApprovalTask_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_CheckOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_CheckOrder]( [CheckOrderId] [int] IDENTITY(1,1) NOT NULL, [WarehouseId] [int] NOT NULL, [CheckOrderNo] [varchar](50) NOT NULL, [ReceiveOrderNo] [varchar](50) NOT NULL, [CheckOrderStatus] [int] NOT NULL, [AuditStatus] [int] NOT NULL, [ReceiveDetailRowNo] [int] NOT NULL, [MaterielCode] [varchar](50) NOT NULL, [LotNo] [varchar](50) NOT NULL, [QualifiedQuantity] [float] NULL, [DefectedQuantity] [float] NULL, [ReturnQuantity] [float] NULL, [ScrappedQuantity] [float] NULL, [ReceivedQuantity] [float] NOT NULL, [Result] [varchar](50) NULL, [DefectedNote] [varchar](50) NULL, [CheckUserName] [varchar](50) NULL, [UploadStatus] [int] NULL, [Unit] [varchar](20) NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [MaterielSpec] [varchar](200) NULL, CONSTRAINT [PK_Dt_CheckOrder_CheckOrderId] PRIMARY KEY CLUSTERED ( [CheckOrderId] 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_CheckOrderResult] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_CheckOrderResult]( [Id] [int] IDENTITY(1,1) NOT NULL, [CheckOrderId] [int] NOT NULL, [DefectCode] [varchar](50) NOT NULL, [Result] [varchar](50) NOT NULL, [Quantity] [float] NOT NULL, [SampleCount] [float] NOT NULL, [Note] [varchar](500) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_CheckOrderResult_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_CodeRuleConfig] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_CodeRuleConfig]( [Id] [int] IDENTITY(1,1) NOT NULL, [RuleCode] [varchar](20) NOT NULL, [RuleName] [varchar](20) NOT NULL, [StartVal] [int] NOT NULL, [StartStr] [varchar](5) NULL, [Format] [varchar](50) NOT NULL, [Length] [int] NOT NULL, [CurrentVal] [int] NOT NULL, [Remark] [varchar](500) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_CodeRuleConfig_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_CustomerInfo] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_CustomerInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Code] [varchar](50) NULL, [Name] [varchar](50) NULL, [NickName] [varchar](100) NULL, [State] [bit] NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [OutRule] [int] NULL, CONSTRAINT [PK_Dt_CustomerInfo_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], CONSTRAINT [¢[7bx/UNÀhåg] UNIQUE NONCLUSTERED ( [Code] 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_ErpProInOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ErpProInOrder]( [Id] [int] IDENTITY(1,1) NOT NULL, [WarehouseId] [int] NOT NULL, [OrderNo] [varchar](50) NOT NULL, [UpperOrderNo] [varchar](50) NOT NULL, [OrderType] [int] NOT NULL, [ProStockAttribute] [int] NULL, [PCode] [varchar](50) NOT NULL, [PVer] [varchar](50) NOT NULL, [PLot] [varchar](50) NOT NULL, [DateCode] [varchar](50) NOT NULL, [QtyPcs] [float] NOT NULL, [QtySet] [float] NOT NULL, [XQty] [float] NOT NULL, [XSite] [varchar](50) NOT NULL, [Unit] [varchar](50) NOT NULL, [OrderDate] [varchar](50) NOT NULL, [ProSaleOrderNo] [varchar](50) NOT NULL, [Customer] [varchar](50) NOT NULL, [FactoryCode] [varchar](50) NOT NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_ErpProInOrder_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_ErpProTransferOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ErpProTransferOrder]( [Id] [int] IDENTITY(1,1) NOT NULL, [WarehouseId] [int] NOT NULL, [OrderNo] [varchar](50) NOT NULL, [UpperOrderNo] [varchar](50) NOT NULL, [OrderType] [int] NOT NULL, [ProStockAttribute] [int] NULL, [PCode] [varchar](50) NOT NULL, [PVer] [varchar](50) NOT NULL, [PLot] [varchar](50) NOT NULL, [DateCode] [varchar](50) NOT NULL, [QtyPcs] [float] NOT NULL, [QtySet] [float] NOT NULL, [XQty] [float] NOT NULL, [XSite] [varchar](50) NOT NULL, [Unit] [varchar](50) NOT NULL, [OrderDate] [varchar](50) NOT NULL, [ProSaleOrderNo] [varchar](50) NOT NULL, [Customer] [varchar](50) NOT NULL, [FactoryCode] [varchar](50) NOT NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_ErpProTransferOrder_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_InboundOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_InboundOrder]( [Id] [int] IDENTITY(1,1) NOT NULL, [WarehouseId] [int] NOT NULL, [InboundOrderNo] [varchar](50) NOT NULL, [UpperOrderNo] [varchar](50) NULL, [SupplierId] [varchar](50) NOT NULL, [OrderType] [int] NOT NULL, [OrderStatus] [int] NOT NULL, [CreateType] [int] NOT NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_InboundOrder_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_InboundOrder_Hty] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_InboundOrder_Hty]( [Id] [int] IDENTITY(1,1) NOT NULL, [SourceId] [int] NOT NULL, [OperateType] [varchar](50) NOT NULL, [InsertTime] [datetime] NOT NULL, [WarehouseId] [int] NOT NULL, [InboundOrderNo] [varchar](50) NOT NULL, [UpperOrderNo] [varchar](50) NULL, [SupplierId] [varchar](50) NOT NULL, [OrderType] [int] NOT NULL, [OrderStatus] [int] NOT NULL, [CreateType] [int] NOT NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_InboundOrder_Hty_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_InboundOrderDetail] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_InboundOrderDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [OrderId] [int] NOT NULL, [MaterielCode] [varchar](50) NOT NULL, [BatchNo] [varchar](50) NOT NULL, [OrderQuantity] [decimal](10, 3) NOT NULL, [ReceiptQuantity] [decimal](10, 3) NOT NULL, [OverInQuantity] [decimal](10, 3) NOT NULL, [OrderDetailStatus] [int] NOT NULL, [Unit] [varchar](20) NOT NULL, [RowNo] [int] NOT NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [MaterielName] [varchar](200) NULL, [MaterielSpec] [varchar](200) NULL, CONSTRAINT [PK_Dt_InboundOrderDetail_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_InboundOrderDetail_Hty] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_InboundOrderDetail_Hty]( [Id] [int] IDENTITY(1,1) NOT NULL, [SourceId] [int] NOT NULL, [OperateType] [varchar](50) NOT NULL, [InsertTime] [datetime] NOT NULL, [OrderId] [int] NOT NULL, [MaterielCode] [varchar](50) NOT NULL, [BatchNo] [varchar](50) NOT NULL, [OrderQuantity] [decimal](10, 3) NOT NULL, [ReceiptQuantity] [decimal](10, 3) NOT NULL, [OverInQuantity] [decimal](10, 3) NOT NULL, [OrderDetailStatus] [int] NOT NULL, [Unit] [varchar](20) NOT NULL, [RowNo] [int] NOT NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_InboundOrderDetail_Hty_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_LocationInfo] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_LocationInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [WarehouseId] [int] NOT NULL, [LocationCode] [varchar](30) NULL, [LocationName] [varchar](50) NULL, [RoadwayNo] [varchar](20) NULL, [Row] [int] NULL, [Column] [int] NULL, [Layer] [int] NULL, [Depth] [int] NULL, [LocationType] [int] NULL, [LocationStatus] [int] NULL, [EnableStatus] [int] NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_LocationInfo_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_LocationStatusChangeRecord] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_LocationStatusChangeRecord]( [Id] [int] IDENTITY(1,1) NOT NULL, [LocationId] [int] NOT NULL, [LocationCode] [varchar](30) NULL, [BeforeStatus] [int] NOT NULL, [AfterStatus] [int] NOT NULL, [ChangeType] [int] NOT NULL, [OrderId] [int] NULL, [OrderNo] [varchar](50) NULL, [TaskNum] [int] NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_LocationStatusChangeRecord_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_MaterielCodeInfo] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_MaterielCodeInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [MaterielCode] [varchar](50) NOT NULL, [LotNo] [varchar](200) NOT NULL, [ProductionDate] [date] NOT NULL, [EffectiveDate] [date] NOT NULL, [PurchaseOrderNo] [varchar](50) NOT NULL, [Quantity] [decimal](10, 3) NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [WarehouseId] [int] NULL, [MaterielName] [varchar](200) NULL, [SupplierCode] [varchar](50) NULL, CONSTRAINT [PK_Dt_MaterielCodeInfo_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_MaterielInfo] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_MaterielInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [WarehouseId] [int] NOT NULL, [MaterielCode] [varchar](50) NOT NULL, [MaterielName] [varchar](200) NOT NULL, [MaterielSpec] [varchar](200) NOT NULL, [MaterielType] [int] NOT NULL, [MaterielSourceType] [int] NOT NULL, [MaterielUnit] [varchar](50) NOT NULL, [MaterielVersion] [varchar](50) NULL, [MaterielSize] [decimal](10, 3) NULL, [MaterielLength] [decimal](10, 3) NULL, [MaterielThickness] [decimal](10, 3) NULL, [MaterielWide] [decimal](10, 3) NULL, [MaterielModel] [varchar](255) NULL, [MaterielState] [int] NOT NULL, [MaterielInvOrgId] [varchar](50) NOT NULL, [IsCheck] [int] NOT NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_MaterielInfo_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_MesOutboundOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_MesOutboundOrder]( [Id] [int] IDENTITY(1,1) NOT NULL, [WarehouseId] [int] NOT NULL, [OrderNo] [varchar](50) NOT NULL, [TaskNo] [varchar](50) NOT NULL, [OrderType] [int] NOT NULL, [OrderStatus] [int] NOT NULL, [CreateType] [int] NOT NULL, [MaterialCode] [varchar](50) NOT NULL, [MaterialName] [varchar](200) NULL, [Unit] [varchar](255) NULL, [OrderQuantity] [decimal](10, 3) NOT NULL, [LockQuantity] [decimal](10, 3) NOT NULL, [OverOutQuantity] [decimal](10, 3) NOT NULL, [Line] [varchar](255) NULL, [TargetAddressCode] [varchar](255) NULL, [Width] [decimal](10, 3) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_MesOutboundOrder_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_MesPPBackInboundOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_MesPPBackInboundOrder]( [Id] [int] IDENTITY(1,1) NOT NULL, [WarehouseId] [int] NOT NULL, [InboundOrderNo] [varchar](50) NOT NULL, [SourceAddressCode] [varchar](50) NOT NULL, [CarrierCode] [varchar](50) NOT NULL, [OrderType] [int] NOT NULL, [OrderStatus] [int] NOT NULL, [CreateType] [int] NOT NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_MesPPBackInboundOrder_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_MesPPBackInboundOrderDetail] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_MesPPBackInboundOrderDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [OrderId] [int] NOT NULL, [MaterielCode] [varchar](50) NOT NULL, [MaterielName] [varchar](200) NOT NULL, [MaterialLot] [varchar](50) NOT NULL, [MaterielSpec] [varchar](200) NULL, [OrderQuantity] [decimal](10, 3) NOT NULL, [ReceiptQuantity] [decimal](10, 3) NOT NULL, [OverInQuantity] [decimal](10, 3) NOT NULL, [OrderDetailStatus] [int] NOT NULL, [Unit] [varchar](20) NOT NULL, [RowNo] [int] NOT NULL, [Remark] [varchar](255) NULL, [CutedWidth] [decimal](10, 3) NULL, [MaterialLotOld] [varchar](255) NULL, [ProductionDate] [varchar](255) NULL, [EffectiveDate] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_MesPPBackInboundOrderDetail_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_MesPPCutOutboundOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_MesPPCutOutboundOrder]( [Id] [int] IDENTITY(1,1) NOT NULL, [WarehouseId] [int] NOT NULL, [OrderNo] [varchar](50) NOT NULL, [TaskNo] [varchar](50) NOT NULL, [OrderType] [int] NOT NULL, [OrderStatus] [int] NOT NULL, [CreateType] [int] NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_MesPPCutOutboundOrder_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_MesPPCutOutboundOrderDetail] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_MesPPCutOutboundOrderDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [OrderId] [int] NOT NULL, [MaterielCode] [varchar](50) NOT NULL, [MaterielName] [varchar](200) NULL, [BatchNo] [varchar](50) NULL, [OrderQuantity] [float] NOT NULL, [LockQuantity] [float] NOT NULL, [OverOutQuantity] [float] NOT NULL, [OrderDetailStatus] [int] NOT NULL, [Unit] [varchar](255) NULL, [LayerCode] [varchar](200) NULL, [Sequence] [int] NOT NULL, [Width] [float] NULL, [TargetAddressCode] [varchar](255) NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_MesPPCutOutboundOrderDetail_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_MesPPOutboundOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_MesPPOutboundOrder]( [Id] [int] IDENTITY(1,1) NOT NULL, [WarehouseId] [int] NOT NULL, [OrderNo] [varchar](50) NOT NULL, [TaskNo] [varchar](50) NOT NULL, [OrderType] [int] NOT NULL, [OrderStatus] [int] NOT NULL, [CreateType] [int] NOT NULL, [MaterialCode] [varchar](50) NOT NULL, [MaterialName] [varchar](200) NULL, [Unit] [varchar](255) NULL, [OrderQuantity] [float] NOT NULL, [LockQuantity] [float] NOT NULL, [OverOutQuantity] [float] NOT NULL, [Line] [varchar](255) NULL, [TargetAddressCode] [varchar](255) NULL, [Width] [float] NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_MesPPOutboundOrder_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_MesPPOutboundOrderDetail] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_MesPPOutboundOrderDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [OrderId] [int] NOT NULL, [Warehouse] [varchar](50) NOT NULL, [CarrierCode] [varchar](50) NOT NULL, [OrderDetailStatus] [int] NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_MesPPOutboundOrderDetail_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_MesProInOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_MesProInOrder]( [Id] [int] IDENTITY(1,1) NOT NULL, [WarehouseId] [int] NOT NULL, [ProInOrderNo] [varchar](50) NOT NULL, [BatchNo] [varchar](20) NOT NULL, [MesProStatus] [int] NOT NULL, [UnPackStock] [int] NOT NULL, [CreateType] [int] NOT NULL, [WorkCenter] [varchar](50) NOT NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_MesProInOrder_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_MesProInOrderDetail] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_MesProInOrderDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [OrderId] [int] NOT NULL, [BagNo] [varchar](50) NOT NULL, [ProductCode] [varchar](50) NOT NULL, [ProductVersion] [varchar](50) NOT NULL, [SETQty] [float] NOT NULL, [OKPCSQTY] [float] NOT NULL, [OverInQuantity] [float] NOT NULL, [DateCode] [varchar](50) NOT NULL, [XQty] [float] NOT NULL, [XSite] [varchar](50) NULL, [Weight] [float] NOT NULL, [ERPOrder] [varchar](50) NOT NULL, [MoNumber] [varchar](50) NOT NULL, [SaleOrder] [varchar](50) NOT NULL, [LotNumber] [varchar](50) NOT NULL, [PackingDate] [datetime] NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_MesProInOrderDetail_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_MesRworkOutboundOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_MesRworkOutboundOrder]( [Id] [int] IDENTITY(1,1) NOT NULL, [WarehouseId] [int] NOT NULL, [OrderNo] [varchar](50) NOT NULL, [TaskNo] [varchar](50) NOT NULL, [LockQuantity] [float] NOT NULL, [OverOutQuantity] [float] NOT NULL, [OrderStatus] [int] NOT NULL, [CreateType] [int] NOT NULL, [OrderType] [int] NOT NULL, [ProductCode] [varchar](50) NOT NULL, [ProductName] [varchar](50) NOT NULL, [ProductVersion] [varchar](50) NOT NULL, [DateCode] [varchar](50) NOT NULL, [RequiredQuantity] [float] NOT NULL, [FactoryCode] [varchar](50) NOT NULL, [SaleOrder] [varchar](50) NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_MesRworkOutboundOrder_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_NodeTransition] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_NodeTransition]( [Id] [int] IDENTITY(1,1) NOT NULL, [FromNodeId] [int] NOT NULL, [ToNodeId] [int] NOT NULL, [Condition] [varchar](200) NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_NodeTransition_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_OutboundOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_OutboundOrder]( [Id] [int] IDENTITY(1,1) NOT NULL, [WarehouseId] [int] NOT NULL, [OrderNo] [varchar](50) NOT NULL, [UpperOrderNo] [varchar](50) NULL, [OrderType] [int] NOT NULL, [OrderStatus] [int] NOT NULL, [CreateType] [int] NOT NULL, [DepartmentCode] [varchar](50) NULL, [DepartmentName] [varchar](50) NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [UpFLOrderNo] [varchar](50) NULL, CONSTRAINT [PK_Dt_OutboundOrder_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_OutboundOrder_Hty] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_OutboundOrder_Hty]( [Id] [int] IDENTITY(1,1) NOT NULL, [SourceId] [int] NOT NULL, [OperateType] [varchar](50) NOT NULL, [InsertTime] [datetime] NOT NULL, [WarehouseId] [int] NOT NULL, [OrderNo] [varchar](50) NOT NULL, [UpperOrderNo] [varchar](50) NULL, [OrderType] [int] NOT NULL, [OrderStatus] [int] NOT NULL, [CreateType] [int] NOT NULL, [DepartmentCode] [varchar](50) NULL, [DepartmentName] [varchar](50) NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [UpFLOrderNo] [varchar](50) NULL, CONSTRAINT [PK_Dt_OutboundOrder_Hty_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_OutboundOrderDetail] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_OutboundOrderDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [OrderId] [int] NOT NULL, [MaterielCode] [varchar](50) NOT NULL, [MaterielName] [varchar](200) NULL, [BatchNo] [varchar](50) NULL, [RowNo] [int] NOT NULL, [OrderQuantity] [decimal](10, 3) NOT NULL, [LockQuantity] [decimal](10, 3) NOT NULL, [OverOutQuantity] [decimal](10, 3) NOT NULL, [OrderDetailStatus] [int] NOT NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [Unit] [varchar](255) NULL, [MaterielSpec] [varchar](200) NULL, CONSTRAINT [PK_Dt_OutboundOrderDetail_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_OutboundOrderDetail_Hty] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_OutboundOrderDetail_Hty]( [Id] [int] IDENTITY(1,1) NOT NULL, [SourceId] [int] NOT NULL, [OperateType] [varchar](50) NOT NULL, [InsertTime] [datetime] NOT NULL, [OrderId] [int] NOT NULL, [MaterielCode] [varchar](50) NOT NULL, [MaterielName] [varchar](200) NULL, [BatchNo] [varchar](50) NULL, [RowNo] [int] NOT NULL, [OrderQuantity] [decimal](10, 3) NOT NULL, [LockQuantity] [decimal](10, 3) NOT NULL, [OverOutQuantity] [decimal](10, 3) NOT NULL, [OrderDetailStatus] [int] NOT NULL, [Unit] [varchar](255) NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [MaterielSpec] [varchar](200) NULL, CONSTRAINT [PK_Dt_OutboundOrderDetail_Hty_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_OutProStockInfo] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_OutProStockInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [OrderNo] [varchar](50) NOT NULL, [OrderDetailId] [int] NOT NULL, [OrderType] [int] NOT NULL, [BatchNo] [varchar](50) NULL, [SaleOrder] [varchar](50) NULL, [Customer] [varchar](50) NOT NULL, [PCode] [varchar](50) NOT NULL, [PVer] [varchar](50) NOT NULL, [PLot] [varchar](50) NULL, [DateCode] [varchar](50) NULL, [StockId] [int] NOT NULL, [OrderQuantity] [float] NOT NULL, [OriginalQuantity] [float] NOT NULL, [AssignQuantity] [float] NOT NULL, [LocationCode] [varchar](50) NULL, [PalletCode] [varchar](50) NOT NULL, [Unit] [varchar](255) NULL, [TaskNum] [int] NULL, [Status] [int] NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_OutProStockInfo_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_OutStockLockInfo] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_OutStockLockInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [OrderNo] [varchar](50) NOT NULL, [OrderDetailId] [int] NOT NULL, [OrderType] [int] NOT NULL, [BatchNo] [varchar](50) NOT NULL, [MaterielCode] [varchar](50) NOT NULL, [MaterielName] [varchar](200) NULL, [StockId] [int] NOT NULL, [OrderQuantity] [decimal](10, 3) NOT NULL, [OriginalQuantity] [decimal](10, 3) NOT NULL, [AssignQuantity] [decimal](10, 3) NOT NULL, [LocationCode] [varchar](30) NULL, [PalletCode] [varchar](50) NOT NULL, [TaskNum] [int] NULL, [Status] [int] NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [Unit] [varchar](255) NULL, CONSTRAINT [PK_Dt_OutStockLockInfo_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_PalletCodeInfo] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_PalletCodeInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [WarehouseId] [int] NOT NULL, [PalletType] [int] NOT NULL, [PalletCode] [varchar](20) NOT NULL, [SerialNo] [int] NOT NULL, [Status] [int] NOT NULL, [Size] [int] NOT NULL, [PalletTypeId] [int] NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_PalletCodeInfo_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_PalletTypeInfo] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_PalletTypeInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [PalletType] [int] NOT NULL, [TypeName] [varchar](50) NOT NULL, [Length] [int] NOT NULL, [Width] [int] NOT NULL, [Height] [int] NOT NULL, [Enbale] [int] NOT NULL, [WarehouseId] [int] NOT NULL, [SortNum] [varchar](50) NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [CodeStartStr] [varchar](50) NULL, [LocaitonCount] [int] NULL, [IsOdd] [bit] NULL, CONSTRAINT [PK_Dt_PalletTypeInfo_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_ProOutOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ProOutOrder]( [Id] [int] IDENTITY(1,1) NOT NULL, [WarehouseId] [int] NOT NULL, [ProOutOrderNo] [varchar](20) NOT NULL, [ProOrderType] [int] NOT NULL, [ProOrderStatus] [int] NOT NULL, [PlantShipDate] [datetime] NOT NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_ProOutOrder_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_ProOutOrderDetail] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ProOutOrderDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [ProOrderId] [int] NOT NULL, [RowId] [int] NOT NULL, [ProOrderDetailStatus] [int] NOT NULL, [SaleOrder] [varchar](50) NOT NULL, [Customer] [varchar](50) NOT NULL, [FactoryCode] [varchar](50) NOT NULL, [PCode] [varchar](50) NOT NULL, [PVer] [varchar](50) NOT NULL, [PLot] [varchar](50) NULL, [DateCode] [varchar](50) NULL, [QtyPcs] [float] NOT NULL, [OverQtyPcs] [float] NOT NULL, [LockQtyPcs] [float] NOT NULL, [XQty] [varchar](255) NULL, [XSite] [varchar](50) NULL, [Unit] [varchar](50) NOT NULL, [SpareQty] [float] NOT NULL, [OutSpecifyVer] [varchar](50) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [EndCustomer] [varchar](50) NULL, CONSTRAINT [PK_Dt_ProOutOrderDetail_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_ProSpecifyVerOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ProSpecifyVerOrder]( [Id] [int] IDENTITY(1,1) NOT NULL, [WarehouseId] [int] NOT NULL, [ProSaleOrderNo] [varchar](50) NOT NULL, [RowId] [int] NOT NULL, [PCode] [varchar](50) NOT NULL, [PVer] [varchar](50) NOT NULL, [PLot] [varchar](50) NOT NULL, [DateCode] [varchar](50) NOT NULL, [QtyQcs] [float] NOT NULL, [Ver] [varchar](50) NOT NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_ProSpecifyVerOrder_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_ProStockInfo] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ProStockInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [PalletCode] [varchar](50) NOT NULL, [ProStockAttribute] [int] NULL, [PalletType] [int] NOT NULL, [LocationCode] [varchar](30) NULL, [ShipmentOrder] [varchar](30) NULL, [WarehouseId] [int] NOT NULL, [StockStatus] [int] NOT NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_ProStockInfo_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_ProStockInfo_Hty] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ProStockInfo_Hty]( [Id] [int] IDENTITY(1,1) NOT NULL, [SourceId] [int] NOT NULL, [OperateType] [varchar](50) NOT NULL, [InsertTime] [datetime] NOT NULL, [PalletCode] [varchar](50) NOT NULL, [ProStockAttribute] [int] NULL, [PalletType] [int] NOT NULL, [LocationCode] [varchar](30) NULL, [ShipmentOrder] [varchar](30) NULL, [WarehouseId] [int] NOT NULL, [StockStatus] [int] NOT NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_ProStockInfo_Hty_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_ProStockInfoDetail] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ProStockInfoDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [ProStockId] [int] NOT NULL, [BagNo] [varchar](50) NOT NULL, [ProductCode] [varchar](50) NOT NULL, [OutboundQuantity] [float] NOT NULL, [OutSETQty] [float] NOT NULL, [ProOutDetailStatus] [int] NOT NULL, [ProductVersion] [varchar](50) NOT NULL, [SETQty] [float] NOT NULL, [StockPcsQty] [float] NOT NULL, [DateCode] [varchar](50) NOT NULL, [XQty] [float] NOT NULL, [XSite] [varchar](50) NULL, [Weight] [float] NOT NULL, [PackingDate] [datetime] NULL, [LotNumber] [varchar](50) NOT NULL, [ERPOrder] [varchar](50) NOT NULL, [MoNumber] [varchar](50) NOT NULL, [SaleOrder] [varchar](50) NOT NULL, [SpecifyVer] [varchar](50) NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [OutDetailId] [int] NULL, [OutDetailSaleNo] [varchar](50) NULL, CONSTRAINT [PK_Dt_ProStockInfoDetail_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_ProStockInfoDetail_Hty] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ProStockInfoDetail_Hty]( [Id] [int] IDENTITY(1,1) NOT NULL, [SourceId] [int] NOT NULL, [OperateType] [varchar](50) NOT NULL, [InsertTime] [datetime] NOT NULL, [ProStockId] [int] NOT NULL, [BagNo] [varchar](50) NOT NULL, [ProductCode] [varchar](50) NOT NULL, [OutboundQuantity] [float] NOT NULL, [OutSETQty] [float] NOT NULL, [ProOutDetailStatus] [int] NOT NULL, [ProductVersion] [varchar](50) NOT NULL, [SETQty] [float] NOT NULL, [StockPcsQty] [float] NOT NULL, [DateCode] [varchar](50) NOT NULL, [XQty] [float] NOT NULL, [XSite] [varchar](50) NULL, [Weight] [float] NOT NULL, [PackingDate] [datetime] NULL, [LotNumber] [varchar](50) NOT NULL, [ERPOrder] [varchar](50) NOT NULL, [MoNumber] [varchar](50) NOT NULL, [SaleOrder] [varchar](50) NOT NULL, [SpecifyVer] [varchar](50) NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_ProStockInfoDetail_Hty_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_PurchaseOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_PurchaseOrder]( [Id] [int] IDENTITY(1,1) NOT NULL, [PurchaseOrderNo] [varchar](50) NOT NULL, [PurchaseOrderType] [varchar](50) NOT NULL, [SupplierCode] [varchar](50) NOT NULL, [OrderQuantity] [float] NOT NULL, [PurchaseOrderStatus] [int] NOT NULL, [OrderDate] [varchar](50) NOT NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_PurchaseOrder_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_PurchaseOrderDetail] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_PurchaseOrderDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [PurchaseOrderId] [int] NOT NULL, [RowNo] [int] NOT NULL, [MaterielCode] [varchar](50) NOT NULL, [PurchaseDetailStatus] [int] NOT NULL, [WarehouseId] [int] NOT NULL, [PurchaseDetailQuantity] [decimal](10, 3) NOT NULL, [PurchaseDetailReceiveQty] [decimal](10, 3) NOT NULL, [Unit] [varchar](20) NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [MaterielName] [varchar](200) NULL, [MaterielSpec] [varchar](200) NULL, CONSTRAINT [PK_Dt_PurchaseOrderDetail_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_ReceiveOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ReceiveOrder]( [ReceiveOrderId] [int] IDENTITY(1,1) NOT NULL, [ReceiveOrderNo] [varchar](50) NOT NULL, [ReceiveOrderType] [int] NOT NULL, [ReceiveOrderStatus] [int] NOT NULL, [UploadStatus] [int] NOT NULL, [CustomerId] [varchar](50) NULL, [SuppliersId] [varchar](50) NOT NULL, [WarehouseId] [int] NOT NULL, [ReceiveDate] [datetime] NOT NULL, [DeliveryCode] [varchar](50) NULL, [Remark] [varchar](500) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [CreateInOrderStatus] [int] NULL, CONSTRAINT [PK_Dt_ReceiveOrder_ReceiveOrderId] PRIMARY KEY CLUSTERED ( [ReceiveOrderId] 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_ReceiveOrderDetail] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ReceiveOrderDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [ReceiveOrderId] [int] NOT NULL, [PurchaseOrderNo] [varchar](50) NOT NULL, [PurchaseOrderDetailRowNo] [int] NOT NULL, [RowNo] [int] NOT NULL, [MaterielCode] [varchar](50) NOT NULL, [LotNo] [varchar](50) NOT NULL, [ReceivedQuantity] [decimal](10, 3) NOT NULL, [IfInspection] [int] NOT NULL, [PriceInTax] [decimal](10, 3) NOT NULL, [TaxRate] [varchar](20) NULL, [CurrCode] [varchar](20) NULL, [Remark] [varchar](500) NULL, [Unit] [varchar](20) NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [MaterielName] [varchar](200) NULL, [MaterielSpec] [varchar](200) NULL, CONSTRAINT [PK_Dt_ReceiveOrderDetail_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_ReturnOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ReturnOrder]( [Id] [int] IDENTITY(1,1) NOT NULL, [OrderNo] [varchar](50) NOT NULL, [WarehouseId] [int] NOT NULL, [ReturnOrderType] [int] NOT NULL, [ReturnOrderStatus] [int] NOT NULL, [UploadStatus] [int] NOT NULL, [IsDev] [int] NOT NULL, [Remark] [varchar](500) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_ReturnOrder_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_ReturnOrderDetail] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ReturnOrderDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [ReturnId] [int] NOT NULL, [PickCode] [varchar](50) NOT NULL, [ApplyRow] [int] NOT NULL, [RowId] [int] NOT NULL, [OrderDetailStatus] [int] NOT NULL, [MCode] [varchar](50) NOT NULL, [MaterielName] [varchar](100) NULL, [MaterielSpec] [varchar](200) NULL, [BatchNo] [varchar](50) NOT NULL, [Qty] [decimal](10, 3) NOT NULL, [ReturnQty] [decimal](10, 3) NOT NULL, [OverReturnQty] [decimal](10, 3) NOT NULL, [Unit] [varchar](20) NOT NULL, [Code] [varchar](50) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_ReturnOrderDetail_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_StockInfo] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_StockInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [PalletCode] [varchar](50) NOT NULL, [PalletType] [int] NOT NULL, [LocationCode] [varchar](30) NULL, [WarehouseId] [int] NOT NULL, [StockStatus] [int] NOT NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_StockInfo_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_StockInfo_Hty] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_StockInfo_Hty]( [Id] [int] IDENTITY(1,1) NOT NULL, [SourceId] [int] NOT NULL, [OperateType] [varchar](50) NOT NULL, [InsertTime] [datetime] NOT NULL, [PalletCode] [varchar](50) NOT NULL, [PalletType] [int] NOT NULL, [LocationCode] [varchar](30) NULL, [WarehouseId] [int] NOT NULL, [StockStatus] [int] NOT NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_StockInfo_Hty_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_StockInfoDetail] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_StockInfoDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [StockId] [int] NOT NULL, [MaterielCode] [varchar](50) NOT NULL, [MaterielName] [varchar](200) NOT NULL, [OrderNo] [varchar](50) NOT NULL, [BatchNo] [varchar](50) NULL, [ProductionDate] [varchar](20) NOT NULL, [EffectiveDate] [varchar](20) NOT NULL, [SerialNumber] [varchar](200) NOT NULL, [StockQuantity] [decimal](10, 3) NOT NULL, [OutboundQuantity] [decimal](10, 3) NOT NULL, [Status] [int] NOT NULL, [InboundOrderRowNo] [int] NOT NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [Unit] [varchar](255) NULL, [MaterielSpec] [varchar](200) NULL, [CutedWidth] [decimal](10, 3) NULL, CONSTRAINT [PK_Dt_StockInfoDetail_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_StockInfoDetail_Hty] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_StockInfoDetail_Hty]( [Id] [int] IDENTITY(1,1) NOT NULL, [SourceId] [int] NOT NULL, [OperateType] [varchar](50) NOT NULL, [InsertTime] [datetime] NOT NULL, [StockId] [int] NOT NULL, [MaterielCode] [varchar](50) NOT NULL, [MaterielName] [varchar](200) NOT NULL, [OrderNo] [varchar](50) NOT NULL, [BatchNo] [varchar](100) NULL, [ProductionDate] [varchar](20) NOT NULL, [EffectiveDate] [varchar](20) NOT NULL, [SerialNumber] [varchar](100) NOT NULL, [StockQuantity] [float] NOT NULL, [OutboundQuantity] [float] NOT NULL, [Status] [int] NOT NULL, [Unit] [varchar](255) NULL, [InboundOrderRowNo] [int] NOT NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [MaterielSpec] [varchar](200) NULL, [CutedWidth] [float] NULL, CONSTRAINT [PK_Dt_StockInfoDetail_Hty_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_StockQuantityChangeRecord] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_StockQuantityChangeRecord]( [Id] [int] IDENTITY(1,1) NOT NULL, [StockDetailId] [int] NOT NULL, [PalleCode] [varchar](50) NOT NULL, [MaterielCode] [varchar](50) NOT NULL, [MaterielName] [varchar](200) NOT NULL, [BatchNo] [varchar](50) NOT NULL, [SerilNumber] [varchar](100) NOT NULL, [OrderNo] [varchar](50) NULL, [TaskNum] [int] NULL, [ChangeType] [int] NOT NULL, [ChangeQuantity] [decimal](10, 3) NOT NULL, [BeforeQuantity] [float] NOT NULL, [AfterQuantity] [float] NOT NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_StockQuantityChangeRecord_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_SupplierInfo] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_SupplierInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [SupplierCode] [varchar](50) NULL, [SupplierName] [varchar](200) NULL, [SupplierShortName] [varchar](50) NULL, [Contacts] [varchar](50) NULL, [ContactNumber] [varchar](50) NULL, [ContactAddress] [varchar](200) NULL, [Email] [varchar](50) NULL, [Description] [varchar](200) NULL, [InvOrgId] [varchar](50) NULL, [Status] [int] NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_SupplierInfo_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_TakeStockOrder] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_TakeStockOrder]( [Id] [int] IDENTITY(1,1) NOT NULL, [OrderNo] [varchar](50) NOT NULL, [WarehouseId] [int] NOT NULL, [TakeStockStatus] [int] NOT NULL, [Remark] [varchar](500) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_TakeStockOrder_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_TakeStockOrderDetail] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_TakeStockOrderDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [TakeStockId] [int] NOT NULL, [MaterielCode] [varchar](50) NOT NULL, [MaterielName] [varchar](200) NOT NULL, [BatchNo] [varchar](50) NOT NULL, [MaterielSpec] [varchar](200) NULL, [Unit] [varchar](50) NULL, [SysQty] [decimal](10, 3) NULL, [Qty] [decimal](10, 3) NULL, [Remark] [varchar](500) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_TakeStockOrderDetail_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_Task] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_Task]( [TaskId] [int] IDENTITY(1,1) NOT NULL, [TaskNum] [int] NOT NULL, [PalletCode] [varchar](50) NOT NULL, [PalletType] [int] NOT NULL, [Roadway] [varchar](10) NOT NULL, [TaskType] [int] NOT NULL, [TaskStatus] [int] NOT NULL, [SourceAddress] [varchar](30) NOT NULL, [TargetAddress] [varchar](30) NOT NULL, [CurrentAddress] [varchar](30) NOT NULL, [NextAddress] [varchar](30) NOT NULL, [WarehouseId] [int] NOT NULL, [OrderNo] [varchar](50) NULL, [Grade] [int] NOT NULL, [Dispatchertime] [datetime] NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_Task_TaskId] 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] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_Task_Hty] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_Task_Hty]( [TaskId] [int] IDENTITY(1,1) NOT NULL, [SourceId] [int] NOT NULL, [OperateType] [varchar](50) NOT NULL, [InsertTime] [datetime] NOT NULL, [TaskNum] [int] NOT NULL, [PalletCode] [varchar](50) NOT NULL, [PalletType] [int] NOT NULL, [Roadway] [varchar](10) NOT NULL, [TaskType] [int] NOT NULL, [TaskStatus] [int] NOT NULL, [SourceAddress] [varchar](30) NOT NULL, [TargetAddress] [varchar](30) NOT NULL, [CurrentAddress] [varchar](30) NOT NULL, [NextAddress] [varchar](30) NOT NULL, [WarehouseId] [int] NOT NULL, [OrderNo] [varchar](50) NULL, [Grade] [int] NOT NULL, [Dispatchertime] [datetime] NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_Task_Hty_TaskId] 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] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_UserInfo] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_UserInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [Code] [varchar](50) NULL, [DeptNo] [varchar](50) NULL, [DeptName] [varchar](50) NULL, [Name] [varchar](50) NULL, [State] [int] NOT NULL, [InvOrgId] [varchar](50) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_UserInfo_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_Warehouse] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_Warehouse]( [WarehouseId] [int] IDENTITY(1,1) NOT NULL, [WarehouseCode] [varchar](20) NOT NULL, [WarehouseName] [varchar](20) NOT NULL, [WarehouseType] [varchar](20) NOT NULL, [WarehouseStatus] [int] NOT NULL, [WarehouseDes] [varchar](255) NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_Warehouse_WarehouseId] PRIMARY KEY CLUSTERED ( [WarehouseId] 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: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_Dictionary]( [DicId] [int] IDENTITY(1,1) NOT NULL, [Config] [varchar](200) NULL, [Sql] [varchar](500) NULL, [DicName] [varchar](50) NULL, [DicNo] [varchar](50) NULL, [Enable] [tinyint] NULL, [OrderNo] [int] NULL, [ParentId] [int] NULL, [Remark] [varchar](2000) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_Dictionary_DicId] 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: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_DictionaryList]( [DicListId] [int] IDENTITY(1,1) NOT NULL, [DicName] [varchar](50) NULL, [DicValue] [varchar](50) NULL, [DicId] [int] NOT NULL, [Enable] [tinyint] NULL, [OrderNo] [int] NULL, [Remark] [varchar](2000) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_DictionaryList_DicListId] 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_Log] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_Log]( [Id] [int] IDENTITY(1,1) NOT NULL, [BeginDate] [datetime] NULL, [ElapsedTime] [int] NULL, [EndDate] [datetime] NULL, [RequestParam] [varchar](max) NULL, [ResponseParam] [varchar](max) NULL, [Success] [int] NULL, [Url] [varchar](2000) NULL, [UserIP] [varchar](20) NULL, [UserName] [varchar](50) NULL, [UserId] [int] NULL, CONSTRAINT [PK_Sys_Log_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] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_Menu] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_Menu]( [MenuId] [int] IDENTITY(1,1) NOT NULL, [MenuName] [varchar](50) NULL, [Auth] [varchar](2000) NULL, [Icon] [varchar](200) NULL, [Description] [varchar](2000) NULL, [Enable] [tinyint] NULL, [TableName] [varchar](50) NULL, [ParentId] [int] NOT NULL, [Url] [varchar](50) NULL, [OrderNo] [int] NULL, [MenuType] [int] NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_Menu_MenuId] 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: 2025/4/16 21:37:22 ******/ 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](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] 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: 2025/4/16 21:37:22 ******/ 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](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) 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_RoleDataPermission] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_RoleDataPermission]( [Id] [int] IDENTITY(1,1) NOT NULL, [RoleId] [int] NOT NULL, [RoleName] [varchar](50) NOT NULL, [WarehouseId] [int] NOT NULL, [WarehouseName] [varchar](50) NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_RoleDataPermission_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_Tenant] Script Date: 2025/4/16 21:37:22 ******/ 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](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) 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_User] Script Date: 2025/4/16 21:37:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_User]( [UserId] [int] IDENTITY(1,1) NOT NULL, [UserName] [varchar](100) NOT NULL, [RoleId] [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, [DeptId] [int] NULL, [Email] [varchar](100) NULL, [Enable] [tinyint] NOT NULL, [Gender] [int] NULL, [HeadImageUrl] [varchar](500) NULL, [LastModifyPwdDate] [datetime] NULL, [Address] [varchar](200) NULL, [Token] [varchar](500) NULL, [TenantId] [bigint] NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_User_UserId] PRIMARY KEY CLUSTERED ( [UserId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING ON GO /****** Object: Index [unique_materielinfo_materielcode] Script Date: 2025/4/16 21:37:22 ******/ CREATE UNIQUE NONCLUSTERED INDEX [unique_materielinfo_materielcode] ON [dbo].[Dt_MaterielInfo] ( [MaterielCode] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO /****** Object: Index [unique_task_taskNum] Script Date: 2025/4/16 21:37:22 ******/ CREATE UNIQUE NONCLUSTERED INDEX [unique_task_taskNum] ON [dbo].[Dt_Task] ( [TaskNum] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO ALTER TABLE [dbo].[Dt_InboundOrder_Hty] ADD DEFAULT ('0') FOR [SourceId] GO ALTER TABLE [dbo].[Dt_InboundOrderDetail] ADD DEFAULT ('0') FOR [ReceiptQuantity] GO ALTER TABLE [dbo].[Dt_InboundOrderDetail] ADD DEFAULT ('0') FOR [OverInQuantity] GO ALTER TABLE [dbo].[Dt_InboundOrderDetail_Hty] ADD DEFAULT ('0') FOR [SourceId] GO ALTER TABLE [dbo].[Dt_InboundOrderDetail_Hty] ADD DEFAULT ('0') FOR [ReceiptQuantity] GO ALTER TABLE [dbo].[Dt_InboundOrderDetail_Hty] ADD DEFAULT ('0') FOR [OverInQuantity] GO ALTER TABLE [dbo].[Dt_LocationInfo] ADD DEFAULT ('0') FOR [LocationStatus] GO ALTER TABLE [dbo].[Dt_LocationInfo] ADD DEFAULT ('0') FOR [EnableStatus] GO ALTER TABLE [dbo].[Dt_MesOutboundOrder] ADD DEFAULT ('0') FOR [LockQuantity] GO ALTER TABLE [dbo].[Dt_MesOutboundOrder] ADD DEFAULT ('0') FOR [OverOutQuantity] GO ALTER TABLE [dbo].[Dt_MesPPBackInboundOrderDetail] ADD DEFAULT ('0') FOR [ReceiptQuantity] GO ALTER TABLE [dbo].[Dt_MesPPBackInboundOrderDetail] ADD DEFAULT ('0') FOR [OverInQuantity] GO ALTER TABLE [dbo].[Dt_MesPPCutOutboundOrderDetail] ADD DEFAULT ('0') FOR [LockQuantity] GO ALTER TABLE [dbo].[Dt_MesPPCutOutboundOrderDetail] ADD DEFAULT ('0') FOR [OverOutQuantity] GO ALTER TABLE [dbo].[Dt_MesPPOutboundOrder] ADD DEFAULT ('0') FOR [LockQuantity] GO ALTER TABLE [dbo].[Dt_MesPPOutboundOrder] ADD DEFAULT ('0') FOR [OverOutQuantity] GO ALTER TABLE [dbo].[Dt_MesRworkOutboundOrder] ADD DEFAULT ('0') FOR [LockQuantity] GO ALTER TABLE [dbo].[Dt_MesRworkOutboundOrder] ADD DEFAULT ('0') FOR [OverOutQuantity] GO ALTER TABLE [dbo].[Dt_MesRworkOutboundOrder] ADD DEFAULT ('0') FOR [RequiredQuantity] GO ALTER TABLE [dbo].[Dt_OutboundOrder_Hty] ADD DEFAULT ('0') FOR [SourceId] GO ALTER TABLE [dbo].[Dt_OutboundOrderDetail] ADD DEFAULT ('0') FOR [LockQuantity] GO ALTER TABLE [dbo].[Dt_OutboundOrderDetail] ADD DEFAULT ('0') FOR [OverOutQuantity] GO ALTER TABLE [dbo].[Dt_OutboundOrderDetail_Hty] ADD DEFAULT ('0') FOR [SourceId] GO ALTER TABLE [dbo].[Dt_ProStockInfo_Hty] ADD DEFAULT ('0') FOR [SourceId] GO ALTER TABLE [dbo].[Dt_ProStockInfoDetail_Hty] ADD DEFAULT ('0') FOR [SourceId] GO ALTER TABLE [dbo].[Dt_StockInfo_Hty] ADD DEFAULT ('0') FOR [SourceId] GO ALTER TABLE [dbo].[Dt_StockInfoDetail] ADD DEFAULT ('0') FOR [OutboundQuantity] GO ALTER TABLE [dbo].[Dt_StockInfoDetail_Hty] ADD DEFAULT ('0') FOR [SourceId] GO ALTER TABLE [dbo].[Dt_StockInfoDetail_Hty] ADD DEFAULT ('0') FOR [OutboundQuantity] GO ALTER TABLE [dbo].[Dt_StockQuantityChangeRecord] ADD DEFAULT ('0') FOR [BeforeQuantity] GO ALTER TABLE [dbo].[Dt_StockQuantityChangeRecord] ADD DEFAULT ('0') FOR [AfterQuantity] GO ALTER TABLE [dbo].[Dt_Task_Hty] ADD DEFAULT ('0') FOR [SourceId] GO ALTER TABLE [dbo].[Dt_Warehouse] ADD DEFAULT ('0') FOR [WarehouseStatus] GO ALTER TABLE [dbo].[Sys_User] ADD DEFAULT ('0') FOR [TenantId] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AnalysisRuleConfig', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ĉR÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AnalysisRuleConfig', @level2type=N'COLUMN',@level2name=N'AnalysisCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ĉR Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AnalysisRuleConfig', @level2type=N'COLUMN',@level2name=N'AnalysisName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'MRW[&{2N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AnalysisRuleConfig', @level2type=N'COLUMN',@level2name=N'StartStr' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ó~_gW[&{2N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AnalysisRuleConfig', @level2type=N'COLUMN',@level2name=N'EndStr' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'RrRW[&{2N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AnalysisRuleConfig', @level2type=N'COLUMN',@level2name=N'SplitStr' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'xĉR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AnalysisRuleConfig', @level2type=N'COLUMN',@level2name=N'Format' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AnalysisRuleConfig', @level2type=N'COLUMN',@level2name=N'Remark' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AnalysisRuleConfig', @level2type=N'COLUMN',@level2name=N'Creater' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AnalysisRuleConfig', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AnalysisRuleConfig', @level2type=N'COLUMN',@level2name=N'Modifier' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AnalysisRuleConfig', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'x㉐gĉRM‘n' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_AnalysisRuleConfig' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApiInfo', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¥cãS÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApiInfo', @level2type=N'COLUMN',@level2name=N'ApiCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¥cãS Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApiInfo', @level2type=N'COLUMN',@level2name=N'ApiName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¥cãS0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApiInfo', @level2type=N'COLUMN',@level2name=N'ApiAddress' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApiInfo', @level2type=N'COLUMN',@level2name=N'Remark' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApiInfo', @level2type=N'COLUMN',@level2name=N'Creater' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApiInfo', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApiInfo', @level2type=N'COLUMN',@level2name=N'Modifier' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApiInfo', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¥cãSáOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApiInfo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalFlow', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[ybAm z÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalFlow', @level2type=N'COLUMN',@level2name=N'FlowCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[ybAm z Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalFlow', @level2type=N'COLUMN',@level2name=N'FlowName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[ybAm zÏcð' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalFlow', @level2type=N'COLUMN',@level2name=N'FlowDes' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalFlow', @level2type=N'COLUMN',@level2name=N'Creater' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalFlow', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalFlow', @level2type=N'COLUMN',@level2name=N'Modifier' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalFlow', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[ybAm zhˆ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalFlow' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalNode', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[ybAm z÷S ÿY.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalNode', @level2type=N'COLUMN',@level2name=N'FlowId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[yb‚‚¹p Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalNode', @level2type=N'COLUMN',@level2name=N'NodeName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'‚‚¹p{|‹Wÿ‚YUSºN¡[yb0YºN¡[yb0O~{I{ ÿ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalNode', @level2type=N'COLUMN',@level2name=N'NodeType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[ybºN҉r‚ÿ‚Yèè•Ï~t0;`Ï~tI{ ÿ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalNode', @level2type=N'COLUMN',@level2name=N'ApproverRole' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'‚‚¹pz˜^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalNode', @level2type=N'COLUMN',@level2name=N'NodeSequence' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalNode', @level2type=N'COLUMN',@level2name=N'Creater' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalNode', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalNode', @level2type=N'COLUMN',@level2name=N'Modifier' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalNode', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[yb‚‚¹phˆ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalNode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[ybûN¡R÷S ÿ;N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalTask', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[ybAm z÷S ÿY.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalTask', @level2type=N'COLUMN',@level2name=N'FlowId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[yb‚‚¹p÷S ÿY.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalTask', @level2type=N'COLUMN',@level2name=N'NodeId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'3u÷‹ºN(u7b÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalTask', @level2type=N'COLUMN',@level2name=N'ApplicantUserId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'3u÷‹ºN(u7b Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalTask', @level2type=N'COLUMN',@level2name=N'ApplicantUserName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R¶r`ÿ‚Y…_¡[yb0ò]¡[yb0ò]sšÞVI{ ÿ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalTask', @level2type=N'COLUMN',@level2name=N'Status' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[ybaÁ‰…Q¹[' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalTask', @level2type=N'COLUMN',@level2name=N'OpinionContent' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[ybºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalTask', @level2type=N'COLUMN',@level2name=N'AuditUser' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'egn;N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalTask', @level2type=N'COLUMN',@level2name=N'SourceKey' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalTask', @level2type=N'COLUMN',@level2name=N'Creater' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalTask', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalTask', @level2type=N'COLUMN',@level2name=N'Modifier' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalTask', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[ybûN¡Rhˆ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApprovalTask' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_CheckOrder', @level2type=N'COLUMN',@level2name=N'CheckOrderId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN“^;N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_CheckOrder', @level2type=N'COLUMN',@level2name=N'WarehouseId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÀhŒšUS÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_CheckOrder', @level2type=N'COLUMN',@level2name=N'CheckOrderNo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'US÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_CheckOrder', @level2type=N'COLUMN',@level2name=N'ReceiveOrderNo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(ÀhUS¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_CheckOrder', @level2type=N'COLUMN',@level2name=N'CheckOrderStatus' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[yb¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_CheckOrder', @level2type=N'COLUMN',@level2name=N'AuditStatus' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'USfÆ~Lˆ÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_CheckOrder', @level2type=N'COLUMN',@level2name=N'ReceiveDetailRowNo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ir™e÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_CheckOrder', @level2type=N'COLUMN',@level2name=N'MaterielCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'yb!k÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_CheckOrder', @level2type=N'COLUMN',@level2name=N'LotNo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'TeGYpeR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PalletTypeInfo', @level2type=N'COLUMN',@level2name=N'IsOdd' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XbØv{|‹W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PalletTypeInfo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrder', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN“^;N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrder', @level2type=N'COLUMN',@level2name=N'WarehouseId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQ“^US÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrder', @level2type=N'COLUMN',@level2name=N'ProOutOrderNo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¢‹US{|‹W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrder', @level2type=N'COLUMN',@level2name=N'ProOrderType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¢‹US¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrder', @level2type=N'COLUMN',@level2name=N'ProOrderStatus' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡‹RúQ'öeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrder', @level2type=N'COLUMN',@level2name=N'PlantShipDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrder', @level2type=N'COLUMN',@level2name=N'Remark' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrder', @level2type=N'COLUMN',@level2name=N'Creater' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrder', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrder', @level2type=N'COLUMN',@level2name=N'Modifier' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrder', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'bÁTúQ“^US' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQ“^US;N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'ProOrderId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQ“^USLˆ÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'RowId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQ“^USfÆ~¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'ProOrderDetailStatus' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'•.U¢‹US÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'SaleOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¢[7b' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'Customer' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'å]‚S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'FactoryCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'§NÁTx' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'PCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'§NÁTHr,g' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'PVer' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'§NÁTyb!k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'PLot' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'§NÁThTg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'DateCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQ“^TmHr,g' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'OutSpecifyVer' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'Creater' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'Modifier' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'È~ïz¢[7b' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail', @level2type=N'COLUMN',@level2name=N'EndCustomer' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'bÁTúQ“^fÆ~US' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProOutOrderDetail' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProSpecifyVerOrder', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN“^;N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProSpecifyVerOrder', @level2type=N'COLUMN',@level2name=N'WarehouseId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'•.U¢‹US÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProSpecifyVerOrder', @level2type=N'COLUMN',@level2name=N'ProSaleOrderNo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'fÆ~Lˆ÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProSpecifyVerOrder', @level2type=N'COLUMN',@level2name=N'RowId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'§NÁTx' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProSpecifyVerOrder', @level2type=N'COLUMN',@level2name=N'PCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'§NÁTHr,g' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProSpecifyVerOrder', @level2type=N'COLUMN',@level2name=N'PVer' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'§NÁTyb!k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProSpecifyVerOrder', @level2type=N'COLUMN',@level2name=N'PLot' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'§NÁThTg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProSpecifyVerOrder', @level2type=N'COLUMN',@level2name=N'DateCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'TmHr,g÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProSpecifyVerOrder', @level2type=N'COLUMN',@level2name=N'Ver' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProSpecifyVerOrder', @level2type=N'COLUMN',@level2name=N'Remark' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProSpecifyVerOrder', @level2type=N'COLUMN',@level2name=N'Creater' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProSpecifyVerOrder', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProSpecifyVerOrder', @level2type=N'COLUMN',@level2name=N'Modifier' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProSpecifyVerOrder', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'bÁT•.Uc>mUS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProSpecifyVerOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ö€Fh÷S/Y±{÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo', @level2type=N'COLUMN',@level2name=N'PalletCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'“^X[^\'`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo', @level2type=N'COLUMN',@level2name=N'ProStockAttribute' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ö€Fh{|‹W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo', @level2type=N'COLUMN',@level2name=N'PalletType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N''MO÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo', @level2type=N'COLUMN',@level2name=N'LocationCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQ'US÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo', @level2type=N'COLUMN',@level2name=N'ShipmentOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN“^;N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo', @level2type=N'COLUMN',@level2name=N'WarehouseId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'“^X[¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo', @level2type=N'COLUMN',@level2name=N'StockStatus' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo', @level2type=N'COLUMN',@level2name=N'Remark' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo', @level2type=N'COLUMN',@level2name=N'Creater' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo', @level2type=N'COLUMN',@level2name=N'Modifier' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'bÁT“^X[áOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ŸShˆ;N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty', @level2type=N'COLUMN',@level2name=N'SourceId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Íd\O{|‹W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty', @level2type=N'COLUMN',@level2name=N'OperateType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûyeQ†SòSöeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty', @level2type=N'COLUMN',@level2name=N'InsertTime' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ö€Fh÷S/Y±{÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty', @level2type=N'COLUMN',@level2name=N'PalletCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'“^X[^\'`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty', @level2type=N'COLUMN',@level2name=N'ProStockAttribute' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ö€Fh{|‹W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty', @level2type=N'COLUMN',@level2name=N'PalletType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N''MO÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty', @level2type=N'COLUMN',@level2name=N'LocationCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQ'US÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty', @level2type=N'COLUMN',@level2name=N'ShipmentOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN“^;N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty', @level2type=N'COLUMN',@level2name=N'WarehouseId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'“^X[¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty', @level2type=N'COLUMN',@level2name=N'StockStatus' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty', @level2type=N'COLUMN',@level2name=N'Remark' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty', @level2type=N'COLUMN',@level2name=N'Creater' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty', @level2type=N'COLUMN',@level2name=N'Modifier' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'bÁT“^X[†SòSáOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfo_Hty' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'bÁT“^X[;N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'ProStockId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'…QS÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'BagNo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'§NÁTx' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'ProductCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQ“^peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'OutboundQuantity' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQ“^SETpeϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'OutSETQty' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'bÁT“^X[fÆ~¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'ProOutDetailStatus' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Hr,g' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'ProductVersion' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SňSETpeϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'SETQty' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'“^X[TmHr,g' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'SpecifyVer' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'Remark' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'Creater' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'Modifier' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQ“^fÆ~ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'OutDetailId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQ“^fÆ~¢‹US÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail', @level2type=N'COLUMN',@level2name=N'OutDetailSaleNo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'bÁT“^X[áOo`fÆ~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ŸShˆ;N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'SourceId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Íd\O{|‹W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'OperateType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûyeQ†SòSöeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'InsertTime' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'bÁT“^X[;N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'ProStockId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'…QS÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'BagNo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'§NÁTx' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'ProductCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQ“^peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'OutboundQuantity' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQ“^SETpeϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'OutSETQty' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'bÁT“^X[fÆ~¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'ProOutDetailStatus' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Hr,g' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'ProductVersion' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SňSETpeϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'SETQty' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'“^X[TmHr,g' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'SpecifyVer' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'Remark' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'Creater' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'Modifier' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'bÁT“^X[†SòSáOo`fÆ~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ProStockInfoDetail_Hty' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrder', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-US÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrder', @level2type=N'COLUMN',@level2name=N'PurchaseOrderNo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USnc{|‹W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrder', @level2type=N'COLUMN',@level2name=N'PurchaseOrderType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'›O”^FU÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrder', @level2type=N'COLUMN',@level2name=N'SupplierCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrder', @level2type=N'COLUMN',@level2name=N'OrderQuantity' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-US¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrder', @level2type=N'COLUMN',@level2name=N'PurchaseOrderStatus' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N' NUSåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrder', @level2type=N'COLUMN',@level2name=N'OrderDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrder', @level2type=N'COLUMN',@level2name=N'Remark' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrder', @level2type=N'COLUMN',@level2name=N'Creater' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrder', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrder', @level2type=N'COLUMN',@level2name=N'Modifier' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrder', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-US' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrder' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrderDetail', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'4Yhˆ;N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrderDetail', @level2type=N'COLUMN',@level2name=N'PurchaseOrderId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Lˆ÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrderDetail', @level2type=N'COLUMN',@level2name=N'RowNo' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ir™e÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrderDetail', @level2type=N'COLUMN',@level2name=N'MaterielCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-USfÆ~¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrderDetail', @level2type=N'COLUMN',@level2name=N'PurchaseDetailStatus' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN“^÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrderDetail', @level2type=N'COLUMN',@level2name=N'WarehouseId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrderDetail', @level2type=N'COLUMN',@level2name=N'PurchaseDetailQuantity' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ò]6e'peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrderDetail', @level2type=N'COLUMN',@level2name=N'PurchaseDetailReceiveQty' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USMO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrderDetail', @level2type=N'COLUMN',@level2name=N'Unit' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrderDetail', @level2type=N'COLUMN',@level2name=N'Creater' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrderDetail', @level2type=N'COLUMN',@level2name=N'CreateDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrderDetail', @level2type=N'COLUMN',@level2name=N'Modifier' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrderDetail', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ir™e Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_PurchaseOrderDetail', @level2type=N'COLUMN',@level2name=N'MaterielName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ir™eĉ