DepartmentWorkInProgressSettingsByDepartmentId: Bouw7 itgen_bouw7_departmentworkinprogresssettingsbydepartmentid_plural
read only REST
- Catalog:
Bouw7 - Schema:
Department - Label: itgen_bouw7_departmentworkinprogresssettingsbydepartmentid_plural
Returns a single department based on the given ID. Returns a single department based on the given ID.
Can only retrieve data.
Summary
Returns a single department based on the given ID.
API Source
- Endpoint:
/organization/department/{department} - Operation:
get /organization/department/{department}
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 |
|---|---|---|---|---|
department |
`` |
Table Columns
The columns of the table DepartmentWorkInProgressSettingsByDepartmentId 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 |
|---|---|---|---|---|---|
branch |
int64 |
itgen_bouw7_branchid | writable, branch |
The ID of the linked branch. | |
branch_ |
varchar2 |
Branch Code | filters on the platform, writable, ::ancestor. |
The code for this branch | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_description | filters on the platform, writable, ::ancestor. |
The description of the division. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_exactdivisionid | filters on the platform, writable, ::ancestor. |
The division ID of an Exact Online environment. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_glaccountcode | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for sales related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_glaccountcodepurchase | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for purchase related items. | |
branch_ |
int64 |
itgen_bouw7_branch_division_id | filters on the platform, writable, ::ancestor. |
The ID of the division. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_journalcode | filters on the platform, writable, ::ancestor. |
A default journal code to use for sales related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_journalcodepurchase | filters on the platform, writable, ::ancestor. |
A default journal code to use for purchase related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_salesinvoicenumberprefix | filters on the platform, writable, ::ancestor. |
The prefix (3 digits) used to generate invoice number range per division. | |
branch_ |
int64 |
Branch ID | filters on the platform, writable, ::ancestor. |
The ID of the branch. | |
branch_ |
varchar2 |
Branch Name | filters on the platform, writable, ::ancestor. |
The name of this branch | |
color |
varchar2 |
Colour | filters on the platform, writable, ::ancestor. |
Display color of the department | |
cost |
varchar2 |
itgen_bouw7_costcenterhours | writable, cost |
A cost center to use for hours related items. | |
cost |
varchar2 |
itgen_bouw7_costcenterhoursdebit | writable, cost |
A cost center to use for hours 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. | |
gl |
varchar2 |
itgen_bouw7_glaccountcodehours | writable, gl |
A general ledger account code to use for hours related items. | |
gl |
varchar2 |
itgen_bouw7_glaccountcodehoursclosing | writable, gl |
A general ledger account code to use for hours closing related items. | |
gl |
varchar2 |
itgen_bouw7_glaccountcodehoursdebit | writable, gl |
A general ledger account code to use for hours debit related items. | |
has |
char |
itgen_bouw7_hasbranchspecificaccess | filters on the platform, writable, ::ancestor. |
Whether users within the department can only access items associated with one of the specified branches. | |
id |
int64 |
ID | writable, id |
The ID of the work in progress settings. | |
id_2 |
int64 |
ID | filters on the platform, writable, ::ancestor. |
ID of the department. | |
is |
char |
Is Active | filters on the platform, writable, ::ancestor. |
Whether or not the department is active. | |
is |
char |
itgen_bouw7_isdatawithoutbranchaccessible | filters on the platform, writable, ::ancestor. |
Whether this branch can access data without a branch, this option is only used in combination with the hasBranchSpecificAccess=true. | |
name |
varchar2 |
Name | filters on the platform, writable, ::ancestor. |
Name of the department. | |
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: