invantive documentation
Invantive Support ForumsLog In / Sign Up

ExpenseClaimDetailAttachments: Visma.net Financials Expense Claim Detail Attachments

read only REST

  • Catalog: VismaNet
  • Schema: ExpenseClaim
  • Label: Expense Claim Detail Attachments

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
departmentId `` Identifies the department
greaterThanValue `` Greater-than value. The item which is the object for this, varies from API to API.
lastModifiedDateTime `` 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-MM-dd * yyyy-MM-dd HH:mm:ss * yyyy-MM-dd HH:mm:ss.FFF * yyyy-MM-ddTHH:mm:ss * yyyy-MM-ddTHH:mm:ss.FFF Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive.
lastModifiedDateTimeCondition `` 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 ExpenseClaimDetailAttachments 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.
amountInClaimCurr double itgen_vnet_amountinclaimcurr writable, ::ancestor.amountInClaimCurr Amount in claim currency > The amount claimed by the employee, which is expressed in the currency of the expense claim.
approvalDate datetime Approval Date filters on the platform, writable, ::ancestor.::ancestor.approvalDate The top part > Approval date > The date when the claim was approved.
approvalStatus varchar2 Approval Status writable, ::ancestor.approvalStatus Approval status > The approval status, which indicates whether the detail row requires approval and, if it does, what the current state of approval is.
approvalStatusText varchar2 Approval Status Text writable, ::ancestor.approvalStatusText Last approval comment > The approval status text suitable for display
approvalStatusText_2 varchar2 Approval Status Text 2 filters on the platform, writable, ::ancestor.::ancestor.approvalStatusText The top part > Approval status > A text field.
approvalStatus_2 varchar2 Approval Status 2 filters on the platform, writable, ::ancestor.::ancestor.approvalStatus The top part > Approval status > The status of the claim in Approval.
approver varchar2 Approver writable, ::ancestor.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.
arReferenceNbr varchar2 itgen_vnet_arreferencenbr writable, ::ancestor.arReferenceNbr REef.no. customer > The reference number of the customer ledger document.
branch_name varchar2 Branch Name writable, ::ancestor.branch.name Click the magnifier. > The name.
branch_number varchar2 Branch Number writable, ::ancestor.branch.number Click the magnifier. > The identifier.
claimAmount double Claim Amount writable, ::ancestor.claimAmount Claim amount > The amount claimed by the employee, which is calculated as the total claim amount minus the employee part.
claimDetailId int32 Claim Detail ID writable, ::ancestor.claimDetailId Identifies the expense claim detail id, necessary when updating detail information
claimTotal double Claim Total filters on the platform, writable, ::ancestor.::ancestor.claimTotal The top part > Claim total > The total amount of the claim.
claimedBy_internalId varchar2 Claimed by - Internal ID filters on the platform, writable, ::ancestor.::ancestor.claimedBy.internalId
claimedBy_name varchar2 Claimed by - Name filters on the platform, writable, ::ancestor.::ancestor.claimedBy.name The name of the particular destination of the selected type.
claimedBy_number varchar2 Claimed by - Number filters on the platform, writable, ::ancestor.::ancestor.claimedBy.number The identifier of the particular destination of the selected type.
currency varchar2 Currency writable, ::ancestor.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_2 varchar2 itgen_vnet_currency_2 filters on the platform, writable, ::ancestor.::ancestor.currency The top part > Currency > The currency of the claim.
customer_name varchar2 Customer Name writable, ::ancestor.customer.name Click the magnifier. > The name.
customer_name_2 varchar2 itgen_vnet_customer_name_2 filters on the platform, writable, ::ancestor.::ancestor.customer.name Click the magnifier. > The name.
customer_number varchar2 Customer Number writable, ::ancestor.customer.number
customer_number_2 varchar2 itgen_vnet_customer_number_2 filters on the platform, writable, ::ancestor.::ancestor.customer.number
date datetime Date writable, ::ancestor.date Mandatory field: Date > The date when the expense was incurred.
date_2 datetime itgen_vnet_date_2 filters on the platform, writable, ::ancestor.::ancestor.date Mandatory field: The top part > Date* > The date when the claim was entered.
department_description varchar2 Department Description filters on the platform, writable, ::ancestor.::ancestor.department.description Click on the magnifier. > The description.
department_id varchar2 Department ID filters on the platform, writable, ::ancestor.::ancestor.department.id Click on the magnifier. > The identifier.
description varchar2 Description writable, ::ancestor.description Mandatory field: Description* > A description of the transaction.
description_2 varchar2 Description 2 filters on the platform, writable, ::ancestor.::ancestor.description Mandatory field: The top part > Description > A description of the claim.
employeePart double itgen_vnet_employeepart writable, ::ancestor.employeePart Employee part > The part of the total amount that will not be paid back to the employee. The percentage depends on the company policy.
errorInfo varchar2 Error Message filters on the platform, writable, ::ancestor.::ancestor.errorInfo
expenseAccount_active char itgen_vnet_expenseaccount_active writable, ::ancestor.expenseAccount.active
expenseAccount_description varchar2 Expense Account Description writable, ::ancestor.expenseAccount.description Name of item/description
expenseAccount_externalCode1 varchar2 itgen_vnet_expenseaccount_externalcode1 writable, ::ancestor.expenseAccount.externalCode1 Account class > The identifier of the account class.
expenseAccount_externalCode2 varchar2 itgen_vnet_expenseaccount_externalcode2 writable, ::ancestor.expenseAccount.externalCode2 Account class > The name of the account class.
expenseAccount_number varchar2 Expense Account Number writable, ::ancestor.expenseAccount.number Number of item
expenseAccount_type varchar2 Expense Account Type writable, ::ancestor.expenseAccount.type Account > The account number.
expenseItem_description varchar2 itgen_vnet_expenseitem_description writable, ::ancestor.expenseItem.description Name of item/description
expenseItem_number varchar2 itgen_vnet_expenseitem_number writable, ::ancestor.expenseItem.number Number of item
expenseSubaccount_active char itgen_vnet_expensesubaccount_active writable, ::ancestor.expenseSubaccount.active
expenseSubaccount_description varchar2 itgen_vnet_expensesubaccount_description writable, ::ancestor.expenseSubaccount.description Click on the magnifier. > The description.
expenseSubaccount_id varchar2 itgen_vnet_expensesubaccount_id writable, ::ancestor.expenseSubaccount.id Click on the magnifier. > The identifier.
id guid ID writable, id The ID of the attachment
invoiceable char Invoiceable writable, ::ancestor.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).
lastModifiedDateTime datetime Last Modified filters on the platform, writable, ::ancestor.::ancestor.lastModifiedDateTime System generated information: The lastest time the expense claim was modified
lineId guid Line Identifier writable, ::ancestor.lineId The expense claim line id
location_description varchar2 Location Description writable, ::ancestor.location.description Click on the magnifier. > The description.
location_description_2 varchar2 itgen_vnet_location_description_2 filters on the platform, writable, ::ancestor.::ancestor.location.description Click on the magnifier. > The description.
location_id varchar2 Location ID writable, ::ancestor.location.id Click on the magnifier. > The identifier.
location_id_2 varchar2 Location ID 2 filters on the platform, writable, ::ancestor.::ancestor.location.id Click on the magnifier. > The identifier.
metadata_maxPageSize int64 Metadata Max Pagesize filters on the platform, writable, ::ancestor.::ancestor.metadata.maxPageSize
metadata_totalCount int64 Total Count filters on the platform, writable, ::ancestor.::ancestor.metadata.totalCount
name varchar2 Name writable, name The name of the attachment.
projectTask_description varchar2 Project Task Description writable, ::ancestor.projectTask.description Click on the magnifier. > The description.
projectTask_id varchar2 Project Task ID writable, ::ancestor.projectTask.id Click on the magnifier. > The identifier.
projectTask_internalId int32 itgen_vnet_projecttask_internalid writable, ::ancestor.projectTask.internalId The internal identifier.
project_description varchar2 Project Description writable, ::ancestor.project.description Click on the magnifier. > The description.
project_id varchar2 Project ID writable, ::ancestor.project.id Click on the magnifier. > The identifier.
project_internalId int32 itgen_vnet_project_internalid writable, ::ancestor.project.internalId The internal identifier.
quantity double Quantity writable, ::ancestor.quantity Quantity > The quantity of this expense item.
refNbr varchar2 Reference Number writable, ::ancestor.refNbr Ref. no. > The identifier of the transaction.
refNbr_2 varchar2 itgen_vnet_refnbr_2 filters on the platform, writable, ::ancestor.::ancestor.refNbr The top part > Ref. no. > The unique reference number of the expense claim document.
revision int32 Revision writable, revision The version of the attachment.
salesAccount_active char itgen_vnet_salesaccount_active writable, ::ancestor.salesAccount.active
salesAccount_description varchar2 Sales Account Description writable, ::ancestor.salesAccount.description Name of item/description
salesAccount_externalCode1 varchar2 itgen_vnet_salesaccount_externalcode1 writable, ::ancestor.salesAccount.externalCode1 Account class > The identifier of the account class.
salesAccount_externalCode2 varchar2 itgen_vnet_salesaccount_externalcode2 writable, ::ancestor.salesAccount.externalCode2 Account class > The name of the account class.
salesAccount_number varchar2 Sales Account Number writable, ::ancestor.salesAccount.number Number of item
salesAccount_type varchar2 Sales Account Type writable, ::ancestor.salesAccount.type Account > The account number.
salesSubaccount_active char itgen_vnet_salessubaccount_active writable, ::ancestor.salesSubaccount.active
salesSubaccount_description varchar2 itgen_vnet_salessubaccount_description writable, ::ancestor.salesSubaccount.description Click on the magnifier. > The description.
salesSubaccount_id varchar2 itgen_vnet_salessubaccount_id writable, ::ancestor.salesSubaccount.id Click on the magnifier. > The identifier.
status varchar2 Status filters on the platform, writable, ::ancestor.::ancestor.status The top part > Status > The current status of the expense claim: On Hold/Pending Approval/Approved/Rejected/Released.
taxCategory_description varchar2 itgen_vnet_taxcategory_description writable, ::ancestor.taxCategory.description Name of item/description
taxCategory_number varchar2 itgen_vnet_taxcategory_number writable, ::ancestor.taxCategory.number Number of item
timeStamp blob Timestamp 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 writable, ::ancestor.totalAmount Amount > The total amount paid for the expense item in the specified quantity.
unitCost double Unit Cost writable, ::ancestor.unitCost Unit cost > The cost of a unit of the item.
uom varchar2 Unit of Measure writable, ::ancestor.uom Mandatory field: UoM > The unit of measure in which the quantity is shown.
vatExemptTotal double VAT Exempt Total filters on the platform, writable, ::ancestor.::ancestor.vatExemptTotal The top part > VAT exempt total > The document total that is exempt from VAT.
vatTaxableTotal double VAT Taxable Total filters on the platform, writable, ::ancestor.::ancestor.vatTaxableTotal 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: