# Departments: ionBIZ Departments - Catalog: `ionBIZ` - Label: Departments - Retrieve: true ## Table Columns The columns of the table `Departments` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Active` | `boolean` | Active | ☐ | | | `AllowTimesheetsOnPublicHolidays` | `boolean` | Allow Timesheets on Public Holidays | ☐ | | | `AllowTimesheetsOnSundays` | `boolean` | Allow Timesheets on Sundays | ☐ | | | `Code` | `string` | Code | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `DefaultColor` | `string` | Default Colour | ☐ | | | `DefaultFlexOTCounterDayFrom` | `datetimeoffset` | Default Flex o t Counter Day from | ☐ | | | `DefaultName` | `string` | Default Name | ☐ | | | `DefaultRoleId` | `int32` | Default Role ID | ☐ | | | `DefaultShortName` | `string` | Default Short Name | ☐ | | | `DepartmentBossInvoiceExportId` | `int32` | Department Boss Invoice Export ID | ☐ | | | `ExternalCode` | `string` | External Code | ☐ | | | `GenericEmailLeaves` | `string` | Generic Email Leaves | ☐ | | | `Id` | `int32` | ID | ☑ | | | `ImportPlanningSubjectAs` | `int32` | Import Planning Subject as | ☐ | | | `IsDefault` | `boolean` | Is Default | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `NegQtyAllowedOvertime` | `int64` | Negative Quantity Allowed Overtime | ☐ | | | `ParentId` | `int32` | Parentid | ☐ | | | `Sequence` | `int32` | Sequence | ☐ | | | `WorkHoursPerDay` | `decimal` | Workhours per Day | ☐ | |