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 |
|---|---|---|---|---|
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. | ||
description |
`` | Project name/description | ||
greater |
`` | Greater than value. The item which is the object for this, varies from API to API. | ||
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. | ||
project |
`` | Identifies the Project | ||
project |
`` | Identifies the Project by ID and description | ||
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 |
`` | Select project status. (Values: Planned, Active, Completed, Cancelled, OnHold, PendingApproval) | ||
visible |
`` | If the project is visible in the Supplier ledger | ||
visible |
`` | If the project is visible in the Customer ledger | ||
visible |
`` | If the project is visible in the Cash management workspace | ||
visible |
`` | If the project is visible in the CRM workspace | ||
visible |
`` | If the project is visible in the Expense workspace | ||
visible |
`` | If the project is visible in the General ledger workspace | ||
visible |
`` | If the project is visible in the Inventory workspace | ||
visible |
`` | If the project is visible in the Purchases workspace | ||
visible |
`` | If the project is visible in the Sales workspace | ||
visible |
`` | 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_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
auto |
char |
Auto Allocate | filters on the platform, writable, auto |
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, automatic |
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_ |
varchar2 |
Customer Name | filters on the platform, writable, customer. |
Click the magnifier. > The name. | |
customer_ |
varchar2 |
Customer Number | filters on the platform, writable, customer. |
||
description |
varchar2 |
Description | filters on the platform, writable, description |
Mandatory field: The top part > Description* > The description of the project. | |
end |
datetime |
End Date | filters on the platform, writable, end |
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, error |
||
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. | |
internal |
int32 |
Internal ID | filters on the platform, writable, internal |
||
last |
datetime |
Last Modified | filters on the platform, writable, last |
Systemgenerated information. | |
metadata_ |
int64 |
Metadata Max Pagesize | filters on the platform, writable, metadata. |
||
metadata_ |
int64 |
Total Count | filters on the platform, writable, metadata. |
||
project |
varchar2 |
Project ID | filters on the platform, writable, project |
Mandatory field: The top part > Project ID* > The unique ID for the project. | |
public |
guid |
Public ID | filters on the platform, writable, public |
||
start |
datetime |
Start Date | filters on the platform, writable, start |
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. | |
time |
blob |
Timestamp | filters on the platform, writable, time |
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, visibility. |
Supplier ledger | |
visibility_ |
char |
itgen_vnet_visibility_visibleinar | filters on the platform, writable, visibility. |
Customer ledger | |
visibility_ |
char |
itgen_vnet_visibility_visibleinca | filters on the platform, writable, visibility. |
Cash management | |
visibility_ |
char |
itgen_vnet_visibility_visibleincr | filters on the platform, writable, visibility. |
||
visibility_ |
char |
itgen_vnet_visibility_visibleinea | filters on the platform, writable, visibility. |
Expenses | |
visibility_ |
char |
itgen_vnet_visibility_visibleingl | filters on the platform, writable, visibility. |
General ledger | |
visibility_ |
char |
itgen_vnet_visibility_visibleinin | filters on the platform, writable, visibility. |
Inventory | |
visibility_ |
char |
itgen_vnet_visibility_visibleinpo | filters on the platform, writable, visibility. |
Purchases | |
visibility_ |
char |
itgen_vnet_visibility_visibleinso | filters on the platform, writable, visibility. |
Sales | |
visibility_ |
char |
itgen_vnet_visibility_visibleinta | filters on the platform, writable, visibility. |
Time entries |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Basic |
customer_ |
Customers. |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: