# PurchaseInvoiceLines: ROBAWS Purchase Invoice Lines Search This is a read-only table function. The ROBAWS API may not support modifying the data, or the Invantive SQL driver for ROBAWS does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the ROBAWS API. - Catalog: `Robaws` - Schema: `PurchaseInvoices` - Label: Purchase Invoice Lines ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `fromDate` | `datetime` | ☐ | | | | `projectId` | `string` | ☐ | | | | `searchText` | `string` | ☐ | | | | `sort` | `string` | ☐ | | | | `supplierId` | `string` | ☐ | | | | `toDate` | `datetime` | ☐ | | | | `type` | `string` | ☐ | | Values: INVOICE, CREDIT_NOTE. | | `withArchived` | `boolean` | ☐ | | | ## Columns The columns of the table `PurchaseInvoiceLines` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `accountancyStatus` | `string` | Accounting status | ☐ | | | `activityId` | `string` | Activity ID | ☐ | | | `archivedAt_1` | `datetime` | Archived at | ☐ | | | `archivedAt` | `datetime` | Archived at | ☐ | | | `articleId` | `string` | Item ID | ☐ | | | `c_metadata_description` | `string` | | ☐ | | | `c_metadata_href` | `string` | | ☐ | | | `c_metadata_resource` | `string` | | ☐ | | | `c_metadata_resourceTypeId` | `string` | | ☐ | | | `company_archivedAt` | `datetime` | | ☐ | | | `company_createdAt` | `datetime` | | ☐ | | | `company_deletedAt` | `datetime` | | ☐ | | | `company_extraFields` | `string` | | ☐ | | | `company_id` | `string` | | ☐ | | | `company_lockedAt` | `datetime` | | ☐ | | | `company_name` | `string` | | ☐ | | | `company_updatedAt` | `datetime` | | ☐ | | | `companyId` | `string` | Company ID | ☐ | | | `contactPersonId` | `string` | Contact Person ID | ☐ | | | `createdAt_1` | `datetime` | Created at | ☐ | | | `createdAt` | `datetime` | Created at | ☐ | | | `creditedInvoiceId` | `string` | Credit Note ID | ☐ | Only present for invoices of type CREDIT_NOTE. This is the id of the invoice that has been credited by this credit note. | | `creditedTotal` | `decimal` | Total credited | ☐ | Only present for invoices of type INVOICE | | `currency` | `string` | Currencies | ☐ | | | `date` | `datetime` | Date | ☐ | | | `deletedAt_1` | `datetime` | Deleted at | ☐ | | | `deletedAt` | `datetime` | Deleted at | ☐ | | | `description` | `string` | Description | ☐ | | | `discount` | `decimal` | Discount | ☐ | | | `exchangeRate` | `decimal` | Exchange rate | ☐ | | | `expireDate` | `datetime` | Expiry Date | ☐ | | | `extraFields_1` | `string` | Extra fields | ☐ | | | `extraFields` | `string` | Extra fields | ☐ | | | `generalLedgerAccountId` | `string` | Ledger Account ID | ☐ | | | `id_1` | `string` | ID | ☐ | | | `id` | `string` | ID | ☐ | | | `invoiceNumber` | `string` | Invoice Number | ☐ | | | `journalName` | `string` | Journal name | ☐ | | | `lockedAt_1` | `datetime` | Closed at | ☐ | | | `lockedAt` | `datetime` | Closed at | ☐ | | | `logicId` | `string` | Logical ID | ☐ | | | `materialId` | `string` | Material ID | ☐ | | | `openTotal` | `decimal` | Total Open | ☐ | | | `paymentConditionId` | `string` | Payment Term ID | ☐ | | | `paymentInstruction` | `string` | Payment Instruction | ☐ | | | `postId` | `string` | Post ID | ☐ | | | `price` | `decimal` | Price | ☐ | | | `projectId` | `string` | Project ID | ☐ | | | `purchaseInvoiceId` | `string` | Purchase Invoice ID | ☐ | Only present when obtained via bulk endpoint | | `quantity` | `decimal` | Quantity | ☐ | | | `remark` | `string` | Remark | ☐ | | | `status` | `string` | Status | ☐ | | | `statusDetails_color` | `string` | | ☐ | | | `statusDetails_name` | `string` | | ☐ | | | `styleName` | `string` | Style Name | ☐ | | | `supplier_archivedAt` | `datetime` | | ☐ | | | `supplier_createdAt` | `datetime` | | ☐ | | | `supplier_deletedAt` | `datetime` | | ☐ | | | `supplier_email` | `string` | | ☐ | | | `supplier_extraFields` | `string` | | ☐ | | | `supplier_fax` | `string` | | ☐ | | | `supplier_generalLedgerAccountId` | `string` | | ☐ | | | `supplier_gsm` | `string` | | ☐ | | | `supplier_iban` | `string` | | ☐ | | | `supplier_id` | `string` | | ☐ | | | `supplier_invoiceRemarks` | `string` | | ☐ | | | `supplier_kvk` | `string` | | ☐ | | | `supplier_language` | `string` | | ☐ | | | `supplier_legalFormId` | `string` | | ☐ | | | `supplier_lockedAt` | `datetime` | | ☐ | | | `supplier_logicId` | `string` | | ☐ | | | `supplier_name` | `string` | | ☐ | | | `supplier_paymentConditionId` | `string` | | ☐ | | | `supplier_planningEmail` | `string` | | ☐ | | | `supplier_status` | `string` | | ☐ | | | `supplier_supplyOrderRemarks` | `string` | | ☐ | | | `supplier_tel` | `string` | | ☐ | | | `supplier_type` | `string` | | ☐ | | | `supplier_updatedAt` | `datetime` | | ☐ | | | `supplier_vatIdNumber` | `string` | | ☐ | | | `supplier_vatTariffId` | `string` | | ☐ | | | `supplier_website` | `string` | | ☐ | | | `supplierId` | `string` | Supplier ID | ☐ | | | `supplierReference` | `string` | Supplier Reference | ☐ | | | `supplyOrderId` | `string` | Delivery Order ID | ☐ | | | `totalExclVat` | `decimal` | Total excluding VAT | ☐ | | | `totalInclVat` | `decimal` | Total including VAT | ☐ | | | `type_1` | `string` | Type | ☐ | | | `type` | `string` | Type | ☐ | | | `unitType` | `string` | Unit Type | ☐ | | | `updatedAt_1` | `datetime` | Updated On | ☐ | | | `updatedAt` | `datetime` | Updated On | ☐ | | | `vatTariffId` | `string` | VAT Rate ID | ☐ | |