InvoiceCompanyInfoByProject: Bouw7 Invoice Company Information by Project
read only REST
- Catalog:
Bouw7 - Schema:
Invoicing - Label: Invoice Company Information by Project
Returns the company information based on the given project. Returns the company information based on the given project.
Can only retrieve data.
Summary
Returns the company information based on the given project.
API Source
- Endpoint:
/invoicing-project/{project}/company-info - Operation:
get /invoicing-project/{project}/company-info
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 |
|---|---|---|---|---|
project |
`` | Project ID |
Table Columns
The columns of the table InvoiceCompanyInfoByProject 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 |
|---|---|---|---|---|---|
city |
varchar2 |
City | filters on the platform, writable, city |
The city of residence of the supplier. | |
coc |
varchar2 |
Chamber of Commerce Number | filters on the platform, writable, coc |
The chamber of commerce number of the supplier. | |
country |
varchar2 |
Country | filters on the platform, writable, country |
The country of the supplier. | |
email |
varchar2 |
Email Address | filters on the platform, writable, email |
The email-address of the supplier. | |
expiration |
int64 |
Expiration Reminder Days | filters on the platform, writable, expiration |
The number of days before a reminder is sent. | |
g |
varchar2 |
G-Account Percentage | filters on the platform, writable, g |
The g account percentage for the customer. | |
g |
varchar2 |
G-Account Text | filters on the platform, writable, g |
The g account text for the customer. | |
house |
varchar2 |
House Number | filters on the platform, writable, house |
The house- or building-number of the supplier. | |
iban |
varchar2 |
IBAN | filters on the platform, writable, iban |
The IBAN-account number of the supplier. | |
logo_ |
datetime |
Logo Created at | filters on the platform, writable, logo. |
The creation time of the entity. | |
logo_ |
varchar2 |
Logo Created by | filters on the platform, writable, logo. |
The user that created the entity. | |
logo_ |
varchar2 |
Logo Extension | filters on the platform, writable, logo. |
The extension of the file. | |
logo_ |
int64 |
Logo ID | filters on the platform, writable, logo. |
The ID of this file | |
logo_ |
int64 |
Logo Model ID | filters on the platform, writable, logo. |
The ID of the associated type. | |
logo_ |
varchar2 |
Logo Model Type | filters on the platform, writable, logo. |
The category of the file. | |
logo_ |
varchar2 |
Logo Name | filters on the platform, writable, logo. |
The public name of the file. | |
logo_ |
varchar2 |
itgen_bouw7_logo_securehash | filters on the platform, writable, logo. |
A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. | |
logo_ |
int64 |
Logo Size | filters on the platform, writable, logo. |
The size of the file in bytes. | |
logo_ |
datetime |
Logo Updated at | filters on the platform, writable, logo. |
The last updated time of the entity. | |
logo_ |
varchar2 |
Logo Updated by | filters on the platform, writable, logo. |
The user that last updated the entity. | |
logo_ |
varchar2 |
Logo URI | filters on the platform, writable, logo. |
The URI of the file, used to fetch the contents. | |
n |
varchar2 |
N-Account Text | filters on the platform, writable, n |
The n account text for the customer. | |
name |
varchar2 |
Name | filters on the platform, writable, name |
The name of the supplier. | |
phone |
varchar2 |
Phone Number | filters on the platform, writable, phone |
The phone number of the supplier. | |
should |
char |
Should Copy Project Description | filters on the platform, writable, should |
Whether the project description should be copied. | |
show |
char |
Show Project Name on Invoice PDF | filters on the platform, writable, show |
Whether the project name will show on the invoice. | |
show |
char |
Show Project Number on Invoice | filters on the platform, writable, show |
Whether the project number will show on the invoice. | |
street |
varchar2 |
Street Name | filters on the platform, writable, street |
The street name of the supplier. | |
vat |
varchar2 |
VAT Number | filters on the platform, writable, vat |
The VAT-number of the supplier. | |
wage |
varchar2 |
Wage Component Percentage | filters on the platform, writable, wage |
The wage component percentage for the customer. | |
website |
varchar2 |
Website Address | filters on the platform, writable, website |
The website address of the supplier. | |
zip |
varchar2 |
ZIP Code | filters on the platform, writable, zip |
The zip-code of the supplier. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: