Thanks for the response, guys! I eventually discarded this approach and went ahead with 'Debit - Credit' regardless of Account Type. This, I was told by a few Finance guys, was the way to go from a functional perspective.

But I guess this post would be useful in the future for those who face similar situations when working on ETL for other industries.

Thanks a ton, guys! I really appreciate it. 🙂