ExpenseClaimDetails: Visma.net Financials Expense Claim Details
read only REST
- Catalog:
VismaNet - Schema:
ExpenseClaim - Label: Expense Claim Details
Get a range of Expense Claims, a filter needs to be specified. ScreenId=EP301000 Request page size must be lower or equal to the allowed max page size which is returned as part of the metadata information. If requested page size is greater than allowed max page size, request will be limited to max page size Change log: 2021-October:Added forced pagination 2022-December: Added the actual code to force pagination!
Can only retrieve data.
API Source
- Endpoint:
/v1/expenseClaim - Operation:
get /v1/expenseClaim
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 |
|---|---|---|---|---|
customer |
`` | The customer from the document | ||
date |
`` | The date of the document | ||
department |
`` | Identifies the department | ||
greater |
`` | Greater-than value. The item which is the object for this, varies from API to API. | ||
last |
`` | This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present. Accepted format: * yyyy- * yyyy- * yyyy- * yyyy- * yyyy- Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive. |
||
last |
`` | This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive. | ||
status |
`` | The status of the document. (Values: Hold, PendingApproval, Approved, Rejected, Released) |
Table Columns
The columns of the table ExpenseClaimDetails 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. | |
amount |
double |
itgen_vnet_amountinclaimcurr | writable, amount |
Amount in claim currency > The amount claimed by the employee, which is expressed in the currency of the expense claim. | |
approval |
datetime |
Approval Date | filters on the platform, writable, ::ancestor. |
The top part > Approval date > The date when the claim was approved. | |
approval |
varchar2 |
Approval Status | writable, approval |
Approval status > The approval status, which indicates whether the detail row requires approval and, if it does, what the current state of approval is. | |
approval |
varchar2 |
Approval Status Text | writable, approval |
Last approval comment > The approval status text suitable for display | |
approval |
varchar2 |
Approval Status Text 2 | filters on the platform, writable, ::ancestor. |
The top part > Approval status > A text field. | |
approval |
varchar2 |
Approval Status 2 | filters on the platform, writable, ::ancestor. |
The top part > Approval status > The status of the claim in Approval. | |
approver |
varchar2 |
Approver | writable, approver |
Pending approver > 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. | |
ar |
varchar2 |
itgen_vnet_arreferencenbr | writable, ar |
REef.no. customer > The reference number of the customer ledger document. | |
branch_ |
varchar2 |
Branch Name | writable, branch. |
Click the magnifier. > The name. | |
branch_ |
varchar2 |
Branch Number | writable, branch. |
Click the magnifier. > The identifier. | |
claim |
double |
Claim Amount | writable, claim |
Claim amount > The amount claimed by the employee, which is calculated as the total claim amount minus the employee part. | |
claim |
int32 |
Claim Detail ID | writable, claim |
Identifies the expense claim detail id, necessary when updating detail information | |
claim |
double |
Claim Total | filters on the platform, writable, ::ancestor. |
The top part > Claim total > The total amount of the claim. | |
claimed |
varchar2 |
Claimed by - Internal ID | filters on the platform, writable, ::ancestor. |
||
claimed |
varchar2 |
Claimed by - Name | filters on the platform, writable, ::ancestor. |
The name of the particular destination of the selected type. | |
claimed |
varchar2 |
Claimed by - Number | filters on the platform, writable, ::ancestor. |
The identifier of the particular destination of the selected type. | |
currency |
varchar2 |
Currency | writable, currency |
Currency > 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_ |
varchar2 |
itgen_vnet_currency_2 | filters on the platform, writable, ::ancestor. |
The top part > Currency > The currency of the claim. | |
customer_ |
varchar2 |
Customer Name | writable, customer. |
Click the magnifier. > The name. | |
customer_ |
varchar2 |
itgen_vnet_customer_name_2 | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The name. | |
customer_ |
varchar2 |
Customer Number | writable, customer. |
||
customer_ |
varchar2 |
itgen_vnet_customer_number_2 | filters on the platform, writable, ::ancestor. |
||
date |
datetime |
Date | writable, date |
Mandatory field: Date > The date when the expense was incurred. | |
date_2 |
datetime |
itgen_vnet_date_2 | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Date* > The date when the claim was entered. | |
department_ |
varchar2 |
Department Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
department_ |
varchar2 |
Department ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
description |
varchar2 |
Description | writable, description |
Mandatory field: Description* > A description of the transaction. | |
description_ |
varchar2 |
Description 2 | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Description > A description of the claim. | |
employee |
double |
itgen_vnet_employeepart | writable, employee |
Employee part > The part of the total amount that will not be paid back to the employee. The percentage depends on the company policy. | |
error |
varchar2 |
Error Message | filters on the platform, writable, ::ancestor. |
||
expense |
char |
itgen_vnet_expenseaccount_active | writable, expense |
||
expense |
varchar2 |
Expense Account Description | writable, expense |
Name of item/description | |
expense |
varchar2 |
itgen_vnet_expenseaccount_externalcode1 | writable, expense |
Account class > The identifier of the account class. | |
expense |
varchar2 |
itgen_vnet_expenseaccount_externalcode2 | writable, expense |
Account class > The name of the account class. | |
expense |
varchar2 |
Expense Account Number | writable, expense |
Number of item | |
expense |
varchar2 |
Expense Account Type | writable, expense |
Account > The account number. | |
expense |
varchar2 |
itgen_vnet_expenseitem_description | writable, expense |
Name of item/description | |
expense |
varchar2 |
itgen_vnet_expenseitem_number | writable, expense |
Number of item | |
expense |
char |
itgen_vnet_expensesubaccount_active | writable, expense |
||
expense |
varchar2 |
itgen_vnet_expensesubaccount_description | writable, expense |
Click on the magnifier. > The description. | |
expense |
varchar2 |
itgen_vnet_expensesubaccount_id | writable, expense |
Click on the magnifier. > The identifier. | |
invoiceable |
char |
Invoiceable | writable, invoiceable |
Invoicable > A check box that, if selected, indicates that the claim amount is invoiceable to the customer (the total amount minus the employee's part). | |
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
System generated information: The lastest time the expense claim was modified | |
lineId |
guid |
Line Identifier | writable, lineId |
The expense claim line id | |
location_ |
varchar2 |
Location Description | writable, location. |
Click on the magnifier. > The description. | |
location_ |
varchar2 |
itgen_vnet_location_description_2 | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
location_ |
varchar2 |
Location ID | writable, location. |
Click on the magnifier. > The identifier. | |
location_ |
varchar2 |
Location ID 2 | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, ::ancestor. |
||
project |
varchar2 |
Project Task Description | writable, project |
Click on the magnifier. > The description. | |
project |
varchar2 |
Project Task ID | writable, project |
Click on the magnifier. > The identifier. | |
project |
int32 |
itgen_vnet_projecttask_internalid | writable, project |
The internal identifier. | |
project_ |
varchar2 |
Project Description | writable, project. |
Click on the magnifier. > The description. | |
project_ |
varchar2 |
Project ID | writable, project. |
Click on the magnifier. > The identifier. | |
project_ |
int32 |
itgen_vnet_project_internalid | writable, project. |
The internal identifier. | |
quantity |
double |
Quantity | writable, quantity |
Quantity > The quantity of this expense item. | |
refNbr |
varchar2 |
Reference Number | writable, refNbr |
Ref. no. > The identifier of the transaction. | |
ref |
varchar2 |
itgen_vnet_refnbr_2 | filters on the platform, writable, ::ancestor. |
The top part > Ref. no. > The unique reference number of the expense claim document. | |
sales |
char |
itgen_vnet_salesaccount_active | writable, sales |
||
sales |
varchar2 |
Sales Account Description | writable, sales |
Name of item/description | |
sales |
varchar2 |
itgen_vnet_salesaccount_externalcode1 | writable, sales |
Account class > The identifier of the account class. | |
sales |
varchar2 |
itgen_vnet_salesaccount_externalcode2 | writable, sales |
Account class > The name of the account class. | |
sales |
varchar2 |
Sales Account Number | writable, sales |
Number of item | |
sales |
varchar2 |
Sales Account Type | writable, sales |
Account > The account number. | |
sales |
char |
itgen_vnet_salessubaccount_active | writable, sales |
||
sales |
varchar2 |
itgen_vnet_salessubaccount_description | writable, sales |
Click on the magnifier. > The description. | |
sales |
varchar2 |
itgen_vnet_salessubaccount_id | writable, sales |
Click on the magnifier. > The identifier. | |
status |
varchar2 |
Status | filters on the platform, writable, ::ancestor. |
The top part > Status > The current status of the expense claim: On Hold/Pending Approval/Approved/Rejected/Released. | |
tax |
varchar2 |
itgen_vnet_taxcategory_description | writable, tax |
Name of item/description | |
tax |
varchar2 |
itgen_vnet_taxcategory_number | writable, tax |
Number of item | |
time |
blob |
Timestamp | filters on the platform, writable, ::ancestor. |
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) | |
total |
double |
Total Amount | writable, total |
Amount > The total amount paid for the expense item in the specified quantity. | |
unit |
double |
Unit Cost | writable, unit |
Unit cost > The cost of a unit of the item. | |
uom |
varchar2 |
Unit of Measure | writable, uom |
Mandatory field: UoM > The unit of measure in which the quantity is shown. | |
vat |
double |
VAT Exempt Total | filters on the platform, writable, ::ancestor. |
The top part > VAT exempt total > The document total that is exempt from VAT. | |
vat |
double |
VAT Taxable Total | filters on the platform, writable, ::ancestor. |
The top part > VAT taxable total > The document total that is subjected to VAT. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Expense |
branch_ |
Branches. |
Key | |
Expense |
customer_ |
Customers. |
Key | |
Expense |
expense |
Accounts. |
Key | |
Expense |
sales |
Accounts. |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: