ProjectCategoryDivisionSettings: Bouw7 Project Category Division Settings
read only REST
- Catalog:
Bouw7 - Schema:
Organization - Label: Project Category Division Settings
Return a set of project categories for the organization. Return a set of project categories for the organization.
Can only retrieve data.
Summary
Return a set of project categories for the organization.
API Source
- Endpoint:
/organization/project-categories - Operation:
get /organization/project-categories
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 71 |
| Full scan rows per minute | 241,000 |
| Point query rows per minute | 666 |
The result can be cached on the client.
Table Columns
The columns of the table ProjectCategoryDivisionSettings 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, ::ancestor. |
The code for the category. | |
cost |
varchar2 |
Cost Centre General Costs | writable, cost |
A cost center to use for general costs related items. | |
cost |
varchar2 |
Cost Centre General Costs Debit | writable, cost |
A cost center to use for general costs debit related items. | |
created |
datetime |
Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
division |
int64 |
Division ID | writable, division |
The ID of the linked division. | |
general |
varchar2 |
General Costs or Profit | filters on the platform, writable, ::ancestor. |
The general costs or profit for the category. | |
general |
varchar2 |
General Costs Percentage | filters on the platform, writable, ::ancestor. |
The general costs percentage for the category. | |
gl |
varchar2 |
GL Account Code General Costs | writable, gl |
A general ledger account code to use for general costs related items. | |
gl |
varchar2 |
GL Account Code General Costs Closing | writable, gl |
A general ledger account code to use for general costs closing related items. | |
gl |
varchar2 |
GL Account Code General Costs Debit | writable, gl |
A general ledger account code to use for general costs debit related items. | |
gross |
varchar2 |
Gross Profit Margin | filters on the platform, writable, ::ancestor. |
The gross profit margin for the category. | |
id |
int64 |
ID | writable, id |
The ID of the division project category settings. | |
id_2 |
int64 |
ID | filters on the platform, writable, ::ancestor. |
The ID of the category. | |
name |
varchar2 |
Name | filters on the platform, writable, ::ancestor. |
The name of the category. | |
updated |
datetime |
Updated At | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: