ProjectCategoryById: Bouw7 Project Category by ID
read only REST
- Catalog:
Bouw7 - Schema:
Organization - Label: Project Category by ID
Returns a single project category based on the given ID. Returns a single project category based on the given ID.
Can only retrieve data.
Summary
Returns a single project category based on the given ID.
API Source
- Endpoint:
/organization/project-category/{id} - Operation:
get /organization/project-category/{id}
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 90 |
| Full scan rows per minute | 241,000 |
| Point query rows per minute | 666 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` |
Table Columns
The columns of the table ProjectCategoryById 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 |
|---|---|---|---|---|---|
code |
varchar2 |
Code | filters on the platform, writable, code |
The code for the category. | |
created |
datetime |
Created at | filters on the platform, writable, created |
The creation time of the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, created |
The user that created the entity. | |
general |
varchar2 |
General Costs or Profit | filters on the platform, writable, general |
The general costs or profit for the category. | |
general |
varchar2 |
General Costs Percentage | filters on the platform, writable, general |
The general costs percentage for the category. | |
gross |
varchar2 |
Gross Profit Margin | filters on the platform, writable, gross |
The gross profit margin for the category. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of the category. | |
name |
varchar2 |
Name | filters on the platform, writable, name |
The name of the category. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, updated |
The user that last updated the entity. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: