User Tools

Site Tools


update_tax_chart_id

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

update_tax_chart_id [2016/08/21 19:30] (current)
sweitmann created
Line 1: Line 1:
 +    update acc_trans set tax_chart_id = (select id from chart where accno = substr(acc_trans.tax,1,4)) where tax <> '' and tax <> 'auto';
update_tax_chart_id.txt ยท Last modified: 2016/08/21 19:30 by sweitmann