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

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

`read only` `REST`

- Catalog: `VismaNet`
- Schema: `CashTransaction`
- Label: Cash Transaction Tax 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 `CashTransactionTaxDetailsByReferenceNumber` 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, `::ancestor.amount` | The top part &gt; Amount &gt; The amount of the transaction. |
| `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. |
| `deductibleTaxRate` | `double` | itgen_vnet_deductibletaxrate | [ ] | writable, `deductibleTaxRate` | Deductible VAT rate &gt; The percent of deduction that applies to the VAT amount paid to the supplier for specific purchases. |
| `description` | `varchar2` | Description | [ ] | 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. |
| `expenseAmount` | `double` | itgen_vnet_expenseamount | [ ] | writable, `expenseAmount` | Expense amount &gt; The percentage that is deducted from the VAT amount paid to the supplier for specific purchases. |
| `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. |
| `includeInVatExemptTotal` | `char` | itgen_vnet_includeinvatexempttotal | [ ] | writable, `includeInVatExemptTotal` | Include in VAT exempt total &gt; A check box that indicates (if selected) that this value-added VAT has a zero rate and is used to calculate a document subtotal that is actually exempt from VAT. |
| `lastModifiedDateTime` | `datetime` | Last Modified | [ ] | filters on the platform, writable, `::ancestor.lastModifiedDateTime` | System generated information. |
| `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. |
| `pendingVat` | `char` | itgen_vnet_pendingvat | [ ] | writable, `pendingVat` | Pending VAT &gt; A check box that indicates (if selected) that the VAT that should be calculated in documents, but should not be recorded to the VAT report until the VAT invoice is received. |
| `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. |
| `reverseVat` | `char` | Reverse VAT | [ ] | writable, `reverseVat` | Reverse VAT &gt; A check box that indicates (if selected) that this is a reverse VAT. |
| `statisticalVat` | `char` | Statistical VAT | [ ] | writable, `statisticalVat` | Statistical VAT &gt; A check box that indicates (if selected) that the VAT on documents will be calculated only for statistical purposes or will be reported only but not actually paid. |
| `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 | [ ] | writable, `taxAmount` | VAT amount &gt; The VAT amount calculated for the transaction. |
| `taxAmount_2` | `double` | itgen_vnet_taxamount_2 | [ ] | 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. |
| `taxRate` | `double` | Tax Rate | [ ] | writable, `taxRate` | VAT rate &gt; The rate of the VAT. |
| `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. |
| `taxType` | `varchar2` | Tax Type | [ ] | writable, `taxType` | VAT type &gt; The type of VAT. |
| `tax_description` | `varchar2` | Tax Description | [ ] | writable, `tax.description` | Name of item/description |
| `tax_number` | `varchar2` | Tax Number | [ ] | writable, `tax.number` | Number of item |
| `taxableAmount` | `double` | Taxable Amount | [ ] | writable, `taxableAmount` | Taxable amount &gt; The taxable amount of the transaction. |
| `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. |
| `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)

