# CaseWare_LedgerBalances: Balances (CaseWare) ## Documentation CaseWare ledger balances incl. opening balance - Name: `CaseWare_LedgerBalances` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Balances (CaseWare) - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/CaseWare_LedgerBalances` - Insert Service URL (OData-specific): `/connectors/CaseWare_LedgerBalances` - Update Service URL (OData-specific): `/connectors/CaseWare_LedgerBalances` - Delete Service URL (OData-specific): `/connectors/CaseWare_LedgerBalances` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `CaseWare_LedgerBalances` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Administratie` | `int32` | Administration | | | | `Beginbalans` | `decimal` | Amount | | | | `Budget` | `decimal` | Period credit balance | | | | `Credit_periodesaldo` | `decimal` | Period credit balance | | | | `D_C_boeking_code` | `string(20)` | D/C entry code | | | | `Debet_periodesaldo` | `decimal` | Period debit balance | | | | `Grootboekrekeningnummer` | `string(16)` | General ledger account number | | | | `Jaar` | `int32` | Year | | | | `Omschrijving` | `string(50)` | Description | | | | `Rekeningtype_code` | `string(20)` | Account type code | | | | `Saldo` | `decimal` | Period credit balance | | |