# Projectcostshistories - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Projectcostshistories` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AddToActuals` | `boolean` | Add to Actuals | ☐ | | | `AddToBaselineBudget` | `boolean` | Add to Baseline Budget | ☐ | | | `AddToCurrentBudget` | `boolean` | Add to Current Budget | ☐ | | | `Billable` | `boolean` | Billable | ☐ | | | `BookedAmount` | `decimal` | Booked Amount | ☐ | | | `Comment` | `string` | Comment | ☐ | | | `ConfirmedById` | `int32` | Confirmed by ID | ☐ | | | `CostDate` | `datetimeoffset` | Cost Date | ☐ | | | `CostPrice` | `decimal` | Cost Price | ☐ | | | `CostSheetId` | `int32` | Cost Sheet ID | ☐ | | | `CostTypeId` | `int32` | Cost Type ID | ☐ | | | `CreatedByExternal` | `boolean` | Created by External | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `CustomerId` | `int32` | Customer ID | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `DeliveredToCustomer` | `decimal` | Delivered to Customer | ☐ | | | `Dep_ApproverId` | `int32` | Department Approver ID | ☐ | | | `Description` | `string` | Description | ☐ | | | `DisapprovalReasonId` | `int32` | Disapproval Reason ID | ☐ | | | `DisapprovalReasonMotivation` | `string` | Disapproval Reason Motivation | ☐ | | | `ExternalAccountingCompany` | `string` | External Accounting Company | ☐ | | | `ExternalDocDate` | `datetimeoffset` | External Document Date | ☐ | | | `ExternalDocDueDate` | `datetimeoffset` | External Document Due Date | ☐ | | | `ExternalDocId` | `string` | External Document ID | ☐ | | | `ExternalDocLineId` | `int32` | External Document Line ID | ☐ | | | `Hyperlink` | `string` | Hyperlink | ☐ | | | `Id` | `int32` | ID | ☑ | | | `InvoiceId` | `string` | Invoice ID | ☐ | | | `InvoiceUponDelivery` | `boolean` | Invoice upon Delivery | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `ItemCompositionId` | `int32` | Item Composition ID | ☐ | | | `ItemId` | `int32` | Item ID | ☐ | | | `LastExportDateTime` | `datetimeoffset` | Last Export Date/Time | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `ModifiedDate` | `datetimeoffset` | Modified Date | ☐ | | | `NextInvoiceDate` | `datetimeoffset` | Next Invoice Date | ☐ | | | `OnHold` | `boolean` | On Hold | ☐ | | | `PartialDeliveryAllowed` | `boolean` | Partial Delivery Allowed | ☐ | | | `PM_ApproverId` | `int32` | Approver ID | ☐ | | | `Postpone` | `boolean` | Postpone | ☐ | | | `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 | ☐ | | | `ProjectItemToProduceId` | `int32` | Project Item to Produce ID | ☐ | | | `PS_ApproverId` | `int32` | Approver ID | ☐ | | | `Purchase` | `boolean` | Purchase | ☐ | | | `PurchaseComment` | `string` | Purchase Comment | ☐ | | | `PurchaseInvoiceId` | `int32` | Purchase Invoice ID | ☐ | | | `Quantity` | `decimal` | Quantity | ☐ | | | `Reimbursable` | `boolean` | Reimbursable | ☐ | | | `ReimbursalApproverId` | `int32` | Reimbursal Approver ID | ☐ | | | `ReimbursedAmount` | `decimal` | Reimbursed Amount | ☐ | | | `ReimbursedOn` | `datetimeoffset` | Reimbursed on | ☐ | | | `ReimburseStatusId` | `int32` | Reimburse Status ID | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `ResourceId` | `int32` | Resource ID | ☐ | | | `SalesPrice` | `decimal` | Salesprice | ☐ | | | `SalesQuoteLine_Id` | `int32` | Sales Quote Line ID | ☐ | | | `Sequence` | `int32` | Sequence | ☐ | | | `Status` | `int32` | Status | ☐ | | | `SupplyClosed` | `boolean` | Supply Closed | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `TransferToProjectId` | `int32` | Transfer to Project ID | ☐ | | | `UnitTypeId` | `int32` | Unit Type ID | ☐ | | | `VATPercentageId` | `int32` | VAT Percentage ID | ☐ | |