[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

Revision: 2640
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2640&view=rev
Author:   einhverfr
Date:     2009-06-12 00:33:06 +0000 (Fri, 12 Jun 2009)

Log Message:
-----------
Australian charts converted

Modified Paths:
--------------
    trunk/sql/coa/au/General-0000.sql
    trunk/sql/coa/au/General-00000.sql

Modified: trunk/sql/coa/au/General-0000.sql
===================================================================
--- trunk/sql/coa/au/General-0000.sql	2009-06-11 23:19:31 UTC (rev 2639)
+++ trunk/sql/coa/au/General-0000.sql	2009-06-12 00:33:06 UTC (rev 2640)
@@ -1,111 +1,111 @@
 begin;
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2000', 'CURRENT LIABILITIES', 'H', 'L', '', '');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2600', 'LONG TERM LIABILITIES', 'H', 'L', '', '');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4000', 'SALES REVENUE', 'H', 'I', '', '');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5000', 'COST OF GOODS SOLD', 'H', 'E', '', '');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5400', 'PAYROLL EXPENSES', 'H', 'E', '', '');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5600', 'GENERAL & ADMINISTRATIVE EXPENSES', 'H', 'E', '', '');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6000', 'CAR EXPENSES', 'H', 'E', '', '');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4300', 'OTHER REVENUE', 'H', 'I', '', '');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5470', 'Staff Amenities', 'A', 'E', '', '');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1500', 'STOCK ON HAND', 'H', 'A', '', '');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3300', 'EQUITY', 'H', 'Q', '', '');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1520', 'SOH / Leather', 'A', 'A', 'IC', '1500');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1000', 'CURRENT ASSETS', 'H', 'A', '', '');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1820', 'Plant & Equipment - at Cost', 'A', 'A', 'AP_amount', '1800');
+SELECT account_heading_save(NULL, '2000', 'CURRENT LIABILITIES', NULL);
+SELECT account_heading_save(NULL, '2600', 'LONG TERM LIABILITIES', NULL);
+SELECT account_heading_save(NULL, '4000', 'SALES REVENUE', NULL);
+SELECT account_heading_save(NULL, '5000', 'COST OF GOODS SOLD', NULL);
+SELECT account_heading_save(NULL, '5400', 'PAYROLL EXPENSES', NULL);
+SELECT account_heading_save(NULL, '5600', 'GENERAL & ADMINISTRATIVE EXPENSES', NULL);
+SELECT account_heading_save(NULL, '6000', 'CAR EXPENSES', NULL);
+SELECT account_heading_save(NULL, '4300', 'OTHER REVENUE', NULL);
+SELECT account_save(NULL,'5470','Staff Amenities','','E', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '1500', 'STOCK ON HAND', NULL);
+SELECT account_heading_save(NULL, '3300', 'EQUITY', NULL);
+SELECT account_save(NULL,'1520','SOH / Leather','1500','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_heading_save(NULL, '1000', 'CURRENT ASSETS', NULL);
+SELECT account_save(NULL,'1820','Plant & Equipment - at Cost','1800','A', NULL, false,string_to_array('AP_amount', ':'));
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('1825', 'Less: Accumulated Depreciation', 'A', 'A', '', '1800', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1840', 'Motor Vehicles - at Cost', 'A', 'A', 'AP_amount', '1800');
+SELECT account_save(NULL,'1840','Motor Vehicles - at Cost','1800','A', NULL, false,string_to_array('AP_amount', ':'));
 INSERT INTO chart (accno, description, charttype, category, link, gifi_accno, contra) VALUES ('1845', 'Less: Accumulated Depreciation', 'A', 'A', '', '1800', '1');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1800', 'CAPITAL ASSETS', 'H', 'A', '', '');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1060', 'Cheque Account', 'A', 'A', 'AR_paid:AP_paid', '1000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1205', 'Less: Provision Doubtful Debts', 'A', 'A', '', '1000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1210', 'Trade Debtors / Australia - with GST', 'A', 'A', 'AR', '1000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1220', 'Trade Debtors / Exports - GST free', 'A', 'A', 'AR', '1000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1230', 'GST / Refund', 'A', 'A', 'AR_tax:AP_tax:IC_taxpart:IC_taxservice', '1000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1530', 'SOH / PVC', 'A', 'A', 'IC', '1500');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1540', 'SOH / Fabrics', 'A', 'A', 'IC', '1500');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1550', 'SOH / Metal Hardware / Fasteners / Accessories', 'A', 'A', 'IC', '1500');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1560', 'SOH / Paint / Glue / Dye', 'A', 'A', 'IC', '1500');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1570', 'SOH / Threads / Tapes / Cords / Laces', 'A', 'A', 'IC', '1500');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1580', 'SOH / Other Goods', 'A', 'A', 'IC', '1500');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2100', 'Trade Creditors', 'A', 'L', 'AP', '2000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2160', 'Taxation - Payable', 'A', 'L', '', '2000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2210', 'Workers Compensation - Payable', 'A', 'L', '', '2000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2250', 'Superannuation - Payable', 'A', 'L', '', '2000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2260', 'Insurance - Payable', 'A', 'L', '', '2000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2290', 'GST / Payable', 'A', 'L', 'AR_tax:AP_tax:IC_taxpart:IC_taxservice', '2000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2300', 'GST Payments / Refunds', 'A', 'L', '', '2000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2310', 'GST Adjustments', 'A', 'L', '', '2000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3350', 'Issued & Paid up Capital', 'A', 'Q', '', '3300');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3370', 'Opening Account Balance', 'A', 'Q', '', '3300');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3380', 'Credit Payments / Holding Account', 'A', 'Q', 'AR_paid', '');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4020', 'Sales / Manufactured Products', 'A', 'I', 'AR_amount:IC_sale', '4000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4030', 'Sales / General', 'A', 'I', 'AR_amount:IC_sale:IC_income', '4000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4410', 'Shop Labour', 'A', 'I', 'IC_income', '4000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4420', 'Design / Patternmaking', 'A', 'I', 'IC_income', '4000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4430', 'Shipping & Handling', 'A', 'I', 'IC_income', '4000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4440', 'Interest Received', 'A', 'I', '', '4000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4450', 'Foreign Exchange Profit', 'A', 'I', '', '4000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4460', 'Mark-Up / Price Adjustment', 'A', 'I', 'IC_income', '4000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('4470', 'Computer Consultancy / Training', 'A', 'I', 'IC_income', '4000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2620', 'Bank Loans', 'A', 'L', '', '2000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2640', 'Hire Purchase', 'A', 'L', 'AP_amount', '2000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('2650', 'Other Loans', 'A', 'L', '', '2000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5020', 'COGS / Leather', 'A', 'E', 'IC_cogs', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5030', 'COGS / PVC', 'A', 'E', 'IC_cogs', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5040', 'COGS / Fabrics', 'A', 'E', 'IC_cogs', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5050', 'COGS / Metal Hardware / Fasteners / Accessories', 'A', 'E', 'IC_cogs', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5060', 'COGS / Paint / Glue / Dye', 'A', 'E', 'IC_cogs', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5070', 'COGS / Threads / Tapes / Cords / Laces', 'A', 'E', 'IC_cogs', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5080', 'COGS / Other Goods', 'A', 'E', 'IC_cogs', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5410', 'Wages', 'A', 'E', '', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5430', 'Superannuation', 'A', 'E', '', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5440', 'Workers Compensation', 'A', 'E', '', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5605', 'External labour costs', 'A', 'E', 'AP_amount:IC_expense', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5610', 'Accountancy', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5611', 'Legal Fees', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5613', 'Postage / Printing / Stationery', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5614', 'Freight and Cartage', 'A', 'E', 'AP_amount:IC_expense', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5615', 'Advertising & Promotions', 'A', 'E', 'AP_amount:IC_expense', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5620', 'Bad Debts', 'A', 'E', '', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5650', 'Capital Cost Allowance Expense', 'A', 'E', '', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5660', 'Interest Expenses', 'A', 'E', '', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5670', 'Depreciation Expenses', 'A', 'E', '', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5680', 'Taxation', 'A', 'E', '', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5685', 'Insurance', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5686', 'Security', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5690', 'Bank Fees And Charges', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5695', 'Other Fees And Charges', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5700', 'Office Supplies', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5760', 'Rent on Land & Buildings', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5765', 'Repairs & Maintenance', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5766', 'Fixtures & Fittings', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5770', 'Replacements (tools, etc)', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5780', 'Telephone', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5782', 'Computer Expenses', 'A', 'E', 'AP_amount:IC_expense', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5783', 'Research & Development', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5785', 'Travel, Accommodation & Conference', 'A', 'E', '', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5790', 'Hire / Rent of Plant & Equipment ', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5795', 'Registration & Insurance', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5800', 'Licenses', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5810', 'Foreign Exchange Loss', 'A', 'E', '', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5811', 'Electricity', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5812', 'Gas', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5813', 'Sundry Expenses', 'A', 'E', 'AP_amount:IC_expense', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5820', 'Goods & Services for own Use', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6010', 'M/V Commercial - Fuels / Oils / Parts', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6020', 'M/V Commercial - Repairs', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6040', 'M/V Commercial - Reg / Insurance', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6080', 'M/V Private Use - Interest Expenses', 'A', 'E', '', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6090', 'M/V Private Use - Other Expenses', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6070', 'M/V Private Use - Depreciation Expenses', 'A', 'E', '', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6050', 'M/V Commercial - Depreciation Expenses', 'A', 'E', '', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('6060', 'M/V Commercial - Interest Expenses', 'A', 'E', '', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('1065', 'Cash / Paid From Private Accounts', 'A', 'Q', 'AR_paid:AP_paid', '1000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3360', 'Payments for G & S for own Use', 'A', 'Q', 'AP_paid', '3300');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5830', 'Discounts / Refunds / Rounding', 'A', 'E', 'AP_amount', '5000');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('3390', 'Retained Profits', 'A', 'Q', '', '3300');
