USE [ETrade]

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (1, 1, N'Compras', 1, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF1F497D', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (2, 4, N'Salários', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFE18030', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (3, 4, N'Rescisões', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF9ACCFF', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (4, 4, N'Férias', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFCBAFED', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (5, 4, N'Almoço', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFE57572', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (6, 4, N'Despesas viagem', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFE57572', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (7, 4, N'Lanches', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF9ACCFF', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (8, 4, N'Limpeza', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF4BACC6', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (9, 4, N'Exames médicos', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFF79646', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (10, 3, N'Contabilidade ', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF4BACC6', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (11, 3, N'Aluguel', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFCBAFED', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (12, 3, N'Luz', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFF79646', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (13, 3, N'Agua', 0, 0, CAST(N'2021-08-26T09:08:13.020' AS DateTime), 0, N'#FF1E7F99', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (14, 3, N'IPTU', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF6E8E2C', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (15, 3, N'Maquinas de cartão', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFF79646', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (16, 3, N'Computadores', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF6E8E2C', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (17, 3, N'Internet', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF4F81BD', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (18, 3, N'Telefone', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFE18030', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (19, 3, N'Celulares', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF4F81BD', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (20, 3, N'Seguro', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF1E7F99', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (21, 5, N'Sindicato', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFFF9B98', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (22, 5, N'INSS', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF9ACCFF', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (23, 5, N'DARF', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF1F497D', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (24, 5, N'FGTS', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFFF9B98', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (25, 5, N'GPS', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFF79646', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (26, 6, N'Tarifa conta', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFE57572', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (27, 6, N'IOF', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFE18030', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (28, 6, N'Taxas', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF1F497D', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (29, 7, N'Gráfica', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF1F497D', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (30, 7, N'Publicidade', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFF79646', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (31, 8, N'Correio', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFF79646', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (32, 8, N'Transportadora', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF9ACCFF', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (33, 8, N'Automóvel', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFCBAFED', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (34, 8, N'Combustivel', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFC0504D', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (35, 9, N'Material de escritório', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFF79646', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (36, 9, N'Material de limpeza', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFFF9B98', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (37, 10, N'Cheques devolvidos', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFFF9B98', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (38, 10, N'Devoluções de cliente', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF1E7F99', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (39, 11, N'Moveis', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFE57572', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (40, 11, N'Equipamentos', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFE57572', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (41, 11, N'Obras', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF6E8E2C', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (42, 12, N'Pagamento de emprestímo', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF6E8E2C', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (43, 12, N'Juros', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FF1E7F99', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (44, 13, N'Retirada sócio', 0, 0, CAST(N'2020-06-09T08:10:36.897' AS DateTime), 0, N'#FFFF9B98', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (10001, 2, N'Vendas a Vista', 1, 0, CAST(N'2020-06-09T08:10:36.983' AS DateTime), 0, N'#FF478847', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (10002, 2, N'Cheques Compensados', 1, 0, CAST(N'2020-06-09T08:10:36.983' AS DateTime), 0, N'#FF478847', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (10003, 2, N'Cartao de Credito/Debito', 1, 0, CAST(N'2020-06-09T08:10:36.983' AS DateTime), 0, N'#FF478847', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (10004, 2, N'Parcelas Recebidas', 1, 0, CAST(N'2020-06-09T08:10:36.983' AS DateTime), 0, N'#FF478847', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (10005, 2, N'Cheques Devolvidos', 1, 0, CAST(N'2020-06-09T08:10:36.983' AS DateTime), 0, N'#FF478847', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (10006, 2, N'Troco', 1, 0, CAST(N'2020-06-09T08:10:36.983' AS DateTime), 0, N'#FF478847', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (10007, 2, N'Recebimento varias contas', 1, 0, CAST(N'2020-06-09T08:10:36.983' AS DateTime), 0, N'#FF478847', 0);

INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor], [NaoConsiderarDre]) VALUES (10695256, 1, N'Compras', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF1F497D', 0);

INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (1, 1, N'Despesas', 1, CAST(N'2019-11-29T14:15:44.047' AS DateTime), 0);

INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (2, 2, N'Receitas', 1, CAST(N'2015-08-03T04:14:58.007' AS DateTime), 0);

INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (3, 1, N'Estabelecimento', 0, CAST(N'2017-08-11T00:21:21.980' AS DateTime), 0);

INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (4, 1, N'Recursos Humanos', 0, CAST(N'2017-08-11T00:21:45.233' AS DateTime), 0);

INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (5, 1, N'Impostos', 0, CAST(N'2017-08-11T00:21:27.233' AS DateTime), 0);

INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (6, 1, N'Bancária', 0, CAST(N'2017-08-11T00:21:17.860' AS DateTime), 0);

INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (7, 1, N'Marketing', 0, CAST(N'2017-08-11T00:21:32.837' AS DateTime), 0);

INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (8, 1, N'Transporte', 0, CAST(N'2017-08-11T00:21:50.100' AS DateTime), 0);

INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (9, 1, N'Materiais', 0, CAST(N'2017-08-11T00:21:37.863' AS DateTime), 0);

INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (10, 1, N'Perdas', 0, CAST(N'2017-08-11T00:20:29.160' AS DateTime), 0);

INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (11, 1, N'Investimentos', 0, CAST(N'2017-08-11T00:20:36.923' AS DateTime), 0);

INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (12, 1, N'Emprestimos e juros', 0, CAST(N'2017-08-11T00:39:20.810' AS DateTime), 0);

INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (13, 1, N'Retirada', 0, CAST(N'2017-08-11T00:20:50.943' AS DateTime), 0);

INSERT [dbo].[PlanoConta3] ([Codigo], [Nome], [Tipo], [Fixo], [DataAlteracao], [Status]) VALUES (1, N'Despesas', 1, 1, CAST(N'2020-06-09T08:10:37.933' AS DateTime), 0);

INSERT [dbo].[PlanoConta3] ([Codigo], [Nome], [Tipo], [Fixo], [DataAlteracao], [Status]) VALUES (2, N'Receitas', 2, 1, CAST(N'2020-06-09T08:10:37.973' AS DateTime), 0);