# Frmissueplain - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Frmissueplain` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Action` | `boolean` | Action | ☐ | | | `ActionDate` | `datetimeoffset` | Action Date | ☐ | | | `ActionRequiredById` | `int32` | Action Required by ID | ☐ | | | `ActualHours` | `int64` | Actual Hours | ☐ | | | `Area` | `string` | Area | ☐ | | | `AreaId` | `int32` | Area ID | ☐ | | | `AssignedOn` | `datetimeoffset` | Assigned on | ☐ | | | `AssignedOverdueAlarmIn` | `int64` | Assigned Overdue Alarm in | ☐ | | | `AssignedTo` | `string` | Assigned To | ☐ | | | `AssignedToUser` | `string` | Assigned to User | ☐ | | | `AssignedUserId` | `int32` | Assigned User ID | ☐ | | | `AssignIn` | `int64` | Assign In | ☐ | | | `AssignInColor` | `string` | Assign In Color | ☐ | | | `AssignInIconColor` | `string` | Assign In Icon Color | ☐ | | | `Billable` | `boolean` | Billable | ☑ | | | `BudgetType` | `int32` | Budget Type | ☑ | | | `CanAddTimesheet` | `boolean` | Can Add Timesheet | ☑ | | | `Category` | `string` | Category | ☐ | | | `CategoryId` | `int32` | Category ID | ☐ | | | `CategorySequence` | `int32` | Category Sequence | ☐ | | | `Color` | `string` | Colour | ☐ | | | `CompletedByContactId` | `int32` | Completed by Contact ID | ☐ | | | `CompletedByUserId` | `int32` | Completed by User ID | ☐ | | | `CompletedPercent` | `int32` | Completed (%) | ☐ | | | `CompletionDate` | `datetimeoffset` | Completion Date | ☐ | | | `ContactFirstName` | `string` | Contact First Name | ☐ | | | `ContactId` | `int32` | Contact ID | ☐ | | | `ContactLastName` | `string` | Contact Last Name | ☐ | | | `ContactName` | `string` | Contact Name | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☑ | | | `Creator` | `string` | Creator | ☐ | | | `CreatorContactId` | `int32` | Creator Contact ID | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `DepartmentName` | `string` | Department Name | ☐ | | | `Description` | `string` | Description | ☐ | | | `DueDate` | `datetimeoffset` | Due Date | ☐ | | | `DueDateColor` | `string` | Due Date Color | ☐ | | | `EscalatedToYou` | `boolean` | Escalated to You | ☐ | | | `EstimatedHours` | `decimal` | Estimated Hours | ☐ | | | `ExpectedDeliveryDate` | `datetimeoffset` | Expected Delivery Date | ☐ | | | `ExposeToRelationPortal` | `boolean` | Expose to Relation Portal | ☑ | | | `ExternalID` | `string` | External ID | ☐ | | | `FirstRespondedOn` | `datetimeoffset` | First Responded on | ☐ | | | `FirstResponseIn` | `int64` | First Response in | ☐ | | | `FirstResponseInColor` | `string` | First Response In Color | ☐ | | | `FirstResponseInIconColor` | `string` | First Response In Icon Color | ☐ | | | `FirstResponseOverdueAlarmIn` | `int64` | First Response Overdue Alarm in | ☐ | | | `GroupId` | `int32` | Group ID | ☐ | | | `GroupName` | `string` | Group Name | ☐ | | | `GroupSequence` | `int32` | Group Sequence | ☐ | | | `HasReminders` | `boolean` | Has Reminders | ☐ | | | `Id` | `int32` | ID | ☑ | | | `Invoiced` | `decimal` | Invoiced | ☐ | | | `IsCompleted` | `boolean` | Is Completed | ☐ | | | `IssueId` | `string` | Issue ID | ☐ | | | `IssueStatusActionRequired` | `boolean` | Issue Status Action Required | ☐ | | | `IssueStatusUseEscalationRule` | `boolean` | Issue Status Use Escalation Rule | ☐ | | | `IterationId` | `int32` | Iteration ID | ☐ | | | `IterationName` | `string` | Iteration Name | ☐ | | | `IterationOwnerId` | `int32` | Iteration Owner ID | ☐ | | | `IterationSequence` | `int32` | Iteration Sequence | ☐ | | | `Location` | `string` | Location | ☐ | | | `ModifiedByContactId` | `int32` | Modified by Contact ID | ☐ | | | `ModifiedByUserId` | `int32` | Modified by User ID | ☐ | | | `ModifiedDate` | `datetimeoffset` | Modified Date | ☐ | | | `ModifierName` | `string` | Modifier Name | ☐ | | | `Name` | `string` | Name | ☐ | | | `Owner` | `string` | Owner | ☐ | | | `OwnerId` | `int32` | Owner ID | ☐ | | | `PermissionsDeleteWithNoLinks` | `boolean` | Permissions Delete with No Links | ☑ | | | `Planned` | `int64` | Planned | ☐ | | | `Points` | `int32` | Points | ☐ | | | `Priority` | `string` | Priority | ☐ | | | `PriorityColor` | `string` | Priority Color | ☐ | | | `PriorityId` | `int32` | Priority ID | ☐ | | | `PrioritySequence` | `int32` | Priority Sequence | ☐ | | | `Project` | `string` | Project | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `ProjectIdString` | `string` | Project ID String | ☐ | | | `ProjectManagerId` | `int32` | Project Manager ID | ☐ | | | `ProjectSupervisorId` | `int32` | Project Supervisor ID | ☐ | | | `Quote` | `string` | Quote | ☐ | | | `QuoteId` | `int32` | Quote ID | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `RelationName` | `string` | Relation Name | ☐ | | | `ReleaseNotesCount` | `int32` | Release Notes Count | ☐ | | | `ResolutionIn` | `int64` | Resolution in | ☐ | | | `ResolutionInColor` | `string` | Resolution In Color | ☐ | | | `ResolutionInIconColor` | `string` | Resolution In Icon Color | ☐ | | | `ResolutionOverdueAlarmIn` | `int64` | Resolution Overdue Alarm in | ☐ | | | `ResolutionTimersCount` | `int32` | Resolution Timers Count | ☐ | | | `RowNumber` | `int32` | Row Number | ☑ | | | `SalesPrice` | `decimal` | Salesprice | ☐ | | | `Severity` | `string` | Severity | ☐ | | | `SeverityColor` | `string` | Severity Color | ☐ | | | `SeverityId` | `int32` | Severity ID | ☐ | | | `SeveritySequence` | `int32` | Severity Sequence | ☐ | | | `ShowOnHome` | `boolean` | Show on Home | ☐ | | | `ShowPauseTimer` | `boolean` | Show Pause Timer | ☐ | | | `ShowRestartTimer` | `boolean` | Show Restart Timer | ☐ | | | `ShowSla` | `boolean` | Show SLA | ☐ | | | `ShowStopTimer` | `boolean` | Show Stop Timer | ☐ | | | `SkillName` | `string` | Skill Name | ☐ | | | `SLATemplateId` | `int32` | SLA Template ID | ☐ | | | `SoftwareId` | `int32` | Software ID | ☐ | | | `SoftwareName` | `string` | Software Name | ☐ | | | `SoftwareSequence` | `int32` | Software Sequence | ☐ | | | `Status` | `string` | Status | ☐ | | | `StatusId` | `int32` | Status ID | ☐ | | | `StatusSequence` | `int32` | Status Sequence | ☐ | | | `TaskColor` | `string` | Task Color | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `TaskName` | `string` | Task Name | ☐ | | | `Tester` | `string` | Tester | ☐ | | | `TestStatus` | `string` | Test Status | ☐ | | | `TestStatusId` | `int32` | Test Status ID | ☐ | | | `TestUserId` | `int32` | Test User ID | ☐ | | | `Type` | `string` | Type | ☐ | | | `TypeId` | `int32` | Type ID | ☐ | | | `TypeSequence` | `int32` | Type Sequence | ☐ | | | `UnreadEmails` | `int32` | Unread Emails | ☑ | | | `UnreadNotes` | `int32` | Unread Notes | ☑ | |