[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[2676] trunk/sql/coa
- Subject: SF.net SVN: ledger-smb:[2676] trunk/sql/coa
- From: ..hidden..
- Date: Sat, 13 Jun 2009 04:30:34 +0000
Revision: 2676
http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2676&view=rev
Author: einhverfr
Date: 2009-06-13 04:30:33 +0000 (Sat, 13 Jun 2009)
Log Message:
-----------
More fixes to charts of accounts files
Modified Paths:
--------------
trunk/sql/coa/cn/chart/General.sql
trunk/sql/coa/co/chart/PUC.sql
trunk/sql/coa/cz/chart/General.sql
trunk/sql/coa/de/chart/DATEV-SKR03.sql
trunk/sql/coa/de/chart/General.sql
trunk/sql/coa/de/chart/SKR03.sql
trunk/sql/coa/dk/chart/General.sql
Modified: trunk/sql/coa/cn/chart/General.sql
===================================================================
--- trunk/sql/coa/cn/chart/General.sql 2009-06-13 04:09:11 UTC (rev 2675)
+++ trunk/sql/coa/cn/chart/General.sql 2009-06-13 04:30:33 UTC (rev 2676)
@@ -1,8 +1,10 @@
begin;
-- Default chart of accounts -- sample only
-SELECT account_save(NULL,'2190','åäæåç','L','', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '1000', 'æåèä', NULL);
+SELECT account_heading_save(NULL, '1800', 'èæèä', NULL);
SELECT account_heading_save(NULL, '2600', 'éæèå', NULL);
SELECT account_heading_save(NULL, '3300', 'èäèæ', NULL);
+SELECT account_heading_save(NULL, '2000', 'æåèå', NULL);
SELECT account_heading_save(NULL, '3500', 'äççé', NULL);
SELECT account_heading_save(NULL, '4000', 'éåçé', NULL);
SELECT account_heading_save(NULL, '4300', 'èèçé', NULL);
@@ -10,18 +12,16 @@
SELECT account_heading_save(NULL, '5000', 'èéææ', NULL);
SELECT account_heading_save(NULL, '5400', 'èèæå', NULL);
SELECT account_heading_save(NULL, '5600', 'æååççæå', NULL);
+SELECT account_heading_save(NULL, '1500', 'åèèä', NULL);
+SELECT account_save(NULL,'2190','åäæåç','L','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1205','åååæ','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL, '1000', 'æåèä', NULL);
-SELECT account_heading_save(NULL, '1800', 'èæèä', NULL);
-SELECT account_save(NULL,'1825','çèåæäæ - èçåèå.','A','', NULL, true,string_to_array('','1', ':'));
-SELECT account_save(NULL,'1845','çèåæäæ - èèåå','A','', NULL, true,string_to_array('','1', ':'));
-SELECT account_heading_save(NULL, '2000', 'æåèå', NULL);
+SELECT account_save(NULL,'1825','çèåæäæ - èçåèå.','A','', NULL, true,string_to_array('', ':'));
+SELECT account_save(NULL,'1845','çèåæäæ - èèåå','A','', NULL, true,string_to_array('', ':'));
SELECT account_save(NULL,'2620','éèåæ','L','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'3600','æåçé','Q','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2160','åäååç','L','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'3590','äççé - ååå','Q','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'3350','æéèä','Q','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL, '1500', 'åèèä', NULL);
SELECT account_save(NULL,'5615','ååèé','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'5790','åå','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'5700','ååçå','E','', NULL, false,string_to_array('AP_amount', ':'));
Modified: trunk/sql/coa/co/chart/PUC.sql
===================================================================
--- trunk/sql/coa/co/chart/PUC.sql 2009-06-13 04:09:11 UTC (rev 2675)
+++ trunk/sql/coa/co/chart/PUC.sql 2009-06-13 04:30:33 UTC (rev 2676)
@@ -36,7 +36,7 @@
SELECT account_heading_save(NULL, '133015', 'ANTICIPO A TRABAJADORES', NULL);
SELECT account_heading_save(NULL, '1340', 'PROMESAS DE COMPRAVENTA', NULL);
SELECT account_heading_save(NULL, '134005', 'DE BIENES RAICES', NULL);
-SELECT account_save(NULL,'1340050001','Promesas Compra Venta Bienes Rai','1340050001','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1340050001','Promesas Compra Venta Bienes Rai','A','1340050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '1345', 'INGRESOS POR COBRAR', NULL);
SELECT account_heading_save(NULL, '1350', 'RETENCIONES SOBRE CONTRATOS', NULL);
SELECT account_heading_save(NULL, '135005', 'DE CONTRATOS DE CONSTRUCCION', NULL);
@@ -44,30 +44,30 @@
SELECT account_heading_save(NULL, '135095', 'RETENCION SOBRE OTROS CONTRATOS', NULL);
SELECT account_heading_save(NULL, '1355', 'ANTICIPO DE IMPUESTOS', NULL);
SELECT account_heading_save(NULL, '135505', 'ANTICIPO DE IMPUESTO DE RENTA', NULL);
-SELECT account_save(NULL,'1355050001','Anticipo de Impuesto de Renta','1355050001','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1355050001','Anticipo de Impuesto de Renta','A','1355050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '135510', 'ANTICIPO DE IMPTO DE IND. Y CCIO', NULL);
-SELECT account_save(NULL,'1355100001','Anticipo de Industria y Comercio','1355100001','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1355100001','Anticipo de Industria y Comercio','A','1355100001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '135515', 'RETENCION EN LA FUENTE', NULL);
-SELECT account_save(NULL,'1355150002','Retefuente 10% Honorarios','1355150002','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1355150004','Retefuente Alquiler Bienes R. 4%','1355150004','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1355150005','Retefuente Obras Civiles 1%','1355150005','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1355150006','Retefuente 6% servicios','1355150006','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1355150007','Retencion en la fuente 3.5%','1355150007','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1355150002','Retefuente 10% Honorarios','A','1355150002', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1355150004','Retefuente Alquiler Bienes R. 4%','A','1355150004', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1355150005','Retefuente Obras Civiles 1%','A','1355150005', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1355150006','Retefuente 6% servicios','A','1355150006', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1355150007','Retencion en la fuente 3.5%','A','1355150007', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '135517', 'IMPUESTO A LAS VENTAS RETENIDO', NULL);
SELECT account_heading_save(NULL, '135518', 'IMPUESTO DE IND. Y CCIO RETENIDO', NULL);
-SELECT account_save(NULL,'1355180001','Ica Retenido','1355180001','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1355180001','Ica Retenido','A','1355180001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '135520', 'SOBRANTE EN LIQUIDACION PRIVADA', NULL);
-SELECT account_save(NULL,'1355200001','Saldo a Favor en Renta','1355200001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1355200002','Sobrante en Declaracion de IVA','1355200002','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1355200001','Saldo a Favor en Renta','A','1355200001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1355200002','Sobrante en Declaracion de IVA','A','1355200002', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '1380', 'DEUDORES VARIOS', NULL);
SELECT account_heading_save(NULL, '138020', 'CUENTAS POR COBRAR A TERCEROS', NULL);
-SELECT account_save(NULL,'1380200001','Cuentas por Cobrar a Terceros','1380200001','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1380200001','Cuentas por Cobrar a Terceros','A','1380200001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '138095', 'OTROS DEUDORES VARIOS', NULL);
-SELECT account_save(NULL,'1380950001','Deudores Varios Otros','1380950001','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1380950001','Deudores Varios Otros','A','1380950001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '1390', 'DEUDAS DE DIFICIL COBRO', NULL);
SELECT account_heading_save(NULL, '1399', 'PROVISIONES', NULL);
SELECT account_heading_save(NULL, '139905', 'PROVISION CLIENTES', NULL);
-SELECT account_save(NULL,'1399050001','Provision cartera Dificil Cobro','1399050001','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1399050001','Provision cartera Dificil Cobro','A','1399050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '14', 'INVENTARIOS', NULL);
SELECT account_heading_save(NULL, '1410', 'PRODUCTOS EN PROCESO', NULL);
SELECT account_heading_save(NULL, '141005', 'PRODUCTOS EN PROCESO', NULL);
@@ -104,28 +104,28 @@
SELECT account_heading_save(NULL, '15249910', 'AJUSTES POR INFLACION', NULL);
SELECT account_heading_save(NULL, '1528', 'EQUIPOS DE COMPUTACION Y COMUNIC', NULL);
SELECT account_heading_save(NULL, '152805', 'EQUIPOS DE PROCESAMIENTO DE DATO', NULL);
-SELECT account_save(NULL,'1528050001','Cinco Computadores','1528050001','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1528050001','Cinco Computadores','A','1528050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '152899', 'AJUSTES POR INFLACION', NULL);
SELECT account_heading_save(NULL, '15289905', 'AJ. INFL. EQ. PROCESAMIENTO DATO', NULL);
-SELECT account_save(NULL,'1528990501','Aj. por Inflac. Cinco Computador','1528990501','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1528990501','Aj. por Inflac. Cinco Computador','A','1528990501', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '1540', 'FLOTA Y EQUIPO DE TRANSPORTE', NULL);
SELECT account_heading_save(NULL, '154005', 'AUTOS, CAMIONETAS Y CAMPEROS', NULL);
SELECT account_heading_save(NULL, '154099', 'AJUSTES POR INFLACION', NULL);
SELECT account_heading_save(NULL, '15409905', 'AJ. INFL. AUTOS CAMPEROS CMIONET', NULL);
-SELECT account_save(NULL,'1540990501','Aj. Infl. Autos y Camperos','1540990501','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1540990501','Aj. Infl. Autos y Camperos','A','1540990501', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '1592', 'DEPRECIACION ACUMULADA', NULL);
SELECT account_heading_save(NULL, '159205', 'DEPREC.DE CONSTRUCCIONES Y EDIFI', NULL);
SELECT account_heading_save(NULL, '159210', 'DEPREC. MAQUINARIA Y EQUIPO', NULL);
SELECT account_heading_save(NULL, '159215', 'DEPRECIACION EQUIPO DE OFICINA', NULL);
SELECT account_heading_save(NULL, '159220', 'DEPRECIACION EQ. COMPUTACION Y C', NULL);
-SELECT account_save(NULL,'1592200001','Depreciacion Cinco Computadores','1592200001','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1592200001','Depreciacion Cinco Computadores','A','1592200001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '159235', 'DEPRECIACION FLOTA DE TRANSPORTE', NULL);
SELECT account_heading_save(NULL, '159299', 'AJUSTES POR INFLACION', NULL);
-SELECT account_save(NULL,'1592990005','Aj.Infl. Construc. y Edificacion','1592990005','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1592990010','Aj.Infl. Maquinaria y Equipo','1592990010','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1592990015','Aj. Infl. Equipos de Oficina','1592990015','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1592990020','Aj. Infl. Eq. Computac. y Comuni','1592990020','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1592990035','Aj. Infl. Flota y Eq. de transpo','1592990035','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1592990005','Aj.Infl. Construc. y Edificacion','A','1592990005', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1592990010','Aj.Infl. Maquinaria y Equipo','A','1592990010', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1592990015','Aj. Infl. Equipos de Oficina','A','1592990015', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1592990020','Aj. Infl. Eq. Computac. y Comuni','A','1592990020', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1592990035','Aj. Infl. Flota y Eq. de transpo','A','1592990035', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '19', 'VALORIZACIONES', NULL);
SELECT account_heading_save(NULL, '1905', 'VALORIZACIONES DE INVERSIONES', NULL);
SELECT account_heading_save(NULL, '1910', 'DE PROPIEDAD PLANTA Y EQUIPOS', NULL);
@@ -135,14 +135,14 @@
SELECT account_heading_save(NULL, '21', 'OBLIGACIONES FINANCIERAS', NULL);
SELECT account_heading_save(NULL, '2105', 'BANCOS NACIONALES', NULL);
SELECT account_heading_save(NULL, '210505', 'SOBREGIROS', NULL);
-SELECT account_save(NULL,'2105050001','Sobregiros Bancarios','2105050001','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2105050001','Sobregiros Bancarios','L','2105050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '210510', 'PAGARES', NULL);
-SELECT account_save(NULL,'2105100001','Pagares','2105100001','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2105100001','Pagares','L','2105100001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '2130', 'ENTIDADES FINANCIERAS DEL EXTERI', NULL);
SELECT account_heading_save(NULL, '2145', 'OBLIGACIONES GUBERNAMENTALES', NULL);
SELECT account_heading_save(NULL, '2195', 'OTRAS OBLIGACIONES', NULL);
SELECT account_heading_save(NULL, '219505', 'OBLIGACIONES CON PARTICULARES', NULL);
-SELECT account_save(NULL,'2195050001','Otras obligaciones con Particula','2195050001','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2195050001','Otras obligaciones con Particula','L','2195050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '219510', 'OBLIGACIONES COMPA?IAS VINCULADA', NULL);
SELECT account_heading_save(NULL, '22', 'PROVEEDORES', NULL);
SELECT account_heading_save(NULL, '2205', 'PROVEEDORES NACIONALES', NULL);
@@ -178,22 +178,22 @@
SELECT account_heading_save(NULL, '236515', 'HONORARIOS', NULL);
SELECT account_heading_save(NULL, '236520', 'COMISIONES', NULL);
SELECT account_heading_save(NULL, '236525', 'SERVICIOS', NULL);
-SELECT account_save(NULL,'2365250002','Servicios Hoteleros 3.5%','2365250002','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2365250002','Servicios Hoteleros 3.5%','L','2365250002', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '236530', 'ARRENDAMIENTOS', NULL);
-SELECT account_save(NULL,'2365300002','Arriendo Inmuebles 4%','2365300002','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2365300002','Arriendo Inmuebles 4%','L','2365300002', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '236535', 'RENDIMIENTOS FINANCIERSO', NULL);
SELECT account_heading_save(NULL, '236540', 'RETENCION POR COMPRAS', NULL);
SELECT account_heading_save(NULL, '2368', 'IMPTO DE IND. Y CCIO RETENIDO', NULL);
SELECT account_heading_save(NULL, '236801', 'SECTOR INDUSTRIAL', NULL);
-SELECT account_save(NULL,'2368010003','Demas Activ. Industriales 7xmil','2368010003','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2368010003','Demas Activ. Industriales 7xmil','L','2368010003', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '236802', 'SECTOR COMERCIAL', NULL);
-SELECT account_save(NULL,'2368020004','Demas Activ. Comerciales 7xmil','2368020004','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2368020004','Demas Activ. Comerciales 7xmil','L','2368020004', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '236803', 'SECTOR SERVICIOS', NULL);
-SELECT account_save(NULL,'2368030001','Retencin ICA 6xMil','2368030001','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2368030009','Demas Activ. Servicios 8xmil','2368030009','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2368030001','Retencin ICA 6xMil','L','2368030001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2368030009','Demas Activ. Servicios 8xmil','L','2368030009', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '2370', 'RETENCIONES Y APORTES DE NOMINA', NULL);
SELECT account_heading_save(NULL, '237005', 'APORTES A EPS', NULL);
-SELECT account_save(NULL,'2370050001','Aportes a EPS','2370050001','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2370050001','Aportes a EPS','L','2370050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '237006', 'APORTES A ARP', NULL);
SELECT account_heading_save(NULL, '237010', 'APORTES A IDBF, SENA Y CAJAS COM', NULL);
SELECT account_heading_save(NULL, '2380', 'ACREEDORES VARIOS', NULL);
@@ -202,17 +202,17 @@
SELECT account_heading_save(NULL, '24', 'IMPUESTOS GRAVAMENES Y TASAS', NULL);
SELECT account_heading_save(NULL, '2404', 'IMPUESTO DE RENTA', NULL);
SELECT account_heading_save(NULL, '240405', 'VIGENCIA FISCAL CORRIENTE', NULL);
-SELECT account_save(NULL,'2404050001','IMPORENTA VIGENCIA ACTUAL','2404050001','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2404050001','IMPORENTA VIGENCIA ACTUAL','L','2404050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '240410', 'VIGENCIAS FISCALES ANTERIORES', NULL);
-SELECT account_save(NULL,'2404100001','IMPORENTA VIGENCIA ANTERIORES','2404100001','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2404100001','IMPORENTA VIGENCIA ANTERIORES','L','2404100001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '2408', 'IMPUESTO A LAS VENTAS POR PAGAR', NULL);
SELECT account_heading_save(NULL, '240805', 'IVA DESCONTABLE', NULL);
SELECT account_heading_save(NULL, '240810', 'IVA GENERADO EN VENTAS', NULL);
SELECT account_heading_save(NULL, '240815', 'IMPUESTOS POR PAGAR ANTERIORES', NULL);
-SELECT account_save(NULL,'2408150001','ViGencia Fiscal Anterior','2408150001','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2408150001','ViGencia Fiscal Anterior','L','2408150001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '2412', 'IMPUESTO DE IND. Y COMERCIO', NULL);
SELECT account_heading_save(NULL, '241205', 'VIGENCIA FISCAL CORRIENTE', NULL);
-SELECT account_save(NULL,'2412050001','ICA POR PAGAR','2412050001','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2412050001','ICA POR PAGAR','L','2412050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '241210', 'VIGENCIAS FISCALES ANTERIORES', NULL);
SELECT account_heading_save(NULL, '25', 'OBLIGACIONES LABORALES', NULL);
SELECT account_heading_save(NULL, '2505', 'SALARIOS POR PAGAR', NULL);
@@ -234,7 +234,7 @@
SELECT account_heading_save(NULL, '261020', 'PRIMA DE SERVICIOS', NULL);
SELECT account_heading_save(NULL, '2615', 'PARA OBLIGACIONES FISCALES', NULL);
SELECT account_heading_save(NULL, '261505', 'DE RENTA Y COMPLEMENTARIOS', NULL);
-SELECT account_save(NULL,'2615050001','Impuesto de Renta y Complementar','2615050001','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2615050001','Impuesto de Renta y Complementar','L','2615050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '261510', 'DE INDUSTRIA Y COMERCIO', NULL);
SELECT account_heading_save(NULL, '261595', 'OTROS', NULL);
SELECT account_heading_save(NULL, '2630', 'PARA MANTENIMIENTO Y REPARACION', NULL);
@@ -245,7 +245,7 @@
SELECT account_heading_save(NULL, '2805', 'ANTICIPOS Y AVANCES RECIBIDOS', NULL);
SELECT account_heading_save(NULL, '280505', 'DE CLIENTES', NULL);
SELECT account_heading_save(NULL, '280510', 'SOBRE CONTRATOS', NULL);
-SELECT account_save(NULL,'2805100001','Anticipo Recibido Sobre Contrato','2805100001','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2805100001','Anticipo Recibido Sobre Contrato','L','2805100001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '280515', 'PARA OBRAS EN PROCESO', NULL);
SELECT account_heading_save(NULL, '2815', 'INGRESOS RECIBIDOS PARA TERCEROS', NULL);
SELECT account_heading_save(NULL, '281505', 'VALORES RECIBIDOS PARA TERCEROS', NULL);
@@ -256,25 +256,25 @@
SELECT account_heading_save(NULL, '31', 'CAPITAL SOCIAL', NULL);
SELECT account_heading_save(NULL, '3105', 'CAPITAL SUSCRITO Y PAGADO', NULL);
SELECT account_heading_save(NULL, '310505', 'CAPITAL AUTORIZADO', NULL);
-SELECT account_save(NULL,'3105050001','Capital Suscrito y Pagado','3105050001','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3105050001','Capital Suscrito y Pagado','Q','3105050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '310510', 'CAPITAL POR SUSCRIBIR (DB)', NULL);
SELECT account_heading_save(NULL, '310515', 'CAPITAL SUSCRITO POR COBRAR (DB)', NULL);
SELECT account_heading_save(NULL, '3115', 'APORTES SOCIALES', NULL);
SELECT account_heading_save(NULL, '33', 'RESERVAS', NULL);
SELECT account_heading_save(NULL, '3305', 'RESERVAS OBLIGATORIAS', NULL);
SELECT account_heading_save(NULL, '330505', 'RESERVA LEGAL', NULL);
-SELECT account_save(NULL,'3305050001','Reserva Legal','3305050001','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3305050001','Reserva Legal','Q','3305050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '3310', 'RESERVAS ESTATUTARIAS', NULL);
SELECT account_heading_save(NULL, '3315', 'RESERVAS OCASIONALES', NULL);
SELECT account_heading_save(NULL, '34', 'REVALORIZACION DEL PATRIMONIO', NULL);
SELECT account_heading_save(NULL, '3405', 'AJUSTES POR INFLACION', NULL);
SELECT account_heading_save(NULL, '340505', 'DE CAPITAL SOCIAL', NULL);
-SELECT account_save(NULL,'3405050001','AxI CAPITAL','3405050001','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3405050001','AxI CAPITAL','Q','3405050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '340510', 'DE SUPERAVIT DE CAPITAL', NULL);
SELECT account_heading_save(NULL, '340515', 'DE RESERVAS', NULL);
-SELECT account_save(NULL,'3405150001','AxI RESERVA LEGAL','3405150001','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3405150001','AxI RESERVA LEGAL','Q','3405150001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '340520', 'DE RESULTADO DE EJERC. ANTERIORE', NULL);
-SELECT account_save(NULL,'3405200001','AxI RESULTADOS ANTERIORES','3405200001','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3405200001','AxI RESULTADOS ANTERIORES','Q','3405200001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '340525', 'DE ACTIVOS DE PERIODO IMPRODUCTI', NULL);
SELECT account_heading_save(NULL, '340530', 'DE SANEAMIENTO FISCAL', NULL);
SELECT account_heading_save(NULL, '340535', 'DE AJUSTES DECRETO 3019 DE 1989', NULL);
@@ -283,25 +283,25 @@
SELECT account_heading_save(NULL, '36', 'RESULTADOS DE EJERCICIO', NULL);
SELECT account_heading_save(NULL, '3605', 'UTILIDAD DEL EJERCICIO', NULL);
SELECT account_heading_save(NULL, '360505', 'UTILIDAD DEL EJERCICIO', NULL);
-SELECT account_save(NULL,'3605050001','Utilidad del Ejercicio','3605050001','Q', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'3605050002','Utilidad de Ajustes por Inflacio','3605050002','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3605050001','Utilidad del Ejercicio','Q','3605050001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3605050002','Utilidad de Ajustes por Inflacio','Q','3605050002', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '3610', 'PERDIDAS DEL EJERCICIO', NULL);
SELECT account_heading_save(NULL, '361005', 'PERDIDA DEL EJERCICIO', NULL);
-SELECT account_save(NULL,'3610050001','Perdida del Ejercicio','3610050001','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3610050001','Perdida del Ejercicio','Q','3610050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '37', 'RESULTADOS EJERCICIOS ANRERIORES', NULL);
SELECT account_heading_save(NULL, '3705', 'UTILIDADES ACUMULADAS', NULL);
SELECT account_heading_save(NULL, '370510', 'UTILIDADES ACUMULADAS', NULL);
-SELECT account_save(NULL,'3705100001','Utilidades Acumuladas','3705100001','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3705100001','Utilidades Acumuladas','Q','3705100001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '3710', 'PERDIDAS ACUMULADAS', NULL);
SELECT account_heading_save(NULL, '371010', 'PERDIDAS ACUMULADAS', NULL);
-SELECT account_save(NULL,'3710100001','Perdidas Acumuladas','3710100001','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3710100001','Perdidas Acumuladas','Q','3710100001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '38', 'SUPERAVIT POR VALORIZACIONES', NULL);
SELECT account_heading_save(NULL, '3805', 'DE INVERSIONES', NULL);
SELECT account_heading_save(NULL, '380505', 'DE ACCIONES', NULL);
SELECT account_heading_save(NULL, '380510', 'CUOTAS O PARTES DE INTERES SOCIA', NULL);
SELECT account_heading_save(NULL, '3810', 'DE PROPIEDAD PLANTA Y EQUIPO', NULL);
SELECT account_heading_save(NULL, '381008', 'CONSTRUCCIONES Y EDIFICACIONES', NULL);
-SELECT account_save(NULL,'3810080001','Superavit por Valorizacion C y E','3810080001','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3810080001','Superavit por Valorizacion C y E','Q','3810080001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '3895', 'DE OTROS ACTIVOS', NULL);
SELECT account_heading_save(NULL, '4', 'INGRESOS', NULL);
SELECT account_heading_save(NULL, '41', 'INGRESOS OPERACIONALES', NULL);
@@ -317,8 +317,8 @@
SELECT account_heading_save(NULL, '415030', 'COMISIONES', NULL);
SELECT account_heading_save(NULL, '4175', 'DEVOLUCIONES EN VENTAS', NULL);
SELECT account_heading_save(NULL, '417505', 'DEVOLUCIONES EN VENTAS', NULL);
-SELECT account_save(NULL,'4175050001','Devoluciones en Ventas','4175050001','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4175050002','Descuento en Ventas','4175050002','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4175050001','Devoluciones en Ventas','I','4175050001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4175050002','Descuento en Ventas','I','4175050002', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '42', 'INGRESOS NO OPERACIONALES', NULL);
SELECT account_heading_save(NULL, '4205', 'OTRAS VENTAS', NULL);
SELECT account_heading_save(NULL, '420505', 'MATERIA PRIMA', NULL);
@@ -326,7 +326,7 @@
SELECT account_heading_save(NULL, '4210', 'INGRESOS FINANCIEROS', NULL);
SELECT account_heading_save(NULL, '421005', 'INTERESES', NULL);
SELECT account_heading_save(NULL, '421040', 'DESCUENTOS COMERCIALES CONDICION', NULL);
-SELECT account_save(NULL,'4210400001','Descuentos Financieros','4210400001','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4210400001','Descuentos Financieros','I','4210400001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '4215', 'DIVIDENDOS Y PARTICIPACIONES', NULL);
SELECT account_heading_save(NULL, '4220', 'ARRENDAMIENTOS', NULL);
SELECT account_heading_save(NULL, '422010', 'CONSTRUCCIONES Y EDIFICACIONES', NULL);
@@ -358,26 +358,26 @@
SELECT account_heading_save(NULL, '4705', 'CORRECCION MONETARIA', NULL);
SELECT account_heading_save(NULL, '470505', 'INVERSIONES (CR)', NULL);
SELECT account_heading_save(NULL, '470510', 'INVENTARIOS (CR)', NULL);
-SELECT account_save(NULL,'4705100005','Inventario Materia Prima','4705100005','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4705100010','Inventario Productos en Proceso','4705100010','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4705100015','Obras de construccion en curso','4705100015','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4705100020','Inventario contratos en ejecucio','4705100020','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4705100030','Inventario Producto terminado','4705100030','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4705100035','Inv. Mercancia no Fabricada','4705100035','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4705100065','Inventarios en transito','4705100065','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705100005','Inventario Materia Prima','I','4705100005', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705100010','Inventario Productos en Proceso','I','4705100010', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705100015','Obras de construccion en curso','I','4705100015', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705100020','Inventario contratos en ejecucio','I','4705100020', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705100030','Inventario Producto terminado','I','4705100030', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705100035','Inv. Mercancia no Fabricada','I','4705100035', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705100065','Inventarios en transito','I','4705100065', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '470515', 'PROPIEDAD PLANTA Y EQUIPO (CR)', NULL);
-SELECT account_save(NULL,'4705150001','Terrenos','4705150001','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4705150003','Construcciones en Curso','4705150003','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4705150004','Maquinaria y Equipo en Montaje','4705150004','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4705150005','Construcciones y Edificaciones','4705150005','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4705150006','Maquinaria y Equipos','4705150006','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4705150007','Equipos de Oficina','4705150007','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4705150008','Equipos de Computacion y comunic','4705150008','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4705150011','Flota y Equipo de transporte','4705150011','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705150001','Terrenos','I','4705150001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705150003','Construcciones en Curso','I','4705150003', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705150004','Maquinaria y Equipo en Montaje','I','4705150004', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705150005','Construcciones y Edificaciones','I','4705150005', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705150006','Maquinaria y Equipos','I','4705150006', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705150007','Equipos de Oficina','I','4705150007', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705150008','Equipos de Computacion y comunic','I','4705150008', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705150011','Flota y Equipo de transporte','I','4705150011', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '470540', 'PATRIMONIO', NULL);
-SELECT account_save(NULL,'4705400001','Aj. por Infl. Patrimonio','4705400001','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705400001','Aj. por Infl. Patrimonio','I','4705400001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '470545', 'DEPRECIACION ACUMULADA (DB)', NULL);
-SELECT account_save(NULL,'4705450001','Depreciacion Acumulada (DB)','4705450001','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4705450001','Depreciacion Acumulada (DB)','I','4705450001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '470550', 'DEPRECIACION DIFERIDA (CR)', NULL);
SELECT account_heading_save(NULL, '470560', 'AMORTIZACION ACUMULADA (DB)', NULL);
SELECT account_heading_save(NULL, '5', 'GASTOS', NULL);
@@ -390,13 +390,13 @@
SELECT account_heading_save(NULL, '520527', 'AUXILIO DE TRANSPORTE', NULL);
SELECT account_heading_save(NULL, '520530', 'CESANTIAS', NULL);
SELECT account_heading_save(NULL, '520533', 'INTERESES SOBRE CESANTIAS', NULL);
-SELECT account_save(NULL,'5205330001','Intereses Sobre Cesantias','5205330001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5205330001','Intereses Sobre Cesantias','E','5205330001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '520536', 'PRIMAS DE SERVICIOS', NULL);
SELECT account_heading_save(NULL, '520539', 'VACACIONES', NULL);
SELECT account_heading_save(NULL, '520548', 'BONIFICACIONES', NULL);
-SELECT account_save(NULL,'5205480001','Bonificaciones a Empleados','5205480001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5205480001','Bonificaciones a Empleados','E','5205480001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '520563', 'CAPACITACION AL PERSONAL', NULL);
-SELECT account_save(NULL,'5205630001','Capacitacion al Personal','5205630001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5205630001','Capacitacion al Personal','E','5205630001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '520568', 'APORTES ARP', NULL);
SELECT account_heading_save(NULL, '520569', 'APORTES EPS', NULL);
SELECT account_heading_save(NULL, '520570', 'APORTES A FONDO DE PENSIONES/CES', NULL);
@@ -404,7 +404,7 @@
SELECT account_heading_save(NULL, '520575', 'APORTES ICBF', NULL);
SELECT account_heading_save(NULL, '520578', 'APORTES SENA', NULL);
SELECT account_heading_save(NULL, '520595', 'OTROS GASTOS DE PERSONAL', NULL);
-SELECT account_save(NULL,'5205950001','Otros Gastos de personal','5205950001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5205950001','Otros Gastos de personal','E','5205950001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '5210', 'HONORARIOS', NULL);
SELECT account_heading_save(NULL, '521005', 'JUNTA DIRECTIVA', NULL);
SELECT account_heading_save(NULL, '521010', 'REVISORIA FISCAL', NULL);
@@ -413,77 +413,77 @@
SELECT account_heading_save(NULL, '521030', 'ASESORIA FINANCIERA', NULL);
SELECT account_heading_save(NULL, '521035', 'ASESORIA TECNICA', NULL);
SELECT account_heading_save(NULL, '521095', 'OTROS HONORARIOS', NULL);
-SELECT account_save(NULL,'5210950001','Estudio y DiseÃo de Planos','5210950001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5210950001','Estudio y DiseÃo de Planos','E','5210950001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '5215', 'IMPUESTOS', NULL);
SELECT account_heading_save(NULL, '521505', 'INDUSTRIA Y COMERCIO', NULL);
-SELECT account_save(NULL,'5215050001','Impuesto de Industria y Comercio','5215050001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5215050001','Impuesto de Industria y Comercio','E','5215050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '521510', 'DE TIMBRES', NULL);
-SELECT account_save(NULL,'5215100001','Impuesto de Timbre','5215100001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5215100001','Impuesto de Timbre','E','5215100001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '521515', 'IMPUESTOS A LA PROPIEDAD RAIZ', NULL);
-SELECT account_save(NULL,'5215200001','DERECHOS SOBRE INSTRUMENTOS PUBL','5215200001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5215200001','DERECHOS SOBRE INSTRUMENTOS PUBL','E','5215200001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '521540', 'IMPUESTOS SOBRE VEHICULOS', NULL);
-SELECT account_save(NULL,'5215400001','Impuestos Sobre Vehiculos','5215400001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5215400001','Impuestos Sobre Vehiculos','E','5215400001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '521595', 'OTROS IMPUESTOS', NULL);
SELECT account_heading_save(NULL, '5220', 'ARRENDAMIENTOS', NULL);
SELECT account_heading_save(NULL, '522010', 'CONSTRUCCIONES U EDIFICACIONES', NULL);
SELECT account_heading_save(NULL, '522015', 'MAQUINARIA Y EQUIPO', NULL);
-SELECT account_save(NULL,'5220150001','Arriendo Maquinaria y Equipo','5220150001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5220150001','Arriendo Maquinaria y Equipo','E','5220150001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '522025', 'EQUIPOS DE COMPUTACION Y COMUNIC', NULL);
-SELECT account_save(NULL,'5220250001','Alquiler Eq. Computacion y Comun','5220250001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5220250001','Alquiler Eq. Computacion y Comun','E','5220250001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '522040', 'FLOTA Y EQUIPO DE TRANSPORTE', NULL);
-SELECT account_save(NULL,'5220400001','Alquiler de Vehiculos y Camiones','5220400001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5220400001','Alquiler de Vehiculos y Camiones','E','5220400001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '5230', 'SEGUROS', NULL);
SELECT account_heading_save(NULL, '523005', 'MANEJO', NULL);
SELECT account_heading_save(NULL, '523010', 'CUMPLIMIENTO', NULL);
-SELECT account_save(NULL,'5230100001','Polizas de Cumplimiento','5230100001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5230100001','Polizas de Cumplimiento','E','5230100001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '523040', 'FLOTA Y EQUIPO DE TRANSPORTE', NULL);
SELECT account_heading_save(NULL, '523075', 'OBLIGATORIO ACCIDENTES DE TRANSI', NULL);
SELECT account_heading_save(NULL, '5235', 'SERVICIOS', NULL);
SELECT account_heading_save(NULL, '523505', 'ASEO Y VIGILANCIA', NULL);
SELECT account_heading_save(NULL, '523515', 'ASSITENCIA TECNICA', NULL);
SELECT account_heading_save(NULL, '523520', 'PROCESAMIENTO ELECTRONICO DE DAT', NULL);
-SELECT account_save(NULL,'5235200001','Procesamiento electronico de Dat','5235200001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5235200001','Procesamiento electronico de Dat','E','5235200001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '523525', 'ACUEDUCTO Y ALCANTARILLADO', NULL);
SELECT account_heading_save(NULL, '523530', 'ENERGIA ELECTRICA', NULL);
SELECT account_heading_save(NULL, '523535', 'TELEFONO', NULL);
SELECT account_heading_save(NULL, '523540', 'CORREO PORTES Y TELEGRAMAS', NULL);
SELECT account_heading_save(NULL, '523545', 'FAX Y TELEX', NULL);
-SELECT account_save(NULL,'5235450001','fax y Telex','5235450001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5235450001','fax y Telex','E','5235450001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '523550', 'TRANSPORTES FLETES Y ACARREOS', NULL);
SELECT account_heading_save(NULL, '523555', 'GAS', NULL);
SELECT account_heading_save(NULL, '523560', 'PUBLICIDAD PROPAGANDA Y PROMOCIO', NULL);
-SELECT account_save(NULL,'5235600001','Publicidad Propaganda y Promocio','5235600001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5235600001','Publicidad Propaganda y Promocio','E','5235600001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '523595', 'OTROS SERVICIOS', NULL);
-SELECT account_save(NULL,'5235950002','Fabricacion y Elaboracion','5235950002','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5235950004','Capacitacion a Contratistas','5235950004','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5235950007','DigitaciÃn y archivo documentos','5235950007','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5235950002','Fabricacion y Elaboracion','E','5235950002', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5235950004','Capacitacion a Contratistas','E','5235950004', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5235950007','DigitaciÃn y archivo documentos','E','5235950007', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '5240', 'GASTOS LEGALES', NULL);
SELECT account_heading_save(NULL, '524005', 'NOTARIALES', NULL);
SELECT account_heading_save(NULL, '524010', 'REGISTRO MERCANTIL', NULL);
-SELECT account_save(NULL,'5240100001','Registro Mercantil','5240100001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5240100001','Registro Mercantil','E','5240100001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '524015', 'TRAMITES Y LICENCIAS', NULL);
SELECT account_heading_save(NULL, '524095', 'OTROS GASTOS LEGALES', NULL);
-SELECT account_save(NULL,'5240950001','Tramite de Vehiculos','5240950001','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5240950003','Sobretasa','5240950003','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5240950004','Dcmtos Varios en Camara Comercio','5240950004','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5240950005','Floio para Libros Legales','5240950005','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5240950006','Impuesto para preservar la Segur','5240950006','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5240950001','Tramite de Vehiculos','E','5240950001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5240950003','Sobretasa','E','5240950003', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5240950004','Dcmtos Varios en Camara Comercio','E','5240950004', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5240950005','Floio para Libros Legales','E','5240950005', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5240950006','Impuesto para preservar la Segur','E','5240950006', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '5245', 'MANTENIMIENTO Y REPARACIONES', NULL);
SELECT account_heading_save(NULL, '524510', 'CONSTRUCCIONES Y EDIFICACIONES', NULL);
-SELECT account_save(NULL,'5245100001','Construcciones y Edificaciones','5245100001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5245100001','Construcciones y Edificaciones','E','5245100001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '524515', 'MAQUINARIA Y EQUIPOS', NULL);
-SELECT account_save(NULL,'5245150001','Equipo de Refrigeracion','5245150001','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5245150002','Equipos de Ingenieria Civil','5245150002','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5245150003','Repuestos y Herramientas','5245150003','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5245150001','Equipo de Refrigeracion','E','5245150001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5245150002','Equipos de Ingenieria Civil','E','5245150002', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5245150003','Repuestos y Herramientas','E','5245150003', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '524520', 'EQUIPO DE OFICINA', NULL);
-SELECT account_save(NULL,'5245200001','Equipo de Oficina','5245200001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5245200001','Equipo de Oficina','E','5245200001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '524525', 'EQUIPO DE COMPUTACION Y COMUNICA', NULL);
-SELECT account_save(NULL,'5245250001','Mtto y Rep. Eq. Computacion y Co','5245250001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5245250001','Mtto y Rep. Eq. Computacion y Co','E','5245250001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '524540', 'FLOTA Y EQUIPO DE TRANSPORTE', NULL);
-SELECT account_save(NULL,'5245400001','Mantenimiento de Vehiculos','5245400001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5245400001','Mantenimiento de Vehiculos','E','5245400001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '5250', 'ADECUACION E INSTALACION', NULL);
SELECT account_heading_save(NULL, '525005', 'INSTALACIONES ELECTRICAS', NULL);
-SELECT account_save(NULL,'5250050001','Instalaciones Electricas','5250050001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5250050001','Instalaciones Electricas','E','5250050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '525010', 'ARREGLOS ORNAMENTALES', NULL);
SELECT account_heading_save(NULL, '525015', 'REPARACIONES LOCATIVAS', NULL);
SELECT account_heading_save(NULL, '525095', 'OTROS ADECUACIONES E INSTALACION', NULL);
@@ -491,253 +491,253 @@
SELECT account_heading_save(NULL, '525505', 'ALOJAMIENTO Y MANUTENCION', NULL);
SELECT account_heading_save(NULL, '525515', 'PASAJES AEREOS', NULL);
SELECT account_heading_save(NULL, '525520', 'PASAJES TERRESTRES', NULL);
-SELECT account_save(NULL,'5255200001','Pasajes Terrestres','5255200001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5255200001','Pasajes Terrestres','E','5255200001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '525595', 'OTROS GASTOS DE VIAJE', NULL);
-SELECT account_save(NULL,'5255950002','Llamadas Telefonicas en Viajes','5255950002','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5255950002','Llamadas Telefonicas en Viajes','E','5255950002', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '5260', 'DEPRECIACIONES', NULL);
SELECT account_heading_save(NULL, '526005', 'CONSTRUCCIONES Y EDIFICACIONES', NULL);
-SELECT account_save(NULL,'5260050001','Depreciacion Locales Tequendama','5260050001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5260050001','Depreciacion Locales Tequendama','E','5260050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '526010', 'MAQUINARIA Y EQUIPO', NULL);
-SELECT account_save(NULL,'5260100001','Depreciacion de maq. y Equipos','5260100001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5260100001','Depreciacion de maq. y Equipos','E','5260100001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '526015', 'EQUIPOS DE OFICINA', NULL);
-SELECT account_save(NULL,'5260150001','Depreciacion Equipos de Oficina','5260150001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5260150001','Depreciacion Equipos de Oficina','E','5260150001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '526020', 'EQUIPOS DE COMPUTACION Y COMUNIC', NULL);
-SELECT account_save(NULL,'5260200001','Depreciacion Eq. de Computacion','5260200001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5260200001','Depreciacion Eq. de Computacion','E','5260200001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '526035', 'FLOTA Y EQUIPO DE TRANSPORTE', NULL);
-SELECT account_save(NULL,'5260350001','Depreciacion de Vehiculos','5260350001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5260350001','Depreciacion de Vehiculos','E','5260350001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '526099', 'AJUSTES POR INLFACION', NULL);
-SELECT account_save(NULL,'5260990005','Aj. Infl. Construcciones y Edif.','5260990005','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5260990010','Aj. Infl. Maquinaria y Equipo','5260990010','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5260990015','Aj. Infl. Equipos de Oficina','5260990015','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5260990020','Aj. Infl. Eq. Computacion y Com.','5260990020','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5260990035','Aj. Infl. Vehiculos','5260990035','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5260990005','Aj. Infl. Construcciones y Edif.','E','5260990005', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5260990010','Aj. Infl. Maquinaria y Equipo','E','5260990010', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5260990015','Aj. Infl. Equipos de Oficina','E','5260990015', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5260990020','Aj. Infl. Eq. Computacion y Com.','E','5260990020', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5260990035','Aj. Infl. Vehiculos','E','5260990035', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '5295', 'GASTOS DIVERSOS', NULL);
SELECT account_heading_save(NULL, '529505', 'COMISIONES', NULL);
SELECT account_heading_save(NULL, '529510', 'LIBROS SUSCRIPCIONES PERIODICOS', NULL);
-SELECT account_save(NULL,'5295100001','Libros Suscripciones periodicos','5295100001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5295100001','Libros Suscripciones periodicos','E','5295100001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '529520', 'GASTOS DE REPRESENTACION Y REL.P', NULL);
-SELECT account_save(NULL,'5295200001','Gastos de Representacion y Rel.P','5295200001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5295200001','Gastos de Representacion y Rel.P','E','5295200001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '529525', 'ELEMENTOS DE ASEO Y CAFETERIA', NULL);
SELECT account_heading_save(NULL, '529530', 'UTILES PAPELERIA Y FOTOCOPIAS', NULL);
SELECT account_heading_save(NULL, '529535', 'COMBUSTIBLES Y LUBRICANTES', NULL);
SELECT account_heading_save(NULL, '529545', 'TAXIS Y BUSES', NULL);
SELECT account_heading_save(NULL, '529550', 'ESTAMPILLAS', NULL);
-SELECT account_save(NULL,'5295500001','Estampillas','5295500001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5295500001','Estampillas','E','5295500001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '529560', 'CASINO Y RESTAURANTE', NULL);
SELECT account_heading_save(NULL, '529565', 'PARQUEADEROS', NULL);
-SELECT account_save(NULL,'5295650001','Parqueaderos','5295650001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5295650001','Parqueaderos','E','5295650001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '529595', 'OTROS GASTOS DIVERSOS', NULL);
-SELECT account_save(NULL,'5295950001','Cargue y Decargue de Materiales','5295950001','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5295950002','Autenticaciones','5295950002','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5295950004','Ajuste al Peso','5295950004','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5295950001','Cargue y Decargue de Materiales','E','5295950001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5295950002','Autenticaciones','E','5295950002', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5295950004','Ajuste al Peso','E','5295950004', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '5299', 'PROVISIONES', NULL);
SELECT account_heading_save(NULL, '529910', 'DEUDORES', NULL);
-SELECT account_save(NULL,'5299100001','Provision Deudas Dificil Recaudo','5299100001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5299100001','Provision Deudas Dificil Recaudo','E','5299100001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '53', 'GASTOS NO OPERACIONALES', NULL);
SELECT account_heading_save(NULL, '5305', 'GASTOS FINANCIEROS', NULL);
SELECT account_heading_save(NULL, '530505', 'GASTOS BANCARIOS', NULL);
-SELECT account_save(NULL,'5305050001','Gastos Bancarios','5305050001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5305050001','Gastos Bancarios','E','5305050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '530515', 'COMISIONES', NULL);
-SELECT account_save(NULL,'5305150001','Comisiones Bancarias','5305150001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5305150001','Comisiones Bancarias','E','5305150001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '530520', 'INTERESES', NULL);
-SELECT account_save(NULL,'5305200001','Intereses Corriente Ptmos Bancar','5305200001','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5305200002','Intereses por Sobregiro Bancario','5305200002','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5305200003','Intereses de Mora','5305200003','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5305200001','Intereses Corriente Ptmos Bancar','E','5305200001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5305200002','Intereses por Sobregiro Bancario','E','5305200002', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5305200003','Intereses de Mora','E','5305200003', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '5315', 'GASTOS EXTRAORDINARIOS', NULL);
SELECT account_heading_save(NULL, '531520', 'IMPUESTOS ASUMIDOS', NULL);
-SELECT account_save(NULL,'5315200001','Impuestos Asumidos','5315200001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5315200001','Impuestos Asumidos','E','5315200001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '531595', 'OTROS GASTOS EXTRAORDINARIOS', NULL);
SELECT account_heading_save(NULL, '5395', 'GASTOS DIVERSOS', NULL);
SELECT account_heading_save(NULL, '539520', 'MULTAS SANCIONES Y LITIGIOS', NULL);
-SELECT account_save(NULL,'5395200001','Multas Sanciones y Litigios','5395200001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5395200001','Multas Sanciones y Litigios','E','5395200001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '54', 'IMPUESTO DE RENTA Y COMPLEMENTAR', NULL);
SELECT account_heading_save(NULL, '5405', 'IMPUESTO DE RENTA Y COMPLEMENTAR', NULL);
SELECT account_heading_save(NULL, '540505', 'IMPUESTO DE RENTA Y COMPLEMENTAR', NULL);
-SELECT account_save(NULL,'5405050001','Impuesto de Renta y Complementar','5405050001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5405050001','Impuesto de Renta y Complementar','E','5405050001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '6', 'COSTO DE VENTA', NULL);
SELECT account_heading_save(NULL, '61', 'COSTO DE VENTAS Y PREST. SERVICI', NULL);
SELECT account_heading_save(NULL, '6135', 'COMERCIO AL POR MAYOR Y MENOR', NULL);
SELECT account_heading_save(NULL, '613554', 'VTA MAQ. EQ. OFIC. Y SOFTWARE', NULL);
-SELECT account_save(NULL,'6135540001','Costo de Ventas','6135540001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6135540001','Costo de Ventas','E','6135540001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '62', 'COMPRAS', NULL);
SELECT account_heading_save(NULL, '6205', 'COMPRA DE MERCANCIA', NULL);
SELECT account_heading_save(NULL, '6210', 'COMPRA DE MATERIA PRIMA', NULL);
SELECT account_heading_save(NULL, '621001', 'COMPRA DE MATERIA PRIMA', NULL);
-SELECT account_save(NULL,'1305050002','Clientes Nacionales','1305050002','A', NULL, false,string_to_array('AR', ':'));
-SELECT account_save(NULL,'2408050001','Iva Descontable en compras 16%','2408050001','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2408050002','Iva Descontable en servicios 16%','2408050002','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2408050003','Iva Descontable Arri. y Hotel 7%','2408050003','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2408050004','Iva Descontable en Tiquetes 8%','2408050004','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2408050005','Iva Descontable en Servicios 20%','2408050005','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2408050010','Iva Descon. Reg. Simplif. 12%','2408050010','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'1305050001','Clientes Nacionales','1305050001','A', NULL, false,string_to_array('AR', ':'));
-SELECT account_save(NULL,'1330050001','Anticipo a Proveedores','1330050001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1350950001','Contratos de Consultoria','1350950001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1465050001','Inventarios en Transito','1465050001','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'2205050002','Proveedores Nacionales','2205050002','L', NULL, false,string_to_array('AP', ':'));
-SELECT account_save(NULL,'2320050001','Cuentas por pagar a Contratistas','2320050001','L', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'1305050002','Clientes Nacionales','A','1305050002', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'2408050001','Iva Descontable en compras 16%','L','2408050001', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2408050002','Iva Descontable en servicios 16%','L','2408050002', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2408050003','Iva Descontable Arri. y Hotel 7%','L','2408050003', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2408050004','Iva Descontable en Tiquetes 8%','L','2408050004', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2408050005','Iva Descontable en Servicios 20%','L','2408050005', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2408050010','Iva Descon. Reg. Simplif. 12%','L','2408050010', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1305050001','Clientes Nacionales','A','1305050001', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'1330050001','Anticipo a Proveedores','A','1330050001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1350950001','Contratos de Consultoria','A','1350950001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1465050001','Inventarios en Transito','A','1465050001', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'2205050002','Proveedores Nacionales','L','2205050002', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'2320050001','Cuentas por pagar a Contratistas','L','2320050001', NULL, false,string_to_array('AP', ':'));
SELECT account_heading_save(NULL, '2315', 'A COMPA??AS VINCULADAS', NULL);
-SELECT account_save(NULL,'2335950001','Gastos Causados por Pagar','2335950001','L', NULL, false,string_to_array('AP', ':'));
-SELECT account_save(NULL,'2205050001','Proveedores Nacionales','2205050001','L', NULL, false,string_to_array('AP', ':'));
-SELECT account_save(NULL,'2365150002','Honorarios Persona Natural 11%','2365150002','L', NULL, false,string_to_array('AP_tax:IC_taxservice', ':'));
-SELECT account_save(NULL,'2365150003','Honorarios Persona Juridica 10%','2365150003','L', NULL, false,string_to_array('AP_tax:IC_taxservice', ':'));
-SELECT account_save(NULL,'5105480001','Bonificaciones a Empleados','5105480001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2335950001','Gastos Causados por Pagar','L','2335950001', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'2205050001','Proveedores Nacionales','L','2205050001', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'2365150002','Honorarios Persona Natural 11%','L','2365150002', NULL, false,string_to_array('AP_tax:IC_taxservice', ':'));
+SELECT account_save(NULL,'2365150003','Honorarios Persona Juridica 10%','L','2365150003', NULL, false,string_to_array('AP_tax:IC_taxservice', ':'));
+SELECT account_save(NULL,'5105480001','Bonificaciones a Empleados','E','5105480001', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '142005', 'CONTRATOS EN EJECUCION', NULL);
-SELECT account_save(NULL,'5220100001','Arriendo Casa','5220100001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5255950001','Taxis y Buses','5255950001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5235550001','Gas','5235550001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5255150001','Pasajes Aereos','5255150001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5235250001','Acueducto y Alcantarilldo','5235250001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'2368030002','Retencion ICA 8xMil','2368030002','L', NULL, false,string_to_array('AP_tax:IC_taxservice', ':'));
-SELECT account_save(NULL,'2380950001','Cuentas por pagar','2380950001','L', NULL, false,string_to_array('AP', ':'));
-SELECT account_save(NULL,'1330100001','Anticipo a Contratistas','1330100001','A', NULL, false,string_to_array('AR', ':'));
-SELECT account_save(NULL,'2408050006','IVA Descontable en compras 20% ','2408050006','L', NULL, false,string_to_array('IC_taxservice', ':'));
-SELECT account_save(NULL,'5295950003','Compra de Medicina Contratistas','5295950003','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5295600001','Casino y Restaurante','5295600001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5295450001','Taxis y Buses Urbanos','5295450001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5295350001','Combustibles y lubricantes','5295350001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5295050001','Comisiones','5295050001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5255950003','Tasa Aeroportuaria','5255950003','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5255050001','Alojamiento y Manutencion','5255050001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5250150001','Reparaciones Locativas','5250150001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5240950002','Exp. Certif. Libertad y tradicio','5240950002','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5240150001','Tramites y Licencias','5240150001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5235950006','Mano de Obra OBRAS CIVILES','5235950006','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5235950005','Jardineria','5235950005','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5235950003','Digitacion de Planos','5235950003','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5235950001','Pintura','5235950001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5235500001','Transportes Fletes y Acarreos','5235500001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5235400001','Correo Portes y Telegramas','5235400001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5235150001','Asistencia tecnica','5235150001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5235050001','Aseo y Vigilancia','5235050001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5215950001','Impuesto de 3 por Mil','5215950001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5215150001','Impuestos a la Propiedad raiz','5215150001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5210950003','Asesoria Administrativa y de Mer','5210950003','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5210950002','Asesoria Contable','5210950002','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5210250001','Asesorias Juridicas','5210250001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5205780001','Aportes SENA','5205780001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5205750001','Aportes ICBF','5205750001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5205720001','Aportes cajas de Compensacion','5205720001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5205700001','Aportes fondo de Pensiones y Ces','5205700001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5205690001','Aportes EPS','5205690001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5205680001','Aportes ARP','5205680001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5205390001','Vacaciones','5205390001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5205360001','Primas de Servicios','5205360001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5205300001','Cesantias','5205300001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'5205270001','Auxilio de transporte','5205270001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'4295050001','Aprovechamiento Material Sobrant','4295050001','I', NULL, false,string_to_array('IC_sale:IC_income', ':'));
-SELECT account_save(NULL,'4210050001','Intereses por Rendimientos Finan','4210050001','I', NULL, false,string_to_array('IC_income', ':'));
-SELECT account_save(NULL,'2408100001','Iva Generado por Ingresos 16%','2408100001','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2408100002','Iva Generado por Ingresos 7%','2408100002','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'6210010001','Compra de Materia Prima','6210010001','E', NULL, false,string_to_array('IC_cogs', ':'));
-SELECT account_save(NULL,'2365400002','Compra Combustibles y Lub. 0.1%','2365400002','L', NULL, false,string_to_array('IC_taxservice', ':'));
-SELECT account_save(NULL,'2365400001','Compras en General 3.5%','2365400001','L', NULL, false,string_to_array('IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2365300004','Arriendo Maq. Obra Civil 2%','2365300004','L', NULL, false,string_to_array('IC_taxservice', ':'));
-SELECT account_save(NULL,'2365300003','Arriendo Bienes Muebles 4%','2365300003','L', NULL, false,string_to_array('IC_taxservice', ':'));
-SELECT account_save(NULL,'2365300001','Arriendo Inmuebles 3.5%','2365300001','L', NULL, false,string_to_array('IC_taxservice', ':'));
-SELECT account_save(NULL,'2365250004','Construccion Obra Civil 1%','2365250004','L', NULL, false,string_to_array('IC_taxservice', ':'));
-SELECT account_save(NULL,'2365250003','Transporte de Carga 1%','2365250003','L', NULL, false,string_to_array('IC_taxservice', ':'));
-SELECT account_save(NULL,'2365250001','Servicios en General 6%','2365250001','L', NULL, false,string_to_array('IC_taxservice', ':'));
-SELECT account_save(NULL,'2365200001','Retencion Comision del 11%','2365200001','L', NULL, false,string_to_array('IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2365150001','Honorarios Persona Natural 10%','2365150001','L', NULL, false,string_to_array('AP_tax:IC_taxservice', ':'));
-SELECT account_save(NULL,'5295300001','Utiles Papeleria y Fotocopias','5295300001','E', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'5295250001','Elementos de Aseo y Cafeteria','5295250001','E', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'5235300001','Energia Electrica','5235300001','E', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'5235350001','Telefono','5235350001','E', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'1355150003','Retefuente 7% Rendimientos Finan','1355150003','A', NULL, false,string_to_array('IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'1355150001','Retefuente 2% Factor multiplicad','1355150001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1355170001','Iva Retenido 75% de 16%','1355170001','A', NULL, false,string_to_array('IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2365150004','Honorarios Persona Juridica 11%','2365150004','L', NULL, false,string_to_array('CT_tax', ':'));
-SELECT account_save(NULL,'2367050001','Iva retenido reg simplif 12% ','236705','L', NULL, false,string_to_array('AP_tax', ':'));
+SELECT account_save(NULL,'5220100001','Arriendo Casa','E','5220100001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5255950001','Taxis y Buses','E','5255950001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5235550001','Gas','E','5235550001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5255150001','Pasajes Aereos','E','5255150001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5235250001','Acueducto y Alcantarilldo','E','5235250001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'2368030002','Retencion ICA 8xMil','L','2368030002', NULL, false,string_to_array('AP_tax:IC_taxservice', ':'));
+SELECT account_save(NULL,'2380950001','Cuentas por pagar','L','2380950001', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'1330100001','Anticipo a Contratistas','A','1330100001', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'2408050006','IVA Descontable en compras 20% ','L','2408050006', NULL, false,string_to_array('IC_taxservice', ':'));
+SELECT account_save(NULL,'5295950003','Compra de Medicina Contratistas','E','5295950003', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5295600001','Casino y Restaurante','E','5295600001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5295450001','Taxis y Buses Urbanos','E','5295450001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5295350001','Combustibles y lubricantes','E','5295350001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5295050001','Comisiones','E','5295050001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5255950003','Tasa Aeroportuaria','E','5255950003', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5255050001','Alojamiento y Manutencion','E','5255050001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5250150001','Reparaciones Locativas','E','5250150001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5240950002','Exp. Certif. Libertad y tradicio','E','5240950002', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5240150001','Tramites y Licencias','E','5240150001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5235950006','Mano de Obra OBRAS CIVILES','E','5235950006', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5235950005','Jardineria','E','5235950005', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5235950003','Digitacion de Planos','E','5235950003', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5235950001','Pintura','E','5235950001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5235500001','Transportes Fletes y Acarreos','E','5235500001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5235400001','Correo Portes y Telegramas','E','5235400001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5235150001','Asistencia tecnica','E','5235150001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5235050001','Aseo y Vigilancia','E','5235050001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5215950001','Impuesto de 3 por Mil','E','5215950001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5215150001','Impuestos a la Propiedad raiz','E','5215150001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5210950003','Asesoria Administrativa y de Mer','E','5210950003', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5210950002','Asesoria Contable','E','5210950002', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5210250001','Asesorias Juridicas','E','5210250001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5205780001','Aportes SENA','E','5205780001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5205750001','Aportes ICBF','E','5205750001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5205720001','Aportes cajas de Compensacion','E','5205720001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5205700001','Aportes fondo de Pensiones y Ces','E','5205700001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5205690001','Aportes EPS','E','5205690001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5205680001','Aportes ARP','E','5205680001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5205390001','Vacaciones','E','5205390001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5205360001','Primas de Servicios','E','5205360001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5205300001','Cesantias','E','5205300001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'5205270001','Auxilio de transporte','E','5205270001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'4295050001','Aprovechamiento Material Sobrant','I','4295050001', NULL, false,string_to_array('IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'4210050001','Intereses por Rendimientos Finan','I','4210050001', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'2408100001','Iva Generado por Ingresos 16%','L','2408100001', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2408100002','Iva Generado por Ingresos 7%','L','2408100002', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'6210010001','Compra de Materia Prima','E','6210010001', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'2365400002','Compra Combustibles y Lub. 0.1%','L','2365400002', NULL, false,string_to_array('IC_taxservice', ':'));
+SELECT account_save(NULL,'2365400001','Compras en General 3.5%','L','2365400001', NULL, false,string_to_array('IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2365300004','Arriendo Maq. Obra Civil 2%','L','2365300004', NULL, false,string_to_array('IC_taxservice', ':'));
+SELECT account_save(NULL,'2365300003','Arriendo Bienes Muebles 4%','L','2365300003', NULL, false,string_to_array('IC_taxservice', ':'));
+SELECT account_save(NULL,'2365300001','Arriendo Inmuebles 3.5%','L','2365300001', NULL, false,string_to_array('IC_taxservice', ':'));
+SELECT account_save(NULL,'2365250004','Construccion Obra Civil 1%','L','2365250004', NULL, false,string_to_array('IC_taxservice', ':'));
+SELECT account_save(NULL,'2365250003','Transporte de Carga 1%','L','2365250003', NULL, false,string_to_array('IC_taxservice', ':'));
+SELECT account_save(NULL,'2365250001','Servicios en General 6%','L','2365250001', NULL, false,string_to_array('IC_taxservice', ':'));
+SELECT account_save(NULL,'2365200001','Retencion Comision del 11%','L','2365200001', NULL, false,string_to_array('IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2365150001','Honorarios Persona Natural 10%','L','2365150001', NULL, false,string_to_array('AP_tax:IC_taxservice', ':'));
+SELECT account_save(NULL,'5295300001','Utiles Papeleria y Fotocopias','E','5295300001', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5295250001','Elementos de Aseo y Cafeteria','E','5295250001', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5235300001','Energia Electrica','E','5235300001', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5235350001','Telefono','E','5235350001', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'1355150003','Retefuente 7% Rendimientos Finan','A','1355150003', NULL, false,string_to_array('IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1355150001','Retefuente 2% Factor multiplicad','A','1355150001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1355170001','Iva Retenido 75% de 16%','A','1355170001', NULL, false,string_to_array('IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2365150004','Honorarios Persona Juridica 11%','L','2365150004', NULL, false,string_to_array('CT_tax', ':'));
+SELECT account_save(NULL,'2367050001','Iva retenido reg simplif 12% ','L','236705', NULL, false,string_to_array('AP_tax', ':'));
SELECT account_heading_save(NULL, '236710', 'IVA RETENIDO AL REGIMEN COMUN ', NULL);
SELECT account_heading_save(NULL, '236705', 'IVA RETENIDO AL REGIMEN SIMPLIF. ', NULL);
SELECT account_heading_save(NULL, '2367', 'IMPUESTO A LAS VENTAS RETENIDO', NULL);
-SELECT account_save(NULL,'4295810001','Ajuste al Peso','4295810001','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5240050001','Gastos Notariales','5240050001','E', NULL, false,string_to_array('IC_expense', ':'));
-SELECT account_save(NULL,'429581001','Ajuste','429581001','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4130950001','Consultorias','4130950001','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
-SELECT account_save(NULL,'4130100001','Ingresos por Obras Civiles','4130100001','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
-SELECT account_save(NULL,'4130950002','Interventorias','4130950002','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
-SELECT account_save(NULL,'4220100001','Arriendo de locales y oficinas','4220100001','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
-SELECT account_save(NULL,'4220150001','Arriendo de Maquinaria y Equipos','4220150001','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'4295810001','Ajuste al Peso','I','4295810001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5240050001','Gastos Notariales','E','5240050001', NULL, false,string_to_array('IC_expense', ':'));
+SELECT account_save(NULL,'429581001','Ajuste','I','429581001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4130950001','Consultorias','I','4130950001', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'4130100001','Ingresos por Obras Civiles','I','4130100001', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'4130950002','Interventorias','I','4130950002', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'4220100001','Arriendo de locales y oficinas','I','4220100001', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'4220150001','Arriendo de Maquinaria y Equipos','I','4220150001', NULL, false,string_to_array('AR_amount:IC_income', ':'));
INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4235950001', 'Algo',
'A', 'I', 'AR_amount:IC_income', '4235950001');
-SELECT account_save(NULL,'5205060001','Sueldos de Personal','5205060001','E', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_save(NULL,'2370060001','Aportes a ARP','2370060001','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2380950002','Otros Acreedores Varios','2380950001','L', NULL, false,string_to_array('AP', ':'));
-SELECT account_save(NULL,'2335300001','Servicios Tecnicos','2335300001','L', NULL, false,string_to_array('AP', ':'));
-SELECT account_save(NULL,'2370100001','Aportes a Sena, icbf y Cajas com','2370100001','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2380300001','Fondos de Cesantias y/o Pension','2380300001','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2505050001','Salarios por Pagar','2505050001','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2610050001','Cesantias','2610050001','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2610100001','Intereses Sobre Cesantias','2610100001','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2610150001','Vacaciones','2610150001','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2610200001','Prima de Servicios','2610200001','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2367100001','Iva retenido al reg comun 16% ','236710','L', NULL, false,string_to_array('CT_tax', ':'));
-SELECT account_save(NULL,'2367050002','Iva retenido Reg Simp.del 7% ','236705','L', NULL, false,string_to_array('IC_taxservice', ':'));
-SELECT account_save(NULL,'2367100002','Iva retenido al reg comun 20% ','236710','L', NULL, false,string_to_array('IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2367100003','Iva retenido al reg comun del 7% ','236710','L', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'1410990001','Aj. por Inflacion Inv. en Proces','1410990001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1465990001','Aj.por Infl. Inv. en Transito','1465990001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1330150001','Anticipo a Trabajadores','1330150001','A', NULL, false,string_to_array('AR', ':'));
-SELECT account_save(NULL,'1420990001','Aj.por Inflacion Ctos en Ejecuci','1420990001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1430990001','Aj.por Inflacion Inv.Prod.Termin','1430990001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1435990001','Aj.por Infl.Mcia No Fab.Empresa','1435990001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1105050001','Caja Mayor','1105050001','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1105100001','Caja Menor 1','1105100001','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1105100002','Caja Menor 2','1105100002','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1105100003','Caja Menor 3','1105100003','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1105100004','Caja menor 4','1105100004','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1105100005','Caja menor 5','1105100005','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1110050013','Banco Ganadero Cta.Cte.xxxxxxxx','1110050013','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1110050029','Tequendama Cte. #xxxxxxxx','1110050029','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1120050013','Banco Ganadero Ahorro xxxxxxxx','1120050013','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1120050019','Banco Colpatria Ahor. xxxxxxxxx','1120050019','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1120051302','Bco Ganadero Ahorro xxxxxxxxxx','1120051302','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1355150020','Retencion en la Fuente AÃo Anter','1355150020','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1410050001','Muebles','1410050001','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1410050002','Inventario 1','1410050002','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1410050003','Inventario 2','1410050003','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1410050004','Inventario 3','1410050004','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1410050005','Inventario 4','1410050005','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1410050010','Inventario 5','1410050010','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1420050001','Lokesea','1420050001','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1430050001','Lokesea','1430050001','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1435050001','Lokesea','1435050001','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1420050002','Lokesea','1420050002','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1516100001','Local #1','1516100001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1516100002','Local #2','1516100002','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1516100003','Local #3','1516100003','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1516990001','Aj. Infl. Local #1','1516990001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1435050099','Cuenta Inventario para Lokesea','1435050099','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1516991001','Aj. Infl. Local #1','1516991001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1516991002','Aj. Infl. Local #2','1516991002','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1516991003','Aj. Infl. Local #3','1516991003','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1520020001','Lokesea del Inventario','1520020001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1520020002','Equipo de Lokeasea','1520020002','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1520990201','Aj. por Inflacion Lokesea','1520990201','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1520990202','Aj.x Infl. Otro Lokesea','1520990202','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1524100001','Aire Acondicionado LG','1524100001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1524991001','Aj. por Inflac. Aire Acond. LG','1524991001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1592100001','Depreciacion Lokesea','1592100001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1540050001','Mazda Blanco Placa ALGO0815','1540050001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1592050001','Local #1','1592050001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1592050002','Local #2','1592050002','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1592050003','Local #3','1592050003','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1592100002','Deprec. Otro Lokesea','1592100002','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1592150001','Depreciacion Aire LG','1592150001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1592350001','Mazda Balnco Placa ALGO0815','1592350001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1910080001','Local #1','1910080001','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1910080002','Local #2','1910080002','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1910080003','Local #3','1910080003','A', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2335950002','Cuentas por pagar CaribeNet S.A. (www.caribenet.com)','2335950002','L', NULL, false,string_to_array('AP', ':'));
-SELECT account_save(NULL,'3115050001','Yo','3115050001','Q', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'3115050002','Tu','3115050002','Q', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4120270001','Lokeproducimos','4120270001','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
-SELECT account_save(NULL,'4130950003','En que ganamos?','4130950003','I', NULL, false,string_to_array('AR_amount:IC_income', ':'));
-SELECT account_save(NULL,'4135950001','Loquevendomos','4135950001','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'4150300001','Vendo hasta mi mama!','4150300001','I', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5230750001','Soat - Seguro Obligatorio Vehiculos','5230750001','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5205060001','Sueldos de Personal','E','5205060001', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'2370060001','Aportes a ARP','L','2370060001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2380950002','Otros Acreedores Varios','L','2380950001', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'2335300001','Servicios Tecnicos','L','2335300001', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'2370100001','Aportes a Sena, icbf y Cajas com','L','2370100001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2380300001','Fondos de Cesantias y/o Pension','L','2380300001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2505050001','Salarios por Pagar','L','2505050001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2610050001','Cesantias','L','2610050001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2610100001','Intereses Sobre Cesantias','L','2610100001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2610150001','Vacaciones','L','2610150001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2610200001','Prima de Servicios','L','2610200001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2367100001','Iva retenido al reg comun 16% ','L','236710', NULL, false,string_to_array('CT_tax', ':'));
+SELECT account_save(NULL,'2367050002','Iva retenido Reg Simp.del 7% ','L','236705', NULL, false,string_to_array('IC_taxservice', ':'));
+SELECT account_save(NULL,'2367100002','Iva retenido al reg comun 20% ','L','236710', NULL, false,string_to_array('IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2367100003','Iva retenido al reg comun del 7% ','L','236710', NULL, false,string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1410990001','Aj. por Inflacion Inv. en Proces','A','1410990001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1465990001','Aj.por Infl. Inv. en Transito','A','1465990001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1330150001','Anticipo a Trabajadores','A','1330150001', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'1420990001','Aj.por Inflacion Ctos en Ejecuci','A','1420990001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1430990001','Aj.por Inflacion Inv.Prod.Termin','A','1430990001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1435990001','Aj.por Infl.Mcia No Fab.Empresa','A','1435990001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1105050001','Caja Mayor','A','1105050001', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1105100001','Caja Menor 1','A','1105100001', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1105100002','Caja Menor 2','A','1105100002', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1105100003','Caja Menor 3','A','1105100003', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1105100004','Caja menor 4','A','1105100004', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1105100005','Caja menor 5','A','1105100005', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1110050013','Banco Ganadero Cta.Cte.xxxxxxxx','A','1110050013', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1110050029','Tequendama Cte. #xxxxxxxx','A','1110050029', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1120050013','Banco Ganadero Ahorro xxxxxxxx','A','1120050013', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1120050019','Banco Colpatria Ahor. xxxxxxxxx','A','1120050019', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1120051302','Bco Ganadero Ahorro xxxxxxxxxx','A','1120051302', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1355150020','Retencion en la Fuente AÃo Anter','A','1355150020', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1410050001','Muebles','A','1410050001', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1410050002','Inventario 1','A','1410050002', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1410050003','Inventario 2','A','1410050003', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1410050004','Inventario 3','A','1410050004', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1410050005','Inventario 4','A','1410050005', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1410050010','Inventario 5','A','1410050010', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1420050001','Lokesea','A','1420050001', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1430050001','Lokesea','A','1430050001', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1435050001','Lokesea','A','1435050001', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1420050002','Lokesea','A','1420050002', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1516100001','Local #1','A','1516100001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1516100002','Local #2','A','1516100002', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1516100003','Local #3','A','1516100003', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1516990001','Aj. Infl. Local #1','A','1516990001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1435050099','Cuenta Inventario para Lokesea','A','1435050099', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1516991001','Aj. Infl. Local #1','A','1516991001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1516991002','Aj. Infl. Local #2','A','1516991002', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1516991003','Aj. Infl. Local #3','A','1516991003', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1520020001','Lokesea del Inventario','A','1520020001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1520020002','Equipo de Lokeasea','A','1520020002', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1520990201','Aj. por Inflacion Lokesea','A','1520990201', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1520990202','Aj.x Infl. Otro Lokesea','A','1520990202', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1524100001','Aire Acondicionado LG','A','1524100001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1524991001','Aj. por Inflac. Aire Acond. LG','A','1524991001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1592100001','Depreciacion Lokesea','A','1592100001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1540050001','Mazda Blanco Placa ALGO0815','A','1540050001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1592050001','Local #1','A','1592050001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1592050002','Local #2','A','1592050002', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1592050003','Local #3','A','1592050003', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1592100002','Deprec. Otro Lokesea','A','1592100002', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1592150001','Depreciacion Aire LG','A','1592150001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1592350001','Mazda Balnco Placa ALGO0815','A','1592350001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1910080001','Local #1','A','1910080001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1910080002','Local #2','A','1910080002', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1910080003','Local #3','A','1910080003', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2335950002','Cuentas por pagar CaribeNet S.A. (www.caribenet.com)','L','2335950002', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'3115050001','Yo','Q','3115050001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3115050002','Tu','Q','3115050002', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4120270001','Lokeproducimos','I','4120270001', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'4130950003','En que ganamos?','I','4130950003', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_save(NULL,'4135950001','Loquevendomos','I','4135950001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4150300001','Vendo hasta mi mama!','I','4150300001', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5230750001','Soat - Seguro Obligatorio Vehiculos','E','5230750001', NULL, false,string_to_array('', ':'));
--
INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '1355150003'), -0.07);
INSERT INTO tax (chart_id, rate) VALUES ((SELECT id FROM chart WHERE accno = '1355170001'), -0.12);
Modified: trunk/sql/coa/cz/chart/General.sql
===================================================================
--- trunk/sql/coa/cz/chart/General.sql 2009-06-13 04:09:11 UTC (rev 2675)
+++ trunk/sql/coa/cz/chart/General.sql 2009-06-13 04:30:33 UTC (rev 2676)
@@ -1,3 +1,4 @@
+BEGIN;
-- Czech chart of accounts
-- ..hidden..
--
@@ -332,6 +333,6 @@
INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
--
-commit;
+rollback;
--
Modified: trunk/sql/coa/de/chart/DATEV-SKR03.sql
===================================================================
--- trunk/sql/coa/de/chart/DATEV-SKR03.sql 2009-06-13 04:09:11 UTC (rev 2675)
+++ trunk/sql/coa/de/chart/DATEV-SKR03.sql 2009-06-13 04:30:33 UTC (rev 2676)
@@ -2,222 +2,222 @@
-- DATEV SKR03
--
@@ Diff output truncated at 100000 characters. @@
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.