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_ |
int64 |
Aggregation Level | filters on the platform, writable, aggregation_ |
||
description |
varchar2 |
Description | filters on the platform, writable, description |
||
id |
int64 |
ID | filters on the platform, writable, id |
||
is_ |
char |
Is Balance | filters on the platform, writable, is_ |
Indicates this is a balance code (more than 99 and less than 300). Used on various balance related reports. | |
is_ |
char |
Is Balance Group | filters on the platform, writable, is_ |
Indicates this is a group of balance codes (dividable by ten, more than 99 and less than 300) | |
is_ |
char |
Is Profit/Loss | filters on the platform, writable, is_ |
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