# CostTypes: ionBIZ Cost Types - Catalog: `ionBIZ` - Label: Cost Types - Retrieve: true ## Table Columns The columns of the table `CostTypes` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Active` | `boolean` | Active | ☐ | | | `AllowTimesheetMatching` | `boolean` | Allow Timesheet Matching | ☐ | | | `ApprovalByDepartment` | `boolean` | Approval by Department | ☐ | | | `ApprovalByProjectManager` | `boolean` | Approval by Project Manager | ☐ | | | `ApprovalByProjectSupervisor` | `boolean` | Approval by Project Supervisor | ☐ | | | `Code` | `string` | Code | ☐ | | | `CostCategoryId` | `int32` | Cost Category ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `DefaultCostPrice` | `decimal` | Default Cost Price | ☐ | | | `DefaultName` | `string` | Default Name | ☐ | | | `ExcludeFromGroupingOnProposals` | `boolean` | Exclude from Grouping on Proposals | ☐ | | | `ExternalApprovalByDepartment` | `boolean` | External Approval by Department | ☐ | | | `ExternalApprovalByProjectManager` | `boolean` | External Approval by Project Manager | ☐ | | | `ExternalApprovalByProjectSupervisor` | `boolean` | External Approval by Project Supervisor | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IsDefault` | `boolean` | Is Default | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `LedgerAccountCostId` | `int32` | Ledger Account Cost ID | ☐ | | | `LedgerAccountId` | `int32` | Ledger Account ID | ☐ | | | `Margin` | `decimal` | Margin | ☐ | | | `MarginType` | `int32` | Margin Type | ☐ | | | `OneTimeUseItem` | `boolean` | One Time Use Item | ☐ | | | `ProjectActivityId` | `int32` | Project Activity ID | ☐ | | | `Sequence` | `int32` | Sequence | ☐ | | | `UpdateItemUnitCostBasedOnLastUnitCost` | `boolean` | Update Item Unit Cost Based on Last Unit Cost | ☐ | | | `UseOnMileageCostType` | `boolean` | Use on Mileage Cost Type | ☐ | |