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_ |
`` | Filter on a specific account id. | ||
administration_ |
`` | Partition to retrieve data from. | ||
fiscal_ |
`` | The fiscal year of the administration to which you want to connect. | ||
invoice_ |
`` | 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_ |
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