invantive documentation
Invantive Support ForumsLog In / Sign Up

ProfitLossBalances: Minox Profit/Loss and Balances

read only per partition REST

  • Catalog: Minox
  • Schema: MasterDataProfitLossBalance
  • Label: Profit/Loss and Balances

Retrieves a list of profit/loss/balance codes. Profit and loss codes are used on the matching report and determine in which category a ledger_account should put its losses or profits. In the case of a profit/loss report, the ID field should be higher or equal to 1 and less then 100. All other codes, 0 or 100-299 are reserved for the balance report where 100, 110 etc are groups under which the next 9 codes fall (so for example 100-109 or 110-119). For these group codes you can specify if they are liabilities or assets.

The data in this table is partitioned per value of the administration_code column.

Can only retrieve data.

Summary

Profit and loss codes are used on the matching report and determine in which category a ledger_account should put its losses or profits. In the case of a profit/loss report, the ID field should be higher or equal to 1 and less then 100. All other codes, 0 or 100-299 are reserved for the balance report where 100, 110 etc are groups under which the next 9 codes fall (so for example 100-109 or 110-119). For these group codes you can specify if they are liabilities or assets.

API Source

  • Endpoint: /tenant/{tenant_id}/administration/{administration_id}/profit_loss_balance
  • Operation: get /tenant/{tenant_id}/administration/{administration_id}/profit_loss_balance

Table Columns

The columns of the table ProfitLossBalances 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
aggregation_level int64 Aggregation Level filters on the platform, writable, aggregation_level
description varchar2 Description filters on the platform, writable, description
id int64 ID filters on the platform, writable, id
is_balance char Is Balance filters on the platform, writable, is_balance Indicates this is a balance code (more than 99 and less than 300). Used on various balance related reports.
is_balance_group char Is Balance Group filters on the platform, writable, is_balance_group Indicates this is a group of balance codes (dividable by ten, more than 99 and less than 300)
is_profit_loss char Is Profit/Loss filters on the platform, writable, is_profit_loss Indicates this is a profit and loss code (ranging from 1 to 99). Used on various profit loss related reports.
type varchar2 Type filters on the platform, writable, type This is only available on balance group

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