---
title: "CashTransactions (Visma.net Financials)"
description: "Cash Transactions"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/vismanet/VismaNet.CashTransaction.CashTransactions
original: https://documentation.invantive.eu/en/datamodels/vismanet/VismaNet.CashTransaction.CashTransactions
updated: 2026-11-01T17:49:50Z
license: https://documentation.invantive.eu/en/
---

# CashTransactions: Visma.net Financials Cash Transactions

`insert` `update` `REST`

- Catalog: `VismaNet`
- Schema: `CashTransaction`
- Primary Keys: `referenceNbr`
- Label: Cash Transactions

Get all Transaction - ScreenID=CA304000
Data for the Cash Transaction

Can retrieve data and change data using `insert` and `update`.

## Summary

Data for the Cash Transaction

## API Source

- Endpoint: `/v1/cashTransaction`
- Operation: `get /v1/cashTransaction`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 155 |
| Full scan rows per minute | 29,100 |
| Point query rows per minute | 387 |

The result can be cached on the client.

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `lastModifiedDateTime` | `` | [ ] |  | This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present.  Accepted format: * ```yyyy-MM-dd``` * ```yyyy-MM-dd HH:mm:ss``` * ```yyyy-MM-dd HH:mm:ss.FFF``` * ```yyyy-MM-ddTHH:mm:ss``` * ```yyyy-MM-ddTHH:mm:ss.FFF```  _Note:_ __LastModifiedDateTime__ and __LastModifiedDateTimeCondition__ are __mutually inclusive__. |
| `lastModifiedDateTimeCondition` | `` | [ ] |  | This value represents the condition to be applied when retrieving records.  Accepted values (without the single quotes): * '&gt;' for greater than * '&lt;' for less than * '&gt;=' for greater than or equal * '&lt;=' for less than or equal  _Note:_ __LastModifiedDateTime__ and __LastModifiedDateTimeCondition__ are __mutually inclusive__. |

## Table Columns

