invantive documentation
Invantive Support ForumsLog In / Sign Up

PurchaseOrderContractHistoryEntriesById: Bouw7 Purchase Order Contract History Entries by ID

read only REST

  • Catalog: Bouw7
  • Schema: Contract
  • Label: Purchase Order Contract History Entries by ID

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 PurchaseOrderContractHistoryEntriesById 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
contract_acceptedAt varchar2 Contract Accepted at filters on the platform, writable, contract.acceptedAt Datetime when contract was accepted.
contract_contractNumber varchar2 Contract Number filters on the platform, writable, contract.contractNumber The contract number of the contract.
contract_cost varchar2 Contract Cost filters on the platform, writable, contract.cost The cost of the contract.
contract_createDeliveryTicket char Contract Create Delivery Ticket filters on the platform, writable, contract.createDeliveryTicket Whether or not to create a delivery ticket.
contract_createdAt datetime Contract Created at filters on the platform, writable, contract.createdAt The creation time of the entity.
contract_createdBy varchar2 Contract Created by filters on the platform, writable, contract.createdBy The user that created the entity.
contract_deliveryAddress varchar2 Contract Delivery Address filters on the platform, writable, contract.deliveryAddress Delivery address of the purchase order contract.
contract_deliveryDate datetime Contract Delivery Date filters on the platform, writable, contract.deliveryDate Delivery date of the purchase order contract.
contract_deliveryDateText varchar2 Contract Delivery Date Text filters on the platform, writable, contract.deliveryDateText Delivery date text of the purchase order contract.
contract_deniedAt varchar2 Contract Denied at filters on the platform, writable, contract.deniedAt Datetime when contract was denied.
contract_description varchar2 Contract Description filters on the platform, writable, contract.description The description of the contract.
contract_id int64 Contract ID filters on the platform, writable, contract.id The ID of the purchase order contract.
contract_internalNote varchar2 itgen_bouw7_contract_internalnote filters on the platform, writable, contract.internalNote Internal note about the contract.
contract_language varchar2 Contract Language filters on the platform, writable, contract.language The locale used by this contract, e.g.: nl-NL.
contract_mailSent char Contract Mail Sent filters on the platform, writable, contract.mailSent Flag to indicate if mail was sent.
contract_mailSentAt varchar2 Contract Mail Sent at filters on the platform, writable, contract.mailSentAt The date the contract was sent.
contract_mailSentBy varchar2 Contract Mail Sent by filters on the platform, writable, contract.mailSentBy The user that sent the email.
contract_name varchar2(255) Contract Name filters on the platform, writable, contract.name The name of the contract.
contract_number varchar2 Contract Number filters on the platform, writable, contract.number Number of the contract.
contract_paymentAgreement varchar2 Contract Payment Agreement filters on the platform, writable, contract.paymentAgreement The payment agreement of the contract.
contract_purchaseType int64 Contract Purchase Type filters on the platform, writable, contract.purchaseType The purchase type of the purchase order contract.
contract_status int64 Contract Status filters on the platform, writable, contract.status Status of the contract.
contract_type int64 Contract Type filters on the platform, writable, contract.type Type of the contract.
contract_updatedAt datetime Contract Updated at filters on the platform, writable, contract.updatedAt The last updated time of the entity.
contract_updatedBy varchar2 Contract Updated by filters on the platform, writable, contract.updatedBy The user that last updated the entity.
createdAt datetime Created at filters on the platform, writable, createdAt The creation time of the entity.
createdBy varchar2 Created by filters on the platform, writable, createdBy The user that created the entity.
id int64 ID filters on the platform, writable, id The ID of the purchase order history entry.
message varchar2 Message filters on the platform, writable, message The message of the history entry.
updatedAt datetime Updated At filters on the platform, writable, updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by filters on the platform, writable, updatedBy The user that last updated the entity.

Release Notes

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