invantive documentation
Invantive Support ForumsLog In / Sign Up

Divisions: Bouw7 Divisions

popular read only REST

  • Catalog: Bouw7
  • Schema: Organization
  • Label: Divisions

Return a list of divisions associated with the organization.

Can only retrieve data.

Summary

Return a list of divisions associated with the organization.

API Source

  • Endpoint: /list/divisions
  • Operation: get /list/divisions

Performance Characteristics

Characteristic Value
Average access latency (ms) 72
Full scan rows per minute 1,320
Point query rows per minute 666

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
q `` A Heimdall Query Language string

Table Columns

The columns of the table Divisions 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 Exact Payment Condition Purchase filters on the platform, writable, exactPaymentConditionPurchase A default payment condition to use for purchase related items.
exactPaymentConditionSales varchar2 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.
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.

Release Notes

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