# ReportingBalance: Exact Online Reporting Balance - Catalog: `ExactOnlineREST` - Schema: `Financial` - Primary Keys: `ID` - Label: Reporting Balance The data in this table is partitioned per value of the `Division` column. Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `ReportingBalance` 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 | Documentation | |---|:---:|---|:---:|---| | `Amount` | `double` | Amount | ☐ | The sum of the amounts of all transactions in the grouping. | | `AmountCredit` | `double` | Amount Credit | ☐ | The sum of the amounts of all credit transactions in the grouping. | | `AmountDebit` | `double` | Amount Debit | ☐ | The sum of the amounts of all debit transactions in the grouping. | | `BalanceType` | `varchar2`(1) | Balance Type | ☐ | Balance type of the G/L account: B = Balance Sheet, W = Profit & Loss. | | `CostCenterCode` | `varchar2`(8) | Cost Centre Code | ☐ | The code of the cost center. | | `CostCenterDescription` | `varchar2`(60) | Cost Centre Description | ☐ | The description of the cost center. | | `CostUnitCode` | `varchar2`(8) | Cost Unit Code | ☐ | The code of the cost unit. | | `CostUnitDescription` | `varchar2`(60) | Cost Unit Description | ☐ | The description of the cost unit. | | `Count` | `int32` | Count | ☐ | The number of transactions in the grouping. | | `Division` | `int32` | Division | ☐ | Division code. | | `DivisionCompanyCoCNumber` | `varchar2`(60) | Division Chamber of Commerce Number | ☐ | Chamber of commerce number of the Exact Online division. | | `DivisionCompanyIBANNumber` | `varchar2`(50) | Division IBAN Number | ☐ | IBAN number of the Exact Online division. | | `DivisionCompanyName` | `varchar2`(50) | Division Company Name | ☑ | Company name of the Exact Online division. | | `DivisionCompanyRSINNumber` | `varchar2`(9) | Division RSIN Number | ☐ | RSIN number of the Exact Online division. | | `DivisionCompanyVATNumber` | `varchar2`(35) | Division VAT Number | ☐ | VAT number of the Exact Online division. | | `DivisionCompanyWageTaxNumber` | `varchar2`(60) | Division Wage Tax Number | ☐ | Wage tax number of the Exact Online division. | | `DivisionLabel` | `varchar2`(128) | Division Label | ☑ | Label of the Exact Online division. | | `DivisionName` | `varchar2`(50) | Administration Name | ☑ | Name of the Exact Online division. | | `DivisionOwnerCompanyName` | `varchar2`(50) | Subscription Holder Name | ☑ | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionOwnerCompanyNumber` | `varchar2`(18) | Subscription Holder Number | ☑ | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionShortName` | `int64` | Division Short Name | ☑ | Short name of the Exact Online division. | | `GLAccount` | `guid` | General Ledger Account | ☐ | G/L account. | | `GLAccountCode` | `varchar2`(30) | GL Account Code | ☐ | Code of the G/L account. | | `GLAccountDescription` | `varchar2`(60) | GL Account Description | ☐ | Description of the G/L account. | | `ID` | `int64` | ID | ☑ | Record ID. | | `ReportingPeriod` | `int32` | Reporting Period | ☐ | The reporting period of the transactions in the grouping. | | `ReportingYear` | `int32` | Reporting Year | ☐ | The reporting year of the transactions in the grouping. | | `Status` | `int32` | Status | ☐ | Status: 20 = Open, 50 = Processed. To get 'after entry' results, both Open and Processed amounts have to be included. This is by default, so it requires no extra filtering. | | `Type` | `int32` | Type | ☐ | The type of the transactions in the grouping. |