invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectTaskEmployees2: Visma.net Financials Project Task Employees

read only REST

  • Catalog: VismaNet
  • Schema: Project
  • Label: Project Task Employees

Get all tasks for a project

Can only retrieve data.

API Source

  • Endpoint: /v1/project/tasks
  • Operation: get /v1/project/tasks

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
createdDateTime `` This value, generated by the system, indicates the creation date and time. Use it to retrieve all records that have been created 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: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive.
createdDateTimeCondition `` 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: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive.
description `` Identifies the Project task description
expandAttribute `` Expands project atributes
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.
projectId `` Identifies the Project
projectInternalId `` Identifies the project by internal id
publicId `` Identifies the project by publicId
restrictedEmployee `` Id of the employee where access restrictions apply
restrictedUser `` Id of the Odp User where access restrictions apply
status `` The status of the document. (Values: Planned, Active, Cancelled, Canceled, Completed)
taskCd `` Identifies the Project task ID
taskCdDesc `` Identifies the Project task ID and description
visibleInAp `` If the project task is visible in the Supplier ledger
visibleInAr `` If the project task is visible in the Customer ledger
visibleInCa `` If the project task is visible in the Cash management workspace
visibleInCr `` If the project task is visible in the CRM workspace
visibleInEa `` If the project task is visible in the Expense workspace
visibleInGl `` If the project task is visible in the General ledger workspace
visibleInIn `` If the project task is visible in the Inventory workspace
visibleInPo `` If the project task is visible in the Purchases workspace
visibleInSo `` If the project task is visible in the Sales workspace
visibleInTa `` If the project task is visible in the Time entities workspace

Table Columns

