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