invantive documentation
Invantive Support ForumsLog In / Sign Up

BasicProjects: Visma.net Financials Basic Projects

read only REST

  • Catalog: VismaNet
  • Schema: ProjectBasic
  • Label: Basic Projects

Get a range of Projects - ScreenId=PM301000 Request 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/projectbasic
  • Operation: get /v1/projectbasic

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 `` Project name/description
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.
nonProject `` Set to true to return the non-project.
projectId `` Identifies the Project
projectIdDesc `` Identifies the Project by ID and description
publicId `` Identifies the Project by its publicId
restrictedEmployee `` Id of the employee where access restrictions apply
restrictedUser `` Id of the odp user where access restrictions apply
startDate `` Project's start date
status `` Select project status. (Values: Planned, Active, Completed, Cancelled, OnHold, PendingApproval)
visibleInAp `` If the project is visible in the Supplier ledger
visibleInAr `` If the project is visible in the Customer ledger
visibleInCa `` If the project is visible in the Cash management workspace
visibleInCr `` If the project is visible in the CRM workspace
visibleInEa `` If the project is visible in the Expense workspace
visibleInGl `` If the project is visible in the General ledger workspace
visibleInIn `` If the project is visible in the Inventory workspace
visibleInPo `` If the project is visible in the Purchases workspace
visibleInSo `` If the project is visible in the Sales workspace
visibleInTa `` If the project is visible in the Time entities workspace

Table Columns

The columns of the table BasicProjects 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.
autoAllocate char Auto Allocate filters on the platform, writable, autoAllocate 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.
automaticReleaseAr char Automatic Release AR filters on the platform, writable, automaticReleaseAr 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.
customer_name varchar2 Customer Name filters on the platform, writable, customer.name Click the magnifier. > The name.
customer_number varchar2 Customer Number filters on the platform, writable, customer.number
description varchar2 Description filters on the platform, writable, description Mandatory field: The top part > Description* > The description of the project.
endDate datetime End Date filters on the platform, writable, endDate Summary tab > Project properties section > End date > The date when the project is expected to end.
errorInfo varchar2 Error Message filters on the platform, writable, errorInfo
hold char Hold filters on the platform, writable, hold The top part > Hold > A check box that you select to indicate that the project should have the In planning status.
internalID int32 Internal ID filters on the platform, writable, internalID
lastModifiedDateTime datetime Last Modified filters on the platform, writable, lastModifiedDateTime Systemgenerated information.
metadata_maxPageSize int64 Metadata Max Pagesize filters on the platform, writable, metadata.maxPageSize
metadata_totalCount int64 Total Count filters on the platform, writable, metadata.totalCount
projectID varchar2 Project ID filters on the platform, writable, projectID Mandatory field: The top part > Project ID* > The unique ID for the project.
publicId guid Public ID filters on the platform, writable, publicId
startDate datetime Start Date filters on the platform, writable, startDate Mandatory field: Summary tab > Project properties section > Start date* > The date when the project starts.
status varchar2 Status filters on the platform, writable, status The top part > Status > The status of the project, which can be one of the following options: In planning, Active, Completed, Suspended, Cancelled.
timeStamp blob Timestamp filters on the platform, 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)
visibility_visibleInAp char itgen_vnet_visibility_visibleinap filters on the platform, writable, visibility.visibleInAp Supplier ledger
visibility_visibleInAr char itgen_vnet_visibility_visibleinar filters on the platform, writable, visibility.visibleInAr Customer ledger
visibility_visibleInCa char itgen_vnet_visibility_visibleinca filters on the platform, writable, visibility.visibleInCa Cash management
visibility_visibleInCr char itgen_vnet_visibility_visibleincr filters on the platform, writable, visibility.visibleInCr
visibility_visibleInEa char itgen_vnet_visibility_visibleinea filters on the platform, writable, visibility.visibleInEa Expenses
visibility_visibleInGl char itgen_vnet_visibility_visibleingl filters on the platform, writable, visibility.visibleInGl General ledger
visibility_visibleInIn char itgen_vnet_visibility_visibleinin filters on the platform, writable, visibility.visibleInIn Inventory
visibility_visibleInPo char itgen_vnet_visibility_visibleinpo filters on the platform, writable, visibility.visibleInPo Purchases
visibility_visibleInSo char itgen_vnet_visibility_visibleinso filters on the platform, writable, visibility.visibleInSo Sales
visibility_visibleInTa char itgen_vnet_visibility_visibleinta filters on the platform, writable, visibility.visibleInTa Time entries

Keys

Key Column Refers to Kind Description
BasicProjects_customer_number_fk customer_number Customers.number Key

Release Notes

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