# Issues: ionBIZ Issues - Catalog: `ionBIZ` - Label: Issues - Retrieve: true ## Table Columns The columns of the table `Issues` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ActionDate` | `datetimeoffset` | Action Date | ☐ | | | `ActionRequiredById` | `int32` | Action Required by ID | ☐ | | | `AddToPlanning` | `boolean` | Add to Planning | ☐ | | | `AreaId` | `int32` | Area ID | ☐ | | | `AssignedByUserId` | `int32` | Assigned by User ID | ☐ | | | `AssignedOn` | `datetimeoffset` | Assigned on | ☐ | | | `AssignedUserId` | `int32` | Assigned User ID | ☐ | | | `Billable` | `boolean` | Billable | ☐ | | | `BudgetType` | `int32` | Budget Type | ☐ | | | `CategoryId` | `int32` | Category ID | ☐ | | | `Color` | `string` | Colour | ☐ | | | `CompletedByContactId` | `int32` | Completed by Contact ID | ☐ | | | `CompletedByUserId` | `int32` | Completed by User ID | ☐ | | | `CompletedPercent` | `int32` | Completed (%) | ☐ | | | `CompletionDate` | `datetimeoffset` | Completion Date | ☐ | | | `ContactId` | `int32` | Contact ID | ☐ | | | `ContractId` | `int32` | Contract ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorContactId` | `int32` | Creator Contact ID | ☐ | | | `CreatorUserId` | `int32` | Creator User ID | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `DeletedByContactId` | `int32` | Deleted by Contact ID | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `Description` | `string` | Description | ☐ | | | `DueDate` | `datetimeoffset` | Due Date | ☐ | | | `EstimatedHours` | `decimal` | Estimated Hours | ☐ | | | `ExpectedDeliveryDate` | `datetimeoffset` | Expected Delivery Date | ☐ | | | `ExposeToRelationPortal` | `boolean` | Expose to Relation Portal | ☐ | | | `ExternalID` | `string` | External ID | ☐ | | | `FirstRespondedByUserId` | `int32` | First Responded by User ID | ☐ | | | `FirstRespondedOn` | `datetimeoffset` | First Responded on | ☐ | | | `GroupId` | `int32` | Group ID | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InvoiceMode` | `int32` | Invoice Mode | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IssueArea_Id` | `int32` | Issue Area ID | ☐ | | | `IssueId` | `string` | Issue ID | ☐ | | | `IterationId` | `int32` | Iteration ID | ☐ | | | `ModifiedByContactId` | `int32` | Modified by Contact ID | ☐ | | | `ModifiedByUserId` | `int32` | Modified by User ID | ☐ | | | `ModifiedDate` | `datetimeoffset` | Modified Date | ☐ | | | `Name` | `string` | Name | ☐ | | | `NextInvoiceDate` | `datetimeoffset` | Next Invoice Date | ☐ | | | `OwnerId` | `int32` | Owner ID | ☐ | | | `Points` | `int32` | Points | ☐ | | | `PriorityId` | `int32` | Priority ID | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `ProjectInvoiceId` | `int32` | Project Invoice ID | ☐ | | | `ProjectInvoiceLineId` | `int32` | Project Invoice Line ID | ☐ | | | `ProjectInvoiceProposalLineId` | `int32` | Project Invoice Proposal Line ID | ☐ | | | `QuoteId` | `int32` | Quote ID | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `RelationLeadId` | `int32` | Relation Lead ID | ☐ | | | `Resolution` | `string` | Resolution | ☐ | | | `ReviewedHours` | `decimal` | Reviewed Hours | ☐ | | | `RMAAssignedToId` | `int32` | RMA Assigned to ID | ☐ | | | `RMAComment` | `string` | RMA Comment | ☐ | | | `RMACustomerEstimateApprovedById` | `int32` | RMA Customer Estimate Approved by ID | ☐ | | | `RMACustomerEstimateDecisionDate` | `datetimeoffset` | RMA Customer Estimate Decision Date | ☐ | | | `RMACustomerEstimatePrice` | `decimal` | RMA Customer Estimate Price | ☐ | | | `RMACustomerEstimateReference` | `string` | RMA Customer Estimate Reference | ☐ | | | `RMADeliveryDate` | `datetimeoffset` | RMA Delivery Date | ☐ | | | `RMADeliveryToId` | `int32` | RMA Delivery to ID | ☐ | | | `RMAItemId` | `int32` | RMA Item ID | ☐ | | | `RMAOrderInfo` | `string` | RMA Order | ☐ | | | `RMAPredecessorId` | `int32` | RMA Predecessor ID | ☐ | | | `RMAReceivingDate` | `datetimeoffset` | RMA Receiving Date | ☐ | | | `RMAReplacementItemId` | `int32` | RMA Replacement Item ID | ☐ | | | `RMAReplacementReturnDate` | `datetimeoffset` | RMA Replacement Return Date | ☐ | | | `RMAReplacementSerialNumber` | `string` | RMA Replacement Serial Number | ☐ | | | `RMAReplacementShipmentDate` | `datetimeoffset` | RMA Replacement Shipment Date | ☐ | | | `RMAReplacementStatus` | `string` | RMA Replacement Status | ☐ | | | `RMARespectiveUnitCost` | `decimal` | RMA Respective Unit Cost | ☐ | | | `RMASendToId` | `int32` | RMA Send to ID | ☐ | | | `RMASerialNumber` | `string` | RMA Serial Number | ☐ | | | `RMASupplierContactId` | `int32` | RMA Supplier Contact ID | ☐ | | | `RMASupplierEstimateApprovedById` | `int32` | RMA Supplier Estimate Approved by ID | ☐ | | | `RMASupplierEstimateDecisionDate` | `datetimeoffset` | RMA Supplier Estimate Decision Date | ☐ | | | `RMASupplierEstimatePrice` | `decimal` | RMA Supplier Estimate Price | ☐ | | | `RMASupplierEstimateReference` | `string` | RMA Supplier Estimate Reference | ☐ | | | `RMASupplierGuarantee` | `boolean` | RMA Supplier Guarantee | ☐ | | | `RMASupplierId` | `int32` | RMA Supplier ID | ☐ | | | `RMASupplierRef` | `string` | RMA Supplier Reference | ☐ | | | `RMASupplierReturnDate` | `datetimeoffset` | RMA Supplier Return Date | ☐ | | | `RMASupplierShipmentDate` | `datetimeoffset` | RMA Supplier Shipment Date | ☐ | | | `RMASupplierShipmentInfo` | `string` | RMA Supplier Shipment Information | ☐ | | | `SalesPrice` | `decimal` | Salesprice | ☐ | | | `SeverityId` | `int32` | Severity ID | ☐ | | | `SoftwareId` | `int32` | Software ID | ☐ | | | `Solution` | `string` | Solution | ☐ | | | `StatusId` | `int32` | Status ID | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `TestResult` | `string` | Test Result | ☐ | | | `TestStatusId` | `int32` | Test Status ID | ☐ | | | `TestUserId` | `int32` | Test User ID | ☐ | | | `TransferToProjectId` | `int32` | Transfer to Project ID | ☐ | | | `TypeId` | `int32` | Type ID | ☐ | |