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

# CashTransactionDetailsByReferenceNumber: Visma.net Financials Cash Transaction Details by Reference Number

`read only` `REST`

- Catalog: `VismaNet`
- Schema: `CashTransaction`
- Label: Cash Transaction Details 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 `CashTransactionDetailsByReferenceNumber` 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 | [ ] | writable, `amount` | Amount &gt; The total amount for all units or items. |
| `amount_2` | `double` | itgen_vnet_amount_2 | [ ] | filters on the platform, writable, `::ancestor.amount` | The top part &gt; Amount &gt; The amount of the transaction. |
| `branch_name` | `varchar2` | Branch Name | [ ] | writable, `branch.name` | Click the magnifier. &gt; The name. |
| `branch_number` | `varchar2` | Branch Number | [ ] | writable, `branch.number` | Click the magnifier. &gt; The identifier. |
| `cashAccount_description` | `varchar2` | Cash Account Description | [ ] | filters on the platform, writable, `::ancestor.cashAccount.description` | Name of item/description |
| `cashAccount_number` | `varchar2` | Cash Account Number | [ ] | filters on the platform, writable, `::ancestor.cashAccount.number` | Number of item |
| `cashAccount_type` | `varchar2` | Cash Account Type | [ ] | filters on the platform, writable, `::ancestor.cashAccount.type` |  |
| `controlTotal` | `double` | Total for Control | [ ] | filters on the platform, writable, `::ancestor.controlTotal` | Mandatory field: The top part &gt; Control total &gt; The control total of the transaction. |
| `currency` | `varchar2` | Currency | [ ] | filters on the platform, writable, `::ancestor.currency` | The top part &gt; Currency &gt; The currency of the cash account. |
| `description` | `varchar2` | Description | [ ] | writable, `description` | Description &gt; The description provided for the item. |
| `description_2` | `varchar2` | Description 2 | [ ] | filters on the platform, writable, `::ancestor.description` | The top part &gt; Description &gt; A detailed description of the transaction. |
| `disbReceipt` | `varchar2` | itgen_vnet_disbreceipt | [ ] | filters on the platform, writable, `::ancestor.disbReceipt` | The top part &gt; Disb./receipt &gt; The basic type of the transaction. |
| `documentRef` | `varchar2` | Document Reference | [ ] | filters on the platform, writable, `::ancestor.documentRef` | The top part &gt; Document ref. &gt; The external document reference number. |
| `entryType_description` | `varchar2` | Entry Type Description | [ ] | filters on the platform, writable, `::ancestor.entryType.description` | Click on the magnifier. &gt; The description. |
| `entryType_id` | `varchar2` | Entry Type ID | [ ] | filters on the platform, writable, `::ancestor.entryType.id` | Click on the magnifier. &gt; The identifier. |
| `finPeriod` | `varchar2` | Financial Period | [ ] | filters on the platform, writable, `::ancestor.finPeriod` | The property is now considered obsolete. Use Financial Period instead |
| `financialPeriod` | `varchar2` | Financial Period | [ ] | filters on the platform, writable, `::ancestor.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, `::ancestor.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, `::ancestor.financialsDetail.branch.name` | Click the magnifier. &gt; The name. |
| `financialsDetail_branch_number` | `varchar2` | Branch Number | [ ] | filters on the platform, writable, `::ancestor.financialsDetail.branch.number` | Click the magnifier. &gt; The identifier. |
| `financialsDetail_clearDate` | `datetime` | Clear Date | [ ] | filters on the platform, writable, `::ancestor.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, `::ancestor.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, `::ancestor.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, `::ancestor.financialsDetail.taxZone.defaultTaxCategory.description` | Name of item/description |
| `financialsDetail_taxZone_defaultTaxCategory_number` | `varchar2` | Tax Zone Default Tax Category Number | [ ] | filters on the platform, writable, `::ancestor.financialsDetail.taxZone.defaultTaxCategory.number` | Number of item |
| `financialsDetail_taxZone_defaultVatCategory` | `varchar2` | Tax Zone Default VAT Category | [ ] | filters on the platform, writable, `::ancestor.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, `::ancestor.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, `::ancestor.financialsDetail.taxZone.errorInfo` |  |
| `financialsDetail_taxZone_id` | `varchar2` | Tax Zone ID | [ ] | filters on the platform, writable, `::ancestor.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, `::ancestor.financialsDetail.taxZone.metadata.maxPageSize` |  |
| `financialsDetail_taxZone_metadata_totalCount` | `int64` | itgen_vnet_financialsdetail_taxzone_metadata_totalcount | [ ] | filters on the platform, writable, `::ancestor.financialsDetail.taxZone.metadata.totalCount` |  |
| `hold` | `char` | Hold | [ ] | filters on the platform, writable, `::ancestor.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. |
| `item_description` | `varchar2` | itgen_vnet_item_description | [ ] | writable, `item.description` | Name of item/description |
| `item_number` | `varchar2` | itgen_vnet_item_number | [ ] | writable, `item.number` | Number of item |
| `lastModifiedDateTime` | `datetime` | Last Modified | [ ] | filters on the platform, writable, `::ancestor.lastModifiedDateTime` | System generated information. |
| `lineNumber` | `int32` | Line Number | [ ] | writable, `lineNumber` | The line number in the table. |
| `nonBillable` | `char` | itgen_vnet_nonbillable | [ ] | writable, `nonBillable` | Non-invoiceable &gt; A check box that indicates (if selected) that this transaction is non-invoiceable in the project. |
| `offsetAccount_description` | `varchar2` | itgen_vnet_offsetaccount_description | [ ] | writable, `offsetAccount.description` | Name of item/description |
| `offsetAccount_number` | `varchar2` | itgen_vnet_offsetaccount_number | [ ] | writable, `offsetAccount.number` | Number of item |
| `offsetAccount_type` | `varchar2` | itgen_vnet_offsetaccount_type | [ ] | writable, `offsetAccount.type` |  |
| `offsetCashAccount_description` | `varchar2` | itgen_vnet_offsetcashaccount_description | [ ] | writable, `offsetCashAccount.description` | Name of item/description |
| `offsetCashAccount_number` | `varchar2` | itgen_vnet_offsetcashaccount_number | [ ] | writable, `offsetCashAccount.number` | Number of item |
| `offsetCashAccount_type` | `varchar2` | itgen_vnet_offsetcashaccount_type | [ ] | writable, `offsetCashAccount.type` |  |
| `offsetSubAccount_active` | `char` | itgen_vnet_offsetsubaccount_active | [ ] | writable, `offsetSubAccount.active` | Active &gt; The status of the identifier. |
| `offsetSubAccount_description` | `varchar2` | itgen_vnet_offsetsubaccount_description | [ ] | writable, `offsetSubAccount.description` | Description &gt; The description of the identifier. |
| `offsetSubAccount_errorInfo` | `varchar2` | itgen_vnet_offsetsubaccount_errorinfo | [ ] | writable, `offsetSubAccount.errorInfo` |  |
| `offsetSubAccount_lastModifiedDateTime` | `datetime` | itgen_vnet_offsetsubaccount_lastmodifieddatetime | [ ] | writable, `offsetSubAccount.lastModifiedDateTime` | System generated information. |
| `offsetSubAccount_metadata_maxPageSize` | `int64` | itgen_vnet_offsetsubaccount_metadata_maxpagesize | [ ] | writable, `offsetSubAccount.metadata.maxPageSize` |  |
| `offsetSubAccount_metadata_totalCount` | `int64` | itgen_vnet_offsetsubaccount_metadata_totalcount | [ ] | writable, `offsetSubAccount.metadata.totalCount` |  |
| `offsetSubAccount_subaccountId` | `int32` | itgen_vnet_offsetsubaccount_subaccountid | [ ] | writable, `offsetSubAccount.subaccountId` | SubID &gt; The  identifier of the subaccount. |
| `offsetSubAccount_subaccountNumber` | `varchar2` | itgen_vnet_offsetsubaccount_subaccountnumber | [ ] | writable, `offsetSubAccount.subaccountNumber` | Mandatory field: Subaccount* &gt; The subaccount number. Format 9-XX. |
| `offsetSubAccount_timeStamp` | `blob` | itgen_vnet_offsetsubaccount_timestamp | [ ] | writable, `offsetSubAccount.timeStamp` | The timestamp of the subaccount, used for concurrency control. |
| `owner_internalId` | `varchar2` | Owner Internal ID | [ ] | filters on the platform, writable, `::ancestor.owner.internalId` |  |
| `owner_name` | `varchar2` | Owner Name | [ ] | filters on the platform, writable, `::ancestor.owner.name` | The name of the particular destination of the selected type. |
| `owner_number` | `varchar2` | Owner Number | [ ] | filters on the platform, writable, `::ancestor.owner.number` | The identifier of the particular destination of the selected type. |
| `price` | `double` | Price | [ ] | writable, `price` | Price &gt; The unit price for the item. |
| `projectTask_description` | `varchar2` | Project Task Description | [ ] | writable, `projectTask.description` | Click on the magnifier. &gt; The description. |
| `projectTask_id` | `varchar2` | Project Task ID | [ ] | writable, `projectTask.id` | Click on the magnifier. &gt; The identifier. |
| `projectTask_internalId` | `int32` | itgen_vnet_projecttask_internalid | [ ] | writable, `projectTask.internalId` | The internal identifier. |
| `project_description` | `varchar2` | Project Description | [ ] | writable, `project.description` | Click on the magnifier. &gt; The description. |
| `project_id` | `varchar2` | Project ID | [ ] | writable, `project.id` | Click on the magnifier. &gt; The identifier. |
| `project_internalId` | `int32` | itgen_vnet_project_internalid | [ ] | writable, `project.internalId` | The internal identifier. |
| `quantity` | `double` | Quantity | [ ] | writable, `quantity` | Quantity &gt; The quantity of the item. |
| `referenceNbr` | `varchar2` | Reference Number | [ ] | filters on the platform, writable, `::ancestor.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, `::ancestor.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, `::ancestor.taxAmount` | The top part &gt; VAT amount &gt; The VAT amount to be paid for the document. A user enters this amount manually. |
| `taxCategory_description` | `varchar2` | itgen_vnet_taxcategory_description | [ ] | writable, `taxCategory.description` | Name of item/description |
| `taxCategory_number` | `varchar2` | itgen_vnet_taxcategory_number | [ ] | writable, `taxCategory.number` | Number of item |
| `taxTotal` | `double` | Tax Total | [ ] | filters on the platform, writable, `::ancestor.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, `::ancestor.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, `::ancestor.tranDate` | Mandatory field: The top part &gt; Trans. date* &gt; The date of the transaction. |
| `tranType` | `varchar2` | Transaction Type | [ ] | filters on the platform, writable, `::ancestor.tranType` | The top part &gt; Trans type &gt; 	The type of cash transaction. |
| `uom` | `varchar2` | Unit of Measure | [ ] | writable, `uom` | UoM &gt; The unit of measure of the item. |
| `vatExemptTotal` | `double` | VAT Exempt Total | [ ] | filters on the platform, writable, `::ancestor.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, `::ancestor.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)

