X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=sql-ledger%2Fsql%2FSwiss-German-chart.sql;h=b4a4405012be99107e3851b92a8cbc15c0203659;hp=75959efd29101047ba29c64d155727eaea9c9696;hb=32306b5f8ffe4ce594409aa6e89626740b225a39;hpb=52072fcd26f2faf57923f598c358e7f47c4e2643 diff --git a/sql-ledger/sql/Swiss-German-chart.sql b/sql-ledger/sql/Swiss-German-chart.sql index 75959efd2..b4a440501 100644 --- a/sql-ledger/sql/Swiss-German-chart.sql +++ b/sql-ledger/sql/Swiss-German-chart.sql @@ -156,5 +156,5 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '212 insert into tax (chart_id,rate) values ((select id from chart where accno = '21221'),0.024); insert into tax (chart_id,rate) values ((select id from chart where accno = '21224'),0.076); -- -update defaults set inventory_accno_id = (select id from chart where accno = '11121'), income_accno_id = (select id from chart where accno = '34002'), expense_accno_id = (select id from chart where accno = '42005'), fxgain_accno_id = (select id from chart where accno = '36005'), fxloss_accno_id = (select id from chart where accno = '39006'), invnumber = '2002000', sonumber = '2002000', ponumber = '2002000', curr = 'EUR:USD', weightunit = 'kg'; +update defaults set inventory_accno_id = (select id from chart where accno = '11121'), income_accno_id = (select id from chart where accno = '34002'), expense_accno_id = (select id from chart where accno = '42005'), fxgain_accno_id = (select id from chart where accno = '36005'), fxloss_accno_id = (select id from chart where accno = '39006'), curr = 'EUR:USD', weightunit = 'kg'; --