ProjectTaskAttributes: Visma.net Financials itgen_vnet_projecttaskattributes_plural
read only REST
- Catalog:
VismaNet - Schema:
Project - Label: itgen_vnet_projecttaskattributes_plural
Get a range of Projects - ScreenId=PM301000 The requested 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
Can only retrieve data.
API Source
- Endpoint:
/v1/project - Operation:
get /v1/project
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 |
|---|---|---|---|---|
attributes |
`` | Identifies the attributes | ||
branch |
`` | The branch name. | ||
created |
`` | 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- * yyyy- * yyyy- * yyyy- * yyyy- Note: CreatedDateTime and CreatedDateTimeCondition are mutually inclusive. |
||
created |
`` | 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. | ||
expand |
`` | Expands project atributes | ||
last |
`` | 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- * yyyy- * yyyy- * yyyy- * yyyy- Note: LastModifiedDateTime and LastModifiedDateTimeCondition are mutually inclusive. |
||
last |
`` | 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. | ||
non |
`` | Set to true to return the non-project. | ||
onHold |
`` | If the project is on hold | ||
public |
`` | Identifies the Project by its publicId | ||
restricted |
`` | ID of the employee where access restrictions apply | ||
restricted |
`` | Id of the odp user where access restrictions apply | ||
start |
`` | Project’s start date | ||
status |
`` | Use drop down and select Status. (Values: Planned, Active, Completed, Cancelled, OnHold, PendingApproval) | ||
system |
`` | If the project is a template | ||
task |
`` | Use drop down and select Status. (Values: Planned, Active, Cancelled, Canceled, Completed) | ||
task |
`` | If the project task is visible in the Supplier ledger | ||
task |
`` | If the project task is visible in the Customer ledger | ||
task |
`` | If the project task is visible in the Cash management workspace | ||
task |
`` | If the project task is visible in the CRM workspace | ||
task |
`` | If the project task is visible in the Expense workspace | ||
task |
`` | If the project task is visible in the General ledger workspace | ||
task |
`` | If the project task is visible in the Inventory workspace | ||
task |
`` | If the project task is visible in the Purchases workspace | ||
task |
`` | If the project task is visible in the Sales workspace | ||
task |
`` | If the project task is visible in the Time entities workspace | ||
visible |
`` | If the project is visible in AP |
Table Columns
The columns of the table ProjectTaskAttributes 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. | |
allocation |
char |
Allocation Rule Active | filters on the platform, writable, ::ancestor. |
||
allocation |
varchar2 |
Allocation Rule Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
allocation |
varchar2 |
Allocation Rule ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
assets |
double |
Assets | filters on the platform, writable, ::ancestor. |
The top part > Assest > The actual assets for the project. | |
auto |
char |
Auto Allocate | filters on the platform, writable, ::ancestor. |
Summary tab > Invoicing and allocation settings section > Run allocation when you release project transactions > A check box that indicates (if selected) that allocation is run automatically during the release of the documents associated with this project. | |
automatic |
char |
Automatic Release AR | filters on the platform, writable, ::ancestor. |
Summary tab > Invoicing and allocation settings section > Automatically release customer documents > A check box that indicates (if selected) that invoice documents are released automatically after the project invoicing is completed. | |
billing |
varchar2 |
Billing Period | filters on the platform, writable, ::ancestor. |
Summary tab > Invoicing and allocation settings section > Invoicing period > The frequency of invoicing, which can be one of the following options: Week, Month, Quarter, Year, On demand. | |
billing |
char |
Billing Rule Active | filters on the platform, writable, ::ancestor. |
||
billing |
varchar2 |
Billing Rule Description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
billing |
varchar2 |
Billing Rule ID | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
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. | |
customer |
int32 |
Customer Location ID | filters on the platform, writable, ::ancestor. |
Click the magnifier > The identifier | |
customer |
varchar2 |
Customer Location Name | filters on the platform, writable, ::ancestor. |
Click the magnifier > The displayed name | |
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. |
||
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 | writable, ::ancestor. |
Mandatory field: Description > The description of the task. | |
description_ |
varchar2 |
itgen_vnet_description_3 | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Description* > The description of the project. | |
end |
datetime |
End Date | writable, ::ancestor. |
End date > The date when the task was actually finished. | |
end |
datetime |
itgen_vnet_enddate_2 | filters on the platform, writable, ::ancestor. |
Summary tab > Project properties section > End date > The date when the project is expected to end. | |
error |
varchar2 |
Error Message | filters on the platform, writable, ::ancestor. |
||
expenses |
double |
Expenses | filters on the platform, writable, ::ancestor. |
The top part > Expenses > The total of the current expenses incurred by the project. | |
hold |
char |
Hold | filters on the platform, writable, ::ancestor. |
The top part > Hold > A check box that you select to indicate that the project should have the In planning status. | |
id |
varchar2 |
ID | writable, id |
||
income |
double |
Income | filters on the platform, writable, ::ancestor. |
The top part > Income > The income expected from the project. | |
internal |
int32 |
Internal ID | filters on the platform, writable, ::ancestor. |
||
last |
datetime |
Last Billing Date | filters on the platform, writable, ::ancestor. |
Summary tab > Invoicing and allocation settings section > Last invoicing date > The date when the latest invoicing was performed for the project. | |
last |
datetime |
Last Modified | filters on the platform, writable, ::ancestor. |
System generated information | |
liability |
double |
Liability | filters on the platform, writable, ::ancestor. |
The top part > Liabilities > The actual liabilities for the project. | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, ::ancestor. |
||
next |
datetime |
Next Billing Date | filters on the platform, writable, ::ancestor. |
Summary tab > Invoicing and allocation settings section > Next invoicing date > The date for which the next invoicing is scheduled for the project. | |
note |
varchar2 |
Note | filters on the platform, writable, ::ancestor. |
The note on the project. | |
planned |
datetime |
itgen_vnet_plannedend | writable, ::ancestor. |
||
planned |
datetime |
itgen_vnet_plannedstart | writable, ::ancestor. |
||
project |
varchar2 |
Project ID | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Project ID* > The unique ID for the project. | |
project |
int32 |
itgen_vnet_projectmanager_address_addressid | filters on the platform, writable, ::ancestor. |
||
project |
varchar2 |
itgen_vnet_projectmanager_address_addressline1 | filters on the platform, writable, ::ancestor. |
Address 1 > The first line of the customer's/supplier's/company's/employee's contact address. | |
project |
varchar2 |
itgen_vnet_projectmanager_address_addressline2 | filters on the platform, writable, ::ancestor. |
Address 2 > The second line of the address. | |
project |
varchar2 |
itgen_vnet_projectmanager_address_addressline3 | filters on the platform, writable, ::ancestor. |
Address 3 > The third line of the address. | |
project |
varchar2 |
itgen_vnet_projectmanager_address_city | filters on the platform, writable, ::ancestor. |
City > The city. | |
project |
varchar2 |
itgen_vnet_projectmanager_address_country_errorinfo | filters on the platform, writable, ::ancestor. |
||
project |
varchar2 |
itgen_vnet_projectmanager_address_country_id | filters on the platform, writable, ::ancestor. |
Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166. | |
project |
int64 |
itgen_vnet_projectmanager_address_country_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
project |
int64 |
itgen_vnet_projectmanager_address_country_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
project |
varchar2 |
itgen_vnet_projectmanager_address_country_name | filters on the platform, writable, ::ancestor. |
Mandatory field: Country name* > The complete name of the country. | |
project |
varchar2 |
itgen_vnet_projectmanager_address_county_id | filters on the platform, writable, ::ancestor. |
Click the magnifier > The identifier | |
project |
varchar2 |
itgen_vnet_projectmanager_address_county_name | filters on the platform, writable, ::ancestor. |
Click the magnifier > The displayed name | |
project |
varchar2 |
itgen_vnet_projectmanager_address_postalcode | filters on the platform, writable, ::ancestor. |
Postcode > The postcode. | |
project |
varchar2 |
itgen_vnet_projectmanager_branch_name | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The name. | |
project |
varchar2 |
itgen_vnet_projectmanager_branch_number | filters on the platform, writable, ::ancestor. |
Click the magnifier. > The identifier. | |
project |
varchar2 |
itgen_vnet_projectmanager_calendarid | filters on the platform, writable, ::ancestor. |
||
project |
varchar2 |
itgen_vnet_projectmanager_contact_attention | filters on the platform, 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. | |
project |
int32 |
itgen_vnet_projectmanager_contact_contactid | filters on the platform, writable, ::ancestor. |
||
project |
varchar2 |
itgen_vnet_projectmanager_contact_email | filters on the platform, writable, ::ancestor. |
Email > The email address of the customer/supplier/company as a business entity. | |
project |
varchar2 |
itgen_vnet_projectmanager_contact_employeecontact | filters on the platform, writable, ::ancestor. |
Employee contact > The link to the contact record associated with the employee. | |
project |
varchar2 |
itgen_vnet_projectmanager_contact_fax | filters on the platform, writable, ::ancestor. |
Fax > The fax number. | |
project |
varchar2 |
itgen_vnet_projectmanager_contact_firstname | filters on the platform, writable, ::ancestor. |
First name > The first name of the employee. | |
project |
varchar2 |
itgen_vnet_projectmanager_contact_lastname | filters on the platform, writable, ::ancestor. |
Mandatory field: Last name* > The last name of the employee. | |
project |
varchar2 |
itgen_vnet_projectmanager_contact_midname | filters on the platform, writable, ::ancestor. |
Middle name > The middle name of the employee. | |
project |
varchar2 |
itgen_vnet_projectmanager_contact_name | filters on the platform, writable, ::ancestor. |
Name > The legal name of to appear on the documents. | |
project |
varchar2 |
itgen_vnet_projectmanager_contact_phone1 | filters on the platform, writable, ::ancestor. |
Phone 1 > The default phone number. | |
project |
varchar2 |
itgen_vnet_projectmanager_contact_phone2 | filters on the platform, writable, ::ancestor. |
Phone 2 > An additional phone number. | |
project |
varchar2 |
itgen_vnet_projectmanager_contact_phone3 | filters on the platform, writable, ::ancestor. |
Phone 3 > An additional phone number of the employee. | |
project |
varchar2 |
itgen_vnet_projectmanager_contact_title | filters on the platform, writable, ::ancestor. |
Title > The courtesy title to be used for the employee. | |
project |
varchar2 |
itgen_vnet_projectmanager_contact_web | filters on the platform, writable, ::ancestor. |
Web > The website of the company, if one exists. | |
project |
varchar2 |
Project Manager Department | filters on the platform, writable, ::ancestor. |
Mandatory field: General information tab > Employee section > Department* > The department the employee works for. | |
project |
varchar2 |
itgen_vnet_projectmanager_employeeclass_description | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
project |
varchar2 |
itgen_vnet_projectmanager_employeeclass_id | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
project |
int32 |
Project Manager Employee ID | filters on the platform, 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. | |
project |
varchar2 |
itgen_vnet_projectmanager_employeelogin | filters on the platform, writable, ::ancestor. |
||
project |
varchar2 |
Project Manager Employee Name | filters on the platform, writable, ::ancestor. |
The top part > Employee name > The name of this employee. | |
project |
varchar2 |
Project Manager Employee Number | filters on the platform, writable, ::ancestor. |
General information tab > Employee settings section > Employee ref. no. > A reference number for the employee. | |
project |
guid |
itgen_vnet_projectmanager_employeeuserid | filters on the platform, writable, ::ancestor. |
Employee internal user ID. This is the ID of the user linked to the employee | |
project |
varchar2 |
itgen_vnet_projectmanager_errorinfo | filters on the platform, writable, ::ancestor. |
||
project |
datetime |
itgen_vnet_projectmanager_lastmodifieddatetime | filters on the platform, writable, ::ancestor. |
||
project |
int64 |
itgen_vnet_projectmanager_metadata_maxpagesize | filters on the platform, writable, ::ancestor. |
||
project |
int64 |
itgen_vnet_projectmanager_metadata_totalcount | filters on the platform, writable, ::ancestor. |
||
project |
varchar2 |
Project Manager Status | filters on the platform, 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. | |
project |
blob |
itgen_vnet_projectmanager_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) | |
public |
guid |
Public ID | filters on the platform, writable, ::ancestor. |
||
rate |
varchar2 |
Rate Table Description | writable, ::ancestor. |
Click on the magnifier. > The description. | |
rate |
varchar2 |
itgen_vnet_ratetable_description_2 | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The description. | |
rate |
varchar2 |
Rate Table ID | writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
rate |
varchar2 |
itgen_vnet_ratetable_id_2 | filters on the platform, writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
restrict |
char |
Restrict Employees | 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. | |
restrict |
char |
itgen_vnet_restrictemployees_2 | filters on the platform, writable, ::ancestor. |
Summary tab > Project 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 project. | |
restrict |
char |
Restrict Equipment | filters on the platform, writable, ::ancestor. |
||
start |
datetime |
Start Date | writable, ::ancestor. |
Start date > The date when the task was actually started. | |
start |
datetime |
itgen_vnet_startdate_2 | filters on the platform, writable, ::ancestor. |
Mandatory field: Summary tab > Project properties section > Start date* > The date when the project starts. | |
status |
varchar2 |
Status | writable, ::ancestor. |
Mandatory field: Status* > The status of the task, which can be one of the following: In planning, Active, Cancelled, Completed. | |
status_ |
varchar2 |
itgen_vnet_status_2 | filters on the platform, writable, ::ancestor. |
The top part > Status > The status of the project, which can be one of the following options: In planning, Active, Completed, Suspended, Cancelled. | |
system |
char |
System Template | filters on the platform, writable, ::ancestor. |
||
taskId |
varchar2 |
Task ID | writable, ::ancestor. |
Mandatory field: > Task ID* > The ID of the task. | |
template_ |
varchar2 |
Template Description | filters on the platform, writable, ::ancestor. |
Name of item/description | |
template_ |
varchar2 |
Template Number | filters on the platform, writable, ::ancestor. |
Number of item | |
template_ |
varchar2 |
Template Status | filters on the platform, writable, ::ancestor. |
||
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) | |
value |
varchar2 |
Value | writable, value |
Value > The value of the attribute. | |
visibility_ |
char |
itgen_vnet_visibility_visibleinap | writable, ::ancestor. |
Supplier ledger | |
visibility_ |
char |
itgen_vnet_visibility_visibleinap_2 | filters on the platform, writable, ::ancestor. |
Supplier ledger | |
visibility_ |
char |
itgen_vnet_visibility_visibleinar | writable, ::ancestor. |
Customer ledger | |
visibility_ |
char |
itgen_vnet_visibility_visibleinar_2 | filters on the platform, writable, ::ancestor. |
Customer ledger | |
visibility_ |
char |
itgen_vnet_visibility_visibleinca | writable, ::ancestor. |
Cash management | |
visibility_ |
char |
itgen_vnet_visibility_visibleinca_2 | filters on the platform, writable, ::ancestor. |
Cash management | |
visibility_ |
char |
itgen_vnet_visibility_visibleincr | writable, ::ancestor. |
||
visibility_ |
char |
itgen_vnet_visibility_visibleincr_2 | filters on the platform, writable, ::ancestor. |
||
visibility_ |
char |
itgen_vnet_visibility_visibleinea | writable, ::ancestor. |
Expenses | |
visibility_ |
char |
itgen_vnet_visibility_visibleinea_2 | filters on the platform, writable, ::ancestor. |
Expenses | |
visibility_ |
char |
itgen_vnet_visibility_visibleingl | writable, ::ancestor. |
General ledger | |
visibility_ |
char |
itgen_vnet_visibility_visibleingl_2 | filters on the platform, writable, ::ancestor. |
General ledger | |
visibility_ |
char |
itgen_vnet_visibility_visibleinin | writable, ::ancestor. |
Inventory | |
visibility_ |
char |
itgen_vnet_visibility_visibleinin_2 | filters on the platform, writable, ::ancestor. |
Inventory | |
visibility_ |
char |
itgen_vnet_visibility_visibleinpo | writable, ::ancestor. |
Purchases | |
visibility_ |
char |
itgen_vnet_visibility_visibleinpo_2 | filters on the platform, writable, ::ancestor. |
Purchases | |
visibility_ |
char |
itgen_vnet_visibility_visibleinso | writable, ::ancestor. |
Sales | |
visibility_ |
char |
itgen_vnet_visibility_visibleinso_2 | filters on the platform, writable, ::ancestor. |
Sales | |
visibility_ |
char |
itgen_vnet_visibility_visibleinta | writable, ::ancestor. |
Time entries | |
visibility_ |
char |
itgen_vnet_visibility_visibleinta_2 | filters on the platform, writable, ::ancestor. |
Time entries |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Project |
branch_ |
Branches. |
Key | |
Project |
customer_ |
Customers. |
Key | |
Project |
def |
Accounts. |
Key | |
Project |
def |
Accounts. |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: