search_payslip_items
Search payslip line items by keyword to get monthly breakdowns and totals for competenze and ritenute, filtered by optional year range.
Instructions
Search payslip line items by description keyword.
Searches the voci_corpo_busta table using SQL LIKE matching. Groups and sums results by month/year.
Args: keyword: Search term (e.g. "Straordinario", "Ferie", "Ticket", "Commissioni"). start_year: Filter from this year (optional). end_year: Filter up to this year (optional).
Returns per-month breakdown and grand totals for competenze and ritenute.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| keyword | Yes | ||
| end_year | No | ||
| start_year | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |