SF.net SVN: ledger-smb:[4432] branches/1.3/sql/coa

[..hidden..]

Revision: 4432
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4432&view=rev
Author:   einhverfr
Date:     2012-03-10 10:53:52 +0000 (Sat, 10 Mar 2012)
Log Message:
-----------
More bank account recon setups added

Modified Paths:
--------------
    branches/1.3/sql/coa/tw/chart/General.sql
    branches/1.3/sql/coa/uk/chart/General.sql
    branches/1.3/sql/coa/us/chart/General.sql
    branches/1.3/sql/coa/us/chart/Manufacturing.sql
    branches/1.3/sql/coa/us/chart/Service.sql
    branches/1.3/sql/coa/us/chart/UCOA-Form990.sql
    branches/1.3/sql/coa/us/chart/UCOA-Form990EZ.sql
    branches/1.3/sql/coa/ve/chart/General.sql

Modified: branches/1.3/sql/coa/tw/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/tw/chart/General.sql	2012-03-10 10:46:46 UTC (rev 4431)
+++ branches/1.3/sql/coa/tw/chart/General.sql	2012-03-10 10:53:52 UTC (rev 4432)
@@ -66,6 +66,9 @@
 SELECT account_save(NULL,'4320','èè','I','', NULL, false, false, string_to_array('AR_amount:IC_income', ':'));
 SELECT account_save(NULL,'1200','ææåæ','A','', NULL, false, false, string_to_array('AR', ':'));
 SELECT account_save(NULL,'1061','æçæé','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno in ('1061', '1065');
+
 SELECT account_save(NULL,'2310','ååæåç','L','', NULL, false, false, string_to_array('AR_tax:AP_tax:IC_taxpart:IC_taxservice', ':'));
 --
 -- exchange rate

Modified: branches/1.3/sql/coa/uk/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/uk/chart/General.sql	2012-03-10 10:46:46 UTC (rev 4431)
+++ branches/1.3/sql/coa/uk/chart/General.sql	2012-03-10 10:53:52 UTC (rev 4432)
@@ -23,6 +23,9 @@
 SELECT account_save(NULL,'1220','Building Society Account','A','', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1230','Petty Cash','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1240','Company Credit Card','L','', NULL, false, false, string_to_array('', ':'));
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno in ('1200', '1210', '1220', '1230', '1240');
+
 SELECT account_save(NULL,'2100','Creditors Control Account','L','', NULL, false, false, string_to_array('AP', ':'));
 SELECT account_save(NULL,'2102','Other Creditors','L','', NULL, false, false, string_to_array('AP', ':'));
 SELECT account_save(NULL,'2109','Accruals','L','', NULL, false, false, string_to_array('', ':'));

Modified: branches/1.3/sql/coa/us/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/us/chart/General.sql	2012-03-10 10:46:46 UTC (rev 4431)
+++ branches/1.3/sql/coa/us/chart/General.sql	2012-03-10 10:53:52 UTC (rev 4432)
@@ -5,6 +5,9 @@
 SELECT account_heading_save(NULL,'1000','CURRENT ASSETS', NULL);
 SELECT account_save(NULL,'1060','Checking Account','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1065','Petty Cash','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno in ('1060', '1065');
+
 SELECT account_save(NULL,'1200','Accounts Receivables','A','', NULL, false, false, string_to_array('AR', ':'));
 SELECT account_save(NULL,'1205','Allowance for doubtful accounts','A','', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'1500','INVENTORY ASSETS', NULL);

Modified: branches/1.3/sql/coa/us/chart/Manufacturing.sql
===================================================================
--- branches/1.3/sql/coa/us/chart/Manufacturing.sql	2012-03-10 10:46:46 UTC (rev 4431)
+++ branches/1.3/sql/coa/us/chart/Manufacturing.sql	2012-03-10 10:53:52 UTC (rev 4432)
@@ -5,6 +5,9 @@
 SELECT account_heading_save(NULL,'1000','CURRENT ASSETS', NULL);
 SELECT account_save(NULL,'1060','Checking Account','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1065','Petty Cash','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno in ('1060', '1065');
+
 SELECT account_save(NULL,'1200','Accounts Receivables','A','', NULL, false, false, string_to_array('AR', ':'));
 SELECT account_save(NULL,'1205','Allowance for doubtful accounts','A','', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'1500','INVENTORY ASSETS', NULL);

Modified: branches/1.3/sql/coa/us/chart/Service.sql
===================================================================
--- branches/1.3/sql/coa/us/chart/Service.sql	2012-03-10 10:46:46 UTC (rev 4431)
+++ branches/1.3/sql/coa/us/chart/Service.sql	2012-03-10 10:53:52 UTC (rev 4432)
@@ -5,6 +5,9 @@
 SELECT account_heading_save(NULL,'1000','CURRENT ASSETS', NULL);
 SELECT account_save(NULL,'1060','Checking Account','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1065','Petty Cash','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno in ('1060', '1065');
+
 SELECT account_save(NULL,'1200','Accounts Receivables','A','', NULL, false, false, string_to_array('AR', ':'));
 SELECT account_save(NULL,'1205','Allowance for doubtful accounts','A','', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'1500','INVENTORY ASSETS', NULL);

Modified: branches/1.3/sql/coa/us/chart/UCOA-Form990.sql
===================================================================
--- branches/1.3/sql/coa/us/chart/UCOA-Form990.sql	2012-03-10 10:46:46 UTC (rev 4431)
+++ branches/1.3/sql/coa/us/chart/UCOA-Form990.sql	2012-03-10 10:53:52 UTC (rev 4432)
@@ -6,6 +6,9 @@
 SELECT account_save(NULL,'1020','Cash in bank-payroll','A','45', NULL, false, false, string_to_array('AP_paid', ':'));
 SELECT account_save(NULL,'1040','Petty cash','A','45', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1070','Savings & short-term investments','A','46', NULL, false, false, string_to_array('', ':'));
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno in ('1010', '1020', '1040', '1070');
+
 SELECT account_heading_save(NULL,'1100','Accounts receivable', NULL);
 SELECT account_save(NULL,'1110','Accounts receivable','A','47a', NULL, false, false, string_to_array('AR', ':'));
 SELECT account_save(NULL,'1115','Doubtful accounts allowance','A','47b', NULL, true, false, string_to_array('AR_paid', ':'));

Modified: branches/1.3/sql/coa/us/chart/UCOA-Form990EZ.sql
===================================================================
--- branches/1.3/sql/coa/us/chart/UCOA-Form990EZ.sql	2012-03-10 10:46:46 UTC (rev 4431)
+++ branches/1.3/sql/coa/us/chart/UCOA-Form990EZ.sql	2012-03-10 10:53:52 UTC (rev 4432)
@@ -6,6 +6,9 @@
 SELECT account_save(NULL,'1020','Cash in bank-payroll','A','22', NULL, false, false, string_to_array('AP_paid', ':'));
 SELECT account_save(NULL,'1040','Petty cash','A','22', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1070','Savings & short-term investments','A','22', NULL, false, false, string_to_array('', ':'));
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno in ('1010', '1020', '1040', '1070');
+
 SELECT account_heading_save(NULL,'1100','Accounts receivable', NULL);
 SELECT account_save(NULL,'1110','Accounts receivable','A','24', NULL, false, false, string_to_array('', ':'));
 SELECT account_save(NULL,'1115','Doubtful accounts allowance','A','24', NULL, true, false, string_to_array('AR_paid', ':'));

Modified: branches/1.3/sql/coa/ve/chart/General.sql
===================================================================
--- branches/1.3/sql/coa/ve/chart/General.sql	2012-03-10 10:46:46 UTC (rev 4431)
+++ branches/1.3/sql/coa/ve/chart/General.sql	2012-03-10 10:53:52 UTC (rev 4432)
@@ -10,6 +10,9 @@
 SELECT account_save(NULL,'1110','Provincial','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1120','Venezuela','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
 SELECT account_save(NULL,'1130','Banesco JD','A','', NULL, false, false, string_to_array('AR_paid:AP_paid', ':'));
+SELECT cr_coa_to_account_save(accno, accno || '--' || description)
+FROM account WHERE accno in ('1050', '1100', '1110', '1120', '1130');
+
 SELECT account_save(NULL,'1200','Cuentas por Cobrar','A','', NULL, false, false, string_to_array('AR', ':'));
 SELECT account_save(NULL,'1205','ProvisiÃn Cuentas Incobrables','A','', NULL, false, false, string_to_array('', ':'));
 SELECT account_heading_save(NULL,'1500','INVENTARIO', NULL);

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