SF.net SVN: ledger-smb:[3402] trunk/sql/coa

[..hidden..]

Revision: 3402
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3402&view=rev
Author:   einhverfr
Date:     2011-07-01 10:21:44 +0000 (Fri, 01 Jul 2011)

Log Message:
-----------
co and cz COA's now load

Modified Paths:
--------------
    trunk/sql/coa/co/chart/PUC.sql
    trunk/sql/coa/cz/chart/General.sql

Modified: trunk/sql/coa/co/chart/PUC.sql
===================================================================
--- trunk/sql/coa/co/chart/PUC.sql	2011-07-01 10:08:04 UTC (rev 3401)
+++ trunk/sql/coa/co/chart/PUC.sql	2011-07-01 10:21:44 UTC (rev 3402)
@@ -647,7 +647,7 @@
 SELECT account_save(NULL,'1355150003','Retefuente 7% Rendimientos Finan','A','1355150003', NULL, false, false, string_to_array('IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'1355150001','Retefuente 2% Factor multiplicad','A','1355150001', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1355170001','Iva Retenido 75% de 16%','A','1355170001', NULL, false, false, string_to_array('IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2365150004','Honorarios Persona Juridica 11%','L','2365150004', NULL, false, false, string_to_array('CT_tax', ':'));
+SELECT account_save(NULL,'2365150004','Honorarios Persona Juridica 11%','L','2365150004', NULL, false, false, string_to_array('AR_tax:AP_tax', ':'));
 SELECT account_save(NULL,'2367050001','Iva retenido reg simplif 12% ','L','236705', NULL, false, 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);
@@ -673,7 +673,7 @@
 SELECT account_save(NULL,'2610100001','Intereses Sobre Cesantias','L','2610100001', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2610150001','Vacaciones','L','2610150001', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2610200001','Prima de Servicios','L','2610200001', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'2367100001','Iva retenido al reg comun 16% ','L','236710', NULL, false, false, string_to_array('CT_tax', ':'));
+SELECT account_save(NULL,'2367100001','Iva retenido al reg comun 16% ','L','236710', NULL, false, false, string_to_array('AR_tax:AP_tax', ':'));
 SELECT account_save(NULL,'2367050002','Iva retenido Reg Simp.del 7% ','L','236705', NULL, false, false, string_to_array('IC_taxservice', ':'));
 SELECT account_save(NULL,'2367100002','Iva retenido al reg comun 20% ','L','236710', NULL, false, false, string_to_array('IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'2367100003','Iva retenido al reg comun del 7% ','L','236710', NULL, false, false, string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));

Modified: trunk/sql/coa/cz/chart/General.sql
===================================================================
--- trunk/sql/coa/cz/chart/General.sql	2011-07-01 10:08:04 UTC (rev 3401)
+++ trunk/sql/coa/cz/chart/General.sql	2011-07-01 10:21:44 UTC (rev 3402)
@@ -91,7 +91,7 @@
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10421, '52700', 'ZÃkonnà sociÃlnà nÃklady', 'A', 'E', 'AP_amount', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10423, '52800', 'Ostatnà sociÃlnà nÃklady', 'A', 'E', 'AP_amount', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10433, '54000', 'Jinà provoznà nÃklady', 'A', 'E', 'AP_amount:IC_expense', '', false);
-INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10437, '54200', 'Prodanà materiÃl', 'A', 'E', 'IC_COGS', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10437, '54200', 'Prodanà materiÃl', 'A', 'E', 'IC_expense', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10439, '54300', 'Dary', 'A', 'E', '', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10441, '54400', 'Smluvnà pokuty a Ãroky z prodlenÃ', 'A', 'E', 'AP_amount', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10443, '54500', 'Ostatnà pokuty a penÃle', 'A', 'E', 'AP_amount', '', false);
@@ -107,9 +107,9 @@
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10487, '58400', 'Tvorba rezerv', 'A', 'E', '', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10529, '62000', 'Aktivace', 'A', 'I', '', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10537, '62400', 'Aktivace dlouhodobÃho hmotnÃho majetku', 'A', 'I', '', '', false);
-INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10539, '64000', 'Jinà provoznà vÃnosy.', 'A', 'I', 'AR_amount:IC_sale:IC_Income', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10539, '64000', 'Jinà provoznà vÃnosy.', 'A', 'I', 'AR_amount:IC_sale:IC_income', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10547, '64600', 'VÃnosy z odepsanÃch pohledÃvek', 'A', 'I', 'AR_amount', '', false);
-INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10549, '64800', 'Jinà provoznà vÃnosy', 'A', 'I', 'AR_amount:IC_sale:IC_Income', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10549, '64800', 'Jinà provoznà vÃnosy', 'A', 'I', 'AR_amount:IC_sale:IC_income', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10569, '66200', 'Ãroky', 'A', 'I', '', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10571, '66300', 'Kursovà zisky', 'A', 'I', '', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10243, '34311', 'DPH snÃÅenà vstup', 'A', 'L', 'AP_tax:IC_taxpart:IC_taxservice', '', false);
@@ -231,11 +231,11 @@
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10377, '47500', 'Dlouhodobà pÅijatà zÃlohy', 'A', 'L', 'AP', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10379, '47800', 'Dlouhodobà smÄnky k ÃhradÄ', 'A', 'L', 'AP', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10385, '49100', 'ÃÄet individuÃlnÃho podnikatele', 'A', 'Q', '', '', false);
-INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10387, '50000', 'SpotÅebovanà nÃkupy', 'A', 'E', 'AP_amount:IC_COGS', '', false);
-INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10389, '50100', 'SpotÅeba materiÃlu', 'A', 'E', 'AP_amount:IC_COGS', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10387, '50000', 'SpotÅebovanà nÃkupy', 'A', 'E', 'AP_amount:IC_expense', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10389, '50100', 'SpotÅeba materiÃlu', 'A', 'E', 'AP_amount:IC_expense', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10391, '50200', 'SpotÅeba energie', 'A', 'E', 'AP_amount', '', false);
-INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10393, '50300', 'SpotÅeba ostatnÃch neskladovatelnÃch dodÃvek', 'A', 'E', 'AP_amount:IC_COGS', '', false);
-INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10395, '50400', 'Prodanà zboÅÃ', 'A', 'E', 'AP_amount:IC_COGS', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10393, '50300', 'SpotÅeba ostatnÃch neskladovatelnÃch dodÃvek', 'A', 'E', 'AP_amount:IC_expense', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10395, '50400', 'Prodanà zboÅÃ', 'A', 'E', 'AP_amount:IC_expense', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10397, '51000', 'SluÅby', 'A', 'E', 'AP_amount:IC_expense', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10399, '51100', 'Opravy a udrÅovÃnÃ', 'A', 'E', 'AP_amount:IC_expense', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10405, '51800', 'Ostatnà sluÅby', 'A', 'E', 'AP_amount:IC_expense', '', false);
@@ -271,7 +271,7 @@
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10505, '59600', 'PÅevod podÃlu na hospodÃÅskÃm vÃsledku spoleÄnÃkÃm', 'A', 'E', '', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10507, '59700', 'PÅevod provoznÃch nÃkladÅ', 'A', 'E', '', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10509, '59800', 'PÅevod finanÄnÃch nÃkladÃ', 'A', 'E', '', '', false);
-INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10511, '60000', 'TrÅby za vlastnà vÃkony a zboÅÃ', 'A', 'I', 'AR_amount:IC_sale:IC_Income', '', false);
+INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10511, '60000', 'TrÅby za vlastnà vÃkony a zboÅÃ', 'A', 'I', 'AR_amount:IC_sale:IC_income', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10513, '60100', 'TrÅby za vlastnà vÃrobky', 'A', 'I', 'AR_amount:IC_sale', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10515, '60200', 'TrÅby z prodeje sluÅeb', 'A', 'I', 'AR_amount:IC_income', '', false);
 INSERT INTO chart (id, accno, description, charttype, category, link, gifi_accno, contra) values (10517, '60400', 'TrÅby za zboÅÃ', 'A', 'I', 'AR_amount:IC_sale', '', false);


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.