invantive documentation
Invantive Support ForumsLog In / Sign Up

TransactionLineBatch_Cost_typeSearchBatchId: Minox itgen_minox_transactionlinebatch_cost_typesearchbatchid_plural

read only per partition REST

  • Catalog: Minox
  • Schema: FinancialTransactionLineBatch
  • Label: itgen_minox_transactionlinebatch_cost_typesearchbatchid_plural

Get all the lines belonging to a single batch.

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}/transaction_line_batch/{batch_id}
  • Operation: get /tenant/{tenant_id}/administration/{administration_id}/transaction_line_batch/{batch_id}

Parameters

Name Data Type Required Default Documentation
administration_code `` Partition to retrieve data from.
batch_id `` The identity of a transaction line batch. This must be an UUID.

Table Columns

The columns of the table TransactionLineBatch_Cost_typeSearchBatchId 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:

Changes of This Table, 26.0 to 27.0

  • - administration_code
  • - administration_name

All changes of the driver, 26.0 to 27.0