You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

2311 lines
274 KiB

1 year ago
USE [master]
GO
/****** Object: Database [SCP] Script Date: 2018-05-02 20:47:12 ******/
CREATE DATABASE [SCP] ON PRIMARY
( NAME = N'ChangKeTecSCP', FILENAME = N'C:\SqlData\SCP.mdf' , SIZE = 73728KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
LOG ON
( NAME = N'ChangKeTecSCP_log', FILENAME = N'C:\SqlData\SCP_0.ldf' , SIZE = 73728KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
GO
ALTER DATABASE [SCP] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [SCP].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [SCP] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [SCP] SET ANSI_NULLS OFF
GO
ALTER DATABASE [SCP] SET ANSI_PADDING OFF
GO
ALTER DATABASE [SCP] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [SCP] SET ARITHABORT OFF
GO
ALTER DATABASE [SCP] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [SCP] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [SCP] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [SCP] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [SCP] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [SCP] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [SCP] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [SCP] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [SCP] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [SCP] SET DISABLE_BROKER
GO
ALTER DATABASE [SCP] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [SCP] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [SCP] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [SCP] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [SCP] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [SCP] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [SCP] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [SCP] SET RECOVERY FULL
GO
ALTER DATABASE [SCP] SET MULTI_USER
GO
ALTER DATABASE [SCP] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [SCP] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'SCP', N'ON'
GO
USE [SCP]
GO
/****** Object: Table [dbo].[__MigrationHistory] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[__MigrationHistory](
[MigrationId] [nvarchar](150) NOT NULL,
[nvarchar(150)] [nvarchar](300) NOT NULL,
[Model] [varbinary](max) NOT NULL,
[ProductVersion] [nvarchar](32) NOT NULL,
CONSTRAINT [PK___MigrationHistory] PRIMARY KEY CLUSTERED
(
[MigrationId] ASC,
[nvarchar(150)] 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].[ERP_ORDER] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ERP_ORDER](
[UID] [int] NOT NULL,
[ErpBillNum] [nvarchar](50) NOT NULL,
[VendId] [nvarchar](50) NULL,
[ModType] [nvarchar](50) NULL,
[Contacter] [nvarchar](50) NULL,
[Site] [nvarchar](50) NULL,
[Buyer] [nvarchar](50) NULL,
[BuyerPhone] [nvarchar](50) NULL,
[Address] [nvarchar](200) NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](500) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[GUID] [uniqueidentifier] ROWGUIDCOL NOT NULL,
CONSTRAINT [PK_TB_QadOrder] PRIMARY KEY CLUSTERED
(
[UID] 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].[ERP_ORDER_DETAIL] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ERP_ORDER_DETAIL](
[UID] [int] NOT NULL,
[ErpBillNum] [nvarchar](50) NOT NULL,
[PoLine] [int] NOT NULL,
[PartCode] [nvarchar](50) NOT NULL,
[PartPrice] [money] NOT NULL,
[BeginTime] [datetime2](3) NULL,
[EndTime] [datetime2](3) NULL,
[PlanQty] [money] NOT NULL,
[ClosedQty] [money] NOT NULL,
[DockCode] [nvarchar](50) NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](500) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[GUID] [uniqueidentifier] ROWGUIDCOL NOT NULL,
CONSTRAINT [PK_ERP_ORDER_DETAIL] PRIMARY KEY CLUSTERED
(
[UID] 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].[TA_BILLTYPE] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TA_BILLTYPE](
[UID] [int] IDENTITY(1,1) NOT NULL,
[BillType] [int] NOT NULL,
[TypeName] [nvarchar](50) NOT NULL,
[TypeDesc] [nvarchar](50) NOT NULL,
[State] [int] NOT NULL,
[Prefix] [nvarchar](50) NOT NULL,
[BillNumRule] [nvarchar](500) NOT NULL,
[LastNumber] [int] NOT NULL,
[LastBillNum] [nvarchar](50) NULL,
[LastBillTime] [datetime] NOT NULL,
[PrintTemplateFileName] [nvarchar](500) NULL,
[ImportTemplateFileName] [nvarchar](500) NULL,
[Sep] [varchar](50) NULL,
[PaperOrientation] [int] NOT NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] ROWGUIDCOL NOT NULL,
CONSTRAINT [PK_TA_BILLTYPE] PRIMARY KEY CLUSTERED
(
[BillType] 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].[TA_CONFIG] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TA_CONFIG](
[UID] [int] IDENTITY(1,1) NOT NULL,
[ParamName] [nvarchar](50) NOT NULL,
[ParamValue] [nvarchar](50) NOT NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](500) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] ROWGUIDCOL NOT NULL,
CONSTRAINT [PK_SYS_CONFIG] PRIMARY KEY CLUSTERED
(
[ParamName] 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].[TA_FACTORY] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TA_FACTORY](
[UID] [int] NOT NULL,
[FactoryId] [nvarchar](50) NOT NULL,
[FactoryName] [nvarchar](255) NULL,
[ErpSite] [nvarchar](50) NOT NULL,
[ErpDomain] [nvarchar](50) NOT NULL,
[Address] [nvarchar](255) NULL,
[ZipCode] [nvarchar](255) NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](255) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] ROWGUIDCOL NOT NULL,
CONSTRAINT [PK_TA_Factory] PRIMARY KEY CLUSTERED
(
[FactoryId] 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].[TA_PART] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TA_PART](
[UID] [bigint] IDENTITY(1,1) NOT NULL,
[PartCode] [nvarchar](50) NOT NULL,
[ErpPartCode] [nvarchar](50) NULL,
[PartDesc1] [nvarchar](max) NOT NULL,
[PartDesc2] [nvarchar](max) NULL,
[ProjectId] [nvarchar](50) NOT NULL,
[Unit] [nvarchar](50) NOT NULL,
[PartGroup] [nvarchar](50) NULL,
[State] [varchar](10) NULL,
[Configuration] [nvarchar](100) NULL,
[ValidityDays] [int] NOT NULL,
[ReceivePort] [nvarchar](50) NULL,
[PalletSize] [nvarchar](50) NULL,
[Remark] [nvarchar](500) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] ROWGUIDCOL NOT NULL,
CONSTRAINT [PK_TA_PART] PRIMARY KEY CLUSTERED
(
[PartCode] 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].[TA_VEND_PART] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TA_VEND_PART](
[UID] [bigint] IDENTITY(1,1) NOT NULL,
[VendId] [nvarchar](50) NOT NULL,
[PartCode] [nvarchar](50) NOT NULL,
[VendPartCode] [nvarchar](50) NOT NULL,
[VendPackQty] [decimal](18, 5) NOT NULL,
[PoUnit] [nvarchar](50) NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](500) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] ROWGUIDCOL NOT NULL,
CONSTRAINT [PK_TA_VEND_PART] PRIMARY KEY CLUSTERED
(
[VendId] ASC,
[PartCode] ASC,
[VendPartCode] 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].[TA_VENDER] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TA_VENDER](
[UID] [int] IDENTITY(1,1) NOT NULL,
[VendId] [nvarchar](50) NOT NULL,
[VendName] [nvarchar](50) NOT NULL,
[VendAbbCode] [varchar](2) NULL,
[VendType] [nvarchar](50) NULL,
[Country] [nvarchar](50) NULL,
[City] [nvarchar](50) NULL,
[Currency] [nvarchar](50) NULL,
[Address] [nvarchar](200) NULL,
[ZipCode] [nvarchar](50) NULL,
[Contacter] [nvarchar](50) NULL,
[Phone] [nvarchar](50) NULL,
[Fax] [nvarchar](50) NULL,
[Email] [nvarchar](50) NULL,
[State] [int] NULL,
[Remark] [nvarchar](500) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] ROWGUIDCOL NOT NULL,
CONSTRAINT [PK23] PRIMARY KEY NONCLUSTERED
(
[VendId] 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].[TB_ASK] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_ASK](
[UID] [int] NOT NULL,
[AskBillNum] [nvarchar](50) NOT NULL,
[PoBillNum] [nvarchar](50) NOT NULL,
[VendId] [nvarchar](50) NOT NULL,
[Site] [nvarchar](50) NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](500) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_TB_ASK] PRIMARY KEY CLUSTERED
(
[AskBillNum] 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].[TB_ASK_DETAIL] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_ASK_DETAIL](
[UID] [int] NOT NULL,
[AskBillNum] [nvarchar](50) NOT NULL,
[PoBillNum] [nvarchar](50) NOT NULL,
[PoLine] [int] NOT NULL,
[PartCode] [nvarchar](50) NOT NULL,
[AskQty] [money] NOT NULL,
[ShippedQty] [money] NOT NULL,
[ReceivedQty] [money] NOT NULL,
[BeginTime] [datetime2](3) NULL,
[EndTime] [datetime2](3) NULL,
[PoUnit] [nvarchar](50) NULL,
[LocUnit] [nvarchar](50) NULL,
[PackQty] [money] NOT NULL,
[UnConv] [money] NOT NULL,
[DockCode] [nvarchar](50) NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](200) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_Table_1] PRIMARY KEY CLUSTERED
(
[AskBillNum] ASC,
[PoLine] 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].[TB_ASN] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_ASN](
[UID] [int] IDENTITY(1,1) NOT NULL,
[AsnBillNum] [nvarchar](50) NOT NULL,
[AskBillNum] [nvarchar](50) NOT NULL,
[PoBillNum] [nvarchar](50) NULL,
[VendId] [nvarchar](50) NOT NULL,
[Site] [nvarchar](50) NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](50) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[ShipTime] [datetime2](3) NULL,
[ShipUser] [nvarchar](50) NULL,
[ReceiveTime] [datetime2](3) NULL,
[ReceiveUser] [nvarchar](50) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK7_1_1] PRIMARY KEY NONCLUSTERED
(
[AsnBillNum] 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].[TB_ASN_DETAIL] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_ASN_DETAIL](
[UID] [int] IDENTITY(1,1) NOT NULL,
[AsnBillNum] [nvarchar](50) NOT NULL,
[PoBillNum] [nvarchar](50) NULL,
[PoLine] [int] NOT NULL,
[PartCode] [nvarchar](50) NOT NULL,
[Batch] [nvarchar](50) NOT NULL,
[ProduceDate] [date] NULL,
[VendBatch] [nvarchar](50) NULL,
[Qty] [money] NOT NULL,
[PoUnit] [nvarchar](50) NULL,
[LocUnit] [nvarchar](50) NULL,
[PackQty] [money] NOT NULL,
[UnConv] [money] NOT NULL,
[DockCode] [nvarchar](50) NULL,
[State] [int] NULL,
[Remark] [nvarchar](50) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_TF_ASN_DETAIL_1] PRIMARY KEY CLUSTERED
(
[AsnBillNum] ASC,
[PoLine] ASC,
[PartCode] ASC,
[Batch] 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].[TB_INVOICE] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_INVOICE](
[UID] [int] IDENTITY(1,1) NOT NULL,
[InvcBillNum] [nvarchar](200) NOT NULL,
[Site] [nvarchar](50) NULL,
[InvoiceNum] [nvarchar](50) NULL,
[ExpressNum] [nvarchar](50) NULL,
[VendId] [nvarchar](50) NOT NULL,
[Tax] [decimal](18, 2) NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](50) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_TB_INVOICE] PRIMARY KEY CLUSTERED
(
[InvcBillNum] 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].[TB_INVOICE_DETAIL] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_INVOICE_DETAIL](
[UID] [int] IDENTITY(1,1) NOT NULL,
[InvcBillNum] [nvarchar](50) NOT NULL,
[RecvBillNum] [nvarchar](50) NULL,
[AsnBillNum] [nvarchar](50) NULL,
[PoBillNum] [nvarchar](50) NOT NULL,
[PoLineNum] [int] NOT NULL,
[PartCode] [nvarchar](50) NOT NULL,
[Batch] [nvarchar](50) NOT NULL,
[ProduceDate] [date] NULL,
[VendBatch] [nvarchar](50) NULL,
[Qty] [decimal](18, 5) NOT NULL,
[PoUnit] [nvarchar](50) NULL,
[Price] [decimal](18, 5) NOT NULL,
[Currency] [nvarchar](50) NULL,
[PackQty] [decimal](18, 5) NULL,
[State] [int] NULL,
[Remark] [nvarchar](500) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_TB_INVOICE_DETAIL] PRIMARY KEY CLUSTERED
(
[UID] 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].[TB_PLAN] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_PLAN](
[UID] [int] IDENTITY(1,1) NOT NULL,
[PlanId] [nvarchar](50) NOT NULL,
[PlanName] [nvarchar](250) NULL,
[ErpPlanId] [nvarchar](50) NOT NULL,
[Version] [nvarchar](50) NOT NULL,
[VendId] [nvarchar](50) NOT NULL,
[Site] [nvarchar](50) NOT NULL,
[PlanType] [int] NOT NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](500) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_TS_LONGTERM_PLAN] PRIMARY KEY CLUSTERED
(
[PlanId] 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].[TB_PLAN_DETAIL] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_PLAN_DETAIL](
[UID] [int] NOT NULL,
[PlanId] [nvarchar](50) NOT NULL,
[PlanPieriod] [nvarchar](50) NOT NULL,
[BeginDate] [date] NOT NULL,
[EndDate] [date] NOT NULL,
[PartCode] [nvarchar](50) NOT NULL,
[Qty] [money] NOT NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](500) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_TB_PLAN_DETAIL] PRIMARY KEY CLUSTERED
(
[PlanId] ASC,
[PlanPieriod] ASC,
[PartCode] 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].[TB_PO] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_PO](
[UID] [int] IDENTITY(1,1) NOT NULL,
[PoBillNum] [nvarchar](50) NOT NULL,
[ErpBillNum] [nvarchar](50) NULL,
[VendId] [nvarchar](50) NOT NULL,
[ModType] [int] NULL,
[Contacter] [nvarchar](50) NULL,
[Site] [nvarchar](50) NULL,
[Buyer] [nvarchar](50) NULL,
[BuyerPhone] [nvarchar](50) NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](500) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK7_1] PRIMARY KEY NONCLUSTERED
(
[PoBillNum] 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].[TB_PO_DETAIL] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_PO_DETAIL](
[UID] [int] IDENTITY(1,1) NOT NULL,
[PoBillNum] [nvarchar](50) NOT NULL,
[PoLine] [int] NOT NULL,
[PartCode] [nvarchar](50) NOT NULL,
[PlanQty] [money] NOT NULL,
[ShippedQty] [money] NOT NULL,
[ReceivedQty] [money] NOT NULL,
[RejectQty] [nvarchar](50) NULL,
[BeginTime] [datetime2](3) NULL,
[EndTime] [datetime2](3) NULL,
[PoUnit] [nvarchar](50) NULL,
[LocUnit] [nvarchar](50) NULL,
[Price] [money] NOT NULL,
[Currency] [nvarchar](50) NULL,
[PackQty] [money] NOT NULL,
[UnConv] [money] NOT NULL,
[DockCode] [nvarchar](50) NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](200) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_TF_PO_DETAIL_1] PRIMARY KEY CLUSTERED
(
[PoBillNum] ASC,
[PoLine] 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].[TB_RECEIVE] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_RECEIVE](
[UID] [int] IDENTITY(1,1) NOT NULL,
[RecvBillNum] [nvarchar](50) NOT NULL,
[PoBillNum] [nvarchar](50) NOT NULL,
[AsnBillNum] [nvarchar](50) NULL,
[Site] [nvarchar](50) NULL,
[VendId] [nvarchar](50) NOT NULL,
[ShipTime] [datetime2](3) NOT NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](50) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_TB_RECEIVE] PRIMARY KEY CLUSTERED
(
[RecvBillNum] 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].[TB_RECEIVE_DETAIL] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_RECEIVE_DETAIL](
[UID] [int] IDENTITY(1,1) NOT NULL,
[RecvBillNum] [nvarchar](50) NOT NULL,
[PoBIllNum] [nvarchar](50) NOT NULL,
[PoLine] [int] NOT NULL,
[PartCode] [nvarchar](50) NOT NULL,
[Batch] [nvarchar](50) NOT NULL,
[Qty] [money] NOT NULL,
[DockCode] [nvarchar](50) NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](500) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_TB_RECEIVE_DETAIL] PRIMARY KEY CLUSTERED
(
[RecvBillNum] ASC,
[PoBIllNum] ASC,
[PoLine] 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].[TB_REJECT] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_REJECT](
[UID] [int] IDENTITY(1,1) NOT NULL,
[RjctBillNum] [nvarchar](50) NOT NULL,
[PoBillNum] [nvarchar](50) NOT NULL,
[AsnBillNum] [nvarchar](50) NULL,
[Site] [nvarchar](50) NULL,
[VendId] [nvarchar](50) NOT NULL,
[ShipTime] [datetime2](7) NOT NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](50) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_TB_RETURN] PRIMARY KEY CLUSTERED
(
[RjctBillNum] 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].[TB_REJECT_DETAIL] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TB_REJECT_DETAIL](
[UID] [int] IDENTITY(1,1) NOT NULL,
[RjctBillNum] [nvarchar](50) NOT NULL,
[PoBillNum] [nvarchar](50) NOT NULL,
[PoLine] [int] NOT NULL,
[PartCode] [nvarchar](50) NOT NULL,
[Batch] [nvarchar](50) NOT NULL,
[Qty] [money] NOT NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](500) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_TB_REJECT_DETAIL] PRIMARY KEY CLUSTERED
(
[RjctBillNum] ASC,
[PoBillNum] ASC,
[PoLine] 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].[TL_BASEDATA] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TL_BASEDATA](
[UID] [bigint] IDENTITY(1,1) NOT NULL,
[UserName] [nvarchar](80) NOT NULL,
[LogTime] [datetime] NOT NULL,
[LogType] [varchar](50) NOT NULL,
[DataType] [varchar](50) NOT NULL,
[OldValue] [nvarchar](4000) NOT NULL,
[NewValue] [nvarchar](4000) NOT NULL,
[Remark] [nvarchar](500) NULL,
CONSTRAINT [PK_TL_BASEDATA] PRIMARY KEY CLUSTERED
(
[UID] 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].[TL_BILL] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TL_BILL](
[UID] [bigint] IDENTITY(1,1) NOT NULL,
[UserName] [nvarchar](80) NOT NULL,
[LogTime] [datetime] NOT NULL,
[LogType] [nvarchar](50) NOT NULL,
[BillNum] [nvarchar](50) NOT NULL,
[BillType] [int] NOT NULL,
[Message] [nvarchar](max) NULL,
CONSTRAINT [PK_TL_BILL] PRIMARY KEY CLUSTERED
(
[UID] 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].[TL_USER] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TL_USER](
[UID] [bigint] IDENTITY(1,1) NOT NULL,
[UserId] [nvarchar](80) NOT NULL,
[UserName] [nvarchar](50) NOT NULL,
[LogTime] [datetime] NOT NULL,
[LogType] [varchar](50) NOT NULL,
[LogSite] [nvarchar](200) NOT NULL,
[Message] [nvarchar](max) NULL,
CONSTRAINT [PK_TL_LOG] PRIMARY KEY CLUSTERED
(
[UID] 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].[TS_BARCODE] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TS_BARCODE](
[UID] [bigint] IDENTITY(1,1) NOT NULL,
[BarCode] [varchar](50) NOT NULL,
[FullBarCode] [varchar](500) NOT NULL,
[PartCode] [varchar](50) NOT NULL,
[VendPartCode] [varchar](50) NULL,
[Batch] [varchar](50) NOT NULL,
[ProduceDate] [datetime2](3) NOT NULL,
[ManageType] [int] NOT NULL,
[SerialNum] [varchar](50) NOT NULL,
[Qty] [money] NOT NULL,
[BarCodeType] [int] NOT NULL,
[BillNum] [varchar](50) NOT NULL,
[BillLine] [int] NOT NULL,
[VendId] [varchar](50) NULL,
[VendBatch] [nvarchar](50) NULL,
[PackQty] [money] NOT NULL,
[CreateOper] [nvarchar](50) NOT NULL,
[CreateTime] [datetime] NOT NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](500) NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_TS_BARCODE] PRIMARY KEY CLUSTERED
(
[BarCode] 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].[TS_INFO] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TS_INFO](
[UID] [int] IDENTITY(1,1) NOT NULL,
[VendId] [nvarchar](50) NULL,
[Site] [nvarchar](50) NOT NULL,
[InfoType] [int] NULL,
[Title] [nvarchar](50) NULL,
[Infomation] [text] NULL,
[FileName] [nvarchar](500) NULL,
[state] [int] NULL,
[Remark] [nvarchar](50) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTIme] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NULL,
[GUID] [uniqueidentifier] ROWGUIDCOL NOT NULL,
CONSTRAINT [PK_TA_Info] PRIMARY KEY CLUSTERED
(
[UID] 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].[TS_STOCK] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TS_STOCK](
[UID] [bigint] IDENTITY(1,1) NOT NULL,
[BarCode] [nvarchar](50) NOT NULL,
[LocCode] [nvarchar](50) NOT NULL,
[PartCode] [nvarchar](50) NOT NULL,
[Batch] [nvarchar](50) NOT NULL,
[State] [int] NOT NULL,
[Qty] [money] NOT NULL,
[VendId] [nvarchar](50) NULL,
[VendBatch] [nvarchar](50) NULL,
[ReceiveTime] [datetime2](3) NOT NULL,
[ProduceDate] [date] NOT NULL,
[Remark] [nvarchar](500) NULL,
CONSTRAINT [PK_TS_STOCK_DETAIL] PRIMARY KEY CLUSTERED
(
[BarCode] ASC,
[LocCode] ASC,
[State] 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].[TS_UNI_API] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TS_UNI_API](
[UID] [int] IDENTITY(1,1) NOT NULL,
[InterfaceType] [nvarchar](50) NOT NULL,
[TableName] [nvarchar](50) NULL,
[BillType] [int] NULL,
[SubBillType] [int] NULL,
[BillNum] [nvarchar](50) NOT NULL,
[PartCode] [nvarchar](50) NOT NULL,
[Batch] [nvarchar](50) NOT NULL,
[FromLoc] [nvarchar](50) NULL,
[ToLoc] [nvarchar](50) NULL,
[FromErpLoc] [varchar](8) NULL,
[ToErpLoc] [varchar](8) NULL,
[Qty] [decimal](18, 5) NOT NULL,
[State] [int] NOT NULL,
[PutTime] [datetime] NOT NULL,
[VendId] [nvarchar](50) NULL,
[PoUnit] [nvarchar](50) NULL,
[LocUnit] [nvarchar](50) NULL,
[ValidDate] [datetime] NOT NULL,
[ErpBillNum] [nvarchar](50) NULL,
[ErpLineNum] [int] NOT NULL,
[VendBatch] [nvarchar](50) NULL,
[SourceBillNum] [nvarchar](50) NULL,
[CreateUser] [nvarchar](50) NULL,
[CreateTime] [datetime] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_TS_UNI_INTERFACE] PRIMARY KEY CLUSTERED
(
[UID] 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].[TS_UNI_API_HIS] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TS_UNI_API_HIS](
[UID] [int] NOT NULL,
[InterfaceType] [nvarchar](50) NOT NULL,
[TableName] [nvarchar](50) NULL,
[BillType] [int] NULL,
[SubBillType] [int] NULL,
[BillNum] [nvarchar](50) NOT NULL,
[PartCode] [nvarchar](50) NOT NULL,
[Batch] [nvarchar](50) NOT NULL,
[FromLoc] [nvarchar](50) NULL,
[ToLoc] [nvarchar](50) NULL,
[FromErpLoc] [varchar](8) NULL,
[ToErpLoc] [varchar](8) NULL,
[Qty] [decimal](18, 5) NOT NULL,
[State] [int] NOT NULL,
[PutTime] [datetime] NOT NULL,
[VendId] [nvarchar](50) NULL,
[PoUnit] [nvarchar](50) NULL,
[LocUnit] [nvarchar](50) NULL,
[ValidDate] [datetime] NOT NULL,
[ErpBillNum] [nvarchar](50) NULL,
[ErpLineNum] [int] NOT NULL,
[VendBatch] [nvarchar](50) NULL,
[SourceBillNum] [nvarchar](50) NULL,
[CreateUser] [nvarchar](50) NULL,
[CreateTime] [datetime] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_TS_UNI_API_HIS_1] PRIMARY KEY CLUSTERED
(
[UID] 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].[TT_CURRENCY] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TT_CURRENCY](
[UID] [int] IDENTITY(1,1) NOT NULL,
[CurrencyId] [nvarchar](50) NOT NULL,
[CurrencyName] [nvarchar](50) NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](50) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_TA_CURRENCY] PRIMARY KEY CLUSTERED
(
[CurrencyId] 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].[TT_PROJECT] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TT_PROJECT](
[UID] [int] IDENTITY(1,1) NOT NULL,
[ProjectId] [nvarchar](50) NOT NULL,
[ProjectName] [nvarchar](50) NOT NULL,
[State] [int] NOT NULL,
[Remark] [nvarchar](50) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK_TT_PROJECT] PRIMARY KEY CLUSTERED
(
[ProjectId] 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].[TT_UNIT] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TT_UNIT](
[UID] [int] IDENTITY(1,1) NOT NULL,
[UnitId] [nvarchar](50) NOT NULL,
[UnitName] [nvarchar](50) NULL,
[State] [int] NOT NULL,
[Remak] [nvarchar](200) NULL,
[CreateTime] [datetime2](3) NOT NULL,
[CreateUser] [nvarchar](50) NOT NULL,
[UpdateTime] [datetime2](3) NULL,
[UpdateUser] [nvarchar](50) NULL,
[UpdateInfo] [nvarchar](500) NULL,
[IsDeleted] [bit] NOT NULL,
[GUID] [uniqueidentifier] NOT NULL,
CONSTRAINT [PK17] PRIMARY KEY NONCLUSTERED
(
[UnitId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ERP_ORDER] ADD CONSTRAINT [DF_ERP_ORDER_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[ERP_ORDER] ADD CONSTRAINT [DF_ERP_ORDER_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[ERP_ORDER] ADD CONSTRAINT [DF_ERP_ORDER_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[ERP_ORDER] ADD CONSTRAINT [DF_ERP_ORDER_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[ERP_ORDER_DETAIL] ADD CONSTRAINT [DF_ERP_ORDER_DETAIL_PartPrice] DEFAULT ((0)) FOR [PartPrice]
GO
ALTER TABLE [dbo].[ERP_ORDER_DETAIL] ADD CONSTRAINT [DF_ERP_ORDER_DETAIL_PlanQty] DEFAULT ((0)) FOR [PlanQty]
GO
ALTER TABLE [dbo].[ERP_ORDER_DETAIL] ADD CONSTRAINT [DF_ERP_ORDER_DETAIL_ClosedQty] DEFAULT ((0)) FOR [ClosedQty]
GO
ALTER TABLE [dbo].[ERP_ORDER_DETAIL] ADD CONSTRAINT [DF_ERP_ORDER_DETAIL_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[ERP_ORDER_DETAIL] ADD CONSTRAINT [DF_ERP_ORDER_DETAIL_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[ERP_ORDER_DETAIL] ADD CONSTRAINT [DF_ERP_ORDER_DETAIL_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[ERP_ORDER_DETAIL] ADD CONSTRAINT [DF_ERP_ORDER_DETAIL_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TA_BILLTYPE] ADD CONSTRAINT [DF_TA_BILLTYPE_State] DEFAULT ((0)) FOR [State]
GO
ALTER TABLE [dbo].[TA_BILLTYPE] ADD CONSTRAINT [DF_TA_BILLTYPE_BillNumRule] DEFAULT (N'P|D:l|N:4') FOR [BillNumRule]
GO
ALTER TABLE [dbo].[TA_BILLTYPE] ADD CONSTRAINT [DF_TA_BILLTYPE_LastNumber] DEFAULT ((1)) FOR [LastNumber]
GO
ALTER TABLE [dbo].[TA_BILLTYPE] ADD CONSTRAINT [DF_TA_BILLTYPE_LastBillNum] DEFAULT ('') FOR [LastBillNum]
GO
ALTER TABLE [dbo].[TA_BILLTYPE] ADD CONSTRAINT [DF_TA_BILLTYPE_LastBillTime] DEFAULT (getdate()) FOR [LastBillTime]
GO
ALTER TABLE [dbo].[TA_BILLTYPE] ADD CONSTRAINT [DF_TA_BILLTYPE_PrintTemplateFileName] DEFAULT ('') FOR [PrintTemplateFileName]
GO
ALTER TABLE [dbo].[TA_BILLTYPE] ADD CONSTRAINT [DF_TA_BILLTYPE_Sep] DEFAULT ('.') FOR [Sep]
GO
ALTER TABLE [dbo].[TA_BILLTYPE] ADD CONSTRAINT [DF_TA_BILLTYPE_PaperOrientation] DEFAULT ((0)) FOR [PaperOrientation]
GO
ALTER TABLE [dbo].[TA_BILLTYPE] ADD CONSTRAINT [DF_TA_BILLTYPE_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TA_BILLTYPE] ADD CONSTRAINT [DF_TA_BILLTYPE_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TA_BILLTYPE] ADD CONSTRAINT [DF_TA_BILLTYPE_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TA_BILLTYPE] ADD CONSTRAINT [DF_TA_BILLTYPE_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TA_CONFIG] ADD CONSTRAINT [DF_SYS_CONFIG_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TA_CONFIG] ADD CONSTRAINT [DF_TA_CONFIG_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TA_CONFIG] ADD CONSTRAINT [DF_TA_CONFIG_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TA_CONFIG] ADD CONSTRAINT [DF_TA_CONFIG_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TA_CONFIG] ADD CONSTRAINT [DF_TA_CONFIG_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TA_FACTORY] ADD CONSTRAINT [DF_TA_FACTORY_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TA_FACTORY] ADD CONSTRAINT [DF_TA_FACTORY_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TA_FACTORY] ADD CONSTRAINT [DF_TA_FACTORY_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TA_FACTORY] ADD CONSTRAINT [DF_TA_FACTORY_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TA_FACTORY] ADD CONSTRAINT [DF_TA_FACTORY_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TA_PART] ADD CONSTRAINT [DF_TA_PART_ErpPartCode] DEFAULT ('') FOR [ErpPartCode]
GO
ALTER TABLE [dbo].[TA_PART] ADD CONSTRAINT [DF_TA_PART_PartName2] DEFAULT ('''') FOR [PartDesc2]
GO
ALTER TABLE [dbo].[TA_PART] ADD CONSTRAINT [DF_TA_PART_ProjectId] DEFAULT ('') FOR [ProjectId]
GO
ALTER TABLE [dbo].[TA_PART] ADD CONSTRAINT [DF_TA_PART_Unit] DEFAULT (N'EA') FOR [Unit]
GO
ALTER TABLE [dbo].[TA_PART] ADD CONSTRAINT [DF_TA_PART_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TA_PART] ADD CONSTRAINT [DF_TA_PART_ValidityDays] DEFAULT ((365)) FOR [ValidityDays]
GO
ALTER TABLE [dbo].[TA_PART] ADD CONSTRAINT [DF_TA_PART_ReceivePort] DEFAULT ('') FOR [ReceivePort]
GO
ALTER TABLE [dbo].[TA_PART] ADD CONSTRAINT [DF_TA_PART_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TA_PART] ADD CONSTRAINT [DF_TA_PART_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TA_PART] ADD CONSTRAINT [DF_TA_PART_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TA_PART] ADD CONSTRAINT [DF_TA_PART_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TA_VEND_PART] ADD CONSTRAINT [DF_Table_1_CustId] DEFAULT ('') FOR [VendId]
GO
ALTER TABLE [dbo].[TA_VEND_PART] ADD CONSTRAINT [DF_TA_Vend_PART_VendPackQty] DEFAULT ((1)) FOR [VendPackQty]
GO
ALTER TABLE [dbo].[TA_VEND_PART] ADD CONSTRAINT [DF_TA_Vend_PART_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TA_VEND_PART] ADD CONSTRAINT [DF_TA_VEND_PART_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TA_VEND_PART] ADD CONSTRAINT [DF_TA_VEND_PART_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TA_VEND_PART] ADD CONSTRAINT [DF_TA_VEND_PART_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TA_VEND_PART] ADD CONSTRAINT [DF_TA_VEND_PART_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TA_VENDER] ADD CONSTRAINT [DF_TA_SUPERLIER_VendAbbCode] DEFAULT ((0)) FOR [VendAbbCode]
GO
ALTER TABLE [dbo].[TA_VENDER] ADD CONSTRAINT [DF__t_Supplie__state__56E8E7AB] DEFAULT ((0)) FOR [State]
GO
ALTER TABLE [dbo].[TA_VENDER] ADD CONSTRAINT [DF_TA_VENDER_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TA_VENDER] ADD CONSTRAINT [DF_TA_VENDER_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TA_VENDER] ADD CONSTRAINT [DF_TA_VENDER_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TA_VENDER] ADD CONSTRAINT [DF_TA_VENDER_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TB_ASK] ADD CONSTRAINT [DF_TB_ASK_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TB_ASK] ADD CONSTRAINT [DF_TB_ASK_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TB_ASK] ADD CONSTRAINT [DF_TB_ASK_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TB_ASK] ADD CONSTRAINT [DF_TB_ASK_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TB_ASK] ADD CONSTRAINT [DF_TB_ASK_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TB_ASK_DETAIL] ADD CONSTRAINT [DF_Table_1_PoLine] DEFAULT ((1)) FOR [PoLine]
GO
ALTER TABLE [dbo].[TB_ASK_DETAIL] ADD CONSTRAINT [DF_Table_1_BillQty_1] DEFAULT ((0)) FOR [AskQty]
GO
ALTER TABLE [dbo].[TB_ASK_DETAIL] ADD CONSTRAINT [DF_Table_1_ShippedQty] DEFAULT ((0)) FOR [ShippedQty]
GO
ALTER TABLE [dbo].[TB_ASK_DETAIL] ADD CONSTRAINT [DF_Table_1_ReceivedQty] DEFAULT ((0)) FOR [ReceivedQty]
GO
ALTER TABLE [dbo].[TB_ASK_DETAIL] ADD CONSTRAINT [DF_Table_1_PackQty] DEFAULT ((1)) FOR [PackQty]
GO
ALTER TABLE [dbo].[TB_ASK_DETAIL] ADD CONSTRAINT [DF_TB_ASK_DETAIL_UnConv] DEFAULT ((1)) FOR [UnConv]
GO
ALTER TABLE [dbo].[TB_ASK_DETAIL] ADD CONSTRAINT [DF_Table_1_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TB_ASK_DETAIL] ADD CONSTRAINT [DF_Table_1_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TB_ASK_DETAIL] ADD CONSTRAINT [DF_Table_1_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TB_ASK_DETAIL] ADD CONSTRAINT [DF_Table_1_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TB_ASK_DETAIL] ADD CONSTRAINT [DF_Table_1_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TB_ASN] ADD CONSTRAINT [DF__KF_Suppli__cBill__208CD6FA] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TB_ASN] ADD CONSTRAINT [DF_TB_ASN_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TB_ASN] ADD CONSTRAINT [DF_TB_ASN_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TB_ASN] ADD CONSTRAINT [DF_TF_ASN_ShipTime] DEFAULT ('1-1-1') FOR [ShipTime]
GO
ALTER TABLE [dbo].[TB_ASN] ADD CONSTRAINT [DF_TB_ASN_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TB_ASN] ADD CONSTRAINT [DF_TB_ASN_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TB_ASN_DETAIL] ADD CONSTRAINT [DF_TB_ASN_DETAIL_ErpBillNum] DEFAULT ('') FOR [PoBillNum]
GO
ALTER TABLE [dbo].[TB_ASN_DETAIL] ADD CONSTRAINT [DF_TF_ASN_DETAIL_PoLineNum] DEFAULT ((1)) FOR [PoLine]
GO
ALTER TABLE [dbo].[TB_ASN_DETAIL] ADD CONSTRAINT [DF_TF_ASN_DETAIL_ProduceDate] DEFAULT (getdate()) FOR [ProduceDate]
GO
ALTER TABLE [dbo].[TB_ASN_DETAIL] ADD CONSTRAINT [DF__KF_Supplie__nQty__6CD828CA] DEFAULT ((0)) FOR [Qty]
GO
ALTER TABLE [dbo].[TB_ASN_DETAIL] ADD CONSTRAINT [DF_TF_ASN_DETAIL_PackQty] DEFAULT ((1)) FOR [PackQty]
GO
ALTER TABLE [dbo].[TB_ASN_DETAIL] ADD CONSTRAINT [DF_TB_ASN_DETAIL_UnConv] DEFAULT ((1)) FOR [UnConv]
GO
ALTER TABLE [dbo].[TB_ASN_DETAIL] ADD CONSTRAINT [DF_TF_ASN_DETAIL_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TB_ASN_DETAIL] ADD CONSTRAINT [DF_TB_ASN_DETAIL_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TB_ASN_DETAIL] ADD CONSTRAINT [DF_TB_ASN_DETAIL_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TB_ASN_DETAIL] ADD CONSTRAINT [DF_TB_ASN_DETAIL_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TB_ASN_DETAIL] ADD CONSTRAINT [DF_TB_ASN_DETAIL_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TB_INVOICE] ADD CONSTRAINT [DF_TB_INVOICE_Tax] DEFAULT ((0.16)) FOR [Tax]
GO
ALTER TABLE [dbo].[TB_INVOICE] ADD CONSTRAINT [DF_TB_INVOICE_State] DEFAULT ((0)) FOR [State]
GO
ALTER TABLE [dbo].[TB_INVOICE] ADD CONSTRAINT [DF_TB_INVOICE_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TB_INVOICE] ADD CONSTRAINT [DF_TB_INVOICE_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TB_INVOICE] ADD CONSTRAINT [DF_TB_INVOICE_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TB_INVOICE] ADD CONSTRAINT [DF_TB_INVOICE_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TB_INVOICE_DETAIL] ADD CONSTRAINT [DF_TB_INVOICE_DETAIL_PoLineNum] DEFAULT ((1)) FOR [PoLineNum]
GO
ALTER TABLE [dbo].[TB_INVOICE_DETAIL] ADD CONSTRAINT [DF_TB_INVOICE_DETAIL_ProduceDate] DEFAULT (getdate()) FOR [ProduceDate]
GO
ALTER TABLE [dbo].[TB_INVOICE_DETAIL] ADD CONSTRAINT [DF_Table_1_BillQty] DEFAULT ((0)) FOR [Qty]
GO
ALTER TABLE [dbo].[TB_INVOICE_DETAIL] ADD CONSTRAINT [DF_TB_INVOICE_DETAIL_Price] DEFAULT ((0)) FOR [Price]
GO
ALTER TABLE [dbo].[TB_INVOICE_DETAIL] ADD CONSTRAINT [DF_TB_INVOICE_DETAIL_PackQty] DEFAULT ((1)) FOR [PackQty]
GO
ALTER TABLE [dbo].[TB_INVOICE_DETAIL] ADD CONSTRAINT [DF_TB_INVOICE_DETAIL_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TB_INVOICE_DETAIL] ADD CONSTRAINT [DF_TB_INVOICE_DETAIL_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TB_INVOICE_DETAIL] ADD CONSTRAINT [DF_TB_INVOICE_DETAIL_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TB_INVOICE_DETAIL] ADD CONSTRAINT [DF_TB_INVOICE_DETAIL_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TB_INVOICE_DETAIL] ADD CONSTRAINT [DF_TB_INVOICE_DETAIL_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TB_PLAN] ADD CONSTRAINT [DF_TS_LONGTERM_PLAN_PlanType] DEFAULT ((1)) FOR [PlanType]
GO
ALTER TABLE [dbo].[TB_PLAN] ADD CONSTRAINT [DF_TS_LONGTERM_PLAN_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TB_PLAN] ADD CONSTRAINT [DF_TS_LONGTERM_PLAN_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TB_PLAN] ADD CONSTRAINT [DF_TS_LONGTERM_PLAN_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TB_PLAN] ADD CONSTRAINT [DF_TS_LONGTERM_PLAN_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TB_PLAN] ADD CONSTRAINT [DF_TS_LONGTERM_PLAN_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TB_PLAN_DETAIL] ADD CONSTRAINT [DF_TB_PLAN_DETAIL_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TB_PLAN_DETAIL] ADD CONSTRAINT [DF_TB_PLAN_DETAIL_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TB_PLAN_DETAIL] ADD CONSTRAINT [DF_TB_PLAN_DETAIL_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TB_PLAN_DETAIL] ADD CONSTRAINT [DF_TB_PLAN_DETAIL_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TB_PLAN_DETAIL] ADD CONSTRAINT [DF_TB_PLAN_DETAIL_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TB_PO] ADD CONSTRAINT [DF__KF_Purcha__cBill__3E1D39E1] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TB_PO] ADD CONSTRAINT [DF_TB_PO_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TB_PO] ADD CONSTRAINT [DF_TB_PO_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TB_PO] ADD CONSTRAINT [DF_TB_PO_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TB_PO] ADD CONSTRAINT [DF_TB_PO_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TB_PO_DETAIL] ADD CONSTRAINT [DF_TF_PO_DETAIL_Line] DEFAULT ((1)) FOR [PoLine]
GO
ALTER TABLE [dbo].[TB_PO_DETAIL] ADD CONSTRAINT [DF__KF_Purchas__nQty__5BAD9CC8] DEFAULT ((0)) FOR [PlanQty]
GO
ALTER TABLE [dbo].[TB_PO_DETAIL] ADD CONSTRAINT [DF_TF_PO_D_dClosedQty] DEFAULT ((0)) FOR [ShippedQty]
GO
ALTER TABLE [dbo].[TB_PO_DETAIL] ADD CONSTRAINT [DF_TF_PO_DETAIL_ReceivedQty] DEFAULT ((0)) FOR [ReceivedQty]
GO
ALTER TABLE [dbo].[TB_PO_DETAIL] ADD CONSTRAINT [DF_TF_PO_DETAIL_PurchasePrice] DEFAULT ((0)) FOR [Price]
GO
ALTER TABLE [dbo].[TB_PO_DETAIL] ADD CONSTRAINT [DF_TF_PO_DETAIL_PackQty] DEFAULT ((1)) FOR [PackQty]
GO
ALTER TABLE [dbo].[TB_PO_DETAIL] ADD CONSTRAINT [DF_TB_PO_DETAIL_UnConv] DEFAULT ((1)) FOR [UnConv]
GO
ALTER TABLE [dbo].[TB_PO_DETAIL] ADD CONSTRAINT [DF_TF_PO_DETAIL_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TB_PO_DETAIL] ADD CONSTRAINT [DF_TB_PO_DETAIL_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TB_PO_DETAIL] ADD CONSTRAINT [DF_TB_PO_DETAIL_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TB_PO_DETAIL] ADD CONSTRAINT [DF_TB_PO_DETAIL_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TB_PO_DETAIL] ADD CONSTRAINT [DF_TB_PO_DETAIL_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TB_RECEIVE] ADD CONSTRAINT [DF_TB_RECEIVE_ShipTime] DEFAULT (sysdatetime()) FOR [ShipTime]
GO
ALTER TABLE [dbo].[TB_RECEIVE] ADD CONSTRAINT [DF_TB_RECEIVE_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TB_RECEIVE] ADD CONSTRAINT [DF_TB_RECEIVE_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TB_RECEIVE] ADD CONSTRAINT [DF_TB_RECEIVE_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TB_RECEIVE] ADD CONSTRAINT [DF_TB_RECEIVE_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TB_RECEIVE_DETAIL] ADD CONSTRAINT [DF_TB_RECEIVE_DETAIL_PoBIllNum] DEFAULT ('') FOR [PoBIllNum]
GO
ALTER TABLE [dbo].[TB_RECEIVE_DETAIL] ADD CONSTRAINT [DF_TB_RECEIVE_DETAIL_PoLineNum] DEFAULT ((1)) FOR [PoLine]
GO
ALTER TABLE [dbo].[TB_RECEIVE_DETAIL] ADD CONSTRAINT [DF_Table_1_ClosedQty] DEFAULT ((0)) FOR [Qty]
GO
ALTER TABLE [dbo].[TB_RECEIVE_DETAIL] ADD CONSTRAINT [DF_TB_RECEIVE_DETAIL_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TB_RECEIVE_DETAIL] ADD CONSTRAINT [DF_TB_RECEIVE_DETAIL_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TB_RECEIVE_DETAIL] ADD CONSTRAINT [DF_TB_RECEIVE_DETAIL_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TB_RECEIVE_DETAIL] ADD CONSTRAINT [DF_TB_RECEIVE_DETAIL_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TB_RECEIVE_DETAIL] ADD CONSTRAINT [DF_TB_RECEIVE_DETAIL_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TB_REJECT] ADD CONSTRAINT [DF_TB_RETURN_ShipTime] DEFAULT (sysdatetime()) FOR [ShipTime]
GO
ALTER TABLE [dbo].[TB_REJECT] ADD CONSTRAINT [DF_TB_RETURN_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TB_REJECT] ADD CONSTRAINT [DF_TB_REJECT_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TB_REJECT] ADD CONSTRAINT [DF_TB_REJECT_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TB_REJECT] ADD CONSTRAINT [DF_TB_REJECT_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TB_REJECT_DETAIL] ADD CONSTRAINT [DF_TB_REJECT_DETAIL_PoBillNum] DEFAULT ('') FOR [PoBillNum]
GO
ALTER TABLE [dbo].[TB_REJECT_DETAIL] ADD CONSTRAINT [DF_TB_RETURN_DETAIL_PoLineNum] DEFAULT ((1)) FOR [PoLine]
GO
ALTER TABLE [dbo].[TB_REJECT_DETAIL] ADD CONSTRAINT [DF_TB_RETURN_DETAIL_ReceivedQty] DEFAULT ((0)) FOR [Qty]
GO
ALTER TABLE [dbo].[TB_REJECT_DETAIL] ADD CONSTRAINT [DF_TB_RETURN_DETAIL_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TB_REJECT_DETAIL] ADD CONSTRAINT [DF_TB_REJECT_DETAIL_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TB_REJECT_DETAIL] ADD CONSTRAINT [DF_TB_REJECT_DETAIL_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TB_REJECT_DETAIL] ADD CONSTRAINT [DF_TB_REJECT_DETAIL_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TB_REJECT_DETAIL] ADD CONSTRAINT [DF_TB_REJECT_DETAIL_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TL_BASEDATA] ADD CONSTRAINT [DF_TL_BASEDATA_LogTime] DEFAULT (getdate()) FOR [LogTime]
GO
ALTER TABLE [dbo].[TL_BASEDATA] ADD CONSTRAINT [DF_Table_1_LogSite] DEFAULT ('') FOR [OldValue]
GO
ALTER TABLE [dbo].[TL_BASEDATA] ADD CONSTRAINT [DF_TL_BASEDATA_NewValue] DEFAULT ('') FOR [NewValue]
GO
ALTER TABLE [dbo].[TL_BILL] ADD CONSTRAINT [DF_TL_BILL_LogTime] DEFAULT (getdate()) FOR [LogTime]
GO
ALTER TABLE [dbo].[TL_BILL] ADD CONSTRAINT [DF_Table_1_OldData] DEFAULT ((0)) FOR [BillNum]
GO
ALTER TABLE [dbo].[TL_USER] ADD CONSTRAINT [DF_TL_LOG_LogTime] DEFAULT (getdate()) FOR [LogTime]
GO
ALTER TABLE [dbo].[TL_USER] ADD CONSTRAINT [DF_TL_LOG_LogSite] DEFAULT ((0)) FOR [LogSite]
GO
ALTER TABLE [dbo].[TS_BARCODE] ADD CONSTRAINT [DF_TS_BARCODE_Batch] DEFAULT (N'    ') FOR [Batch]
GO
ALTER TABLE [dbo].[TS_BARCODE] ADD CONSTRAINT [DF_TS_BARCODE_ProduceDate] DEFAULT (sysdatetime()) FOR [ProduceDate]
GO
ALTER TABLE [dbo].[TS_BARCODE] ADD CONSTRAINT [DF_TS_BARCODE_SerialNum] DEFAULT ('''') FOR [SerialNum]
GO
ALTER TABLE [dbo].[TS_BARCODE] ADD CONSTRAINT [DF_TS_BARCODE_Qty] DEFAULT ((1)) FOR [Qty]
GO
ALTER TABLE [dbo].[TS_BARCODE] ADD CONSTRAINT [DF_TS_BARCODE_SourceBillNum] DEFAULT ('  ') FOR [BillNum]
GO
ALTER TABLE [dbo].[TS_BARCODE] ADD CONSTRAINT [DF_TS_BARCODE_BillLine] DEFAULT ((0)) FOR [BillLine]
GO
ALTER TABLE [dbo].[TS_BARCODE] ADD CONSTRAINT [DF_TS_BARCODE_PackQty] DEFAULT ((1)) FOR [PackQty]
GO
ALTER TABLE [dbo].[TS_BARCODE] ADD CONSTRAINT [DF_TS_BARCODE_CreateOper] DEFAULT (N'    ') FOR [CreateOper]
GO
ALTER TABLE [dbo].[TS_BARCODE] ADD CONSTRAINT [DF_TS_BARCODE_CreateTime] DEFAULT (getdate()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TS_BARCODE] ADD CONSTRAINT [DF_TS_BARCODE_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TS_BARCODE] ADD CONSTRAINT [DF_TS_BARCODE_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TS_INFO] ADD CONSTRAINT [DF_TS_INFO_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TS_INFO] ADD CONSTRAINT [DF_TS_INFO_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TS_INFO] ADD CONSTRAINT [DF_TS_INFO_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TS_INFO] ADD CONSTRAINT [DF_TA_INFO_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TS_STOCK] ADD CONSTRAINT [DF_TS_STOCK_DETAIL_Batch] DEFAULT (N'    ') FOR [Batch]
GO
ALTER TABLE [dbo].[TS_STOCK] ADD CONSTRAINT [DF_TS_STOCK_DETAIL_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TS_STOCK] ADD CONSTRAINT [DF_TS_UNIQUE_STOCK_Qty] DEFAULT ((1)) FOR [Qty]
GO
ALTER TABLE [dbo].[TS_STOCK] ADD CONSTRAINT [DF_TS_STOCK_DETAIL_VendBatch] DEFAULT ('') FOR [VendBatch]
GO
ALTER TABLE [dbo].[TS_STOCK] ADD CONSTRAINT [DF_TS_STOCK_DETAIL_ReceiveDate] DEFAULT (getdate()) FOR [ReceiveTime]
GO
ALTER TABLE [dbo].[TS_STOCK] ADD CONSTRAINT [DF_TS_STOCK_DETAIL_ProduceDate] DEFAULT ('1-1-1') FOR [ProduceDate]
GO
ALTER TABLE [dbo].[TS_UNI_API] ADD CONSTRAINT [DF_TS_UNI_INTERFACE_Qty] DEFAULT ((0)) FOR [Qty]
GO
ALTER TABLE [dbo].[TS_UNI_API] ADD CONSTRAINT [DF_TS_UNI_INTERFACE_State] DEFAULT ((0)) FOR [State]
GO
ALTER TABLE [dbo].[TS_UNI_API] ADD CONSTRAINT [DF_TS_UNI_INTERFACE_PutTime] DEFAULT (getdate()) FOR [PutTime]
GO
ALTER TABLE [dbo].[TS_UNI_API] ADD CONSTRAINT [DF_TS_UNI_INTERFACE_ValidDate] DEFAULT (getdate()) FOR [ValidDate]
GO
ALTER TABLE [dbo].[TS_UNI_API] ADD CONSTRAINT [DF_TS_UNI_INTERFACE_ErpLineNum] DEFAULT ((0)) FOR [ErpLineNum]
GO
ALTER TABLE [dbo].[TS_UNI_API] ADD CONSTRAINT [DF_TS_UNI_INTERFACE_CreateTime] DEFAULT (getdate()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TS_UNI_API] ADD CONSTRAINT [DF_TS_UNI_API_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TS_UNI_API_HIS] ADD CONSTRAINT [DF_TS_UNI_API_HIS_Qty_1] DEFAULT ((0)) FOR [Qty]
GO
ALTER TABLE [dbo].[TS_UNI_API_HIS] ADD CONSTRAINT [DF_TS_UNI_API_HIS_State_1] DEFAULT ((0)) FOR [State]
GO
ALTER TABLE [dbo].[TS_UNI_API_HIS] ADD CONSTRAINT [DF_TS_UNI_API_HIS_PutTime_1] DEFAULT (getdate()) FOR [PutTime]
GO
ALTER TABLE [dbo].[TS_UNI_API_HIS] ADD CONSTRAINT [DF_TS_UNI_API_HIS_ValidDate_1] DEFAULT (getdate()) FOR [ValidDate]
GO
ALTER TABLE [dbo].[TS_UNI_API_HIS] ADD CONSTRAINT [DF_TS_UNI_API_HIS_ErpLineNum_1] DEFAULT ((0)) FOR [ErpLineNum]
GO
ALTER TABLE [dbo].[TS_UNI_API_HIS] ADD CONSTRAINT [DF_TS_UNI_API_HIS_CreateTime_1] DEFAULT (getdate()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TS_UNI_API_HIS] ADD CONSTRAINT [DF_TS_UNI_API_HIS_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TT_CURRENCY] ADD CONSTRAINT [DF_TT_CURRENCY_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TT_CURRENCY] ADD CONSTRAINT [DF_TT_CURRENCY_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TT_CURRENCY] ADD CONSTRAINT [DF_TT_CURRENCY_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TT_CURRENCY] ADD CONSTRAINT [DF_TT_CURRENCY_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TT_CURRENCY] ADD CONSTRAINT [DF_TT_CURRENCY_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TT_PROJECT] ADD CONSTRAINT [DF_TT_PROJECT_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TT_PROJECT] ADD CONSTRAINT [DF_TT_PROJECT_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TT_PROJECT] ADD CONSTRAINT [DF_TT_PROJECT_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TT_PROJECT] ADD CONSTRAINT [DF_TT_PROJECT_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TT_PROJECT] ADD CONSTRAINT [DF_TT_PROJECT_GUID] DEFAULT (newid()) FOR [GUID]
GO
ALTER TABLE [dbo].[TT_UNIT] ADD CONSTRAINT [DF_TT_UNIT_State] DEFAULT ((1)) FOR [State]
GO
ALTER TABLE [dbo].[TT_UNIT] ADD CONSTRAINT [DF_TT_UNIT_CreateTime] DEFAULT (sysdatetime()) FOR [CreateTime]
GO
ALTER TABLE [dbo].[TT_UNIT] ADD CONSTRAINT [DF_TT_UNIT_CreateUser] DEFAULT ('') FOR [CreateUser]
GO
ALTER TABLE [dbo].[TT_UNIT] ADD CONSTRAINT [DF_TT_UNIT_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
GO
ALTER TABLE [dbo].[TT_UNIT] ADD CONSTRAINT [DF_TT_UNIT_GUID] DEFAULT (newid()) FOR [GUID]
GO
/****** Object: StoredProcedure [dbo].[P_GetAllTables] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[P_GetAllTables]
as
begin
SELECT
h T = Case When A.colorder=1 Then D.name Else '' End,
hf = Case When A.colorder=1 Then isnull(F.value,'') Else '' End,
-- h T = D.name,
-- hf = isnull(F.value,''),
W[k^S = A.colorder,
W[k T = A.name,
W[kf = isnull(G.[value],''),
X = Case When COLUMNPROPERTY( A.id,A.name,'IsIdentity')=1 Then '�%'Else '' End,
;N. = Case When exists(SELECT 1 FROM sysobjects Where xtype='PK' and parent_obj=A.id and name in (
SELECT name FROM sysindexes WHERE indid in( SELECT indid FROM sysindexkeys WHERE id = A.id AND colid=A.colid))) then '�%' else '' end,
{|W = B.name,
^ = COLUMNPROPERTY(A.id,A.name,'PRECISION'),
\peMOpe = isnull(COLUMNPROPERTY(A.id,A.name,'Scale'),0),
AQzz = Case When A.isnullable=1 Then '�%'Else '' End,
؞<P = isnull(E.Text,''),
`S(uW[pe = A.Length
FROM
syscolumns A
Left Join
systypes B
On
A.xusertype=B.xusertype
Inner Join
sysobjects D
On
A.id=D.id and D.xtype='U' and D.name<>'dtproperties'
Left Join
syscomments E
on
A.cdefault=E.id
Left Join
sys.extended_properties G
on
A.id=G.major_id and A.colid=G.minor_id
Left Join
sys.extended_properties F
On
D.id=F.major_id and F.minor_id=0
--where d.name='OrderInfo' --YgSgc[h,R
NdkagN
Order By
D.Name,A.id,A.colorder
end
GO
/****** Object: StoredProcedure [dbo].[p_GetTableRows] Script Date: 2018-05-02 20:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[p_GetTableRows]
as
begin
SELECT a.name, b.rows
FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id
WHERE (a.type = 'u') AND (b.indid IN (0, 1))
ORDER BY b.rows desc,a.name DESC
end
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ERP��US�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER', @level2type=N'COLUMN',@level2name=N'ErpBillNum'
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'ERP_ORDER', @level2type=N'COLUMN',@level2name=N'VendId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USnc{|�W(1:�e zUS,2:�yce��US)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER', @level2type=N'COLUMN',@level2name=N'ModType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'T��|�N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER', @level2type=N'COLUMN',@level2name=N'Contacter'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0W�p' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER', @level2type=N'COLUMN',@level2name=N'Site'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-�XT' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER', @level2type=N'COLUMN',@level2name=N'Buyer'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-�XT5u݋' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER', @level2type=N'COLUMN',@level2name=N'BuyerPhone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`�1� gHe �0��eHe �' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Y�l' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'R�^�e��' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER', @level2type=N'COLUMN',@level2name=N'CreateTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'R�^�N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER', @level2type=N'COLUMN',@level2name=N'CreateUser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ERP;Nh����U_�N�c�S���S�v@b gpenc �' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ERP��US�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER_DETAIL', @level2type=N'COLUMN',@level2name=N'ErpBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��USL�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER_DETAIL', @level2type=N'COLUMN',@level2name=N'PoLine'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���N�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER_DETAIL', @level2type=N'COLUMN',@level2name=N'PartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��US�N<h' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER_DETAIL', @level2type=N'COLUMN',@level2name=N'PartPrice'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'_Ye' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER_DETAIL', @level2type=N'COLUMN',@level2name=N'BeginTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'~_ge' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER_DETAIL', @level2type=N'COLUMN',@level2name=N'EndTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��Rpeϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER_DETAIL', @level2type=N'COLUMN',@level2name=N'PlanQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�]�~peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER_DETAIL', @level2type=N'COLUMN',@level2name=N'ClosedQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER_DETAIL', @level2type=N'COLUMN',@level2name=N'DockCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`�1� gHe �0��eHe �' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER_DETAIL', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Y�l' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER_DETAIL', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'R�^�e��' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER_DETAIL', @level2type=N'COLUMN',@level2name=N'CreateTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'R�^�N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER_DETAIL', @level2type=N'COLUMN',@level2name=N'CreateUser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ERP��USf�~h�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ERP_ORDER_DETAIL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USnc{|�W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_BILLTYPE', @level2type=N'COLUMN',@level2name=N'BillType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'{|�W T�y' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_BILLTYPE', @level2type=N'COLUMN',@level2name=N'TypeName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�c��' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_BILLTYPE', @level2type=N'COLUMN',@level2name=N'TypeDesc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_BILLTYPE', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'MR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_BILLTYPE', @level2type=N'COLUMN',@level2name=N'Prefix'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�SĉR' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_BILLTYPE', @level2type=N'COLUMN',@level2name=N'BillNumRule'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'g�~�^�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_BILLTYPE', @level2type=N'COLUMN',@level2name=N'LastNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'g�~USnc�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_BILLTYPE', @level2type=N'COLUMN',@level2name=N'LastBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'g�~USnc�e��' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_BILLTYPE', @level2type=N'COLUMN',@level2name=N'LastBillTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SbpS!jg�e�N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_BILLTYPE', @level2type=N'COLUMN',@level2name=N'PrintTemplateFileName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�[eQ!jg�e�N T�y' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_BILLTYPE', @level2type=N'COLUMN',@level2name=N'ImportTemplateFileName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�SR��&{(".")' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_BILLTYPE', @level2type=N'COLUMN',@level2name=N'Sep'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USnc{|�Wh�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_BILLTYPE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�Spe T�y' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_CONFIG', @level2type=N'COLUMN',@level2name=N'ParamName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�Spe<P' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_CONFIG', @level2type=N'COLUMN',@level2name=N'ParamValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_CONFIG', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Y�l' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_CONFIG', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�|�~M�nh�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_CONFIG'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�]�S�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_FACTORY', @level2type=N'COLUMN',@level2name=N'FactoryId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�]�S T�y' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_FACTORY', @level2type=N'COLUMN',@level2name=N'FactoryName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ERP0W�p' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_FACTORY', @level2type=N'COLUMN',@level2name=N'ErpSite'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ERP�W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_FACTORY', @level2type=N'COLUMN',@level2name=N'ErpDomain'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_FACTORY', @level2type=N'COLUMN',@level2name=N'Address'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_FACTORY', @level2type=N'COLUMN',@level2name=N'ZipCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�]�Sh�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_FACTORY'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���N�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_PART', @level2type=N'COLUMN',@level2name=N'PartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ERP���N�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_PART', @level2type=N'COLUMN',@level2name=N'ErpPartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���N�c��1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_PART', @level2type=N'COLUMN',@level2name=N'PartDesc1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���N�c��2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_PART', @level2type=N'COLUMN',@level2name=N'PartDesc2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'y��v�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_PART', @level2type=N'COLUMN',@level2name=N'ProjectId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USMO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_PART', @level2type=N'COLUMN',@level2name=N'Unit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���N�~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_PART', @level2type=N'COLUMN',@level2name=N'PartGroup'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`�0�1YHe 1: gHe �' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_PART', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'M�n�Oo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_PART', @level2type=N'COLUMN',@level2name=N'Configuration'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O(�g�)Y �' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_PART', @level2type=N'COLUMN',@level2name=N'ValidityDays'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_PART', @level2type=N'COLUMN',@level2name=N'ReceivePort'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Xb�v:\�[' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_PART', @level2type=N'COLUMN',@level2name=N'PalletSize'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Y�l' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_PART', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���Nh�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_PART'
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'TA_VEND_PART', @level2type=N'COLUMN',@level2name=N'VendId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���N�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VEND_PART', @level2type=N'COLUMN',@level2name=N'PartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O�^FU���N�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VEND_PART', @level2type=N'COLUMN',@level2name=N'VendPartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O�^FUSňpeϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VEND_PART', @level2type=N'COLUMN',@level2name=N'VendPackQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-�USMO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VEND_PART', @level2type=N'COLUMN',@level2name=N'PoUnit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`�0�1YHe 1: gHe �' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VEND_PART', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Y�l' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VEND_PART', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O�^FU���Nh�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VEND_PART'
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'TA_VENDER', @level2type=N'COLUMN',@level2name=N'VendId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O�^FU T�y' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VENDER', @level2type=N'COLUMN',@level2name=N'VendName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O�^FU)�Q' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VENDER', @level2type=N'COLUMN',@level2name=N'VendAbbCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O�^FU{|�W (1:�V�Q,1:�VY)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VENDER', @level2type=N'COLUMN',@level2name=N'VendType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�V�[' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VENDER', @level2type=N'COLUMN',@level2name=N'Country'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�W^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VENDER', @level2type=N'COLUMN',@level2name=N'City'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'^�y' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VENDER', @level2type=N'COLUMN',@level2name=N'Currency'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VENDER', @level2type=N'COLUMN',@level2name=N'Address'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VENDER', @level2type=N'COLUMN',@level2name=N'ZipCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'T��|�N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VENDER', @level2type=N'COLUMN',@level2name=N'Contacter'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'5u݋' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VENDER', @level2type=N'COLUMN',@level2name=N'Phone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N' Ow' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VENDER', @level2type=N'COLUMN',@level2name=N'Fax'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'5uP[���N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VENDER', @level2type=N'COLUMN',@level2name=N'Email'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VENDER', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Y�l' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VENDER', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O�^FUh�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TA_VENDER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��'USS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK', @level2type=N'COLUMN',@level2name=N'AskBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��US�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK', @level2type=N'COLUMN',@level2name=N'PoBillNum'
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'TB_ASK', @level2type=N'COLUMN',@level2name=N'VendId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0W�p' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK', @level2type=N'COLUMN',@level2name=N'Site'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��f' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��';Nh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��'USS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK_DETAIL', @level2type=N'COLUMN',@level2name=N'AskBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��US�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK_DETAIL', @level2type=N'COLUMN',@level2name=N'PoBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��USL�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK_DETAIL', @level2type=N'COLUMN',@level2name=N'PoLine'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���N�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK_DETAIL', @level2type=N'COLUMN',@level2name=N'PartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��'peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK_DETAIL', @level2type=N'COLUMN',@level2name=N'AskQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�]�Speϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK_DETAIL', @level2type=N'COLUMN',@level2name=N'ShippedQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�]6epeϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK_DETAIL', @level2type=N'COLUMN',@level2name=N'ReceivedQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'_Ye' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK_DETAIL', @level2type=N'COLUMN',@level2name=N'BeginTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'~_ge' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK_DETAIL', @level2type=N'COLUMN',@level2name=N'EndTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-�USMO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK_DETAIL', @level2type=N'COLUMN',@level2name=N'PoUnit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'hSpeϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK_DETAIL', @level2type=N'COLUMN',@level2name=N'PackQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'l�bc�s' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK_DETAIL', @level2type=N'COLUMN',@level2name=N'UnConv'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK_DETAIL', @level2type=N'COLUMN',@level2name=N'DockCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK_DETAIL', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��f' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK_DETAIL', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��'f~h' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASK_DETAIL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�S'USS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN', @level2type=N'COLUMN',@level2name=N'AsnBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��'USS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN', @level2type=N'COLUMN',@level2name=N'AskBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��US�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN', @level2type=N'COLUMN',@level2name=N'PoBillNum'
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'TB_ASN', @level2type=N'COLUMN',@level2name=N'VendId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0W�p' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN', @level2type=N'COLUMN',@level2name=N'Site'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��f' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�S'e' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN', @level2type=N'COLUMN',@level2name=N'ShipTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'e' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN', @level2type=N'COLUMN',@level2name=N'ReceiveTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�S'US;Nh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�S'USS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN_DETAIL', @level2type=N'COLUMN',@level2name=N'AsnBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��US�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN_DETAIL', @level2type=N'COLUMN',@level2name=N'PoBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��USL�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN_DETAIL', @level2type=N'COLUMN',@level2name=N'PoLine'
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'TB_ASN_DETAIL', @level2type=N'COLUMN',@level2name=N'PartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'yb!k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN_DETAIL', @level2type=N'COLUMN',@level2name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'u�N�eg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN_DETAIL', @level2type=N'COLUMN',@level2name=N'ProduceDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O�^FUyb!k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN_DETAIL', @level2type=N'COLUMN',@level2name=N'VendBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�S'peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN_DETAIL', @level2type=N'COLUMN',@level2name=N'Qty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-�USMO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN_DETAIL', @level2type=N'COLUMN',@level2name=N'PoUnit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'X[�PUSMO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN_DETAIL', @level2type=N'COLUMN',@level2name=N'LocUnit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'hSpeϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN_DETAIL', @level2type=N'COLUMN',@level2name=N'PackQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'l�bc�s' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN_DETAIL', @level2type=N'COLUMN',@level2name=N'UnConv'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN_DETAIL', @level2type=N'COLUMN',@level2name=N'DockCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r` ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN_DETAIL', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�S'USf~h' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_ASN_DETAIL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�ShyUS�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE', @level2type=N'COLUMN',@level2name=N'InvcBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0W�p' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE', @level2type=N'COLUMN',@level2name=N'Site'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ёz�Shy�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE', @level2type=N'COLUMN',@level2name=N'InvoiceNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�_�US�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE', @level2type=N'COLUMN',@level2name=N'ExpressNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O'FUS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE', @level2type=N'COLUMN',@level2name=N'VendId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'z�s' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE', @level2type=N'COLUMN',@level2name=N'Tax'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��f' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�Shy;Nh�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�ShyUS�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL', @level2type=N'COLUMN',@level2name=N'InvcBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'USS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL', @level2type=N'COLUMN',@level2name=N'RecvBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�S'USS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL', @level2type=N'COLUMN',@level2name=N'AsnBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��US�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL', @level2type=N'COLUMN',@level2name=N'PoBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��USL�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL', @level2type=N'COLUMN',@level2name=N'PoLineNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���N�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL', @level2type=N'COLUMN',@level2name=N'PartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'yb!k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL', @level2type=N'COLUMN',@level2name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'u�N�eg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL', @level2type=N'COLUMN',@level2name=N'ProduceDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O�^FUyb!k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL', @level2type=N'COLUMN',@level2name=N'VendBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL', @level2type=N'COLUMN',@level2name=N'Qty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-�USMO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL', @level2type=N'COLUMN',@level2name=N'PoUnit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�N<h' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL', @level2type=N'COLUMN',@level2name=N'Price'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N''^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL', @level2type=N'COLUMN',@level2name=N'Currency'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'hSpe' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL', @level2type=N'COLUMN',@level2name=N'PackQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r` 0� NT<h 1�T<h' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��f' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�Shyf�~h�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_INVOICE_DETAIL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'
RUSSERPRUSS+Hr,gS ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PLAN', @level2type=N'COLUMN',@level2name=N'PlanId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��RUS T�y' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PLAN', @level2type=N'COLUMN',@level2name=N'PlanName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ERP��RUS�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PLAN', @level2type=N'COLUMN',@level2name=N'ErpPlanId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Hr,g�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PLAN', @level2type=N'COLUMN',@level2name=N'Version'
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'TB_PLAN', @level2type=N'COLUMN',@level2name=N'VendId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0W�p' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PLAN', @level2type=N'COLUMN',@level2name=N'Site'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��R{|�W�0���Km��R �1��V�[��R �' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PLAN', @level2type=N'COLUMN',@level2name=N'PlanType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��R;Nh�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PLAN'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��RUS�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PLAN_DETAIL', @level2type=N'COLUMN',@level2name=N'PlanId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�D:�e �W:hT �M�g �' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PLAN_DETAIL', @level2type=N'COLUMN',@level2name=N'PlanPieriod'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'_�Y�eg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PLAN_DETAIL', @level2type=N'COLUMN',@level2name=N'BeginDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�~_g�eg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PLAN_DETAIL', @level2type=N'COLUMN',@level2name=N'EndDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���N�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PLAN_DETAIL', @level2type=N'COLUMN',@level2name=N'PartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PLAN_DETAIL', @level2type=N'COLUMN',@level2name=N'Qty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��Rf�~h�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PLAN_DETAIL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��US�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO', @level2type=N'COLUMN',@level2name=N'PoBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ERP��US�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO', @level2type=N'COLUMN',@level2name=N'ErpBillNum'
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'TB_PO', @level2type=N'COLUMN',@level2name=N'VendId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USnc{|�W(1:�e zUS,2:�yce��US)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO', @level2type=N'COLUMN',@level2name=N'ModType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'T��|�N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO', @level2type=N'COLUMN',@level2name=N'Contacter'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0W�p' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO', @level2type=N'COLUMN',@level2name=N'Site'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-�XT' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO', @level2type=N'COLUMN',@level2name=N'Buyer'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-�XT5u݋' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO', @level2type=N'COLUMN',@level2name=N'BuyerPhone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��f' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��US;Nh�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��US�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL', @level2type=N'COLUMN',@level2name=N'PoBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��USL�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL', @level2type=N'COLUMN',@level2name=N'PoLine'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���N�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL', @level2type=N'COLUMN',@level2name=N'PartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��'peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL', @level2type=N'COLUMN',@level2name=N'PlanQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�]�Speϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL', @level2type=N'COLUMN',@level2name=N'ShippedQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�]6epeϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL', @level2type=N'COLUMN',@level2name=N'ReceivedQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�]�peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL', @level2type=N'COLUMN',@level2name=N'RejectQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'_Ye' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL', @level2type=N'COLUMN',@level2name=N'BeginTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'~_ge' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL', @level2type=N'COLUMN',@level2name=N'EndTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-�USMO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL', @level2type=N'COLUMN',@level2name=N'PoUnit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'X[�PUSMO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL', @level2type=N'COLUMN',@level2name=N'LocUnit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�N<h' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL', @level2type=N'COLUMN',@level2name=N'Price'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'^�y' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL', @level2type=N'COLUMN',@level2name=N'Currency'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'hSpeϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL', @level2type=N'COLUMN',@level2name=N'PackQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��f' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��USf�~h� ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_PO_DETAIL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'USS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE', @level2type=N'COLUMN',@level2name=N'RecvBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��US�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE', @level2type=N'COLUMN',@level2name=N'PoBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�S'USS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE', @level2type=N'COLUMN',@level2name=N'AsnBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0W�p' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE', @level2type=N'COLUMN',@level2name=N'Site'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O'FU Ty' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE', @level2type=N'COLUMN',@level2name=N'VendId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�S'e' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE', @level2type=N'COLUMN',@level2name=N'ShipTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��f' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6RUS�N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE', @level2type=N'COLUMN',@level2name=N'CreateUser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'US;Nh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'USS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE_DETAIL', @level2type=N'COLUMN',@level2name=N'RecvBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��US�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE_DETAIL', @level2type=N'COLUMN',@level2name=N'PoBIllNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��USL�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE_DETAIL', @level2type=N'COLUMN',@level2name=N'PoLine'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���N�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE_DETAIL', @level2type=N'COLUMN',@level2name=N'PartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'yb!k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE_DETAIL', @level2type=N'COLUMN',@level2name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�]�~_gϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE_DETAIL', @level2type=N'COLUMN',@level2name=N'Qty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE_DETAIL', @level2type=N'COLUMN',@level2name=N'DockCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r` 0� NT<h 1�T<h' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE_DETAIL', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6RUS�N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE_DETAIL', @level2type=N'COLUMN',@level2name=N'CreateUser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'f~h' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_RECEIVE_DETAIL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N''USS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT', @level2type=N'COLUMN',@level2name=N'RjctBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��US�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT', @level2type=N'COLUMN',@level2name=N'PoBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�S'USS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT', @level2type=N'COLUMN',@level2name=N'AsnBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0W�p' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT', @level2type=N'COLUMN',@level2name=N'Site'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O'FU Ty' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT', @level2type=N'COLUMN',@level2name=N'VendId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�S'e' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT', @level2type=N'COLUMN',@level2name=N'ShipTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��f' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6RUS�N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT', @level2type=N'COLUMN',@level2name=N'CreateUser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N''US;Nh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N''USS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT_DETAIL', @level2type=N'COLUMN',@level2name=N'RjctBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��US�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT_DETAIL', @level2type=N'COLUMN',@level2name=N'PoBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��USL�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT_DETAIL', @level2type=N'COLUMN',@level2name=N'PoLine'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���N�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT_DETAIL', @level2type=N'COLUMN',@level2name=N'PartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'yb!k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT_DETAIL', @level2type=N'COLUMN',@level2name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N''peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT_DETAIL', @level2type=N'COLUMN',@level2name=N'Qty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r` 0� NT<h 1�T<h' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT_DETAIL', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6RUS�N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT_DETAIL', @level2type=N'COLUMN',@level2name=N'CreateUser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N''f~h' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TB_REJECT_DETAIL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�d\O�N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_BASEDATA', @level2type=N'COLUMN',@level2name=N'UserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�e�_�e��' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_BASEDATA', @level2type=N'COLUMN',@level2name=N'LogTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�e�_{|�W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_BASEDATA', @level2type=N'COLUMN',@level2name=N'LogType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�e�_�~+R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_BASEDATA', @level2type=N'COLUMN',@level2name=N'DataType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�S<P' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_BASEDATA', @level2type=N'COLUMN',@level2name=N'OldValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�e<P' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_BASEDATA', @level2type=N'COLUMN',@level2name=N'NewValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Y�l' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_BASEDATA', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�W@xpenc�O9e�e�_h�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_BASEDATA'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�d\O�N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_BILL', @level2type=N'COLUMN',@level2name=N'UserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�e�_�e��' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_BILL', @level2type=N'COLUMN',@level2name=N'LogTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�e�_{|�W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_BILL', @level2type=N'COLUMN',@level2name=N'LogType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USnc�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_BILL', @level2type=N'COLUMN',@level2name=N'BillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USnc{|�W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_BILL', @level2type=N'COLUMN',@level2name=N'BillType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�e�_�Oo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_BILL', @level2type=N'COLUMN',@level2name=N'Message'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USnc�r`�S�f�e�_h�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_BILL'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�d\OXT�]�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_USER', @level2type=N'COLUMN',@level2name=N'UserId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�d\OXT�Y T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_USER', @level2type=N'COLUMN',@level2name=N'UserName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�e�_�e��' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_USER', @level2type=N'COLUMN',@level2name=N'LogTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�e�_{|�W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_USER', @level2type=N'COLUMN',@level2name=N'LogType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'IPb:ghV T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_USER', @level2type=N'COLUMN',@level2name=N'LogSite'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�e�_�Oo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_USER', @level2type=N'COLUMN',@level2name=N'Message'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�d\OXT�e�_h�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TL_USER'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'h~{�S�yb!k�{t N&^Am4l�S �' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'BarCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�[teh~{�S�yb!k�{t_N&^Am4l�S �' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'FullBarCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���N�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'PartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O�^FU���N�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'VendPartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'yb!k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'u�N�eg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'ProduceDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�{t{|�W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'ManageType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Am4l�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'SerialNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'Qty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1:N�~x 2:�N�~x' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'BarCodeType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-���US�S�u�N��R�S �' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'BillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USncL�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'BillLine'
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'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'VendId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O�^FUyb!k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'VendBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'hSpe' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'PackQty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'R�^�N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'CreateOper'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'R�^�e��' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'CreateTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`�0��_�h �1�T<h �2� NT<h �3�Ǐg �4��_$R�[ �' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Y�l' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'h~{h�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_BARCODE'
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'TS_INFO', @level2type=N'COLUMN',@level2name=N'VendId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0W�p' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_INFO', @level2type=N'COLUMN',@level2name=N'Site'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�Oo`{|�W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_INFO', @level2type=N'COLUMN',@level2name=N'InfoType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'h��' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_INFO', @level2type=N'COLUMN',@level2name=N'Title'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�Oo`�Q�[' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_INFO', @level2type=N'COLUMN',@level2name=N'Infomation'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'D��N�e�N T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_INFO', @level2type=N'COLUMN',@level2name=N'FileName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_INFO', @level2type=N'COLUMN',@level2name=N'state'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�S^�Oo`h�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_INFO'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'h~{�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_STOCK', @level2type=N'COLUMN',@level2name=N'BarCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�^MO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_STOCK', @level2type=N'COLUMN',@level2name=N'LocCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���N�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_STOCK', @level2type=N'COLUMN',@level2name=N'PartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'yb!k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_STOCK', @level2type=N'COLUMN',@level2name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_STOCK', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_STOCK', @level2type=N'COLUMN',@level2name=N'Qty'
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'TS_STOCK', @level2type=N'COLUMN',@level2name=N'VendId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O�^FUyb!k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_STOCK', @level2type=N'COLUMN',@level2name=N'VendBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6e'eg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_STOCK', @level2type=N'COLUMN',@level2name=N'ReceiveTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'u�N�e��' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_STOCK', @level2type=N'COLUMN',@level2name=N'ProduceDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Y�l' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_STOCK', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�S�e�^X[h�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_STOCK'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�c�S{|�W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'InterfaceType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�c�Sh� T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'TableName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USnc{|�W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'BillType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'P[USnc{|�W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'SubBillType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USnc�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'BillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���N�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'PartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'yb!k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'eg�n�^MO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'FromLoc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�vh�^MO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'ToLoc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'eg�nERP�^MO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'FromErpLoc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�vhERP�^MO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'ToErpLoc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'Qty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�S��e��' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'PutTime'
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'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'VendId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-�USMO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'PoUnit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'X[�PUSMO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'LocUnit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'uHe�eg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'ValidDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ERPUSnc�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'ErpBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ERPL��S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'ErpLineNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O�^FUyb!k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'VendBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'
N8nUSncS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'SourceBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'R�^�N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'CreateUser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'R�^�e��' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API', @level2type=N'COLUMN',@level2name=N'CreateTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�c�S��U_h�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�c�S{|�W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'InterfaceType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�c�Sh� T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'TableName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USnc{|�W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'BillType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'P[USnc{|�W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'SubBillType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USnc�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'BillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'���N�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'PartCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'yb!k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'Batch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'eg�n�^MO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'FromLoc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�vh�^MO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'ToLoc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'eg�nERP�^MO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'FromErpLoc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�vhERP�^MO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'ToErpLoc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'peϑ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'Qty'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�S��e��' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'PutTime'
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'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'VendId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ǒ-�USMO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'PoUnit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'X[�PUSMO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'LocUnit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'uHe�eg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'ValidDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ERPUSnc�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'ErpBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ERPL��S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'ErpLineNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�O�^FUyb!k' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'VendBatch'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'
N8nUSncS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'SourceBillNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'R�^�N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'CreateUser'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'R�^�e��' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS', @level2type=N'COLUMN',@level2name=N'CreateTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�c�S��U_�S�Sh�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TS_UNI_API_HIS'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'^�y' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TT_CURRENCY', @level2type=N'COLUMN',@level2name=N'CurrencyId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N''^c' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TT_CURRENCY', @level2type=N'COLUMN',@level2name=N'CurrencyName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TT_CURRENCY', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Y�l' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TT_CURRENCY', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'^�yh�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TT_CURRENCY'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'y��v�S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TT_PROJECT', @level2type=N'COLUMN',@level2name=N'ProjectId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'y��v T�y' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TT_PROJECT', @level2type=N'COLUMN',@level2name=N'ProjectName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TT_PROJECT', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Y�l' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TT_PROJECT', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'y��vh�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TT_PROJECT'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USMO' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TT_UNIT', @level2type=N'COLUMN',@level2name=N'UnitId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'USMO T�y' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TT_UNIT', @level2type=N'COLUMN',@level2name=N'UnitName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'�r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TT_UNIT', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Y�l' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TT_UNIT', @level2type=N'COLUMN',@level2name=N'Remak'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'��ϑUSMOh�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TT_UNIT'
GO
USE [master]
GO
ALTER DATABASE [SCP] SET READ_WRITE
GO