invantive documentation
Invantive Support ForumsLog In / Sign Up

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_to varchar2 Belongs to filters on the platform, writable, belongs_to the tablename of the proposal line the accrual belongs to
booking_date varchar2 Booking Date filters on the platform, writable, booking_date An ISO date string of the date of the booking
cost_center_id decimal Cost Centre ID filters on the platform, writable, cost_center_id The number of the cost center (required if ledger/transitoria account has cost type)
currency_id varchar2 Currency ID filters on the platform, writable, currency_id the currency of the accrual
debet_credit varchar2 Debet/Credit filters on the platform, writable, debet_credit A string containing 'debet' or 'credit'
description varchar2 Description filters on the platform, writable, description The main description of the accrual
entry_number decimal Entry Number filters on the platform, writable, entry_number 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_account_id decimal Ledger Account ID filters on the platform, writable, ledger_account_id 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_period decimal Start Period filters on the platform, writable, start_period The number of the starting period (has to be in the range of the number of periods of the administration)
start_year decimal Start Year filters on the platform, writable, start_year The starting year (has to be a fiscal year the administration has)
transaction_line_id varchar2 Transaction Line ID filters on the platform, writable, transaction_line_id Optional field to specify which transaction_line the accrual belongs to (uuid)
transitoria_account_id decimal Transitoria Account ID filters on the platform, writable, transitoria_account_id 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_center_id_fk cost_center_id 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

All changes of the driver, 26.0 to 27.0