invantive documentation
Invantive Support ForumsLog In / Sign Up

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.
exactDivisionId varchar2 Exact Division ID filters on the platform, writable, exactDivisionId The division ID of an Exact Online environment.
exactPaymentConditionPurchase varchar2(255) Exact Payment Condition Purchase filters on the platform, writable, exactPaymentConditionPurchase A default payment condition to use for purchase related items.
exactPaymentConditionSales varchar2(255) Exact Payment Condition Sales filters on the platform, writable, exactPaymentConditionSales A default payment condition to use for sales related items.
glAccountCode varchar2 General Ledger Account Code filters on the platform, writable, glAccountCode A default general ledger account code to use for sales related items.
glAccountCodePurchase varchar2 General Ledger Account Code Purchase filters on the platform, writable, glAccountCodePurchase 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.
journalCode varchar2 Journal Code filters on the platform, writable, journalCode A default journal code to use for sales related items.
journalCodePurchase varchar2 Journal Code Purchase filters on the platform, writable, journalCodePurchase A default journal code to use for purchase related items.
journalCodeWorkInProgress varchar2 Journal Code Work in Progress filters on the platform, writable, journalCodeWorkInProgress A default journal code to use for work in progress related items.
purchaseInvoiceImportBranch_code varchar2 itgen_bouw7_purchaseinvoiceimportbranch_code filters on the platform, writable, purchaseInvoiceImportBranch.code The code for this branch
purchaseInvoiceImportBranch_division_description varchar2 itgen_bouw7_purchaseinvoiceimportbranch_division_description filters on the platform, writable, purchaseInvoiceImportBranch.division.description The description of the division.
purchaseInvoiceImportBranch_division_exactDivisionId varchar2 itgen_bouw7_purchaseinvoiceimportbranch_division_exactdivisionid filters on the platform, writable, purchaseInvoiceImportBranch.division.exactDivisionId The division ID of an Exact Online environment.
purchaseInvoiceImportBranch_division_glAccountCode varchar2 itgen_bouw7_purchaseinvoiceimportbranch_division_glaccountcode filters on the platform, writable, purchaseInvoiceImportBranch.division.glAccountCode A default general ledger account code to use for sales related items.
purchaseInvoiceImportBranch_division_glAccountCodePurchase varchar2 itgen_bouw7_purchaseinvoiceimportbranch_division_glaccountcodepurchase filters on the platform, writable, purchaseInvoiceImportBranch.division.glAccountCodePurchase A default general ledger account code to use for purchase related items.
purchaseInvoiceImportBranch_division_id int64 itgen_bouw7_purchaseinvoiceimportbranch_division_id filters on the platform, writable, purchaseInvoiceImportBranch.division.id The ID of the division.
purchaseInvoiceImportBranch_division_journalCode varchar2 itgen_bouw7_purchaseinvoiceimportbranch_division_journalcode filters on the platform, writable, purchaseInvoiceImportBranch.division.journalCode A default journal code to use for sales related items.
purchaseInvoiceImportBranch_division_journalCodePurchase varchar2 itgen_bouw7_purchaseinvoiceimportbranch_division_journalcodepurchase filters on the platform, writable, purchaseInvoiceImportBranch.division.journalCodePurchase A default journal code to use for purchase related items.
purchaseInvoiceImportBranch_division_salesInvoiceNumberPrefix varchar2(3) itgen_bouw7_purchaseinvoiceimportbranch_division_salesinvoicenumberprefix filters on the platform, writable, purchaseInvoiceImportBranch.division.salesInvoiceNumberPrefix The prefix (3 digits) used to generate invoice number range per division.
purchaseInvoiceImportBranch_id int64 itgen_bouw7_purchaseinvoiceimportbranch_id filters on the platform, writable, purchaseInvoiceImportBranch.id The ID of the branch.
purchaseInvoiceImportBranch_name varchar2 itgen_bouw7_purchaseinvoiceimportbranch_name filters on the platform, writable, purchaseInvoiceImportBranch.name The name of this branch
salesInvoiceNumberPrefix varchar2(3) Sales Invoice Number Prefix filters on the platform, writable, salesInvoiceNumberPrefix The prefix (3 digits) used to generate invoice number range per division.
shouldImportForAllJournalsForPurchaseInvoice char itgen_bouw7_shouldimportforalljournalsforpurchaseinvoice filters on the platform, writable, shouldImportForAllJournalsForPurchaseInvoice Whether all journals are allowed when importing purchase invoices from Exact Online.
workInProgressSettings_allowInvoiceLinesWithoutProject char itgen_bouw7_workinprogresssettings_allowinvoicelineswithoutproject filters on the platform, writable, workInProgressSettings.allowInvoiceLinesWithoutProject If invoice lines without project are allowed.
workInProgressSettings_closingProjectStatus_closesProject char itgen_bouw7_workinprogresssettings_closingprojectstatus_closesproject filters on the platform, writable, workInProgressSettings.closingProjectStatus.closesProject Whether or not this status closes a project.
workInProgressSettings_closingProjectStatus_createdAt datetime itgen_bouw7_workinprogresssettings_closingprojectstatus_createdat filters on the platform, writable, workInProgressSettings.closingProjectStatus.createdAt The creation time of the entity.
workInProgressSettings_closingProjectStatus_createdBy varchar2 itgen_bouw7_workinprogresssettings_closingprojectstatus_createdby filters on the platform, writable, workInProgressSettings.closingProjectStatus.createdBy The user that created the entity.
workInProgressSettings_closingProjectStatus_id int64 itgen_bouw7_workinprogresssettings_closingprojectstatus_id filters on the platform, writable, workInProgressSettings.closingProjectStatus.id The ID of the status.
workInProgressSettings_closingProjectStatus_invoicesProject char itgen_bouw7_workinprogresssettings_closingprojectstatus_invoicesproject filters on the platform, writable, workInProgressSettings.closingProjectStatus.invoicesProject Whether or not this status invoices a project.
workInProgressSettings_closingProjectStatus_name varchar2 itgen_bouw7_workinprogresssettings_closingprojectstatus_name filters on the platform, writable, workInProgressSettings.closingProjectStatus.name The name of the status.
workInProgressSettings_closingProjectStatus_plansProject char itgen_bouw7_workinprogresssettings_closingprojectstatus_plansproject filters on the platform, writable, workInProgressSettings.closingProjectStatus.plansProject Whether or not this status plans a project.
workInProgressSettings_closingProjectStatus_updatedAt datetime itgen_bouw7_workinprogresssettings_closingprojectstatus_updatedat filters on the platform, writable, workInProgressSettings.closingProjectStatus.updatedAt The last updated time of the entity.
workInProgressSettings_closingProjectStatus_updatedBy varchar2 itgen_bouw7_workinprogresssettings_closingprojectstatus_updatedby filters on the platform, writable, workInProgressSettings.closingProjectStatus.updatedBy The user that last updated the entity.
workInProgressSettings_costCenterEquipment varchar2(255) itgen_bouw7_workinprogresssettings_costcenterequipment filters on the platform, writable, workInProgressSettings.costCenterEquipment A cost center to use for equipment related items.
workInProgressSettings_costCenterEquipmentDebit varchar2(255) itgen_bouw7_workinprogresssettings_costcenterequipmentdebit filters on the platform, writable, workInProgressSettings.costCenterEquipmentDebit A cost center to use for equipment debit related items.
workInProgressSettings_costCenterHours varchar2(255) itgen_bouw7_workinprogresssettings_costcenterhours filters on the platform, writable, workInProgressSettings.costCenterHours A cost center to use for hours related items.
workInProgressSettings_costCenterHoursDebit varchar2(255) itgen_bouw7_workinprogresssettings_costcenterhoursdebit filters on the platform, writable, workInProgressSettings.costCenterHoursDebit A cost center to use for hours debit related items.
workInProgressSettings_costCenterMaterial varchar2(255) itgen_bouw7_workinprogresssettings_costcentermaterial filters on the platform, writable, workInProgressSettings.costCenterMaterial A cost center to use for material related items.
workInProgressSettings_costCenterMaterialDebit varchar2(255) itgen_bouw7_workinprogresssettings_costcentermaterialdebit filters on the platform, writable, workInProgressSettings.costCenterMaterialDebit A cost center to use for material debit related items.
workInProgressSettings_costCenterPurchase varchar2(255) itgen_bouw7_workinprogresssettings_costcenterpurchase filters on the platform, writable, workInProgressSettings.costCenterPurchase A cost center to use for purchase related items.
workInProgressSettings_costCenterPurchaseDebit varchar2(255) itgen_bouw7_workinprogresssettings_costcenterpurchasedebit filters on the platform, writable, workInProgressSettings.costCenterPurchaseDebit A cost center to use for purchase debit related items.
workInProgressSettings_costCenterSales varchar2(255) itgen_bouw7_workinprogresssettings_costcentersales filters on the platform, writable, workInProgressSettings.costCenterSales A cost center to use for sales related items.
workInProgressSettings_costCenterSalesDebit varchar2(255) itgen_bouw7_workinprogresssettings_costcentersalesdebit filters on the platform, writable, workInProgressSettings.costCenterSalesDebit A cost center to use for sales debit related items.
workInProgressSettings_costCenterWaste varchar2(255) itgen_bouw7_workinprogresssettings_costcenterwaste filters on the platform, writable, workInProgressSettings.costCenterWaste A cost center to use for waste related items.
workInProgressSettings_costCenterWasteDebit varchar2(255) itgen_bouw7_workinprogresssettings_costcenterwastedebit filters on the platform, writable, workInProgressSettings.costCenterWasteDebit A cost center to use for waste debit related items.
workInProgressSettings_divisionId int64 itgen_bouw7_workinprogresssettings_divisionid filters on the platform, writable, workInProgressSettings.divisionId The division ID that belongs to these settings.
workInProgressSettings_glAccountCodeEquipment varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodeequipment filters on the platform, writable, workInProgressSettings.glAccountCodeEquipment A general ledger account code to use for equipment related items.
workInProgressSettings_glAccountCodeEquipmentClosing varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodeequipmentclosing filters on the platform, writable, workInProgressSettings.glAccountCodeEquipmentClosing A general ledger account code to use for equipment closing related items.
workInProgressSettings_glAccountCodeEquipmentDebit varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodeequipmentdebit filters on the platform, writable, workInProgressSettings.glAccountCodeEquipmentDebit A general ledger account code to use for equipment debit related items.
workInProgressSettings_glAccountCodeHours varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodehours filters on the platform, writable, workInProgressSettings.glAccountCodeHours A general ledger account code to use for hours related items.
workInProgressSettings_glAccountCodeHoursClosing varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodehoursclosing filters on the platform, writable, workInProgressSettings.glAccountCodeHoursClosing A general ledger account code to use for hours closing related items.
workInProgressSettings_glAccountCodeHoursDebit varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodehoursdebit filters on the platform, writable, workInProgressSettings.glAccountCodeHoursDebit A general ledger account code to use for hours debit related items.
workInProgressSettings_glAccountCodeMaterial varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodematerial filters on the platform, writable, workInProgressSettings.glAccountCodeMaterial A general ledger account code to use for material related items.
workInProgressSettings_glAccountCodeMaterialClosing varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodematerialclosing filters on the platform, writable, workInProgressSettings.glAccountCodeMaterialClosing A general ledger account code to use for material closing related items.
workInProgressSettings_glAccountCodeMaterialDebit varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodematerialdebit filters on the platform, writable, workInProgressSettings.glAccountCodeMaterialDebit A general ledger account code to use for material debit related items.
workInProgressSettings_glAccountCodePurchase varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodepurchase filters on the platform, writable, workInProgressSettings.glAccountCodePurchase A general ledger account code to use for purchase related items.
workInProgressSettings_glAccountCodePurchaseClosing varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodepurchaseclosing filters on the platform, writable, workInProgressSettings.glAccountCodePurchaseClosing A general ledger account code to use for purchase closing related items.
workInProgressSettings_glAccountCodePurchaseDebit varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodepurchasedebit filters on the platform, writable, workInProgressSettings.glAccountCodePurchaseDebit A general ledger account code to use for purchase debit related items.
workInProgressSettings_glAccountCodeSales varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodesales filters on the platform, writable, workInProgressSettings.glAccountCodeSales A general ledger account code to use for sales related items.
workInProgressSettings_glAccountCodeSalesClosing varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodesalesclosing filters on the platform, writable, workInProgressSettings.glAccountCodeSalesClosing A general ledger account code to use for sales closing related items.
workInProgressSettings_glAccountCodeSalesDebit varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodesalesdebit filters on the platform, writable, workInProgressSettings.glAccountCodeSalesDebit A general ledger account code to use for sales debit related items.
workInProgressSettings_glAccountCodeWaste varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodewaste filters on the platform, writable, workInProgressSettings.glAccountCodeWaste A general ledger account code to use for waste related items.
workInProgressSettings_glAccountCodeWasteClosing varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodewasteclosing filters on the platform, writable, workInProgressSettings.glAccountCodeWasteClosing A general ledger account code to use for waste closing related items.
workInProgressSettings_glAccountCodeWasteDebit varchar2(255) itgen_bouw7_workinprogresssettings_glaccountcodewastedebit filters on the platform, writable, workInProgressSettings.glAccountCodeWasteDebit A general ledger account code to use for waste debit related items.
workInProgressSettings_id int64 itgen_bouw7_workinprogresssettings_id filters on the platform, writable, workInProgressSettings.id The ID of the work in progress settings.

Release Notes

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