# Timesheetcellsrow - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Timesheetcellsrow` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Actuals` | `int64` | Actuals | ☐ | | | `AssignedTime` | `int64` | Assigned Time | ☑ | | | `CompletedPercent` | `decimal` | Completed (%) | ☑ | | | `CreatorId` | `int32` | Creator ID | ☑ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `CurrencySymbol` | `string` | Currency Symbol | ☐ | | | `Customer` | `string` | Customer | ☐ | | | `CustomerBlocked` | `int32` | Customer Blocked | ☐ | | | `CustomerId` | `int32` | Customer ID | ☐ | | | `ExternalNoteIsRequired` | `boolean` | External Note Is Required | ☑ | | | `Id` | `int32` | ID | ☑ | | | `InternalNoteIsRequired` | `boolean` | Internal Note Is Required | ☑ | | | `IssueId` | `int32` | Issue ID | ☐ | | | `IssueName` | `string` | Issue Name | ☐ | | | `Name` | `string` | Name | ☐ | | | `NameP` | `string` | Parent Name | ☐ | | | `NamePP` | `string` | Grandparent Name | ☐ | | | `NamePPP` | `string` | Great-Grandparent Name | ☐ | | | `ParentId` | `int32` | Parentid | ☐ | | | `ParentParentId` | `int32` | Grandparent ID | ☐ | | | `ParentParentParentId` | `int32` | Great-Grandparent ID | ☐ | | | `Planned` | `int64` | Planned | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `RequiredPercentageTimesheetConfirmation` | `int32` | Required Percentage Timesheet Confirmation | ☐ | | | `ResourceDepartmentId` | `int32` | Resource Department ID | ☑ | | | `ResourceEndDate` | `datetimeoffset` | Resource End Date | ☐ | | | `ResourceId` | `int32` | Resource ID | ☑ | | | `ResourceName` | `string` | Resource Name | ☐ | | | `ResourceStartDate` | `datetimeoffset` | Resource Start Date | ☐ | | | `SalesQuoteId` | `int32` | Sales Quote ID | ☐ | | | `SalesQuoteName` | `string` | Sales Quote Name | ☐ | | | `SequenceIdOrder` | `string` | Sequence ID Order | ☐ | | | `Status` | `int32` | Status | ☑ | | | `TaskBaseline` | `int64` | Task Baseline | ☐ | | | `TaskBillable` | `boolean` | Task Billable | ☑ | | | `TaskDeclarable` | `boolean` | Task Declarable | ☐ | | | `TaskEndDate` | `datetimeoffset` | Task End Date | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `TaskIsClosed` | `boolean` | Task Is Closed | ☑ | | | `TaskProjectId` | `string` | Task Project ID | ☐ | | | `TaskProjectName` | `string` | Task Project Name | ☐ | | | `TaskResourceId` | `int32` | Task Resource ID | ☑ | | | `TaskStartDate` | `datetimeoffset` | Task Start Date | ☐ | | | `TaskStatusAllowTimesheet` | `boolean` | Task Status Allow Timesheet | ☑ | | | `TicketIsRequired` | `boolean` | Ticket Is Required | ☑ | | | `TimeToCompletion` | `int64` | Time to Completion | ☑ | | | `TotalActuals` | `int64` | Total Actuals | ☐ | | | `Type` | `int32` | Type | ☑ | |