BEGIN; delete from _sys_account2account_plan_data; delete from sys_account2account_plan; delete from _account_plan_data; delete from account_plan; insert into account_plan (id) values (1); insert into _account_plan_data (id,code,name,_table,parent) values (1,'1','ACTIVO',1,NULL); insert into account_plan (id) values (2); insert into _account_plan_data (id,code,name,_table,parent) values (2,'1.1','ACTIVO CORRIENTE',2,1); insert into account_plan (id) values (3); insert into _account_plan_data (id,code,name,_table,parent) values (3,'1.1.1','DISPONIBILIDADES',3,2); insert into account_plan (id) values (4); insert into _account_plan_data (id,code,name,_table,parent) values (4,'1.1.1.1','CAJA',4,3); insert into account_plan (id) values (5); insert into _account_plan_data (id,code,name,_table,parent) values (5,'1.1.1.2','BANCOS',5,3); insert into account_plan (id) values (6); insert into _account_plan_data (id,code,name,_table,parent) values (6,'1.1.2','INVERSIONES CORRIENTES',6,2); insert into account_plan (id) values (7); insert into _account_plan_data (id,code,name,_table,parent) values (7,'1.1.2.1','TÍTULO VALORES',7,6); insert into account_plan (id) values (8); insert into _account_plan_data (id,code,name,_table,parent) values (8,'1.1.2.2','OTRAS INVERSIONES',8,6); insert into account_plan (id) values (9); insert into _account_plan_data (id,code,name,_table,parent) values (9,'1.1.3','CRÉDITOS POR VENTA',9,2); insert into account_plan (id) values (10); insert into _account_plan_data (id,code,name,_table,parent) values (10,'1.1.3.1','DEUDORES POR VENTA',10,9); insert into account_plan (id) values (11); insert into _account_plan_data (id,code,name,_table,parent) values (11,'1.1.3.2','DEUDORES EN GESTIÓN EXTRAJUDICIAL',11,9); insert into account_plan (id) values (12); insert into _account_plan_data (id,code,name,_table,parent) values (12,'1.1.3.3','DEUDORES EN GESTIÓN JUDICIAL',12,9); insert into account_plan (id) values (13); insert into _account_plan_data (id,code,name,_table,parent) values (13,'1.1.3.4','DOCUMENTOS A COBRAR',13,9); insert into account_plan (id) values (14); insert into _account_plan_data (id,code,name,_table,parent) values (14,'1.1.3.5','PREVISIÓN PARA DEUDORES INCOBRABLES',14,9); insert into account_plan (id) values (15); insert into _account_plan_data (id,code,name,_table,parent) values (15,'1.1.4','CRÉDITOS FISCALES Y SOCIALES',15,2); insert into account_plan (id) values (16); insert into _account_plan_data (id,code,name,_table,parent) values (16,'1.1.4.1','SALDO DDJJ IVA A FAVOR',16,15); insert into account_plan (id) values (17); insert into _account_plan_data (id,code,name,_table,parent) values (17,'1.1.4.2','RETENCIONES IVA SUIFRIDAS',17,15); insert into account_plan (id) values (18); insert into _account_plan_data (id,code,name,_table,parent) values (18,'1.1.4.3','CRÉDITO DISCAL IVA',18,15); insert into account_plan (id) values (19); insert into _account_plan_data (id,code,name,_table,parent) values (19,'1.1.5','ANTICIPOS',19,2); insert into account_plan (id) values (20); insert into _account_plan_data (id,code,name,_table,parent) values (20,'1.1.5.1','ANTICIPOS VARIOS',20,19); insert into account_plan (id) values (21); insert into _account_plan_data (id,code,name,_table,parent) values (21,'1.1.5.2','GASTOS PAGADOS POR ADELANTADO',21,19); insert into account_plan (id) values (22); insert into _account_plan_data (id,code,name,_table,parent) values (22,'1.1.5.3','CUENTA PARTICULAR SOCIOS',22,19); insert into account_plan (id) values (23); insert into _account_plan_data (id,code,name,_table,parent) values (23,'1.1.6','BIENES DE CAMBIO',23,2); insert into account_plan (id) values (24); insert into _account_plan_data (id,code,name,_table,parent) values (24,'1.1.6.1','MATERIA PRIMA',24,23); insert into account_plan (id) values (25); insert into _account_plan_data (id,code,name,_table,parent) values (25,'1.1.6.2','PRODUCTOS EN PROCESO',25,23); insert into account_plan (id) values (26); insert into _account_plan_data (id,code,name,_table,parent) values (26,'1.1.6.3','PRODUCTOS TERMINADOS',26,23); insert into account_plan (id) values (27); insert into _account_plan_data (id,code,name,_table,parent) values (27,'1.1.6.4','PRODUCTOS EN CONSIGNACIÓN',27,23); insert into account_plan (id) values (28); insert into _account_plan_data (id,code,name,_table,parent) values (28,'1.2','ACTIVO NO CORRIENTE',28,1); insert into account_plan (id) values (29); insert into _account_plan_data (id,code,name,_table,parent) values (29,'1.2.1','INVERSIONES NO CORRIENTES',29,28); insert into account_plan (id) values (30); insert into _account_plan_data (id,code,name,_table,parent) values (30,'1.2.1.1','TÍTULOS VALORES',30,29); insert into account_plan (id) values (31); insert into _account_plan_data (id,code,name,_table,parent) values (31,'1.2.1.2','INMUEBLES',31,29); insert into account_plan (id) values (32); insert into _account_plan_data (id,code,name,_table,parent) values (32,'1.2.1.99','INMUEBLES - AJTE CBIOS PO ADQ. MONEDA',32,NULL); insert into account_plan (id) values (33); insert into _account_plan_data (id,code,name,_table,parent) values (33,'1.2.2','BIENES DE USO - VALOR DE ORÍGEN',33,28); insert into account_plan (id) values (34); insert into _account_plan_data (id,code,name,_table,parent) values (34,'1.2.2.1','EQUIPOS',34,33); insert into account_plan (id) values (35); insert into _account_plan_data (id,code,name,_table,parent) values (35,'1.2.2.2','INMUEBLES',35,33); insert into account_plan (id) values (36); insert into _account_plan_data (id,code,name,_table,parent) values (36,'1.2.2.3','RODADOS',36,33); insert into account_plan (id) values (37); insert into _account_plan_data (id,code,name,_table,parent) values (37,'1.2.2.99','BIENES DE USO - AJTE CBIOS PO ADQ. MON',37,NULL); insert into account_plan (id) values (38); insert into _account_plan_data (id,code,name,_table,parent) values (38,'1.2.3','AMORTIZACIÓN ACUMULADA BIENES DE USO',38,28); insert into account_plan (id) values (39); insert into _account_plan_data (id,code,name,_table,parent) values (39,'1.2.3.1','A.A. EQUIPOS',39,38); insert into account_plan (id) values (40); insert into _account_plan_data (id,code,name,_table,parent) values (40,'1.2.3.2','A.A. INMUEBLES',40,38); insert into account_plan (id) values (41); insert into _account_plan_data (id,code,name,_table,parent) values (41,'1.2.3.3','A.A. RODADOS',41,38); insert into account_plan (id) values (42); insert into _account_plan_data (id,code,name,_table,parent) values (42,'1.2.3.99','AMORT. ACUM. - CBIOS PO ADQ. MONEDA',42,NULL); insert into account_plan (id) values (43); insert into _account_plan_data (id,code,name,_table,parent) values (43,'2','PASIVO',43,NULL); insert into account_plan (id) values (44); insert into _account_plan_data (id,code,name,_table,parent) values (44,'2.1','PASIVO CORRIENTE',44,43); insert into account_plan (id) values (45); insert into _account_plan_data (id,code,name,_table,parent) values (45,'2.1.1','DEUDAS COMERCIALES',45,44); insert into account_plan (id) values (46); insert into _account_plan_data (id,code,name,_table,parent) values (46,'2.1.1.1','PROVEEDORES',46,45); insert into account_plan (id) values (47); insert into _account_plan_data (id,code,name,_table,parent) values (47,'2.1.1.2','DOCUMENTOS A PAGAR',47,45); insert into account_plan (id) values (48); insert into _account_plan_data (id,code,name,_table,parent) values (48,'2.1.2','DEUDAS BANCARIAS Y FINANCIERAS',48,44); insert into account_plan (id) values (49); insert into _account_plan_data (id,code,name,_table,parent) values (49,'2.1.2.1','DEUDAS BANCARIAS',49,48); insert into account_plan (id) values (50); insert into _account_plan_data (id,code,name,_table,parent) values (50,'2.1.2.2','DEUDAS FINANCIERAS',50,48); insert into account_plan (id) values (51); insert into _account_plan_data (id,code,name,_table,parent) values (51,'2.1.3','DEUDAS FISCALES',51,44); insert into account_plan (id) values (52); insert into _account_plan_data (id,code,name,_table,parent) values (52,'2.1.3.1','IMPUESTO A LAS GANANCIAS - DDJJ A PAGAR',52,51); insert into account_plan (id) values (53); insert into _account_plan_data (id,code,name,_table,parent) values (53,'2.1.3.2','RETENCION GANANCIAS A DEPOSITAR',53,51); insert into account_plan (id) values (54); insert into _account_plan_data (id,code,name,_table,parent) values (54,'2.1.3.3','IVA DÉBITO FISCAL',54,51); insert into account_plan (id) values (55); insert into _account_plan_data (id,code,name,_table,parent) values (55,'2.1.3.4','IVA - SALDO DDJJ A PAGAR',55,51); insert into account_plan (id) values (56); insert into _account_plan_data (id,code,name,_table,parent) values (56,'2.1.3.5','RETENCIÓN IVA A DEPOSITAR',56,51); insert into account_plan (id) values (57); insert into _account_plan_data (id,code,name,_table,parent) values (57,'2.1.3.6','PERCEPCIÓN IVA A DEPOSITAR',57,51); insert into account_plan (id) values (58); insert into _account_plan_data (id,code,name,_table,parent) values (58,'2.1.3.7','DDJJ IIBB',58,51); insert into account_plan (id) values (59); insert into _account_plan_data (id,code,name,_table,parent) values (59,'2.1.3.8','RENTENCIONES INGRESOS BRUTOS A DEPOSITAR',59,51); insert into account_plan (id) values (60); insert into _account_plan_data (id,code,name,_table,parent) values (60,'2.1.3.9','IMPUESTO INMOBILIARIO',60,51); insert into account_plan (id) values (61); insert into _account_plan_data (id,code,name,_table,parent) values (61,'2.1.3.10','COMERCIO E INDUSTRIA',61,NULL); insert into account_plan (id) values (62); insert into _account_plan_data (id,code,name,_table,parent) values (62,'2.1.4','DEUDAS SOCIALES',62,44); insert into account_plan (id) values (63); insert into _account_plan_data (id,code,name,_table,parent) values (63,'2.1.4.1','SUELDOS Y JORNALES A PAGAR',63,62); insert into account_plan (id) values (64); insert into _account_plan_data (id,code,name,_table,parent) values (64,'2.1.4.2','CARGA SOCIALES A PAGAR',64,62); insert into account_plan (id) values (65); insert into _account_plan_data (id,code,name,_table,parent) values (65,'2.1.4.3','PREVISION VACACIONES',65,62); insert into account_plan (id) values (66); insert into _account_plan_data (id,code,name,_table,parent) values (66,'2.1.4.4','PREVISIÓN SAC',66,62); insert into account_plan (id) values (67); insert into _account_plan_data (id,code,name,_table,parent) values (67,'2.1.5','OTROS PASIVOS CP',67,44); insert into account_plan (id) values (68); insert into _account_plan_data (id,code,name,_table,parent) values (68,'2.1.5.1','ANTICIPOS DE CLIENTES',68,67); insert into account_plan (id) values (69); insert into _account_plan_data (id,code,name,_table,parent) values (69,'2.1.6','PREVISIONES',69,44); insert into account_plan (id) values (70); insert into _account_plan_data (id,code,name,_table,parent) values (70,'2.2','PASIVO NO CORRIENTE',70,43); insert into account_plan (id) values (71); insert into _account_plan_data (id,code,name,_table,parent) values (71,'2.2.1','DEUDAS COMERCIALES',71,70); insert into account_plan (id) values (72); insert into _account_plan_data (id,code,name,_table,parent) values (72,'2.2.1.1','PROVEEDORES LARGO PLAZO',72,71); insert into account_plan (id) values (73); insert into _account_plan_data (id,code,name,_table,parent) values (73,'2.2.2','DEUDAS BANCARIAS Y FINANCIERAS',73,70); insert into account_plan (id) values (74); insert into _account_plan_data (id,code,name,_table,parent) values (74,'2.2.2.1','DEUDAS FINANCIERAS LP',74,73); insert into account_plan (id) values (75); insert into _account_plan_data (id,code,name,_table,parent) values (75,'2.2.3','DEUDAS FISCALES',75,70); insert into account_plan (id) values (76); insert into _account_plan_data (id,code,name,_table,parent) values (76,'2.2.3.1','MORATORIA LP',76,75); insert into account_plan (id) values (77); insert into _account_plan_data (id,code,name,_table,parent) values (77,'2.2.4','DEUDAS SOCIALES',77,70); insert into account_plan (id) values (78); insert into _account_plan_data (id,code,name,_table,parent) values (78,'2.2.4.1','INDEMNIZACIONES LP',78,77); insert into account_plan (id) values (79); insert into _account_plan_data (id,code,name,_table,parent) values (79,'2.2.5','PREVISIONES',79,70); insert into account_plan (id) values (80); insert into _account_plan_data (id,code,name,_table,parent) values (80,'2.2.5.1','PREVISIÓN',80,79); insert into account_plan (id) values (81); insert into _account_plan_data (id,code,name,_table,parent) values (81,'3','PATRIMONIO NETO',81,NULL); insert into account_plan (id) values (82); insert into _account_plan_data (id,code,name,_table,parent) values (82,'4','INGRESOS',82,NULL); insert into account_plan (id) values (83); insert into _account_plan_data (id,code,name,_table,parent) values (83,'4.1','INGRESOS OPERATIVOS',83,82); insert into account_plan (id) values (84); insert into _account_plan_data (id,code,name,_table,parent) values (84,'4.1.1','INGRESOS POR VENTA',84,83); insert into account_plan (id) values (85); insert into _account_plan_data (id,code,name,_table,parent) values (85,'4.1.1.1','INGRESOS POR VENTA',85,84); insert into account_plan (id) values (86); insert into _account_plan_data (id,code,name,_table,parent) values (86,'4.1.1.99','INGRESOS X VTA - AJTE PODER ADQ. MONEDA',86,NULL); insert into account_plan (id) values (87); insert into _account_plan_data (id,code,name,_table,parent) values (87,'4.1.2','INGRESOS VARIOS',87,83); insert into account_plan (id) values (88); insert into _account_plan_data (id,code,name,_table,parent) values (88,'4.1.3','INGRESOS FINANCIEROS',88,83); insert into account_plan (id) values (89); insert into _account_plan_data (id,code,name,_table,parent) values (89,'4.1.3.1','INTERESES GANADOS',89,88); insert into account_plan (id) values (90); insert into _account_plan_data (id,code,name,_table,parent) values (90,'4.1.3.2','DIF. DE CAMBIO GANADA',90,88); insert into account_plan (id) values (91); insert into _account_plan_data (id,code,name,_table,parent) values (91,'4.1.3.99','INGRESOS FINANCIEROS - AJTE PO ADQ. MON',91,NULL); insert into account_plan (id) values (92); insert into _account_plan_data (id,code,name,_table,parent) values (92,'4.2','INGRESOS EXTRAORDINARIOS',92,82); insert into account_plan (id) values (93); insert into _account_plan_data (id,code,name,_table,parent) values (93,'4.2.1','RESULTADO VENTA DE ACTIVOS OPERATIVOS',93,92); insert into account_plan (id) values (94); insert into _account_plan_data (id,code,name,_table,parent) values (94,'4.2.1.1','RESULTADO VENTA DE BIENES DE USO',94,93); insert into account_plan (id) values (95); insert into _account_plan_data (id,code,name,_table,parent) values (95,'5','EGRESOS',95,NULL); insert into account_plan (id) values (96); insert into _account_plan_data (id,code,name,_table,parent) values (96,'5.1','EGRESOS OPERATIVOS',96,95); insert into account_plan (id) values (97); insert into _account_plan_data (id,code,name,_table,parent) values (97,'5.1.1','COSTOS VARIABLES',97,96); insert into account_plan (id) values (98); insert into _account_plan_data (id,code,name,_table,parent) values (98,'5.1.1.1','COMPRA DE MATERIA PRIMA Y MATERIALES',98,97); insert into account_plan (id) values (99); insert into _account_plan_data (id,code,name,_table,parent) values (99,'5.1.1.2','SUELDOS Y JORNALES',99,97); insert into account_plan (id) values (100); insert into _account_plan_data (id,code,name,_table,parent) values (100,'5.1.1.3','CARGAS SOCIALES',100,97); insert into account_plan (id) values (101); insert into _account_plan_data (id,code,name,_table,parent) values (101,'5.1.1.4','GASTOS DE PERSONAL',101,97); insert into account_plan (id) values (102); insert into _account_plan_data (id,code,name,_table,parent) values (102,'5.1.1.5','SUELDO ANUAL COMPLEMENTARIO',102,97); insert into account_plan (id) values (103); insert into _account_plan_data (id,code,name,_table,parent) values (103,'5.1.1.6','VACACIONES',103,97); insert into account_plan (id) values (104); insert into _account_plan_data (id,code,name,_table,parent) values (104,'5.1.1.7','AMORTIZACIÓN',104,97); insert into account_plan (id) values (105); insert into _account_plan_data (id,code,name,_table,parent) values (105,'5.1.1.8','HONORARIOS',105,97); insert into account_plan (id) values (106); insert into _account_plan_data (id,code,name,_table,parent) values (106,'5.1.1.9','MANTENIMIENTO',106,97); insert into account_plan (id) values (107); insert into _account_plan_data (id,code,name,_table,parent) values (107,'5.1.1.10','ELECTRICIDAD',107,NULL); insert into account_plan (id) values (108); insert into _account_plan_data (id,code,name,_table,parent) values (108,'5.1.1.11','GAS',108,NULL); insert into account_plan (id) values (109); insert into _account_plan_data (id,code,name,_table,parent) values (109,'5.1.1.12','COMBUSTIBLE',109,NULL); insert into account_plan (id) values (110); insert into _account_plan_data (id,code,name,_table,parent) values (110,'5.1.1.13','GASTOS DE MOVILIDAD Y FLETE',110,NULL); insert into account_plan (id) values (111); insert into _account_plan_data (id,code,name,_table,parent) values (111,'5.1.1.14','INSUMOS DE OFICINA',111,NULL); insert into account_plan (id) values (112); insert into _account_plan_data (id,code,name,_table,parent) values (112,'5.1.1.15','INCOBRABLES',112,NULL); insert into account_plan (id) values (113); insert into _account_plan_data (id,code,name,_table,parent) values (113,'5.1.1.16','IMPUESOS TASAS Y CONTRIBUCIONES',113,NULL); insert into account_plan (id) values (114); insert into _account_plan_data (id,code,name,_table,parent) values (114,'.1.1.17','GASTOS DE PUBLICIDAD',114,NULL); insert into account_plan (id) values (115); insert into _account_plan_data (id,code,name,_table,parent) values (115,'5.1.1.18','CORREO',115,NULL); insert into account_plan (id) values (116); insert into _account_plan_data (id,code,name,_table,parent) values (116,'5.1.1.19','GASTOS VARIOS',116,NULL); insert into account_plan (id) values (117); insert into _account_plan_data (id,code,name,_table,parent) values (117,'5.1.1.20','INTERESES PERDIDOS',117,NULL); insert into account_plan (id) values (118); insert into _account_plan_data (id,code,name,_table,parent) values (118,'5.1.1.21','DIFERENCIA DE CAMBIO PERDIDA',118,NULL); insert into account_plan (id) values (119); insert into _account_plan_data (id,code,name,_table,parent) values (119,'5.1.1.22','GASTOS BANCARIOS',119,NULL); insert into account_plan (id) values (120); insert into _account_plan_data (id,code,name,_table,parent) values (120,'5.1.2','COSTOS FIJOS',120,96); insert into account_plan (id) values (121); insert into _account_plan_data (id,code,name,_table,parent) values (121,'5.1.2.1','ALQUILERES',121,120); insert into account_plan (id) values (122); insert into _account_plan_data (id,code,name,_table,parent) values (122,'5.1.2.2','SEGUROS',122,120); insert into account_plan (id) values (123); insert into _account_plan_data (id,code,name,_table,parent) values (123,'5.1.2.3','SUELDOS Y JORNALES',123,120); insert into account_plan (id) values (124); insert into _account_plan_data (id,code,name,_table,parent) values (124,'5.1.2.4','CARGAS SOCIALES',124,120); insert into account_plan (id) values (125); insert into _account_plan_data (id,code,name,_table,parent) values (125,'5.1.2.5','GASTOS DE PERSONAL',125,120); insert into account_plan (id) values (126); insert into _account_plan_data (id,code,name,_table,parent) values (126,'5.1.2.6','SUELDO ANUAL COMPLEMENTARIO',126,120); insert into account_plan (id) values (127); insert into _account_plan_data (id,code,name,_table,parent) values (127,'5.1.2.7','VACACIONES',127,120); insert into account_plan (id) values (128); insert into _account_plan_data (id,code,name,_table,parent) values (128,'5.1.2.8','AMORTIZACIÓN',128,120); insert into account_plan (id) values (129); insert into _account_plan_data (id,code,name,_table,parent) values (129,'5.1.2.9','HONORARIOS',129,120); insert into account_plan (id) values (130); insert into _account_plan_data (id,code,name,_table,parent) values (130,'5.1.2.10','MANTENIMIENTO',130,NULL); insert into account_plan (id) values (131); insert into _account_plan_data (id,code,name,_table,parent) values (131,'5.1.2.11','ELECTRICIDAD',131,NULL); insert into account_plan (id) values (132); insert into _account_plan_data (id,code,name,_table,parent) values (132,'5.1.2.12','GAS',132,NULL); insert into account_plan (id) values (133); insert into _account_plan_data (id,code,name,_table,parent) values (133,'5.1.2.13','COMBUSTIBLE',133,NULL); insert into account_plan (id) values (134); insert into _account_plan_data (id,code,name,_table,parent) values (134,'5.1.2.14','GASTOS DE MOVILIDAD Y FLETE',134,NULL); insert into account_plan (id) values (135); insert into _account_plan_data (id,code,name,_table,parent) values (135,'5.1.2.15','INSUMOS DE OFICINA',135,NULL); insert into account_plan (id) values (136); insert into _account_plan_data (id,code,name,_table,parent) values (136,'5.1.2.16','INCOBRABLES',136,NULL); insert into account_plan (id) values (137); insert into _account_plan_data (id,code,name,_table,parent) values (137,'5.1.2.17','IMPUESOS TASAS Y CONTRIBUCIONES',137,NULL); insert into account_plan (id) values (138); insert into _account_plan_data (id,code,name,_table,parent) values (138,'5.1.2.18','GASTOS DE PUBLICIDAD',138,NULL); insert into account_plan (id) values (139); insert into _account_plan_data (id,code,name,_table,parent) values (139,'5.1.2.19','CORREO',139,NULL); insert into account_plan (id) values (140); insert into _account_plan_data (id,code,name,_table,parent) values (140,'5.1.2.20','GASTOS VARIOS',140,NULL); insert into account_plan (id) values (141); insert into _account_plan_data (id,code,name,_table,parent) values (141,'5.1.2.21','INTERESES PERDIDOS',141,NULL); insert into account_plan (id) values (142); insert into _account_plan_data (id,code,name,_table,parent) values (142,'5.1.2.22','DIFERENCIA DE CAMBIO PERDIDA',142,NULL); insert into account_plan (id) values (143); insert into _account_plan_data (id,code,name,_table,parent) values (143,'5.1.2.23','GASTOS BANCARIOS',143,NULL); insert into account_plan (id) values (144); insert into _account_plan_data (id,code,name,_table,parent) values (144,'5.2','EGRESOS EXTRAORDINARIOS',144,95); insert into account_plan (id) values (145); insert into _account_plan_data (id,code,name,_table,parent) values (145,'5.2.1','VENTA DE ACTIVOS OPERATIVOS',145,144); insert into account_plan (id) values (146); insert into _account_plan_data (id,code,name,_table,parent) values (146,'5.2.1.1','VENTA DE BIENES DE USO',146,145); insert into account_plan (id) values (147); insert into _account_plan_data (id,code,name,_table,parent) values (147,'5.2.2','OTROS EGRESOS EXTRAORDINARIOS',147,144); insert into account_plan (id) values (148); insert into _account_plan_data (id,code,name,_table,parent) values (148,'5.2.2.1','SINIESTROS',148,147); select setval('"account_plan_id_seq"',149,true); select setval('"_account_plan_data_id_seq"',149,true); insert into sys_account2account_plan (id) values (1); insert into _sys_account2account_plan_data (id,_table,name,account,code) values (1,1,'Impuestos',113,'5.1.1.16%'); insert into sys_account2account_plan (id) values (2); insert into _sys_account2account_plan_data (id,_table,name,account,code) values (2,2,'Proveedores',46,'2.1.1.1%'); insert into sys_account2account_plan (id) values (3); insert into _sys_account2account_plan_data (id,_table,name,account,code) values (3,3,'Clientes',84,'4.1.1%'); insert into sys_account2account_plan (id) values (4); insert into _sys_account2account_plan_data (id,_table,name,account,code) values (4,4,'Productos',23,'1.1.6%'); insert into sys_account2account_plan (id) values (5); insert into _sys_account2account_plan_data (id,_table,name,account,code) values (5,5,'Fisco',51,'2.1.3%'); insert into sys_account2account_plan (id) values (6); insert into _sys_account2account_plan_data (id,_table,name,account,code) values (6,6,'Gastos',96,'5.1%'); COMMIT;