# ProjectCategoryDivisionSettings: Bouw7 Project Category Division Settings Return a set of project categories for the organization. Return a set of project categories for the organization. - Catalog: `Bouw7` - Schema: `Organization` - Label: Project Category Division Settings 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 `ProjectCategoryDivisionSettings` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `code` | `varchar2` | Code | ☐ | The code for the category. | | `costCenterGeneralCosts` | `varchar2`(255) | Cost Centre General Costs | ☐ | A cost center to use for general costs related items. | | `costCenterGeneralCostsDebit` | `varchar2`(255) | Cost Centre General Costs Debit | ☐ | A cost center to use for general costs debit related items. | | `createdAt` | `datetime` | Created at | ☐ | The creation time of the entity. | | `createdBy` | `varchar2` | Created by | ☐ | The user that created the entity. | | `divisionId` | `int64` | Division ID | ☐ | The ID of the linked division. | | `generalCostsOrProfit` | `varchar2` | General Costs or Profit | ☐ | The general costs or profit for the category. | | `generalCostsPercentage` | `varchar2` | General Costs Percentage | ☐ | The general costs percentage for the category. | | `glAccountCodeGeneralCosts` | `varchar2`(255) | GL Account Code General Costs | ☐ | A general ledger account code to use for general costs related items. | | `glAccountCodeGeneralCostsClosing` | `varchar2`(255) | GL Account Code General Costs Closing | ☐ | A general ledger account code to use for general costs closing related items. | | `glAccountCodeGeneralCostsDebit` | `varchar2`(255) | GL Account Code General Costs Debit | ☐ | A general ledger account code to use for general costs debit related items. | | `grossProfitMargin` | `varchar2` | Gross Profit Margin | ☐ | The gross profit margin for the category. | | `id_2` | `int64` | ID | ☐ | The ID of the category. | | `id` | `int64` | ID | ☐ | The ID of the division project category settings. | | `name` | `varchar2` | Name | ☐ | The name of the category. | | `updatedAt` | `datetime` | Updated At | ☐ | The last updated time of the entity. | | `updatedBy` | `varchar2` | Updated by | ☐ | The user that last updated the entity. |