GasAccounting logic

CASE
  WHEN SUBSTRING (CE.BUCode, 1, 2) = 'CB'
  AND SUBSTRING (CE.BUCode, 3, 1) NOT IN ('0', 'C')
     THEN 'CORPORATE'
  WHEN SUBSTRING (CE.BUCode, 1, 3) = 'CBC'
     THEN 'COMMERCIAL'
  WHEN SUBSTRING (CE.BUCode, 1, 2) = 'SM'
     THEN CASE
          WHEN C.ProductType LIKE '%CASH%' OR C.ProductType LIKE '%TUNAI%'
          THEN 'CONSUMER'
          ELSE 'SMALL BUSINESS'
          END
  WHEN SUBSTRING (CE.BUCode, 1, 2) = 'MB'
     THEN 'MICRO BANKING'
  WHEN SUBSTRING (CE.BUCode, 1, 2) = 'CL'
     THEN 'CONSUMER'
  WHEN SUBSTRING (CE.BUCode, 1, 2) IN ('FI','GI')
     THEN 'CORPORATE'
  WHEN SUBSTRING (CE.BUCode, 1, 2) IN ('CC')
     THEN 'CREDIT CARD'
END