invantive documentation
Invantive Support ForumsLog In / Sign Up

CallOffSupplyOrders: Robaws Call-Off Supply Orders

delete REST

  • Catalog: Robaws
  • Schema: CallOffSupplyOrders
  • Primary Keys: id
  • Label: Call-Off Supply Orders

Search

Can retrieve data and change data using delete.

API Source

  • Endpoint: /api/v2/call-off-supply-orders
  • Operation: get /api/v2/call-off-supply-orders

Performance Characteristics

Characteristic Value
Average access latency (ms) 143
Full scan rows per minute 16,530
Point query rows per minute 584
Write rows per minute 539

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
articleId ``
assignedUserId ``
clientId ``
completed ``
materialId ``
projectId ``
purchaseInvoiceId ``
salesOrderId ``
searchText ``
sort ``
supplierId ``
supplyOrderId ``
updatedFrom ``
withArchived ``

Table Columns

The columns of the table CallOffSupplyOrders are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
archivedAt datetime Archived at filters on the platform, writable, archivedAt
assignedUserId varchar2 Assigned User ID filters on the platform, writable, assignedUserId
companyId varchar2 Company ID filters on the platform, writable, companyId
completed char Completed filters on the platform, writable, completed
completionPercentage decimal Completion Percentage filters on the platform, writable, completionPercentage
createdAt datetime Created at filters on the platform, writable, createdAt
date datetime Date filters on the platform, writable, date
deletedAt datetime Deleted at filters on the platform, writable, deletedAt
deliveryAddress varchar2 Delivery Address filters on the platform, writable, deliveryAddress
expectedDeliveryDate datetime Expected Delivery Date filters on the platform, writable, expectedDeliveryDate
extraFields varchar2 Extra Fields writable The JSON text of the nested object.
footerText varchar2 Footer Text filters on the platform, writable, footerText When reading, only present if requested via 'include' query parameter, otherwise null. HTML content. Embedded images are resolved to URLs based on the 'x-robaws-html-image-mode' request header: TEMPORARY_URL (default) returns time-limited presigned URLs that require no authentication; PERMANENT_URL returns stable URLs that require an authenticated session; NONE returns the stored HTML, where each image is an with a data-robaws-id and an empty src — keep that tag and its data-robaws-id when writing the HTML back, or the image is lost. Any other value (e.g. BASE64_INLINE) returns 400 Bad Request. When writing, omit it or send null to keep the current text; send an empty string to clear it.
id varchar2 ID filters on the platform, writable, id
introText varchar2 Intro Text filters on the platform, writable, introText When reading, only present if requested via 'include' query parameter, otherwise null. HTML content. Embedded images are resolved to URLs based on the 'x-robaws-html-image-mode' request header: TEMPORARY_URL (default) returns time-limited presigned URLs that require no authentication; PERMANENT_URL returns stable URLs that require an authenticated session; NONE returns the stored HTML, where each image is an with a data-robaws-id and an empty src — keep that tag and its data-robaws-id when writing the HTML back, or the image is lost. Any other value (e.g. BASE64_INLINE) returns 400 Bad Request. When writing, omit it or send null to keep the current text; send an empty string to clear it.
latestDeliveryDate datetime Latest Delivery Date filters on the platform, writable, latestDeliveryDate
lockedAt datetime Locked at filters on the platform, writable, lockedAt
logicId varchar2 Logical ID filters on the platform, writable, logicId
reference varchar2 Reference filters on the platform, writable, reference
remark varchar2 Remark filters on the platform, writable, remark
sentViaWebshop datetime Sent via Webshop filters on the platform, writable, sentViaWebshop
status varchar2 Status filters on the platform, writable, status
statusDetails_color varchar2 Status Details Color filters on the platform, writable, statusDetails.color
statusDetails_name varchar2 Status Details Name filters on the platform, writable, statusDetails.name
supplierContactId varchar2 Supplier Contact ID filters on the platform, writable, supplierContactId
supplierContact_archivedAt datetime Supplier Contact Archived At filters on the platform, writable, supplierContact.archivedAt
supplierContact_createdAt datetime Supplier Contact Created At filters on the platform, writable, supplierContact.createdAt
supplierContact_deletedAt datetime Supplier Contact Deleted At filters on the platform, writable, supplierContact.deletedAt
supplierContact_email varchar2 Supplier Contact Email filters on the platform, writable, supplierContact.email
supplierContact_extraFields varchar2 Supplier Contact Extra Fields writable The JSON text of the nested object.
supplierContact_gsm varchar2 Supplier Contact Mobile filters on the platform, writable, supplierContact.gsm
supplierContact_id varchar2 Supplier Contact ID filters on the platform, writable, supplierContact.id
supplierContact_lockedAt datetime Supplier Contact Locked At filters on the platform, writable, supplierContact.lockedAt
supplierContact_name varchar2 Supplier Contact Name filters on the platform, writable, supplierContact.name
supplierContact_position varchar2 Supplier Contact Position filters on the platform, writable, supplierContact.position
supplierContact_surname varchar2 Supplier Contact Surname filters on the platform, writable, supplierContact.surname
supplierContact_tel varchar2 Supplier Contact Phone filters on the platform, writable, supplierContact.tel
supplierContact_title varchar2 Supplier Contact Title filters on the platform, writable, supplierContact.title
supplierContact_updatedAt datetime Supplier Contact Updated At filters on the platform, writable, supplierContact.updatedAt
supplierId varchar2 Supplier ID filters on the platform, writable, supplierId
supplier_archivedAt datetime Supplier Archived At filters on the platform, writable, supplier.archivedAt
supplier_confidential char Supplier Confidential filters on the platform, writable, supplier.confidential
supplier_counterAccountCode int32 Supplier Counter Account Code filters on the platform, writable, supplier.counterAccountCode
supplier_createdAt datetime Supplier Created At filters on the platform, writable, supplier.createdAt
supplier_currency varchar2 Supplier Currency filters on the platform, writable, supplier.currency
supplier_deletedAt datetime Supplier Deleted At filters on the platform, writable, supplier.deletedAt
supplier_email varchar2 Supplier Email filters on the platform, writable, supplier.email
supplier_extraFields varchar2 Supplier Extra Fields writable The JSON text of the nested object.
supplier_fax varchar2 Supplier Fax filters on the platform, writable, supplier.fax
supplier_generalLedgerAccountId varchar2 Supplier General Ledger Account ID filters on the platform, writable, supplier.generalLedgerAccountId
supplier_gln varchar2 Supplier GLN filters on the platform, writable, supplier.gln
supplier_gsm varchar2 Supplier Mobile filters on the platform, writable, supplier.gsm
supplier_iban varchar2 Supplier IBAN filters on the platform, writable, supplier.iban
supplier_id varchar2 Supplier ID filters on the platform, writable, supplier.id
supplier_incomingInvoiceAcceptanceFlowRuleId varchar2 Supplier Incoming Invoice Acceptance Flow Rule ID filters on the platform, writable, supplier.incomingInvoiceAcceptanceFlowRuleId
supplier_invoiceRemarks varchar2 Supplier Invoice Remarks filters on the platform, writable, supplier.invoiceRemarks
supplier_kvk varchar2 Supplier Chamber of Commerce filters on the platform, writable, supplier.kvk
supplier_language varchar2 Supplier Language filters on the platform, writable, supplier.language
supplier_legalFormId varchar2 Supplier Legal Form ID filters on the platform, writable, supplier.legalFormId
supplier_lockedAt datetime Supplier Locked At filters on the platform, writable, supplier.lockedAt
supplier_logicId varchar2 Supplier Logic ID filters on the platform, writable, supplier.logicId
supplier_name varchar2 Supplier Name filters on the platform, writable, supplier.name
supplier_paymentConditionId varchar2 Supplier Payment Condition ID filters on the platform, writable, supplier.paymentConditionId
supplier_planningEmail varchar2 Supplier Planning Email filters on the platform, writable, supplier.planningEmail
supplier_purchaseSupplyOrderAcceptanceFlowRuleId varchar2 Supplier Purchase Supply Order Acceptance Flow Rule ID filters on the platform, writable, supplier.purchaseSupplyOrderAcceptanceFlowRuleId
supplier_status varchar2 Supplier Status filters on the platform, writable, supplier.status
supplier_steuernummer varchar2 Supplier German Tax Number filters on the platform, writable, supplier.steuernummer
supplier_supplyOrderRemarks varchar2 Supplier Supply Order Remarks filters on the platform, writable, supplier.supplyOrderRemarks
supplier_tel varchar2 Supplier Phone filters on the platform, writable, supplier.tel
supplier_type varchar2 Supplier Type filters on the platform, writable, supplier.type
supplier_updatedAt datetime Supplier Updated At filters on the platform, writable, supplier.updatedAt
supplier_vatIdNumber varchar2 Supplier VAT ID Number filters on the platform, writable, supplier.vatIdNumber
supplier_vatTariffId varchar2 Supplier VAT Tariff ID filters on the platform, writable, supplier.vatTariffId
supplier_website varchar2 Supplier Website filters on the platform, writable, supplier.website
toLocationId varchar2 To Location ID filters on the platform, writable, toLocationId
toLocation_archivedAt datetime To Location Archived At filters on the platform, writable, toLocation.archivedAt
toLocation_countAsAvailable char To Location Count as Available filters on the platform, writable, toLocation.countAsAvailable
toLocation_createdAt datetime To Location Created At filters on the platform, writable, toLocation.createdAt
toLocation_deletedAt datetime To Location Deleted At filters on the platform, writable, toLocation.deletedAt
toLocation_extraFields varchar2 To Location Extra Fields writable The JSON text of the nested object.
toLocation_id varchar2 To Location ID filters on the platform, writable, toLocation.id
toLocation_lockedAt datetime To Location Locked At filters on the platform, writable, toLocation.lockedAt
toLocation_name varchar2 To Location Name filters on the platform, writable, toLocation.name
toLocation_updatedAt datetime To Location Updated At filters on the platform, writable, toLocation.updatedAt
totalExclVat decimal Total excluding VAT filters on the platform, writable, totalExclVat
totalInclVat decimal Total including VAT filters on the platform, writable, totalInclVat
type varchar2 Type filters on the platform, writable, type
updatedAt datetime Updated at filters on the platform, writable, updatedAt

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: