invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectTaskAttributes2: Visma.net Financials itgen_vnet_projecttaskattributes_plural

read only REST

  • Catalog: VismaNet
  • Schema: Project
  • Label: itgen_vnet_projecttaskattributes_plural

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 ProjectTaskAttributes2 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.
branch_name varchar2 Branch Name filters on the platform, writable, ::ancestor.branch.name Click the magnifier. > The name.
branch_number varchar2 Branch Number filters on the platform, writable, ::ancestor.branch.number Click the magnifier. > The identifier.
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.
description varchar2 Description writable, description Attribute > The description of the attribute.
description_2 varchar2 Description 2 filters on the platform, writable, ::ancestor.description Mandatory field: Description > The description of the task.
endDate datetime End Date filters on the platform, writable, ::ancestor.endDate End date > The date when the task was actually finished.
id varchar2 ID writable, id
internalId int32 Internal ID filters on the platform, writable, ::ancestor.internalId Internal ID* > The internal ID of the task.
lastModifiedDateTime datetime Last Modified filters on the platform, writable, ::ancestor.lastModifiedDateTime Information collected from system.
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 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 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)
value varchar2 Value writable, value Value > The value of the attribute.
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: