[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[3392] trunk/sql/coa

Subject: SF.net SVN: ledger-smb:[3392] trunk/sql/coa
From: ..hidden..
Date: Thu, 30 Jun 2011 19:06:29 +0000
Revision: 3392
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3392&view=rev
Author:   ehuelsmann
Date:     2011-06-30 19:06:28 +0000 (Thu, 30 Jun 2011)

Log Message:
-----------
Fix the other CoA files which didn't load.

Modified Paths:
--------------
    trunk/sql/coa/be/chart/General.sql
    trunk/sql/coa/ca/chart/French-Quebec_General.sql
    trunk/sql/coa/id/chart/General.sql
    trunk/sql/coa/nl/chart/Simple.sql
    trunk/sql/coa/tw/chart/General.sql
    trunk/sql/coa/uk/chart/General.sql
    trunk/sql/coa/us/chart/Manufacturing.sql
    trunk/sql/coa/us/chart/Service.sql
    trunk/sql/coa/us/chart/UCOA-Form990.sql
    trunk/sql/coa/us/chart/UCOA-Form990EZ.sql

Modified: trunk/sql/coa/be/chart/General.sql
===================================================================
--- trunk/sql/coa/be/chart/General.sql	2011-06-30 16:24:46 UTC (rev 3391)
+++ trunk/sql/coa/be/chart/General.sql	2011-06-30 19:06:28 UTC (rev 3392)
@@ -11,25 +11,25 @@
 SELECT account_save(NULL,'4168','Rabais, ristournes, remises Ã obtenir et autres avoirs non encore reÃus','A','416', NULL, '0',string_to_array('AP_paid', ':'));
 SELECT account_heading_save(NULL, '43', 'Dettes financiÃres - FinanciÃle schulden', NULL);
 SELECT account_save(NULL,'2400','Mobilier - Meubilair','A','24', NULL, '0',string_to_array('', ':'));
-SELECT account_save(NULL,'240190','MatÃriel bureau amort. anterieurs - Afschr. op bureaumaterieel vorig boekj.','A','24', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'221900','Constructions amort. anterieurs - Afschr. op gebouwen vorig boekj.','A','22', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'221910','Constructions amort. de l''exercice - Afschr. op gebouwen dit boekj.','A','22', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'240190','MatÃriel bureau amort. anterieurs - Afschr. op bureaumaterieel vorig boekj.','A','24', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'221900','Constructions amort. anterieurs - Afschr. op gebouwen vorig boekj.','A','22', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'221910','Constructions amort. de l''exercice - Afschr. op gebouwen dit boekj.','A','22', NULL, true, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '75', 'Produits financiers - FinanciÃle opbrengsten', NULL);
-SELECT account_save(NULL,'230900','Inst. techniques amort. anterieurs - Afschr. op installaties vorig boekj.','A','23', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'240090','Mobilier amort. anter. - Afschr. op meubilair vorig boekj.','A','24', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'240091','Mobilier amort. exercice - Afschr. op meubilair dit boekj.','A','24', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'240191','MatÃriel bureau amort. exercice - Afschr. op bureaumaterieel dit boekj.','A','24', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'240290','Materiel Informatique amort. anter. - Afschr. op hardware vorig boekj.','A','24', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'240291','Mat. informat. amort. exercice - Afschr. op hardware dit boekj.','A','24', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'241900','Voiture amort. anter. - Afschr. op wagen vorig boekj.','A','24', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'241910','Voiture amort. exercice - Afschr. op wagen dit boekj. ','A','24', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'260900','Amen. loc. louÃs amort. anter. - Inrichtingskost. vorig boekj.','A','26', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'230910','Inst. techniques amort. exercice - Afschr. op installaties dit boekj.','A','23', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'231900','Mach. et gros mat. amort. anterieurs - Afschr. op machines vorig boekj.','A','23', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'231910','Mach. et gros mat. amort. exercice - Afschr. op machines dit boekj.','A','23', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'237900','Outillage amort. anterieurs - Afschr. op uitrusting vorig boekj.','A','23', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'237910','Outillage amort. exercice - Afschr. op uitrusting dit boekj.','A','23', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'260910','Amen. loc. louÃs amort. exercice - Inrichtingskost. dit boekj.','A','26', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'230900','Inst. techniques amort. anterieurs - Afschr. op installaties vorig boekj.','A','23', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'240090','Mobilier amort. anter. - Afschr. op meubilair vorig boekj.','A','24', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'240091','Mobilier amort. exercice - Afschr. op meubilair dit boekj.','A','24', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'240191','MatÃriel bureau amort. exercice - Afschr. op bureaumaterieel dit boekj.','A','24', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'240290','Materiel Informatique amort. anter. - Afschr. op hardware vorig boekj.','A','24', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'240291','Mat. informat. amort. exercice - Afschr. op hardware dit boekj.','A','24', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'241900','Voiture amort. anter. - Afschr. op wagen vorig boekj.','A','24', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'241910','Voiture amort. exercice - Afschr. op wagen dit boekj. ','A','24', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'260900','Amen. loc. louÃs amort. anter. - Inrichtingskost. vorig boekj.','A','26', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'230910','Inst. techniques amort. exercice - Afschr. op installaties dit boekj.','A','23', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'231900','Mach. et gros mat. amort. anterieurs - Afschr. op machines vorig boekj.','A','23', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'231910','Mach. et gros mat. amort. exercice - Afschr. op machines dit boekj.','A','23', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'237900','Outillage amort. anterieurs - Afschr. op uitrusting vorig boekj.','A','23', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'237910','Outillage amort. exercice - Afschr. op uitrusting dit boekj.','A','23', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'260910','Amen. loc. louÃs amort. exercice - Inrichtingskost. dit boekj.','A','26', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'451541','TVA DUE VENTES 21%','L','451', NULL, '0',string_to_array('AR_tax:IC_taxpart:IC_taxservice', ':'));
 SELECT account_save(NULL,'612200','Carburants voitures','E','61', NULL, '0',string_to_array('AP_amount:IC_expense', ':'));
 SELECT account_save(NULL,'630','Dotations amort., rÃduction valeur s/immo. - Afschr., waardeverm. op v. a., toevoeging','E','63', NULL, '0',string_to_array('', ':'));

Modified: trunk/sql/coa/ca/chart/French-Quebec_General.sql
===================================================================
--- trunk/sql/coa/ca/chart/French-Quebec_General.sql	2011-06-30 16:24:46 UTC (rev 3391)
+++ trunk/sql/coa/ca/chart/French-Quebec_General.sql	2011-06-30 19:06:28 UTC (rev 3392)
@@ -20,9 +20,9 @@
 SELECT account_save(NULL,'1540','Inventaire / MatiÃres premiÃres','A','1122', NULL, false, false, string_to_array('IC', ':'));
 SELECT account_heading_save(NULL, '1800', 'AUTRES IMMOBILISATIONS', NULL);
 SELECT account_save(NULL,'1820','Meubles et accessoires','A','1787', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1825','Amortissement cumulÃ des meubles et des accessoires','A','1788', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'1825','Amortissement cumulÃ des meubles et des accessoires','A','1788', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1840','VÃhicules automobiles','A','1742', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1845','Amortissement cumulÃ des vÃhicules automobiles','A','1743', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'1845','Amortissement cumulÃ des vÃhicules automobiles','A','1743', NULL, true, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL, '2000', 'PASSIF COURANT', NULL);
 SELECT account_save(NULL,'2100','Comptes fournisseurs','L','2621', NULL, false, false, string_to_array('AP', ':'));
 SELECT account_save(NULL,'2160','Taxes fÃdÃrales Ã payer','L','2683', NULL, false, false, string_to_array('', ':'));

Modified: trunk/sql/coa/id/chart/General.sql
===================================================================
--- trunk/sql/coa/id/chart/General.sql	2011-06-30 16:24:46 UTC (rev 3391)
+++ trunk/sql/coa/id/chart/General.sql	2011-06-30 19:06:28 UTC (rev 3392)
@@ -10,9 +10,9 @@
 SELECT account_save(NULL,'1530','Inventory / Aftermarket Parts','A','', NULL, false, false, string_to_array('IC', ':'));
 SELECT account_heading_save(NULL,'1800','AKTIVA TETAP', NULL);
 SELECT account_save(NULL,'1820','Perabot Kantor & Peralatan','A','', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1825','Akumulasi Amort. Perabot & Peralatan','A','', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'1825','Akumulasi Amort. Perabot & Peralatan','A','', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1840','Kendaraan','A','', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1845','Akumulasi Amort. Kendaraan','A','', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'1845','Akumulasi Amort. Kendaraan','A','', NULL, true, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'2000','HUTANG LANCAR', NULL);
 SELECT account_save(NULL,'2100','Hutang Dagang','L','', NULL, false, false, string_to_array('AP', ':'));
 SELECT account_save(NULL,'2160','Hutang Pajak','L','', NULL, false, false, string_to_array('', ':'));

Modified: trunk/sql/coa/nl/chart/Simple.sql
===================================================================
--- trunk/sql/coa/nl/chart/Simple.sql	2011-06-30 16:24:46 UTC (rev 3391)
+++ trunk/sql/coa/nl/chart/Simple.sql	2011-06-30 19:06:28 UTC (rev 3392)
@@ -14,9 +14,9 @@
 SELECT account_save(NULL,'1540','Voorraad / Aftermarket Parts','A','', NULL, false, false, string_to_array('IC', ':'));
 SELECT account_heading_save(NULL,'1800','LANGE TERMIJN ACTIVA', NULL);
 SELECT account_save(NULL,'1820','Inventaris','A','', NULL, false, false, string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'1825','Afschrijving inventaris','A','', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'1825','Afschrijving inventaris','A','', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1840','Auto','A','', NULL, false, false, string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'1845','Afschrijving auto','A','', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'1845','Afschrijving auto','A','', NULL, true, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'2000','HUIDIGE PASSIVA', NULL);
 SELECT account_save(NULL,'2100','Crediteuren','L','', NULL, false, false, string_to_array('AP', ':'));
 SELECT account_save(NULL,'2160','Niet-rijks Belastingen','L','', NULL, false, false, string_to_array('', ':'));

Modified: trunk/sql/coa/tw/chart/General.sql
===================================================================
--- trunk/sql/coa/tw/chart/General.sql	2011-06-30 16:24:46 UTC (rev 3391)
+++ trunk/sql/coa/tw/chart/General.sql	2011-06-30 19:06:28 UTC (rev 3392)
@@ -13,8 +13,8 @@
 SELECT account_heading_save(NULL,'5400','èèæå', NULL);
 SELECT account_heading_save(NULL,'5600','æååççæå', NULL);
 SELECT account_save(NULL,'1205','åååæ','A','', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1825','çèåæäæ - èçåèå.','A','', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'1845','çèåæäæ - éèåå','A','', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'1825','çèåæäæ - èçåèå.','A','', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'1845','çèåæäæ - éèåå','A','', NULL, true, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'2000','æåèå', NULL);
 SELECT account_save(NULL,'2190','æäæåç','L','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'2620','éèåæ','L','', NULL, false, false, string_to_array('', ':'));

Modified: trunk/sql/coa/uk/chart/General.sql
===================================================================
--- trunk/sql/coa/uk/chart/General.sql	2011-06-30 16:24:46 UTC (rev 3391)
+++ trunk/sql/coa/uk/chart/General.sql	2011-06-30 19:06:28 UTC (rev 3392)
@@ -6,13 +6,13 @@
 SELECT account_save(NULL,'0011','Goodwill','A','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'0012','Goodwill Amortisation','A','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'0020','Plant and Machinery','A','', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'0021','Plant/Machinery Depreciation','A','', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'0021','Plant/Machinery Depreciation','A','', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'0030','Office Equipment','A','', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'0031','Office Equipment Depreciation','A','', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'0031','Office Equipment Depreciation','A','', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'0040','Furniture and Fixtures','A','', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'0041','Furniture/Fixture Depreciation','A','', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'0041','Furniture/Fixture Depreciation','A','', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'0050','Motor Vehicles','A','', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'0051','Motor Vehicles Depreciation','A','', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'0051','Motor Vehicles Depreciation','A','', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1001','Stock','A','', NULL, false, false, string_to_array('IC', ':'));
 SELECT account_save(NULL,'1002','Work in Progress','A','', NULL, false, false, string_to_array('IC', ':'));
 SELECT account_save(NULL,'1100','Debtors Control Account','A','', NULL, false, false, string_to_array('AR', ':'));

Modified: trunk/sql/coa/us/chart/Manufacturing.sql
===================================================================
--- trunk/sql/coa/us/chart/Manufacturing.sql	2011-06-30 16:24:46 UTC (rev 3391)
+++ trunk/sql/coa/us/chart/Manufacturing.sql	2011-06-30 19:06:28 UTC (rev 3392)
@@ -16,9 +16,9 @@
 
 SELECT account_heading_save(NULL,'1800','CAPITAL ASSETS', NULL);
 SELECT account_save(NULL,'1820','Office Furniture & Equipment','A','', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1825','Accum. Amort. -Furn. & Equip.','A','', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'1825','Accum. Amort. -Furn. & Equip.','A','', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1840','Vehicle','A','', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1845','Accum. Amort. -Vehicle','A','', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'1845','Accum. Amort. -Vehicle','A','', NULL, true, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'2000','CURRENT LIABILITIES', NULL);
 SELECT account_save(NULL,'2100','Accounts Payable','L','', NULL, false, false, string_to_array('AP', ':'));
 SELECT account_heading_save(NULL,'2600','LONG TERM LIABILITIES', NULL);

Modified: trunk/sql/coa/us/chart/Service.sql
===================================================================
--- trunk/sql/coa/us/chart/Service.sql	2011-06-30 16:24:46 UTC (rev 3391)
+++ trunk/sql/coa/us/chart/Service.sql	2011-06-30 19:06:28 UTC (rev 3392)
@@ -11,9 +11,9 @@
 SELECT account_save(NULL,'1520','Inventory','A','', NULL, false, 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, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1825','Accum. Amort. -Furn. & Equip.','A','', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'1825','Accum. Amort. -Furn. & Equip.','A','', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1840','Vehicle','A','', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1845','Accum. Amort. -Vehicle','A','', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'1845','Accum. Amort. -Vehicle','A','', NULL, true, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'2000','CURRENT LIABILITIES', NULL);
 SELECT account_save(NULL,'2100','Accounts Payable','L','', NULL, false, false, string_to_array('AP', ':'));
 SELECT account_heading_save(NULL,'2600','LONG TERM LIABILITIES', NULL);

Modified: trunk/sql/coa/us/chart/UCOA-Form990.sql
===================================================================
--- trunk/sql/coa/us/chart/UCOA-Form990.sql	2011-06-30 16:24:46 UTC (rev 3391)
+++ trunk/sql/coa/us/chart/UCOA-Form990.sql	2011-06-30 19:06:28 UTC (rev 3392)
@@ -8,17 +8,17 @@
 SELECT account_save(NULL,'1070','Savings & short-term investments','A','46', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'1100','Accounts receivable', NULL);
 SELECT account_save(NULL,'1110','Accounts receivable','A','47a', NULL, false, false, string_to_array('AR', ':'));
-SELECT account_save(NULL,'1115','Doubtful accounts allowance','A','47b', NULL, '1',string_to_array('AR_paid', ':'));
+SELECT account_save(NULL,'1115','Doubtful accounts allowance','A','47b', NULL, true, false, string_to_array('AR_paid', ':'));
 SELECT account_heading_save(NULL,'1200','Contributions receivable', NULL);
 SELECT account_save(NULL,'1210','Pledges receivable','A','48a', NULL, false, false, string_to_array('AR', ':'));
-SELECT account_save(NULL,'1215','Doubtful pledges allowance','A','48b', NULL, '1',string_to_array('AR_paid', ':'));
-SELECT account_save(NULL,'1225','Discounts - long-term pledges','A','48a', NULL, '1',string_to_array('AR_paid', ':'));
+SELECT account_save(NULL,'1215','Doubtful pledges allowance','A','48b', NULL, true, false, string_to_array('AR_paid', ':'));
+SELECT account_save(NULL,'1225','Discounts - long-term pledges','A','48a', NULL, true, false, string_to_array('AR_paid', ':'));
 SELECT account_save(NULL,'1240','Grants receivable','A','49', NULL, false, false, string_to_array('AR', ':'));
-SELECT account_save(NULL,'1245','Discounts - long-term grants','A','49', NULL, '1',string_to_array('AR_paid', ':'));
+SELECT account_save(NULL,'1245','Discounts - long-term grants','A','49', NULL, true, false, string_to_array('AR_paid', ':'));
 SELECT account_heading_save(NULL,'1300','Other receivables', NULL);
 SELECT account_save(NULL,'1310','Employee & trustee receivables','A','50', NULL, false, false, string_to_array('AR', ':'));
 SELECT account_save(NULL,'1320','Notes/loans receivable','A','51a', NULL, false, false, string_to_array('AR', ':'));
-SELECT account_save(NULL,'1325','Doubtful notes/loans allowance','A','51b', NULL, '1',string_to_array('AR_paid', ':'));
+SELECT account_save(NULL,'1325','Doubtful notes/loans allowance','A','51b', NULL, true, false, string_to_array('AR_paid', ':'));
 SELECT account_heading_save(NULL,'1400','Other assets', NULL);
 SELECT account_save(NULL,'1410','Inventories for sale','A','52', NULL, false, false, string_to_array('IC', ':'));
 SELECT account_save(NULL,'1420','Inventories for use','A','52', NULL, false, false, string_to_array('IC', ':'));
@@ -28,7 +28,7 @@
 SELECT account_save(NULL,'1510','Marketable securities ','A','54', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1530','Land held for investment','A','55a', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1540','Buildings held for investment','A','55a', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1545','Accum deprec - bldg investment','A','55b', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'1545','Accum deprec - bldg investment','A','55b', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1580','Investments - other','A','56', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'1600','Fixed operating assets', NULL);
 SELECT account_save(NULL,'1610','Land - operating','A','57a', NULL, false, false, string_to_array('', ':'));
@@ -38,10 +38,10 @@
 SELECT account_save(NULL,'1650','Vehicles','A','57a', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1660','Construction in progress','A','57a', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'1700','Accum deprec - fixed operating assets', NULL);
-SELECT account_save(NULL,'1725','Accum deprec - building','A','57b', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'1735','Accum amort - leasehold improvements','A','57b', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'1745','Accum deprec - furn,fix,equip','A','57b', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'1755','Accum deprec - vehicles','A','57b', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'1725','Accum deprec - building','A','57b', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'1735','Accum amort - leasehold improvements','A','57b', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'1745','Accum deprec - furn,fix,equip','A','57b', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'1755','Accum deprec - vehicles','A','57b', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1810','Other long-term assets','A','58', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1850','Split-interest agreements','A','58', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1910','Collections - art, etc','A','58', NULL, false, false, string_to_array('', ':'));
@@ -86,8 +86,8 @@
 SELECT account_save(NULL,'4010','Individual/small business contributions','I','1a', NULL, false, false, string_to_array('AR_amount:IC_income', ':'));
 SELECT account_save(NULL,'4020','Corporate contributions','I','1a', NULL, false, false, string_to_array('AR_amount:IC_income', ':'));
 SELECT account_save(NULL,'4070','Legacies & bequests','I','1a', NULL, false, false, string_to_array('AR_amount', ':'));
-SELECT account_save(NULL,'4075','Uncollectible pledges - estimated','I','contra1a', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'4085','Long-term pledges discount','I','contra1a', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'4075','Uncollectible pledges - estimated','I','contra1a', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'4085','Long-term pledges discount','I','contra1a', NULL, true, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'4100','Donated goods & services revenue', NULL);
 SELECT account_save(NULL,'4110','Donated professional services-GAAP','I','PartIV-A&82b', NULL, false, false, string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'4120','Donated other services - non-GAAP','I','PartIV-A&82b', NULL, false, false, string_to_array('AR_amount', ':'));
@@ -98,7 +98,7 @@
 SELECT account_save(NULL,'4210','Corporate/business grants','I','1a', NULL, false, false, string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'4230','Foundation/trust grants','I','1a', NULL, false, false, string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'4250','Nonprofit organization grants','I','1a', NULL, false, false, string_to_array('AR_amount', ':'));
-SELECT account_save(NULL,'4255','Discounts - long-term grants','I','contra1a', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'4255','Discounts - long-term grants','I','contra1a', NULL, true, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'4300','Revenue from split-interest agreements', NULL);
 SELECT account_save(NULL,'4310','Split-interest agreement contributions','I','1a', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'4350','Gain (loss) split-interest agreements','I','20', NULL, false, false, string_to_array('', ':'));
@@ -131,15 +131,15 @@
 SELECT account_save(NULL,'5340','Real estate rent - not debt-financed','I','6a&97b', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'5345','Real estate rental cost - not debt-financed','I','6b&97b', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'5350','Personal property rent','I','6a&98', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'5355','Personal property rental cost','I','6b&98', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'5355','Personal property rental cost','I','6b&98', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'5360','Other investment income','I','7&99', NULL, false, false, string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'5370','Securities sales - gross','I','8a-(A)&100', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'5375','Securities sales cost ','I','8b-(A)&100', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'5375','Securities sales cost ','I','8b-(A)&100', NULL, true, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'5400','Revenue from other sources', NULL);
 SELECT account_save(NULL,'5410','Non-inventory sales - gross','I','8a-(B)&100', NULL, false, false, string_to_array('AR_amount:IC_income', ':'));
-SELECT account_save(NULL,'5415','Non-inventory sales cost ','I','8b-(B)&100', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'5415','Non-inventory sales cost ','I','8b-(B)&100', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'5440','Gross sales - inventory','I','10a&102', NULL, false, false, string_to_array('AR_amount:IC_sale', ':'));
-SELECT account_save(NULL,'5445','Cost of inventory sold ','I','10b&102', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'5445','Cost of inventory sold ','I','10b&102', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'5450','Advertising revenue','I','11&103', NULL, false, false, string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'5460','Affiliate revenues from other entities','I','11&103', NULL, false, false, string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'5490','Misc revenue','I','11&103', NULL, false, false, string_to_array('AR_amount', ':'));

Modified: trunk/sql/coa/us/chart/UCOA-Form990EZ.sql
===================================================================
--- trunk/sql/coa/us/chart/UCOA-Form990EZ.sql	2011-06-30 16:24:46 UTC (rev 3391)
+++ trunk/sql/coa/us/chart/UCOA-Form990EZ.sql	2011-06-30 19:06:28 UTC (rev 3392)
@@ -8,17 +8,17 @@
 SELECT account_save(NULL,'1070','Savings & short-term investments','A','22', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'1100','Accounts receivable', NULL);
 SELECT account_save(NULL,'1110','Accounts receivable','A','24', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1115','Doubtful accounts allowance','A','24', NULL, '1',string_to_array('AR_paid', ':'));
+SELECT account_save(NULL,'1115','Doubtful accounts allowance','A','24', NULL, true, false, string_to_array('AR_paid', ':'));
 SELECT account_heading_save(NULL,'1200','Contributions receivable', NULL);
 SELECT account_save(NULL,'1210','Pledges receivable','A','24', NULL, false, false, string_to_array('AR', ':'));
-SELECT account_save(NULL,'1215','Doubtful pledges allowance','A','24', NULL, '1',string_to_array('AR_paid', ':'));
-SELECT account_save(NULL,'1225','Discounts - long-term pledges','A','24', NULL, '1',string_to_array('AR_paid', ':'));
+SELECT account_save(NULL,'1215','Doubtful pledges allowance','A','24', NULL, true, false, string_to_array('AR_paid', ':'));
+SELECT account_save(NULL,'1225','Discounts - long-term pledges','A','24', NULL, true, false, string_to_array('AR_paid', ':'));
 SELECT account_save(NULL,'1240','Grants receivable','A','24', NULL, false, false, string_to_array('AR', ':'));
-SELECT account_save(NULL,'1245','Discounts - long-term grants','A','24', NULL, '1',string_to_array('AR_paid', ':'));
+SELECT account_save(NULL,'1245','Discounts - long-term grants','A','24', NULL, true, false, string_to_array('AR_paid', ':'));
 SELECT account_heading_save(NULL,'1300','Other receivables', NULL);
 SELECT account_save(NULL,'1310','Employee & trustee receivables','A','24', NULL, false, false, string_to_array('AR', ':'));
 SELECT account_save(NULL,'1320','Notes/loans receivable','A','24', NULL, false, false, string_to_array('AR', ':'));
-SELECT account_save(NULL,'1325','Doubtful notes/loans allowance','A','24', NULL, '1',string_to_array('AR_paid', ':'));
+SELECT account_save(NULL,'1325','Doubtful notes/loans allowance','A','24', NULL, true, false, string_to_array('AR_paid', ':'));
 SELECT account_heading_save(NULL,'1400','Other assets', NULL);
 SELECT account_save(NULL,'1410','Inventories for sale','A','24', NULL, false, false, string_to_array('IC', ':'));
 SELECT account_save(NULL,'1420','Inventories for use','A','24', NULL, false, false, string_to_array('IC', ':'));
@@ -28,7 +28,7 @@
 SELECT account_save(NULL,'1510','Marketable securities ','A','22', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1530','Land held for investment','A','22', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1540','Buildings held for investment','A','22', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'1545','Accum deprec - bldg investment','A','22', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'1545','Accum deprec - bldg investment','A','22', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1580','Investments - other','A','22', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'1600','Fixed operating assets', NULL);
 SELECT account_save(NULL,'1610','Land - operating','A','23', NULL, false, false, string_to_array('', ':'));
@@ -38,10 +38,10 @@
 SELECT account_save(NULL,'1650','Vehicles','A','24', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1660','Construction in progress','A','24', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'1700','Accum deprec - fixed operating assets', NULL);
-SELECT account_save(NULL,'1725','Accum deprec - building','A','23', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'1735','Accum amort - leasehold improvements','A','24', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'1745','Accum deprec - furn,fix,equip','A','24', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'1755','Accum deprec - vehicles','A','24', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'1725','Accum deprec - building','A','23', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'1735','Accum amort - leasehold improvements','A','24', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'1745','Accum deprec - furn,fix,equip','A','24', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'1755','Accum deprec - vehicles','A','24', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1810','Other long-term assets','A','24', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1850','Split-interest agreements','A','24', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1910','Collections - art, etc','A','24', NULL, false, false, string_to_array('', ':'));
@@ -86,8 +86,8 @@
 SELECT account_save(NULL,'4010','Individual/small business contributions','I','1', NULL, false, false, string_to_array('AR_amount:IC_income', ':'));
 SELECT account_save(NULL,'4020','Corporate contributions','I','1', NULL, false, false, string_to_array('AR_amount:IC_income', ':'));
 SELECT account_save(NULL,'4070','Legacies & bequests','I','1', NULL, false, false, string_to_array('AR_amount', ':'));
-SELECT account_save(NULL,'4075','Uncollectible pledges - estimated','I','1', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'4085','Long-term pledges discount','I','1', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'4075','Uncollectible pledges - estimated','I','1', NULL, true, false, string_to_array('', ':'));
+SELECT account_save(NULL,'4085','Long-term pledges discount','I','1', NULL, true, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'4100','Donated goods & services revenue', NULL);
 SELECT account_save(NULL,'4110','Donated professional services-GAAP','I','', NULL, false, false, string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'4120','Donated other services - non-GAAP','I','', NULL, false, false, string_to_array('AR_amount', ':'));
@@ -98,7 +98,7 @@
 SELECT account_save(NULL,'4210','Corporate/business grants','I','1', NULL, false, false, string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'4230','Foundation/trust grants','I','1', NULL, false, false, string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'4250','Nonprofit organization grants','I','1', NULL, false, false, string_to_array('AR_amount', ':'));
-SELECT account_save(NULL,'4255','Discounts - long-term grants','I','1', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'4255','Discounts - long-term grants','I','1', NULL, true, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'4300','Revenue from split-interest agreements', NULL);
 SELECT account_save(NULL,'4310','Split-interest agreement contributions','I','1', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'4350','Gain (loss) split-interest agreements','I','1', NULL, false, false, string_to_array('', ':'));
@@ -131,15 +131,15 @@
 SELECT account_save(NULL,'5340','Real estate rent - not debt-financed','I','8', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'5345','Real estate rental cost - not debt-financed','I','8', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'5350','Personal property rent','I','8', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'5355','Personal property rental cost','I','8', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'5355','Personal property rental cost','I','8', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'5360','Other investment income','I','4', NULL, false, false, string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'5370','Securities sales - gross','I','5a', NULL, false, false, string_to_array('', ':'));
-SELECT account_save(NULL,'5375','Securities sales cost ','I','5b', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'5375','Securities sales cost ','I','5b', NULL, true, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'5400','Revenue from other sources', NULL);
 SELECT account_save(NULL,'5410','Non-inventory sales - gross','I','5a', NULL, false, false, string_to_array('AR_amount:IC_income', ':'));
-SELECT account_save(NULL,'5415','Non-inventory sales cost ','I','5b', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'5415','Non-inventory sales cost ','I','5b', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'5440','Gross sales - inventory','I','8', NULL, false, false, string_to_array('AR_amount:IC_sale', ':'));
-SELECT account_save(NULL,'5445','Cost of inventory sold ','I','8', NULL, '1',string_to_array('', ':'));
+SELECT account_save(NULL,'5445','Cost of inventory sold ','I','8', NULL, true, false, string_to_array('', ':'));
 SELECT account_save(NULL,'5450','Advertising revenue','I','8', NULL, false, false, string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'5460','Affiliate revenues from other entities','I','8', NULL, false, false, string_to_array('AR_amount', ':'));
 SELECT account_save(NULL,'5490','Misc revenue','I','8', NULL, false, false, string_to_array('AR_amount', ':'));


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:[3391] trunk
Next by Date: SF.net SVN: ledger-smb:[3393] trunk/dists/deb/ubuntu/ubuntu.sh
Previous by thread: SF.net SVN: ledger-smb:[3391] trunk
Next by thread: SF.net SVN: ledger-smb:[3393] trunk/dists/deb/ubuntu/ubuntu.sh
Index(es):
- Date
- Thread