SYCW_API/文档/Sql/sql_20190125...

USE [CallCenter_SanYuanCW]
GO

/****** Object:  Table [dbo].[T_Wo_Bill]    Script Date: 01/25/2019 15:50:24 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[T_Wo_Bill]') AND type in (N'U'))
DROP TABLE [dbo].[T_Wo_Bill]
GO

USE [CallCenter_SanYuanCW]
GO

/****** Object:  Table [dbo].[T_Wo_Bill]    Script Date: 01/25/2019 15:50:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[T_Wo_Bill](
	[F_ID] [int] IDENTITY(1,1) NOT NULL,
	[WorkOrderID] [nvarchar](50) NULL,
	[F_BillType] [nvarchar](200) NULL,
	[F_CusName] [nvarchar](500) NULL,
	[F_TaxIDNum] [nvarchar](500) NULL,
	[F_Address] [nvarchar](2000) NULL,
	[F_Phone] [nvarchar](50) NULL,
	[F_Bank] [nvarchar](1000) NULL,
	[F_BankAccount] [nvarchar](500) NULL,
	[F_ProName] [nvarchar](1000) NULL,
	[F_Models] [nvarchar](500) NULL,
	[F_Unit] [nvarchar](50) NULL,
	[F_Amount] [nvarchar](50) NULL,
	[F_UnitPrice] [nvarchar](50) NULL,
	[F_SumPrice] [nvarchar](50) NULL,
	[F_TaxRate] [nvarchar](50) NULL,
	[F_TaxAmount] [nvarchar](50) NULL,
	[F_BillingMethod] [nvarchar](50) NULL,
	[F_BillingTime] [nvarchar](50) NULL,
	[F_Remark] [nvarchar](2000) NULL,
	[F_CusCode] [nvarchar](100) NULL,
	[F_Openid] [nvarchar](50) NULL,
	[F_CreateOn] [datetime] NULL,
	[F_IsDel] [bit] NULL,
	[F_CreateBy] [nvarchar](50) NULL,
 CONSTRAINT [PK__T_Wo_Bill__3214EC276FD49106] PRIMARY KEY CLUSTERED 
(
	[F_ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工单明细ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_ID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工单ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'WorkOrderID'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发票类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_BillType'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_CusName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'纳税人识别号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_TaxIDNum'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_Address'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_Phone'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开户行' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_Bank'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开户行账号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_BankAccount'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_ProName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'型号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_Models'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_Unit'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_Amount'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_UnitPrice'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_SumPrice'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'税率' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_TaxRate'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'税额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_TaxAmount'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开票方式：快递/自取' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_BillingMethod'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'开票时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_BillingTime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_Remark'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录的公司code' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_CusCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'提交人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_Openid'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'提交时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_CreateOn'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill', @level2type=N'COLUMN',@level2name=N'F_IsDel'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户开票表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Wo_Bill'
GO