invantive documentation
Invantive Support ForumsLog In / Sign Up

BranchById: Bouw7 Branch by ID

read only REST

  • Catalog: Bouw7
  • Schema: Organization
  • Label: Branch by ID

Returns a single branch based on the given ID. Returns a single branch based on the given ID.

Can only retrieve data.

Summary

Returns a single branch based on the given ID.

API Source

  • Endpoint: /organization/branch/{id}
  • Operation: get /organization/branch/{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 BranchById 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
accountNumber varchar2(255) Account Number filters on the platform, writable, accountNumber Account number of the branch.
address varchar2(255) Address filters on the platform, writable, address Address of the branch.
afasAdministration varchar2(255) AFAS Administration filters on the platform, writable, afasAdministration Afas administration code of the branch.
afasProjectLeader varchar2(255) AFAS Project Leader filters on the platform, writable, afasProjectLeader Afas project leader of the branch.
city varchar2(255) City filters on the platform, writable, city City of the branch.
cocNumber varchar2(255) Chamber of Commerce Number filters on the platform, writable, cocNumber The COC number.
code varchar2(255) Code filters on the platform, writable, code The code of the branch.
companyName varchar2(255) Company Name filters on the platform, writable, companyName The company name of the branch.
countryCode varchar2(2) Country Code filters on the platform, writable, countryCode An ISO 3166-2 representation of the country.
createdAt datetime Created at filters on the platform, writable, createdAt The creation time of the entity.
createdBy varchar2 Created by filters on the platform, writable, createdBy The user that created the entity.
division_description varchar2 Division Description filters on the platform, writable, division.description The description of the division this object is associated with.
division_exactPaymentConditionPurchase varchar2(255) itgen_bouw7_division_exactpaymentconditionpurchase filters on the platform, writable, division.exactPaymentConditionPurchase A default payment condition to use for purchase related items.
division_exactPaymentConditionSales varchar2(255) itgen_bouw7_division_exactpaymentconditionsales filters on the platform, writable, division.exactPaymentConditionSales A default payment condition to use for sales related items.
division_glAccountCode varchar2 Division General Ledger Account Code filters on the platform, writable, division.glAccountCode A general ledger account code to use for sales related items.
division_glAccountCodePurchase varchar2 Division General Ledger Account Code Purchase filters on the platform, writable, division.glAccountCodePurchase A general ledger account code to use for purchase related items.
division_id int64 Division ID filters on the platform, writable, division.id The ID of the division this object is associated with.
division_journalCode varchar2 Division Journal Code filters on the platform, writable, division.journalCode A journal code to use for sales related items.
division_journalCodePurchase varchar2 Division Journal Code Purchase filters on the platform, writable, division.journalCodePurchase A journal code to use for purchase related items.
division_journalCodeWorkInProgress varchar2 itgen_bouw7_division_journalcodeworkinprogress filters on the platform, writable, division.journalCodeWorkInProgress A default journal code to use for work in progress related items.
division_workInProgressSettings_costCenterEquipment varchar2(255) itgen_bouw7_division_workinprogresssettings_costcenterequipment filters on the platform, writable, division.workInProgressSettings.costCenterEquipment A cost center to use for equipment related items.
division_workInProgressSettings_costCenterEquipmentDebit varchar2(255) itgen_bouw7_division_workinprogresssettings_costcenterequipmentdebit filters on the platform, writable, division.workInProgressSettings.costCenterEquipmentDebit A cost center to use for equipment debit related items.
division_workInProgressSettings_costCenterHours varchar2(255) itgen_bouw7_division_workinprogresssettings_costcenterhours filters on the platform, writable, division.workInProgressSettings.costCenterHours A cost center to use for hours related items.
division_workInProgressSettings_costCenterHoursDebit varchar2(255) itgen_bouw7_division_workinprogresssettings_costcenterhoursdebit filters on the platform, writable, division.workInProgressSettings.costCenterHoursDebit A cost center to use for hours debit related items.
division_workInProgressSettings_costCenterMaterial varchar2(255) itgen_bouw7_division_workinprogresssettings_costcentermaterial filters on the platform, writable, division.workInProgressSettings.costCenterMaterial A cost center to use for material related items.
division_workInProgressSettings_costCenterMaterialDebit varchar2(255) itgen_bouw7_division_workinprogresssettings_costcentermaterialdebit filters on the platform, writable, division.workInProgressSettings.costCenterMaterialDebit A cost center to use for material debit related items.
division_workInProgressSettings_costCenterPurchase varchar2(255) itgen_bouw7_division_workinprogresssettings_costcenterpurchase filters on the platform, writable, division.workInProgressSettings.costCenterPurchase A cost center to use for purchase related items.
division_workInProgressSettings_costCenterPurchaseDebit varchar2(255) itgen_bouw7_division_workinprogresssettings_costcenterpurchasedebit filters on the platform, writable, division.workInProgressSettings.costCenterPurchaseDebit A cost center to use for purchase debit related items.
division_workInProgressSettings_costCenterSales varchar2(255) itgen_bouw7_division_workinprogresssettings_costcentersales filters on the platform, writable, division.workInProgressSettings.costCenterSales A cost center to use for sales related items.
division_workInProgressSettings_costCenterSalesDebit varchar2(255) itgen_bouw7_division_workinprogresssettings_costcentersalesdebit filters on the platform, writable, division.workInProgressSettings.costCenterSalesDebit A cost center to use for sales debit related items.
division_workInProgressSettings_costCenterWaste varchar2(255) itgen_bouw7_division_workinprogresssettings_costcenterwaste filters on the platform, writable, division.workInProgressSettings.costCenterWaste A cost center to use for waste related items.
division_workInProgressSettings_costCenterWasteDebit varchar2(255) itgen_bouw7_division_workinprogresssettings_costcenterwastedebit filters on the platform, writable, division.workInProgressSettings.costCenterWasteDebit A cost center to use for waste debit related items.
division_workInProgressSettings_glAccountCodeEquipment varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodeequipment filters on the platform, writable, division.workInProgressSettings.glAccountCodeEquipment A general ledger account code to use for equipment related items.
division_workInProgressSettings_glAccountCodeEquipmentClosing varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodeequipmentclosing filters on the platform, writable, division.workInProgressSettings.glAccountCodeEquipmentClosing A general ledger account code to use for equipment closing related items.
division_workInProgressSettings_glAccountCodeEquipmentDebit varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodeequipmentdebit filters on the platform, writable, division.workInProgressSettings.glAccountCodeEquipmentDebit A general ledger account code to use for equipment debit related items.
division_workInProgressSettings_glAccountCodeHours varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodehours filters on the platform, writable, division.workInProgressSettings.glAccountCodeHours A general ledger account code to use for hours related items.
division_workInProgressSettings_glAccountCodeHoursClosing varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodehoursclosing filters on the platform, writable, division.workInProgressSettings.glAccountCodeHoursClosing A general ledger account code to use for hours closing related items.
division_workInProgressSettings_glAccountCodeHoursDebit varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodehoursdebit filters on the platform, writable, division.workInProgressSettings.glAccountCodeHoursDebit A general ledger account code to use for hours debit related items.
division_workInProgressSettings_glAccountCodeMaterial varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodematerial filters on the platform, writable, division.workInProgressSettings.glAccountCodeMaterial A general ledger account code to use for material related items.
division_workInProgressSettings_glAccountCodeMaterialClosing varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodematerialclosing filters on the platform, writable, division.workInProgressSettings.glAccountCodeMaterialClosing A general ledger account code to use for material closing related items.
division_workInProgressSettings_glAccountCodeMaterialDebit varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodematerialdebit filters on the platform, writable, division.workInProgressSettings.glAccountCodeMaterialDebit A general ledger account code to use for material debit related items.
division_workInProgressSettings_glAccountCodePurchase varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodepurchase filters on the platform, writable, division.workInProgressSettings.glAccountCodePurchase A general ledger account code to use for purchase related items.
division_workInProgressSettings_glAccountCodePurchaseClosing varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodepurchaseclosing filters on the platform, writable, division.workInProgressSettings.glAccountCodePurchaseClosing A general ledger account code to use for purchase closing related items.
division_workInProgressSettings_glAccountCodePurchaseDebit varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodepurchasedebit filters on the platform, writable, division.workInProgressSettings.glAccountCodePurchaseDebit A general ledger account code to use for purchase debit related items.
division_workInProgressSettings_glAccountCodeSales varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodesales filters on the platform, writable, division.workInProgressSettings.glAccountCodeSales A general ledger account code to use for sales related items.
division_workInProgressSettings_glAccountCodeSalesClosing varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodesalesclosing filters on the platform, writable, division.workInProgressSettings.glAccountCodeSalesClosing A general ledger account code to use for sales closing related items.
division_workInProgressSettings_glAccountCodeSalesDebit varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodesalesdebit filters on the platform, writable, division.workInProgressSettings.glAccountCodeSalesDebit A general ledger account code to use for sales debit related items.
division_workInProgressSettings_glAccountCodeWaste varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodewaste filters on the platform, writable, division.workInProgressSettings.glAccountCodeWaste A general ledger account code to use for waste related items.
division_workInProgressSettings_glAccountCodeWasteClosing varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodewasteclosing filters on the platform, writable, division.workInProgressSettings.glAccountCodeWasteClosing A general ledger account code to use for waste closing related items.
division_workInProgressSettings_glAccountCodeWasteDebit varchar2(255) itgen_bouw7_division_workinprogresssettings_glaccountcodewastedebit filters on the platform, writable, division.workInProgressSettings.glAccountCodeWasteDebit A general ledger account code to use for waste debit related items.
division_workInProgressSettings_id int64 itgen_bouw7_division_workinprogresssettings_id filters on the platform, writable, division.workInProgressSettings.id The ID of the work in progress settings.
email varchar2(255) Email filters on the platform, writable, email Email of the branch.
file_createdAt datetime File Created at filters on the platform, writable, file.createdAt The creation time of the entity.
file_createdBy varchar2 File Created by filters on the platform, writable, file.createdBy The user that created the entity.
file_extension varchar2 File Extension filters on the platform, writable, file.extension The extension of the file.
file_id int64 File ID filters on the platform, writable, file.id The ID of this file
file_modelId int64 File Model ID filters on the platform, writable, file.modelId The ID of the associated type.
file_modelType varchar2 File Model Type filters on the platform, writable, file.modelType The category of the file.
file_name varchar2 File Name filters on the platform, writable, file.name The public name of the file.
file_secureHash varchar2 itgen_bouw7_file_securehash filters on the platform, writable, file.secureHash A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication.
file_size int64 File Size filters on the platform, writable, file.size The size of the file in bytes.
file_updatedAt datetime File Updated at filters on the platform, writable, file.updatedAt The last updated time of the entity.
file_updatedBy varchar2 File Updated by filters on the platform, writable, file.updatedBy The user that last updated the entity.
file_uri varchar2 File URI filters on the platform, writable, file.uri The URI of the file, used to fetch the contents.
gAccountPercentage varchar2 G-Account Percentage filters on the platform, writable, gAccountPercentage The g account percentage of the branch.
gAccountText varchar2(255) G-Account Text filters on the platform, writable, gAccountText The g account text of the branch.
id int64 ID filters on the platform, writable, id ID of the branch.
invoiceFooter varchar2 Invoice Footer filters on the platform, writable, invoiceFooter The invoice footer text.
nAccountText varchar2(255) N-Account Text filters on the platform, writable, nAccountText The n account text of the branch.
name varchar2(255) Name filters on the platform, writable, name Name of the branch.
phoneNumber varchar2(255) Phone Number filters on the platform, writable, phoneNumber Phone number of the branch.
updatedAt datetime Updated At filters on the platform, writable, updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by filters on the platform, writable, updatedBy The user that last updated the entity.
useOrganizationInfo char Use Organisation Info filters on the platform, writable, useOrganizationInfo If organization information should be used instead of branch information.
vatNumber varchar2(255) VAT Number filters on the platform, writable, vatNumber VAT number of the branch.
wageComponentPercentage varchar2 Wage Component Percentage filters on the platform, writable, wageComponentPercentage The wage component percentage of the branch.
website varchar2(255) Website filters on the platform, writable, website The website of the branch.
zipCode varchar2(20) ZIP Code filters on the platform, writable, zipCode ZIP code of the branch.

Release Notes

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