invantive documentation
Invantive Support ForumsLog In / Sign Up

PurchaseOrderContractHistoryEntries_ContractProjectCategoryDivisionSettings: Bouw7 itgen_bouw7_purchaseordercontracthistoryentries_contractprojectcategorydivisionsettings_plural

read only REST

  • Catalog: Bouw7
  • Schema: Contract
  • Label: itgen_bouw7_purchaseordercontracthistoryentries_contractprojectcategorydivisionsettings_plural

Returns a list of purchase order contract history entries associated with the given ID. Returns a list of purchase order contract history entries.

Can only retrieve data.

Summary

Returns a list of purchase order contract history entries.

API Source

  • Endpoint: /contracts/purchase-order/log-entries/{id}
  • Operation: get /contracts/purchase-order/log-entries/{id}

Performance Characteristics

Characteristic Value
Average access latency (ms) 90
Full scan rows per minute 241,000
Point query rows per minute 666

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
id `` Purchase order contract ID

Table Columns

The columns of the table PurchaseOrderContractHistoryEntries_ContractProjectCategoryDivisionSettings 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
acceptedAt varchar2 Accepted at writable, ::ancestor.::ancestor.::ancestor.acceptedAt Datetime when contract was accepted.
contractNumber varchar2 Contract Number writable, ::ancestor.::ancestor.::ancestor.contractNumber The contract number of the contract.
cost varchar2 Cost writable, ::ancestor.::ancestor.::ancestor.cost The cost of the contract.
createDeliveryTicket char Create Delivery Ticket writable, ::ancestor.::ancestor.::ancestor.createDeliveryTicket Whether or not to create a delivery ticket.
createdAt datetime Created at writable, ::ancestor.::ancestor.::ancestor.createdAt The creation time of the entity.
createdAt_2 datetime Created at filters on the platform, writable, ::ancestor.::ancestor.::ancestor.::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Created by writable, ::ancestor.::ancestor.::ancestor.createdBy The user that created the entity.
createdBy_2 varchar2 Created by filters on the platform, writable, ::ancestor.::ancestor.::ancestor.::ancestor.createdBy The user that created the entity.
deliveryAddress varchar2 Delivery Address writable, ::ancestor.::ancestor.::ancestor.deliveryAddress Delivery address of the purchase order contract.
deliveryDate datetime Delivery Date writable, ::ancestor.::ancestor.::ancestor.deliveryDate Delivery date of the purchase order contract.
deliveryDateText varchar2 Delivery Date Text writable, ::ancestor.::ancestor.::ancestor.deliveryDateText Delivery date text of the purchase order contract.
deniedAt varchar2 Denied at writable, ::ancestor.::ancestor.::ancestor.deniedAt Datetime when contract was denied.
description varchar2 Description writable, ::ancestor.::ancestor.::ancestor.description The description of the contract.
id int64 ID writable, ::ancestor.::ancestor.::ancestor.id The ID of the purchase order contract.
id_2 int64 ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.::ancestor.id The ID of the purchase order history entry.
internalNote varchar2 Internal Note writable, ::ancestor.::ancestor.::ancestor.internalNote Internal note about the contract.
language varchar2 Language writable, ::ancestor.::ancestor.::ancestor.language The locale used by this contract, e.g.: nl-NL.
mailSent char Mail Sent writable, ::ancestor.::ancestor.::ancestor.mailSent Flag to indicate if mail was sent.
mailSentAt varchar2 Mail Sent at writable, ::ancestor.::ancestor.::ancestor.mailSentAt The date the contract was sent.
mailSentBy varchar2 Mail Sent by writable, ::ancestor.::ancestor.::ancestor.mailSentBy The user that sent the email.
message varchar2 Message filters on the platform, writable, ::ancestor.::ancestor.::ancestor.::ancestor.message The message of the history entry.
name varchar2(255) Name writable, ::ancestor.::ancestor.::ancestor.name The name of the contract.
number varchar2 Number writable, ::ancestor.::ancestor.::ancestor.number Number of the contract.
paymentAgreement varchar2 Payment Agreement writable, ::ancestor.::ancestor.::ancestor.paymentAgreement The payment agreement of the contract.
purchaseType int64 Purchase Type writable, ::ancestor.::ancestor.::ancestor.purchaseType The purchase type of the purchase order contract.
status int64 Status writable, ::ancestor.::ancestor.::ancestor.status Status of the contract.
type int64 Type writable, ::ancestor.::ancestor.::ancestor.type Type of the contract.
updatedAt datetime Updated At writable, ::ancestor.::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedAt_2 datetime Updated at filters on the platform, writable, ::ancestor.::ancestor.::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by writable, ::ancestor.::ancestor.::ancestor.updatedBy The user that last updated the entity.
updatedBy_2 varchar2 Updated by filters on the platform, writable, ::ancestor.::ancestor.::ancestor.::ancestor.updatedBy The user that last updated the entity.

Release Notes

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