[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[2675] trunk/sql/coa
- Subject: SF.net SVN: ledger-smb:[2675] trunk/sql/coa
- From: ..hidden..
- Date: Sat, 13 Jun 2009 04:09:12 +0000
Revision: 2675
http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2675&view=rev
Author: einhverfr
Date: 2009-06-13 04:09:11 +0000 (Sat, 13 Jun 2009)
Log Message:
-----------
More minor fixes to coa scripts
Modified Paths:
--------------
trunk/sql/coa/au/chart/General-0000.sql
trunk/sql/coa/ca/chart/English_General.sql
trunk/sql/coa/ca/chart/French-Quebec_General.sql
Modified: trunk/sql/coa/au/chart/General-0000.sql
===================================================================
--- trunk/sql/coa/au/chart/General-0000.sql 2009-06-13 03:40:11 UTC (rev 2674)
+++ trunk/sql/coa/au/chart/General-0000.sql 2009-06-13 04:09:11 UTC (rev 2675)
@@ -7,105 +7,105 @@
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_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_save(NULL,'1520','SOH / Leather','A','1500', 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', ':'));
+SELECT account_save(NULL,'1820','Plant & Equipment - at Cost','A','1800', 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');
-SELECT account_save(NULL,'1840','Motor Vehicles - at Cost','1800','A', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'1840','Motor Vehicles - at Cost','A','1800', 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');
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('', ':'));
+SELECT account_save(NULL,'1060','Cheque Account','A','1000', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1205','Less: Provision Doubtful Debts','A','1000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1210','Trade Debtors / Australia - with GST','A','1000', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'1220','Trade Debtors / Exports - GST free','A','1000', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'1230','GST / Refund','A','1000', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'1530','SOH / PVC','A','1500', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1540','SOH / Fabrics','A','1500', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1550','SOH / Metal Hardware / Fasteners / Accessories','A','1500', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1560','SOH / Paint / Glue / Dye','A','1500', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1570','SOH / Threads / Tapes / Cords / Laces','A','1500', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1580','SOH / Other Goods','A','1500', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'2100','Trade Creditors','L','2000', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'2160','Taxation - Payable','L','2000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2210','Workers Compensation - Payable','L','2000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2250','Superannuation - Payable','L','2000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2260','Insurance - Payable','L','2000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2290','GST / Payable','L','2000', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2300','GST Payments / Refunds','L','2000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2310','GST Adjustments','L','2000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3350','Issued & Paid up Capital','Q','3300', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3370','Opening Account Balance','Q','3300', 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','I','4000', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'4030','Sales / General','I','4000', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'4410','Shop Labour','I','4000', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'4420','Design / Patternmaking','I','4000', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'4430','Shipping & Handling','I','4000', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'4440','Interest Received','I','4000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4450','Foreign Exchange Profit','I','4000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4460','Mark-Up / Price Adjustment','I','4000', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'4470','Computer Consultancy / Training','I','4000', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'2620','Bank Loans','L','2000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2640','Hire Purchase','L','2000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'2650','Other Loans','L','2000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5020','COGS / Leather','E','5000', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'5030','COGS / PVC','E','5000', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'5040','COGS / Fabrics','E','5000', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'5050','COGS / Metal Hardware / Fasteners / Accessories','E','5000', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'5060','COGS / Paint / Glue / Dye','E','5000', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'5070','COGS / Threads / Tapes / Cords / Laces','E','5000', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'5080','COGS / Other Goods','E','5000', NULL, false,string_to_array('IC_cogs', ':'));
+SELECT account_save(NULL,'5410','Wages','E','5000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5430','Superannuation','E','5000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5440','Workers Compensation','E','5000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5605','External labour costs','E','5000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5610','Accountancy','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5611','Legal Fees','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5613','Postage / Printing / Stationery','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5614','Freight and Cartage','E','5000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5615','Advertising & Promotions','E','5000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5620','Bad Debts','E','5000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5650','Capital Cost Allowance Expense','E','5000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5660','Interest Expenses','E','5000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5670','Depreciation Expenses','E','5000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5680','Taxation','E','5000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5685','Insurance','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5686','Security','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5690','Bank Fees And Charges','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5695','Other Fees And Charges','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5700','Office Supplies','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5760','Rent on Land & Buildings','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5765','Repairs & Maintenance','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5766','Fixtures & Fittings','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5770','Replacements (tools, etc)','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5780','Telephone','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5782','Computer Expenses','E','5000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5783','Research & Development','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5785','Travel, Accommodation & Conference','E','5000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5790','Hire / Rent of Plant & Equipment ','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5795','Registration & Insurance','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5800','Licenses','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5810','Foreign Exchange Loss','E','5000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5811','Electricity','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5812','Gas','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5813','Sundry Expenses','E','5000', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5820','Goods & Services for own Use','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'6010','M/V Commercial - Fuels / Oils / Parts','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'6020','M/V Commercial - Repairs','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'6040','M/V Commercial - Reg / Insurance','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'6080','M/V Private Use - Interest Expenses','E','5000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6090','M/V Private Use - Other Expenses','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'6070','M/V Private Use - Depreciation Expenses','E','5000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6050','M/V Commercial - Depreciation Expenses','E','5000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'6060','M/V Commercial - Interest Expenses','E','5000', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1065','Cash / Paid From Private Accounts','Q','1000', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'3360','Payments for G & S for own Use','Q','3300', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'5830','Discounts / Refunds / Rounding','E','5000', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'3390','Retained Profits','Q','3300', 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/ca/chart/English_General.sql
===================================================================
--- trunk/sql/coa/ca/chart/English_General.sql 2009-06-13 03:40:11 UTC (rev 2674)
+++ trunk/sql/coa/ca/chart/English_General.sql 2009-06-13 04:09:11 UTC (rev 2675)
@@ -12,9 +12,9 @@
SELECT account_save(NULL,'1540','Inventory / Raw Materials','A','1122', NULL, false,string_to_array('IC', ':'));
SELECT account_heading_save(NULL, '1800', 'CAPITAL ASSETS', NULL);
SELECT account_save(NULL,'1820','Office Furniture & Equipment','A','1787', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1825','Accum. Amort. -Furn. & Equip.','A','1788', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'1825','Accum. Amort. -Furn. & Equip.','A','1788', NULL, true,string_to_array('', ':'));
SELECT account_save(NULL,'1840','Vehicle','A','1742', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'1845','Accum. Amort. -Vehicle','A','1743', NULL, true,string_to_array('','1', ':'));
+SELECT account_save(NULL,'1845','Accum. Amort. -Vehicle','A','1743', NULL, true,string_to_array('', ':'));
SELECT account_heading_save(NULL, '2000', 'CURRENT LIABILITIES', NULL);
SELECT account_save(NULL,'2100','Accounts Payable','L','2621', NULL, false,string_to_array('AP', ':'));
SELECT account_save(NULL,'2160','Federal Taxes Payable','L','2683', NULL, false,string_to_array('', ':'));
Modified: trunk/sql/coa/ca/chart/French-Quebec_General.sql
===================================================================
--- trunk/sql/coa/ca/chart/French-Quebec_General.sql 2009-06-13 03:40:11 UTC (rev 2674)
+++ trunk/sql/coa/ca/chart/French-Quebec_General.sql 2009-06-13 04:09:11 UTC (rev 2675)
@@ -10,71 +10,71 @@
-- TVQ/TPS terminology, CSST, Assurance-emploi, RRQ, TVQ rate
SELECT account_heading_save(NULL, '1000', 'ACTIF COURANT', NULL);
-SELECT account_save(NULL,'1060','Compte chÃque','1002','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1065','Petite caisse','1001','A', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
-SELECT account_save(NULL,'1200','Comptes clients','1060','A', NULL, false,string_to_array('AR', ':'));
-SELECT account_save(NULL,'1205','Provisions pour crÃances douteuses','1063','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1060','Compte chÃque','A','1002', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1065','Petite caisse','A','1001', NULL, false,string_to_array('AR_paid:AP_paid', ':'));
+SELECT account_save(NULL,'1200','Comptes clients','A','1060', NULL, false,string_to_array('AR', ':'));
+SELECT account_save(NULL,'1205','Provisions pour crÃances douteuses','A','1063', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '1500', 'INVENTAIRE', NULL);
-SELECT account_save(NULL,'1520','Inventaire / GÃnÃral','1122','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1530','Inventaire / PiÃces de rechange','1122','A', NULL, false,string_to_array('IC', ':'));
-SELECT account_save(NULL,'1540','Inventaire / MatiÃres premiÃres','1122','A', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1520','Inventaire / GÃnÃral','A','1122', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1530','Inventaire / PiÃces de rechange','A','1122', NULL, false,string_to_array('IC', ':'));
+SELECT account_save(NULL,'1540','Inventaire / MatiÃres premiÃres','A','1122', NULL, false,string_to_array('IC', ':'));
SELECT account_heading_save(NULL, '1800', 'AUTRES IMMOBILISATIONS', NULL);
-SELECT account_save(NULL,'1820','Meubles et accessoires','1787','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1820','Meubles et accessoires','A','1787', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1825','Amortissement cumulà des meubles et des accessoires','A','1788', NULL, '1',string_to_array('', ':'));
-SELECT account_save(NULL,'1840','VÃhicules automobiles','1742','A', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'1840','VÃhicules automobiles','A','1742', NULL, false,string_to_array('', ':'));
SELECT account_save(NULL,'1845','Amortissement cumulà des vÃhicules automobiles','A','1743', NULL, '1',string_to_array('', ':'));
SELECT account_heading_save(NULL, '2000', 'PASSIF COURANT', NULL);
-SELECT account_save(NULL,'2100','Comptes fournisseurs','2621','L', NULL, false,string_to_array('AP', ':'));
-SELECT account_save(NULL,'2160','Taxes fÃdÃrales à payer','2683','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2170','Taxes provinciales à payer','2684','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2310','TPS','2685','L', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2320','TVQ','2686','L', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
-SELECT account_save(NULL,'2380','IndemnitÃs de vacances à payer','2624','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2390','CSST Ã payer','2627','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2100','Comptes fournisseurs','L','2621', NULL, false,string_to_array('AP', ':'));
+SELECT account_save(NULL,'2160','Taxes fÃdÃrales à payer','L','2683', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2170','Taxes provinciales à payer','L','2684', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2310','TPS','L','2685', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2320','TVQ','L','2686', NULL, false,string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
+SELECT account_save(NULL,'2380','IndemnitÃs de vacances à payer','L','2624', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2390','CSST Ã payer','L','2627', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '2400', 'RETENUES SUR SALAIRE', NULL);
-SELECT account_save(NULL,'2410','Assurance-emploi à payer','2627','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2420','RRQ Ã payer','2627','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2450','ImpÃt sur le revenu à payer','2628','L', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2410','Assurance-emploi à payer','L','2627', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2420','RRQ Ã payer','L','2627', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2450','ImpÃt sur le revenu à payer','L','2628', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '2600', 'PASSIF Ã LONG TERME', NULL);
-SELECT account_save(NULL,'2620','Emprunts bancaires','2701','L', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'2680','Emprunt auprÃs des actionnaires','2780','L', NULL, false,string_to_array('AP_paid', ':'));
+SELECT account_save(NULL,'2620','Emprunts bancaires','L','2701', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'2680','Emprunt auprÃs des actionnaires','L','2780', NULL, false,string_to_array('AP_paid', ':'));
SELECT account_heading_save(NULL, '3300', 'CAPITAL SOCIAL', NULL);
-SELECT account_save(NULL,'3350','Actions ordinaires','3500','Q', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'3350','Actions ordinaires','Q','3500', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '4000', 'REVENUS DE VENTE', NULL);
-SELECT account_save(NULL,'4020','Ventes gÃnÃrales','8000','I', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
-SELECT account_save(NULL,'4030','PiÃces de rechange','8000','I', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
+SELECT account_save(NULL,'4020','Ventes gÃnÃrales','I','8000', NULL, false,string_to_array('AR_amount:IC_sale:IC_income', ':'));
+SELECT account_save(NULL,'4030','PiÃces de rechange','I','8000', NULL, false,string_to_array('AR_amount:IC_sale', ':'));
SELECT account_heading_save(NULL, '4400', 'AUTRES REVENUS', NULL);
-SELECT account_save(NULL,'4430','Transport et manutention','8457','I', NULL, false,string_to_array('IC_income', ':'));
-SELECT account_save(NULL,'4440','IntÃrÃts','8090','I', NULL, false,string_to_array('IC_income', ':'));
-SELECT account_save(NULL,'4450','Gain sur change','8231','I', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'4430','Transport et manutention','I','8457', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'4440','IntÃrÃts','I','8090', NULL, false,string_to_array('IC_income', ':'));
+SELECT account_save(NULL,'4450','Gain sur change','I','8231', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '5000', 'COÃT DES PRODUITS VENDUS', NULL);
-SELECT account_save(NULL,'5010','Achats','8320','E', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
-SELECT account_save(NULL,'5050','PiÃces de rechange','8320','E', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
-SELECT account_save(NULL,'5100','Frais de transport','8457','E', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
+SELECT account_save(NULL,'5010','Achats','E','8320', NULL, false,string_to_array('AP_amount:IC_cogs:IC_expense', ':'));
+SELECT account_save(NULL,'5050','PiÃces de rechange','E','8320', NULL, false,string_to_array('AP_amount:IC_cogs', ':'));
+SELECT account_save(NULL,'5100','Frais de transport','E','8457', NULL, false,string_to_array('AP_amount:IC_expense', ':'));
SELECT account_heading_save(NULL, '5400', 'FRAIS DE PERSONNEL', NULL);
-SELECT account_save(NULL,'5410','Salaires','9060','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5420','DÃpenses d''assurance-emploi','8622','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5430','DÃpenses RRQ','8622','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5440','DÃpenses CSST','8622','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5450','DÃpenses FSS','8622','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5460','DÃpenses RQAP','8622','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5470','DÃpenses vacances','8622','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5410','Salaires','E','9060', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5420','DÃpenses d''assurance-emploi','E','8622', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5430','DÃpenses RRQ','E','8622', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5440','DÃpenses CSST','E','8622', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5450','DÃpenses FSS','E','8622', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5460','DÃpenses RQAP','E','8622', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5470','DÃpenses vacances','E','8622', NULL, false,string_to_array('', ':'));
SELECT account_heading_save(NULL, '5600', 'DÃPENSES ADMINISTRATIVES ET GÃNÃRALES', NULL);
-SELECT account_save(NULL,'5610','Frais comptables et juridiques','8862','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5615','Publicità et promotion','8520','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5620','CrÃances irrÃvocables','8590','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5660','Amortissement de l''exercice','8670','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5680','ImpÃt sur le revenu','9990','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5685','Assurances','9804','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5690','IntÃrÃts et frais bancaires','9805','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5700','Fournitures de bureau','8811','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5760','Loyer','9811','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5780','TÃlÃphone','9225','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5785','Voyages et loisirs','8523','E', NULL, false,string_to_array('', ':'));
-SELECT account_save(NULL,'5790','Services publics','8812','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5765','RÃparation et entretien','8964','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5800','Taxes d''affaires, droits d''adhÃsion et permis','8760','E', NULL, false,string_to_array('AP_amount', ':'));
-SELECT account_save(NULL,'5810','Perte sur change','8231','E', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5610','Frais comptables et juridiques','E','8862', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5615','Publicità et promotion','E','8520', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5620','CrÃances irrÃvocables','E','8590', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5660','Amortissement de l''exercice','E','8670', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5680','ImpÃt sur le revenu','E','9990', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5685','Assurances','E','9804', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5690','IntÃrÃts et frais bancaires','E','9805', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5700','Fournitures de bureau','E','8811', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5760','Loyer','E','9811', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5780','TÃlÃphone','E','9225', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5785','Voyages et loisirs','E','8523', NULL, false,string_to_array('', ':'));
+SELECT account_save(NULL,'5790','Services publics','E','8812', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5765','RÃparation et entretien','E','8964', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5800','Taxes d''affaires, droits d''adhÃsion et permis','E','8760', NULL, false,string_to_array('AP_amount', ':'));
+SELECT account_save(NULL,'5810','Perte sur change','E','8231', NULL, false,string_to_array('', ':'));
--
insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.05);
insert into tax (chart_id,rate,pass) values ((select id from chart where accno = '2320'),0.075,1);
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.