# Vwprojectinvoiceschedulelines - Catalog: `ionBIZ` - Retrieve: true ## Table Columns The columns of the table `Vwprojectinvoiceschedulelines` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ApprovalProcessId` | `int32` | Approval Process ID | ☐ | | | `CalculateAmountOnInvoicing` | `boolean` | Calculate Amount on Invoicing | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `Date` | `datetimeoffset` | Date | ☐ | | | `EndDate` | `datetimeoffset` | End Date | ☐ | | | `Id` | `int32` | ID | ☑ | | | `LedgerAccountId` | `int32` | Ledger Account ID | ☐ | | | `Name` | `string` | Name | ☐ | | | `NextInvoiceDate` | `datetimeoffset` | Next Invoice Date | ☐ | | | `Percentage` | `decimal` | Percentage | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `ProjectInvoiceScheduleId` | `int32` | Project Invoice Schedule ID | ☐ | | | `ProjectStatusId` | `int32` | Project Status ID | ☐ | | | `Quantity` | `decimal` | Quantity | ☐ | | | `Rate` | `decimal` | Rate | ☐ | | | `Recurrence` | `int32` | Recurrence | ☐ | | | `ScheduleContractId` | `int32` | Schedule Contract ID | ☐ | | | `ScheduleCreatorId` | `int32` | Schedule Creator ID | ☐ | | | `ScheduleCurrencyId` | `int32` | Schedule Currency ID | ☐ | | | `ScheduleDate` | `datetimeoffset` | Schedule Date | ☐ | | | `ScheduleEndDate` | `datetimeoffset` | Schedule End Date | ☐ | | | `ScheduleProjectCurrencyId` | `int32` | Schedule Project Currency ID | ☐ | | | `ScheduleRelationId` | `int32` | Schedule Relation ID | ☐ | | | `ScheduleStatus` | `int32` | Schedule Status | ☐ | | | `StakeholderBudget` | `boolean` | Stakeholder Budget | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `Total` | `decimal` | Total | ☐ | | | `UnitPrice` | `decimal` | Unit Price | ☐ | | | `UseRemainingPercentage` | `boolean` | Use Remaining Percentage | ☐ | |