USE [TaxAdmin8] GO INSERT [dbo].[Organization] ([ID], [ClientCode], [Name], [Code], [ParentID], [TaxPayerNumber], [RegionID], [StructureID], [IndustryID], [BusinessUnitID], [IsActive], [PLevel], [CreateTime], [UpdateTime], [AreaID], [EnglishName], [Abbreviation], [InvoiceType], [LegalPersonName], [ManufactureAddress], [RegisterAddress], [BankAccountName], [BankAccountNumber], [PhoneNumber], [RegistrationType], [Remark], [Vehicleroutinglocation]) VALUES (N'007e9946-6217-4756-bee3-023d1e4e583f', N'pwc', N'test1234567788', N'EDMOND12345678', N'05f7c09b-8711-4320-be25-89ba438d20c4', N'', N'110100', N'500de3b0-0a5b-492f-81d5-34117ea119ed', N'0', N'5064297b-5a34-4dc3-a0fe-2ab5cdf18c1d', 1, 0, CAST(N'2017-11-21T15:13:41.803' AS DateTime), CAST(N'2017-11-21T15:13:41.803' AS DateTime), N'0bae00f7-96dc-46c8-b6f5-a427616c5bcf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) GO INSERT [dbo].[Organization] ([ID], [ClientCode], [Name], [Code], [ParentID], [TaxPayerNumber], [RegionID], [StructureID], [IndustryID], [BusinessUnitID], [IsActive], [PLevel], [CreateTime], [UpdateTime], [AreaID], [EnglishName], [Abbreviation], [InvoiceType], [LegalPersonName], [ManufactureAddress], [RegisterAddress], [BankAccountName], [BankAccountNumber], [PhoneNumber], [RegistrationType], [Remark], [Vehicleroutinglocation]) VALUES (N'05f7c09b-8711-4320-be25-89ba438d20c4', N'pwc', N'ida测试报表001', N'0111001', NULL, NULL, N'110100', N'd72fd390-742d-4aee-95ef-bc8a641da35b', N'23', NULL, 0, 0, CAST(N'2018-01-11T14:02:52.100' AS DateTime), CAST(N'2018-01-11T14:41:40.197' AS DateTime), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL) GO INSERT [dbo].[Industry] ([ID], [Name], [IsActive], [EnglishName]) VALUES (N'23', N'房地产业', 1, NULL) GO INSERT [dbo].[Industry] ([ID], [Name], [IsActive], [EnglishName]) VALUES (N'0', N'通用行业', 1, NULL) GO INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'100000', NULL, N'中国', N'中国', N'中国', 0, NULL, NULL, N'China', 116.368324, 39.9150848, 1) GO INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110000', N'100000', N'北京市', N'北京', N'中国,北京', 1, NULL, NULL, N'Beijing', 116.405289, 39.9049873, 1) GO INSERT [dbo].[Region] ([ID], [ParentID], [Name], [ShortName], [MergerName], [LevelType], [TelCode], [ZipCode], [PinYin], [Longitude], [Latitude], [IsActive]) VALUES (N'110100', N'110000', N'北京市', N'北京', N'中国,北京,北京市', 2, N'010 ', 100000, N'Beijing', 116.405289, 39.9049873, 1) GO INSERT [dbo].[OrganizationStructure] ([ID], [Name], [IsActive], [CreateTime], [UpdateTime]) VALUES (N'500de3b0-0a5b-492f-81d5-34117ea119ed', N'分公司', 1, CAST(N'2017-04-24T23:31:41.527' AS DateTime), CAST(N'2017-06-20T13:43:33.527' AS DateTime)) GO INSERT [dbo].[OrganizationStructure] ([ID], [Name], [IsActive], [CreateTime], [UpdateTime]) VALUES (N'd72fd390-742d-4aee-95ef-bc8a641da35b', N'11122333445566778899', 1, CAST(N'2017-07-27T16:40:36.010' AS DateTime), CAST(N'2018-02-28T17:47:39.143' AS DateTime)) GO INSERT [dbo].[BusinessUnit] ([ID], [Name], [IsActive], [CreateTime], [UpdateTime]) VALUES (N'5064297b-5a34-4dc3-a0fe-2ab5cdf18c1d', N'月球事业部', 1, CAST(N'2017-06-21T16:15:30.937' AS DateTime), CAST(N'2017-07-13T11:21:48.523' AS DateTime)) GO INSERT [dbo].[OrganizationServiceTemplateGroup] ([ID], [OrganizationID], [ServiceTypeID], [TemplateGroupID]) VALUES (N'92d5b268-86bf-4482-bad6-4fcb86a7cb1f', N'05f7c09b-8711-4320-be25-89ba438d20c4', N'2', N'D7C49ECB-27D8-446D-8AF0-29852763B097') GO INSERT [dbo].[OrganizationServiceTemplateGroup] ([ID], [OrganizationID], [ServiceTypeID], [TemplateGroupID]) VALUES (N'f136d474-1be8-4ba3-ad08-e78c2bed3047', N'05f7c09b-8711-4320-be25-89ba438d20c4', N'6', N'03DE48D6-4980-47B8-A9A4-30484EE62966') GO INSERT [dbo].[TemplateGroup] ([ID], [Name], [ServiceTypeID], [IndustryIDs], [PayTaxType], [GroupType], [CopyFrom], [UpdateTime], [CreateTime], [IsSystemType]) VALUES (N'03DE48D6-4980-47B8-A9A4-30484EE62966', N'企业所得税默认模板1', N'6', N'0', NULL, 1, N'97A5CF03-53D7-49B0-9CD2-B534D6A803D5', CAST(N'2017-10-11T11:55:14.047' AS DateTime), CAST(N'2017-10-11T11:55:14.047' AS DateTime), 0) GO INSERT [dbo].[TemplateGroup] ([ID], [Name], [ServiceTypeID], [IndustryIDs], [PayTaxType], [GroupType], [CopyFrom], [UpdateTime], [CreateTime], [IsSystemType]) VALUES (N'44FCDD85-0CDA-4882-8A16-38FE99CF1FA7', N'ida测试模板002', N'6', N'0', NULL, 1, N'03DE48D6-4980-47B8-A9A4-30484EE62966', CAST(N'2018-01-16T09:41:09.050' AS DateTime), CAST(N'2018-01-16T09:41:09.050' AS DateTime), 0) GO INSERT [dbo].[TemplateGroup] ([ID], [Name], [ServiceTypeID], [IndustryIDs], [PayTaxType], [GroupType], [CopyFrom], [UpdateTime], [CreateTime], [IsSystemType]) VALUES (N'683E89B1-BEC9-458B-ADE0-06343055C751', N'ida测试模板001', N'6', N'0', NULL, 1, N'03DE48D6-4980-47B8-A9A4-30484EE62966', CAST(N'2018-01-16T09:39:50.487' AS DateTime), CAST(N'2018-01-16T09:39:50.487' AS DateTime), 0) GO INSERT [dbo].[TemplateGroup] ([ID], [Name], [ServiceTypeID], [IndustryIDs], [PayTaxType], [GroupType], [CopyFrom], [UpdateTime], [CreateTime], [IsSystemType]) VALUES (N'D7C49ECB-27D8-446D-8AF0-29852763B097', N'PwC_Demo模板', N'2', N'0', 1, 1, N'1F5247ED-72B8-4919-AB06-C13DABE43585', CAST(N'2017-09-28T10:46:58.200' AS DateTime), CAST(N'2017-09-28T10:46:58.200' AS DateTime), 0) GO INSERT [dbo].[EnterpriseAccountSet] ([ID], [Code], [Name], [IsActive], [CreatorID], [CreateTime], [UpdateTime]) VALUES (N'98a60fe3-39f9-4ae5-b5e4-9621c7510e74', N'891288BB-2A51-401E-B63C-45575C779CC1', N'房地产企业账套', 1, N'66933E7B-DA75-4B2E-B7D6-AB65DCA20D50', CAST(N'2017-06-21T09:52:09.930' AS DateTime), CAST(N'2017-06-21T09:52:09.930' AS DateTime)) GO INSERT [dbo].[EnterpriseAccountSetOrg] ([ID], [EnterpriseAccountSetID], [OrganizationID], [EffectiveDate], [ExpiredDate]) VALUES (N'dded0b68-c355-42e6-b894-a885a77bef4e', N'98a60fe3-39f9-4ae5-b5e4-9621c7510e74', N'05f7c09b-8711-4320-be25-89ba438d20c4', CAST(N'2018-01-01T00:00:00.000' AS DateTime), CAST(N'2018-12-31T00:00:00.000' AS DateTime)) GO INSERT [dbo].[ServiceType] ([ID], [Name], [Prefix], [IsActive]) VALUES (N'1', N'后台Administration', N'Admin', 0) GO INSERT [dbo].[ServiceType] ([ID], [Name], [Prefix], [IsActive]) VALUES (N'10', N'递延所得税', N'DTA', 1) GO INSERT [dbo].[ServiceType] ([ID], [Name], [Prefix], [IsActive]) VALUES (N'11', N'税务现金流', N'CF', 1) GO INSERT [dbo].[ServiceType] ([ID], [Name], [Prefix], [IsActive]) VALUES (N'12', N'资产管理增值税服务', N'AssetsManage', 1) GO INSERT [dbo].[ServiceType] ([ID], [Name], [Prefix], [IsActive]) VALUES (N'2', N'增值税申报分析', N'VAT', 1) GO INSERT [dbo].[ServiceType] ([ID], [Name], [Prefix], [IsActive]) VALUES (N'3', N'电子税务管理', N'AM', 0) GO INSERT [dbo].[ServiceType] ([ID], [Name], [Prefix], [IsActive]) VALUES (N'4', N'财务尽职调查', N'FDD', 1) GO INSERT [dbo].[ServiceType] ([ID], [Name], [Prefix], [IsActive]) VALUES (N'5', N'税务管理平台', N'Dashboard', 0) GO INSERT [dbo].[ServiceType] ([ID], [Name], [Prefix], [IsActive]) VALUES (N'6', N'企业所得税', N'CIT', 1) GO INSERT [dbo].[ServiceType] ([ID], [Name], [Prefix], [IsActive]) VALUES (N'7', N'电子税务审计', N'TCS', 0) GO INSERT [dbo].[ServiceType] ([ID], [Name], [Prefix], [IsActive]) VALUES (N'8', N'电子税务审计', N'TaxAudit', 1) GO INSERT [dbo].[ServiceType] ([ID], [Name], [Prefix], [IsActive]) VALUES (N'9', N'关联交易管理', N'RPT', 1) GO