USE [ETrade]
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (1, 1, N'Compras', 1, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF1F497D')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (2, 4, N'Salarios', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFE18030')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (3, 4, N'Rescisoes', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF9ACCFF')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (4, 4, N'Ferias', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFCBAFED')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (5, 4, N'Almoco', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFE57572')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (6, 4, N'Despesas viagem', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFE57572')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (7, 4, N'Lanches', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF9ACCFF')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (8, 4, N'Limpeza', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF4BACC6')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (9, 4, N'Exames medicos', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFF79646')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (10, 3, N'Contabilidade ', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF4BACC6')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (11, 3, N'Aluguel', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFCBAFED')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (12, 3, N'Luz', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFF79646')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (13, 3, N'Agua', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF1E7F99')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (14, 3, N'IPTU', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF6E8E2C')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (15, 3, N'Maquinas de cartao', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFF79646')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (16, 3, N'Computadores', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF6E8E2C')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (17, 3, N'Internet', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF4F81BD')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (18, 3, N'Telefone', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFE18030')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (19, 3, N'Celulares', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF4F81BD')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (20, 3, N'Seguro', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF1E7F99')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (21, 5, N'Sindicato', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFFF9B98')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (22, 5, N'INSS', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF9ACCFF')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (23, 5, N'DARF', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF1F497D')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (24, 5, N'FGTS', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFFF9B98')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (25, 5, N'GPS', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFF79646')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (26, 6, N'Tarifa conta', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFE57572')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (27, 6, N'IOF', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFE18030')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (28, 6, N'Taxas', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF1F497D')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (29, 7, N'Grafica', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF1F497D')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (30, 7, N'Publicidade', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFF79646')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (31, 8, N'Correio', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFF79646')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (32, 8, N'Transportadora', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF9ACCFF')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (33, 8, N'Automovel', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFCBAFED')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (34, 8, N'Combustivel', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFC0504D')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (35, 9, N'Material de escritorio', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFF79646')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (36, 9, N'Material de limpeza', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFFF9B98')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (37, 10, N'Cheques devolvidos', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFFF9B98')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (38, 10, N'Devolucoes de cliente', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF1E7F99')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (39, 11, N'Moveis', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFE57572')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (40, 11, N'Equipamentos', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFE57572')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (41, 11, N'Obras', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF6E8E2C')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (42, 12, N'Pagamento de emprestimo', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF6E8E2C')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (43, 12, N'Juros', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF1E7F99')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (44, 13, N'Retirada socio', 0, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FFFF9B98')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (10001, 2, N'Vendas a Vista', 1, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF478847')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (10002, 2, N'Cheques Compensados', 1, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF478847')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (10003, 2, N'Cartao de Credito/Debito', 1, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF478847')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (10004, 2, N'Parcelas Recebidas', 1, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF478847')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (10005, 2, N'Cheques Devolvidos', 1, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF478847')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (10006, 2, N'Troco', 1, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF478847')
 
INSERT [dbo].[PlanoConta1] ([Codigo], [PlanoConta2__Codigo], [Nome], [Fixo], [Inativo], [DataAlteracao], [Status], [Cor]) VALUES (10007, 2, N'Recebimento varias contas', 1, 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0, N'#FF478847')
 
INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (1, 1, N'Despesas', 1, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
 
INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (2, 2, N'Receitas', 1, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
 
INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (3, 1, N'Estabelecimento', 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
 
INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (4, 1, N'Recursos Humanos', 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
 
INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (5, 1, N'Impostos', 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
 
INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (6, 1, N'Bancaria', 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
 
INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (7, 1, N'Marketing', 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
 
INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (8, 1, N'Transporte', 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
 
INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (9, 1, N'Materiais', 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
 
INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (10, 1, N'Perdas', 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
 
INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (11, 1, N'Investimentos', 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
 
INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (12, 1, N'Emprestimos e juros', 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
 
INSERT [dbo].[PlanoConta2] ([Codigo], [PlanoConta3__Codigo], [Nome], [Fixo], [DataAlteracao], [Status]) VALUES (13, 1, N'Retirada', 0, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
 
INSERT [dbo].[PlanoConta3] ([Codigo], [Nome], [Tipo], [Fixo], [DataAlteracao], [Status]) VALUES (1, N'Despesas', 1, 1, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)
 
INSERT [dbo].[PlanoConta3] ([Codigo], [Nome], [Tipo], [Fixo], [DataAlteracao], [Status]) VALUES (2, N'Receitas', 2, 1, CAST(N'1900-01-01T00:00:00.000' AS DateTime), 0)