invantive documentation
Invantive Support ForumsLog In / Sign Up

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

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 `` 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 writable Partition code, segmenting the data.
COMPANY_NAME varchar2(240) Company Name writable Name of the partition.
branch_name varchar2 Branch Name filters on the platform, writable, branch.name Click the magnifier. > The name.
branch_number varchar2 Branch Number filters on the platform, writable, branch.number Click the magnifier. > The identifier.
claimAmount double Claim Amount filters on the platform, writable, claimAmount Receipt details tab > Expense details section > Expense claim > 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 > 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 > 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 > The third line of the address.
claimedBy_address_city varchar2 itgen_vnet_claimedby_address_city filters on the platform, writable, claimedBy.address.city City > 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* > 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* > 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 > 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 > The displayed name
claimedBy_address_postalCode varchar2 itgen_vnet_claimedby_address_postalcode filters on the platform, writable, claimedBy.address.postalCode Postcode > The postcode.
claimedBy_branch_name varchar2 itgen_vnet_claimedby_branch_name filters on the platform, writable, claimedBy.branch.name Click the magnifier. > The name.
claimedBy_branch_number varchar2 itgen_vnet_claimedby_branch_number filters on the platform, writable, claimedBy.branch.number Click the magnifier. > 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 > 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 > 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 > 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 > The fax number.
claimedBy_contact_firstName varchar2 itgen_vnet_claimedby_contact_firstname filters on the platform, writable, claimedBy.contact.firstName First name > 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* > 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 > The middle name of the employee.
claimedBy_contact_name varchar2 itgen_vnet_claimedby_contact_name filters on the platform, writable, claimedBy.contact.name Name > 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 > The default phone number.
claimedBy_contact_phone2 varchar2 itgen_vnet_claimedby_contact_phone2 filters on the platform, writable, claimedBy.contact.phone2 Phone 2 > An additional phone number.
claimedBy_contact_phone3 varchar2 itgen_vnet_claimedby_contact_phone3 filters on the platform, writable, claimedBy.contact.phone3 Phone 3 > 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 > 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 > 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 > Employee section > Department* > 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. > The description.
claimedBy_employeeClass_id varchar2 itgen_vnet_claimedby_employeeclass_id filters on the platform, writable, claimedBy.employeeClass.id Click on the magnifier. > The identifier.
claimedBy_employeeId int32 itgen_vnet_claimedby_employeeid filters on the platform, writable, claimedBy.employeeId Mandatory field: The top part > Employee ID* > 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 > Employee name > The name of this employee.
claimedBy_employeeNumber varchar2 itgen_vnet_claimedby_employeenumber filters on the platform, writable, claimedBy.employeeNumber General information tab > Employee settings section > Employee ref. no. > 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 > Status > 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. > The description.
currency_id varchar2 Currency ID filters on the platform, writable, currency.id Click on the magnifier. > The identifier.
customer_name varchar2 Customer Name filters on the platform, writable, customer.name Click the magnifier. > 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 > Date > The date of the expense receipt.
description varchar2 Description filters on the platform, writable, description Open the receipt Mandatory field: Receipt details tab > Expense details section > Description* > The expense description, which is displayed as a link.
employeePart double itgen_vnet_employeepart filters on the platform, writable, employeePart Receipt details tab > Expense details section > Employee part > 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. > The description.
expenseSub_id varchar2 itgen_vnet_expensesub_id filters on the platform, writable, expenseSub.id Click on the magnifier. > 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 > Financial details section > Invoiceable > 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. > The description.
location_id varchar2 Location ID filters on the platform, writable, location.id Click on the magnifier. > The identifier.
projectTask_description varchar2 Project Task Description filters on the platform, writable, projectTask.description Click on the magnifier. > The description.
projectTask_id varchar2 Project Task ID filters on the platform, writable, projectTask.id Click on the magnifier. > 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. > The description.
project_id varchar2 Project ID filters on the platform, writable, project.id Click on the magnifier. > 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 > Expense details section > Quantity > 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 > Employee > The identifier of the employee whose expense receipts you want to manage.
refNbr varchar2 Reference Number filters on the platform, writable, refNbr Both tabs > Ref. no. > 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. > The description.
salesSub_id varchar2 itgen_vnet_salessub_id filters on the platform, writable, salesSub.id Click on the magnifier. > The identifier.
status varchar2 Status filters on the platform, writable, status Receipt details tab > Expense details section > Expense claim status > 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 > VAT total > 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 > Expense details section > Amount > 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 > Expense details section > Unit cost > The cost of one unit of the expense item.
uom varchar2 Unit of Measure filters on the platform, writable, uom Receipt details tab > Expense details section > UoM > The unit of measure of the expense item.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: