invantive documentation
Invantive Support ForumsLog In / Sign Up

TransactionLinesByFiscalYearPeriod: Minox Transaction Lines by Fiscal Year and Period

read only per partition REST

  • Catalog: Minox
  • Schema: FinancialTransactionLines
  • Label: Transaction Lines by Fiscal Year and Period

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

Release Notes

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

Changes of This Table, 26.0 to 27.0

  • - administration_code
  • - administration_name

All changes of the driver, 26.0 to 27.0