Are you a Sungard HE customer using the Banner ERP Software?
Have you ever wanted to know how to easily select a student’s account balance?

Well, all of a student’s charges and payments are held in the tbraccd table. Banner defines the tbraccd table as the “Account Charge/Payment Detail Table”. Furthermore, each entry in the tbraccd table has a specific detail code defined in the tbraccd_detail_code column. This column relates to the tbbdetc table, which Banner defines as the “Detail Charge/Payment Code Definition Table”.

Essentially, the tbraccd table stores the type of transaction, and the transaction amount. The tbbdetc table tells us whether that transaction type is a charge or a payment. continue reading…