EwtTransaction
One month's expanded withholding on income payments to a payee under one ATC code.
| Table | ewt_transactions |
| Tenant-scoped | Yes — extends TenantOwned |
| Columns | 11 |
| Relationships | 1 |
| Source | backend/src/main/java/com/motorph/payroll/model/EwtTransaction.java |
Columns
| Field | Type | Column | Null | Notes |
|---|---|---|---|---|
ewtTransactionId | Integer | ewt_transaction_id | — | primary key, generated |
periodMonth | LocalDate | period_month | — | — |
atcCode | String | atc_code | — | — |
incomePayment | BigDecimal | income_payment | — | — |
taxRate | BigDecimal | tax_rate | — | — |
taxWithheld | BigDecimal | tax_withheld | — | — |
remarks | String | remarks | Yes | — |
createdBy | String | created_by | Yes | — |
createdDate | LocalDateTime | created_date | Yes | — |
lastModifiedBy | String | last_modified_by | Yes | — |
lastModifiedDate | LocalDateTime | last_modified_date | Yes | — |
Plus tenant_id, inherited from TenantOwned. Hibernate stamps it on insert and adds where tenant_id = ? to every query, so it is never written or read by application code.
Relationships
| Field | Kind | Target | Join column | Required |
|---|---|---|---|---|
payee | @ManyToOne | EwtPayee | ewt_payee_id | Yes |
Neighbourhood
Repository
EwtTransactionRepository
Declared over EwtTransaction with id type Integer. Source: backend/src/main/java/com/motorph/payroll/repository/EwtTransactionRepository.java
| Method | Returns | Notes |
|---|---|---|
findFiltered(@Param("payeeId") Integer payeeId, @Param("from") LocalDate from, @Param("to") LocalDate to, Pageable pageable) | Page<EwtTransaction> | explicit @Query |
findAllByPeriodMonthBetweenOrderByPeriodMonthAsc(LocalDate from, LocalDate to) | List<EwtTransaction> | derived |
existsByPayee_EwtPayeeId(Integer payeeId) | boolean | derived |
Reached by
These controllers hold — directly or through a service they depend on — a repository over EwtTransaction.
| Controller | Base path | Endpoints | Module |
|---|---|---|---|
| EwtController | /api | 8 | PH Statutory |
| EwtFormsController | /api/government-forms/ewt | 4 | PH Statutory |
Generated page
This page is rebuilt from the source on every docs build by docs-site/scripts/gen-code-wiki.mjs. Editing it has no effect — change the code, or, if what you want to say is prose, write it in docs/.