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

# ExpenseClaimDetailsByExpenseClaimNumber: Visma.net Financials itgen_vnet_expenseclaimdetailsbyexpenseclaimnumber_plural

`read only` `REST`

- Catalog: `VismaNet`
- Schema: `ExpenseClaim`
- Label: itgen_vnet_expenseclaimdetailsbyexpenseclaimnumber_plural

Get a specific Expense Claim
Data for a single expense claim 
The response headers include an ETag after a successful GET operation.

Can only retrieve data.

## Summary

Data for a single expense claim <br></br>
The response headers include an ETag after a successful GET operation.

## API Source

- Endpoint: `/v1/expenseClaim/{expenseClaimNbr}`
- Operation: `get /v1/expenseClaim/{expenseClaimNbr}`

## 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 |
|---|---|:---:|---|---|
| `expenseClaimNbr` | `` | [x] |  | Identifies the expense claim |

## Table Columns

The columns of the table `ExpenseClaimDetailsByExpenseClaimNumber` 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. |
| `amountInClaimCurr` | `double` | itgen_vnet_amountinclaimcurr | [ ] | writable, `amountInClaimCurr` | Amount in claim currency &gt; The amount claimed by the employee, which is expressed in the currency of the expense claim. |
| `approvalDate` | `datetime` | Approval Date | [ ] | filters on the platform, writable, `::ancestor.approvalDate` | The top part &gt; Approval date &gt; The date when the claim was approved. |
| `approvalStatus` | `varchar2` | Approval Status | [ ] | writable, `approvalStatus` | Approval status &gt; The approval status, which indicates whether the detail row requires approval and, if it does, what the current state of approval is. |
| `approvalStatusText` | `varchar2` | Approval Status Text | [ ] | writable, `approvalStatusText` | Last approval comment &gt; The approval status text suitable for display |
| `approvalStatusText_2` | `varchar2` | Approval Status Text 2 | [ ] | filters on the platform, writable, `::ancestor.approvalStatusText` | The top part &gt; Approval status &gt; A text field. |
| `approvalStatus_2` | `varchar2` | Approval Status 2 | [ ] | filters on the platform, writable, `::ancestor.approvalStatus` | The top part &gt; Approval status &gt; The status of the claim in Approval. |
| `approver` | `varchar2` | Approver | [ ] | writable, `approver` | Pending approver &gt; The identifier of the person authorized to approve the activity, if approval is required. This is either the approver of the project task or, if no approver is assigned to the project task, the project manager. |
| `arReferenceNbr` | `varchar2` | itgen_vnet_arreferencenbr | [ ] | writable, `arReferenceNbr` | REef.no. customer &gt; The reference number of the customer ledger document. |
| `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. |
| `claimAmount` | `double` | Claim Amount | [ ] | writable, `claimAmount` | Claim amount &gt; The amount claimed by the employee, which is calculated as the total claim amount minus the employee part. |
| `claimDetailId` | `int32` | Claim Detail ID | [ ] | writable, `claimDetailId` | Identifies the expense claim detail id, necessary when updating detail information |
| `claimTotal` | `double` | Claim Total | [ ] | filters on the platform, writable, `::ancestor.claimTotal` | The top part &gt; Claim total &gt; The total amount of the claim. |
| `claimedBy_internalId` | `varchar2` | Claimed by - Internal ID | [ ] | filters on the platform, writable, `::ancestor.claimedBy.internalId` |  |
| `claimedBy_name` | `varchar2` | Claimed by - Name | [ ] | filters on the platform, writable, `::ancestor.claimedBy.name` | The name of the particular destination of the selected type. |
| `claimedBy_number` | `varchar2` | Claimed by - Number | [ ] | filters on the platform, writable, `::ancestor.claimedBy.number` | The identifier of the particular destination of the selected type. |
| `currency` | `varchar2` | Currency | [ ] | writable, `currency` | Currency &gt; The currency of the expense receipt. However, if you enter a claim line directly, the currency value is read-only and matching the claim currency. |
| `currency_2` | `varchar2` | itgen_vnet_currency_2 | [ ] | filters on the platform, writable, `::ancestor.currency` | The top part &gt; Currency &gt; The currency of the claim. |
| `customer_name` | `varchar2` | Customer Name | [ ] | writable, `customer.name` | Click the magnifier. &gt; The name. |
| `customer_name_2` | `varchar2` | itgen_vnet_customer_name_2 | [ ] | filters on the platform, writable, `::ancestor.customer.name` | Click the magnifier. &gt; The name. |
| `customer_number` | `varchar2` | Customer Number | [ ] | writable, `customer.number` |  |
| `customer_number_2` | `varchar2` | itgen_vnet_customer_number_2 | [ ] | filters on the platform, writable, `::ancestor.customer.number` |  |
| `date` | `datetime` | Date | [ ] | writable, `date` | Mandatory field: Date &gt; The date when the expense was incurred. |
| `date_2` | `datetime` | itgen_vnet_date_2 | [ ] | filters on the platform, writable, `::ancestor.date` | Mandatory field: The top part &gt; Date* &gt; The date when the claim was entered. |
| `department_description` | `varchar2` | Department Description | [ ] | filters on the platform, writable, `::ancestor.department.description` | Click on the magnifier. &gt; The description. |
| `department_id` | `varchar2` | Department ID | [ ] | filters on the platform, writable, `::ancestor.department.id` | Click on the magnifier. &gt; The identifier. |
| `description` | `varchar2` | Description | [ ] | writable, `description` | Mandatory field: Description* &gt; A description of the transaction. |
| `description_2` | `varchar2` | Description 2 | [ ] | filters on the platform, writable, `::ancestor.description` | Mandatory field: The top part &gt; Description &gt; A description of the claim. |
| `employeePart` | `double` | itgen_vnet_employeepart | [ ] | writable, `employeePart` | Employee part &gt; The part of the total amount that will not be paid back to the employee. The percentage depends on the company policy. |
| `errorInfo` | `varchar2` | Error Message | [ ] | filters on the platform, writable, `::ancestor.errorInfo` |  |
| `expenseAccount_active` | `char` | itgen_vnet_expenseaccount_active | [ ] | writable, `expenseAccount.active` |  |
| `expenseAccount_description` | `varchar2` | Expense Account Description | [ ] | writable, `expenseAccount.description` | Name of item/description |
| `expenseAccount_externalCode1` | `varchar2` | itgen_vnet_expenseaccount_externalcode1 | [ ] | writable, `expenseAccount.externalCode1` | Account class &gt; The identifier of the account class. |
| `expenseAccount_externalCode2` | `varchar2` | itgen_vnet_expenseaccount_externalcode2 | [ ] | writable, `expenseAccount.externalCode2` | Account class &gt; The name of the account class. |
| `expenseAccount_number` | `varchar2` | Expense Account Number | [ ] | writable, `expenseAccount.number` | Number of item |
| `expenseAccount_type` | `varchar2` | Expense Account Type | [ ] | writable, `expenseAccount.type` | Account &gt; The account number. |
| `expenseItem_description` | `varchar2` | itgen_vnet_expenseitem_description | [ ] | writable, `expenseItem.description` | Name of item/description |
| `expenseItem_number` | `varchar2` | itgen_vnet_expenseitem_number | [ ] | writable, `expenseItem.number` | Number of item |
| `expenseSubaccount_active` | `char` | itgen_vnet_expensesubaccount_active | [ ] | writable, `expenseSubaccount.active` |  |
| `expenseSubaccount_description` | `varchar2` | itgen_vnet_expensesubaccount_description | [ ] | writable, `expenseSubaccount.description` | Click on the magnifier. &gt; The description. |
| `expenseSubaccount_id` | `varchar2` | itgen_vnet_expensesubaccount_id | [ ] | writable, `expenseSubaccount.id` | Click on the magnifier. &gt; The identifier. |
| `invoiceable` | `char` | Invoiceable | [ ] | writable, `invoiceable` | Invoicable &gt; A check box that, if selected, indicates that the claim amount is invoiceable to the customer (the total amount minus the employee's part). |
| `lastModifiedDateTime` | `datetime` | Last Modified | [ ] | filters on the platform, writable, `::ancestor.lastModifiedDateTime` | System generated information: The lastest time the expense claim was modified |
| `lineId` | `guid` | Line Identifier | [ ] | writable, `lineId` | The expense claim line id |
| `location_description` | `varchar2` | Location Description | [ ] | writable, `location.description` | Click on the magnifier. &gt; The description. |
| `location_description_2` | `varchar2` | itgen_vnet_location_description_2 | [ ] | filters on the platform, writable, `::ancestor.location.description` | Click on the magnifier. &gt; The description. |
| `location_id` | `varchar2` | Location ID | [ ] | writable, `location.id` | Click on the magnifier. &gt; The identifier. |
| `location_id_2` | `varchar2` | Location ID 2 | [ ] | filters on the platform, writable, `::ancestor.location.id` | Click on the magnifier. &gt; The identifier. |
| `metadata_maxPageSize` | `int64` | Metadata Max Pagesize | [ ] | filters on the platform, writable, `::ancestor.metadata.maxPageSize` |  |
| `metadata_totalCount` | `int64` | Total Count | [ ] | filters on the platform, writable, `::ancestor.metadata.totalCount` |  |
| `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 this expense item. |
| `refNbr` | `varchar2` | Reference Number | [ ] | writable, `refNbr` | Ref. no. &gt; The identifier of the transaction. |
| `refNbr_2` | `varchar2` | itgen_vnet_refnbr_2 | [ ] | filters on the platform, writable, `::ancestor.refNbr` | The top part &gt; Ref. no. &gt; The unique reference number of the expense claim document. |
| `salesAccount_active` | `char` | itgen_vnet_salesaccount_active | [ ] | writable, `salesAccount.active` |  |
| `salesAccount_description` | `varchar2` | Sales Account Description | [ ] | writable, `salesAccount.description` | Name of item/description |
| `salesAccount_externalCode1` | `varchar2` | itgen_vnet_salesaccount_externalcode1 | [ ] | writable, `salesAccount.externalCode1` | Account class &gt; The identifier of the account class. |
| `salesAccount_externalCode2` | `varchar2` | itgen_vnet_salesaccount_externalcode2 | [ ] | writable, `salesAccount.externalCode2` | Account class &gt; The name of the account class. |
| `salesAccount_number` | `varchar2` | Sales Account Number | [ ] | writable, `salesAccount.number` | Number of item |
| `salesAccount_type` | `varchar2` | Sales Account Type | [ ] | writable, `salesAccount.type` | Account &gt; The account number. |
| `salesSubaccount_active` | `char` | itgen_vnet_salessubaccount_active | [ ] | writable, `salesSubaccount.active` |  |
| `salesSubaccount_description` | `varchar2` | itgen_vnet_salessubaccount_description | [ ] | writable, `salesSubaccount.description` | Click on the magnifier. &gt; The description. |
| `salesSubaccount_id` | `varchar2` | itgen_vnet_salessubaccount_id | [ ] | writable, `salesSubaccount.id` | Click on the magnifier. &gt; The identifier. |
| `status` | `varchar2` | Status | [ ] | filters on the platform, writable, `::ancestor.status` | The top part &gt; Status &gt; The current status of the expense claim: On Hold/Pending Approval/Approved/Rejected/Released. |
| `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 |
| `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) |
| `totalAmount` | `double` | Total Amount | [ ] | writable, `totalAmount` | Amount &gt; The total amount paid for the expense item in the specified quantity. |
| `unitCost` | `double` | Unit Cost | [ ] | writable, `unitCost` | Unit cost &gt; The cost of a unit of the item. |
| `uom` | `varchar2` | Unit of Measure | [ ] | writable, `uom` | Mandatory field: UoM &gt; The unit of measure in which the quantity is shown. |
| `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)

