Accruals: Minox Accruals
read only per partition REST
- Catalog:
Minox - Schema:
FinancialAccruals - Label: Accruals
Retrieve the accruals. Retrieve the accruals.
The data in this table is partitioned per value of the administration_code column.
Can only retrieve data.
Summary
Retrieve the accruals.
API Source
- Endpoint:
/tenant/{tenant_id}/administration/{administration_id}/accrual - Operation:
get /tenant/{tenant_id}/administration/{administration_id}/accrual
Table Columns
The columns of the table Accruals 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 |
|---|---|---|---|---|---|
belongs_ |
varchar2 |
Belongs to | filters on the platform, writable, belongs_ |
the tablename of the proposal line the accrual belongs to | |
booking_ |
varchar2 |
Booking Date | filters on the platform, writable, booking_ |
An ISO date string of the date of the booking | |
cost_ |
decimal |
Cost Centre ID | filters on the platform, writable, cost_ |
The number of the cost center (required if ledger/transitoria account has cost type) | |
currency_ |
varchar2 |
Currency ID | filters on the platform, writable, currency_ |
the currency of the accrual | |
debet_ |
varchar2 |
Debet/Credit | filters on the platform, writable, debet_ |
A string containing 'debet' or 'credit' | |
description |
varchar2 |
Description | filters on the platform, writable, description |
The main description of the accrual | |
entry_ |
decimal |
Entry Number | filters on the platform, writable, entry_ |
The entry number for the bookings | |
explanation |
varchar2 |
Explanation | filters on the platform, writable, explanation |
Extra space for an explanation of the accrual | |
id |
varchar2 |
ID | filters on the platform, writable, id |
The identifier of the accrual (uuid) | |
ledger_ |
decimal |
Ledger Account ID | filters on the platform, writable, ledger_ |
The number of the expenses/sales account | |
periods |
decimal |
Periods | filters on the platform, writable, periods |
In how many periods the total amount will be divided and booked | |
start_ |
decimal |
Start Period | filters on the platform, writable, start_ |
The number of the starting period (has to be in the range of the number of periods of the administration) | |
start_ |
decimal |
Start Year | filters on the platform, writable, start_ |
The starting year (has to be a fiscal year the administration has) | |
transaction_ |
varchar2 |
Transaction Line ID | filters on the platform, writable, transaction_ |
Optional field to specify which transaction_line the accrual belongs to (uuid) | |
transitoria_ |
decimal |
Transitoria Account ID | filters on the platform, writable, transitoria_ |
The number of the accrual account | |
value |
decimal |
Value | filters on the platform, writable, value |
The total amount of the accrual |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Accruals_ |
cost_ |
CostCenters.id |
Key |
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