ExpenseReceiptClaimsByWorkGroupDescription: Visma.net Financials itgen_vnet_expensereceiptclaimsbyworkgroupdescription_plural
read only REST
- Catalog:
VismaNet - Schema:
ExpenseReceipt - Label: itgen_vnet_expensereceiptclaimsbyworkgroupdescription_plural
Get a range of Expense Receipts, a filter needs to be specified. ScreenId=EP301020
Can only retrieve data.
API Source
- Endpoint:
/v1/expenseReceipt - Operation:
get /v1/expenseReceipt
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 |
|---|---|---|---|---|
claimed |
`` | Identifies the employee from the document | ||
customer |
`` | Identifies the customer from the document | ||
date |
`` | The date of the document | ||
date |
`` | |||
inventory |
`` | Identifies the inventory item from the document | ||
invoiceable |
`` | If the document is invoiceable | ||
project |
`` | Identifies the project from the document | ||
project |
`` | Filter on Task ID. | ||
status |
`` | The status of the document. (Values: Open, Pending, Approved, Rejected, Released) |
Table Columns
The columns of the table ExpenseReceiptClaimsByWorkGroupDescription 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. | |
TEXT |
varchar2 |
itgen_vnet_text | writable, ::self |
||
address_ |
int32 |
Address ID | writable, ::ancestor. |
||
address_ |
varchar2 |
Address Line 1 | writable, ::ancestor. |
Address 1 > The first line of the customer's/supplier's/company's/employee's contact address. | |
address_ |
varchar2 |
Address Line 2 | writable, ::ancestor. |
Address 2 > The second line of the address. | |
address_ |
varchar2 |
Address Line 3 | writable, ::ancestor. |
Address 3 > The third line of the address. | |
address_ |
varchar2 |
City | writable, ::ancestor. |
City > The city. | |
address_ |
varchar2 |
itgen_vnet_address_country_errorinfo | writable, ::ancestor. |
||
address_ |
varchar2 |
Country ID | writable, ::ancestor. |
Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166. | |
address_ |
int64 |
itgen_vnet_address_country_metadata_maxpagesize | writable, ::ancestor. |
||
address_ |
int64 |
itgen_vnet_address_country_metadata_totalcount | writable, ::ancestor. |
||
address_ |
varchar2 |
Country Name | writable, ::ancestor. |
Mandatory field: Country name* > The complete name of the country. | |
address_ |
varchar2 |
County ID | writable, ::ancestor. |
Click the magnifier > The identifier | |
address_ |
varchar2 |
County Name | writable, ::ancestor. |
Click the magnifier > The displayed name | |
address_ |
varchar2 |
Postal Code | writable, ::ancestor. |
Postcode > The postcode. | |
branch_ |
varchar2 |
Branch Name | writable, ::ancestor. |
Click the magnifier. > The name. | |
branch_ |
varchar2 |
Branch Name 2 | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The name. | |
branch_ |
varchar2 |
Branch Number | writable, ::ancestor. |
Click the magnifier. > The identifier. | |
branch_ |
varchar2 |
Branch Number 2 | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The identifier. | |
calendar |
varchar2 |
Calendar ID | writable, ::ancestor. |
||
claim |
double |
Claim Amount | filters on the platform, writable, ::ancestor. |
Receipt details tab > Expense details section > Expense claim > The expense claim with which the expense receipt is associated. | |
contact_ |
varchar2 |
itgen_vnet_contact_attention | writable, ::ancestor. |
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_ |
int32 |
Contact ID | writable, ::ancestor. |
||
contact_ |
varchar2 |
Contact Email | writable, ::ancestor. |
Email > The email address of the customer/supplier/company as a business entity. | |
contact_ |
varchar2 |
Contact Employee Contact | writable, ::ancestor. |
Employee contact > The link to the contact record associated with the employee. | |
contact_ |
varchar2 |
Contact Fax | writable, ::ancestor. |
Fax > The fax number. | |
contact_ |
varchar2 |
Contact First Name | writable, ::ancestor. |
First name > The first name of the employee. | |
contact_ |
varchar2 |
Contact Last Name | writable, ::ancestor. |
Mandatory field: Last name* > The last name of the employee. | |
contact_ |
varchar2 |
Contact Middle Name | writable, ::ancestor. |
Middle name > The middle name of the employee. | |
contact_ |
varchar2 |
Contact Name | writable, ::ancestor. |
Name > The legal name of to appear on the documents. | |
contact_ |
varchar2 |
Contact Phone 1 | writable, ::ancestor. |
Phone 1 > The default phone number. | |
contact_ |
varchar2 |
Contact Phone 2 | writable, ::ancestor. |
Phone 2 > An additional phone number. | |
contact_ |
varchar2 |
Contact Phone 3 | writable, ::ancestor. |
Phone 3 > An additional phone number of the employee. | |
contact_ |
varchar2 |
Contact Title | writable, ::ancestor. |
Title > The courtesy title to be used for the employee. | |
contact_ |
varchar2 |
Contact Website | writable, ::ancestor. |
Web > The website of the company, if one exists. | |
currency_ |
varchar2 |
Currency Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
currency_ |
varchar2 |
Currency ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
customer_ |
varchar2 |
Customer Name | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The name. | |
customer_ |
varchar2 |
Customer Number | filters on the platform, writable, ::ancestor. |
||
date |
datetime |
Date | filters on the platform, writable, ::ancestor. |
Both tabs > Date > The date of the expense receipt. | |
department |
varchar2 |
Department | writable, ::ancestor. |
Mandatory field: General information tab > Employee section > Department* > The department the employee works for. | |
description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
Open the receipt Mandatory field: Receipt details tab > Expense details section > Description* > The expense description, which is displayed as a link. | |
employee |
varchar2 |
Employee Class Description | writable, ::ancestor. |
Click on the magnifier. > The description. | |
employee |
varchar2 |
Employee Class ID | writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
employee |
int32 |
Employee ID | writable, ::ancestor. |
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. | |
employee |
varchar2 |
Employee Login | writable, ::ancestor. |
||
employee |
varchar2 |
Employee Name | writable, ::ancestor. |
The top part > Employee name > The name of this employee. | |
employee |
varchar2 |
Employee Number | writable, ::ancestor. |
General information tab > Employee settings section > Employee ref. no. > A reference number for the employee. | |
employee |
double |
itgen_vnet_employeepart | filters on the platform, writable, ::ancestor. |
Receipt details tab > Expense details section > Employee part > The part of the total amount that will not be paid back to the employee. | |
employee |
guid |
Employee User ID | writable, ::ancestor. |
Employee internal user ID. This is the ID of the user linked to the employee | |
error |
varchar2 |
Error Message | writable, ::ancestor. |
||
expense |
varchar2 |
Expense Account Description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
expense |
varchar2 |
Expense Account Number | filters on the platform, writable, ::ancestor. |
Number of item | |
expense |
varchar2 |
Expense Account Type | filters on the platform, writable, ::ancestor. |
||
expense |
varchar2 |
Expense Claim Description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
expense |
varchar2 |
Expense Claim Number | filters on the platform, writable, ::ancestor. |
Number of item | |
expense |
char |
itgen_vnet_expensesub_active | filters on the platform, writable, ::ancestor. |
||
expense |
varchar2 |
itgen_vnet_expensesub_description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
expense |
varchar2 |
itgen_vnet_expensesub_id | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
image_ |
guid |
Image ID | filters on the platform, writable, ::ancestor. |
The ID of the attachment | |
image_ |
varchar2 |
Image Name | filters on the platform, writable, ::ancestor. |
The name of the attachment. | |
image_ |
int32 |
Image Revision | filters on the platform, writable, ::ancestor. |
The version of the attachment. | |
internal |
int32 |
Internal ID | filters on the platform, writable, ::ancestor. |
||
inventory_ |
varchar2 |
Inventory Description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
inventory_ |
varchar2 |
Inventory Number | filters on the platform, writable, ::ancestor. |
Number of item | |
invoiceable |
char |
Invoiceable | filters on the platform, writable, ::ancestor. |
Receipt details tab > Financial details section > Invoiceable > A check box that indicates (if selected) that the customer should be invoiced for the claim amount. | |
last |
datetime |
Last Modified | writable, ::ancestor. |
||
location_ |
varchar2 |
Location Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
location_ |
varchar2 |
Location ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
metadata_ |
int64 |
Metadata Max Pagesize | writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | writable, ::ancestor. |
||
project |
varchar2 |
Project Task Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
project |
varchar2 |
Project Task ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
project |
int32 |
itgen_vnet_projecttask_internalid | filters on the platform, writable, ::ancestor. |
The internal identifier. | |
project_ |
varchar2 |
Project Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
project_ |
varchar2 |
Project ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
project_ |
int32 |
itgen_vnet_project_internalid | filters on the platform, writable, ::ancestor. |
The internal identifier. | |
quantity |
double |
Quantity | filters on the platform, writable, ::ancestor. |
Receipt details tab > Expense details section > Quantity > The quantity of the expense item that the employee purchased according to the receipt. | |
receipt |
varchar2 |
Receipt ID | filters on the platform, writable, ::ancestor. |
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. |
Both tabs > Ref. no. > The reference number, which usually matches the number of the original receipt. | |
sales |
varchar2 |
Sales Account Description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
sales |
varchar2 |
Sales Account Number | filters on the platform, writable, ::ancestor. |
Number of item | |
sales |
varchar2 |
Sales Account Type | filters on the platform, writable, ::ancestor. |
||
sales |
char |
itgen_vnet_salessub_active | filters on the platform, writable, ::ancestor. |
||
sales |
varchar2 |
itgen_vnet_salessub_description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
sales |
varchar2 |
itgen_vnet_salessub_id | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
status |
varchar2 |
Status | writable, ::ancestor. |
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_ |
varchar2 |
itgen_vnet_status_2 | filters on the platform, writable, ::ancestor. |
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. | |
tax |
varchar2 |
itgen_vnet_taxcategory_description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
tax |
varchar2 |
itgen_vnet_taxcategory_number | filters on the platform, writable, ::ancestor. |
Number of item | |
tax |
double |
Tax Total | filters on the platform, writable, ::ancestor. |
The top part > VAT total > The total amount of VAT or taxes calculated for the expense receipt. | |
time |
blob |
Timestamp | 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) | |
time |
blob |
itgen_vnet_timestamp_2 | 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 | filters on the platform, writable, ::ancestor. |
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). | |
unit |
double |
Unit Cost | filters on the platform, writable, ::ancestor. |
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. |
Receipt details tab > Expense details section > UoM > The unit of measure of the expense item. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Expense |
branch_ |
Branches. |
Key | |
Expense |
currency_ |
Currencies.id |
Key | |
Expense |
customer_ |
Customers. |
Key | |
Expense |
expense |
Accounts. |
Key | |
Expense |
inventory_ |
InventoryItems. |
Key | |
Expense |
sales |
Accounts. |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: