# PurchaseInvoices: ionBIZ Purchase Invoices - Catalog: `ionBIZ` - Label: Purchase Invoices - Retrieve: true ## Table Columns The columns of the table `PurchaseInvoices` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Address_CountryId` | `int32` | Address Country ID | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `CurrencyId` | `int32` | Currency ID | ☐ | | | `DeletedById` | `int32` | Deleted by ID | ☐ | | | `DeletionDate` | `datetimeoffset` | Deletion Date | ☐ | | | `DeliveryDate` | `datetimeoffset` | Delivery Date | ☐ | | | `Description` | `string` | Description | ☐ | | | `DocDate` | `datetimeoffset` | Document Date | ☐ | | | `DocId` | `string` | Document ID | ☐ | | | `DueDate` | `datetimeoffset` | Due Date | ☐ | | | `ExchangeRateDate` | `datetimeoffset` | Exchange Rate Date | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `Locked` | `boolean` | Locked | ☐ | | | `Notes` | `string` | Notes | ☐ | | | `PaidOn` | `datetimeoffset` | Paid on | ☐ | | | `PaymentMethodId` | `int32` | Payment Method ID | ☐ | | | `PaymentRef` | `string` | Payment Reference | ☐ | | | `ProjectId` | `int32` | Project ID | ☐ | | | `PurchaseInvoiceStatusId` | `int32` | Purchase Invoice Status ID | ☐ | | | `RelationContactId` | `int32` | Relation Contact ID | ☐ | | | `RelationId` | `int32` | Relation ID | ☐ | | | `RelationVat` | `string` | Relation VAT | ☐ | | | `ResourceId` | `int32` | Resource ID | ☐ | | | `ResourceLanguageId` | `int32` | Resource Language ID | ☐ | | | `SupplierDocId` | `string` | Supplier Document ID | ☐ | | | `SysEndTime` | `datetimeoffset` | System End Time | ☐ | | | `SysStartTime` | `datetimeoffset` | System Start Time | ☐ | | | `TemplateId` | `int32` | Template ID | ☐ | |