# ProjectInvoiceApprovalPeriods: ionBIZ Project Invoice Approval Periods
- Catalog: `ionBIZ`
- Label: Project Invoice Approval Periods
- Retrieve: true
## Table Columns
The columns of the table `ProjectInvoiceApprovalPeriods` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `Active` | `boolean` | Active | ☐ | |
| `AdminClosingDate` | `datetimeoffset` | Administrative Closing Date | ☐ | |
| `AreaId` | `int32` | Area ID | ☐ | |
| `CloseDate` | `datetimeoffset` | Close Date | ☐ | |
| `CreationDate` | `datetimeoffset` | Creation Date | ☐ | |
| `CreatorId` | `int32` | Creator ID | ☐ | |
| `DepartmentId` | `int32` | Department ID | ☐ | |
| `EndDate` | `datetimeoffset` | End Date | ☐ | |
| `Id` | `int32` | ID | ☑ | |
| `IsDeleted` | `boolean` | Is Deleted | ☐ | |
| `ManualClosingDate` | `datetimeoffset` | Manual Closing Date | ☐ | |
| `ManuallyClosed` | `boolean` | Manually Closed | ☐ | |
| `ModifierId` | `int32` | Modifier ID | ☐ | |
| `ModifyDate` | `datetimeoffset` | Modify Date | ☐ | |
| `StartDate` | `datetimeoffset` | Start Date | ☐ | |
| `Year` | `int32` | Year | ☐ | |