Databases

Expense Reporting & Approval Chains Schema

ER Diagrams · made in Skemio

Entity relationship diagram showing corporate expense reports, line items, corporate card transactions, and multi-tier approval steps.
Entity relationship diagram showing corporate expense reports, line items, corporate card transactions, and multi-tier approval steps.
Open it in SkemioMake your own

What it shows

  • Store base currency and converted transaction amounts on line items.
  • Separate approval hierarchy state from employee organizational charts.
  • Match corporate card feed transactions using external settlement IDs.

The takeaway

Capture point-in-time exchange rates and dynamic approval states to insulate reports from org changes.

More er diagrams