# ContactDivisionsById: Bouw7 Contact Divisions by ID Returns a single contact based on the given ID. Returns a single contact based on the given ID. - Catalog: `Bouw7` - Schema: `Contact` - Label: Contact Divisions by ID This is a read-only table function. The Bouw7 API may not support changing the data or the Invantive UniversalSQL driver for Bouw7 does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Bouw7 API. ## Parameters of Table Function The following parameters can be used to control the behaviour of the table function `ContactDivisionsById`. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values. Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three. Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third. | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `id` | `` | ☑ | | | ## Columns of Table Function The columns of the table function `ContactDivisionsById` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `accountNumber` | `varchar2`(256) | Account Number | ☐ | The account number. | | `agreedHourlyRate` | `varchar2` | Agreed Hourly Rate | ☐ | The agreed hourly rate. | | `city` | `varchar2`(256) | City | ☐ | The city name. | | `cocNumber` | `varchar2`(256) | Chamber of Commerce Number | ☐ | The chamber of commerce number. | | `code` | `varchar2` | Code | ☐ | The debtor/creditor number (code) of the contact in the associated division | | `contactPersonName` | `varchar2` | Contact Person Name | ☐ | The name of person to contact. | | `contactType_id` | `int64` | Contact Type ID | ☐ | The ID of contact type. | | `contactType_name` | `varchar2` | Contact Type Name | ☐ | The name of contact type. | | `countryCode` | `varchar2`(2) | Country Code | ☐ | An ISO 3166-2 representation of the country. | | `createdAt` | `datetime` | Created at | ☐ | The creation time of the entity. | | `createdBy` | `varchar2` | Created by | ☐ | The user that created the entity. | | `debtorNumber` | `varchar2`(256) | Debtor Number | ☐ | The debtor number. | | `divisionId` | `int64` | Division ID | ☐ | The division ID of an Exact Online environment. | | `email` | `varchar2`(256) | Email | ☐ | The email address. | | `expirationReminder` | `int64` | Expiration Reminder | ☐ | Expiration reminder days. | | `firstReminder` | `int64` | First Reminder | ☐ | The first reminder. | | `gAccountPercentage` | `varchar2` | G-Account Percentage | ☐ | G-account percentage. | | `gAccountText` | `varchar2`(255) | G-Account Text | ☐ | G-account text. | | `glAccountCode` | `varchar2` | General Ledger Account Code | ☐ | A default general ledger account code to use for sales related items. | | `glAccountCodeInvoice` | `varchar2` | General Ledger Account Code Invoice | ☐ | A default general ledger account code to use for invoice related items. | | `glAccountCodePurchase_2` | `varchar2` | | ☐ | A default general ledger account code to use for purchase related items. | | `glAccountCodePurchase` | `varchar2` | General Ledger Account Code Purchase | ☐ | A default general ledger account code to use for purchase related items. | | `glnNumber` | `varchar2`(13) | GLN Number | ☐ | The Global Location Number. | | `hourlyRate` | `varchar2` | Hourly Rate | ☐ | The hourly rate. | | `houseNumber` | `varchar2` | House Number | ☐ | The house number (incl. additions). | | `id_2` | `int64` | ID | ☐ | The ID of contact. | | `id` | `int64` | ID | ☐ | The ID of the contact division link. | | `information` | `varchar2` | Information | ☐ | Additional information about the contact. | | `invoiceMail` | `varchar2`(255) | Invoice Mail | ☐ | The invoice mail. | | `invoiceSubject` | `varchar2`(255) | Invoice Subject | ☐ | The invoice subject. | | `invoiceUblVersion` | `varchar2` | Invoice UBL Version | ☐ | The preferred UBL invoice version for this contact. | | `isVatShifted` | `char` | Is VAT Shifted | ☐ | Whether VAT is shifted for the contact. | | `mobileNumber` | `varchar2`(256) | Mobile Number | ☐ | The mobile phone number. | | `nAccountText` | `varchar2`(255) | N-Account Text | ☐ | N-account text. | | `name` | `varchar2`(256) | Name | ☐ | The contact name. | | `paymentConditionPurchase` | `varchar2`(255) | Payment Condition Purchase | ☐ | A default payment condition to use for purchase related items. | | `paymentConditionSales` | `varchar2`(255) | Payment Condition Sales | ☐ | A default payment condition to use for sales related items. | | `phoneNumber` | `varchar2`(256) | Phone Number | ☐ | The phone number. | | `planning` | `varchar2` | Planning | ☐ | The planning text. | | `reminderMail` | `varchar2`(255) | Reminder Mail | ☐ | The reminder mail. | | `secondReminder` | `int64` | Second Reminder | ☐ | The second reminder. | | `sellingHourlyRate` | `varchar2` | Selling Hourly Rate | ☐ | The selling hourly rate. | | `socialSecurityNumber` | `varchar2`(255) | Social Security Number | ☐ | The Social Security Number. | | `streetName` | `varchar2` | Street Name | ☐ | The street name of contact. | | `surcharges_deliveryTicket` | `varchar2` | Surcharges Delivery Ticket | ☐ | The delivery ticket. | | `surcharges_equipment` | `varchar2` | Surcharges Equipment | ☐ | The equipment. | | `surcharges_material` | `varchar2` | Surcharges Material | ☐ | The material. | | `surcharges_others` | `varchar2` | Surcharges Others | ☐ | Others. | | `surcharges_purchaseInvoice` | `varchar2` | Surcharges Purchase Invoice | ☐ | The purchase invoice. | | `surcharges_subcontracting` | `varchar2` | Surcharges Sub-contracting | ☐ | Subcontracting. | | `surcharges_workOutsourcing` | `varchar2` | Surcharges Work Outsourcing | ☐ | The work outsourcing. | | `updatedAt` | `datetime` | Updated At | ☐ | The last updated time of the entity. | | `updatedBy` | `varchar2` | Updated by | ☐ | The user that last updated the entity. | | `vatNumber` | `varchar2`(256) | VAT Number | ☐ | The value added tax number. | | `wageComponentPercentage` | `varchar2` | Wage Component Percentage | ☐ | Wage component percentage. | | `zipCode` | `varchar2`(20) | ZIP Code | ☐ | The zip-code. |