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

# ExpenseReceiptByNumber: Visma.net Financials Expense Receipt by Number

`read only` `REST`

- Catalog: `VismaNet`
- Schema: `ExpenseReceipt`
- Label: Expense Receipt by Number

Get a specific ExpenseReceipt
Data for a single expense receipt 
The response headers include an ETag after a successful GET operation.

Can only retrieve data.

## Summary

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

## API Source

- Endpoint: `/v1/expenseReceipt/{receiptNumber}`
- Operation: `get /v1/expenseReceipt/{receiptNumber}`

## 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 |
|---|---|:---:|---|---|
| `receiptNumber` | `` | [x] |  | Identifies the ExpenseReceipt |

## Table Columns

The columns of the table `ExpenseReceiptByNumber` 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. |
| `branch_name` | `varchar2` | Branch Name | [ ] | filters on the platform, writable, `branch.name` | Click the magnifier. &gt; The name. |
| `branch_number` | `varchar2` | Branch Number | [ ] | filters on the platform, writable, `branch.number` | Click the magnifier. &gt; The identifier. |
| `claimAmount` | `double` | Claim Amount | [ ] | filters on the platform, writable, `claimAmount` | Receipt details tab &gt; Expense details section &gt; Expense claim &gt; The expense claim with which the expense receipt is associated. |
| `claimedBy_address_addressId` | `int32` | itgen_vnet_claimedby_address_addressid | [ ] | filters on the platform, writable, `claimedBy.address.addressId` |  |
| `claimedBy_address_addressLine1` | `varchar2` | itgen_vnet_claimedby_address_addressline1 | [ ] | filters on the platform, writable, `claimedBy.address.addressLine1` | Address 1 &gt; The first line of the customer's/supplier's/company's/employee's contact address. |
| `claimedBy_address_addressLine2` | `varchar2` | itgen_vnet_claimedby_address_addressline2 | [ ] | filters on the platform, writable, `claimedBy.address.addressLine2` | Address 2 &gt; The second line of the address. |
| `claimedBy_address_addressLine3` | `varchar2` | itgen_vnet_claimedby_address_addressline3 | [ ] | filters on the platform, writable, `claimedBy.address.addressLine3` | Address 3 &gt; The third line of the address. |
| `claimedBy_address_city` | `varchar2` | itgen_vnet_claimedby_address_city | [ ] | filters on the platform, writable, `claimedBy.address.city` | City &gt; The city. |
| `claimedBy_address_country_errorInfo` | `varchar2` | itgen_vnet_claimedby_address_country_errorinfo | [ ] | filters on the platform, writable, `claimedBy.address.country.errorInfo` |  |
| `claimedBy_address_country_id` | `varchar2` | itgen_vnet_claimedby_address_country_id | [ ] | filters on the platform, writable, `claimedBy.address.country.id` | Mandatory field: Country ID* &gt; The unique two-letter country ID according to international standard ISO 3166. |
| `claimedBy_address_country_metadata_maxPageSize` | `int64` | itgen_vnet_claimedby_address_country_metadata_maxpagesize | [ ] | filters on the platform, writable, `claimedBy.address.country.metadata.maxPageSize` |  |
| `claimedBy_address_country_metadata_totalCount` | `int64` | itgen_vnet_claimedby_address_country_metadata_totalcount | [ ] | filters on the platform, writable, `claimedBy.address.country.metadata.totalCount` |  |
| `claimedBy_address_country_name` | `varchar2` | itgen_vnet_claimedby_address_country_name | [ ] | filters on the platform, writable, `claimedBy.address.country.name` | Mandatory field: Country name* &gt; The complete name of the country. |
| `claimedBy_address_county_id` | `varchar2` | itgen_vnet_claimedby_address_county_id | [ ] | filters on the platform, writable, `claimedBy.address.county.id` | Click the magnifier &gt; The identifier |
| `claimedBy_address_county_name` | `varchar2` | itgen_vnet_claimedby_address_county_name | [ ] | filters on the platform, writable, `claimedBy.address.county.name` | Click the magnifier &gt; The displayed name |
| `claimedBy_address_postalCode` | `varchar2` | itgen_vnet_claimedby_address_postalcode | [ ] | filters on the platform, writable, `claimedBy.address.postalCode` | Postcode &gt; The postcode. |
| `claimedBy_branch_name` | `varchar2` | itgen_vnet_claimedby_branch_name | [ ] | filters on the platform, writable, `claimedBy.branch.name` | Click the magnifier. &gt; The name. |
| `claimedBy_branch_number` | `varchar2` | itgen_vnet_claimedby_branch_number | [ ] | filters on the platform, writable, `claimedBy.branch.number` | Click the magnifier. &gt; The identifier. |
| `claimedBy_calendarID` | `varchar2` | itgen_vnet_claimedby_calendarid | [ ] | filters on the platform, writable, `claimedBy.calendarID` |  |
| `claimedBy_contact_attention` | `varchar2` | itgen_vnet_claimedby_contact_attention | [ ] | filters on the platform, writable, `claimedBy.contact.attention` | Attention &gt; The attention line as it is used in your customer's/supplier's/company's business letters. The intention of this line is to direct the letter to the right person if the letter is not addressed to any specific person. |
| `claimedBy_contact_contactId` | `int32` | itgen_vnet_claimedby_contact_contactid | [ ] | filters on the platform, writable, `claimedBy.contact.contactId` |  |
| `claimedBy_contact_email` | `varchar2` | itgen_vnet_claimedby_contact_email | [ ] | filters on the platform, writable, `claimedBy.contact.email` | Email &gt; The email address of the customer/supplier/company as a business entity. |
| `claimedBy_contact_employeeContact` | `varchar2` | itgen_vnet_claimedby_contact_employeecontact | [ ] | filters on the platform, writable, `claimedBy.contact.employeeContact` | Employee contact &gt; The link to the contact record associated with the employee. |
| `claimedBy_contact_fax` | `varchar2` | itgen_vnet_claimedby_contact_fax | [ ] | filters on the platform, writable, `claimedBy.contact.fax` | Fax &gt; The fax number. |
| `claimedBy_contact_firstName` | `varchar2` | itgen_vnet_claimedby_contact_firstname | [ ] | filters on the platform, writable, `claimedBy.contact.firstName` | First name &gt; The first name of the employee. |
| `claimedBy_contact_lastName` | `varchar2` | itgen_vnet_claimedby_contact_lastname | [ ] | filters on the platform, writable, `claimedBy.contact.lastName` | Mandatory field: Last name* &gt; The last name of the employee. |
| `claimedBy_contact_midName` | `varchar2` | itgen_vnet_claimedby_contact_midname | [ ] | filters on the platform, writable, `claimedBy.contact.midName` | Middle name &gt; The middle name of the employee. |
| `claimedBy_contact_name` | `varchar2` | itgen_vnet_claimedby_contact_name | [ ] | filters on the platform, writable, `claimedBy.contact.name` | Name &gt; The legal name of to appear on the documents. |
| `claimedBy_contact_phone1` | `varchar2` | itgen_vnet_claimedby_contact_phone1 | [ ] | filters on the platform, writable, `claimedBy.contact.phone1` | Phone 1 &gt; The default phone number. |
| `claimedBy_contact_phone2` | `varchar2` | itgen_vnet_claimedby_contact_phone2 | [ ] | filters on the platform, writable, `claimedBy.contact.phone2` | Phone 2 &gt; An additional phone number. |
| `claimedBy_contact_phone3` | `varchar2` | itgen_vnet_claimedby_contact_phone3 | [ ] | filters on the platform, writable, `claimedBy.contact.phone3` | Phone 3 &gt; An additional phone number of the employee. |
| `claimedBy_contact_title` | `varchar2` | itgen_vnet_claimedby_contact_title | [ ] | filters on the platform, writable, `claimedBy.contact.title` | Title &gt; The courtesy title to be used for the employee. |
| `claimedBy_contact_web` | `varchar2` | itgen_vnet_claimedby_contact_web | [ ] | filters on the platform, writable, `claimedBy.contact.web` | Web &gt; The website of the company, if one exists. |
| `claimedBy_department` | `varchar2` | itgen_vnet_claimedby_department | [ ] | filters on the platform, writable, `claimedBy.department` | Mandatory field: General information tab &gt; Employee section &gt; Department* &gt; The department the employee works for. |
| `claimedBy_employeeClass_description` | `varchar2` | itgen_vnet_claimedby_employeeclass_description | [ ] | filters on the platform, writable, `claimedBy.employeeClass.description` | Click on the magnifier. &gt; The description. |
| `claimedBy_employeeClass_id` | `varchar2` | itgen_vnet_claimedby_employeeclass_id | [ ] | filters on the platform, writable, `claimedBy.employeeClass.id` | Click on the magnifier. &gt; The identifier. |
| `claimedBy_employeeId` | `int32` | itgen_vnet_claimedby_employeeid | [ ] | filters on the platform, writable, `claimedBy.employeeId` | Mandatory field: The top part &gt; Employee ID* &gt; The unique identifier, which is assigned to the employee in accordance with the configuration of the EMPLOYEE segmented key. |
| `claimedBy_employeeLogin` | `varchar2` | itgen_vnet_claimedby_employeelogin | [ ] | filters on the platform, writable, `claimedBy.employeeLogin` |  |
| `claimedBy_employeeName` | `varchar2` | itgen_vnet_claimedby_employeename | [ ] | filters on the platform, writable, `claimedBy.employeeName` | The top part &gt; Employee name &gt; The name of this employee. |
| `claimedBy_employeeNumber` | `varchar2` | itgen_vnet_claimedby_employeenumber | [ ] | filters on the platform, writable, `claimedBy.employeeNumber` | General information tab &gt; Employee settings section &gt; Employee ref. no. &gt; A reference number for the employee. |
| `claimedBy_employeeUserId` | `guid` | itgen_vnet_claimedby_employeeuserid | [ ] | filters on the platform, writable, `claimedBy.employeeUserId` | Employee internal user ID. This is the ID of the user linked to the employee |
| `claimedBy_errorInfo` | `varchar2` | itgen_vnet_claimedby_errorinfo | [ ] | filters on the platform, writable, `claimedBy.errorInfo` |  |
| `claimedBy_lastModifiedDateTime` | `datetime` | itgen_vnet_claimedby_lastmodifieddatetime | [ ] | filters on the platform, writable, `claimedBy.lastModifiedDateTime` |  |
| `claimedBy_metadata_maxPageSize` | `int64` | itgen_vnet_claimedby_metadata_maxpagesize | [ ] | filters on the platform, writable, `claimedBy.metadata.maxPageSize` |  |
| `claimedBy_metadata_totalCount` | `int64` | itgen_vnet_claimedby_metadata_totalcount | [ ] | filters on the platform, writable, `claimedBy.metadata.totalCount` |  |
| `claimedBy_status` | `varchar2` | itgen_vnet_claimedby_status | [ ] | filters on the platform, writable, `claimedBy.status` | Mandatory field: The top part &gt; Status &gt; The status of the employee. The following options are available: Active, On hold, Hold payments, Inactive, One-time. |
| `claimedBy_timeStamp` | `blob` | itgen_vnet_claimedby_timestamp | [ ] | filters on the platform, writable, `claimedBy.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) |
| `currency_description` | `varchar2` | Currency Description | [ ] | filters on the platform, writable, `currency.description` | Click on the magnifier. &gt; The description. |
| `currency_id` | `varchar2` | Currency ID | [ ] | filters on the platform, writable, `currency.id` | Click on the magnifier. &gt; The identifier. |
| `customer_name` | `varchar2` | Customer Name | [ ] | filters on the platform, writable, `customer.name` | Click the magnifier. &gt; The name. |
| `customer_number` | `varchar2` | Customer Number | [ ] | filters on the platform, writable, `customer.number` |  |
| `date` | `datetime` | Date | [ ] | filters on the platform, writable, `date` | Both tabs &gt; Date &gt; The date of the expense receipt. |
| `description` | `varchar2` | Description | [ ] | filters on the platform, writable, `description` | Open the receipt Mandatory field: Receipt details tab &gt; Expense details section &gt; Description* &gt; The expense description, which is displayed as a link. |
| `employeePart` | `double` | itgen_vnet_employeepart | [ ] | filters on the platform, writable, `employeePart` | Receipt details tab &gt; Expense details section &gt; Employee part  &gt; The part of the total amount that will not be paid back to the employee. |
| `expenseAccount_description` | `varchar2` | Expense Account Description | [ ] | filters on the platform, writable, `expenseAccount.description` | Name of item/description |
| `expenseAccount_number` | `varchar2` | Expense Account Number | [ ] | filters on the platform, writable, `expenseAccount.number` | Number of item |
| `expenseAccount_type` | `varchar2` | Expense Account Type | [ ] | filters on the platform, writable, `expenseAccount.type` |  |
| `expenseClaim_description` | `varchar2` | Expense Claim Description | [ ] | filters on the platform, writable, `expenseClaim.description` | Name of item/description |
| `expenseClaim_number` | `varchar2` | Expense Claim Number | [ ] | filters on the platform, writable, `expenseClaim.number` | Number of item |
| `expenseSub_active` | `char` | itgen_vnet_expensesub_active | [ ] | filters on the platform, writable, `expenseSub.active` |  |
| `expenseSub_description` | `varchar2` | itgen_vnet_expensesub_description | [ ] | filters on the platform, writable, `expenseSub.description` | Click on the magnifier. &gt; The description. |
| `expenseSub_id` | `varchar2` | itgen_vnet_expensesub_id | [ ] | filters on the platform, writable, `expenseSub.id` | Click on the magnifier. &gt; The identifier. |
| `image_id` | `guid` | Image ID | [ ] | filters on the platform, writable, `image.id` | The ID of the attachment |
| `image_name` | `varchar2` | Image Name | [ ] | filters on the platform, writable, `image.name` | The name of the attachment. |
| `image_revision` | `int32` | Image Revision | [ ] | filters on the platform, writable, `image.revision` | The version of the attachment. |
| `internalId` | `int32` | Internal ID | [ ] | filters on the platform, writable, `internalId` |  |
| `inventory_description` | `varchar2` | Inventory Description | [ ] | filters on the platform, writable, `inventory.description` | Name of item/description |
| `inventory_number` | `varchar2` | Inventory Number | [ ] | filters on the platform, writable, `inventory.number` | Number of item |
| `invoiceable` | `char` | Invoiceable | [ ] | filters on the platform, writable, `invoiceable` | Receipt details tab &gt; Financial details section &gt; Invoiceable &gt; A check box that indicates (if selected) that the customer should be invoiced for the claim amount. |
| `location_description` | `varchar2` | Location Description | [ ] | filters on the platform, writable, `location.description` | Click on the magnifier. &gt; The description. |
| `location_id` | `varchar2` | Location ID | [ ] | filters on the platform, writable, `location.id` | Click on the magnifier. &gt; The identifier. |
| `projectTask_description` | `varchar2` | Project Task Description | [ ] | filters on the platform, writable, `projectTask.description` | Click on the magnifier. &gt; The description. |
| `projectTask_id` | `varchar2` | Project Task ID | [ ] | filters on the platform, writable, `projectTask.id` | Click on the magnifier. &gt; The identifier. |
| `projectTask_internalId` | `int32` | itgen_vnet_projecttask_internalid | [ ] | filters on the platform, writable, `projectTask.internalId` | The internal identifier. |
| `project_description` | `varchar2` | Project Description | [ ] | filters on the platform, writable, `project.description` | Click on the magnifier. &gt; The description. |
| `project_id` | `varchar2` | Project ID | [ ] | filters on the platform, writable, `project.id` | Click on the magnifier. &gt; The identifier. |
| `project_internalId` | `int32` | itgen_vnet_project_internalid | [ ] | filters on the platform, writable, `project.internalId` | The internal identifier. |
| `quantity` | `double` | Quantity | [ ] | filters on the platform, writable, `quantity` | Receipt details tab &gt; Expense details section &gt; Quantity &gt; The quantity of the expense item that the employee purchased according to the receipt. |
| `receiptId` | `varchar2` | Receipt ID | [ ] | filters on the platform, writable, `receiptId` | The top part &gt; Employee &gt; 	The identifier of the employee whose expense receipts you want to manage. |
| `refNbr` | `varchar2` | Reference Number | [ ] | filters on the platform, writable, `refNbr` | Both tabs &gt; Ref. no. &gt; The reference number, which usually matches the number of the original receipt. |
| `salesAccount_description` | `varchar2` | Sales Account Description | [ ] | filters on the platform, writable, `salesAccount.description` | Name of item/description |
| `salesAccount_number` | `varchar2` | Sales Account Number | [ ] | filters on the platform, writable, `salesAccount.number` | Number of item |
| `salesAccount_type` | `varchar2` | Sales Account Type | [ ] | filters on the platform, writable, `salesAccount.type` |  |
| `salesSub_active` | `char` | itgen_vnet_salessub_active | [ ] | filters on the platform, writable, `salesSub.active` |  |
| `salesSub_description` | `varchar2` | itgen_vnet_salessub_description | [ ] | filters on the platform, writable, `salesSub.description` | Click on the magnifier. &gt; The description. |
| `salesSub_id` | `varchar2` | itgen_vnet_salessub_id | [ ] | filters on the platform, writable, `salesSub.id` | Click on the magnifier. &gt; The identifier. |
| `status` | `varchar2` | Status | [ ] | filters on the platform, writable, `status` | Receipt details tab &gt; Expense details section &gt; Expense claim status &gt; The current status of the associated expense claim, which can be one of the following options: On hold, Pending apporval, Approved, Rejected, Released. |
| `taxCategory_description` | `varchar2` | itgen_vnet_taxcategory_description | [ ] | filters on the platform, writable, `taxCategory.description` | Name of item/description |
| `taxCategory_number` | `varchar2` | itgen_vnet_taxcategory_number | [ ] | filters on the platform, writable, `taxCategory.number` | Number of item |
| `taxTotal` | `double` | Tax Total | [ ] | filters on the platform, writable, `taxTotal` | The top part &gt; VAT total &gt; The total amount of VAT or taxes calculated for the expense receipt. |
| `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) |
| `totalAmount` | `double` | Total Amount | [ ] | filters on the platform, writable, `totalAmount` | Receipt details tab &gt; Expense details section &gt; Amount &gt; The total amount of the receipt (for VAT-inclusive taxes), or the total amount before taxes (for VAT-exclusive taxes). |
| `unitCost` | `double` | Unit Cost | [ ] | filters on the platform, writable, `unitCost` | Receipt details tab &gt; Expense details section &gt; Unit cost &gt; The cost of one unit of the expense item. |
| `uom` | `varchar2` | Unit of Measure | [ ] | filters on the platform, writable, `uom` | Receipt details tab &gt; Expense details section &gt; UoM &gt; The unit of measure of the expense item. |



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