-INSERT INTO chart (accno, description, charttype, category, link, gifi_accno) VALUES ('5840', 'Fines - NON DEDUCTIBLE EXPENSES', 'A', 'E', '', '');
+SELECT account_heading_save(NULL, '1800', 'CAPITAL ASSETS', NULL);
+SELECT account_save(NULL,'1060','Cheque Account','1000','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1205','Less: Provision Doubtful Debts','1000','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1210','Trade Debtors / Australia - with GST','1000','A', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'1220','Trade Debtors / Exports - GST free','1000','A', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'1230','GST / Refund','1000','A', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1530','SOH / PVC','1500','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1540','SOH / Fabrics','1500','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1550','SOH / Metal Hardware / Fasteners / Accessories','1500','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1560','SOH / Paint / Glue / Dye','1500','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1570','SOH / Threads / Tapes / Cords / Laces','1500','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1580','SOH / Other Goods','1500','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'2100','Trade Creditors','2000','L', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'2160','Taxation - Payable','2000','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2210','Workers Compensation - Payable','2000','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2250','Superannuation - Payable','2000','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2260','Insurance - Payable','2000','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2290','GST / Payable','2000','L', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2300','GST Payments / Refunds','2000','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2310','GST Adjustments','2000','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3350','Issued & Paid up Capital','3300','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3370','Opening Account Balance','3300','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3380','Credit Payments / Holding Account','','Q', NULL, false,string_to_array('AR_paid', ':'));
+SELECT account_save(NULL,'4020','Sales / Manufactured Products','4000','I', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'4030','Sales / General','4000','I', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'4410','Shop Labour','4000','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'4420','Design / Patternmaking','4000','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'4430','Shipping & Handling','4000','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'4440','Interest Received','4000','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4450','Foreign Exchange Profit','4000','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4460','Mark-Up / Price Adjustment','4000','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'4470','Computer Consultancy / Training','4000','I', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'2620','Bank Loans','2000','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2640','Hire Purchase','2000','L', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'2650','Other Loans','2000','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5020','COGS / Leather','5000','E', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'5030','COGS / PVC','5000','E', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'5040','COGS / Fabrics','5000','E', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'5050','COGS / Metal Hardware / Fasteners / Accessories','5000','E', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'5060','COGS / Paint / Glue / Dye','5000','E', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'5070','COGS / Threads / Tapes / Cords / Laces','5000','E', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'5080','COGS / Other Goods','5000','E', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'5410','Wages','5000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5430','Superannuation','5000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5440','Workers Compensation','5000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5605','External labour costs','5000','E', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5610','Accountancy','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5611','Legal Fees','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5613','Postage / Printing / Stationery','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5614','Freight and Cartage','5000','E', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5615','Advertising & Promotions','5000','E', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5620','Bad Debts','5000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5650','Capital Cost Allowance Expense','5000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5660','Interest Expenses','5000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5670','Depreciation Expenses','5000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5680','Taxation','5000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5685','Insurance','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5686','Security','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5690','Bank Fees And Charges','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5695','Other Fees And Charges','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5700','Office Supplies','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5760','Rent on Land & Buildings','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5765','Repairs & Maintenance','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5766','Fixtures & Fittings','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5770','Replacements (tools, etc)','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5780','Telephone','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5782','Computer Expenses','5000','E', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5783','Research & Development','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5785','Travel, Accommodation & Conference','5000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5790','Hire / Rent of Plant & Equipment ','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5795','Registration & Insurance','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5800','Licenses','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5810','Foreign Exchange Loss','5000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5811','Electricity','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5812','Gas','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5813','Sundry Expenses','5000','E', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5820','Goods & Services for own Use','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'6010','M/V Commercial - Fuels / Oils / Parts','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'6020','M/V Commercial - Repairs','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'6040','M/V Commercial - Reg / Insurance','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'6080','M/V Private Use - Interest Expenses','5000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6090','M/V Private Use - Other Expenses','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'6070','M/V Private Use - Depreciation Expenses','5000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6050','M/V Commercial - Depreciation Expenses','5000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6060','M/V Commercial - Interest Expenses','5000','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1065','Cash / Paid From Private Accounts','1000','Q', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'3360','Payments for G & S for own Use','3300','Q', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'5830','Discounts / Refunds / Rounding','5000','E', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'3390','Retained Profits','3300','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5840','Fines - NON DEDUCTIBLE EXPENSES','','E', NULL, false,string_to_array('', ':'));
 --
 INSERT INTO tax (chart_id, rate, taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '1230'), 0.1, '');
 INSERT INTO tax (chart_id, rate, taxnumber) VALUES ((SELECT id FROM chart WHERE accno = '2290'), 0.1, '');

