# Rptplanningsplanninglistresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rptplanningsplanninglistresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ActivityTypeId` | `int32` | Activity Type ID | ☐ | | | `ActivityTypeName` | `string` | Activity Type Name | ☐ | | | `ApprovalDate` | `datetimeoffset` | Approval Date | ☐ | | | `ApproverId` | `int32` | Approver ID | ☐ | | | `ApproverName` | `string` | Approver Name | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☑ | | | `CreatorId` | `int32` | Creator ID | ☑ | | | `CreatorName` | `string` | Creator Name | ☐ | | | `Deadline` | `datetimeoffset` | Deadline | ☐ | | | `Distance` | `decimal` | Distance | ☐ | | | `Duration` | `decimal` | Duration | ☑ | | | `End` | `datetimeoffset` | End | ☐ | | | `FunctionId` | `int32` | Function ID | ☐ | | | `FunctionName` | `string` | Function Name | ☐ | | | `HourFrom` | `datetimeoffset` | Hour from | ☐ | | | `HourlyRate` | `decimal` | Hourly Rate | ☐ | | | `HourTo` | `datetimeoffset` | Hour To | ☐ | | | `ID` | `int32` | ID | ☐ | | | `Issue` | `string` | Issue | ☐ | | | `LastModifiedDate` | `datetimeoffset` | Last Modified Date | ☐ | | | `LinkedResources` | `string` | Linked Resources | ☐ | | | `LocationId` | `int32` | Location ID | ☐ | | | `LocationName` | `string` | Location Name | ☐ | | | `MonthPlanningDate` | `int32` | Month Planning Date | ☐ | | | `OverlappingResources` | `string` | Overlapping Resources | ☐ | | | `Percentage` | `decimal` | Percentage | ☐ | | | `PlanningActivityId` | `int32` | Planning Activity ID | ☐ | | | `PlanningActivityName` | `string` | Planning Activity Name | ☐ | | | `PlanningDate` | `datetimeoffset` | Planning Date | ☐ | | | `PlanningStatus` | `string` | Planning Status | ☐ | | | `PlanningType` | `int32` | Planning Type | ☑ | | | `ProjectDepartmentId` | `int32` | Project Department ID | ☐ | | | `ProjectDepartmentName` | `string` | Project Department Name | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `ProjectIdText` | `string` | Project ID Text | ☐ | | | `ProjectLocation` | `string` | Project Location | ☐ | | | `ProjectManagerName` | `string` | Project Manager Name | ☐ | | | `ProjectName` | `string` | Project Name | ☐ | | | `ProjectSupervisorName` | `string` | Project Supervisor Name | ☐ | | | `ProjectType` | `string` | Project Type | ☐ | | | `RelationGroup` | `string` | Relation Group | ☐ | | | `RelationName` | `string` | Relation Name | ☐ | | | `ResourceDepartmentId` | `int32` | Resource Department ID | ☐ | | | `ResourceDepartmentName` | `string` | Resource Department Name | ☐ | | | `ResourceExternalCode` | `string` | Resource External Code | ☐ | | | `ResourceFunctionName` | `string` | Resource Function Name | ☐ | | | `ResourceId` | `int32` | Resource ID | ☑ | | | `ResourceInitials` | `string` | Resource Initials | ☐ | | | `ResourceName` | `string` | Resource Name | ☐ | | | `ResourceTypeId` | `int32` | Resource Type ID | ☐ | | | `ResourceTypeName` | `string` | Resource Type Name | ☐ | | | `Skill` | `string` | Skill | ☐ | | | `Start` | `datetimeoffset` | Start | ☐ | | | `Subject` | `string` | Subject | ☐ | | | `Task` | `string` | Task | ☐ | | | `TaskActivityId` | `int32` | Task Activity ID | ☐ | | | `TaskActivityName` | `string` | Task Activity Name | ☐ | | | `TaskEndDate` | `datetimeoffset` | Task End Date | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `TaskStartDate` | `datetimeoffset` | Task Start Date | ☐ | | | `TaskStatus` | `string` | Task Status | ☐ | | | `Title` | `string` | Title | ☐ | | | `TotalSales` | `decimal` | Total Sales | ☐ | | | `WorkLocationId` | `int32` | Work Location ID | ☐ | | | `WorkLocationName` | `string` | Work Location Name | ☐ | |