TransactionLinesByBatchId: Minox Transaction Lines by Batch ID
read only per partition REST
- Catalog:
Minox - Schema:
FinancialTransactionLineBatch - Label: Transaction Lines by Batch ID
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_ |
`` | Partition to retrieve data from. | ||
batch_ |
`` | The identity of a transaction line batch. This must be an UUID. |
Table Columns
The columns of the table TransactionLinesByBatchId 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_ |
varchar2 |
Account Description | filters on the platform, writable, account. |
||
account_ |
varchar2 |
Account ID | filters on the platform, writable, account. |
||
account_ |
varchar2 |
Account Scheme | filters on the platform, writable, account. |
||
account_ |
varchar2 |
Account Type | filters on the platform, writable, account. |
||
batch_ |
guid |
Batch ID | filters on the platform, writable, batch_ |
||
cost_ |
varchar2 |
Cost Centre Description | filters on the platform, writable, cost_ |
||
cost_ |
varchar2 |
Cost Type Description | filters on the platform, writable, cost_ |
||
credit |
decimal |
Credit | filters on the platform, writable, credit |
||
currency_ |
varchar2 |
Currency Description | filters on the platform, writable, currency. |
||
currency_ |
decimal |
Currency Exchange Rate | filters on the platform, writable, currency. |
||
currency_ |
varchar2 |
Currency ID | filters on the platform, writable, currency. |
||
debit |
decimal |
Debit | filters on the platform, writable, debit |
||
description |
varchar2 |
Description | filters on the platform, writable, description |
||
document_ |
datetime |
Document Date | filters on the platform, writable, document_ |
||
document_ |
varchar2 |
Document ID | filters on the platform, writable, document_ |
||
due_ |
datetime |
Due Date | filters on the platform, writable, due_ |
||
entry_ |
int64 |
Entry Number | filters on the platform, writable, entry_ |
||
id |
guid |
ID | filters on the platform, writable, id |
||
invoice_ |
int64 |
Invoice Number | filters on the platform, writable, invoice_ |
||
journal_ |
varchar2 |
Journal Description | filters on the platform, writable, journal. |
||
journal_ |
varchar2 |
Journal ID | filters on the platform, writable, journal. |
||
journal_ |
int64 |
Journal Line Number | filters on the platform, writable, journal. |
The current line number of the journal. | |
journal_ |
int64 |
Journal Page Number | filters on the platform, writable, journal. |
The current page number of the journal. | |
journal_ |
varchar2 |
Journal Type | filters on the platform, writable, journal. |
||
payment_ |
varchar2 |
Payment Term Description | filters on the platform, writable, payment_ |
||
payment_ |
int64 |
Payment Term ID | filters on the platform, writable, payment_ |
||
period_ |
varchar2 |
Period Description | filters on the platform, writable, period. |
||
period_ |
int64 |
Period Fiscal Year | filters on the platform, writable, period. |
||
period_ |
int64 |
Period ID | filters on the platform, writable, period. |
||
vat_ |
varchar2 |
VAT Account ID | filters on the platform, writable, vat. |
||
vat_ |
decimal |
VAT Amount | filters on the platform, writable, vat. |
||
vat_ |
varchar2 |
VAT Description | filters on the platform, writable, vat. |
||
vat_id |
int64 |
VAT ID | filters on the platform, writable, vat.id |
||
vat_ |
decimal |
VAT Percentage | filters on the platform, writable, vat. |
||
vat_ |
varchar2 |
VAT Type | filters on the platform, writable, vat. |
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