invantive documentation
Invantive Support ForumsLog In / Sign Up

SubcontractorContractHistoryEntries_ContractProjectCategoryDivisionSettings: Bouw7 itgen_bouw7_subcontractorcontracthistoryentries_contractprojectcategorydivisionsettings_plural

read only REST

  • Catalog: Bouw7
  • Schema: Contract
  • Label: itgen_bouw7_subcontractorcontracthistoryentries_contractprojectcategorydivisionsettings_plural

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

Can only retrieve data.

Summary

Returns a list of subcontractor contract history entries.

API Source

  • Endpoint: /contracts/subcontractor/log-entries/{id}
  • Operation: get /contracts/subcontractor/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 `` Subcontractor contract ID

Table Columns

The columns of the table SubcontractorContractHistoryEntries_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.
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.
expectedCompletionDate datetime Expected Completion Date writable, ::ancestor.::ancestor.::ancestor.expectedCompletionDate The expected completion date of the subcontractor contract.
id int64 ID writable, ::ancestor.::ancestor.::ancestor.id The ID of the subcontractor contract.
id_2 int64 ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.::ancestor.id The ID of the subcontract 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.
startDate datetime Start Date writable, ::ancestor.::ancestor.::ancestor.startDate The starting date of the subcontractor 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: