ProjectTaskAttributesByInternalId: Visma.net Financials itgen_vnet_projecttaskattributesbyinternalid_plural
read only REST
- Catalog:
VismaNet - Schema:
ProjectTask - Label: itgen_vnet_projecttaskattributesbyinternalid_plural
Get project task information by internal id. Data for a single project task. The response headers include an ETag after a successful GET operation.
Can only retrieve data.
Summary
Data for a single project task.
The response headers include an ETag after a successful GET operation.
API Source
- Endpoint:
/v1/projecttask/{internalId} - Operation:
get /v1/projecttask/{internalId}
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 |
|---|---|---|---|---|
internal |
`` | The organisation code. |
Table Columns
The columns of the table ProjectTaskAttributesByInternalId 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. | |
branch_ |
varchar2 |
Branch Name | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The name. | |
branch_ |
varchar2 |
Branch Number | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The identifier. | |
created |
datetime |
Created | filters on the platform, writable, ::ancestor. |
Information collected from the system. Not visible on the screen. | |
def |
varchar2 |
Default Account Description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
def |
varchar2 |
Default Account Number | filters on the platform, writable, ::ancestor. |
Number of item | |
def |
varchar2 |
Default Account Type | filters on the platform, writable, ::ancestor. |
||
def |
varchar2 |
Default Accrual Account Description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
def |
varchar2 |
Default Accrual Account Number | filters on the platform, writable, ::ancestor. |
Number of item | |
def |
varchar2 |
Default Accrual Account Type | filters on the platform, writable, ::ancestor. |
||
def |
char |
Default Accrual Account Sub Active | filters on the platform, writable, ::ancestor. |
||
def |
varchar2 |
Default Accrual Account Sub Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
def |
varchar2 |
Default Accrual Account Sub ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
def |
char |
Default Sub Active | filters on the platform, writable, ::ancestor. |
||
def |
varchar2 |
Default Sub Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
def |
varchar2 |
Default Sub ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
description |
varchar2 |
Description | writable, description |
Attribute > The description of the attribute. | |
description_ |
varchar2 |
Description 2 | filters on the platform, writable, ::ancestor. |
Mandatory field: Description > The description of the task. | |
end |
datetime |
End Date | filters on the platform, writable, ::ancestor. |
End date > The date when the task was actually finished. | |
id |
varchar2 |
ID | writable, id |
||
internal |
int32 |
Internal ID | filters on the platform, writable, ::ancestor. |
Internal ID* > The internal ID of the task. | |
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
Information collected from system. | |
planned |
datetime |
itgen_vnet_plannedend | filters on the platform, writable, ::ancestor. |
||
planned |
datetime |
itgen_vnet_plannedstart | filters on the platform, writable, ::ancestor. |
||
project |
int32 |
itgen_vnet_projectinternalid | filters on the platform, writable, ::ancestor. |
Project Internal ID* > The internal ID of the project. | |
rate |
varchar2 |
Rate Table Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
rate |
varchar2 |
Rate Table ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
restrict |
char |
Restrict Employees | filters on the platform, writable, ::ancestor. |
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. | |
start |
datetime |
Start Date | filters on the platform, writable, ::ancestor. |
Start date > The date when the task was actually started. | |
status |
varchar2 |
Status | filters on the platform, writable, ::ancestor. |
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. |
Mandatory field: > Task ID* > The ID of the task. | |
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 | |
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) | |
value |
varchar2 |
Value | writable, value |
Value > The value of the attribute. | |
visibility_ |
char |
itgen_vnet_visibility_visibleinap | filters on the platform, writable, ::ancestor. |
Supplier ledger | |
visibility_ |
char |
itgen_vnet_visibility_visibleinar | filters on the platform, writable, ::ancestor. |
Customer ledger | |
visibility_ |
char |
itgen_vnet_visibility_visibleinca | filters on the platform, writable, ::ancestor. |
Cash management | |
visibility_ |
char |
itgen_vnet_visibility_visibleincr | filters on the platform, writable, ::ancestor. |
||
visibility_ |
char |
itgen_vnet_visibility_visibleinea | filters on the platform, writable, ::ancestor. |
Expenses | |
visibility_ |
char |
itgen_vnet_visibility_visibleingl | filters on the platform, writable, ::ancestor. |
General ledger | |
visibility_ |
char |
itgen_vnet_visibility_visibleinin | filters on the platform, writable, ::ancestor. |
Inventory | |
visibility_ |
char |
itgen_vnet_visibility_visibleinpo | filters on the platform, writable, ::ancestor. |
Purchases | |
visibility_ |
char |
itgen_vnet_visibility_visibleinso | filters on the platform, writable, ::ancestor. |
Sales | |
visibility_ |
char |
itgen_vnet_visibility_visibleinta | filters on the platform, writable, ::ancestor. |
Time entries |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: