# Timesheets: ionBIZ Timesheets - Catalog: `ionBIZ` - Label: Timesheets - Retrieve: true ## Table Columns The columns of the table `Timesheets` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AbroadAllowance` | `boolean` | Abroad Allowance | ☐ | | | `AllowancePerHour` | `decimal` | Allowance per Hour | ☐ | | | `ApproverId` | `int32` | Approver ID | ☐ | | | `Billable` | `int64` | Billable | ☐ | | | `CostPrice` | `decimal` | Cost Price | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `DailyRate` | `decimal` | Daily Rate | ☐ | | | `Date` | `datetimeoffset` | Date | ☐ | | | `Declarable` | `int64` | Declarable | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `DigitalSigningLineId` | `int32` | Digital Signing Line ID | ☐ | | | `DisapprovalReasonMotivation` | `string` | Disapproval Reason Motivation | ☐ | | | `DisapprovalTimestamp` | `datetimeoffset` | Disapproval Timestamp | ☐ | | | `DisapproverResourceId` | `int32` | Disapprover Resource ID | ☐ | | | `ExternalNotes` | `string` | External Notes | ☐ | | | `Flex` | `boolean` | Flex | ☐ | | | `HotelAllowance` | `boolean` | Hotel Allowance | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IncludeBreaks` | `boolean` | Include Breaks | ☐ | | | `Intercompany` | `boolean` | Intercompany | ☐ | | | `IntercompanyCostPrice` | `decimal` | Intercompany Cost Price | ☐ | | | `IntercompanyNextInvoiceDate` | `datetimeoffset` | Intercompany Next Invoice Date | ☐ | | | `IntercompanyProjectInvoiceId` | `int32` | Intercompany Project Invoice ID | ☐ | | | `IntercompanyProjectInvoiceLineId` | `int32` | Intercompany Project Invoice Line ID | ☐ | | | `IntercompanyProjectInvoiceProposalLineId` | `int32` | Intercompany Project Invoice Proposal Line ID | ☐ | | | `IntercompanyStatus` | `int32` | Intercompany Status | ☐ | | | `InternalNotes` | `string` | Internal Notes | ☐ | | | `InterruptedShift` | `boolean` | Interrupted Shift | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IssueId` | `int32` | Issue ID | ☐ | | | `LastExportDateTime` | `datetimeoffset` | Last Export Date/Time | ☐ | | | `LastExportDateTimeIC` | `datetimeoffset` | Last Export Date Time Intercompany | ☐ | | | `LastModified` | `datetimeoffset` | Last Modified | ☐ | | | `LeadId` | `int32` | Lead ID | ☐ | | | `LeadRelationId` | `int32` | Lead Relation ID | ☐ | | | `Location` | `string` | Location | ☐ | | | `MatchingCostId` | `int32` | Matching Cost ID | ☐ | | | `Mileage` | `decimal` | Mileage | ☐ | | | `MileageCostPrice` | `decimal` | Mileage Cost Price | ☐ | | | `MileageInvoiced` | `boolean` | Mileage Invoiced | ☐ | | | `MileageNextInvoiceDate` | `datetimeoffset` | Mileage Next Invoice Date | ☐ | | | `MileageProjectInvoiceId` | `int32` | Mileage Project Invoice ID | ☐ | | | `MileageProjectInvoiceLineId` | `int32` | Mileage Project Invoice Line ID | ☐ | | | `MileageProjectInvoiceProposalLineId` | `int32` | Mileage Project Invoice Proposal Line ID | ☐ | | | `MileageTransferToProjectId` | `int32` | Mileage Transfer to Project ID | ☐ | | | `MileageUnitPrice` | `decimal` | Mileage Unit Price | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `NextInvoiceDate` | `datetimeoffset` | Next Invoice Date | ☐ | | | `NightShift` | `boolean` | Nightshift | ☐ | | | `Nightshift2` | `boolean` | Nightshift 2 | ☐ | | | `NotBillable` | `int64` | Not Billable | ☐ | | | `NotDeclarable` | `int64` | Not Declarable | ☐ | | | `Overtime` | `boolean` | Overtime | ☐ | | | `OvertimeDetail` | `decimal` | Overtime Detail | ☐ | | | `PayOut` | `boolean` | Payout | ☐ | | | `PlanningId` | `int32` | Planning ID | ☐ | | | `PredefinedExternalNoteId` | `int32` | Predefined External Note ID | ☐ | | | `PredefinedInternalNoteId` | `int32` | Predefined Internal Note ID | ☐ | | | `ProjectActivityId` | `int32` | Project Activity ID | ☐ | | | `ProjectActivityTypeId` | `int32` | Project Activity Type ID | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `ProjectInvoiceApprovalHeaderId` | `int32` | Project Invoice Approval Header ID | ☐ | | | `ProjectInvoiceId` | `int32` | Project Invoice ID | ☐ | | | `ProjectInvoiceLineId` | `int32` | Project Invoice Line ID | ☐ | | | `ProjectInvoiceProposalLineId` | `int32` | Project Invoice Proposal Line ID | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `ResourceId` | `int32` | Resource ID | ☐ | | | `RuleOvertimeId` | `int32` | Rule Overtime ID | ☐ | | | `RuleShiftId` | `int32` | Rule Shift ID | ☐ | | | `SalesPrice` | `decimal` | Salesprice | ☐ | | | `SalesQuoteId` | `int32` | Sales Quote ID | ☐ | | | `StartHour` | `datetimeoffset` | Start Hour | ☐ | | | `Status` | `int32` | Status | ☐ | | | `StopHour` | `datetimeoffset` | Stop Hour | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `TimesheetTimerId` | `int32` | Timesheet Timer ID | ☐ | | | `TransferToProjectId` | `int32` | Transfer to Project ID | ☐ | | | `WorkLocationId` | `int32` | Work Location ID | ☐ | |