# ProjectInvoiceApprovalLines: ionBIZ Project Invoice Approval Lines
- Catalog: `ionBIZ`
- Label: Project Invoice Approval Lines
- Retrieve: true
## Table Columns
The columns of the table `ProjectInvoiceApprovalLines` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `Close` | `boolean` | Close | ☐ | |
| `DeletedById` | `int32` | Deleted by ID | ☐ | |
| `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | |
| `Id` | `int32` | ID | ☑ | |
| `InvoiceAmount` | `decimal` | Invoice Amount | ☐ | |
| `InvoiceText` | `string` | Invoice Text | ☐ | |
| `IsDeleted` | `boolean` | Is Deleted | ☐ | |
| `ProjectCostId` | `int32` | Project Cost ID | ☐ | |
| `ProjectInvoiceApprovalHeaderId` | `int32` | Project Invoice Approval Header ID | ☐ | |
| `Revenue` | `decimal` | Revenue | ☐ | |
| `TaskId` | `int32` | Task ID | ☐ | |