[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[2681] trunk/sql/coa
- Subject: SF.net SVN: ledger-smb:[2681] trunk/sql/coa
- From: ..hidden..
- Date: Sat, 13 Jun 2009 18:13:12 +0000
Revision: 2681
http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2681&view=rev
Author: einhverfr
Date: 2009-06-13 18:13:11 +0000 (Sat, 13 Jun 2009)
Log Message:
-----------
Final changes to chart of accounts to correct load problems. As of now, every chart of accounts script loads in trunk.
Modified Paths:
--------------
trunk/sql/coa/tw/chart/General.sql
trunk/sql/coa/us/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
trunk/sql/coa/ve/chart/General.sql
Modified: trunk/sql/coa/tw/chart/General.sql
===================================================================
--- trunk/sql/coa/tw/chart/General.sql 2009-06-13 18:05:09 UTC (rev 2680)
+++ trunk/sql/coa/tw/chart/General.sql 2009-06-13 18:13:11 UTC (rev 2681)
@@ -1,27 +1,27 @@
begin;
-- Default chart of accounts -- sample only
-SELECT account_heading_save(NULL,'2600','éæèå', NULL));
-SELECT account_heading_save(NULL,'3300','èäèæ', NULL));
-SELECT account_heading_save(NULL,'3500','äççé', NULL));
-SELECT account_heading_save(NULL,'4000','éåçé', NULL));
-SELECT account_heading_save(NULL,'4300','èèçé', NULL));
-SELECT account_heading_save(NULL,'4400','ååçé', NULL));
-SELECT account_heading_save(NULL,'5000','èéææ', NULL));
-SELECT account_heading_save(NULL,'5400','èèæå', NULL));
-SELECT account_heading_save(NULL,'5600','æååççæå', NULL));
+SELECT account_heading_save(NULL,'1000','æåèç', NULL);
+SELECT account_heading_save(NULL,'1800','èæèç', NULL);
+SELECT account_heading_save(NULL,'2600','éæèå', NULL);
+SELECT account_heading_save(NULL,'3300','èäèæ', NULL);
+SELECT account_heading_save(NULL,'3500','äççé', NULL);
+SELECT account_heading_save(NULL,'4000','éåçé', NULL);
+SELECT account_heading_save(NULL,'1500','åèèç', NULL);
+SELECT account_heading_save(NULL,'4300','èèçé', NULL);
+SELECT account_heading_save(NULL,'4400','ååçé', NULL);
+SELECT account_heading_save(NULL,'5000','èéææ', NULL);
+SELECT account_heading_save(NULL,'5400','èèæå', NULL);
+SELECT account_heading_save(NULL,'5600','æååççæå', NULL);
SELECT account_save(NULL,'1205','åååæ','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'1000','æåèç', NULL));
-SELECT account_heading_save(NULL,'1800','èæèç', NULL));
SELECT account_save(NULL,'1825','çèåæäæ - èçåèå.','A','', NULL, '1',string_to_array('', ':'));
SELECT account_save(NULL,'1845','çèåæäæ - éèåå','A','', NULL, '1',string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2000','æåèå', NULL));
+SELECT account_heading_save(NULL,'2000','æåèå', NULL);
SELECT account_save(NULL,'2190','æäæåç','L','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2620','éèåæ','L','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'3600','æåçé','Q','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2160','æäååç','L','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'3590','äççé - ååå','Q','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'3350','æéèä','Q','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'1500','åèèç', NULL));
SELECT account_save(NULL,'5615','ååèé','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'5790','åå','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'5700','èåçå','E','', NULL, false,string_to_array('AP_amount', ':'));
Modified: trunk/sql/coa/us/chart/General.sql
===================================================================
--- trunk/sql/coa/us/chart/General.sql 2009-06-13 18:05:09 UTC (rev 2680)
+++ trunk/sql/coa/us/chart/General.sql 2009-06-13 18:13:11 UTC (rev 2681)
@@ -2,42 +2,42 @@
-- US_General COA
-- modify as needed
--
-SELECT account_heading_save(NULL,'1000','CURRENT ASSETS', NULL));
+SELECT account_heading_save(NULL,'1000','CURRENT ASSETS', NULL);
SELECT account_save(NULL,'1060','Checking Account','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'1065','Petty Cash','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'1200','Accounts Receivables','A','', NULL, false,string_to_array('AR', ':'));
SELECT account_save(NULL,'1205','Allowance for doubtful accounts','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'1500','INVENTORY ASSETS', NULL));
+SELECT account_heading_save(NULL,'1500','INVENTORY ASSETS', NULL);
SELECT account_save(NULL,'1510','Inventory','A','', NULL, false,string_to_array('IC', ':'));
-SELECT account_heading_save(NULL,'1800','CAPITAL ASSETS', NULL));
+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, '1',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, '1',string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2000','CURRENT LIABILITIES', NULL));
+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_heading_save(NULL,'2600','LONG TERM LIABILITIES', NULL));
+SELECT account_heading_save(NULL,'2600','LONG TERM LIABILITIES', NULL);
SELECT account_save(NULL,'2620','Bank Loans','L','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2680','Loans from Shareholders','L','', NULL, false,string_to_array('AP_paid', ':'));
-SELECT account_heading_save(NULL,'3300','SHARE CAPITAL', NULL));
+SELECT account_heading_save(NULL,'3300','SHARE CAPITAL', NULL);
SELECT account_save(NULL,'3350','Common Shares','Q','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'3500','RETAINED EARNINGS', NULL));
+SELECT account_heading_save(NULL,'3500','RETAINED EARNINGS', NULL);
SELECT account_save(NULL,'3590','Retained Earnings - prior years','Q','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'4000','SALES REVENUE', NULL));
+SELECT account_heading_save(NULL,'4000','SALES REVENUE', NULL);
SELECT account_save(NULL,'4010','Sales','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
-SELECT account_heading_save(NULL,'4400','OTHER REVENUE', NULL));
+SELECT account_heading_save(NULL,'4400','OTHER REVENUE', NULL);
SELECT account_save(NULL,'4430','Shipping & Handling','I','', NULL, false,string_to_array('IC_income', ':'));
SELECT account_save(NULL,'4440','Interest','I','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'4450','Foreign Exchange Gain','I','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5000','COST OF GOODS SOLD', NULL));
+SELECT account_heading_save(NULL,'5000','COST OF GOODS SOLD', NULL);
SELECT account_save(NULL,'5010','Purchases','E','', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
SELECT account_save(NULL,'5100','Freight','E','', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_heading_save(NULL,'5400','PAYROLL EXPENSES', NULL));
+SELECT account_heading_save(NULL,'5400','PAYROLL EXPENSES', NULL);
SELECT account_save(NULL,'5410','Wages & Salaries','E','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5600','GENERAL & ADMINISTRATIVE EXPENSES', NULL));
+SELECT account_heading_save(NULL,'5600','GENERAL & ADMINISTRATIVE EXPENSES', NULL);
SELECT account_save(NULL,'5610','Accounting & Legal','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'5615','Advertising & Promotions','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'5620','Bad Debts','E','', NULL, false,string_to_array('', ':'));
Modified: trunk/sql/coa/us/chart/Manufacturing.sql
===================================================================
--- trunk/sql/coa/us/chart/Manufacturing.sql 2009-06-13 18:05:09 UTC (rev 2680)
+++ trunk/sql/coa/us/chart/Manufacturing.sql 2009-06-13 18:13:11 UTC (rev 2681)
@@ -2,41 +2,41 @@
-- US_Manufacturing COA
-- modify as needed
--
-SELECT account_heading_save(NULL,'1000','CURRENT ASSETS', NULL));
+SELECT account_heading_save(NULL,'1000','CURRENT ASSETS', NULL);
SELECT account_save(NULL,'1060','Checking Account','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'1065','Petty Cash','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'1200','Accounts Receivables','A','', NULL, false,string_to_array('AR', ':'));
SELECT account_save(NULL,'1205','Allowance for doubtful accounts','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'1500','INVENTORY ASSETS', NULL));
+SELECT account_heading_save(NULL,'1500','INVENTORY ASSETS', NULL);
SELECT account_save(NULL,'1520','Inventory / General','A','', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1530','Inventory / Raw Materials','A','1126', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1540','Inventory / Work in process','A','1125', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1550','Inventory / Finished Goods','A','1121', NULL, false,string_to_array('IC', ':'));
-SELECT account_heading_save(NULL,'1800','CAPITAL ASSETS', NULL));
+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, '1',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, '1',string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2000','CURRENT LIABILITIES', NULL));
+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_heading_save(NULL,'2600','LONG TERM LIABILITIES', NULL));
+SELECT account_heading_save(NULL,'2600','LONG TERM LIABILITIES', NULL);
SELECT account_save(NULL,'2620','Bank Loans','L','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2680','Loans from Shareholders','L','', NULL, false,string_to_array('AP_paid', ':'));
-SELECT account_heading_save(NULL,'3300','SHARE CAPITAL', NULL));
+SELECT account_heading_save(NULL,'3300','SHARE CAPITAL', NULL);
SELECT account_save(NULL,'3350','Common Shares','Q','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'3500','RETAINED EARNINGS', NULL));
+SELECT account_heading_save(NULL,'3500','RETAINED EARNINGS', NULL);
SELECT account_save(NULL,'3590','Retained Earnings - prior years','Q','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'4000','SALES REVENUE', NULL));
+SELECT account_heading_save(NULL,'4000','SALES REVENUE', NULL);
SELECT account_save(NULL,'4020','Sales / General','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
SELECT account_save(NULL,'4030','Sales / Manufactured Goods','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
SELECT account_save(NULL,'4040','Sales / Aftermarket Parts','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
-SELECT account_heading_save(NULL,'4400','OTHER REVENUE', NULL));
+SELECT account_heading_save(NULL,'4400','OTHER REVENUE', NULL);
SELECT account_save(NULL,'4430','Shipping & Handling','I','', NULL, false,string_to_array('IC_income', ':'));
SELECT account_save(NULL,'4440','Interest','I','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'4450','Foreign Exchange Gain','I','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5000','COST OF GOODS SOLD', NULL));
+SELECT account_heading_save(NULL,'5000','COST OF GOODS SOLD', NULL);
SELECT account_save(NULL,'5010','Purchases','E','', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
SELECT account_save(NULL,'5020','COGS / General','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
@@ -45,9 +45,9 @@
SELECT account_save(NULL,'5050','COGS / Overhead','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
SELECT account_save(NULL,'5100','Freight','E','', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_heading_save(NULL,'5400','PAYROLL EXPENSES', NULL));
+SELECT account_heading_save(NULL,'5400','PAYROLL EXPENSES', NULL);
SELECT account_save(NULL,'5410','Wages & Salaries','E','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5600','GENERAL & ADMINISTRATIVE EXPENSES', NULL));
+SELECT account_heading_save(NULL,'5600','GENERAL & ADMINISTRATIVE EXPENSES', NULL);
SELECT account_save(NULL,'5610','Accounting & Legal','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'5615','Advertising & Promotions','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'5620','Bad Debts','E','', NULL, false,string_to_array('', ':'));
Modified: trunk/sql/coa/us/chart/Service.sql
===================================================================
--- trunk/sql/coa/us/chart/Service.sql 2009-06-13 18:05:09 UTC (rev 2680)
+++ trunk/sql/coa/us/chart/Service.sql 2009-06-13 18:13:11 UTC (rev 2681)
@@ -2,38 +2,38 @@
-- US_Service_Company COA
-- modify as needed
--
-SELECT account_heading_save(NULL,'1000','CURRENT ASSETS', NULL));
+SELECT account_heading_save(NULL,'1000','CURRENT ASSETS', NULL);
SELECT account_save(NULL,'1060','Checking Account','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'1065','Petty Cash','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'1200','Accounts Receivables','A','', NULL, false,string_to_array('AR', ':'));
SELECT account_save(NULL,'1205','Allowance for doubtful accounts','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'1500','INVENTORY ASSETS', NULL));
+SELECT account_heading_save(NULL,'1500','INVENTORY ASSETS', NULL);
SELECT account_save(NULL,'1520','Inventory','A','', NULL, false,string_to_array('IC', ':'));
-SELECT account_heading_save(NULL,'1800','CAPITAL ASSETS', NULL));
+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, '1',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, '1',string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2000','CURRENT LIABILITIES', NULL));
+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_heading_save(NULL,'2600','LONG TERM LIABILITIES', NULL));
+SELECT account_heading_save(NULL,'2600','LONG TERM LIABILITIES', NULL);
SELECT account_save(NULL,'2620','Bank Loans','L','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2680','Loans from Shareholders','L','', NULL, false,string_to_array('AP_paid', ':'));
-SELECT account_heading_save(NULL,'3300','SHARE CAPITAL', NULL));
+SELECT account_heading_save(NULL,'3300','SHARE CAPITAL', NULL);
SELECT account_save(NULL,'3350','Common Shares','Q','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'3500','RETAINED EARNINGS', NULL));
+SELECT account_heading_save(NULL,'3500','RETAINED EARNINGS', NULL);
SELECT account_save(NULL,'3590','Retained Earnings - prior years','Q','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'4000','CONSULTING REVENUE', NULL));
+SELECT account_heading_save(NULL,'4000','CONSULTING REVENUE', NULL);
SELECT account_save(NULL,'4020','Consulting','I','', NULL, false,string_to_array('AR_amount:IC_income', ':'));
-SELECT account_heading_save(NULL,'4400','OTHER REVENUE', NULL));
+SELECT account_heading_save(NULL,'4400','OTHER REVENUE', NULL);
SELECT account_save(NULL,'4410','General Sales','I','', NULL, false,string_to_array('AR_amount:IC_income:IC_sale', ':'));
SELECT account_save(NULL,'4440','Interest','I','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'4450','Foreign Exchange Gain','I','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5000','EXPENSES', NULL));
+SELECT account_heading_save(NULL,'5000','EXPENSES', NULL);
SELECT account_save(NULL,'5020','Purchases','E','', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
-SELECT account_heading_save(NULL,'5400','PAYROLL EXPENSES', NULL));
+SELECT account_heading_save(NULL,'5400','PAYROLL EXPENSES', NULL);
SELECT account_save(NULL,'5410','Wages & Salaries','E','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5600','GENERAL & ADMINISTRATIVE EXPENSES', NULL));
+SELECT account_heading_save(NULL,'5600','GENERAL & ADMINISTRATIVE EXPENSES', NULL);
SELECT account_save(NULL,'5610','Accounting & Legal','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'5615','Advertising & Promotions','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'5620','Bad Debts','E','', NULL, false,string_to_array('', ':'));
Modified: trunk/sql/coa/us/chart/UCOA-Form990.sql
===================================================================
--- trunk/sql/coa/us/chart/UCOA-Form990.sql 2009-06-13 18:05:09 UTC (rev 2680)
+++ trunk/sql/coa/us/chart/UCOA-Form990.sql 2009-06-13 18:13:11 UTC (rev 2681)
@@ -1,43 +1,43 @@
begin;
-- UCOA Form 990
--
-SELECT account_heading_save(NULL,'1000','Cash', NULL));
+SELECT account_heading_save(NULL,'1000','Cash', NULL);
SELECT account_save(NULL,'1010','Cash in bank-operating','A','45', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'1020','Cash in bank-payroll','A','45', NULL, false,string_to_array('AP_paid', ':'));
SELECT account_save(NULL,'1040','Petty cash','A','45', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'1070','Savings & short-term investments','A','46', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'1100','Accounts receivable', NULL));
+SELECT account_heading_save(NULL,'1100','Accounts receivable', NULL);
SELECT account_save(NULL,'1110','Accounts receivable','A','47a', NULL, false,string_to_array('AR', ':'));
SELECT account_save(NULL,'1115','Doubtful accounts allowance','A','47b', NULL, '1',string_to_array('AR_paid', ':'));
-SELECT account_heading_save(NULL,'1200','Contributions receivable', NULL));
+SELECT account_heading_save(NULL,'1200','Contributions receivable', NULL);
SELECT account_save(NULL,'1210','Pledges receivable','A','48a', NULL, 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,'1240','Grants receivable','A','49', NULL, 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_heading_save(NULL,'1300','Other receivables', NULL));
+SELECT account_heading_save(NULL,'1300','Other receivables', NULL);
SELECT account_save(NULL,'1310','Employee & trustee receivables','A','50', NULL, false,string_to_array('AR', ':'));
SELECT account_save(NULL,'1320','Notes/loans receivable','A','51a', NULL, 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_heading_save(NULL,'1400','Other assets', NULL));
+SELECT account_heading_save(NULL,'1400','Other assets', NULL);
SELECT account_save(NULL,'1410','Inventories for sale','A','52', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1420','Inventories for use','A','52', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1450','Prepaid expenses','A','53', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1460','Accrued revenues','A','47a', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'1500','Investments', NULL));
+SELECT account_heading_save(NULL,'1500','Investments', NULL);
SELECT account_save(NULL,'1510','Marketable securities ','A','54', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1530','Land held for investment','A','55a', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1540','Buildings held for investment','A','55a', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1545','Accum deprec - bldg investment','A','55b', NULL, '1',string_to_array('', ':'));
SELECT account_save(NULL,'1580','Investments - other','A','56', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'1600','Fixed operating assets', NULL));
+SELECT account_heading_save(NULL,'1600','Fixed operating assets', NULL);
SELECT account_save(NULL,'1610','Land - operating','A','57a', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1620','Buildings - operating','A','57a', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1630','Leasehold improvements','A','57a', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1640','Furniture, fixtures, & equip','A','57a', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1650','Vehicles','A','57a', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1660','Construction in progress','A','57a', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'1700','Accum deprec - fixed operating assets', NULL));
+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('', ':'));
@@ -46,84 +46,84 @@
SELECT account_save(NULL,'1850','Split-interest agreements','A','58', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1910','Collections - art, etc','A','58', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1950','Funds held in trust by others','A','58', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2000','Payables', NULL));
+SELECT account_heading_save(NULL,'2000','Payables', NULL);
SELECT account_save(NULL,'2010','Accounts payable','L','60', NULL, false,string_to_array('AP', ':'));
SELECT account_save(NULL,'2020','Grants & allocations payable','L','61', NULL, false,string_to_array('AP', ':'));
-SELECT account_heading_save(NULL,'2100','Accrued liabilities', NULL));
+SELECT account_heading_save(NULL,'2100','Accrued liabilities', NULL);
SELECT account_save(NULL,'2110','Accrued payroll','L','60', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2120','Accrued paid leave','L','60', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2130','Accrued payroll taxes','L','60', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2140','Accrued sales taxes','L','60', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2150','Accrued expenses - other','L','60', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2300','Unearned/deferred revenue', NULL));
+SELECT account_heading_save(NULL,'2300','Unearned/deferred revenue', NULL);
SELECT account_save(NULL,'2310','Deferred contract revenue','L','62', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2350','Unearned/deferred revenue - other','L','62', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2410','Refundable advances','L','62', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2500','Short-term notes & loans payable', NULL));
+SELECT account_heading_save(NULL,'2500','Short-term notes & loans payable', NULL);
SELECT account_save(NULL,'2510','Trustee & employee loans payable','L','63', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2550','Line of credit','L','65', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2560','Current portion - long-term loan','L','65', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2570','Short-term liabilities - other','L','65', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2610',' Split-interest liabilities','L','65', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2700','Long-term notes & loans payable', NULL));
+SELECT account_heading_save(NULL,'2700','Long-term notes & loans payable', NULL);
SELECT account_save(NULL,'2710','Bonds payable','L','64a', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2730','Mortgages payable','L','64b', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2750','Capital leases','L','64b', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2770','Long-term liabilities - other','L','64a', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2810','Gov\'t-owned fixed assets liability','L','65', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2910','Custodial funds','L','65', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'3000','Unrestricted net assets', NULL));
+SELECT account_heading_save(NULL,'3000','Unrestricted net assets', NULL);
SELECT account_save(NULL,'3010','Unrestricted net assets','Q','21&67', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'3020','Board-designated net assets','Q','21&67', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'3030','Board designated quasi-endowment','Q','21&67', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'3040','Fixed operating net assets','Q','21&67', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'3100','Temporarily restricted net assets', NULL));
+SELECT account_heading_save(NULL,'3100','Temporarily restricted net assets', NULL);
SELECT account_save(NULL,'3110','Use restricted net assets','Q','21&68', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'3120','Time restricted net assets','Q','21&68', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'3200','Permanently restricted net assets', NULL));
+SELECT account_heading_save(NULL,'3200','Permanently restricted net assets', NULL);
SELECT account_save(NULL,'3210','Endowment net assets','Q','21&69', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'4000','Revenue from direct contributions', NULL));
+SELECT account_heading_save(NULL,'4000','Revenue from direct contributions', NULL);
SELECT account_save(NULL,'4010','Individual/small business contributions','I','1a', NULL, false,string_to_array('AR_amount:IC_income', ':'));
SELECT account_save(NULL,'4020','Corporate contributions','I','1a', NULL, false,string_to_array('AR_amount:IC_income', ':'));
SELECT account_save(NULL,'4070','Legacies & bequests','I','1a', NULL, 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_heading_save(NULL,'4100','Donated goods & services revenue', NULL));
+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,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4120','Donated other services - non-GAAP','I','PartIV-A&82b', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4130','Donated use of facilities','I','PartIV-A&82b', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4140','Gifts in kind - goods','I','1d', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
SELECT account_save(NULL,'4150','Donated art, etc','I','1d', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
-SELECT account_heading_save(NULL,'4200','Revenue from non-government grants', NULL));
+SELECT account_heading_save(NULL,'4200','Revenue from non-government grants', NULL);
SELECT account_save(NULL,'4210','Corporate/business grants','I','1a', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4230','Foundation/trust grants','I','1a', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4250','Nonprofit organization grants','I','1a', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4255','Discounts - long-term grants','I','contra1a', NULL, '1',string_to_array('', ':'));
-SELECT account_heading_save(NULL,'4300','Revenue from split-interest agreements', NULL));
+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,string_to_array('', ':'));
SELECT account_save(NULL,'4350','Gain (loss) split-interest agreements','I','20', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'4400','Revenue from indirect contributions', NULL));
+SELECT account_heading_save(NULL,'4400','Revenue from indirect contributions', NULL);
SELECT account_save(NULL,'4410','United Way or CFC contributions','I','1b', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4420','Affiliated organizations revenue','I','1b', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4430','Fundraising agencies revenue','I','1b', NULL, false,string_to_array('AR_amount', ':'));
-SELECT account_heading_save(NULL,'4500','Revenue from government grants', NULL));
+SELECT account_heading_save(NULL,'4500','Revenue from government grants', NULL);
SELECT account_save(NULL,'4510','Agency (government) grants','I','1c', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4520','Federal grants','I','1c', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4530','State grants','I','1c', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4540','Local government grants','I','1c', NULL, false,string_to_array('AR_amount', ':'));
-SELECT account_heading_save(NULL,'5000','Revenue from government agencies', NULL));
+SELECT account_heading_save(NULL,'5000','Revenue from government agencies', NULL);
SELECT account_save(NULL,'5010','Agency (government) contracts/fees','I','2&93(g)', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5020','Federal contracts/fees','I','2&93(g)', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5030','State contracts/fees','I','2&93(g)', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5040','Local government contracts/fees','I','2&93(g)', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5080','Medicare/Medicaid payments','I','2&93f', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5100','Revenue from program-related sales & fees', NULL));
+SELECT account_heading_save(NULL,'5100','Revenue from program-related sales & fees', NULL);
SELECT account_save(NULL,'5180','Program service fees','I','2&93(a)', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5185','Bad debts, est - program fees','I','2&93(a)', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5200','Revenue from dues', NULL));
+SELECT account_heading_save(NULL,'5200','Revenue from dues', NULL);
SELECT account_save(NULL,'5210','Membership dues-individuals','I','3&94', NULL, false,string_to_array('AR_amount:IC_income', ':'));
SELECT account_save(NULL,'5220','Assessments and dues-organizations','I','3&94', NULL, false,string_to_array('AR_amount:IC_income', ':'));
-SELECT account_heading_save(NULL,'5300','Revenue from investments', NULL));
+SELECT account_heading_save(NULL,'5300','Revenue from investments', NULL);
SELECT account_save(NULL,'5310','Interest-savings/short-term investments','I','4&95', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5320','Dividends & interest - securities','I','5&96', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5330','Real estate rent - debt-financed','I','6a&97a', NULL, false,string_to_array('', ':'));
@@ -135,7 +135,7 @@
SELECT account_save(NULL,'5360','Other investment income','I','7&99', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5370','Securities sales - gross','I','8a-(A)&100', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'5375','Securities sales cost ','I','8b-(A)&100', NULL, '1',string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5400','Revenue from other sources', NULL));
+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,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,'5440','Gross sales - inventory','I','10a&102', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
@@ -143,29 +143,29 @@
SELECT account_save(NULL,'5450','Advertising revenue','I','11&103', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5460','Affiliate revenues from other entities','I','11&103', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5490','Misc revenue','I','11&103', NULL, false,string_to_array('AR_amount', ':'));
-SELECT account_heading_save(NULL,'5800','Special events', NULL));
+SELECT account_heading_save(NULL,'5800','Special events', NULL);
SELECT account_save(NULL,'5810','Special events - non-gift revenue','I','9a&101', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5820','Special events - gift revenue','I','1a&(9a)', NULL, false,string_to_array('AR_amount', ':'));
-SELECT account_heading_save(NULL,'6800','Unrealized gain (loss)', NULL));
+SELECT account_heading_save(NULL,'6800','Unrealized gain (loss)', NULL);
SELECT account_save(NULL,'6810','Unrealized gain (loss) - investments','I','PartIV-A', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'6820','Unrealized gain (loss) - other assets','I','PartIV-A', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'6900','Net assets released from restriction', NULL));
+SELECT account_heading_save(NULL,'6900','Net assets released from restriction', NULL);
SELECT account_save(NULL,'6910','Satisfaction of use restriction','I','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'6920','LB&E acquisition satisfaction','I','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'6930','Time restriction satisfaction','I','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'7000','Grantscts, & direct assistance', NULL));
+SELECT account_heading_save(NULL,'7000','Grantscts, & direct assistance', NULL);
SELECT account_save(NULL,'7010','Contracts - program-related','E','22', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'7020','Grants to other organizations','E','22', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'7040','Awards & grants - individuals','E','22', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'7050','Specific assistance - individuals','E','23', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'7060','Benefits paid to or for members','E','24', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_heading_save(NULL,'7200','Salaries & related expenses', NULL));
+SELECT account_heading_save(NULL,'7200','Salaries & related expenses', NULL);
SELECT account_save(NULL,'7210','Officers & directors salaries','E','25', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'7220','Salaries & wages - other','E','26', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'7230','Pension plan contributions','E','27', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'7240','Employee benefits - not pension','E','28', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'7250','Payroll taxes, etc.','E','29', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'7500','Contract service expenses', NULL));
+SELECT account_heading_save(NULL,'7500','Contract service expenses', NULL);
SELECT account_save(NULL,'7510','Fundraising fees','E','30', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'7520','Accounting fees','E','31', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'7530','Legal fees','E','32', NULL, false,string_to_array('AP_amount', ':'));
@@ -173,7 +173,7 @@
SELECT account_save(NULL,'7550','Temporary help - contract','E','43', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'7580','Donated professional services - GAAP','E','PartIV-B,82b', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'7590','Donated other services - non-GAAP','E','PartIV-B,82b', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_heading_save(NULL,'8100','Nonpersonnel expenses', NULL));
+SELECT account_heading_save(NULL,'8100','Nonpersonnel expenses', NULL);
SELECT account_save(NULL,'8110','Supplies','E','33', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8120','Donated materials & supplies','E','33', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8130','Telephone & telecommunications','E','34', NULL, false,string_to_array('AP_amount', ':'));
@@ -182,7 +182,7 @@
SELECT account_save(NULL,'8170','Printing & copying','E','38', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8180','Books, subscriptions, references','E','38', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8190','In-house publications','E','38', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_heading_save(NULL,'8200','Facility & equipment expenses', NULL));
+SELECT account_heading_save(NULL,'8200','Facility & equipment expenses', NULL);
SELECT account_save(NULL,'8210','Rent, parking, other occupancy','E','36', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8220','Utilities','E','36', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8230','Real estate taxes','E','36', NULL, false,string_to_array('', ':'));
@@ -192,10 +192,10 @@
SELECT account_save(NULL,'8270','Deprec & amort - allowable','E','42', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'8280','Deprec & amort - not allowable','E','42', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'8290','Donated facilities ','E','PartIV-B,82b', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'8300','Travel & meetings expenses', NULL));
+SELECT account_heading_save(NULL,'8300','Travel & meetings expenses', NULL);
SELECT account_save(NULL,'8310','Travel','E','39', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8320','Conferences, conventions, meetings','E','40', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_heading_save(NULL,'8500','Other expenses', NULL));
+SELECT account_heading_save(NULL,'8500','Other expenses', NULL);
SELECT account_save(NULL,'8510','Interest-general','E','41', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8520','Insurance - non-employee related','E','43', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8530','Membership dues - organization','E','43', NULL, false,string_to_array('AP_amount', ':'));
@@ -205,19 +205,19 @@
SELECT account_save(NULL,'8570','Advertising expenses','E','43', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8580','Contingency provisions','E','43', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8590','Other expenses','E','43', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_heading_save(NULL,'8600','Business expenses', NULL));
+SELECT account_heading_save(NULL,'8600','Business expenses', NULL);
SELECT account_save(NULL,'8610','Bad debt expense ','E','43', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'8620','Sales taxes','E','43', NULL, false,string_to_array('AP_tax', ':'));
SELECT account_save(NULL,'8630','UBITaxes ','E','43', NULL, false,string_to_array('AP_tax', ':'));
SELECT account_save(NULL,'8650','Taxes - other','E','43', NULL, false,string_to_array('AP_tax', ':'));
SELECT account_save(NULL,'8660','Fines, penalties, judgments','E','43', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'8670','Organizational (corp) expenses','E','43', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'9800','Fixed asset purchases ', NULL));
+SELECT account_heading_save(NULL,'9800','Fixed asset purchases ', NULL);
SELECT account_save(NULL,'9810','Capital purchases - land','A','capitalized', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'9820','Capital purchases - building','A','capitalized', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'9830','Capital purchases - equipment','A','capitalized', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'9840','Capital purchases - vehicles','A','capitalized', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'9900','Other Allocations', NULL));
+SELECT account_heading_save(NULL,'9900','Other Allocations', NULL);
SELECT account_save(NULL,'9910','Payments to affiliates','E','16', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'9920','Additions to reserves','E','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'9930','Program administration allocations','E','', NULL, false,string_to_array('', ':'));
Modified: trunk/sql/coa/us/chart/UCOA-Form990EZ.sql
===================================================================
--- trunk/sql/coa/us/chart/UCOA-Form990EZ.sql 2009-06-13 18:05:09 UTC (rev 2680)
+++ trunk/sql/coa/us/chart/UCOA-Form990EZ.sql 2009-06-13 18:13:11 UTC (rev 2681)
@@ -1,43 +1,43 @@
begin;
-- UCOA Form 990EZ
--
-SELECT account_heading_save(NULL,'1000','Cash', NULL));
+SELECT account_heading_save(NULL,'1000','Cash', NULL);
SELECT account_save(NULL,'1010','Cash in bank-operating','A','22', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'1020','Cash in bank-payroll','A','22', NULL, false,string_to_array('AP_paid', ':'));
SELECT account_save(NULL,'1040','Petty cash','A','22', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'1070','Savings & short-term investments','A','22', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'1100','Accounts receivable', NULL));
+SELECT account_heading_save(NULL,'1100','Accounts receivable', NULL);
SELECT account_save(NULL,'1110','Accounts receivable','A','24', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1115','Doubtful accounts allowance','A','24', NULL, '1',string_to_array('AR_paid', ':'));
-SELECT account_heading_save(NULL,'1200','Contributions receivable', NULL));
+SELECT account_heading_save(NULL,'1200','Contributions receivable', NULL);
SELECT account_save(NULL,'1210','Pledges receivable','A','24', NULL, 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,'1240','Grants receivable','A','24', NULL, 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_heading_save(NULL,'1300','Other receivables', NULL));
+SELECT account_heading_save(NULL,'1300','Other receivables', NULL);
SELECT account_save(NULL,'1310','Employee & trustee receivables','A','24', NULL, false,string_to_array('AR', ':'));
SELECT account_save(NULL,'1320','Notes/loans receivable','A','24', NULL, 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_heading_save(NULL,'1400','Other assets', NULL));
+SELECT account_heading_save(NULL,'1400','Other assets', NULL);
SELECT account_save(NULL,'1410','Inventories for sale','A','24', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1420','Inventories for use','A','24', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1450','Prepaid expenses','A','24', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1460','Accrued revenues','A','24', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'1500','Investments', NULL));
+SELECT account_heading_save(NULL,'1500','Investments', NULL);
SELECT account_save(NULL,'1510','Marketable securities ','A','22', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1530','Land held for investment','A','22', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1540','Buildings held for investment','A','22', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1545','Accum deprec - bldg investment','A','22', NULL, '1',string_to_array('', ':'));
SELECT account_save(NULL,'1580','Investments - other','A','22', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'1600','Fixed operating assets', NULL));
+SELECT account_heading_save(NULL,'1600','Fixed operating assets', NULL);
SELECT account_save(NULL,'1610','Land - operating','A','23', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1620','Buildings - operating','A','23', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1630','Leasehold improvements','A','24', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1640','Furniture, fixtures, & equip','A','24', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1650','Vehicles','A','24', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1660','Construction in progress','A','24', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'1700','Accum deprec - fixed operating assets', NULL));
+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('', ':'));
@@ -46,84 +46,84 @@
SELECT account_save(NULL,'1850','Split-interest agreements','A','24', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1910','Collections - art, etc','A','24', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1950','Funds held in trust by others','A','24', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2000','Payables', NULL));
+SELECT account_heading_save(NULL,'2000','Payables', NULL);
SELECT account_save(NULL,'2010','Accounts payable','L','26', NULL, false,string_to_array('AP', ':'));
SELECT account_save(NULL,'2020','Grants & allocations payable','L','26', NULL, false,string_to_array('AP', ':'));
-SELECT account_heading_save(NULL,'2100','Accrued liabilities', NULL));
+SELECT account_heading_save(NULL,'2100','Accrued liabilities', NULL);
SELECT account_save(NULL,'2110','Accrued payroll','L','26', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2120','Accrued paid leave','L','26', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2130','Accrued payroll taxes','L','26', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2140','Accrued sales taxes','L','26', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2150','Accrued expenses - other','L','26', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2300','Unearned/deferred revenue', NULL));
+SELECT account_heading_save(NULL,'2300','Unearned/deferred revenue', NULL);
SELECT account_save(NULL,'2310','Deferred contract revenue','L','26', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2350','Unearned/deferred revenue - other','L','26', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2410','Refundable advances','L','26', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2500','Short-term notes & loans payable', NULL));
+SELECT account_heading_save(NULL,'2500','Short-term notes & loans payable', NULL);
SELECT account_save(NULL,'2510','Trustee & employee loans payable','L','26', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2550','Line of credit','L','26', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2560','Current portion - long-term loan','L','26', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2570','Short-term liabilities - other','L','26', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2610',' Split-interest liabilities','L','26', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'2700','Long-term notes & loans payable', NULL));
+SELECT account_heading_save(NULL,'2700','Long-term notes & loans payable', NULL);
SELECT account_save(NULL,'2710','Bonds payable','L','26', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2730','Mortgages payable','L','26', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2750','Capital leases','L','26', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2770','Long-term liabilities - other','L','26', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2810','Gov\'t-owned fixed assets liability','L','26', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2910','Custodial funds','L','26', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'3000','Unrestricted net assets', NULL));
+SELECT account_heading_save(NULL,'3000','Unrestricted net assets', NULL);
SELECT account_save(NULL,'3010','Unrestricted net assets','Q','21&27', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'3020','Board-designated net assets','Q','21&27', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'3030','Board designated quasi-endowment','Q','21&27', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'3040','Fixed operating net assets','Q','21&27', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'3100','Temporarily restricted net assets', NULL));
+SELECT account_heading_save(NULL,'3100','Temporarily restricted net assets', NULL);
SELECT account_save(NULL,'3110','Use restricted net assets','Q','21&27', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'3120','Time restricted net assets','Q','21&27', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'3200','Permanently restricted net assets', NULL));
+SELECT account_heading_save(NULL,'3200','Permanently restricted net assets', NULL);
SELECT account_save(NULL,'3210','Endowment net assets','Q','21&27', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'4000','Revenue from direct contributions', NULL));
+SELECT account_heading_save(NULL,'4000','Revenue from direct contributions', NULL);
SELECT account_save(NULL,'4010','Individual/small business contributions','I','1', NULL, false,string_to_array('AR_amount:IC_income', ':'));
SELECT account_save(NULL,'4020','Corporate contributions','I','1', NULL, false,string_to_array('AR_amount:IC_income', ':'));
SELECT account_save(NULL,'4070','Legacies & bequests','I','1', NULL, 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_heading_save(NULL,'4100','Donated goods & services revenue', NULL));
+SELECT account_heading_save(NULL,'4100','Donated goods & services revenue', NULL);
SELECT account_save(NULL,'4110','Donated professional services-GAAP','I','', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4120','Donated other services - non-GAAP','I','', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4130','Donated use of facilities','I','', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4140','Gifts in kind - goods','I','1', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
SELECT account_save(NULL,'4150','Donated art, etc','I','1', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
-SELECT account_heading_save(NULL,'4200','Revenue from non-government grants', NULL));
+SELECT account_heading_save(NULL,'4200','Revenue from non-government grants', NULL);
SELECT account_save(NULL,'4210','Corporate/business grants','I','1', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4230','Foundation/trust grants','I','1', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4250','Nonprofit organization grants','I','1', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4255','Discounts - long-term grants','I','1', NULL, '1',string_to_array('', ':'));
-SELECT account_heading_save(NULL,'4300','Revenue from split-interest agreements', NULL));
+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,string_to_array('', ':'));
SELECT account_save(NULL,'4350','Gain (loss) split-interest agreements','I','1', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'4400','Revenue from indirect contributions', NULL));
+SELECT account_heading_save(NULL,'4400','Revenue from indirect contributions', NULL);
SELECT account_save(NULL,'4410','United Way or CFC contributions','I','1', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4420','Affiliated organizations revenue','I','1', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4430','Fundraising agencies revenue','I','1', NULL, false,string_to_array('AR_amount', ':'));
-SELECT account_heading_save(NULL,'4500','Revenue from government grants', NULL));
+SELECT account_heading_save(NULL,'4500','Revenue from government grants', NULL);
SELECT account_save(NULL,'4510','Agency (government) grants','I','1', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4520','Federal grants','I','1', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4530','State grants','I','1', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'4540','Local government grants','I','1', NULL, false,string_to_array('AR_amount', ':'));
-SELECT account_heading_save(NULL,'5000','Revenue from government agencies', NULL));
+SELECT account_heading_save(NULL,'5000','Revenue from government agencies', NULL);
SELECT account_save(NULL,'5010','Agency (government) contracts/fees','I','2', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5020','Federal contracts/fees','I','2', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5030','State contracts/fees','I','2', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5040','Local government contracts/fees','I','2', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5080','Medicare/Medicaid payments','I','2', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5100','Revenue from program-related sales & fees', NULL));
+SELECT account_heading_save(NULL,'5100','Revenue from program-related sales & fees', NULL);
SELECT account_save(NULL,'5180','Program service fees','I','2', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5185','Bad debts, est - program fees','I','2', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5200','Revenue from dues', NULL));
+SELECT account_heading_save(NULL,'5200','Revenue from dues', NULL);
SELECT account_save(NULL,'5210','Membership dues-individuals','I','3', NULL, false,string_to_array('AR_amount:IC_income', ':'));
SELECT account_save(NULL,'5220','Assessments and dues-organizations','I','3', NULL, false,string_to_array('AR_amount:IC_income', ':'));
-SELECT account_heading_save(NULL,'5300','Revenue from investments', NULL));
+SELECT account_heading_save(NULL,'5300','Revenue from investments', NULL);
SELECT account_save(NULL,'5310','Interest-savings/short-term investments','I','4', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5320','Dividends & interest - securities','I','4', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5330','Real estate rent - debt-financed','I','8', NULL, false,string_to_array('', ':'));
@@ -135,7 +135,7 @@
SELECT account_save(NULL,'5360','Other investment income','I','4', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5370','Securities sales - gross','I','5a', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'5375','Securities sales cost ','I','5b', NULL, '1',string_to_array('', ':'));
-SELECT account_heading_save(NULL,'5400','Revenue from other sources', NULL));
+SELECT account_heading_save(NULL,'5400','Revenue from other sources', NULL);
SELECT account_save(NULL,'5410','Non-inventory sales - gross','I','5a', NULL, 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,'5440','Gross sales - inventory','I','8', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
@@ -143,29 +143,29 @@
SELECT account_save(NULL,'5450','Advertising revenue','I','8', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5460','Affiliate revenues from other entities','I','8', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5490','Misc revenue','I','8', NULL, false,string_to_array('AR_amount', ':'));
-SELECT account_heading_save(NULL,'5800','Special events', NULL));
+SELECT account_heading_save(NULL,'5800','Special events', NULL);
SELECT account_save(NULL,'5810','Special events - non-gift revenue','I','6a', NULL, false,string_to_array('AR_amount', ':'));
SELECT account_save(NULL,'5820','Special events - gift revenue','I','1&(6a)', NULL, false,string_to_array('AR_amount', ':'));
-SELECT account_heading_save(NULL,'6800','Unrealized gain (loss)', NULL));
+SELECT account_heading_save(NULL,'6800','Unrealized gain (loss)', NULL);
SELECT account_save(NULL,'6810','Unrealized gain (loss) - investments','I','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'6820','Unrealized gain (loss) - other assets','I','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'6900','Net assets released from restriction', NULL));
+SELECT account_heading_save(NULL,'6900','Net assets released from restriction', NULL);
SELECT account_save(NULL,'6910','Satisfaction of use restriction','I','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'6920','LB&E acquisition satisfaction','I','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'6930','Time restriction satisfaction','I','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'7000','Grantscts, & direct assistance', NULL));
+SELECT account_heading_save(NULL,'7000','Grantscts, & direct assistance', NULL);
SELECT account_save(NULL,'7010','Contracts - program-related','E','10', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'7020','Grants to other organizations','E','10', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'7040','Awards & grants - individuals','E','10', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'7050','Specific assistance - individuals','E','10', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'7060','Benefits paid to or for members','E','11', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_heading_save(NULL,'7200','Salaries & related expenses', NULL));
+SELECT account_heading_save(NULL,'7200','Salaries & related expenses', NULL);
SELECT account_save(NULL,'7210','Officers & directors salaries','E','12', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'7220','Salaries & wages - other','E','12', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'7230','Pension plan contributions','E','12', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'7240','Employee benefits - not pension','E','12', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'7250','Payroll taxes, etc.','E','12', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'7500','Contract service expenses', NULL));
+SELECT account_heading_save(NULL,'7500','Contract service expenses', NULL);
SELECT account_save(NULL,'7510','Fundraising fees','E','13', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'7520','Accounting fees','E','13', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'7530','Legal fees','E','13', NULL, false,string_to_array('AP_amount', ':'));
@@ -173,7 +173,7 @@
SELECT account_save(NULL,'7550','Temporary help - contract','E','13', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'7580','Donated professional services - GAAP','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'7590','Donated other services - non-GAAP','E','', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_heading_save(NULL,'8100','Nonpersonnel expenses', NULL));
+SELECT account_heading_save(NULL,'8100','Nonpersonnel expenses', NULL);
SELECT account_save(NULL,'8110','Supplies','E','16', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8120','Donated materials & supplies','E','16', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8130','Telephone & telecommunications','E','16', NULL, false,string_to_array('AP_amount', ':'));
@@ -182,7 +182,7 @@
SELECT account_save(NULL,'8170','Printing & copying','E','15', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8180','Books, subscriptions, references','E','15', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8190','In-house publications','E','15', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_heading_save(NULL,'8200','Facility & equipment expenses', NULL));
+SELECT account_heading_save(NULL,'8200','Facility & equipment expenses', NULL);
SELECT account_save(NULL,'8210','Rent, parking, other occupancy','E','14', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8220','Utilities','E','14', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8230','Real estate taxes','E','14', NULL, false,string_to_array('', ':'));
@@ -192,10 +192,10 @@
SELECT account_save(NULL,'8270','Deprec & amort - allowable','E','16', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'8280','Deprec & amort - not allowable','E','16', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'8290','Donated facilities ','E','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'8300','Travel & meetings expenses', NULL));
+SELECT account_heading_save(NULL,'8300','Travel & meetings expenses', NULL);
SELECT account_save(NULL,'8310','Travel','E','16', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8320','Conferences, conventions, meetings','E','16', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_heading_save(NULL,'8500','Other expenses', NULL));
+SELECT account_heading_save(NULL,'8500','Other expenses', NULL);
SELECT account_save(NULL,'8510','Interest-general','E','16', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8520','Insurance - non-employee related','E','16', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8530','Membership dues - organization','E','16', NULL, false,string_to_array('AP_amount', ':'));
@@ -205,19 +205,19 @@
SELECT account_save(NULL,'8570','Advertising expenses','E','16', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8580','Contingency provisions','E','16', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'8590','Other expenses','E','16', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
-SELECT account_heading_save(NULL,'8600','Business expenses', NULL));
+SELECT account_heading_save(NULL,'8600','Business expenses', NULL);
SELECT account_save(NULL,'8610','Bad debt expense ','E','16', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'8620','Sales taxes','E','16', NULL, false,string_to_array('AP_tax', ':'));
SELECT account_save(NULL,'8630','UBITaxes ','E','16', NULL, false,string_to_array('AP_tax', ':'));
SELECT account_save(NULL,'8650','Taxes - other','E','16', NULL, false,string_to_array('AP_tax', ':'));
SELECT account_save(NULL,'8660','Fines, penalties, judgments','E','16', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'8670','Organizational (corp) expenses','E','16', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'9800','Fixed asset purchases ', NULL));
+SELECT account_heading_save(NULL,'9800','Fixed asset purchases ', NULL);
SELECT account_save(NULL,'9810','Capital purchases - land','A','capitalized', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'9820','Capital purchases - building','A','capitalized', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'9830','Capital purchases - equipment','A','capitalized', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'9840','Capital purchases - vehicles','A','capitalized', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'9900','Other Allocations', NULL));
+SELECT account_heading_save(NULL,'9900','Other Allocations', NULL);
SELECT account_save(NULL,'9910','Payments to affiliates','E','16', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'9920','Additions to reserves','E','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'9930','Program administration allocations','E','', NULL, false,string_to_array('', ':'));
Modified: trunk/sql/coa/ve/chart/General.sql
===================================================================
--- trunk/sql/coa/ve/chart/General.sql 2009-06-13 18:05:09 UTC (rev 2680)
+++ trunk/sql/coa/ve/chart/General.sql 2009-06-13 18:13:11 UTC (rev 2681)
@@ -4,7 +4,7 @@
--
-- ACTIVO
-SELECT account_heading_save(NULL,'1000','ACTIVO', NULL));
+SELECT account_heading_save(NULL,'1000','ACTIVO', NULL);
SELECT account_save(NULL,'1050','Caja','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'1100','Banesco APD','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'1110','Provincial','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
@@ -12,10 +12,10 @@
SELECT account_save(NULL,'1130','Banesco JD','A','', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
SELECT account_save(NULL,'1200','Cuentas por Cobrar','A','', NULL, false,string_to_array('AR', ':'));
SELECT account_save(NULL,'1205','ProvisiÃn Cuentas Incobrables','A','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'1500','INVENTARIO', NULL));
+SELECT account_heading_save(NULL,'1500','INVENTARIO', NULL);
SELECT account_save(NULL,'1520','MercancÃa en AlmacÃn','A','', NULL, false,string_to_array('IC', ':'));
SELECT account_save(NULL,'1530','MercancÃa en ConsignaciÃn','A','', NULL, false,string_to_array('IC', ':'));
-SELECT account_heading_save(NULL,'1800','ACTIVOS CAPITALES', NULL));
+SELECT account_heading_save(NULL,'1800','ACTIVOS CAPITALES', NULL);
SELECT account_save(NULL,'1820','Mobiliario y Equipo','A','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1825','Amort. Acum. -Inv. y Equip.','A','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1840','VehÃculo','A','', NULL, false,string_to_array('', ':'));
@@ -23,36 +23,36 @@
SELECT account_save(NULL,'1850','Edificio','A','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1855','Amort. Acum. -Edificio','A','', NULL, false,string_to_array('', ':'));
-- PASIVO
-SELECT account_heading_save(NULL,'2000','PASIVO CORTO PLAZO', NULL));
+SELECT account_heading_save(NULL,'2000','PASIVO CORTO PLAZO', NULL);
SELECT account_save(NULL,'2100','Cuentas por Pagar','L','', NULL, false,string_to_array('AP', ':'));
-SELECT account_heading_save(NULL,'2600','PASIVO LARGO PLAZO', NULL));
+SELECT account_heading_save(NULL,'2600','PASIVO LARGO PLAZO', NULL);
SELECT account_save(NULL,'2620','PrÃstamos Bancarios','L','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'2680','PrÃstamos de Accionistas','L','', NULL, false,string_to_array('AP_paid', ':'));
-SELECT account_heading_save(NULL,'2700','APARTADOS', NULL));
+SELECT account_heading_save(NULL,'2700','APARTADOS', NULL);
SELECT account_save(NULL,'2710','Apartados Indem. Laborales','L','', NULL, false,string_to_array('', ':'));
-- CAPITAL
-SELECT account_heading_save(NULL,'3300','CAPITAL ACCIONARIO', NULL));
+SELECT account_heading_save(NULL,'3300','CAPITAL ACCIONARIO', NULL);
SELECT account_save(NULL,'3350','Acciones Comunes','Q','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'3400','RESERVAS', NULL));
+SELECT account_heading_save(NULL,'3400','RESERVAS', NULL);
SELECT account_save(NULL,'3410','Reserva Legal','Q','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'3420','Reserva Voluntaria','Q','', NULL, false,string_to_array('', ':'));
-SELECT account_heading_save(NULL,'3500','UTILIDADES RETENIDAS', NULL));
+SELECT account_heading_save(NULL,'3500','UTILIDADES RETENIDAS', NULL);
SELECT account_save(NULL,'3590','Utilidades Retenidas - aÃos anteriores','Q','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'3600','Ganancia del Ejercicio','Q','', NULL, false,string_to_array('', ':'));
-- INGRESO
-SELECT account_heading_save(NULL,'4000','INGRESOS PRINCIPALES', NULL));
+SELECT account_heading_save(NULL,'4000','INGRESOS PRINCIPALES', NULL);
SELECT account_save(NULL,'4020','Ventas Autopartes','I','', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
-SELECT account_heading_save(NULL,'4400','OTROS INGRESOS', NULL));
+SELECT account_heading_save(NULL,'4400','OTROS INGRESOS', NULL);
SELECT account_save(NULL,'4430','Shipping & Handling','I','', NULL, false,string_to_array('IC_income', ':'));
SELECT account_save(NULL,'4440','Intereses','I','', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'4450','Ganancia en Paridad Cambiaria','I','', NULL, false,string_to_array('', ':'));
-- EGRESO
-SELECT account_heading_save(NULL,'5000','COSTO DE VENTA', NULL));
+SELECT account_heading_save(NULL,'5000','COSTO DE VENTA', NULL);
SELECT account_save(NULL,'5010','Compras','E','', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
SELECT account_save(NULL,'5020','COSTO DE VENTA: Autopartes','E','', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
SELECT account_save(NULL,'5100','Flete','E','', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
-- HR
-SELECT account_heading_save(NULL,'5400','GASTO DE PERSONAL', NULL));
+SELECT account_heading_save(NULL,'5400','GASTO DE PERSONAL', NULL);
SELECT account_save(NULL,'5405','Sueldos Directivo y Administradores','E','', NULL, false,string_to_array('HR_expense', ':'));
SELECT account_save(NULL,'5410','Sueldos Empleados','E','', NULL, false,string_to_array('HR_expense', ':'));
SELECT account_save(NULL,'5415','Comisiones Vendedores','E','', NULL, false,string_to_array('HR_expense', ':'));
@@ -64,7 +64,7 @@
SELECT account_save(NULL,'5445','Gastos de RepresentaciÃn','E','', NULL, false,string_to_array('HR_expense', ':'));
SELECT account_save(NULL,'5450','InstrucciÃn y Mejoramiento','E','', NULL, false,string_to_array('HR_expense', ':'));
-SELECT account_heading_save(NULL,'5600','GASTOS GENERALES', NULL));
+SELECT account_heading_save(NULL,'5600','GASTOS GENERALES', NULL);
SELECT account_save(NULL,'5610','Honorarios Profesionales','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'5615','Propaganda','E','', NULL, false,string_to_array('AP_amount', ':'));
SELECT account_save(NULL,'5660','Gasto de AmortizaciÃn','E','', NULL, false,string_to_array('', ':'));
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.