---
title: "YearFiscalYear_CollectionCost_typeSearchTransactionLines (Minox)"
description: "itgen_minox_yearfiscalyear_collectioncost_typesearchtransactionlines_plural"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/minox/Minox.FinancialTransactionLines.YearFiscalYear_CollectionCost_typeSearchTransactionLines
original: https://documentation.invantive.eu/en/datamodels/minox/Minox.FinancialTransactionLines.YearFiscalYear_CollectionCost_typeSearchTransactionLines
updated: 2026-11-01T16:19:41Z
license: https://documentation.invantive.eu/en/
---

# YearFiscalYear_CollectionCost_typeSearchTransactionLines: Minox itgen_minox_yearfiscalyear_collectioncost_typesearchtransactionlines_plural

`read only` `per partition` `REST`

- Catalog: `Minox`
- Schema: `FinancialTransactionLines`
- Label: itgen_minox_yearfiscalyear_collectioncost_typesearchtransactionlines_plural

Get all the lines belonging to a period in the specified year.

The data in this table is partitioned per value of the `administration_code` column.

Can only retrieve data.

## API Source

- Endpoint: `/tenant/{tenant_id}/administration/{administration_id}/year/{fiscal_year}/transaction_lines`
- Operation: `get /tenant/{tenant_id}/administration/{administration_id}/year/{fiscal_year}/transaction_lines`

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `account_id` | `` | [ ] |  | Filter on a specific account id. |
| `administration_code` | `` | [ ] |  | Partition to retrieve data from. |
| `fiscal_year` | `` | [x] |  | The fiscal year of the administration to which you want to connect. |
| `invoice_number` | `` | [ ] |  | Filter on a specific invoice number. |
| `period` | `` | [ ] |  | Filter on a period of when the transaction occured. |
| `usesubledger` | `` | [ ] |  | If the subledger is applicable in the data it is used instead of the ledger. |

## Table Columns

The columns of the table `YearFiscalYear_CollectionCost_typeSearchTransactionLines` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `account_description` | `varchar2` | Account Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.account.description` |  |
| `account_id` | `varchar2` | Account ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.account.id` |  |
| `account_scheme` | `varchar2` | Account Scheme | [ ] | filters on the platform, writable, `::ancestor.::ancestor.account.scheme` |  |
| `account_type` | `varchar2` | Account Type | [ ] | filters on the platform, writable, `::ancestor.::ancestor.account.type` |  |
| `batch_id` | `guid` | Batch ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.batch_id` |  |
| `cost_center_description` | `varchar2` | Cost Centre Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.cost_center.description` |  |
| `credit` | `decimal` | Credit | [ ] | filters on the platform, writable, `::ancestor.::ancestor.credit` |  |
| `currency_description` | `varchar2` | Currency Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.currency.description` |  |
| `currency_exchange_rate` | `decimal` | Currency Exchange Rate | [ ] | filters on the platform, writable, `::ancestor.::ancestor.currency.exchange_rate` |  |
| `currency_id` | `varchar2` | Currency ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.currency.id` |  |
| `debit` | `decimal` | Debit | [ ] | filters on the platform, writable, `::ancestor.::ancestor.debit` |  |
| `description` | `varchar2` | Description | [ ] | writable, `::ancestor.description` |  |
| `description_2` | `varchar2` | itgen_minox_description_2 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.description` |  |
| `document_date` | `datetime` | Document Date | [ ] | filters on the platform, writable, `::ancestor.::ancestor.document_date` |  |
| `document_id` | `varchar2` | Document ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.document_id` |  |
| `due_date` | `datetime` | Due Date | [ ] | filters on the platform, writable, `::ancestor.::ancestor.due_date` |  |
| `entry_number` | `int64` | Entry Number | [ ] | filters on the platform, writable, `::ancestor.::ancestor.entry_number` |  |
| `id` | `guid` | ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.id` |  |
| `invoice_number` | `int64` | Invoice Number | [ ] | filters on the platform, writable, `::ancestor.::ancestor.invoice_number` |  |
| `journal_description` | `varchar2` | Journal Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.journal.description` |  |
| `journal_id` | `varchar2` | Journal ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.journal.id` |  |
| `journal_line_number` | `int64` | Journal Line Number | [ ] | filters on the platform, writable, `::ancestor.::ancestor.journal.line_number` | The current line number of the journal. |
| `journal_page_number` | `int64` | Journal Page Number | [ ] | filters on the platform, writable, `::ancestor.::ancestor.journal.page_number` | The current page number of the journal. |
| `journal_type` | `varchar2` | Journal Type | [ ] | filters on the platform, writable, `::ancestor.::ancestor.journal.type` |  |
| `payment_term_description` | `varchar2` | Payment Term Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.payment_term.description` |  |
| `payment_term_id` | `int64` | Payment Term ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.payment_term.id` |  |
| `period_description` | `varchar2` | Period Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.period.description` |  |
| `period_fiscal_year` | `int64` | Period Fiscal Year | [ ] | filters on the platform, writable, `::ancestor.::ancestor.period.fiscal_year` |  |
| `period_id` | `int64` | Period ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.period.id` |  |
| `vat_account_id` | `varchar2` | VAT Account ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.vat.account_id` |  |
| `vat_amount` | `decimal` | VAT Amount | [ ] | filters on the platform, writable, `::ancestor.::ancestor.vat.amount` |  |
| `vat_description` | `varchar2` | VAT Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.vat.description` |  |
| `vat_id` | `int64` | VAT ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.vat.id` |  |
| `vat_percentage` | `decimal` | VAT Percentage | [ ] | filters on the platform, writable, `::ancestor.::ancestor.vat.percentage` |  |
| `vat_type` | `varchar2` | VAT Type | [ ] | filters on the platform, writable, `::ancestor.::ancestor.vat.type` |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Minox](/en/release-notes/drivers?driver=minox)

### Changes of This Table, 26.0 to 27.0

<a id="MNX-27.0-D041"></a><a id="MNX-27.0-D042"></a>

- `-` `administration_code`
- `-` `administration_name`

[All changes of the driver, 26.0 to 27.0](/en/release-notes/drivers?driver=minox&step=26.0-to-27.0#minox-26.0-to-27.0)

