# ProjectInvoiceScheduleLines: ionBIZ Project Invoice Schedule Lines - Catalog: `ionBIZ` - Label: Project Invoice Schedule Lines - Retrieve: true ## Table Columns The columns of the table `ProjectInvoiceScheduleLines` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Advance` | `boolean` | Advance | ☐ | | | `Amount` | `decimal` | Amount | ☐ | | | `ApprovalProcessId` | `int32` | Approval Process ID | ☐ | | | `ApproveOnlyThisLevel` | `boolean` | Approve only this Level | ☐ | | | `CalculateAmountOnInvoicing` | `boolean` | Calculate Amount on Invoicing | ☐ | | | `ContractId` | `int32` | Contract ID | ☐ | | | `ContractLineId` | `int32` | Contract Line ID | ☐ | | | `CostTypeId` | `int32` | Cost Type ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `Date` | `datetimeoffset` | Date | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `Description` | `string` | Description | ☐ | | | `EndDate` | `datetimeoffset` | End Date | ☐ | | | `Id` | `int32` | ID | ☑ | | | `Invoiced` | `boolean` | Invoiced | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `LastExportDateTime` | `datetimeoffset` | Last Export Date/Time | ☐ | | | `LastInvoiceDate` | `datetimeoffset` | Last Invoice Date | ☐ | | | `LastRecurrenceDate` | `datetimeoffset` | Last Recurrence Date | ☐ | | | `LedgerAccountId` | `int32` | Ledger Account ID | ☐ | | | `LineType` | `int32` | Line Type | ☐ | | | `NextInvoiceDate` | `datetimeoffset` | Next Invoice Date | ☐ | | | `Percentage` | `decimal` | Percentage | ☐ | | | `ProjectBudget` | `decimal` | Project Budget | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `ProjectInvoiceLineId` | `int32` | Project Invoice Line ID | ☐ | | | `ProjectInvoiceProposalLineId` | `int32` | Project Invoice Proposal Line ID | ☐ | | | `ProjectInvoiceScheduleId` | `int32` | Project Invoice Schedule ID | ☐ | | | `Quantity` | `decimal` | Quantity | ☐ | | | `QuoteId` | `int32` | Quote ID | ☐ | | | `Recurrence` | `int32` | Recurrence | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `SeparateProposal` | `boolean` | Separate Proposal | ☐ | | | `Sequence` | `int32` | Sequence | ☐ | | | `TaskId` | `int32` | Task ID | ☐ | | | `TransferToProjectId` | `int32` | Transfer to Project ID | ☐ | | | `UnitPrice` | `decimal` | Unit Price | ☐ | | | `UseRemainingPercentage` | `boolean` | Use Remaining Percentage | ☐ | | | `VATPercentageId` | `int32` | VAT Percentage ID | ☐ | |