invantive documentation
Invantive Support ForumsLog In / Sign Up

SubcontractorContractTerms: Bouw7 Sub-contractor Contract Terms

read only REST

  • Catalog: Bouw7
  • Schema: Contract
  • Label: Sub-contractor Contract Terms

Returns a list of subcontractor contract terms. Returns a list of subcontractor contract terms.

Can only retrieve data.

Summary

Returns a list of subcontractor contract terms.

API Source

  • Endpoint: /list/subcontractor-contract-terms
  • Operation: get /list/subcontractor-contract-terms

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
q `` A Heimdall Query Language string.

Table Columns

The columns of the table SubcontractorContractTerms 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
amount varchar2 Amount filters on the platform, writable, amount The amount of this contract term.
amountToReceive varchar2 Amount to Receive filters on the platform, writable, amountToReceive The amount to receive of this contract term.
contractId int64 Contract ID filters on the platform, writable, contractId The ID of the contract of this contract term.
contractName varchar2 Contract Name filters on the platform, writable, contractName The name of the contract of this contract term.
contractNumber varchar2 Contract Number filters on the platform, writable, contractNumber The number of the contract of this contract term.
contractProjectSecurityLinkId int64 Contract Project Security Link ID filters on the platform, writable, contractProjectSecurityLinkId The ID of the project security link of the contract of this contract term.
contractProjectSecurityLinkName int64 Contract Project Security Link Name filters on the platform, writable, contractProjectSecurityLinkName The name of the project security link of the contract of this contract term.
cost varchar2 Cost filters on the platform, writable, cost The cost of this contract term.
costReceived varchar2 Cost Received filters on the platform, writable, costReceived The received cost of this contract term.
costToReceive varchar2 Cost to Receive filters on the platform, writable, costToReceive The cost to receive of this contract term.
createdAt datetime Created at filters on the platform, writable, createdAt The creation date of the object in ATOM/ISO-8601 format
createdBy_id int64 Created by ID filters on the platform, writable, createdBy.id The ID of the user.
createdBy_username varchar2 Created by User Name filters on the platform, writable, createdBy.username The username of the user.
description varchar2 Description filters on the platform, writable, description The description of this contract term.
id int64 ID filters on the platform, writable, id The ID this contract term.
isApproved char Is Approved filters on the platform, writable, isApproved Whether this this contract term is approved.
isPaid char Is Paid filters on the platform, writable, isPaid Whether this contract term is paid.
number varchar2 Number filters on the platform, writable, number The number of this contract term.
projectId int64 Project ID filters on the platform, writable, projectId The ID of the project of this contract term.
projectName varchar2 Project Name filters on the platform, writable, projectName The name of the project of this contract term.
projectSecurityLinkId int64 Project Security Link ID filters on the platform, writable, projectSecurityLinkId The ID of the project security link of this contract term.
projectSecurityLinkName int64 Project Security Link Name filters on the platform, writable, projectSecurityLinkName The name of the project security link of this contract term.
supplierId int64 Supplier ID filters on the platform, writable, supplierId The ID of the supplier of this contract term.
supplierName varchar2 Supplier Name filters on the platform, writable, supplierName The name of the supplier of this contract term.
updatedAt datetime Updated At filters on the platform, writable, updatedAt The creation date of the object in ATOM/ISO-8601 format
updatedBy_id int64 Updated by ID filters on the platform, writable, updatedBy.id The ID of the user.
updatedBy_username varchar2 Updated by User Name filters on the platform, writable, updatedBy.username The username of the user.

Release Notes

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