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

[..hidden..]

Revision: 2674
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2674&view=rev
Author:   einhverfr
Date:     2009-06-13 03:40:11 +0000 (Sat, 13 Jun 2009)

Log Message:
-----------
Minor corrections to a number of chart of accounts files

Modified Paths:
--------------
    trunk/sql/coa/Sample-chart.sql
    trunk/sql/coa/at/chart/General.sql
    trunk/sql/coa/au/chart/General-00000.sql
    trunk/sql/coa/br/chart/General.sql

Modified: trunk/sql/coa/Sample-chart.sql
===================================================================
--- trunk/sql/coa/Sample-chart.sql	2009-06-12 21:48:35 UTC (rev 2673)
+++ trunk/sql/coa/Sample-chart.sql	2009-06-13 03:40:11 UTC (rev 2674)
@@ -11,9 +11,9 @@
 SELECT account_save(NULL,'1530','Inventory / Aftermarket Parts','A','', NULL, false,string_to_array('IC', ':'));
 SELECT account_heading_save(NULL, '1800', 'CAPITAL ASSETS', NULL);
 SELECT account_save(NULL,'1820','Office Furniture & Equipment','A','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1825','Accum. Amort. -Furn. & Equip.','A','', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'1825','Accum. Amort. -Furn. & Equip.','A','', NULL, true,string_to_array('',':'));
 SELECT account_save(NULL,'1840','Vehicle','A','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1845','Accum. Amort. -Vehicle','A','', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'1845','Accum. Amort. -Vehicle','A','', NULL, true,string_to_array('',':'));
 SELECT account_heading_save(NULL, '2000', 'CURRENT LIABILITIES', NULL);
 SELECT account_save(NULL,'2100','Accounts Payable','L','', NULL, false,string_to_array('AP', ':'));
 SELECT account_save(NULL,'2160','Corporate Taxes Payable','L','', NULL, false,string_to_array('', ':'));

Modified: trunk/sql/coa/at/chart/General.sql
===================================================================
--- trunk/sql/coa/at/chart/General.sql	2009-06-12 21:48:35 UTC (rev 2673)
+++ trunk/sql/coa/at/chart/General.sql	2009-06-13 03:40:11 UTC (rev 2674)
@@ -10,16 +10,16 @@
 SELECT account_heading_save(NULL, '0200', 'GRUNDSTÃCKE', NULL);
 SELECT account_save(NULL,'0210','unbebaute GrundstÃcke','A','020', NULL, false,string_to_array('AP_amount', ':'));
 SELECT account_save(NULL,'0220','bebaute GrundstÃcke','A','021', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'0229','kum. Abschreibung bebaute GrundstÃcke','A','039', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'0229','kum. Abschreibung bebaute GrundstÃcke','A','039', NULL, true,string_to_array('', ':'));
 SELECT account_heading_save(NULL, '0400', 'MASCHINEN', NULL);
 SELECT account_save(NULL,'0410','Maschinen','A','041', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'0419','kum. Abschreibung Maschinen','A','069', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'0419','kum. Abschreibung Maschinen','A','069', NULL, true,string_to_array('', ':'));
 SELECT account_heading_save(NULL, '0500', 'FAHRZEUGE', NULL);
 SELECT account_save(NULL,'0510','Fahrzeuge','A','063', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'0519','kum. Abschreibung Fahrzeuge','A','069', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'0519','kum. Abschreibung Fahrzeuge','A','069', NULL, true,string_to_array('', ':'));
 SELECT account_heading_save(NULL, '0600', 'BETRIEBS- UND GESCHÃFTSAUSSTATTUNG', NULL);
 SELECT account_save(NULL,'0620','BÃroeinrichtungen','A','066', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'0625','kum. Abschreibung Betriebs- und GeschÃftsausstattung','A','069', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'0625','kum. Abschreibung Betriebs- und GeschÃftsausstattung','A','069', NULL, true,string_to_array('', ':'));
 SELECT account_heading_save(NULL, '0700', 'GELEISTETE ANZAHLUNGEN', NULL);
 SELECT account_heading_save(NULL, '0800', 'FINANZANLAGEN', NULL);
 SELECT account_save(NULL,'0810','Beteiligungen','A','081', NULL, false,string_to_array('AP_amount', ':'));

Modified: trunk/sql/coa/au/chart/General-00000.sql
===================================================================
--- trunk/sql/coa/au/chart/General-00000.sql	2009-06-12 21:48:35 UTC (rev 2673)
+++ trunk/sql/coa/au/chart/General-00000.sql	2009-06-13 03:40:11 UTC (rev 2674)
@@ -16,11 +16,11 @@
 SELECT account_save(NULL,'16001','INPUT GST','L','160', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_heading_save(NULL, '18000', 'CAPITAL ASSETS', NULL);
 SELECT account_save(NULL,'18001','Land and Buildings','A','180', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'18002','Accumulated Amortization -Land & Buildings','A','180', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'18002','Accumulated Amortization -Land & Buildings','A','180', NULL, true,string_to_array('', ':'));
 SELECT account_save(NULL,'18003','Office Furniture & Equipment','A','180', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'18004','Accumulated Amortization -Furniture & Equipment','A','180', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'18004','Accumulated Amortization -Furniture & Equipment','A','180', NULL, true,string_to_array('', ':'));
 SELECT account_save(NULL,'18005','Vehicle','A','180', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'18006','Accumulated Amortization -Vehicle','A','180', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'18006','Accumulated Amortization -Vehicle','A','180', NULL, true,string_to_array('', ':'));
 SELECT account_heading_save(NULL, '20000', 'CURRENT LIABILITIES', NULL);
 SELECT account_save(NULL,'20001','Accounts Payable','L','200', NULL, false,string_to_array('AP', ':'));
 SELECT account_heading_save(NULL, '21000', 'STATUTORY CREDITORS', NULL);

Modified: trunk/sql/coa/br/chart/General.sql
===================================================================
--- trunk/sql/coa/br/chart/General.sql	2009-06-12 21:48:35 UTC (rev 2673)
+++ trunk/sql/coa/br/chart/General.sql	2009-06-13 03:40:11 UTC (rev 2674)
@@ -12,9 +12,9 @@
 SELECT account_save(NULL,'1540','InventÃrio / Computer Parts','A','', NULL, false,string_to_array('IC', ':'));
 SELECT account_heading_save(NULL, '1800', 'CAPITAL ASSETS', NULL);
 SELECT account_save(NULL,'1820','EscritÃrio MÃvel & Equipamentos','A','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1825','Accum. Amort. -MÃvel. & Equip.','A','', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'1825','Accum. Amort. -MÃvel. & Equip.','A','', NULL, true,string_to_array('', ':'));
 SELECT account_save(NULL,'1840','VeÃculo','A','', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1845','Accum. Amort. -VeÃculo','A','', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'1845','Accum. Amort. -VeÃculo','A','', NULL, true,string_to_array('', ':'));
 SELECT account_heading_save(NULL, '2000', 'BALANÃO ATUAL', NULL);
 SELECT account_save(NULL,'2100','Contas a Pagar','L','', NULL, false,string_to_array('AP', ':'));
 SELECT account_save(NULL,'2170','Taxas federais','L','', NULL, false,string_to_array('', ':'));


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