UPDATE A
SET A.iAllowICPurchases =
CASE WHEN AT.cAccountTypeDescription IN ('Other Expense','Property, Plant and Equipment','Cost of Sales'
,'Finance Cost','Distribution Cost','Administration Expense')
THEN 1 ELSE 0 END
FROM Accounts A
LEFT JOIN _etblGLAccountTypes AT ON A.iAccountType = AT.idGLAccountType
Overview
Content Tools