invantive documentation
Invantive Support ForumsLog In / Sign Up

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_to varchar2 Belongs to filters on the platform, writable, ::ancestor.belongs_to the tablename of the proposal line the accrual belongs to
booking_date varchar2 Booking Date filters on the platform, writable, ::ancestor.booking_date An ISO date string of the date of the booking
cost_center_id decimal Cost Centre ID filters on the platform, writable, ::ancestor.cost_center_id The number of the cost center (required if ledger/transitoria account has cost type)
credit decimal Credit writable, credit
currency_id varchar2 Currency ID filters on the platform, writable, ::ancestor.currency_id the currency of the accrual
date varchar2 Date writable, date The ISO date of the booking
debet decimal Debet writable, debet
debet_credit varchar2 Debet/Credit filters on the platform, writable, ::ancestor.debet_credit A string containing 'debet' or 'credit'
description varchar2 Description filters on the platform, writable, ::ancestor.description The main description of the accrual
difference decimal Difference writable, difference The difference of the proposed amount and the actual booked amount
entry_number decimal Entry Number filters on the platform, writable, ::ancestor.entry_number The entry number for the bookings
explanation varchar2 Explanation filters on the platform, writable, ::ancestor.explanation 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.id The identifier of the accrual (uuid)
ledger_account_id decimal Ledger Account ID writable, ledger_account_id
ledger_account_id_2 decimal itgen_minox_ledger_account_id_2 filters on the platform, writable, ::ancestor.ledger_account_id The number of the expenses/sales account
periods decimal Periods filters on the platform, writable, ::ancestor.periods In how many periods the total amount will be divided and booked
start_period decimal Start Period filters on the platform, writable, ::ancestor.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, ::ancestor.start_year 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_line_id varchar2 Transaction Line ID filters on the platform, writable, ::ancestor.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, ::ancestor.transitoria_account_id The number of the accrual account
value decimal Value filters on the platform, writable, ::ancestor.value The total amount of the accrual

Keys

Key Column Refers to Kind Description
ProposalAccruals_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