[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb: [853] trunk

Subject: SF.net SVN: ledger-smb: [853] trunk
From: ..hidden..
Date: Mon, 05 Mar 2007 20:31:40 -0800
Revision: 853
          http://svn.sourceforge.net/ledger-smb/?rev=853&view=rev
Author:   einhverfr
Date:     2007-03-05 20:31:39 -0800 (Mon, 05 Mar 2007)

Log Message:
-----------
Final installment of coa file refactoring

Modified Paths:
--------------
    trunk/Changelog

Added Paths:
-----------
    trunk/sql/coa/ch/
    trunk/sql/coa/ch/chart/
    trunk/sql/coa/ch/chart/German.sql
    trunk/sql/coa/ch/gifi/
    trunk/sql/coa/ch/gifi/German.sql
    trunk/sql/coa/cn/
    trunk/sql/coa/cn/chart/
    trunk/sql/coa/cn/chart/General.sql
    trunk/sql/coa/es/
    trunk/sql/coa/es/chart/
    trunk/sql/coa/es/chart/General.sql
    trunk/sql/coa/es/chart/ISO.sql
    trunk/sql/coa/pl/
    trunk/sql/coa/pl/chart/
    trunk/sql/coa/pl/chart/General.sql
    trunk/sql/coa/se/
    trunk/sql/coa/se/chart/
    trunk/sql/coa/se/chart/Agriculture.sql
    trunk/sql/coa/se/chart/Church_Society.sql
    trunk/sql/coa/se/chart/General.sql
    trunk/sql/coa/se/gifi/
    trunk/sql/coa/se/gifi/General.sql
    trunk/sql/coa/tw/
    trunk/sql/coa/tw/chart/
    trunk/sql/coa/tw/chart/General.sql
    trunk/sql/coa/ve/
    trunk/sql/coa/ve/chart/
    trunk/sql/coa/ve/chart/General.sql

Removed Paths:
-------------
    trunk/sql/Poland-chart.sql
    trunk/sql/Simplified-Chinese_Default-chart.sql
    trunk/sql/Spain-ISO-chart.sql
    trunk/sql/Spain-chart.sql
    trunk/sql/Sweden-chart.sql
    trunk/sql/Sweden-gifi.sql
    trunk/sql/Sweden_Agriculture-chart.sql
    trunk/sql/Sweden_Church_Society-chart.sql
    trunk/sql/Swiss-German-chart.sql
    trunk/sql/Swiss-German-gifi.sql
    trunk/sql/Traditional-Chinese_Default-chart.sql
    trunk/sql/Venezuela_Default-chart.sql

Modified: trunk/Changelog
===================================================================
--- trunk/Changelog	2007-03-06 04:16:33 UTC (rev 852)
+++ trunk/Changelog	2007-03-06 04:31:39 UTC (rev 853)
@@ -1,7 +1,8 @@
 Changelog for LedgerSMB 1.3.0
-* Improved error handling/display
-* Basic RESTful web services dispatcher
-* Timecard lists project descriptions as well as numbers
+* Improved error handling/display (Jason)
+* Basic RESTful web services dispatcher (Jason)
+* Timecard lists project descriptions as well as numbers (Chris)
+* Chart of Accounts files organized hierarchically by country code (Chris)
 
 
 Changelog for LedgerSMB 1.2.0

Deleted: trunk/sql/Poland-chart.sql
===================================================================
--- trunk/sql/Poland-chart.sql	2007-03-06 04:16:33 UTC (rev 852)
+++ trunk/sql/Poland-chart.sql	2007-03-06 04:31:39 UTC (rev 853)
@@ -1,349 +0,0 @@
-begin;
--- Chart of Account for Poland
--- From: Peter Dabrowski <..hidden..>
--- Sun, 23 March 2003
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('000000000','Aktywa TrwaÂe','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('001000000','Ârodki TrwaÂe','A','','A','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('001010000','Grunty wÂasne i prawa wieczystego uÂytkowania gruntÃw','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('001020000','Budynki, locale i obiekty inÂynierii lÂdowej i wodnej','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('001030000','UrzÂdzenia techniczne i maszyny','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('001040000','Ârodki transportu','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('001050000','Inne Ârodki trwaÂe','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('002000000','WartoÂci niematerialne i prawne','A','','A','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('002010000','Koszty zakoÃczonych prac rozwojowych','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('002020000','Nabyta wartoÂÃ firmy','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('002080000','Inne wartoÂci niematerialne i prawne','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('002090000','Zaliczki na wartoÂci niematerialne i prawne','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('003000000','DÂugoterminowe aktywa finansowe','A','','A','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('003010000','W jednostkach powiÂzanych','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('003010100','UdziaÂy lub akcje','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('003010200','Inne papiery wartoÂciowe','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('003010300','Udzielone porzyczki','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('003010400','Inne dÂugoterminowe aktywa finansowe','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('003020000','W pozostaÂych jednostkach','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('003020100','UdziaÂy lub akcje','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('003020200','Inne papiery wartoÂciowe','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('003020300','Udzielone poÂyczki','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('003020400','Inne dÂugoterminowe aktywa finansowe','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('003090000','Inne investycje dÂugoterminowe','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('003090100','Inne rodzaje dÂugoterminowych aktywÃw finansowych','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('004000000','Investycje w nieruchomoÂci i prawa','A','','A','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('004010000','NieruchomoÂci','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('004020000','WartoÂci niematerialne i prawne','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('005000000','DÂugoterminowe rozliczenia miÃdzyokresowe','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('005010000','Aktywa z tytuÂu odroczonego podatku dochodowego','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('005020000','Inne rozliczenia miÃdzyokresowe','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('006000000','NaleÂnoÂci dÂugoterminowe','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('006010000','Od jednostek powiÂzanych','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('006020000','Od pozostaÂych jednostek','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('007000000','Odpisy umorzeniowe ÂrodkÃw trwaÂych oraz wartoÂci niematerialnych i prawnych','A','','A','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('007010000','Odpisy umorzeniowe wartoÂci gruntÃw i prawa wieczystego uÂytkowania gruntÃw','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('007020000','Odpisy umorzeniowe budynkÃw, lokali i obiektÃw inÂynierii lÂdowej i wodnej','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('007030000','Odpisy umorzeniowe urzÂdzeÃ technicznych i maszyn','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('007040000','Odpisy umorzeniowe ÂrodkÃw transportu','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('007050000','Odpisy umorzeniowe ulepszeÃ obcych ÂrodkÃw trwaÂych','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('007090000','Odpisy umorzeniowe innych ÂrodkÃw trwaÂych','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('008000000','Ârodki trwaÂe w budowie','A','','A','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('008010000','Inwestycje budowy Ârodka trwaÂego','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('008020000','Ulepszenia Ârodka trwaÂego','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('008030000','NakÂady na budowÃ Ârodka trwaÂego','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('008040000','Zaliczki na Ârodki trwaÂe w budowie','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('008050000','Ulepszenia obcych ÂrodkÃw trwaÂych','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('009000000','Odpisy aktualizujÂce dÂugoterminowe aktywa finansowe','A','','A','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('009010000','Odpisy aktualizujÂce udziaÂy i akcje w obcych jednostkach','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('009020000','Odpisy aktualizujÂce lokaty','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('009030000','Odpisy aktualizujÂce udzielone porzyczki dÂugoterminowe','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('009090000','Odpisy aktualizujÂce inne rodzaje dÂugoterminowych aktywÃw finansowych','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('100000000','Ârodki pieniÃÂne, rachunki bankowe oraz inne krÃtkoterminowe aktywa finansowe','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('110000000','Ârodki pieniÃÂne w kasie','A','','A','AR:AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('110010000','Kasa krajowych ÂrodkÃw pieniÃÂnych','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('110020000','Kasa zagranicznych ÂrodkÃw pieniÃÂnych','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('113000000','Rachunki i kredyty bankowe','A','','A','AR:AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('113010000','Rachunek bieÂÂcy','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('113020000','Rachunek ÂrodkÃw wyodrÃbnionych i zablokowanych','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('113030000','Rachunki kredytÃw bankowych','A','','A','AR_paid:AP_amount:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('113040000','Rachunek ÂrodkÃw walutowych','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('114000000','KrÃtkoterminowe aktywa finansowe','A','','A','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('114010000','KrÃtkoterminowe aktywa finansowe w jednostkach powiÂzanych','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('114010100','UdziaÂy lub akcje','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('114010200','Inne papiery wartoÂciowe','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('114010300','Udzielone poÂyczki','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('114010400','Inne krÃtkoterminowe aktywa finansowe','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('114020000','KrÃtkoterminowe aktywa finansowe w pozostaÂych jednostkach','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('114020100','UdziaÂy lub akcje','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('114020200','Inne papiery wartoÂciowe','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('114020400','Inne krÃtkoterminowe aktywa finansowe','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('115000000','Inne Ârodki pieniÃÂne','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('116000000','Inne aktywa pieniÃÂne','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('117000000','Inne inwestycje krÃtkoterminowe','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('118000000','KrÃtkoterminowe rozliczenia miÃdzyokresowe','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('200000000','Rozrachunki i roszczenia','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('220000000','NaleÂnoÂci krÃtkoterminowe','A','','L','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('220010000','NaleÂnoÂci od jednostek powiÂzanych','A','','L','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('220010100','NaleÂnoÂci z tytuÂu dostaw i usÂug','A','','L','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('220010110','NaleÂnoÂci z tytuÂu dostaw i usÂug, o okresie spÂaty do 12 miesiÃcy','A','','L','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('220010120','NaleÂnoÂci z tytuÂu dostaw i usÂug, o okresie spÂaty powyÂej 12 miesiÃcy','A','','L','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('220010200','Inne naleÂnoÂci','A','','L','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('220010210','ZobowiÂzania z tytuÂu pokrycia kosztÃw ogÃlnego zarzÂdu','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('220010220','ZobowiÂzania z tytuÂu rozliczeÃ VAT','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('221010000','NaleÂnoÂci od pozostaÂych jednostek','A','','L','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('221020100','NaleÂnoÂci z tytuÂu dostaw i usÂug','A','','L','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('221020110','NaleÂnoÂci z tytuÂu dostaw i usÂug, o okresie spÂaty do 12 miesiÃcy','A','','L','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('221020120','NaleÂnoÂci z tytuÂu dostaw i usÂug, o okresie spÂaty powyÂej 12 miesiÃcy','A','','L','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('221020200','NaleÂnoÂci z tytuÂu podatkÃw, dotacji, ceÂ, ubezpieczeÃ spoÂecznych i zdrowotnych oraz innych ÂwiadczeÃ','A','','L','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('221020300','Zaliczki przekazane dostawcom','A','','L','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('221020400','NaleÂnoÂci dochodzone na drodze sÂdowej','A','','L','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('221020500','Inne naleÂnoÂci','A','','L','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222000000','ZobowiÂzania krÃtkoterminowe','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222010000','ZobowiÂzania wobec jednostek powiazanych','A','','L','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222010100','ZobowiÂzania z tytuÂu dostaw i usÂug','A','','L','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222010200','ZobowiÂzania o okresie wymagalnoÂci do 12 miesiÃcy','A','','L','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222010300','ZobowiÂzania o okresie wymagalnoÂci powyÂej 12 miesiÃcy','A','','L','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222010400','Inne zobowiÂzania','A','','L','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222020000','ZobowiÂzania wobec pozostaÂych jednostek','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222020100','Kredyty i poÂyczki','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222020200','ZobowiÂzania z tytuÂu emisji dÂuÂnych papierÃw wartoÂciowych','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222020300','Inne zobowiÂzania finasowe','A','','L','AP_Amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222020400','Zobowiazania z tytuÂu dostaw i usÂug','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222020500','ZobowiÂzania o okresie wymagalnoÂci do 12 miesiÃcy ','A','','L','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222020600','ZobowiÂzania o okresie wymagalnoÂci powyÂej 12 miesiÃy','A','','L','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222020700','Zaliczki otrzmane na dostawy','A','','L','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222020800','ZobowiÂzania wekslowe','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222020900','ZobowiÂzania z tytuÂu podatkÃw, ceÂ, ubezpieczeÃ i innych ÂwiadczeÃ','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222021000','ZobowiÂzania z tytuÂu wynagrodzeÃ','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('222021100','Inne zobowiÂzania','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223000000','Rozrachunki publicznoprawne','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223010000','Rozrachunki z urzÃdem skarbowym z tytuÂu VAT','A','','L','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223020000','Rozliczenie naleÂnego VAT','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223020100','Rozliczenie naleÂnego VAT-22%','A','','L','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223020200','Rozliczenie naleÂnego VAT-7%','A','','L','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223020300','Rozliczenie naleÂnego VAT-0%','A','','L','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223030000','Rozliczenie naliczonego VAT','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223030100','Rozliczenie naliczonego VAT-22%','A','','L','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223030200','Rozliczenie naliczonego VAT-7%','A','','L','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223030300','Rozliczenie naliczonego VAT-0%','A','','L','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223040000','Korekty naliczonego VAT','A','','L','AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223050000','Rozrachunki z UrzÃdem Celnym','A','','L','AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223060000','Rozrachunki z UrzÃdem Skarbowym z tytuÂu znakÃw akcyzy','A','','L','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223070000','Rozrachunki z UrzÃdem Skarbowym z tytuÂu podatku akcyzowego','A','','L','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223080000','Rozliczenie znakÃw akcyzy','A','','L','AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223090000','Rozrachunki z ZUS','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('223100000','Rozrachunki z UrzÃdem Skarbowym z tytuÂu podatku dochodowego od osÃb prawnych','A','','L','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('224000000','Rozrachunki z pracownikami','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('224010000','Rozrachunki z tytuÂu wynagrodzeÃ','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('224020000','Rozrachunki z tytuÂu poÂyczek udzielonych pracownikom','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('224090000','Inne rozrachunki z pracownikami','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225000000','ZobowiÂzania dÂugoterminowe','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225010000','ZobowiÂzania wobec jednostek powiÂzanych','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225010100','ZobowiÂzania z tytuÂu wyodrÃbnienia skÂadnikÃw majÂtkowych','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225010200','ZobowiÂzania z tytuÂu podziaÂu zysku','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225020000','ZobowiÂzania wobec pozostaÂych jednostek','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225020100','Kredyty i poÂyczki otrzymane','A','','L','AR_amount:AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225020200','Kredyty i poÂyczki udzielone','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225020300','ZobowiÂzania z tytuÂu emisji dÂuÂnych papierÃw wartoÂciowych','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225020400','Inne zobowiÂzania kredytowe','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225020500','Inne zobowiÂzania','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225030000','Rozrachunki z tytuÂu wpÂat na kapitaÂ zakÂadowy','A','','L','AR_amount:APamount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225040000','Rozrachunki z tytuÂu wkÂadÃw niepieniÃÂnych na kapitaÂ zakÂadowy','A','','L','AR_amount:AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225050000','Rozrachunki z tytuÂu podwyÂszenia kapitaÂu ze ÂrodkÃw wÂasnych spÃÂki','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225060000','Rozrachunki z tytuÂu umorzenia udziaÂÃw wÂasnych','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225070000','Rozrachunki z tytuÂu dywident','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225080000','Rozrachunki z tytuÂu dopÂat i zwrotu dopÂat','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('225090000','PozostaÂe rozrachunki ze wspÃlnikami','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('229000000','Odpisy aktualizujÂce rozrachunki','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('300000000','MateriaÂy i towary','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('330000000','Rozliczenie zakupu','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('330010000','Rozliczenie wartoÂci materiaÂÃw i towarÃw w drodze','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('330020000','WartoÂci dostaw niefakturowanych','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('330030000','Przychody wszelkich dostaw i usÂug i ich rozliczanie','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('330040000','Odhylenia cen ewidencyjnych od rzeczywistych cen nabycia lub zakupu','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('330050000','Koszty zakupu zawarte w fakturach dostawcÃw','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('330060000','OpÂaty manipulacyjne policzone przez UrzÂd Celny','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('330070000','Niedobory, szkody i nadwyÂki w transporcie','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('330080000','Znaki akcyzy wedÂug dokumentu SAD','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('330090000','Reklamacje faktur dostawcÃw','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('331000000','MateriaÂy','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('331010000','MateriaÂy w magazynach wÂasnych','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('331020000','MateriaÂy w magazynach obcych','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('331030000','MateriaÂy w przerobie','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('333000000','Towary','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('333010000','Towary w magazynach wÂasnych','A','','A','IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('333020000','Towary w magazynach obcych','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('333030000','Towary w detalu','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('334000000','Odchylenia od cen ewidencyjnych materiaÂÃw i towarÃw','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('334010000','Odpisy aktualizujÂce wartoÂÃ materiaÂÃw','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('334020000','Odpisy aktualizujÂce wartoÂÃ towarÃw','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('400000000','Koszty wedÂug rodzajÃw i ich rozliczeÃ','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440000000','Koszty wedÂug rodzajÃw','A','','E','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440010000','ZuÂycie materiaÂÃw i energii','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440010100','ZuÂycie materiaÂÃw biurowych','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440020000','UsÂugi obce','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440020100','UsÂugi celne','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440020200','UsÂugi telekomunikacyjne','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440020300','UsÂugi pocztowe','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440020400','UsÂugi kurierskie i transportowe','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440020500','Analizy sanitarne','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440020600','UsÂugi graficzne i drukarskie','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440030000','Podatki i opÂaty','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440030100','OpÂaty i prowizje bankowe','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440030200','OpÂaty sÂdowe, prawnicze i notarialne','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440030300','OpÂaty skarbowe','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440030400','Koncesje','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440040000','Wynagrodzenia za pracÃ','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('441000000','Âwiadczenia na rzecz pracownikÃw','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('442000000','Amortyzacja','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('443000000','PozostaÂe','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('449000000','Rozliczenie kosztÃw','A','','E','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('449010000','Nie podlegajÂce rozliczeniu w czasie','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('449020000','PrzypadajÂce na przyszÂe okresy','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('449030000','Koszty zgromadzone','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('449040000','Koszty nie wliczane do wartoÂci sprzedaÂy','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('500000000','Koszty wedÂug typÃw dziaÂalnoÂci i ich rozliczenie','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('550000000','Koszty dziaÂalnoÂci podstawowej-produkcyjnej','A','','E','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('550010000','Rozliczone koszta dziaÂalnoÂci','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('550020000','Koszty nie zakoÃczonych dÂugotrwaÂych usÂug','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('550030000','Straty zwiÂzane z wykonaniem dÂugotrwaÂych usÂug','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('552000000','Koszty dziaÂalnoÂci podstawowej-handlowej','A','','E','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('552010000','Koszty utrzymania punktÃw sprzedaÂy detalicznej','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('550200000','Koszty utrzymania hurtowni','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('552030000','Koszty sprzedaÂy wyrobÃw','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('552040000','Podatek akcyzowy','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('552050000','OpÂaty celne','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('553000000','Koszty dziaÂalnoÂci pomocniczej','A','','E','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('553010000','Âwiadczenia usÂug transportowych','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('555000000','Koszty zarzÂdu','A','','E','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('555010000','Koszty zarzÂdzania jednostkÂ','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('555020000','Âwiadczenia usÂug na potrzeby reprezentacji i reklamy','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('558000000','Rozliczenie kosztÃw dziaÂalnoÂci','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('600000000','Produkty i rozliczenia miÃdzyokresowe','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('660000000','PÃÂprodukty i produkty w toku','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('661000000','Produkty gotowe','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('661010000','Wyroby gotowe','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('661020000','Wyroby poza jednostkÂ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('662000000','Odchylenia od cen ewidencyjnych produktÃw','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('662010000','Odchylenia od cen evidencyjnych wyrobÃw gotowych','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('662020000','Odhylenia od cen evidencyjnych pÃÂfabrykatÃw','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('664000000','Rozliczenia miÃdzyokresowe kosztÃw','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('664010000','Czynne rozliczenia miÃdzyokresowe kosztÃw','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('664020000','Bierne rozliczenia miÃdzyokresowe kosztÃw','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('665000000','PozostaÂe rozliczenia miÃdzyokresowe','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('665010000','Czynne rozliczenia przyszÂych okresÃw','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('665020000','Bierne rozliczenia przyszÂych okresÃw','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('700000000','Przychody i koszty zwiÂzane z ich osiÂgniÃciem','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('770000000','SprzedaÂ produktÃw','A','','I','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('770010000','SprzedaÂ produktÃw na kraj','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('770020000','SprzedaÂ produktÃw na eksport','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('770030000','SprzedaÂ usÂug na kraj','A','','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('770040000','SprzedaÂ usÂug na eksport','A','','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('770100000','Koszty sprzedanych produktÃw','A','','E','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('770110000','Koszt wÂasny sprzedaÂy produktÃw na kraj','A','','E','IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('770120000','Koszt wÂasny sprzedaÂy produktÃw na eksport','A','','E','IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('770130000','Koszt wÂasny sprzedaÂy usÂug na kraj','A','','E','IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('770140000','Koszt wÂasny sprzedaÂy usÂug na export','A','','E','IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('773000000','SprzedaÂ towarÃw','A','','I','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('773010000','SprzedaÂ hurtowa towarÃw','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('773020000','SprzedaÂ detaliczna towarÃw','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('773030000','SprzedaÂ wysyÂkowa towarÃw','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('773040000','Prowizja komisowa','A','','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('773100000','WartoÂÃ sprzedanych towarÃw w cenach zakupu','A','','E','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('773110000','WartoÂÃ sprzedanych towarÃw w sprzedaÂy hurtowej','A','','E','IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('773120000','WartoÂÃ sprzedanych towarÃw w sprzedaÂy detalicznej','A','','E','IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('773130000','WartoÂÃ sprzedanych towarÃw w sprzedaÂy wysyÂkowej','A','','E','IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('773140000','Prowizja komisowa','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('774000000','SprzedaÂ materiaÂÃw','A','','I','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('774010000','MateriaÂy','A','','I','AP_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('774020000','Opakowania','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('774030000','Odpady','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('774100000','WartoÂÃ sprzedanych materiaÂÃw','A','','E','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('774110000','WartoÂÃ w cenach zakupu sprzedanych materiaÂÃw','A','','E','IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('774120000','WartoÂÃ w cenach zakupu sprzedanych opakowaÃ','A','','E','IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('774130000','WartoÂÃ w cenach zakupu sprzedanych odpadÃw','A','','E','IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('775000000','Przychody finansowe','A','','I','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('775010000','Kwoty naleÂne ze sprzedaÂy aktywÃw finansowych','A','','I','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('775020000','Kwoty naleÂne z tytuÂu dywident','A','','I','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('775030000','Otrzymane odsetki','A','','I','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('775040000','Przychody ze zbycia investycji','A','','I','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('775050000','Aktualizacja wartoÂci investycji-przychody','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('775060000','Dodatnie rÃÂnice kursu walut','A','','I','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('775070000','PozostaÂe przychody finansowe','A','','I','AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('775100000','Koszty finansowe','A','','E','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('775110000','WartoÂÃ sprzedanych investycji','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('775120000','Odpisy z tytuÂu utraty wartoÂci investycji-koszty','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('775130000','Odsetki zapÂacone','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('775140000','Ujemne rÃÂnice kursu walut','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('775190000','PozostaÂe koszty finansowe','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('776000000','PozostaÂe przychody operacyjne','A','','I','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('776010000','Przychody ze zbycia niefinansowych aktywÃw trwaÂych','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('776020000','Otrzymane dotacje','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('776030000','Przychody z usÂug socjalnych','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('776040000','Przychody ze wzrostu wartoÂci niefinansowych aktywÃw trwaÂych','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('776090000','Inne pozostaÂe przychody operacyjne','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('776100000','PozostaÂe koszty operacyjne','A','','E','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('776110000','WartoÂÃ sprzedanych niefinansowych aktywÃw trwaÂych','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('776120000','Dotacje przekazane','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('776130000','Odpisy z tytuÂu utraty wartoÂci aktywÃw niefinansowych','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('776140000','Inne pozostaÂe koszty operacyjne','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('777000000','Zyski nadzwyczajne','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('777100000','Straty nadzwyczajne','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('779000000','Obroty wewnÃtrzne','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('779010000','Koszt wyrobÃw wÂasnej produkcji wydanych do wÂasnych sklepÃw','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('779020000','Âwiadczenia na rzecz ÂrodkÃw trwaÂych w budowie','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('779040000','Koszt niedoborÃw produktÃw','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('779050000','Koszt zaniechania okreÂlonego rodzaju dziaÂalnoÂci','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('779100000','Koszt obrotÃw wewnÃtrznych','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('779110000','Koszt wytworzenia wyrobÃw gotowych wydanych do wÂasnych sklepÃw','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('779120000','Koszt wytworzenia ÂwiadczeÃ na rzecz ÂrodkÃw trwaÂych w budowie','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('779130000','Koszt wytworzenia zakoÃczonych prac rozwojowych','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('779140000','Koszt wytworzenia produktÃw uznanych za niedobory','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('779150000','Koszt zaniechania okreÂlonego rodzaju dziaÂalnoÂci','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('800000000','KapitaÂy wÂasne i wynik finansowy','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('880000000','KapitaÂ podstawowy','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('880010000','KapitaÂ zakÂadowy','A','','Q','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('881000000','Fundusze wydzielone jednostkom zaleÂnym','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('882000000','NaleÂne wpÂaty na kapitaÂ podstawowy','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('883000000','Fundusze wydzielone jednostkom zaleÂnym','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('884000000','KapitaÂ zapasowy','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('885000000','KapitaÂ rezerwowy','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('886000000','KapitaÂ z aktualizacji wyceny','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('887000000','Rozliczenia wyniku finansowego','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('888000000','Rezerwy','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('888010000','Rezerwa z tytuÂu odroczonego podatku dochodowego','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('888020000','Rezerwa na Âwiadczenia','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('888020100','Rezerwa dÂugoterminowa na Âwiadczenia emerytalne i podobne','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('888020200','Rezerwa krÃtkoterminowa na Âwiadczenia emerytalne i podobne','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('889090000','PozostaÂe rezerwy','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('889090100','PozostaÂe rezerwy dÂugoterminowe','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('889090200','PozostaÂe rezerwy krÃtkoterminowe','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('890000000','Rozliczenia miÃdzyokresowe','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('890010000','Ujemna wartoÂÃ firmy','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('890020000','Inne rozliczenia miÃdzyokresowe','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('890020100','Inne rozliczenia miÃdzyokresowe dÂugoterminowe','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('890020200','Inne rozliczenia miÃdzyokresowe krÃtkoterminowe','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('891000000','Fundusze specjalne','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('892000000','Wynik finansowy','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('893000000','Odpisy z zysku netto w ciÂgu roku obrotowego','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('893010000','Podatek dochodowy','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('893020000','Inne obowiÂzkowe obciÂÂenia wyniku finansowego','A','','Q','');
---
-insert into tax (chart_id,rate) values ((select id from chart where accno = '223020100'),0.22);
-insert into tax (chart_id,rate) values ((select id from chart where accno = '223020200'),0.07);
-insert into tax (chart_id,rate) values ((select id from chart where accno = '223020300'),0);
-insert into tax (chart_id,rate) values ((select id from chart where accno = '223030100'),0.22);
-insert into tax (chart_id,rate) values ((select id from chart where accno = '223030200'),0.07);
-insert into tax (chart_id,rate) values ((select id from chart where accno = '223030300'),0);
---
-INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '333000000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '773010000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '773110000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '775060000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '775140000'), invnumber = '1000', sonumber = '1000', ponumber = '1000', curr = 'PLN:USD:EUR');
-
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
---
-
-
-commit;

Deleted: trunk/sql/Simplified-Chinese_Default-chart.sql
===================================================================
--- trunk/sql/Simplified-Chinese_Default-chart.sql	2007-03-06 04:16:33 UTC (rev 852)
+++ trunk/sql/Simplified-Chinese_Default-chart.sql	2007-03-06 04:31:39 UTC (rev 853)
@@ -1,92 +0,0 @@
-begin;
--- Default chart of accounts -- sample only
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2190','åäæåç','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','éæèå','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300','èäèæ','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3500','äççé','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','éåçé','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4300','èèçé','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4400','ååçé','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5000','èéææ','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5400','èèæå','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5600','æååççæå','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1205','åååæ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','æåèä','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800','èæèä','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1825','çèåæäæ - èçåèå.','A','','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1845','çèåæäæ - èèåå','A','','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','æåèå','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2620','éèåæ','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3600','æåçé','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2160','åäååç','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3590','äççé - ååå','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3350','æéèä','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','åèèä','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5615','ååèé','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5790','åå','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5700','ååçå','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800','æåé','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5610','äèæå','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5685','äé','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5660','åææå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5620','åå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5680','æåç','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5690','åæåéèæçè','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5410','èè','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5420','äéæå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5430','éäéæå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5440','èåéæå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5470','ååçå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4030','éå / èä','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4440','åæ','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5100','èè','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5760','çé','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1530','åå / èä','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1540','åå / äçååéä','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4040','éå / äçååéä','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5030','èéææ / èä','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5010','éè','A','','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5040','èéææ / äçååéä','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1065','éçé','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1820','åååèçåèå','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5785','æèååä','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2680','èäèæ','A','','L','AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5795','æåè','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5780','çäè','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5781','çèèçè','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5765','çäççè','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2311','åæç','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4430','èéè','A','','I','IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1520','åå / çä','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020','èéææ / çä','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100','åäåæ','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1840','èèåå','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4330','çåèè','A','','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020','éå / çä','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4320','èè','A','','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200','åæåæ','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1061','æçæå','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2310','ååæåç','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
---
--- exchange rate
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4450','Foreign Exchange Gain','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5810','Foreign Exchange Loss','A','','E','');
---
-insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.07);
-insert into tax (chart_id,rate) values ((select id from chart where accno = '2311'),0.08);
---
-INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5810'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('curr', 'CAD');
-
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
---
-commit;

Deleted: trunk/sql/Spain-ISO-chart.sql
===================================================================
--- trunk/sql/Spain-ISO-chart.sql	2007-03-06 04:16:33 UTC (rev 852)
+++ trunk/sql/Spain-ISO-chart.sql	2007-03-06 04:31:39 UTC (rev 853)
@@ -1,146 +0,0 @@
-begin;
--- Chart of Accounts for Spain (Cuadro del Plan de Contabilidad espaÃol)
--- From: Federico Montesino Pouzols <..hidden..>
--- 23 Apr 2002
--- 
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('099999999','Grupo 1: financiaciÃn bÃsica','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('100000000','Capital','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('110000000','Reservas','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('120000000','Resultados pendientes de aplicaciÃn','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('130000000','Ingresos a distribuir en varios ejercicios','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('140000000','Provisiones para riesgos y gastos','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('150000000','EmprÃstitos y otras emisiones anÃlogas','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('160000000','Deudas a largo plazo con empresas del grupo y asociadas','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('170000000','Deudas a largo plazo por prestamos recibidos y otros conceptos','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('180000000','Fianzas y depÃsitos recibidos a largo plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('190000000','Situaciones transitorias de financiaciÃn','A','','A','');
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('199999999','Grupo 2: inmovilizado','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('200000000','Gastos de establecimiento','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('210000000','Inmovilizaciones inmateriales','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('220000000','Inmovilizaciones materiales','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('230000000','Inmovilizaciones materiales en curso','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('240000000','Inversiones financieras en empresas del grupo y asociadas','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('250000000','Otras inversiones financieras permanentes','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('260000000','Fianzas y depÃsitos constituidos a largo plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('270000000','Gastos a distribuir en varios ejercicios','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('280000000','AmortizaciÃn acumulada del inmovilizado','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('290000000','Provisiones de inmovilizado','A','','A','');
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('299999999','Grupo 3: existencias','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('300000000','Comerciales','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('310000000','Materias primas','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('320000000','Otros aprovisionamientos','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('330000000','Productos en curso','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('340000000','Productos semiterminados','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('350000000','Productos terminados','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('360000000','Subproductos, residuos y materiales recuperados','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('390000000','Provisiones por depreciaciÃn de existencias','A','','A','');
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('399999999','Grupo 4: acreedores y deudores por operaciones de trÃfico','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('400000000','Proveedores','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('410000000','Acreedores varios','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('430000000','Clientes','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('431000000','Clientes, efectos comerciales a cobrar','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440000000','Deudores varios','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('460000000','Personal','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('470000000','Administraciones pÃblicas','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000000','Hacienda PÃblica, IVA soportado','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000001','IVA soportado 4%','A','','P','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000002','IVA soportado 7%','A','','P','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000003','IVA soportado 16%','A','','P','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('475100000','Hacienda PÃblica, acreedor por retenciones practicadas','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('473000000','Hacienda PÃblica, retenciones y pagos a cuenta','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000000','Hacienda PÃblica, IVA repercutido','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000001','IVA repercutido 4%','A','','P','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000002','IVA repercutido 7%','A','','P','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000003','IVA repercutido 16%','A','','P','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('480000000','Ajustes por periodificaciÃn','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('490000000','Provisiones por operaciones de trÃfico','A','','P','');
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('499999999','Grupo 5: cuentas financieras','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('500000000','EmprÃstitos y otras emisiones anÃlogas a corto plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('510000000','Deudas a corto plazo con empresas del grupo y asociadas','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('520000000','Deudas a corto plazo por prÃstamos recibidos y otros conceptos','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('530000000','Inversiones financieras a corto plazo en empresas del grupo y asociadas','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('540000000','Otras inversiones financieras temporales','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('550000000','Otras cuentas no bancarias','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('560000000','Fianzas y depÃsitos recibidos y constituidos a corto plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('569000000','TesorerÃa','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('570000000','Caja, euros','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('571000000','Caja, moneda extranjera','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('572000000','Bancos e instituciones de crÃdito, c/c. vista, euros','A','','A','AR_paid:AP_paid:AP_amount:AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('573000000','Bancos e instituciones de crÃdito, c/c. vista, moneda extranjera','A','','A','AR_paid:AP_paid:AP_amount:AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('574000000','Bancos e instituciones de crÃdito, cuentas de ahorro, euros','A','','A','AR_paid:AP_paid:AP_amount:AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('575000000','Bancos e instituciones de crÃdito, cuentas de ahorro, moneda extranjera','A','','A','AR_paid:AP_paid:AP_amount:AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('580000000','Ajustes por periodificaciÃn','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('590000000','Provisiones financieras','A','','P','');
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('599999999','Grupo 6: compras y gastos','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('600000000','Compras','A','','E','AP:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('608000000','Devoluciones de compras y operaciones similares','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('610000000','VariaciÃn de existencias','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('620000000','Servicios exteriores','A','','E','IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('630000000','Tributos','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('640000000','Gastos de personal','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('650000000','Otros gastos de gestiÃn','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('660000000','Gastos financieros','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('665000000','Descuentos sobre ventas por pronto pago','A','','E','IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('668000000','Diferencias negativas de cambio','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('670000000','PÃrdidas procedentes del inmovilizado y gastos excepcionales','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('680000000','Dotaciones para amortizaciones','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('690000000','Dotaciones a las provisiones','A','','E','');
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('699999999','Grupo 7: ventas e ingresos','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('700000000','Ventas de mercaderÃas, de producciÃn propia, de servicios, etc.','A','','I','AR:IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('708000000','Devoluciones de ventas y operaciones similares','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('710000000','VariaciÃn de existencias','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('730000000','Trabajos realizados para la empresa','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('740000000','Subvenciones a la explotaciÃn','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('750000000','Otros ingresos de gestiÃn','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('760000000','Ingresos financieros','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('765000000','Descuentos sobre compras por pronto pago','A','','I','IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('768000000','Diferencias positivas de cambio','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('770000000','Beneficios procedentes de inmovilizados e ingresos excepcionales','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('790000000','Excesos y aplicaciones de provisiones','A','','I','');
---
--- Taxes in Spain
---
--- IVA: 4, 7 or 16%
--- IVA soportado
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000000'), 0.0);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000001'), 0.04);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000002'), 0.07);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000003'), 0.16);
--- Recargo equivalente: 0.5, 1 or 4%
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000004'), 0.005);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000005'), 0.01);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '472000006'), 0.04);
---
--- IVA repercutido
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000000'), 0.0);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000001'), 0.04);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000002'), 0.07);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000003'), 0.16);
--- Recargo equivalente: 0.5, 1 or 4%
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000004'), 0.005);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000005'), 0.01);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno = '477000006'), 0.04);
---
--- update defaults
---
-INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '300000000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '700000000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '600000000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '768000000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '668000000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR');
-
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'Kg');
---
-commit;

Deleted: trunk/sql/Spain-chart.sql
===================================================================
--- trunk/sql/Spain-chart.sql	2007-03-06 04:16:33 UTC (rev 852)
+++ trunk/sql/Spain-chart.sql	2007-03-06 04:31:39 UTC (rev 853)
@@ -1,146 +0,0 @@
-begin;
--- Chart of Accounts for Spain (Cuadro del Plan de Contabilidad espaÃol)
--- From: Federico Montesino Pouzols <..hidden..>
--- 23 Apr 2002
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('099999999','Grupo 1: financiaciÃn bÃsica','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('100000000','Capital','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('110000000','Reservas','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('120000000','Resultados pendientes de aplicaciÃn','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('130000000','Ingresos a distribuir en varios ejercicios','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('140000000','Provisiones para riesgos y gastos','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('150000000','EmprÃstitos y otras emisiones anÃlogas','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('160000000','Deudas a largo plazo con empresas del grupo y asociadas','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('170000000','Deudas a largo plazo por prestamos recibidos y otros conceptos','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('180000000','Fianzas y depÃsitos recibidos a largo plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('190000000','Situaciones transitorias de financiaciÃn','A','','A','');
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('199999999','Grupo 2: inmovilizado','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('200000000','Gastos de establecimiento','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('210000000','Inmovilizaciones inmateriales','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('220000000','Inmovilizaciones materiales','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('230000000','Inmovilizaciones materiales en curso','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('240000000','Inversiones financieras en empresas del grupo y asociadas','A','', 'A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('250000000','Otras inversiones financieras permanentes','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('260000000','Fianzas y depÃsitos constituidos a largo plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('270000000','Gastos a distribuir en varios ejercicios','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('280000000','AmortizaciÃn acumulada del inmovilizado','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('290000000','Provisiones de inmovilizado','A','','A','');
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('299999999','Grupo 3: existencias','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('300000000','Comerciales','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('310000000','Materias primas','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('320000000','Otros aprovisionamientos','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('330000000','Productos en curso','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('340000000','Productos semiterminados','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('350000000','Productos terminados','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('360000000','Subproductos, residuos y materiales recuperados','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('390000000','Provisiones por depreciaciÃn de existencias','A','','A','');
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('399999999','Grupo 4: acreedores y deudores por operaciones de trÃfico','H','', '','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('400000000','Proveedores','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('410000000','Acreedores varios','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('430000000','Clientes','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('431000000','Clientes, efectos comerciales a cobrar','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('440000000','Deudores varios','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('460000000','Personal','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('470000000','Administraciones pÃblicas','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000000','Hacienda PÃblica, IVA soportado','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000001','IVA soportado 4%','A','','P','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000002','IVA soportado 7%','A','','P','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('472000003','IVA soportado 16%','A','','P','AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('475100000','Hacienda PÃblica, acreedor por retenciones practicadas','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('473000000','Hacienda PÃblica, retenciones y pagos a cuenta','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000000','Hacienda PÃblica, IVA repercutido','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000001','IVA repercutido 4%','A','','P','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000002','IVA repercutido 7%','A','','P','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('477000003','IVA repercutido 16%','A','','P','AR_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('480000000','Ajustes por periodificaciÃn','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('490000000','Provisiones por operaciones de trÃfico','A','','P','');
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('499999999','Grupo 5: cuentas financieras','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('500000000','EmprÃstitos y otras emisiones anÃlogas a corto plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('510000000','Deudas a corto plazo con empresas del grupo y asociadas','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('520000000','Deudas a corto plazo por prÃstamos recibidos y otros conceptos','A','','P','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('530000000','Inversiones financieras a corto plazo en empresas del grupo y asociadas','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('540000000','Otras inversiones financieras temporales','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('550000000','Otras cuentas no bancarias','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('560000000','Fianzas y depÃsitos recibidos y constituidos a corto plazo','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('569000000','TesorerÃa','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('570000000','Caja, euros','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('571000000','Caja, moneda extranjera','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('572000000','Bancos e instituciones de crÃdito, c/c. vista, euros','A','','A','AR_paid:AP_paid:AP_amount:AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('573000000','Bancos e instituciones de crÃdito, c/c. vista, moneda extranjera','A','','A','AR_paid:AP_paid:AP_amount:AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('574000000','Bancos e instituciones de crÃdito, cuentas de ahorro, euros','A','','A','AR_paid:AP_paid:AP_amount:AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('575000000','Bancos e instituciones de crÃdito, cuentas de ahorro, moneda extranjera','A','','A','AR_paid:AP_paid:AP_amount:AR_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('580000000','Ajustes por periodificaciÃn','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('590000000','Provisiones financieras','A','','P','');
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('599999999','Grupo 6: compras y gastos','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('600000000','Compras','A','','E','AP:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('608000000','Devoluciones de compras y operaciones similares','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('610000000','VariaciÃn de existencias','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('620000000','Servicios exteriores','A','','E','IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('630000000','Tributos','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('640000000','Gastos de personal','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('650000000','Otros gastos de gestiÃn','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('660000000','Gastos financieros','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('665000000','Descuentos sobre ventas por pronto pago','A','','E','IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('668000000','Diferencias negativas de cambio','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('670000000','PÃrdidas procedentes del inmovilizado y gastos excepcionales','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('680000000','Dotaciones para amortizaciones','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('690000000','Dotaciones a las provisiones','A','','E','');
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('699999999','Grupo 7: ventas e ingresos','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('700000000','Ventas de servicios y productos','A','','I','AR:IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('708000000','Devoluciones de ventas y operaciones similares','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('710000000','VariaciÃn de existencias','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('730000000','Trabajos realizados para la empresa','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('740000000','Subvenciones a la explotaciÃn','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('750000000','Otros ingresos de gestiÃn','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('760000000','Ingresos financieros','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('765000000','Descuentos sobre compras por pronto pago','A','','I','IC_sale:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('768000000','Diferencias positivas de cambio','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('770000000','Beneficios procedentes de inmovilizados e ingresos excepcionales','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('790000000','Excesos y aplicaciones de provisiones','A','','I','');
---
--- Taxes in Spain
---
--- IVA: 4, 7 or 16%
--- IVA soportado
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '472000000'), 0.0);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '472000001'), 0.04);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '472000002'), 0.07);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '472000003'), 0.16);
--- Recargo equivalente: 0.5, 1 or 4%
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '472000004'), 0.005);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '472000005'), 0.01);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '472000006'), 0.04);
---
--- IVA repercutido
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '477000000'), 0.0);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '477000001'), 0.04);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '477000002'), 0.07);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '477000003'), 0.16);
--- Recargo equivalente: 0.5, 1 or 4%
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '477000004'), 0.005);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '477000005'), 0.01);
-INSERT INTO "tax" ("chart_id", "rate") VALUES ((SELECT id FROM chart WHERE accno  = '477000006'), 0.04);
---
--- update defaults
---
-INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '300000000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '700000000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '600000000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '768000000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '668000000'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('curr', 'EUR');
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit' , 'Kg';
---
-
-commit;

Deleted: trunk/sql/Sweden-chart.sql
===================================================================
--- trunk/sql/Sweden-chart.sql	2007-03-06 04:16:33 UTC (rev 852)
+++ trunk/sql/Sweden-chart.sql	2007-03-06 04:31:39 UTC (rev 853)
@@ -1,1152 +0,0 @@
-begin;
--- May 7, 2006
--- Johan Hambraeus
---
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1','TillgÃngar ','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('10','Immateriella anlÃggningstillgÃngar ','H','','','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1010','Balanserade utgifter ','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1011','Balanserade utgifter fÃr forskning och utveckling ','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1012','Balanserade utgifter fÃr dataprogram','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1019','Ackumulerade avskrivningar pÃ balanserade utgifter','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1020','Koncessioner m m ','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1029','Ackumulerade avskrivningar pÃ koncessioner','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1030','Patent ','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1039','Ackumulerade avskrivningar pÃ patent ','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1040','Licenser ','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1049','Ackumulerade avskrivningar pÃ licenser','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1050','VarumÃrken ','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1059','Ackumulerade avskrivningar pÃ varumÃrken','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1060','HyresrÃtter ','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1069','Ackumulerade avskrivningar pÃ hyresrÃtter ','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1070','Goodwill ','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1079','Ackumulerade avskrivningar pÃ goodwill','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1080','PÃgÃende projekt och fÃrskott fÃr immateriella anlÃggningstillgÃngar','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1081','PÃgÃende projekt och fÃrskott fÃr immateriella anlÃggningstillgÃngar ','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1088','FÃrskott fÃr immateriella anlÃggningstillgÃngar','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1090','Ãvriga immateriella anlÃggningstillgÃngar','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1099','Ackumulerade avskrivningar pÃ Ãvriga immateriella anlÃggningstillgÃngar','A','234','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11','Byggnader och mark','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1110','Byggnader','A','237','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1111','Byggnader pÃ egen mark','A','237','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1112','Byggnader pÃ ofri grund','A','237','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1119','Ackumulerade avskrivningar pÃ byggnader','A','237','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1130','Mark','A','237','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1140','Tomter och obebyggda markomrÃden','A','237','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1150','MarkanlÃggning','A','237','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1159','Ackumulerade avskrivningar pÃ markanlÃggning','A','237','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1180','PÃgÃende nyanlÃggningar och fÃrskott fÃr byggnader och mark','A','237','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1181','PÃgÃende nybyggnad','A','237','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1182','PÃgÃende tillbyggnad','A','237','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1183','PÃgÃende ombyggnad','A','237','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1188','FÃrskott fÃr byggnader och mark','A','237','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1190','Ãvriga byggnader och mark','A','237','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1199','Ackumulerade avskrivningar pÃ Ãvriga byggnader','A','237','A','');

@@ Diff output truncated at 100000 characters. @@

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
Prev by Date: SF.net SVN: ledger-smb: [852] trunk/sql
Next by Date: SF.net SVN: ledger-smb: [854] trunk/TODO
Previous by thread: SF.net SVN: ledger-smb: [852] trunk/sql
Next by thread: SF.net SVN: ledger-smb: [854] trunk/TODO
Index(es):
- Date
- Thread