SYCW_API/文档/Sql/sql_20190222...

/****** Object:  Table [dbo].[T_Cus_CustomerFinanceLog]    Script Date: 02/21/2019 14:58:17 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[T_Cus_CustomerFinanceLog]') AND type in (N'U'))
DROP TABLE [dbo].[T_Cus_CustomerFinanceLog]
GO

/****** Object:  Table [dbo].[T_Cus_CustomerFinanceLog]    Script Date: 02/21/2019 14:58:18 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[T_Cus_CustomerFinanceLog](
	[F_CusFinLogId] [int] IDENTITY(1,1) NOT NULL,
	[F_CusFinId] [int] NULL,
	[F_CustomerId] [int] NULL,
	[F_CustomerCode] [nvarchar](100) NULL,
	[F_MonthState] [nvarchar](500) NULL,--	本月财税情况：是
	[F_AnnualIncome] [nvarchar](200) NULL,--本年收入（元）
	[F_AnnualProfit] [nvarchar](200) NULL,--本年利润
	[F_AnnualCost] [nvarchar](200) NULL,--本年费用
	[F_AnnualPersonCount] [nvarchar](200) NULL,--本年人数
	[F_AnnualWages] [nvarchar](200) NULL,--本年工资
	[F_QuarterlyCost] [nvarchar](200) NULL,--本季费用
	[F_QuarterlyPersonCount] [nvarchar](200) NULL,--本季人数
	[F_QuarterlyWages] [nvarchar](200) NULL,--本季工资
	[F_QuarterlyIncome] [nvarchar](200) NULL,--本季收入
	[F_QPVAT] [nvarchar](200) NULL,--本季应交税额-增值税
	[F_QPSurtax] [nvarchar](200) NULL,--本季应交税额-附加税
	[F_QPTaxes] [nvarchar](200) NULL,--本季应交税额-企业所得税
	[F_QPConTax] [nvarchar](200) NULL,--本季应交税额-文化事业建设税
	[F_QPPerinTax] [nvarchar](200) NULL,--本季应交税额-个税
	[F_QPStampTax] [nvarchar](200) NULL,--本季应交税额-印花税
	[F_QPOtherTax] [nvarchar](200) NULL,--本季应交税额-其他税额
	[F_Extend1] [nvarchar](2000) NULL,
	[F_Extend2] [nvarchar](2000) NULL,
	[F_Extend3] [nvarchar](2000) NULL,
	[F_Extend4] [nvarchar](2000) NULL,
	[F_Extend5] [nvarchar](2000) NULL,
	[F_Remark1] [ntext] NULL,
	[F_Remark2] [ntext] NULL,
	[F_Remark3] [ntext] NULL,
	[F_CreateBy] [nvarchar](100) NULL,
	[F_CreatedOn] [datetime] NULL,
	[F_DeleteFlag] [smallint] NULL,
 CONSTRAINT [PK_T_Cus_CustomerFinanceLog] PRIMARY KEY CLUSTERED 
(
	[F_CusFinLogId] 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

SET ANSI_PADDING OFF
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'自增ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_CusFinLogId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'财务情况ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_CusFinId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_CustomerId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_CustomerCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本月财税情况' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_MonthState'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年收入（元）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_AnnualIncome'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年利润' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_AnnualProfit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年费用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_AnnualCost'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年人数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_AnnualPersonCount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本年工资' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_AnnualWages'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季费用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_QuarterlyCost'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季人数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_QuarterlyPersonCount'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季工资' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_QuarterlyWages'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季收入' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_QuarterlyIncome'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季应交税额-增值税' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_QPVAT'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季应交税额-附加税' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_QPSurtax'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季应交税额-企业所得税' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_QPTaxes'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季应交税额-文化事业建设税' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_QPConTax'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季应交税额-个税' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_QPPerinTax'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季应交税额-印花税' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_QPStampTax'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'本季应交税额-其他税额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_QPOtherTax'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'扩展字段1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_Extend1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'扩展字段2' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_Extend2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'扩展字段3' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_Extend3'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'扩展字段4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_Extend4'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'扩展字段5' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_Extend5'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_Remark1'
GO

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

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人工号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_CreateBy'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_CreatedOn'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog', @level2type=N'COLUMN',@level2name=N'F_DeleteFlag'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户信息-财税情况日志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Cus_CustomerFinanceLog'
GO