ExpenseClaimByNumber: Visma.net Financials itgen_vnet_expenseclaimbynumber_plural
read only REST
- Catalog:
VismaNet - Schema:
ExpenseClaim - Label: itgen_vnet_expenseclaimbynumber_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
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 |
|---|---|---|---|---|
expense |
`` | Identifies the expense claim |
Table Columns
The columns of the table ExpenseClaimByNumber 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_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
approval |
datetime |
Approval Date | filters on the platform, writable, approval |
The top part > Approval date > The date when the claim was approved. | |
approval |
varchar2 |
Approval Status | filters on the platform, writable, approval |
The top part > Approval status > The status of the claim in Approval. | |
approval |
varchar2 |
Approval Status Text | filters on the platform, writable, approval |
The top part > Approval status > A text field. | |
claim |
double |
Claim Total | filters on the platform, writable, claim |
The top part > Claim total > The total amount of the claim. | |
claimed |
varchar2 |
Claimed by - Internal ID | filters on the platform, writable, claimed |
||
claimed |
varchar2 |
Claimed by - Name | filters on the platform, writable, claimed |
The name of the particular destination of the selected type. | |
claimed |
varchar2 |
Claimed by - Number | filters on the platform, writable, claimed |
The identifier of the particular destination of the selected type. | |
currency |
varchar2 |
Currency | filters on the platform, writable, currency |
The top part > Currency > The currency of the claim. | |
customer_ |
varchar2 |
Customer Name | filters on the platform, writable, customer. |
Click the magnifier. > The name. | |
customer_ |
varchar2 |
Customer Number | filters on the platform, writable, customer. |
||
date |
datetime |
Date | filters on the platform, writable, date |
Mandatory field: The top part > Date* > The date when the claim was entered. | |
department_ |
varchar2 |
Department Description | filters on the platform, writable, department. |
Click on the magnifier. > The description. | |
department_ |
varchar2 |
Department ID | filters on the platform, writable, department. |
Click on the magnifier. > The identifier. | |
description |
varchar2 |
Description | filters on the platform, writable, description |
Mandatory field: The top part > Description > A description of the claim. | |
error |
varchar2 |
Error Message | filters on the platform, writable, error |
||
last |
datetime |
Last Modified | filters on the platform, writable, last |
System generated information: The lastest time the expense claim was modified | |
location_ |
varchar2 |
Location Description | filters on the platform, writable, location. |
Click on the magnifier. > The description. | |
location_ |
varchar2 |
Location ID | filters on the platform, writable, location. |
Click on the magnifier. > The identifier. | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, metadata. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, metadata. |
||
refNbr |
varchar2 |
Reference Number | filters on the platform, writable, refNbr |
The top part > Ref. no. > The unique reference number of the expense claim document. | |
status |
varchar2 |
Status | filters on the platform, writable, status |
The top part > Status > The current status of the expense claim: On Hold/Pending Approval/Approved/Rejected/Released. | |
time |
blob |
Timestamp | filters on the platform, writable, time |
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) | |
vat |
double |
VAT Exempt Total | filters on the platform, writable, vat |
The top part > VAT exempt total > The document total that is exempt from VAT. | |
vat |
double |
VAT Taxable Total | filters on the platform, writable, vat |
The top part > VAT taxable total > The document total that is subjected to VAT. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: