creditbatches

Each row represents a named batch of prepaid credit with balances and expiry dates.

Full schema

View all columns and table relationships

Status group

Yes, this table includes a statusgroup column. See Status Group for details.

Sample query

select
  t.expireson,
  t.clientid,
  t.startingbalance,
  t.currentbalance,
  t.creditbatchname
from creditbatches as t
limit 100