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

# CashTransactionDetails: Visma.net Financials Cash Transaction Details

`read only` `REST`

- Catalog: `VismaNet`
- Schema: `CashTransaction`
- Label: Cash Transaction Details

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

Can only retrieve data.

## 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 `CashTransactionDetails` 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. |

## Keys

| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
| `CashTransactionDetails_branch_number_fk` | `branch_number` | [Branches](VismaNet.Branch.Branches)`.number` | Key |  |
| `CashTransactionDetails_cashAccount_number_fk` | `cashAccount_number` | [Accounts](VismaNet.Account.Accounts)`.accountCD` | Key |  |
| `CashTransactionDetails_item_number_fk` | `item_number` | [InventoryItems](VismaNet.Inventory.InventoryItems)`.inventoryNumber` | Key |  |
| `CashTransactionDetails_offsetAccount_number_fk` | `offsetAccount_number` | [Accounts](VismaNet.Account.Accounts)`.accountCD` | Key |  |
| `CashTransactionDetails_offsetCashAccount_number_fk` | `offsetCashAccount_number` | [Accounts](VismaNet.Account.Accounts)`.accountCD` | Key |  |
| `CashTransactionDetails_project_id_txt` | `project_id` | [Projects](VismaNet.Project.Projects)`.projectID` | Textual | The project, or the code for no project when the document is not associated with a project; that code has no row in Projects. |



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

