# Plannings: ionBIZ Planning - Catalog: `ionBIZ` - Label: Planning - Retrieve: true ## Table Columns The columns of the table `Plannings` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AddTravelReportingTime` | `boolean` | Add Travel Reporting Time | ☐ | | | `ApprovalDate` | `datetimeoffset` | Approval Date | ☐ | | | `ApproverId` | `int32` | Approver ID | ☐ | | | `BarColor` | `string` | Bar Colour | ☐ | | | `Comment` | `string` | Comment | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `Deadline` | `datetimeoffset` | Deadline | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `Distance` | `decimal` | Distance | ☐ | | | `Duration` | `int64` | Duration | ☐ | | | `EndLag` | `int64` | End Lag | ☐ | | | `ExcludeFromCapacity` | `boolean` | Exclude from Capacity | ☐ | | | `FrontColor` | `string` | Front Colour | ☐ | | | `FunctionId` | `int32` | Function ID | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IncludeBreaks` | `boolean` | Include Breaks | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IsRecurrenceOutOfTheRule` | `boolean` | Is Recurrence out of the Rule | ☐ | | | `IssueId` | `int32` | Issue ID | ☐ | | | `ItemEndDate` | `datetimeoffset` | Item End Date | ☐ | | | `ItemStartDate` | `datetimeoffset` | Item Start Date | ☐ | | | `LastModifiedDate` | `datetimeoffset` | Last Modified Date | ☐ | | | `Location` | `string` | Location | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `NumberOfMinutes` | `int32` | Number of Minutes | ☐ | | | `Percentage` | `decimal` | Percentage | ☐ | | | `PlanningDraftId` | `int32` | Planning Draft ID | ☐ | | | `PlanningDraftPlanningId` | `int32` | Planning Draft Planning ID | ☐ | | | `PlanningLinkedGroupId` | `int32` | Planning Linked Group ID | ☐ | | | `PlanningRecurrenceGroupId` | `int32` | Planning Recurrence Group ID | ☐ | | | `PlanningResourceRequestLineAmountId` | `int32` | Planning Resource Request Line Amount ID | ☐ | | | `PlanningTimeLinkedGroupId` | `int32` | Planning Time Linked Group ID | ☐ | | | `ProductionPlanningId` | `int32` | Production Planning ID | ☐ | | | `ProjectActivityId` | `int32` | Project Activity ID | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `QuoteId` | `int32` | Quote ID | ☐ | | | `QuoteLineId` | `int32` | Quote Line ID | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `ReportingPlanningId` | `int32` | Reporting Planning ID | ☐ | | | `ResourceId` | `int32` | Resource ID | ☐ | | | `SkillId` | `int32` | Skill ID | ☐ | | | `StartLag` | `int64` | Start Lag | ☐ | | | `StatusId` | `int32` | Status ID | ☐ | | | `Subject` | `string` | Subject | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `TaskResourceIsLinked` | `boolean` | Task Resource is Linked | ☐ | | | `TimelineId` | `int32` | Timeline ID | ☐ | | | `Title` | `string` | Title | ☐ | | | `TravelPlanningId` | `int32` | Travel Planning ID | ☐ | | | `UpdateByWorkSchedule` | `boolean` | Update by Work Schedule | ☐ | | | `WorkLocationId` | `int32` | Work Location ID | ☐ | |