invantive documentation
Invantive Support ForumsLog In / Sign Up

ExpenseReceiptClaimByReceiptNumber: Visma.net Financials itgen_vnet_expensereceiptclaimbyreceiptnumber_plural

read only REST

  • Catalog: VismaNet
  • Schema: ExpenseReceipt
  • Label: itgen_vnet_expensereceiptclaimbyreceiptnumber_plural

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 ExpenseReceiptClaimByReceiptNumber 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.
TEXT varchar2 itgen_vnet_text writable, ::self
address_addressId int32 Address ID writable, ::ancestor.address.addressId
address_addressLine1 varchar2 Address Line 1 writable, ::ancestor.address.addressLine1 Address 1 > The first line of the customer's/supplier's/company's/employee's contact address.
address_addressLine2 varchar2 Address Line 2 writable, ::ancestor.address.addressLine2 Address 2 > The second line of the address.
address_addressLine3 varchar2 Address Line 3 writable, ::ancestor.address.addressLine3 Address 3 > The third line of the address.
address_city varchar2 City writable, ::ancestor.address.city City > The city.
address_country_errorInfo varchar2 itgen_vnet_address_country_errorinfo writable, ::ancestor.address.country.errorInfo
address_country_id varchar2 Country ID writable, ::ancestor.address.country.id Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166.
address_country_metadata_maxPageSize int64 itgen_vnet_address_country_metadata_maxpagesize writable, ::ancestor.address.country.metadata.maxPageSize
address_country_metadata_totalCount int64 itgen_vnet_address_country_metadata_totalcount writable, ::ancestor.address.country.metadata.totalCount
address_country_name varchar2 Country Name writable, ::ancestor.address.country.name Mandatory field: Country name* > The complete name of the country.
address_county_id varchar2 County ID writable, ::ancestor.address.county.id Click the magnifier > The identifier
address_county_name varchar2 County Name writable, ::ancestor.address.county.name Click the magnifier > The displayed name
address_postalCode varchar2 Postal Code writable, ::ancestor.address.postalCode Postcode > The postcode.
branch_name varchar2 Branch Name writable, ::ancestor.branch.name Click the magnifier. > The name.
branch_name_2 varchar2 Branch Name 2 filters on the platform, writable, ::ancestor.::ancestor.branch.name Click the magnifier. > The name.
branch_number varchar2 Branch Number writable, ::ancestor.branch.number Click the magnifier. > The identifier.
branch_number_2 varchar2 Branch Number 2 filters on the platform, writable, ::ancestor.::ancestor.branch.number Click the magnifier. > The identifier.
calendarID varchar2 Calendar ID writable, ::ancestor.calendarID
claimAmount double Claim Amount filters on the platform, writable, ::ancestor.::ancestor.claimAmount Receipt details tab > Expense details section > Expense claim > The expense claim with which the expense receipt is associated.
contact_attention varchar2 itgen_vnet_contact_attention writable, ::ancestor.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.
contact_contactId int32 Contact ID writable, ::ancestor.contact.contactId
contact_email varchar2 Contact Email writable, ::ancestor.contact.email Email > The email address of the customer/supplier/company as a business entity.
contact_employeeContact varchar2 Contact Employee Contact writable, ::ancestor.contact.employeeContact Employee contact > The link to the contact record associated with the employee.
contact_fax varchar2 Contact Fax writable, ::ancestor.contact.fax Fax > The fax number.
contact_firstName varchar2 Contact First Name writable, ::ancestor.contact.firstName First name > The first name of the employee.
contact_lastName varchar2 Contact Last Name writable, ::ancestor.contact.lastName Mandatory field: Last name* > The last name of the employee.
contact_midName varchar2 Contact Middle Name writable, ::ancestor.contact.midName Middle name > The middle name of the employee.
contact_name varchar2 Contact Name writable, ::ancestor.contact.name Name > The legal name of to appear on the documents.
contact_phone1 varchar2 Contact Phone 1 writable, ::ancestor.contact.phone1 Phone 1 > The default phone number.
contact_phone2 varchar2 Contact Phone 2 writable, ::ancestor.contact.phone2 Phone 2 > An additional phone number.
contact_phone3 varchar2 Contact Phone 3 writable, ::ancestor.contact.phone3 Phone 3 > An additional phone number of the employee.
contact_title varchar2 Contact Title writable, ::ancestor.contact.title Title > The courtesy title to be used for the employee.
contact_web varchar2 Contact Website writable, ::ancestor.contact.web Web > The website of the company, if one exists.
currency_description varchar2 Currency Description filters on the platform, writable, ::ancestor.::ancestor.currency.description Click on the magnifier. > The description.
currency_id varchar2 Currency ID filters on the platform, writable, ::ancestor.::ancestor.currency.id Click on the magnifier. > The identifier.
customer_name varchar2 Customer Name filters on the platform, writable, ::ancestor.::ancestor.customer.name Click the magnifier. > The name.
customer_number varchar2 Customer Number filters on the platform, writable, ::ancestor.::ancestor.customer.number
date datetime Date filters on the platform, writable, ::ancestor.::ancestor.date Both tabs > Date > The date of the expense receipt.
department varchar2 Department writable, ::ancestor.department Mandatory field: General information tab > Employee section > Department* > The department the employee works for.
description varchar2 Description filters on the platform, writable, ::ancestor.::ancestor.description Open the receipt Mandatory field: Receipt details tab > Expense details section > Description* > The expense description, which is displayed as a link.
employeeClass_description varchar2 Employee Class Description writable, ::ancestor.employeeClass.description Click on the magnifier. > The description.
employeeClass_id varchar2 Employee Class ID writable, ::ancestor.employeeClass.id Click on the magnifier. > The identifier.
employeeId int32 Employee ID writable, ::ancestor.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.
employeeLogin varchar2 Employee Login writable, ::ancestor.employeeLogin
employeeName varchar2 Employee Name writable, ::ancestor.employeeName The top part > Employee name > The name of this employee.
employeeNumber varchar2 Employee Number writable, ::ancestor.employeeNumber General information tab > Employee settings section > Employee ref. no. > A reference number for the employee.
employeePart double itgen_vnet_employeepart filters on the platform, writable, ::ancestor.::ancestor.employeePart Receipt details tab > Expense details section > Employee part > The part of the total amount that will not be paid back to the employee.
employeeUserId guid Employee User ID writable, ::ancestor.employeeUserId Employee internal user ID. This is the ID of the user linked to the employee
errorInfo varchar2 Error Message writable, ::ancestor.errorInfo
expenseAccount_description varchar2 Expense Account Description filters on the platform, writable, ::ancestor.::ancestor.expenseAccount.description Name of item/description
expenseAccount_number varchar2 Expense Account Number filters on the platform, writable, ::ancestor.::ancestor.expenseAccount.number Number of item
expenseAccount_type varchar2 Expense Account Type filters on the platform, writable, ::ancestor.::ancestor.expenseAccount.type
expenseClaim_description varchar2 Expense Claim Description filters on the platform, writable, ::ancestor.::ancestor.expenseClaim.description Name of item/description
expenseClaim_number varchar2 Expense Claim Number filters on the platform, writable, ::ancestor.::ancestor.expenseClaim.number Number of item
expenseSub_active char itgen_vnet_expensesub_active filters on the platform, writable, ::ancestor.::ancestor.expenseSub.active
expenseSub_description varchar2 itgen_vnet_expensesub_description filters on the platform, writable, ::ancestor.::ancestor.expenseSub.description Click on the magnifier. > The description.
expenseSub_id varchar2 itgen_vnet_expensesub_id filters on the platform, writable, ::ancestor.::ancestor.expenseSub.id Click on the magnifier. > The identifier.
image_id guid Image ID filters on the platform, writable, ::ancestor.::ancestor.image.id The ID of the attachment
image_name varchar2 Image Name filters on the platform, writable, ::ancestor.::ancestor.image.name The name of the attachment.
image_revision int32 Image Revision filters on the platform, writable, ::ancestor.::ancestor.image.revision The version of the attachment.
internalId int32 Internal ID filters on the platform, writable, ::ancestor.::ancestor.internalId
inventory_description varchar2 Inventory Description filters on the platform, writable, ::ancestor.::ancestor.inventory.description Name of item/description
inventory_number varchar2 Inventory Number filters on the platform, writable, ::ancestor.::ancestor.inventory.number Number of item
invoiceable char Invoiceable filters on the platform, writable, ::ancestor.::ancestor.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.
lastModifiedDateTime datetime Last Modified writable, ::ancestor.lastModifiedDateTime
location_description varchar2 Location Description filters on the platform, writable, ::ancestor.::ancestor.location.description Click on the magnifier. > The description.
location_id varchar2 Location ID filters on the platform, writable, ::ancestor.::ancestor.location.id Click on the magnifier. > The identifier.
metadata_maxPageSize int64 Metadata Max Pagesize writable, ::ancestor.metadata.maxPageSize
metadata_totalCount int64 Total Count writable, ::ancestor.metadata.totalCount
projectTask_description varchar2 Project Task Description filters on the platform, writable, ::ancestor.::ancestor.projectTask.description Click on the magnifier. > The description.
projectTask_id varchar2 Project Task ID filters on the platform, writable, ::ancestor.::ancestor.projectTask.id Click on the magnifier. > The identifier.
projectTask_internalId int32 itgen_vnet_projecttask_internalid filters on the platform, writable, ::ancestor.::ancestor.projectTask.internalId The internal identifier.
project_description varchar2 Project Description filters on the platform, writable, ::ancestor.::ancestor.project.description Click on the magnifier. > The description.
project_id varchar2 Project ID filters on the platform, writable, ::ancestor.::ancestor.project.id Click on the magnifier. > The identifier.
project_internalId int32 itgen_vnet_project_internalid filters on the platform, writable, ::ancestor.::ancestor.project.internalId The internal identifier.
quantity double Quantity filters on the platform, writable, ::ancestor.::ancestor.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, ::ancestor.::ancestor.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, ::ancestor.::ancestor.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, ::ancestor.::ancestor.salesAccount.description Name of item/description
salesAccount_number varchar2 Sales Account Number filters on the platform, writable, ::ancestor.::ancestor.salesAccount.number Number of item
salesAccount_type varchar2 Sales Account Type filters on the platform, writable, ::ancestor.::ancestor.salesAccount.type
salesSub_active char itgen_vnet_salessub_active filters on the platform, writable, ::ancestor.::ancestor.salesSub.active
salesSub_description varchar2 itgen_vnet_salessub_description filters on the platform, writable, ::ancestor.::ancestor.salesSub.description Click on the magnifier. > The description.
salesSub_id varchar2 itgen_vnet_salessub_id filters on the platform, writable, ::ancestor.::ancestor.salesSub.id Click on the magnifier. > The identifier.
status varchar2 Status writable, ::ancestor.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.
status_2 varchar2 itgen_vnet_status_2 filters on the platform, writable, ::ancestor.::ancestor.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, ::ancestor.::ancestor.taxCategory.description Name of item/description
taxCategory_number varchar2 itgen_vnet_taxcategory_number filters on the platform, writable, ::ancestor.::ancestor.taxCategory.number Number of item
taxTotal double Tax Total filters on the platform, writable, ::ancestor.::ancestor.taxTotal The top part > VAT total > The total amount of VAT or taxes calculated for the expense receipt.
timeStamp blob Timestamp 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)
timeStamp_2 blob itgen_vnet_timestamp_2 filters on the platform, writable, ::ancestor.::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 filters on the platform, writable, ::ancestor.::ancestor.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, ::ancestor.::ancestor.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, ::ancestor.::ancestor.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: