[P1][Expense] Expense category hierarchy (Group + SubCategory) with seed data #25

Open
opened 2026-05-26 01:33:00 +00:00 by ChrisChen · 0 comments
Owner

Overview

Two-level expense categorization: Category Group x Sub-Category, scoped by Ministry. Pre-seeded with standard types.

Seed Data

Equipment (Purchase/Rental/Repair), Consumables (Batteries/Cleaning), Food and Beverage (Catering/Groceries), Training (Courses/Books), Materials (Printing/Craft), Facility (Rent/Utilities), Printing, Missions, Benevolence, Other

Tasks

  • ExpenseCategoryGroup table: id, name_en, name_zh, sort_order, is_active
  • ExpenseSubCategory table: id, group_id, name_en, name_zh, sort_order, is_active
  • Seed data via DbInitializer (10 groups, ~30 sub-categories)
  • Admin UI to add/edit/deactivate categories (finance, super_admin)

Reference

PLANNING.md Section 3.6d - Expense category structure and seed data table

## Overview Two-level expense categorization: Category Group x Sub-Category, scoped by Ministry. Pre-seeded with standard types. ## Seed Data Equipment (Purchase/Rental/Repair), Consumables (Batteries/Cleaning), Food and Beverage (Catering/Groceries), Training (Courses/Books), Materials (Printing/Craft), Facility (Rent/Utilities), Printing, Missions, Benevolence, Other ## Tasks - [ ] ExpenseCategoryGroup table: id, name_en, name_zh, sort_order, is_active - [ ] ExpenseSubCategory table: id, group_id, name_en, name_zh, sort_order, is_active - [ ] Seed data via DbInitializer (10 groups, ~30 sub-categories) - [ ] Admin UI to add/edit/deactivate categories (finance, super_admin) ## Reference PLANNING.md Section 3.6d - Expense category structure and seed data table
ChrisChen added this to the Phase 1 - MVP milestone 2026-05-26 01:33:00 +00:00
ChrisChen added the module: expense label 2026-05-26 01:33:00 +00:00
Sign in to join this conversation.