# Projectshistories - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Projectshistories` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AddressId` | `int32` | Address ID | ☐ | | | `Baseline` | `int64` | Baseline | ☐ | | | `BaselineCostsCosts` | `decimal` | Baseline Costs Costs | ☐ | | | `BaselineCostsTime` | `decimal` | Baseline Costs Time | ☐ | | | `BaselineLocked` | `boolean` | Baseline Locked | ☐ | | | `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 | ☐ | | | `CompanyAddressId` | `int32` | Company Address ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `CurrentCostsCosts` | `decimal` | Current Costs Costs | ☐ | | | `CurrentCostsTime` | `decimal` | Current Costs Time | ☐ | | | `CurrentLocked` | `boolean` | Current Locked | ☐ | | | `CurrentSalesCost` | `decimal` | Current Sales Cost | ☐ | | | `CurrentSalesTime` | `decimal` | Current Sales Time | ☐ | | | `CustomerRef` | `string` | Customer Reference | ☐ | | | `Declarable` | `boolean` | Declarable | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `DepartmentId` | `int32` | Department ID | ☐ | | | `Description` | `string` | Description | ☐ | | | `EndDate` | `datetimeoffset` | End Date | ☐ | | | `EngagementClause` | `boolean` | Engagement Clause | ☐ | | | `ExcludeFromFlexCalculation` | `boolean` | Exclude from Flex Calculation | ☐ | | | `ExposeToRelationPortal` | `boolean` | Expose to Relation Portal | ☐ | | | `ExternalNoteOnTimesheetIsRequired` | `boolean` | External Note on Timesheet is Required | ☐ | | | `GroupId` | `int32` | Group ID | ☐ | | | `HonoraryFeeFormulaId` | `int32` | Honorary Fee Formula IOD | ☐ | | | `HonoraryFeePercentage` | `decimal` | Honorary Fee Percentage | ☐ | | | `Hyperlink` | `string` | Hyperlink | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InternalNoteOnTimesheetIsRequired` | `boolean` | Internal Note on Timesheet is Required | ☐ | | | `InvoiceDetailTemplateId` | `int32` | Invoice Detail Template ID | ☐ | | | `InvoiceItemsUponDelivery` | `boolean` | Invoice Items up on Delivery | ☐ | | | `InvoiceTemplateId` | `int32` | Invoice Template ID | ☐ | | | `InvoiceText` | `string` | Invoice Text | ☐ | | | `InvoiceToAddressId` | `int32` | Invoice to Address ID | ☐ | | | `InvoiceToCustomerId` | `int32` | Invoice to Customer ID | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `LastStatusUpdate` | `datetimeoffset` | Last Status Update | ☐ | | | `LinkTimesheetsWithLeads` | `boolean` | Link Timesheets with Leads | ☐ | | | `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 | ☐ | | | `MinStatusId` | `int32` | Minimum Status ID | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `MSPFee` | `decimal` | MSP Fee | ☐ | | | `Name` | `string` | Name | ☐ | | | `NextInvoiceDate` | `datetimeoffset` | Next Invoice Date | ☐ | | | `OverheadFactorCosts` | `decimal` | Overhead Factor Costs | ☐ | | | `OverheadFactorTime` | `decimal` | Overhead Factor Time | ☐ | | | `ProjComment` | `string` | Project Comment | ☐ | | | `ProjectId` | `string` | Project ID | ☐ | | | `ProjectInvoiceGroupId` | `int32` | Project Invoice Group ID | ☐ | | | `ProjectInvoiceLineId` | `int32` | Project Invoice Line ID | ☐ | | | `ProjectInvoiceProposalLineId` | `int32` | Project Invoice Proposal Line ID | ☐ | | | `ProjectManagerId` | `int32` | Project Manager ID | ☐ | | | `ProjectManagerReminder` | `boolean` | Project Manager Reminder | ☐ | | | `ProjectSupervisorId` | `int32` | Project Supervisor ID | ☐ | | | `ProjectSupervisorReminder` | `boolean` | Project Supervisor Reminder | ☐ | | | `ProjectTypeId` | `int32` | Project Type ID | ☐ | | | `RegimePct` | `decimal` | Regime Percentage | ☐ | | | `RelationContactId` | `int32` | Relation Contact ID | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `SalesManagerId` | `int32` | Sales Manager ID | ☐ | | | `SalesManagerReminder` | `boolean` | Sales Manager Reminder | ☐ | | | `SendToAddressId` | `int32` | Send to Address ID | ☐ | | | `SLATemplateId` | `int32` | SLA Template ID | ☐ | | | `StartDate` | `datetimeoffset` | Start Date | ☐ | | | `StatusId` | `int32` | Status ID | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `TemplateId` | `int32` | Template ID | ☐ | | | `TimesheetRuleInvoicingId` | `int32` | Timesheet Rule Invoicing ID | ☐ | | | `TransferToProjectId` | `int32` | Transfer to Project ID | ☐ | | | `WorkHoursPerDay` | `decimal` | Workhours per Day | ☐ | |