invantive documentation
Invantive Support ForumsLog In / Sign Up

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
accountNumber varchar2(256) Account Number filters on the platform, writable, ::ancestor.accountNumber The account number.
agreedHourlyRate varchar2 Agreed Hourly Rate filters on the platform, writable, ::ancestor.agreedHourlyRate The agreed hourly rate.
city varchar2(256) City filters on the platform, writable, ::ancestor.city The city name.
cocNumber varchar2(256) Chamber of Commerce Number filters on the platform, writable, ::ancestor.cocNumber The chamber of commerce number.
contactPersonName varchar2 Contact Person Name filters on the platform, writable, ::ancestor.contactPersonName The name of person to contact.
contactType_id int64 Contact Type ID filters on the platform, writable, ::ancestor.contactType.id The ID of contact type.
contactType_name varchar2 Contact Type Name filters on the platform, writable, ::ancestor.contactType.name The name of contact type.
countryCode varchar2(2) Country Code filters on the platform, writable, ::ancestor.countryCode An ISO 3166-2 representation of the country.
createdAt datetime Created at filters on the platform, writable, ::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Created by filters on the platform, writable, ::ancestor.createdBy The user that created the entity.
customAttribute_fieldType varchar2 Custom Attribute Field Type writable, customAttribute.fieldType The I18N key of the field type.
customAttribute_fieldTypeId int64 Custom Attribute Field Type ID writable, customAttribute.fieldTypeId The ID of the field type.
customAttribute_id int64 Custom Attribute ID writable, customAttribute.id The ID of the custom attribute.
customAttribute_isDisplayedOnCompletion char Custom Attribute Is Displayed on Completion writable, customAttribute.isDisplayedOnCompletion Whether the custom attribute is displayed on a completion document.
customAttribute_isDisplayedOnInvoice char Custom Attribute Is Displayed on Invoice writable, customAttribute.isDisplayedOnInvoice Whether the custom attribute is displayed on an invoice document.
customAttribute_isReadOnly char Custom Attribute Is Read-only writable, customAttribute.isReadOnly Whether the custom attribute is a read-only field.
customAttribute_isRequired char Custom Attribute Is Required writable, customAttribute.isRequired Whether the custom attribute is a required field.
customAttribute_name varchar2 Custom Attribute Name writable, customAttribute.name The name of the custom attribute.
debtorNumber varchar2(256) Debtor Number filters on the platform, writable, ::ancestor.debtorNumber The debtor number.
email varchar2(256) Email filters on the platform, writable, ::ancestor.email The email address.
expirationReminder int64 Expiration Reminder filters on the platform, writable, ::ancestor.expirationReminder Expiration reminder days.
firstReminder int64 First Reminder filters on the platform, writable, ::ancestor.firstReminder The first reminder.
gAccountPercentage varchar2 G-Account Percentage filters on the platform, writable, ::ancestor.gAccountPercentage G-account percentage.
gAccountText varchar2(255) G-Account Text filters on the platform, writable, ::ancestor.gAccountText G-account text.
glAccountCodeInvoice varchar2 General Ledger Account Code Invoice filters on the platform, writable, ::ancestor.glAccountCodeInvoice A default general ledger account code to use for invoice related items.
glAccountCodePurchase varchar2 General Ledger Account Code Purchase filters on the platform, writable, ::ancestor.glAccountCodePurchase A default general ledger account code to use for purchase related items.
glnNumber varchar2(13) GLN Number filters on the platform, writable, ::ancestor.glnNumber The Global Location Number.
hourlyRate varchar2 Hourly Rate filters on the platform, writable, ::ancestor.hourlyRate The hourly rate.
houseNumber varchar2 House Number filters on the platform, writable, ::ancestor.houseNumber The house number (incl. additions).
id int64 ID filters on the platform, writable, ::ancestor.id The ID of contact.
information varchar2 Information filters on the platform, writable, ::ancestor.information Additional information about the contact.
invoiceMail varchar2(255) Invoice Mail filters on the platform, writable, ::ancestor.invoiceMail The invoice mail.
invoiceSubject varchar2(255) Invoice Subject filters on the platform, writable, ::ancestor.invoiceSubject The invoice subject.
invoiceUblVersion varchar2 Invoice UBL Version filters on the platform, writable, ::ancestor.invoiceUblVersion The preferred UBL invoice version for this contact.
isVatShifted char Is VAT Shifted filters on the platform, writable, ::ancestor.isVatShifted Whether VAT is shifted for the contact.
mobileNumber varchar2(256) Mobile Number filters on the platform, writable, ::ancestor.mobileNumber The mobile phone number.
nAccountText varchar2(255) N-Account Text filters on the platform, writable, ::ancestor.nAccountText N-account text.
name varchar2(256) Name filters on the platform, writable, ::ancestor.name The contact name.
phoneNumber varchar2(256) Phone Number filters on the platform, writable, ::ancestor.phoneNumber The phone number.
planning varchar2 Planning filters on the platform, writable, ::ancestor.planning The planning text.
reminderMail varchar2(255) Reminder Mail filters on the platform, writable, ::ancestor.reminderMail The reminder mail.
secondReminder int64 Second Reminder filters on the platform, writable, ::ancestor.secondReminder The second reminder.
sellingHourlyRate varchar2 Selling Hourly Rate filters on the platform, writable, ::ancestor.sellingHourlyRate The selling hourly rate.
socialSecurityNumber varchar2(255) Social Security Number filters on the platform, writable, ::ancestor.socialSecurityNumber The Social Security Number.
streetName varchar2 Street Name filters on the platform, writable, ::ancestor.streetName The street name of contact.
surcharges_deliveryTicket varchar2 Surcharges Delivery Ticket filters on the platform, writable, ::ancestor.surcharges.deliveryTicket The delivery ticket.
surcharges_equipment varchar2 Surcharges Equipment filters on the platform, writable, ::ancestor.surcharges.equipment The equipment.
surcharges_material varchar2 Surcharges Material filters on the platform, writable, ::ancestor.surcharges.material The material.
surcharges_others varchar2 Surcharges Others filters on the platform, writable, ::ancestor.surcharges.others Others.
surcharges_purchaseInvoice varchar2 Surcharges Purchase Invoice filters on the platform, writable, ::ancestor.surcharges.purchaseInvoice The purchase invoice.
surcharges_subcontracting varchar2 Surcharges Sub-contracting filters on the platform, writable, ::ancestor.surcharges.subcontracting Subcontracting.
surcharges_workOutsourcing varchar2 Surcharges Work Outsourcing filters on the platform, writable, ::ancestor.surcharges.workOutsourcing The work outsourcing.
updatedAt datetime Updated At filters on the platform, writable, ::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by filters on the platform, writable, ::ancestor.updatedBy The user that last updated the entity.
value varchar2 Value writable, value The value of the custom attribute.
vatNumber varchar2(256) VAT Number filters on the platform, writable, ::ancestor.vatNumber The value added tax number.
wageComponentPercentage varchar2 Wage Component Percentage filters on the platform, writable, ::ancestor.wageComponentPercentage Wage component percentage.
zipCode varchar2(20) ZIP Code filters on the platform, writable, ::ancestor.zipCode The zip-code.

Release Notes

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