# CaseWare_Transacties: Transactions (CaseWare) ## Documentation CaseWare transactions - Name: `CaseWare_Transacties` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Transactions (CaseWare) - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/CaseWare_Transacties` - Insert Service URL (OData-specific): `/connectors/CaseWare_Transacties` - Update Service URL (OData-specific): `/connectors/CaseWare_Transacties` - Delete Service URL (OData-specific): `/connectors/CaseWare_Transacties` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `CaseWare_Transacties` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Administratie` | `int32` | Administration | | | | `Bedrag_Credit` | `decimal` | Credit amount | | | | `Bedrag_Debet` | `decimal` | Debit amount | | | | `Boekingsdatum` | `datetime` | Entry date | | | | `Boekstuknummer` | `string(32)` | Document number | | | | `D_C_boeking_code` | `string(20)` | D/C entry code | | | | `Dagboekcode` | `string(6)` | Journal code | | | | `Jaar` | `int32` | Year | | | | `Journaalpostnummer` | `int32` | Journal entry number | | | | `Omschrijving_boeking` | `string(120)` | Entry description | | | | `Omschrijving_dagboek` | `string(50)` | Description | | | | `Omschrijving_rekening` | `string(50)` | Description | | | | `Periode` | `int32` | Period | | | | `Rekeningnummer` | `string(16)` | Account number | | | | `Rekeningtype_code` | `string(20)` | Account type code | | | | `Volgnummer_journaalpost` | `int32` | Journal entry sequence number | | |