# Organization: Bouw7 Organisation Return basic information about the organization for the currently authenticated user. Return basic information about the organization the authenticated user is associated with. - Catalog: `Bouw7` - Schema: `Organization` - Label: Organisation This is a read-only table. 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. ## Table Columns The columns of the table `Organization` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `alternativeAddressPosition` | `char` | Alternative Address Position | ☐ | Whether to show the alternative address position. | | `city` | `varchar2` | City | ☐ | The organization's city. | | `cocNumber` | `varchar2` | Chamber of Commerce Number | ☐ | The organization's coc number. | | `contactFirstName` | `varchar2` | Contact First Name | ☐ | The contact first name. | | `contactLastName` | `varchar2` | Contact Last Name | ☐ | The contact last name. | | `country` | `varchar2` | Country | ☐ | The organization's country. | | `currency` | `varchar2` | Currency | ☐ | The currency used by this organization, e.g.: EUR. | | `emailAddress` | `varchar2` | Email Address | ☐ | The organization's email address. | | `expirationReminder` | `int64` | Expiration Reminder | ☐ | The expiration reminder days for this organization. | | `glnNumber` | `varchar2` | GLN Number | ☐ | The Global Location Number. | | `hasExactHostingAssociation` | `char` | | ☐ | Whether the organization has an exact hosting association. | | `hourlyRate` | `varchar2` | Hourly Rate | ☐ | The hourly rate for this organization. | | `houseNumber` | `varchar2` | House Number | ☐ | The organization's house number (incl. additions). | | `iban` | `varchar2` | IBAN | ☐ | The organization's IBAN. | | `id` | `int64` | ID | ☐ | The organization ID. | | `invoiceMail` | `varchar2` | Invoice Mail | ☐ | The invoice email address. | | `isAutomaticInvoiceNumbering` | `char` | | ☐ | Whether automatic invoice numbering is enabled for this organization. | | `isEnableAlternativeEmail` | `char` | | ☐ | Whether an alternative email is enabled for this organization. | | `language` | `varchar2` | Language | ☐ | The locale used by this organization, e.g.: nl-NL. | | `logo_createdAt` | `datetime` | Logo Created at | ☐ | The creation time of the entity. | | `logo_createdBy` | `varchar2` | Logo Created by | ☐ | The user that created the entity. | | `logo_extension` | `varchar2` | Logo Extension | ☐ | The extension of the file. | | `logo_id` | `int64` | Logo ID | ☐ | The ID of this file | | `logo_modelId` | `int64` | Logo Model ID | ☐ | The ID of the associated type. | | `logo_modelType` | `varchar2` | Logo Model Type | ☐ | The category of the file. | | `logo_name` | `varchar2` | Logo Name | ☐ | The public name of the file. | | `logo_secureHash` | `varchar2` | | ☐ | A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. | | `logo_size` | `int64` | Logo Size | ☐ | The size of the file in bytes. | | `logo_updatedAt` | `datetime` | Logo Updated at | ☐ | The last updated time of the entity. | | `logo_updatedBy` | `varchar2` | Logo Updated by | ☐ | The user that last updated the entity. | | `logo_uri` | `varchar2` | Logo URI | ☐ | The URI of the file, used to fetch the contents. | | `name` | `varchar2` | Name | ☐ | The organization name. | | `note` | `varchar2` | Note | ☐ | Note field for organization. | | `phoneNumber` | `varchar2` | Phone Number | ☐ | The organization's phone number. | | `prognosisHourlyRate` | `varchar2` | Prognosis Hourly Rate | ☐ | The prognosis hourly rate for this organization. | | `requireHourLogTimes` | `char` | Require Hour Log Times | ☐ | Whether hour log times are enabled and therefore required for this organization. | | `sellingHourlyRate` | `varchar2` | Selling Hourly Rate | ☐ | The selling hourly rate for this organization. | | `shouldCopyProjectDescription` | `char` | Should Copy Project Description | ☐ | True if the project description should be copied to an invoice. | | `status` | `int64` | Status | ☐ | The status of the organization. | | `streetName` | `varchar2` | Street Name | ☐ | The organization's street name. | | `vatNumber` | `varchar2` | VAT Number | ☐ | The organization's vat number. | | `website` | `varchar2` | Website | ☐ | The organization's website. | | `zipCode` | `varchar2` | ZIP Code | ☐ | The organization's zip-code. |