Modified: trunk/sql/coa/au/General-00000.sql
===================================================================
--- trunk/sql/coa/au/General-00000.sql	2009-06-11 23:19:31 UTC (rev 2639)
+++ trunk/sql/coa/au/General-00000.sql	2009-06-12 00:33:06 UTC (rev 2640)
@@ -2,75 +2,75 @@
 -- Australia chart of accounts
 -- sample only
 --
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('10000','BANK AND CASH ACCOUNTS','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('10001','Bank Account','A','100','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('10010','Petty Cash','A','100','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11000','CUSTOMERS AND SETTLEMENT ACCOUNTS','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('11001','Accounts Receivables','A','110','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12000','OTHER CURRENT ASSETS','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('12001','Allowance for doubtful accounts','A','120','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('15000','INVENTORY ASSETS','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('15001','Inventory / General','A','150','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('15002','Inventory / Aftermarket Parts','A','150','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('16000','STATUTORY DEBTORS','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('16001','INPUT GST','A','160','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('18000','CAPITAL ASSETS','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('18001','Land and Buildings','A','180','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('18002','Accumulated Amortization -Land & Buildings','A','180','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('18003','Office Furniture & Equipment','A','180','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('18004','Accumulated Amortization -Furniture & Equipment','A','180','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('18005','Vehicle','A','180','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('18006','Accumulated Amortization -Vehicle','A','180','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('20000','CURRENT LIABILITIES','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('20001','Accounts Payable','A','200','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21000','STATUTORY CREDITORS','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21001','Corporate Taxes Payable','A','210','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21002','OUTPUT GST','A','210','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('21003','GST Settlement Account','A','210','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22000','PAYROLL ACCOUNTS','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22001','Workers Net Salary Payable','A','220','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22002','PAYG Witholding Payable','A','220','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('22003','Superannuation Plan Payable','A','220','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('26000','LONG TERM LIABILITIES','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('26001','Bank Loans','A','260','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('26002','Loans from Shareholders','A','260','L','AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33000','SHARE CAPITAL','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('33001','Common Shares','A','330','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('40000','SALES REVENUE','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('40001','Sales / General','A','400','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('40002','Sales / Aftermarket Parts','A','400','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41000','CONSULTING REVENUE','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('41001','Consulting','A','410','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42000','OTHER REVENUE','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42001','Interest and Financial Income','A','420','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('42002','Foreign Exchange Gain','A','420','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50000','COST OF GOODS SOLD','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50001','Purchases','A','500','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50002','COGS / General','A','500','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50003','COGS / Aftermarket Parts','A','500','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('50004','Freight','A','500','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54000','PAYROLL EXPENSES','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54001','Wages & Salaries','A','540','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54002','PAYG Tax Expense','A','540','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('54003','Superannuation Plan Expense','A','540','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56000','GENERAL & ADMINISTRATIVE EXPENSES','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56001','Accounting & Legal','A','560','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56002','Advertising & Promotions','A','560','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56003','Amortization Expense','A','560','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56004','Income Taxes','A','560','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56005','Insurance','A','560','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56006','Office Supplies','A','560','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56007','Rent and Rates','A','560','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56008','Repair & Maintenance','A','560','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56009','Telephone, Fax and Internet','A','560','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56010','Travel & Entertainment','A','560','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56011','Utilities','A','560','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56012','Registrations','A','560','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('56013','Licenses','A','560','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58000','OTHER EXPENSES','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58001','Interest & Bank Charges','A','580','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58002','Foreign Exchange Loss','A','580','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('58003','Bad Debts','A','580','E','');
+SELECT account_heading_save(NULL, '10000', 'BANK AND CASH ACCOUNTS', NULL);
+SELECT account_save(NULL,'10001','Bank Account','A','100', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'10010','Petty Cash','A','100', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_heading_save(NULL, '11000', 'CUSTOMERS AND SETTLEMENT ACCOUNTS', NULL);
+SELECT account_save(NULL,'11001','Accounts Receivables','A','110', NULL, false,string_to_array('AR', ':'));
+SELECT account_heading_save(NULL, '12000', 'OTHER CURRENT ASSETS', NULL);
+SELECT account_save(NULL,'12001','Allowance for doubtful accounts','A','120', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '15000', 'INVENTORY ASSETS', NULL);
+SELECT account_save(NULL,'15001','Inventory / General','A','150', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'15002','Inventory / Aftermarket Parts','A','150', NULL, false,string_to_array('IC', ':'));
+SELECT account_heading_save(NULL, '16000', 'STATUTORY DEBTORS', NULL);
+SELECT account_save(NULL,'16001','INPUT GST','L','160', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_heading_save(NULL, '18000', 'CAPITAL ASSETS', NULL);
+SELECT account_save(NULL,'18001','Land and Buildings','A','180', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'18002','Accumulated Amortization -Land & Buildings','A','180', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'18003','Office Furniture & Equipment','A','180', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'18004','Accumulated Amortization -Furniture & Equipment','A','180', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'18005','Vehicle','A','180', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'18006','Accumulated Amortization -Vehicle','A','180', NULL, true,string_to_array('','1', ':'));
+SELECT account_heading_save(NULL, '20000', 'CURRENT LIABILITIES', NULL);
+SELECT account_save(NULL,'20001','Accounts Payable','L','200', NULL, false,string_to_array('AP', ':'));
+SELECT account_heading_save(NULL, '21000', 'STATUTORY CREDITORS', NULL);
+SELECT account_save(NULL,'21001','Corporate Taxes Payable','L','210', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'21002','OUTPUT GST','L','210', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'21003','GST Settlement Account','L','210', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '22000', 'PAYROLL ACCOUNTS', NULL);
+SELECT account_save(NULL,'22001','Workers Net Salary Payable','L','220', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'22002','PAYG Witholding Payable','L','220', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'22003','Superannuation Plan Payable','L','220', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '26000', 'LONG TERM LIABILITIES', NULL);
+SELECT account_save(NULL,'26001','Bank Loans','L','260', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'26002','Loans from Shareholders','L','260', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_heading_save(NULL, '33000', 'SHARE CAPITAL', NULL);
+SELECT account_save(NULL,'33001','Common Shares','Q','330', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '40000', 'SALES REVENUE', NULL);
+SELECT account_save(NULL,'40001','Sales / General','I','400', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'40002','Sales / Aftermarket Parts','I','400', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_heading_save(NULL, '41000', 'CONSULTING REVENUE', NULL);
+SELECT account_save(NULL,'41001','Consulting','I','410', NULL, false,string_to_array('AR_amount:IC_income', ':'));
+SELECT account_heading_save(NULL, '42000', 'OTHER REVENUE', NULL);
+SELECT account_save(NULL,'42001','Interest and Financial Income','I','420', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'42002','Foreign Exchange Gain','I','420', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '50000', 'COST OF GOODS SOLD', NULL);
+SELECT account_save(NULL,'50001','Purchases','E','500', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'50002','COGS / General','E','500', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'50003','COGS / Aftermarket Parts','E','500', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'50004','Freight','E','500', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_heading_save(NULL, '54000', 'PAYROLL EXPENSES', NULL);
+SELECT account_save(NULL,'54001','Wages & Salaries','E','540', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'54002','PAYG Tax Expense','E','540', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'54003','Superannuation Plan Expense','E','540', NULL, false,string_to_array('', ':'));
+SELECT account_heading_save(NULL, '56000', 'GENERAL & ADMINISTRATIVE EXPENSES', NULL);
+SELECT account_save(NULL,'56001','Accounting & Legal','E','560', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'56002','Advertising & Promotions','E','560', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'56003','Amortization Expense','E','560', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'56004','Income Taxes','E','560', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'56005','Insurance','E','560', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'56006','Office Supplies','E','560', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'56007','Rent and Rates','E','560', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'56008','Repair & Maintenance','E','560', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'56009','Telephone, Fax and Internet','E','560', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'56010','Travel & Entertainment','E','560', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'56011','Utilities','E','560', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'56012','Registrations','E','560', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'56013','Licenses','E','560', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_heading_save(NULL, '58000', 'OTHER EXPENSES', NULL);
+SELECT account_save(NULL,'58001','Interest & Bank Charges','E','580', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'58002','Foreign Exchange Loss','E','580', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'58003','Bad Debts','E','580', NULL, false,string_to_array('', ':'));
 --
 insert into tax (chart_id,rate) values ((select id from chart where accno = '16001'),0.1);
 insert into tax (chart_id,rate) values ((select id from chart where accno = '21002'),0.1);


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