ProposalAccruals: Minox Proposal Accruals
read only per partition REST
- Catalog:
Minox - Schema:
FinancialAccruals - Label: Proposal 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 ProposalAccruals 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, ::ancestor. |
the tablename of the proposal line the accrual belongs to | |
booking_ |
varchar2 |
Booking Date | filters on the platform, writable, ::ancestor. |
An ISO date string of the date of the booking | |
cost_ |
decimal |
Cost Centre ID | filters on the platform, writable, ::ancestor. |
The number of the cost center (required if ledger/transitoria account has cost type) | |
credit |
decimal |
Credit | writable, credit |
||
currency_ |
varchar2 |
Currency ID | filters on the platform, writable, ::ancestor. |
the currency of the accrual | |
date |
varchar2 |
Date | writable, date |
The ISO date of the booking | |
debet |
decimal |
Debet | writable, debet |
||
debet_ |
varchar2 |
Debet/Credit | filters on the platform, writable, ::ancestor. |
A string containing 'debet' or 'credit' | |
description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
The main description of the accrual | |
difference |
decimal |
Difference | writable, difference |
The difference of the proposed amount and the actual booked amount | |
entry_ |
decimal |
Entry Number | filters on the platform, writable, ::ancestor. |
The entry number for the bookings | |
explanation |
varchar2 |
Explanation | filters on the platform, writable, ::ancestor. |
Extra space for an explanation of the accrual | |
id |
varchar2 |
ID | writable, id |
||
id_2 |
varchar2 |
itgen_minox_id_2 | filters on the platform, writable, ::ancestor. |
The identifier of the accrual (uuid) | |
ledger_ |
decimal |
Ledger Account ID | writable, ledger_ |
||
ledger_ |
decimal |
itgen_minox_ledger_account_id_2 | filters on the platform, writable, ::ancestor. |
The number of the expenses/sales account | |
periods |
decimal |
Periods | filters on the platform, writable, ::ancestor. |
In how many periods the total amount will be divided and booked | |
start_ |
decimal |
Start Period | filters on the platform, writable, ::ancestor. |
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, ::ancestor. |
The starting year (has to be a fiscal year the administration has) | |
status |
varchar2 |
Status | writable, status |
The status of the booking (pending/booked/deleted) | |
transaction_ |
varchar2 |
Transaction Line ID | filters on the platform, writable, ::ancestor. |
Optional field to specify which transaction_line the accrual belongs to (uuid) | |
transitoria_ |
decimal |
Transitoria Account ID | filters on the platform, writable, ::ancestor. |
The number of the accrual account | |
value |
decimal |
Value | filters on the platform, writable, ::ancestor. |
The total amount of the accrual |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Proposal |
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