ContactCustomAttributeValuesById: Bouw7 Contact Custom Attribute Values by ID
read only REST
- Catalog:
Bouw7 - Schema:
Contact - Label: Contact Custom Attribute Values by ID
Returns a single contact based on the given ID. Returns a single contact based on the given ID.
Can only retrieve data.
Summary
Returns a single contact based on the given ID.
API Source
- Endpoint:
/contact/{id} - Operation:
get /contact/{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 ContactCustomAttributeValuesById 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, ::ancestor. |
The account number. | |
agreed |
varchar2 |
Agreed Hourly Rate | filters on the platform, writable, ::ancestor. |
The agreed hourly rate. | |
city |
varchar2 |
City | filters on the platform, writable, ::ancestor. |
The city name. | |
coc |
varchar2 |
Chamber of Commerce Number | filters on the platform, writable, ::ancestor. |
The chamber of commerce number. | |
contact |
varchar2 |
Contact Person Name | filters on the platform, writable, ::ancestor. |
The name of person to contact. | |
contact |
int64 |
Contact Type ID | filters on the platform, writable, ::ancestor. |
The ID of contact type. | |
contact |
varchar2 |
Contact Type Name | filters on the platform, writable, ::ancestor. |
The name of contact type. | |
country |
varchar2 |
Country Code | filters on the platform, writable, ::ancestor. |
An ISO 3166-2 representation of the country. | |
created |
datetime |
Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
custom |
varchar2 |
Custom Attribute Field Type | writable, custom |
The I18N key of the field type. | |
custom |
int64 |
Custom Attribute Field Type ID | writable, custom |
The ID of the field type. | |
custom |
int64 |
Custom Attribute ID | writable, custom |
The ID of the custom attribute. | |
custom |
char |
Custom Attribute Is Displayed on Completion | writable, custom |
Whether the custom attribute is displayed on a completion document. | |
custom |
char |
Custom Attribute Is Displayed on Invoice | writable, custom |
Whether the custom attribute is displayed on an invoice document. | |
custom |
char |
Custom Attribute Is Read-only | writable, custom |
Whether the custom attribute is a read-only field. | |
custom |
char |
Custom Attribute Is Required | writable, custom |
Whether the custom attribute is a required field. | |
custom |
varchar2 |
Custom Attribute Name | writable, custom |
The name of the custom attribute. | |
debtor |
varchar2 |
Debtor Number | filters on the platform, writable, ::ancestor. |
The debtor number. | |
email |
varchar2 |
filters on the platform, writable, ::ancestor. |
The email address. | ||
expiration |
int64 |
Expiration Reminder | filters on the platform, writable, ::ancestor. |
Expiration reminder days. | |
first |
int64 |
First Reminder | filters on the platform, writable, ::ancestor. |
The first reminder. | |
g |
varchar2 |
G-Account Percentage | filters on the platform, writable, ::ancestor. |
G-account percentage. | |
g |
varchar2 |
G-Account Text | filters on the platform, writable, ::ancestor. |
G-account text. | |
gl |
varchar2 |
General Ledger Account Code Invoice | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for invoice related items. | |
gl |
varchar2 |
General Ledger Account Code Purchase | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for purchase related items. | |
gln |
varchar2 |
GLN Number | filters on the platform, writable, ::ancestor. |
The Global Location Number. | |
hourly |
varchar2 |
Hourly Rate | filters on the platform, writable, ::ancestor. |
The hourly rate. | |
house |
varchar2 |
House Number | filters on the platform, writable, ::ancestor. |
The house number (incl. additions). | |
id |
int64 |
ID | filters on the platform, writable, ::ancestor. |
The ID of contact. | |
information |
varchar2 |
Information | filters on the platform, writable, ::ancestor. |
Additional information about the contact. | |
invoice |
varchar2 |
Invoice Mail | filters on the platform, writable, ::ancestor. |
The invoice mail. | |
invoice |
varchar2 |
Invoice Subject | filters on the platform, writable, ::ancestor. |
The invoice subject. | |
invoice |
varchar2 |
Invoice UBL Version | filters on the platform, writable, ::ancestor. |
The preferred UBL invoice version for this contact. | |
is |
char |
Is VAT Shifted | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
mobile |
varchar2 |
Mobile Number | filters on the platform, writable, ::ancestor. |
The mobile phone number. | |
n |
varchar2 |
N-Account Text | filters on the platform, writable, ::ancestor. |
N-account text. | |
name |
varchar2 |
Name | filters on the platform, writable, ::ancestor. |
The contact name. | |
phone |
varchar2 |
Phone Number | filters on the platform, writable, ::ancestor. |
The phone number. | |
planning |
varchar2 |
Planning | filters on the platform, writable, ::ancestor. |
The planning text. | |
reminder |
varchar2 |
Reminder Mail | filters on the platform, writable, ::ancestor. |
The reminder mail. | |
second |
int64 |
Second Reminder | filters on the platform, writable, ::ancestor. |
The second reminder. | |
selling |
varchar2 |
Selling Hourly Rate | filters on the platform, writable, ::ancestor. |
The selling hourly rate. | |
social |
varchar2 |
Social Security Number | filters on the platform, writable, ::ancestor. |
The Social Security Number. | |
street |
varchar2 |
Street Name | filters on the platform, writable, ::ancestor. |
The street name of contact. | |
surcharges_ |
varchar2 |
Surcharges Delivery Ticket | filters on the platform, writable, ::ancestor. |
The delivery ticket. | |
surcharges_ |
varchar2 |
Surcharges Equipment | filters on the platform, writable, ::ancestor. |
The equipment. | |
surcharges_ |
varchar2 |
Surcharges Material | filters on the platform, writable, ::ancestor. |
The material. | |
surcharges_ |
varchar2 |
Surcharges Others | filters on the platform, writable, ::ancestor. |
Others. | |
surcharges_ |
varchar2 |
Surcharges Purchase Invoice | filters on the platform, writable, ::ancestor. |
The purchase invoice. | |
surcharges_ |
varchar2 |
Surcharges Sub-contracting | filters on the platform, writable, ::ancestor. |
Subcontracting. | |
surcharges_ |
varchar2 |
Surcharges Work Outsourcing | filters on the platform, writable, ::ancestor. |
The work outsourcing. | |
updated |
datetime |
Updated At | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
value |
varchar2 |
Value | writable, value |
The value of the custom attribute. | |
vat |
varchar2 |
VAT Number | filters on the platform, writable, ::ancestor. |
The value added tax number. | |
wage |
varchar2 |
Wage Component Percentage | filters on the platform, writable, ::ancestor. |
Wage component percentage. | |
zip |
varchar2 |
ZIP Code | filters on the platform, writable, ::ancestor. |
The zip-code. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: