DivisionById: Bouw7 Division by ID
read only REST
- Catalog:
Bouw7 - Schema:
Organization - Label: Division by ID
Returns a single division based on the given ID.
Can only retrieve data.
Summary
Returns a single division based on the given ID.
API Source
- Endpoint:
/organization/division/{id} - Operation:
get /organization/division/{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 DivisionById 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 |
|---|---|---|---|---|---|
description |
varchar2 |
Description | filters on the platform, writable, description |
The description of the division. | |
exact |
varchar2 |
Exact Division ID | filters on the platform, writable, exact |
The division ID of an Exact Online environment. | |
exact |
varchar2 |
Exact Payment Condition Purchase | filters on the platform, writable, exact |
A default payment condition to use for purchase related items. | |
exact |
varchar2 |
Exact Payment Condition Sales | filters on the platform, writable, exact |
A default payment condition to use for sales related items. | |
gl |
varchar2 |
General Ledger Account Code | filters on the platform, writable, gl |
A default general ledger account code to use for sales related items. | |
gl |
varchar2 |
General Ledger Account Code Purchase | filters on the platform, writable, gl |
A default general ledger account code to use for purchase related items. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of the division. | |
journal |
varchar2 |
Journal Code | filters on the platform, writable, journal |
A default journal code to use for sales related items. | |
journal |
varchar2 |
Journal Code Purchase | filters on the platform, writable, journal |
A default journal code to use for purchase related items. | |
journal |
varchar2 |
Journal Code Work in Progress | filters on the platform, writable, journal |
A default journal code to use for work in progress related items. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoiceimportbranch_code | filters on the platform, writable, purchase |
The code for this branch | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoiceimportbranch_division_description | filters on the platform, writable, purchase |
The description of the division. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoiceimportbranch_division_exactdivisionid | filters on the platform, writable, purchase |
The division ID of an Exact Online environment. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoiceimportbranch_division_glaccountcode | filters on the platform, writable, purchase |
A default general ledger account code to use for sales related items. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoiceimportbranch_division_glaccountcodepurchase | filters on the platform, writable, purchase |
A default general ledger account code to use for purchase related items. | |
purchase |
int64 |
itgen_bouw7_purchaseinvoiceimportbranch_division_id | filters on the platform, writable, purchase |
The ID of the division. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoiceimportbranch_division_journalcode | filters on the platform, writable, purchase |
A default journal code to use for sales related items. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoiceimportbranch_division_journalcodepurchase | filters on the platform, writable, purchase |
A default journal code to use for purchase related items. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoiceimportbranch_division_salesinvoicenumberprefix | filters on the platform, writable, purchase |
The prefix (3 digits) used to generate invoice number range per division. | |
purchase |
int64 |
itgen_bouw7_purchaseinvoiceimportbranch_id | filters on the platform, writable, purchase |
The ID of the branch. | |
purchase |
varchar2 |
itgen_bouw7_purchaseinvoiceimportbranch_name | filters on the platform, writable, purchase |
The name of this branch | |
sales |
varchar2 |
Sales Invoice Number Prefix | filters on the platform, writable, sales |
The prefix (3 digits) used to generate invoice number range per division. | |
should |
char |
itgen_bouw7_shouldimportforalljournalsforpurchaseinvoice | filters on the platform, writable, should |
Whether all journals are allowed when importing purchase invoices from Exact Online. | |
work |
char |
itgen_bouw7_workinprogresssettings_allowinvoicelineswithoutproject | filters on the platform, writable, work |
If invoice lines without project are allowed. | |
work |
char |
itgen_bouw7_workinprogresssettings_closingprojectstatus_closesproject | filters on the platform, writable, work |
Whether or not this status closes a project. | |
work |
datetime |
itgen_bouw7_workinprogresssettings_closingprojectstatus_createdat | filters on the platform, writable, work |
The creation time of the entity. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_closingprojectstatus_createdby | filters on the platform, writable, work |
The user that created the entity. | |
work |
int64 |
itgen_bouw7_workinprogresssettings_closingprojectstatus_id | filters on the platform, writable, work |
The ID of the status. | |
work |
char |
itgen_bouw7_workinprogresssettings_closingprojectstatus_invoicesproject | filters on the platform, writable, work |
Whether or not this status invoices a project. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_closingprojectstatus_name | filters on the platform, writable, work |
The name of the status. | |
work |
char |
itgen_bouw7_workinprogresssettings_closingprojectstatus_plansproject | filters on the platform, writable, work |
Whether or not this status plans a project. | |
work |
datetime |
itgen_bouw7_workinprogresssettings_closingprojectstatus_updatedat | filters on the platform, writable, work |
The last updated time of the entity. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_closingprojectstatus_updatedby | filters on the platform, writable, work |
The user that last updated the entity. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_costcenterequipment | filters on the platform, writable, work |
A cost center to use for equipment related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_costcenterequipmentdebit | filters on the platform, writable, work |
A cost center to use for equipment debit related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_costcenterhours | filters on the platform, writable, work |
A cost center to use for hours related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_costcenterhoursdebit | filters on the platform, writable, work |
A cost center to use for hours debit related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_costcentermaterial | filters on the platform, writable, work |
A cost center to use for material related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_costcentermaterialdebit | filters on the platform, writable, work |
A cost center to use for material debit related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_costcenterpurchase | filters on the platform, writable, work |
A cost center to use for purchase related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_costcenterpurchasedebit | filters on the platform, writable, work |
A cost center to use for purchase debit related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_costcentersales | filters on the platform, writable, work |
A cost center to use for sales related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_costcentersalesdebit | filters on the platform, writable, work |
A cost center to use for sales debit related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_costcenterwaste | filters on the platform, writable, work |
A cost center to use for waste related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_costcenterwastedebit | filters on the platform, writable, work |
A cost center to use for waste debit related items. | |
work |
int64 |
itgen_bouw7_workinprogresssettings_divisionid | filters on the platform, writable, work |
The division ID that belongs to these settings. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodeequipment | filters on the platform, writable, work |
A general ledger account code to use for equipment related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodeequipmentclosing | filters on the platform, writable, work |
A general ledger account code to use for equipment closing related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodeequipmentdebit | filters on the platform, writable, work |
A general ledger account code to use for equipment debit related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodehours | filters on the platform, writable, work |
A general ledger account code to use for hours related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodehoursclosing | filters on the platform, writable, work |
A general ledger account code to use for hours closing related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodehoursdebit | filters on the platform, writable, work |
A general ledger account code to use for hours debit related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodematerial | filters on the platform, writable, work |
A general ledger account code to use for material related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodematerialclosing | filters on the platform, writable, work |
A general ledger account code to use for material closing related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodematerialdebit | filters on the platform, writable, work |
A general ledger account code to use for material debit related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodepurchase | filters on the platform, writable, work |
A general ledger account code to use for purchase related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodepurchaseclosing | filters on the platform, writable, work |
A general ledger account code to use for purchase closing related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodepurchasedebit | filters on the platform, writable, work |
A general ledger account code to use for purchase debit related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodesales | filters on the platform, writable, work |
A general ledger account code to use for sales related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodesalesclosing | filters on the platform, writable, work |
A general ledger account code to use for sales closing related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodesalesdebit | filters on the platform, writable, work |
A general ledger account code to use for sales debit related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodewaste | filters on the platform, writable, work |
A general ledger account code to use for waste related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodewasteclosing | filters on the platform, writable, work |
A general ledger account code to use for waste closing related items. | |
work |
varchar2 |
itgen_bouw7_workinprogresssettings_glaccountcodewastedebit | filters on the platform, writable, work |
A general ledger account code to use for waste debit related items. | |
work |
int64 |
itgen_bouw7_workinprogresssettings_id | filters on the platform, writable, work |
The ID of the work in progress settings. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: