Taxes Database

Main design of the database is to have taxes associated with three accounts (in, out, and paid), with a closing operation that allows paid to be moved against the in and out accounts.

Application Contexts

• Tax, Summary
• Tax, Collected
• Tax, Paid AP (to Vendors)
• Tax, Paid (to authorities)

Retired application contexts

We will no longer separate services and goods.

Bootstrapping

All tax accounts will be given all 4 contexts

Tax rule parameter modelling

The tax module table will have a new parameter jsonb field which will take a json validator object.

Tax rule parameter storage

The tax table will store the configured parameters for the jsonb parameter object