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

# CashTransactionByReferenceNumber: Visma.net Financials Cash Transaction by Reference Number

`read only` `REST`

- Catalog: `VismaNet`
- Schema: `CashTransaction`
- Label: Cash Transaction by Reference Number

Get a specific Transaction - ScreenID=CA304000
Data for the Cash Transaction 
           The response headers include an ETag after a successful GET operation.

Can only retrieve data.

## Summary

Data for the Cash Transaction <br></br>
           The response headers include an ETag after a successful GET operation.

## API Source

- Endpoint: `/v1/cashTransaction/{referenceNbr}`
- Operation: `get /v1/cashTransaction/{referenceNbr}`

## 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 |
|---|---|:---:|---|---|
| `referenceNbr` | `` | [x] |  | Returns data for the selected Cash transaction |

## Table Columns

The columns of the table `CashTransactionByReferenceNumber` 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. |



## 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)

