---
tags: [accounting, database]
module: Accounting
---

# DatabaseTables

## Connections
[[_Accounting]] · [[[Model]Account]] · [[[Model]JournalEntry]] · [[[Model]JournalRecord]] · [[[Model]Asset]] · [[[Model]BankStatement]] · [[[Model]EasyEntry]] · [[[Model]Reconciliation]] · [[[Model]IntegrationModels]] · [[[Cross]CrossModuleDependencies]]

## Source
`Modules/Accounting/Database/Migrations/tenancy/` (56 migration files)

---

## Account Tables

### `accounts`
Key columns: `id`, `name_ar`, `name_en`, `code`, `subcategory_id` → `acounting_sub_categories`, `status`, `is_main`, `currency_code`, `current_total_debit`, `current_total_credit`, `current_balance`, `created_by` → `users`

### `accounting_categories`
Key columns: `id`, `name_ar`, `name_en`, `default_type`, `income_statement`, `balance_sheet`

### `acounting_sub_categories`
Key columns: `id`, `accounting_category_id` → `accounting_categories`, `name_ar`, `name_en`, `code`

### `accounting_trees`
Key columns: `id`, `parent_id` → `accounts`, `account_id` → `accounts`, `sequence`

### `account_fiscal_year_balances`
Key columns: `id`, `account_id` → `accounts`, `fiscal_year_id` → `fiscal_year`, `opening_debit`, `opening_credit`, `closing_debit`, `closing_credit`

### `account_customer` (pivot)
Columns: `account_id` → `accounts`, `customer_id` → `customers`

### `account_supplier` (pivot)
Columns: `account_id` → `accounts`, `supplier_id` → `suppliers`

### `account_integrations`
Key columns: `id`, `account_id` → `accounts`, `integration_type`, `external_id`

---

## Journal Entry Tables

### `journal_entries`
Key columns: `id`, `fiscal_year_id` → `fiscal_year`, `created_by` → `users`, `memo`, `code`, `date`, `date_from`, `date_to`, `is_period`

### `journal_records`
Key columns: `id`, `journal_entry_id` → `journal_entries`, `account_id` → `accounts`, `customer_id` → `customers`, `supplier_id` → `suppliers`, `value`, `exchange_rate`, `transaction_type`, `balance_after_transaction`, `currency_code`, `tax_id` → `taxes`, `total_debit`, `total_credit`

### `journal_attachments`
Key columns: `id`, `journal_entry_id` → `journal_entries`, `name`, `path`

---

## Easy Entry Table

### `easy_entries`
Key columns: `id`, `entry_type`, `account_from` → `accounts`, `account_to` → `accounts`, `amount`, `currency_code`, `created_by` → `users`, `journal_entry_id` → `journal_entries`

---

## Reconciliation Tables

### `reconciliations`
Key columns: `id`, `reconciled_account_id` → `accounts`, `reconciliation_account_id` → `accounts`, `date_from`, `date_to`, `system_total`, `audit_total`, `difference`, `status`, `added_by`, `confirmed_by`, `journal_entry_id` → `journal_entries`, `confirmed_at`

### `reconciliation_details`
Key columns: `id`, `reconciliation_id` → `reconciliations`, `journal_record_id` → `journal_records`

---

## Asset Tables

### `assets`
Key columns: `id`, `name_ar`, `name_en`, `main_account` → `accounts`, `buying_cost`, `buying_date`, `total_depreciation`, `total_capitalization`, `current_value`, `depreciation_method`, `depreciation_account` → `accounts`, `journal_entry_id` → `journal_entries`, `account_id` → `accounts`, `supplier_id` → `suppliers`, `cost_center_id` → `cost_centers`, `asset_type`, `tax_id` → `taxes`, `is_depreciated`

### `asset_depreciations`
Key columns: `id`, `asset_id` → `assets`, `depreciation_amount`, `depreciation_date`, `residual_value`, `journal_entry_id` → `journal_entries`

### `asset_capitalizations`
Key columns: `id`, `asset_id` → `assets`, `capitalization_amount`, `capitalization_date`, `journal_entry_id` → `journal_entries`, `supplier_id`, `tax_id`, `vat_amount`

### `asset_sells`
Key columns: `id`, `asset_id` → `assets`, `selling_amount`, `selling_date`, `profit_loss`, `journal_entry_id` → `journal_entries`, `tax_id`, `vat_amount`

### `asset_parameters`
Key columns: `id`, `asset_id` → `assets`, `parameter_key`, `parameter_value`

### `asset_attachments` / `asset_capitalization_attachments`
Key columns: `id`, `asset_id` or `asset_capitalization_id`, `name`, `path`

---

## Bank Statement Tables

### `bank_statements`
Key columns: `id`, `account_id` → `accounts`, `fiscal_year_id` → `fiscal_year`, `start_date`, `end_date`, `source`, `status`, `created_by`

### `bank_statement_records`
Key columns: `id`, `bank_statement_id` → `bank_statements`, `reference_number`, `amount`, `debit`, `credit`, `date`, `balance`, `description`, `status`, `journal_entry_id` → `journal_entries`

---

## Integration Tables

### `success_synced_order_manual_entry`
Key columns: `id`, `order_id`, `journal_entry_id` → `journal_entries`, `transaction_type`, `cost_center_id`, `total_debit`, `total_credit`

### `success_synced_order_single_records`
Key columns: `id`, `order_id`, `single_record_journal_entry_id`

### `failed_synced_orders`
Key columns: `id`, `order_id`, `integration_type`, `error_message`

### `sync_segments`
Key columns: `id`, batch tracking columns

### `payment_options_integrations`
Key columns: `id`, `payment_option_id`, `account_id` → `accounts`

### `single_record_journal_entries`
Key columns: `id`, `journal_entry_id` → `journal_entries`, `cost_center_id`, `account_id` → `accounts`, `value`, `transaction_type`

### `single_record_accounts`
Key columns: `id`, `account_id` → `accounts`, `journal_entry_id` → `journal_entries`, `value`, `transaction_type`

---

## Supporting Tables

### `currencies`
Key columns: `id`, `name`, `code`, `symbol`, `exchange_rate`