# Invinvoicingapprovaldetailsresult - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Invinvoicingapprovaldetailsresult` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Budget` | `decimal` | Budget | ☐ | | | `Close` | `boolean` | Close | ☐ | | | `ClosedActualHours` | `decimal` | Closed Actual Hours | ☐ | | | `ClosedActuals` | `decimal` | Closed Actuals | ☐ | | | `ClosedBalance` | `decimal` | Closed Balance | ☐ | | | `ClosedCosts` | `decimal` | Closed Costs | ☐ | | | `ClosedInvoiced` | `decimal` | Closed Invoiced | ☐ | | | `ClosedRevenue` | `decimal` | Closed Revenue | ☐ | | | `CurrentActualHours` | `decimal` | Current Actual Hours | ☐ | | | `CurrentActuals` | `decimal` | Current Actuals | ☐ | | | `CurrentBalance` | `decimal` | Current Balance | ☐ | | | `CurrentCosts` | `decimal` | Current Costs | ☐ | | | `CurrentInvoiceAmount` | `decimal` | Current Invoice Amount | ☐ | | | `CurrentRevenue` | `decimal` | Current Revenue | ☐ | | | `Department` | `string` | Department | ☐ | | | `Id` | `int32` | ID | ☑ | | | `Invoiced` | `decimal` | Invoiced | ☐ | | | `InvoiceText` | `string` | Invoice Text | ☐ | | | `Item` | `string` | Item | ☐ | | | `ProjectCostId` | `int32` | Project Cost ID | ☐ | | | `ProjectId` | `int32` | Project ID | ☑ | | | `ProjectInvoiceApprovalHeaderId` | `int32` | Project Invoice Approval Header ID | ☑ | | | `TaskId` | `int32` | Task ID | ☐ | | | `TaskStatus` | `string` | Task Status | ☐ | | | `Type` | `int32` | Type | ☐ | |