# ProjectInvoices: ionBIZ Project Invoices - Catalog: `ionBIZ` - Label: Project Invoices - Retrieve: true ## Table Columns The columns of the table `ProjectInvoices` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Address_CountryId` | `int32` | Address Country ID | ☐ | | | `AddressInvoiceName` | `string` | Address Invoice Name | ☐ | | | `Amount` | `decimal` | Amount | ☐ | | | `BookingDate` | `datetimeoffset` | Booking Date | ☐ | | | `CompanyAddressId` | `int32` | Company Address ID | ☐ | | | `ContractId` | `int32` | Contract ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CreditNote` | `boolean` | Credit Note | ☐ | | | `CurrencyConvertorFactor` | `decimal` | Currency Convertor Factor | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `CustomerRef` | `string` | Customer Reference | ☐ | | | `DefaultLineDiscountPercentage` | `decimal` | Default Line Discount Percentage | ☐ | | | `DefaultLineDiscountType` | `int32` | Default Line Discount Type | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `DeliveryDate` | `datetimeoffset` | Delivery Date | ☐ | | | `Description` | `string` | Description | ☐ | | | `DetailTemplateId` | `int32` | Detail Template ID | ☐ | | | `DiscountPercentage` | `decimal` | Discount (%) | ☐ | | | `DocDate` | `datetimeoffset` | Document Date | ☐ | | | `DocId` | `string` | Document ID | ☐ | | | `DueDate` | `datetimeoffset` | Due Date | ☐ | | | `EqualizedByCreditNoteId` | `int32` | Equalized by Credit Note ID | ☐ | | | `EqualizesInvoiceId` | `int32` | Equalizes Invoice ID | ☐ | | | `ExchangeRateDate` | `datetimeoffset` | Exchange Rate Date | ☐ | | | `HoursPerDay` | `decimal` | Hours per Day | ☐ | | | `Id` | `int32` | ID | ☑ | | | `Intercompany` | `boolean` | Intercompany | ☐ | | | `IntercompanyProjectId` | `int32` | Inter-company Project ID | ☐ | | | `IntrastatCountryId` | `int32` | Intrastat Country ID | ☐ | | | `InvoiceInDays` | `boolean` | Invoice in Days | ☐ | | | `InvoiceText` | `string` | Invoice Text | ☐ | | | `InvoiceToAddressId` | `int32` | Invoice to Address ID | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `Locked` | `boolean` | Locked | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `Notes` | `string` | Notes | ☐ | | | `NumberRangeId` | `int32` | Number Range ID | ☐ | | | `OurRef` | `string` | Our Reference | ☐ | | | `PaidOn` | `datetimeoffset` | Paid on | ☐ | | | `PaidOnBankAccountId` | `int32` | Paid on Bank Account ID | ☐ | | | `PaymentComment` | `string` | Payment Comment | ☐ | | | `PaymentConditionId` | `int32` | Payment Condition ID | ☐ | | | `ProcessDateTime` | `datetimeoffset` | Process Date/Time | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `ProjectInvoiceApprovalPeriodId` | `int32` | Project Invoice Approval Period ID | ☐ | | | `ProjectInvoiceGroupId` | `int32` | Project Invoice Group ID | ☐ | | | `ProjectInvoiceProposalId` | `int32` | Project Invoice Proposal ID | ☐ | | | `ProjectInvoiceStatusId` | `int32` | Project Invoice Status ID | ☐ | | | `QuoteId` | `int32` | Quote ID | ☐ | | | `RelationContactId` | `int32` | Relation Contact ID | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `RelationVat` | `string` | Relation VAT | ☐ | | | `RevenueDate` | `datetimeoffset` | Revenue Date | ☐ | | | `SalesManagerId` | `int32` | Sales Manager ID | ☐ | | | `SendInvoiceByOption` | `int32` | Send Invoice by Option | ☐ | | | `SendToAddress_CountryId` | `int32` | Send to Address Country ID | ☐ | | | `SendToAddressId` | `int32` | Send to Address ID | ☐ | | | `SendToAddressName` | `string` | Send to Address Name | ☐ | | | `StructuredReference` | `string` | Structured Reference | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `TemplateId` | `int32` | Template ID | ☐ | |