The columns of the table `CashTransactions` 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 | Marks | Documentation |
|---|---|---|:---:|---|---|
| `COMPANY_CODE` | `varchar2(30)` | Company Code | [x] | writable | Partition code, segmenting the data. |
| `COMPANY_NAME` | `varchar2(240)` | Company Name | [x] | writable | Name of the partition. |
| `amount` | `double` | Amount | [ ] | filters on the platform, writable, `amount` | The top part &gt; Amount &gt; The amount of the transaction. |
| `cashAccount_description` | `varchar2` | Cash Account Description | [ ] | filters on the platform, writable, `cashAccount.description` | Name of item/description |
| `cashAccount_number` | `varchar2` | Cash Account Number | [ ] | filters on the platform, writable, `cashAccount.number` | Number of item |
| `cashAccount_type` | `varchar2` | Cash Account Type | [ ] | filters on the platform, writable, `cashAccount.type` |  |
| `controlTotal` | `double` | Total for Control | [ ] | filters on the platform, writable, `controlTotal` | Mandatory field: The top part &gt; Control total &gt; The control total of the transaction. |
| `currency` | `varchar2` | Currency | [ ] | filters on the platform, writable, `currency` | The top part &gt; Currency &gt; The currency of the cash account. |
| `description` | `varchar2` | Description | [ ] | filters on the platform, writable, `description` | The top part &gt; Description &gt; A detailed description of the transaction. |
| `disbReceipt` | `varchar2` | itgen_vnet_disbreceipt | [ ] | filters on the platform, writable, `disbReceipt` | The top part &gt; Disb./receipt &gt; The basic type of the transaction. |
| `documentRef` | `varchar2` | Document Reference | [ ] | filters on the platform, writable, `documentRef` | The top part &gt; Document ref. &gt; The external document reference number. |
| `entryType_description` | `varchar2` | Entry Type Description | [ ] | filters on the platform, writable, `entryType.description` | Click on the magnifier. &gt; The description. |
| `entryType_id` | `varchar2` | Entry Type ID | [ ] | filters on the platform, writable, `entryType.id` | Click on the magnifier. &gt; The identifier. |
| `finPeriod` | `varchar2` | Financial Period | [ ] | filters on the platform, writable, `finPeriod` | The property is now considered obsolete. Use Financial Period instead |
| `financialPeriod` | `varchar2` | Financial Period | [ ] | filters on the platform, writable, `financialPeriod` | Mandatory field: The top part &gt; Period* &gt; The financial period to which the transaction should be posted. |
| `financialsDetail_batchNumber` | `varchar2` | Financials Detail Batch Number | [ ] | filters on the platform, writable, `financialsDetail.batchNumber` | Link to general ledger section &gt; Batch number &gt; The number of the batch generated to implement the cash transaction. |
| `financialsDetail_branch_name` | `varchar2` | Branch Name | [ ] | filters on the platform, writable, `financialsDetail.branch.name` | Click the magnifier. &gt; The name. |
| `financialsDetail_branch_number` | `varchar2` | Branch Number | [ ] | filters on the platform, writable, `financialsDetail.branch.number` | Click the magnifier. &gt; The identifier. |
| `financialsDetail_clearDate` | `datetime` | Clear Date | [ ] | filters on the platform, writable, `financialsDetail.clearDate` | Link to general ledger section &gt; Clear date &gt; 	The date when the transaction was cleared. |
| `financialsDetail_cleared` | `char` | Cleared? | [ ] | filters on the platform, writable, `financialsDetail.cleared` | Link to general ledger section &gt; Cleared &gt; A check box that indicates (if selected) that the transaction was cleared. |
| `financialsDetail_taxCalcMode` | `varchar2` | Tax Calculation Mode | [ ] | filters on the platform, writable, `financialsDetail.taxCalcMode` | VAT settings section &gt; VAT calculation &gt; The VAT calculation mode, which defines which amounts (VAT-inclusive or VAT-exclusive) should be entered in the detail lines of a document. |
| `financialsDetail_taxZone_defaultTaxCategory_description` | `varchar2` | Tax Zone Default Tax Category Description | [ ] | filters on the platform, writable, `financialsDetail.taxZone.defaultTaxCategory.description` | Name of item/description |
| `financialsDetail_taxZone_defaultTaxCategory_number` | `varchar2` | Tax Zone Default Tax Category Number | [ ] | filters on the platform, writable, `financialsDetail.taxZone.defaultTaxCategory.number` | Number of item |
| `financialsDetail_taxZone_defaultVatCategory` | `varchar2` | Tax Zone Default VAT Category | [ ] | filters on the platform, writable, `financialsDetail.taxZone.defaultVatCategory` | Click the magnifier. The Default VAT category for the VAT zone of the supplier, which is specified in the  AP303000 window. |
| `financialsDetail_taxZone_description` | `varchar2` | Tax Zone Description | [ ] | filters on the platform, writable, `financialsDetail.taxZone.description` | Click the magnifier. The description for the VAT zone of the supplier, which is specified in the  AP303000 window. |
| `financialsDetail_taxZone_errorInfo` | `varchar2` | itgen_vnet_financialsdetail_taxzone_errorinfo | [ ] | filters on the platform, writable, `financialsDetail.taxZone.errorInfo` |  |
| `financialsDetail_taxZone_id` | `varchar2` | Tax Zone ID | [ ] | filters on the platform, writable, `financialsDetail.taxZone.id` | Click the magnifier. The identifier for the VAT zone of the supplier, which is specified in the  AP303000 window. |
| `financialsDetail_taxZone_metadata_maxPageSize` | `int64` | itgen_vnet_financialsdetail_taxzone_metadata_maxpagesize | [ ] | filters on the platform, writable, `financialsDetail.taxZone.metadata.maxPageSize` |  |
| `financialsDetail_taxZone_metadata_totalCount` | `int64` | itgen_vnet_financialsdetail_taxzone_metadata_totalcount | [ ] | filters on the platform, writable, `financialsDetail.taxZone.metadata.totalCount` |  |
| `hold` | `char` | Hold | [ ] | filters on the platform, writable, `hold` | The top part &gt; Hold &gt; A check box that, if selected, indicates that the transaction is on hold, which means it may be edited but cannot be released. |
| `lastModifiedDateTime` | `datetime` | Last Modified | [ ] | filters on the platform, writable, `lastModifiedDateTime` | System generated information. |
| `owner_internalId` | `varchar2` | Owner Internal ID | [ ] | filters on the platform, writable, `owner.internalId` |  |
| `owner_name` | `varchar2` | Owner Name | [ ] | filters on the platform, writable, `owner.name` | The name of the particular destination of the selected type. |
| `owner_number` | `varchar2` | Owner Number | [ ] | filters on the platform, writable, `owner.number` | The identifier of the particular destination of the selected type. |
| `referenceNbr` | `varchar2` | Reference Number | [ ] | filters on the platform, writable, `referenceNbr` | The top part &gt; Ref. no. &gt; The unique identifier assigned to the cash transaction in accordance with the numbering sequence. |
| `status` | `varchar2` | Status | [ ] | filters on the platform, writable, `status` | The top part &gt; Status &gt; The status of the transaction, which is automatically assigned by the system. |
| `taxAmount` | `double` | Tax Amount | [ ] | filters on the platform, writable, `taxAmount` | The top part &gt; VAT amount &gt; The VAT amount to be paid for the document. A user enters this amount manually. |
| `taxTotal` | `double` | Tax Total | [ ] | filters on the platform, writable, `taxTotal` | The top part &gt; VAT total &gt; The total amount of tax paid in the document. |
| `timeStamp` | `blob` | Timestamp | [ ] | filters on the platform, writable, `timeStamp` | Identifier that represents a specific version of the resource. It helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers) |
| `tranDate` | `datetime` | Transaction Date | [ ] | filters on the platform, writable, `tranDate` | Mandatory field: The top part &gt; Trans. date* &gt; The date of the transaction. |
| `tranType` | `varchar2` | Transaction Type | [ ] | filters on the platform, writable, `tranType` | The top part &gt; Trans type &gt; 	The type of cash transaction. |
| `vatExemptTotal` | `double` | VAT Exempt Total | [ ] | filters on the platform, writable, `vatExemptTotal` | The top part &gt; VAT exempt total &gt;  The document total that is exempt from VAT. |
| `vatTaxableTotal` | `double` | VAT Taxable Total | [ ] | filters on the platform, writable, `vatTaxableTotal` | The top part &gt; VAT taxable total &gt; The document total that is subjected to VAT. |

## Keys

| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
| `CashTransactions_cashAccount_number_fk` | `cashAccount_number` | [Accounts](VismaNet.Account.Accounts)`.accountCD` | Key |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Visma.net Financials](/en/release-notes/drivers?driver=visma-net-financials)

