SubcontractContractHistoryEntriesBySubcontractorId: Bouw7 Sub-contract Contract History Entries by Sub-contract or ID
read only REST
- Catalog:
Bouw7 - Schema:
Contract - Label: Sub-contract Contract History Entries by Sub-contract or ID
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 SubcontractContractHistoryEntriesBySubcontractorId 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_ |
varchar2 |
Contract Accepted at | filters on the platform, writable, contract. |
Datetime when contract was accepted. | |
contract_ |
varchar2 |
Contract Number | filters on the platform, writable, contract. |
The contract number of the contract. | |
contract_ |
varchar2 |
Contract Cost | filters on the platform, writable, contract. |
The cost of the contract. | |
contract_ |
char |
Contract Create Delivery Ticket | filters on the platform, writable, contract. |
Whether or not to create a delivery ticket. | |
contract_ |
datetime |
Contract Created at | filters on the platform, writable, contract. |
The creation time of the entity. | |
contract_ |
varchar2 |
Contract Created by | filters on the platform, writable, contract. |
The user that created the entity. | |
contract_ |
varchar2 |
Contract Denied at | filters on the platform, writable, contract. |
Datetime when contract was denied. | |
contract_ |
varchar2 |
Contract Description | filters on the platform, writable, contract. |
The description of the contract. | |
contract_ |
datetime |
Contract Expected Completion Date | filters on the platform, writable, contract. |
The expected completion date of the subcontractor contract. | |
contract_ |
int64 |
Contract ID | filters on the platform, writable, contract. |
The ID of the subcontractor contract. | |
contract_ |
varchar2 |
itgen_bouw7_contract_internalnote | filters on the platform, writable, contract. |
Internal note about the contract. | |
contract_ |
varchar2 |
Contract Language | filters on the platform, writable, contract. |
The locale used by this contract, e.g.: nl-NL. | |
contract_ |
char |
Contract Mail Sent | filters on the platform, writable, contract. |
Flag to indicate if mail was sent. | |
contract_ |
varchar2 |
Contract Mail Sent at | filters on the platform, writable, contract. |
The date the contract was sent. | |
contract_ |
varchar2 |
Contract Mail Sent by | filters on the platform, writable, contract. |
The user that sent the email. | |
contract_ |
varchar2 |
Contract Name | filters on the platform, writable, contract. |
The name of the contract. | |
contract_ |
varchar2 |
Contract Number | filters on the platform, writable, contract. |
Number of the contract. | |
contract_ |
varchar2 |
Contract Payment Agreement | filters on the platform, writable, contract. |
The payment agreement of the contract. | |
contract_ |
datetime |
Contract Start Date | filters on the platform, writable, contract. |
The starting date of the subcontractor contract. | |
contract_ |
int64 |
Contract Status | filters on the platform, writable, contract. |
Status of the contract. | |
contract_ |
int64 |
Contract Type | filters on the platform, writable, contract. |
Type of the contract. | |
contract_ |
datetime |
Contract Updated at | filters on the platform, writable, contract. |
The last updated time of the entity. | |
contract_ |
varchar2 |
Contract Updated by | filters on the platform, writable, contract. |
The user that last updated the entity. | |
created |
datetime |
Created at | filters on the platform, writable, created |
The creation time of the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, created |
The user that created the entity. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of the subcontract history entry. | |
message |
varchar2 |
Message | filters on the platform, writable, message |
The message of the history entry. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, updated |
The user that last updated the entity. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: