# CaseWare_Periodesaldi: Caseware Period Balances ## Documentation CaseWare period balances - Name: `CaseWare_Periodesaldi` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Caseware Period Balances - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/CaseWare_Periodesaldi` - Insert Service URL (OData-specific): `/connectors/CaseWare_Periodesaldi` - Update Service URL (OData-specific): `/connectors/CaseWare_Periodesaldi` - Delete Service URL (OData-specific): `/connectors/CaseWare_Periodesaldi` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `CaseWare_Periodesaldi` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Administratie` | `int32` | Administration | | | | `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 | | | | `Periodenummer` | `int32` | Period Number | | | | `Rekeningtype_code` | `string(20)` | Account type code | | |