# ProfitLossBalances: Minox 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. ## Documentation 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. - Catalog: `Minox` - Schema: `MasterDataProfitLossBalance` - Label: Profit/Loss and Balances The data in this table is partitioned per value of the `administration_code` column. This is a read-only table. The Minox API may not support changing the data or the Invantive UniversalSQL driver for Minox does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Minox API. ## Table Columns The columns of the table `ProfitLossBalances` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `aggregation_level` | `int64` | Aggregation Level | ☐ | | | `description` | `varchar2` | Description | ☐ | | | `id` | `int64` | ID | ☐ | | | `is_balance_group` | `char` | Is Balance Group | ☐ | Indicates this is a group of balance codes (dividable by ten, more than 99 and less than 300) | | `is_balance` | `char` | Is Balance | ☐ | Indicates this is a balance code (more than 99 and less than 300). Used on various balance related reports. | | `is_profit_loss` | `char` | 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 | ☐ | This is only available on balance group |