# Tasks: ionBIZ Tasks - Catalog: `ionBIZ` - Label: Tasks - Retrieve: true ## Table Columns The columns of the table `Tasks` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Active` | `boolean` | Active | ☐ | | | `AllowActualSalesTimeGreaterThenCurrentSalesBudgetTime` | `boolean` | Allow Actual Sales Time Greater then Current Sales Budget Time | ☐ | | | `AllowActualsGreaterThenBaseline` | `boolean` | Allow Actuals Greater then Baseline | ☐ | | | `AllowAutomaticUpdateOfAssignedResourceHourlyRates` | `boolean` | Allow Automatic Update of Assigned Resource Hourly Rates | ☐ | | | `AllowMoreActualsThanAssigned` | `boolean` | Allow More Actuals than Assigned | ☐ | | | `AllowMoreAssignedSalesBudgetThanCurrentSalesBudget` | `boolean` | Allow More Assigned Sales Budget than Current Sales Budget | ☐ | | | `AllowMoreTotalAssignedThanBaseline` | `boolean` | Allow More Total Assigned than Baseline | ☐ | | | `AssignedRateBasedOn` | `int32` | Assigned Rate based on | ☐ | | | `BadgeOrderID` | `string` | Badge Order ID | ☐ | | | `Baseline` | `int64` | Baseline | ☐ | | | `BaselineCostsCosts` | `decimal` | Baseline Costs Costs | ☐ | | | `BaselineCostsTime` | `decimal` | Baseline Costs Time | ☐ | | | `BaselineSalesCost` | `decimal` | Baseline Sales Cost | ☐ | | | `BaselineSalesTime` | `decimal` | Baseline Sales Time | ☐ | | | `Billable` | `boolean` | Billable | ☐ | | | `BudgetAllocation` | `int32` | Budget Allocation | ☐ | | | `BudgetType` | `int32` | Budget Type | ☐ | | | `ClosingDate` | `datetimeoffset` | Closing Date | ☐ | | | `Color` | `string` | Colour | ☐ | | | `Comment` | `string` | Comment | ☐ | | | `CompletedById` | `int32` | Completed by ID | ☐ | | | `CompletedPercent` | `int32` | Completed (%) | ☐ | | | `CompletionDate` | `datetimeoffset` | Completion Date | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CurrentCostsCosts` | `decimal` | Current Costs Costs | ☐ | | | `CurrentCostsTime` | `decimal` | Current Costs Time | ☐ | | | `CurrentSalesCost` | `decimal` | Current Sales Cost | ☐ | | | `CurrentSalesTime` | `decimal` | Current Sales Time | ☐ | | | `CustomerRef` | `string` | Customer Reference | ☐ | | | `DailyRate` | `decimal` | Daily Rate | ☐ | | | `Declarable` | `boolean` | Declarable | ☐ | | | `DefaultReportingDuration` | `int64` | Default Reporting Duration | ☐ | | | `DefaultTravelDuration` | `int64` | Default Travel Duration | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `DeliveryDate` | `datetimeoffset` | Delivery Date | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `Description` | `string` | Description | ☐ | | | `DiscountPercentage` | `decimal` | Discount (%) | ☐ | | | `Duration` | `decimal` | Duration | ☐ | | | `DurationType` | `int32` | Duration Type | ☐ | | | `EndDate` | `datetimeoffset` | End Date | ☐ | | | `ExcludeFromFlexCalculation` | `boolean` | Exclude from Flex Calculation | ☐ | | | `ExposeToRelationPortal` | `boolean` | Expose to Relation Portal | ☐ | | | `ExternalNoteOnTimesheetIsRequired` | `boolean` | External Note on Timesheet is Required | ☐ | | | `FunctionId` | `int32` | Function ID | ☐ | | | `HourlyCost` | `decimal` | Hourly Cost | ☐ | | | `HourlyRate` | `decimal` | Hourly Rate | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IntercompanyCostPrice` | `decimal` | Intercompany Cost Price | ☐ | | | `InternalNoteOnTimesheetIsRequired` | `boolean` | Internal Note on Timesheet is Required | ☐ | | | `InternalRef` | `string` | Internal Reference | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IsLeaf` | `boolean` | Is Leaf | ☐ | | | `LedgerAccountId` | `int32` | Ledger Account ID | ☐ | | | `Location` | `string` | Location | ☐ | | | `Mileage` | `decimal` | Mileage | ☐ | | | `MileageFromHours` | `decimal` | Mileage from Hours | ☐ | | | `MileageType` | `int32` | Mileage Type | ☐ | | | `MileageUnitCost` | `decimal` | Mileage Unit Cost | ☐ | | | `MileageUnitPrice` | `decimal` | Mileage Unit Price | ☐ | | | `Milestone` | `boolean` | Milestone | ☐ | | | `MinimalPercentageOfUnusedBaselineVsTime` | `int32` | Minimal Percentage of Unused Baseline versus Time | ☐ | | | `MinimalPercentageOfUsedActualsVsBaseline` | `int32` | Minimal Percentage of Used Actuals versus Baseline | ☐ | | | `MinStatusId` | `int32` | Minimum Status ID | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `ModifiedDate` | `datetimeoffset` | Modified Date | ☐ | | | `Name` | `string` | Name | ☐ | | | `NextInvoiceDate` | `datetimeoffset` | Next Invoice Date | ☐ | | | `NotifyAccountManager` | `boolean` | Notify Account Manager | ☐ | | | `NotifyProjectManager` | `boolean` | Notify Project Manager | ☐ | | | `NotifyProjectSupervisor` | `boolean` | Notify Project Supervisor | ☐ | | | `ParentId` | `int32` | Parentid | ☐ | | | `Priority` | `int32` | Priority | ☐ | | | `ProjectActivityId` | `int32` | Project Activity ID | ☐ | | | `ProjectActivityTypeId` | `int32` | Project Activity Type ID | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `ProjectInvoiceId` | `int32` | Project Invoice ID | ☐ | | | `ProjectInvoiceLineId` | `int32` | Project Invoice Line ID | ☐ | | | `ProjectInvoiceProposalLineId` | `int32` | Project Invoice Proposal Line ID | ☐ | | | `RateType` | `int32` | Rate Type | ☐ | | | `Reporting` | `boolean` | Reporting | ☐ | | | `RequiredResourcesPerDay` | `int32` | Required Resources Per Day | ☐ | | | `SendTMTimesheetsInvoiceProposalsTaskStatusClosed` | `boolean` | Send through Timesheets Invoice Proposal Task Status Closed | ☐ | | | `Sequence` | `int32` | Sequence | ☐ | | | `SequenceId` | `string` | Sequence ID | ☐ | | | `SequenceIdOrder` | `string` | Sequence ID Order | ☐ | | | `ShortName` | `string` | Short Name | ☐ | | | `StartDate` | `datetimeoffset` | Start Date | ☐ | | | `StatusId` | `int32` | Status ID | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `TicketIsRequiredOnTimesheets` | `boolean` | Ticket is Required on Timesheets | ☐ | | | `TimesheetLinked` | `boolean` | Timesheet Linked | ☐ | | | `TimesheetRuleInvoicingId` | `int32` | Timesheet Rule Invoicing ID | ☐ | | | `TimesheetTimesRequired` | `boolean` | Timesheet Times Required | ☐ | | | `TransferToProjectId` | `int32` | Transfer to Project ID | ☐ | | | `Travel` | `boolean` | Travel | ☐ | | | `UsedBudgetPercent` | `int32` | Used Budget Percent | ☐ | |