Aegis Important Config And Setting Tables

Module: Application And General

• Description: Stores logs of unexpected system errors.
  Table: public.tbl_error_log

• Description: Stores information about whether ABB invoice printing is allowed and whether it is IRD approved.
  Table: app.tbl_ird_approval

• Description: Holds configuration for VAT bill prefix and Application module lock settings.
  Table: app.tbl_config

• Description: Tracks email queue and status (sent or not sent).
  Table: app.tbl_email_queue

---

Module: Front Office

Description: Currently no data or configuration. Will be added in future.

---

Module: Point Of Sale

Description: Currently no data or configuration. Will be added in future.

---

Module: Inventory

Description: Currently no data or configuration. Will be added in future.

---

Module: Account

Description: Currently no data or configuration. Will be added in future.

---

Module: Housekeeping

Description: Currently no data or configuration. Will be added in future.

---

Module: Costing

Description: Currently no data or configuration. Will be added in future.

---

Module: HR

• Description: Stores settings for applying discounts for female employees during payroll calculations.
  Table: hr.tbl_settings

• Description: Determines if salary posting is based on Gregorian (AD) or Nepali (BS) calendar.
  Table: hr.tbl_salary_posting_on

---

This document outlines system modules and their associated database tables, providing key configuration settings in one place to simplify development and maintenance tasks.

Prepared By - Sundar Mishra