invantive documentation
Invantive Support ForumsLog In / Sign Up

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
branchId int64 itgen_bouw7_branchid writable, branchId The ID of the linked branch.
branch_code varchar2 Branch Code filters on the platform, writable, ::ancestor.branch.code The code for this branch
branch_division_description varchar2 itgen_bouw7_branch_division_description filters on the platform, writable, ::ancestor.branch.division.description The description of the division.
branch_division_exactDivisionId varchar2 itgen_bouw7_branch_division_exactdivisionid filters on the platform, writable, ::ancestor.branch.division.exactDivisionId The division ID of an Exact Online environment.
branch_division_glAccountCode varchar2 itgen_bouw7_branch_division_glaccountcode filters on the platform, writable, ::ancestor.branch.division.glAccountCode A default general ledger account code to use for sales related items.
branch_division_glAccountCodePurchase varchar2 itgen_bouw7_branch_division_glaccountcodepurchase filters on the platform, writable, ::ancestor.branch.division.glAccountCodePurchase A default general ledger account code to use for purchase related items.
branch_division_id int64 itgen_bouw7_branch_division_id filters on the platform, writable, ::ancestor.branch.division.id The ID of the division.
branch_division_journalCode varchar2 itgen_bouw7_branch_division_journalcode filters on the platform, writable, ::ancestor.branch.division.journalCode A default journal code to use for sales related items.
branch_division_journalCodePurchase varchar2 itgen_bouw7_branch_division_journalcodepurchase filters on the platform, writable, ::ancestor.branch.division.journalCodePurchase A default journal code to use for purchase related items.
branch_division_salesInvoiceNumberPrefix varchar2(3) itgen_bouw7_branch_division_salesinvoicenumberprefix filters on the platform, writable, ::ancestor.branch.division.salesInvoiceNumberPrefix The prefix (3 digits) used to generate invoice number range per division.
branch_id int64 Branch ID filters on the platform, writable, ::ancestor.branch.id The ID of the branch.
branch_name varchar2 Branch Name filters on the platform, writable, ::ancestor.branch.name The name of this branch
color varchar2 Colour filters on the platform, writable, ::ancestor.color Display color of the department
costCenterHours varchar2(255) itgen_bouw7_costcenterhours writable, costCenterHours A cost center to use for hours related items.
costCenterHoursDebit varchar2(255) itgen_bouw7_costcenterhoursdebit writable, costCenterHoursDebit A cost center to use for hours debit related items.
createdAt datetime Created at filters on the platform, writable, ::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Created by filters on the platform, writable, ::ancestor.createdBy The user that created the entity.
glAccountCodeHours varchar2(255) itgen_bouw7_glaccountcodehours writable, glAccountCodeHours A general ledger account code to use for hours related items.
glAccountCodeHoursClosing varchar2(255) itgen_bouw7_glaccountcodehoursclosing writable, glAccountCodeHoursClosing A general ledger account code to use for hours closing related items.
glAccountCodeHoursDebit varchar2(255) itgen_bouw7_glaccountcodehoursdebit writable, glAccountCodeHoursDebit A general ledger account code to use for hours debit related items.
hasBranchSpecificAccess char itgen_bouw7_hasbranchspecificaccess filters on the platform, writable, ::ancestor.hasBranchSpecificAccess 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 ID of the department.
isActive char Is Active filters on the platform, writable, ::ancestor.isActive Whether or not the department is active.
isDataWithoutBranchAccessible char itgen_bouw7_isdatawithoutbranchaccessible filters on the platform, writable, ::ancestor.isDataWithoutBranchAccessible 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 Name of the department.
updatedAt datetime Updated At filters on the platform, writable, ::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by filters on the platform, writable, ::ancestor.updatedBy The user that last updated the entity.

Release Notes

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