Subscriber billing

A subscriber has a connection, a plan, and a status: live, due, or paused.

The bill for the month is generated from the plan. A payment closes it.

A collector's list is the dues on their route.

A pause is a date range. The next bill can see it.

A new connection is a row before the first bill. It does not skip the record.

The office sees which areas have not been collected.

A complaint about the line can sit on the same subscriber.

A plan change is dated. The old rate does not silently cover the new month.

A new cashier can take a payment and find a connection on the first day.

The close is billed, collected, and still due.