# Rpttimesheetactualhoursresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Rpttimesheetactualhoursresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AbroadAllowance` | `decimal` | Abroad Allowance | ☐ | | | `AccMgrExtCode` | `string` | Account Manager External Code | ☐ | | | `AccountMgr` | `string` | Account Manager | ☐ | | | `ActualHours` | `int64` | Actual Hours | ☐ | | | `ApproverName` | `string` | Approver Name | ☐ | | | `AssignedDays` | `decimal` | Assigned Days | ☐ | | | `AssignedHours` | `decimal` | Assigned Hours | ☐ | | | `BaselineHours` | `int64` | Baseline Hours | ☐ | | | `BillableHours` | `int64` | Billable Hours | ☑ | | | `BillableTask` | `boolean` | Billable Task | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `Creator` | `string` | Creator | ☐ | | | `CurrencySymbol` | `string` | Currency Symbol | ☐ | | | `CustomerRef` | `string` | Customer Reference | ☐ | | | `CustomFields` | `string` | Custom Fields | ☐ | | | `Date` | `datetimeoffset` | Date | ☑ | | | `DeclarableHours` | `int64` | Declarable Hours | ☑ | | | `DisapprovalReasonMotivation` | `string` | Disapproval Reason Motivation | ☐ | | | `EndDate` | `datetimeoffset` | End Date | ☐ | | | `ExternalCode` | `string` | External Code | ☐ | | | `ExternalNotes` | `string` | External Notes | ☐ | | | `FunctionName` | `string` | Function Name | ☐ | | | `HotelAllowance` | `decimal` | Hotel Allowance | ☐ | | | `HourlyCostInclOH` | `decimal` | Hourly Cost in CLOH | ☐ | | | `Id` | `int32` | ID | ☑ | | | `Intercompany` | `boolean` | Intercompany | ☐ | | | `IntercompanyCostPrice` | `decimal` | Intercompany Cost Price | ☐ | | | `IntercompanyProjectInvoice` | `string` | Intercompany Project Invoice | ☐ | | | `IntercompanyProjectInvoiceId` | `int32` | Intercompany Project Invoice ID | ☐ | | | `IntercompanyStatus` | `int32` | Intercompany Status | ☐ | | | `InternalNotes` | `string` | Internal Notes | ☐ | | | `InvoiceNumber` | `string` | Invoice Number | ☐ | | | `IssueId` | `int32` | Issue ID | ☐ | | | `IssueIssueId` | `string` | Issue Issue ID | ☐ | | | `IssueName` | `string` | Issue Name | ☐ | | | `LastModified` | `datetimeoffset` | Last Modified | ☑ | | | `Lead` | `string` | Lead | ☐ | | | `LeadRelation` | `string` | Lead Relation | ☐ | | | `LeaveDuration` | `int64` | Leave Duration | ☐ | | | `LeaveType` | `string` | Leave Type | ☐ | | | `Location` | `string` | Location | ☐ | | | `MarginInclOH` | `decimal` | Margin in CLOH | ☐ | | | `Memo` | `string` | Memo | ☐ | | | `Mileage` | `decimal` | Mileage | ☐ | | | `MileageUnitPrice` | `decimal` | Mileage Unit Price | ☐ | | | `NightShift` | `boolean` | Nightshift | ☐ | | | `NotBillableHours` | `int64` | Not Billable Hours | ☑ | | | `NotDeclarableHours` | `int64` | Not Declarable Hours | ☑ | | | `Overtime` | `decimal` | Overtime | ☐ | | | `ParentResourceType` | `string` | Parent Resource Type | ☐ | | | `ParentTask` | `string` | Parent Task | ☐ | | | `PayOut` | `boolean` | Payout | ☑ | | | `PlanningAmount` | `int64` | Planning Amount | ☐ | | | `ProjectActivity` | `string` | Project Activity | ☐ | | | `ProjectActivityId` | `int32` | Project Activity ID | ☐ | | | `ProjectActivityType` | `string` | Project Activity Type | ☐ | | | `ProjectActivityTypeId` | `int32` | Project Activity Type ID | ☐ | | | `ProjectCurrency` | `string` | Project Currency | ☐ | | | `ProjectCustomerRef` | `string` | Project Customer Reference | ☐ | | | `ProjectDepartment` | `string` | Project Department | ☐ | | | `ProjectGroup` | `string` | Project Group | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `ProjectManager` | `string` | Project Manager | ☐ | | | `ProjectName` | `string` | Project Name | ☐ | | | `ProjectProjectId` | `string` | Project Project ID | ☐ | | | `ProjectType` | `string` | Project Type | ☐ | | | `Relation` | `string` | Relation | ☐ | | | `RelationCountry` | `string` | Relation Country | ☐ | | | `RelationGroup` | `string` | Relation Group | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `RelationZip` | `string` | Relation ZIP | ☐ | | | `ResExtCode` | `string` | Resource External Code | ☐ | | | `ResourceCountry` | `string` | Resource Country | ☐ | | | `ResourceDepartment` | `string` | Resource Department | ☐ | | | `ResourceId` | `int32` | Resource ID | ☑ | | | `ResourceName` | `string` | Resource Name | ☐ | | | `ResourceType` | `string` | Resource Type | ☐ | | | `ResourceZip` | `string` | Resource ZIP | ☐ | | | `SalesManager` | `string` | Sales Manager | ☐ | | | `SalesQuoteId` | `int32` | Sales Quote ID | ☐ | | | `SalesQuoteName` | `string` | Sales Quote Name | ☐ | | | `SalesQuoteQuoteId` | `string` | Sales Quote Quote ID | ☐ | | | `StartHour` | `datetimeoffset` | Start Hour | ☐ | | | `Status` | `int32` | Status | ☐ | | | `StopHour` | `datetimeoffset` | Stop Hour | ☐ | | | `Supervisor` | `string` | Supervisor | ☐ | | | `Task` | `string` | Task | ☐ | | | `TaskBudgetType` | `int32` | Task Budget Type | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `TimesheetCurrency` | `string` | Timesheet Currency | ☐ | | | `TotalCost` | `decimal` | Total Cost | ☐ | | | `TotalCostInclOH` | `decimal` | Total Cost in CLOH | ☐ | | | `TotalPrice` | `decimal` | Total Price | ☑ | | | `UnitCost` | `decimal` | Unit Cost | ☐ | | | `UnitPrice` | `decimal` | Unit Price | ☐ | | | `WorkLocationId` | `int32` | Work Location ID | ☐ | | | `WorkLocationIdName` | `string` | Work Location ID Name | ☐ | |