ProjectManagerWorkGroupDescriptionByProjectId: Visma.net Financials itgen_vnet_projectmanagerworkgroupdescriptionbyprojectid_plural
read only REST
- Catalog:
VismaNet - Schema:
Project - Label: itgen_vnet_projectmanagerworkgroupdescriptionbyprojectid_plural
Get a specific Project Data for a single project The response headers include an ETag after a successful GET operation.
Can only retrieve data.
Summary
Data for a single project
The response headers include an ETag after a successful GET operation.
API Source
- Endpoint:
/v1/project/{projectID} - Operation:
get /v1/project/{projectID}
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 |
|---|---|---|---|---|
project |
`` | Identifies the Project |
Table Columns
The columns of the table ProjectManagerWorkGroupDescriptionByProjectId 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. | |
TEXT |
varchar2 |
itgen_vnet_text | writable, ::self |
||
address_ |
int32 |
Address ID | writable, ::ancestor. |
||
address_ |
varchar2 |
Address Line 1 | writable, ::ancestor. |
Address 1 > The first line of the customer's/supplier's/company's/employee's contact address. | |
address_ |
varchar2 |
Address Line 2 | writable, ::ancestor. |
Address 2 > The second line of the address. | |
address_ |
varchar2 |
Address Line 3 | writable, ::ancestor. |
Address 3 > The third line of the address. | |
address_ |
varchar2 |
City | writable, ::ancestor. |
City > The city. | |
address_ |
varchar2 |
itgen_vnet_address_country_errorinfo | writable, ::ancestor. |
||
address_ |
varchar2 |
Country ID | writable, ::ancestor. |
Mandatory field: Country ID* > The unique two-letter country ID according to international standard ISO 3166. | |
address_ |
int64 |
itgen_vnet_address_country_metadata_maxpagesize | writable, ::ancestor. |
||
address_ |
int64 |
itgen_vnet_address_country_metadata_totalcount | writable, ::ancestor. |
||
address_ |
varchar2 |
Country Name | writable, ::ancestor. |
Mandatory field: Country name* > The complete name of the country. | |
address_ |
varchar2 |
County ID | writable, ::ancestor. |
Click the magnifier > The identifier | |
address_ |
varchar2 |
County Name | writable, ::ancestor. |
Click the magnifier > The displayed name | |
address_ |
varchar2 |
Postal Code | writable, ::ancestor. |
Postcode > The postcode. | |
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. | |
calendar |
varchar2 |
Calendar ID | writable, ::ancestor. |
||
contact_ |
varchar2 |
itgen_vnet_contact_attention | 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. | |
contact_ |
int32 |
Contact ID | writable, ::ancestor. |
||
contact_ |
varchar2 |
Contact Email | writable, ::ancestor. |
Email > The email address of the customer/supplier/company as a business entity. | |
contact_ |
varchar2 |
Contact Employee Contact | writable, ::ancestor. |
Employee contact > The link to the contact record associated with the employee. | |
contact_ |
varchar2 |
Contact Fax | writable, ::ancestor. |
Fax > The fax number. | |
contact_ |
varchar2 |
Contact First Name | writable, ::ancestor. |
First name > The first name of the employee. | |
contact_ |
varchar2 |
Contact Last Name | writable, ::ancestor. |
Mandatory field: Last name* > The last name of the employee. | |
contact_ |
varchar2 |
Contact Middle Name | writable, ::ancestor. |
Middle name > The middle name of the employee. | |
contact_ |
varchar2 |
Contact Name | writable, ::ancestor. |
Name > The legal name of to appear on the documents. | |
contact_ |
varchar2 |
Contact Phone 1 | writable, ::ancestor. |
Phone 1 > The default phone number. | |
contact_ |
varchar2 |
Contact Phone 2 | writable, ::ancestor. |
Phone 2 > An additional phone number. | |
contact_ |
varchar2 |
Contact Phone 3 | writable, ::ancestor. |
Phone 3 > An additional phone number of the employee. | |
contact_ |
varchar2 |
Contact Title | writable, ::ancestor. |
Title > The courtesy title to be used for the employee. | |
contact_ |
varchar2 |
Contact Website | writable, ::ancestor. |
Web > The website of the company, if one exists. | |
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. | |
department |
varchar2 |
Department | writable, ::ancestor. |
Mandatory field: General information tab > Employee section > Department* > The department the employee works for. | |
description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Description* > The description of the project. | |
employee |
varchar2 |
Employee Class Description | writable, ::ancestor. |
Click on the magnifier. > The description. | |
employee |
varchar2 |
Employee Class ID | writable, ::ancestor. |
Click on the magnifier. > The identifier. | |
employee |
int32 |
Employee ID | 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. | |
employee |
varchar2 |
Employee Login | writable, ::ancestor. |
||
employee |
varchar2 |
Employee Name | writable, ::ancestor. |
The top part > Employee name > The name of this employee. | |
employee |
varchar2 |
Employee Number | writable, ::ancestor. |
General information tab > Employee settings section > Employee ref. no. > A reference number for the employee. | |
employee |
guid |
Employee User ID | writable, ::ancestor. |
Employee internal user ID. This is the ID of the user linked to the employee | |
end |
datetime |
End Date | 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 | writable, ::ancestor. |
||
error |
varchar2 |
Error Information 2 | 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. | |
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 | writable, ::ancestor. |
||
last |
datetime |
Last Modified Date/Time 2 | 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 | writable, ::ancestor. |
||
metadata_ |
int64 |
itgen_vnet_metadata_maxpagesize_2 | filters on the platform, writable, ::ancestor. |
||
metadata_ |
int64 |
Total Count | writable, ::ancestor. |
||
metadata_ |
int64 |
itgen_vnet_metadata_totalcount_2 | 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. | |
project |
varchar2 |
Project ID | filters on the platform, writable, ::ancestor. |
Mandatory field: The top part > Project ID* > The unique ID for the project. | |
public |
guid |
Public ID | filters on the platform, writable, ::ancestor. |
||
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 > 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 | 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: The top part > Status > The status of the employee. The following options are available: Active, On hold, Hold payments, Inactive, One-time. | |
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. |
||
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) | |
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: