# ProjectTypes: ionBIZ Project Types - Catalog: `ionBIZ` - Label: Project Types - Retrieve: true ## Table Columns The columns of the table `ProjectTypes` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Active` | `boolean` | Active | ☐ | | | `Color` | `string` | Colour | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `DefaultDescription` | `string` | Default Description | ☐ | | | `DefaultForProduction` | `boolean` | Default for Production | ☐ | | | `DefaultName` | `string` | Default Name | ☐ | | | `DefaultOverheadFactorCosts` | `decimal` | Default Overhead Factor Costs | ☐ | | | `DefaultOverheadFactorTime` | `decimal` | Default Overhead Factor Time | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InvScheduleRequiredForStatusInProgress` | `int32` | Invoice Schedule Required for Status in Progress | ☐ | | | `IsDefault` | `boolean` | Is Default | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `ParentId` | `int32` | Parentid | ☐ | | | `RecalculateRotationIndexWhenBookingToThisType` | `boolean` | Recalculate Rotation Index when Booking to this Type | ☐ | | | `Sequence` | `int32` | Sequence | ☐ | | | `ShortName` | `string` | Short Name | ☐ | | | `ShowPlanningHAFromDS` | `boolean` | Show Planning HA from DS | ☐ | | | `ShowProductionTab` | `boolean` | Show Production Tab | ☐ | | | `UseInPlanningApproval` | `boolean` | Use in Planning Approval | ☐ | |