The columns of the table ProjectTaskEmployees2 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.
address_addressId int32 Address ID writable, address.addressId
address_addressLine1 varchar2 Address Line 1 writable, 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, address.addressLine2 Address 2 > The second line of the address.
address_addressLine3 varchar2 Address Line 3 writable, address.addressLine3 Address 3 > The third line of the address.
address_city varchar2 City writable, address.city City > The city.
address_country_errorInfo varchar2 itgen_vnet_address_country_errorinfo writable, address.country.errorInfo
address_country_id varchar2 Country ID writable, 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, address.country.metadata.maxPageSize
address_country_metadata_totalCount int64 itgen_vnet_address_country_metadata_totalcount writable, address.country.metadata.totalCount
address_country_name varchar2 Country Name writable, address.country.name Mandatory field: Country name* > The complete name of the country.
address_county_id varchar2 County ID writable, address.county.id Click the magnifier > The identifier
address_county_name varchar2 County Name writable, address.county.name Click the magnifier > The displayed name
address_postalCode varchar2 Postal Code writable, address.postalCode Postcode > The postcode.
branch_name varchar2 Branch Name writable, branch.name Click the magnifier. > The name.
branch_name_2 varchar2 Branch Name 2 filters on the platform, writable, ::ancestor.branch.name Click the magnifier. > The name.
branch_number varchar2 Branch Number writable, branch.number Click the magnifier. > The identifier.
branch_number_2 varchar2 Branch Number 2 filters on the platform, writable, ::ancestor.branch.number Click the magnifier. > The identifier.
calendarID varchar2 Calendar ID writable, calendarID
contact_attention varchar2 itgen_vnet_contact_attention writable, 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, contact.contactId
contact_email varchar2 Contact Email writable, contact.email Email > The email address of the customer/supplier/company as a business entity.
contact_employeeContact varchar2 Contact Employee Contact writable, contact.employeeContact Employee contact > The link to the contact record associated with the employee.
contact_fax varchar2 Contact Fax writable, contact.fax Fax > The fax number.
contact_firstName varchar2 Contact First Name writable, contact.firstName First name > The first name of the employee.
contact_lastName varchar2 Contact Last Name writable, contact.lastName Mandatory field: Last name* > The last name of the employee.
contact_midName varchar2 Contact Middle Name writable, contact.midName Middle name > The middle name of the employee.
contact_name varchar2 Contact Name writable, contact.name Name > The legal name of to appear on the documents.
contact_phone1 varchar2 Contact Phone 1 writable, contact.phone1 Phone 1 > The default phone number.
contact_phone2 varchar2 Contact Phone 2 writable, contact.phone2 Phone 2 > An additional phone number.
contact_phone3 varchar2 Contact Phone 3 writable, contact.phone3 Phone 3 > An additional phone number of the employee.
contact_title varchar2 Contact Title writable, contact.title Title > The courtesy title to be used for the employee.
contact_web varchar2 Contact Website writable, contact.web Web > The website of the company, if one exists.
createdDateTime datetime Created filters on the platform, writable, ::ancestor.createdDateTime Information collected from the system. Not visible on the screen.
defAccount_description varchar2 Default Account Description filters on the platform, writable, ::ancestor.defAccount.description Name of item/description
defAccount_number varchar2 Default Account Number filters on the platform, writable, ::ancestor.defAccount.number Number of item
defAccount_type varchar2 Default Account Type filters on the platform, writable, ::ancestor.defAccount.type
defAccrualAccount_description varchar2 Default Accrual Account Description filters on the platform, writable, ::ancestor.defAccrualAccount.description Name of item/description
defAccrualAccount_number varchar2 Default Accrual Account Number filters on the platform, writable, ::ancestor.defAccrualAccount.number Number of item
defAccrualAccount_type varchar2 Default Accrual Account Type filters on the platform, writable, ::ancestor.defAccrualAccount.type
defAccrualSub_active char Default Accrual Account Sub Active filters on the platform, writable, ::ancestor.defAccrualSub.active
defAccrualSub_description varchar2 Default Accrual Account Sub Description filters on the platform, writable, ::ancestor.defAccrualSub.description Click on the magnifier. > The description.
defAccrualSub_id varchar2 Default Accrual Account Sub ID filters on the platform, writable, ::ancestor.defAccrualSub.id Click on the magnifier. > The identifier.
defSub_active char Default Sub Active filters on the platform, writable, ::ancestor.defSub.active
defSub_description varchar2 Default Sub Description filters on the platform, writable, ::ancestor.defSub.description Click on the magnifier. > The description.
defSub_id varchar2 Default Sub ID filters on the platform, writable, ::ancestor.defSub.id Click on the magnifier. > The identifier.
department varchar2 Department writable, department Mandatory field: General information tab > Employee section > Department* > The department the employee works for.
description varchar2 Description filters on the platform, writable, ::ancestor.description Mandatory field: Description > The description of the task.
employeeClass_description varchar2 Employee Class Description writable, employeeClass.description Click on the magnifier. > The description.
employeeClass_id varchar2 Employee Class ID writable, employeeClass.id Click on the magnifier. > The identifier.
employeeId int32 Employee ID writable, 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, employeeLogin
employeeName varchar2 Employee Name writable, employeeName The top part > Employee name > The name of this employee.
employeeNumber varchar2 Employee Number writable, employeeNumber General information tab > Employee settings section > Employee ref. no. > A reference number for the employee.
employeeUserId guid Employee User ID writable, employeeUserId Employee internal user ID. This is the ID of the user linked to the employee
endDate datetime End Date filters on the platform, writable, ::ancestor.endDate End date > The date when the task was actually finished.
errorInfo varchar2 Error Message writable, errorInfo
internalId int32 Internal ID filters on the platform, writable, ::ancestor.internalId Internal ID* > The internal ID of the task.
lastModifiedDateTime datetime Last Modified writable, lastModifiedDateTime
lastModifiedDateTime_2 datetime Last Modified Date/Time 2 filters on the platform, writable, ::ancestor.lastModifiedDateTime Information collected from system.
metadata_maxPageSize int64 Metadata Max Pagesize writable, metadata.maxPageSize
metadata_totalCount int64 Total Count writable, metadata.totalCount
plannedEnd datetime itgen_vnet_plannedend filters on the platform, writable, ::ancestor.plannedEnd
plannedStart datetime itgen_vnet_plannedstart filters on the platform, writable, ::ancestor.plannedStart
projectInternalId int32 itgen_vnet_projectinternalid filters on the platform, writable, ::ancestor.projectInternalId Project Internal ID* > The internal ID of the project.
rateTable_description varchar2 Rate Table Description filters on the platform, writable, ::ancestor.rateTable.description Click on the magnifier. > The description.
rateTable_id varchar2 Rate Table ID filters on the platform, writable, ::ancestor.rateTable.id Click on the magnifier. > The identifier.
restrictEmployees char Restrict Employees filters on the platform, writable, ::ancestor.restrictEmployees Summary tab > Task properties section > Restrict employees > A check box that indicates (if selected) that only the employees listed on the Employees tab of this window can create activities and documents associated with the current task.
startDate datetime Start Date filters on the platform, writable, ::ancestor.startDate Start date > The date when the task was actually started.
status varchar2 Status writable, 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.status Mandatory field: Status* > The status of the task, which can be one of the following: In planning, Active, Cancelled, Completed.
taskId varchar2 Task ID filters on the platform, writable, ::ancestor.taskId Mandatory field: > Task ID* > The ID of the task.
taxCategory_description varchar2 itgen_vnet_taxcategory_description filters on the platform, writable, ::ancestor.taxCategory.description Name of item/description
taxCategory_number varchar2 itgen_vnet_taxcategory_number filters on the platform, writable, ::ancestor.taxCategory.number Number of item
timeStamp blob Timestamp writable, 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.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)
visibility_visibleInAp char itgen_vnet_visibility_visibleinap filters on the platform, writable, ::ancestor.visibility.visibleInAp Supplier ledger
visibility_visibleInAr char itgen_vnet_visibility_visibleinar filters on the platform, writable, ::ancestor.visibility.visibleInAr Customer ledger
visibility_visibleInCa char itgen_vnet_visibility_visibleinca filters on the platform, writable, ::ancestor.visibility.visibleInCa Cash management
visibility_visibleInCr char itgen_vnet_visibility_visibleincr filters on the platform, writable, ::ancestor.visibility.visibleInCr
visibility_visibleInEa char itgen_vnet_visibility_visibleinea filters on the platform, writable, ::ancestor.visibility.visibleInEa Expenses
visibility_visibleInGl char itgen_vnet_visibility_visibleingl filters on the platform, writable, ::ancestor.visibility.visibleInGl General ledger
visibility_visibleInIn char itgen_vnet_visibility_visibleinin filters on the platform, writable, ::ancestor.visibility.visibleInIn Inventory
visibility_visibleInPo char itgen_vnet_visibility_visibleinpo filters on the platform, writable, ::ancestor.visibility.visibleInPo Purchases
visibility_visibleInSo char itgen_vnet_visibility_visibleinso filters on the platform, writable, ::ancestor.visibility.visibleInSo Sales
visibility_visibleInTa char itgen_vnet_visibility_visibleinta filters on the platform, writable, ::ancestor.visibility.visibleInTa Time entries

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: