X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=sql-ledger%2Fsql%2FDutch_Standard-chart.sql;h=19c571188e8d3703ec1fa1a45168c17beb6ebb27;hp=cd7c8eb2220cf2cd04f389c523d5d036aba15618;hb=32306b5f8ffe4ce594409aa6e89626740b225a39;hpb=52072fcd26f2faf57923f598c358e7f47c4e2643 diff --git a/sql-ledger/sql/Dutch_Standard-chart.sql b/sql-ledger/sql/Dutch_Standard-chart.sql index cd7c8eb22..19c571188 100644 --- a/sql-ledger/sql/Dutch_Standard-chart.sql +++ b/sql-ledger/sql/Dutch_Standard-chart.sql @@ -229,5 +229,5 @@ insert into tax (chart_id,rate) values ((select id from chart where accno = '180 insert into tax (chart_id,rate) values ((select id from chart where accno = '1810'),0.19); insert into tax (chart_id,rate) values ((select id from chart where accno = '1811'),0.06); -- -update defaults set inventory_accno_id = (select id from chart where accno = '7001'), income_accno_id = (select id from chart where accno = '8520'), expense_accno_id = (select id from chart where accno = '8010'), fxgain_accno_id = (select id from chart where accno = '9220'), fxloss_accno_id = (select id from chart where accno = '9220'), invnumber = '0000', sonumber = '0000', ponumber = '0000', curr = 'EUR:USD', weightunit = 'kg'; +update defaults set inventory_accno_id = (select id from chart where accno = '7001'), income_accno_id = (select id from chart where accno = '8520'), expense_accno_id = (select id from chart where accno = '8010'), fxgain_accno_id = (select id from chart where accno = '9220'), fxloss_accno_id = (select id from chart where accno = '9220'), curr = 'EUR:USD', weightunit = 'kg'; --