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 |
|---|---|---|---|---|---|
account |
varchar2 |
Account Number | filters on the platform, writable, account |
Account number of the branch. | |
address |
varchar2 |
Address | filters on the platform, writable, address |
Address of the branch. | |
afas |
varchar2 |
AFAS Administration | filters on the platform, writable, afas |
Afas administration code of the branch. | |
afas |
varchar2 |
AFAS Project Leader | filters on the platform, writable, afas |
Afas project leader of the branch. | |
city |
varchar2 |
City | filters on the platform, writable, city |
City of the branch. | |
coc |
varchar2 |
Chamber of Commerce Number | filters on the platform, writable, coc |
The COC number. | |
code |
varchar2 |
Code | filters on the platform, writable, code |
The code of the branch. | |
company |
varchar2 |
Company Name | filters on the platform, writable, company |
The company name of the branch. | |
country |
varchar2 |
Country Code | filters on the platform, writable, country |
An ISO 3166-2 representation of the country. | |
created |
datetime |
Created at | filters on the platform, writable, created |
The creation time of the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, created |
The user that created the entity. | |
division_ |
varchar2 |
Division Description | filters on the platform, writable, division. |
The description of the division this object is associated with. | |
division_ |
varchar2 |
itgen_bouw7_division_exactpaymentconditionpurchase | filters on the platform, writable, division. |
A default payment condition to use for purchase related items. | |
division_ |
varchar2 |
itgen_bouw7_division_exactpaymentconditionsales | filters on the platform, writable, division. |
A default payment condition to use for sales related items. | |
division_ |
varchar2 |
Division General Ledger Account Code | filters on the platform, writable, division. |
A general ledger account code to use for sales related items. | |
division_ |
varchar2 |
Division General Ledger Account Code Purchase | filters on the platform, writable, division. |
A general ledger account code to use for purchase related items. | |
division_ |
int64 |
Division ID | filters on the platform, writable, division. |
The ID of the division this object is associated with. | |
division_ |
varchar2 |
Division Journal Code | filters on the platform, writable, division. |
A journal code to use for sales related items. | |
division_ |
varchar2 |
Division Journal Code Purchase | filters on the platform, writable, division. |
A journal code to use for purchase related items. | |
division_ |
varchar2 |
itgen_bouw7_division_journalcodeworkinprogress | filters on the platform, writable, division. |
A default journal code to use for work in progress related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_costcenterequipment | filters on the platform, writable, division. |
A cost center to use for equipment related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_costcenterequipmentdebit | filters on the platform, writable, division. |
A cost center to use for equipment debit related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_costcenterhours | filters on the platform, writable, division. |
A cost center to use for hours related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_costcenterhoursdebit | filters on the platform, writable, division. |
A cost center to use for hours debit related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_costcentermaterial | filters on the platform, writable, division. |
A cost center to use for material related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_costcentermaterialdebit | filters on the platform, writable, division. |
A cost center to use for material debit related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_costcenterpurchase | filters on the platform, writable, division. |
A cost center to use for purchase related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_costcenterpurchasedebit | filters on the platform, writable, division. |
A cost center to use for purchase debit related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_costcentersales | filters on the platform, writable, division. |
A cost center to use for sales related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_costcentersalesdebit | filters on the platform, writable, division. |
A cost center to use for sales debit related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_costcenterwaste | filters on the platform, writable, division. |
A cost center to use for waste related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_costcenterwastedebit | filters on the platform, writable, division. |
A cost center to use for waste debit related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodeequipment | filters on the platform, writable, division. |
A general ledger account code to use for equipment related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodeequipmentclosing | filters on the platform, writable, division. |
A general ledger account code to use for equipment closing related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodeequipmentdebit | filters on the platform, writable, division. |
A general ledger account code to use for equipment debit related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodehours | filters on the platform, writable, division. |
A general ledger account code to use for hours related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodehoursclosing | filters on the platform, writable, division. |
A general ledger account code to use for hours closing related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodehoursdebit | filters on the platform, writable, division. |
A general ledger account code to use for hours debit related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodematerial | filters on the platform, writable, division. |
A general ledger account code to use for material related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodematerialclosing | filters on the platform, writable, division. |
A general ledger account code to use for material closing related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodematerialdebit | filters on the platform, writable, division. |
A general ledger account code to use for material debit related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodepurchase | filters on the platform, writable, division. |
A general ledger account code to use for purchase related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodepurchaseclosing | filters on the platform, writable, division. |
A general ledger account code to use for purchase closing related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodepurchasedebit | filters on the platform, writable, division. |
A general ledger account code to use for purchase debit related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodesales | filters on the platform, writable, division. |
A general ledger account code to use for sales related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodesalesclosing | filters on the platform, writable, division. |
A general ledger account code to use for sales closing related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodesalesdebit | filters on the platform, writable, division. |
A general ledger account code to use for sales debit related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodewaste | filters on the platform, writable, division. |
A general ledger account code to use for waste related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodewasteclosing | filters on the platform, writable, division. |
A general ledger account code to use for waste closing related items. | |
division_ |
varchar2 |
itgen_bouw7_division_workinprogresssettings_glaccountcodewastedebit | filters on the platform, writable, division. |
A general ledger account code to use for waste debit related items. | |
division_ |
int64 |
itgen_bouw7_division_workinprogresssettings_id | filters on the platform, writable, division. |
The ID of the work in progress settings. | |
email |
varchar2 |
filters on the platform, writable, email |
Email of the branch. | ||
file_ |
datetime |
File Created at | filters on the platform, writable, file. |
The creation time of the entity. | |
file_ |
varchar2 |
File Created by | filters on the platform, writable, file. |
The user that created the entity. | |
file_ |
varchar2 |
File Extension | filters on the platform, writable, file. |
The extension of the file. | |
file_ |
int64 |
File ID | filters on the platform, writable, file. |
The ID of this file | |
file_ |
int64 |
File Model ID | filters on the platform, writable, file. |
The ID of the associated type. | |
file_ |
varchar2 |
File Model Type | filters on the platform, writable, file. |
The category of the file. | |
file_ |
varchar2 |
File Name | filters on the platform, writable, file. |
The public name of the file. | |
file_ |
varchar2 |
itgen_bouw7_file_securehash | filters on the platform, writable, file. |
A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. | |
file_ |
int64 |
File Size | filters on the platform, writable, file. |
The size of the file in bytes. | |
file_ |
datetime |
File Updated at | filters on the platform, writable, file. |
The last updated time of the entity. | |
file_ |
varchar2 |
File Updated by | filters on the platform, writable, file. |
The user that last updated the entity. | |
file_ |
varchar2 |
File URI | filters on the platform, writable, file. |
The URI of the file, used to fetch the contents. | |
g |
varchar2 |
G-Account Percentage | filters on the platform, writable, g |
The g account percentage of the branch. | |
g |
varchar2 |
G-Account Text | filters on the platform, writable, g |
The g account text of the branch. | |
id |
int64 |
ID | filters on the platform, writable, id |
ID of the branch. | |
invoice |
varchar2 |
Invoice Footer | filters on the platform, writable, invoice |
The invoice footer text. | |
n |
varchar2 |
N-Account Text | filters on the platform, writable, n |
The n account text of the branch. | |
name |
varchar2 |
Name | filters on the platform, writable, name |
Name of the branch. | |
phone |
varchar2 |
Phone Number | filters on the platform, writable, phone |
Phone number of the branch. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, updated |
The user that last updated the entity. | |
use |
char |
Use Organisation Info | filters on the platform, writable, use |
If organization information should be used instead of branch information. | |
vat |
varchar2 |
VAT Number | filters on the platform, writable, vat |
VAT number of the branch. | |
wage |
varchar2 |
Wage Component Percentage | filters on the platform, writable, wage |
The wage component percentage of the branch. | |
website |
varchar2 |
Website | filters on the platform, writable, website |
The website of the branch. | |
zip |
varchar2 |
ZIP Code | filters on the platform, writable, zip |
ZIP code of the branch. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: