PurchaseOrderContractTerms: Bouw7 Purchase Order Contract Terms
read only REST
- Catalog:
Bouw7 - Schema:
Contract - Label: Purchase Order Contract Terms
Returns a list of purchase order contract terms. Returns a list of purchase order contract terms.
Can only retrieve data.
Summary
Returns a list of purchase order contract terms.
API Source
- Endpoint:
/list/purchase-order-contract-terms - Operation:
get /list/purchase-order-contract-terms
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 90 |
| Full scan rows per minute | 186,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 PurchaseOrderContractTerms 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. | |
amount |
varchar2 |
Amount to Receive | filters on the platform, writable, amount |
The amount to receive of this contract term. | |
contract |
int64 |
Contract ID | filters on the platform, writable, contract |
The ID of the contract of this contract term. | |
contract |
varchar2 |
Contract Name | filters on the platform, writable, contract |
The name of the contract of this contract term. | |
contract |
varchar2 |
Contract Number | filters on the platform, writable, contract |
The number of the contract of this contract term. | |
contract |
int64 |
Contract Project Security Link ID | filters on the platform, writable, contract |
The ID of the project security link of the contract of this contract term. | |
contract |
varchar2 |
Contract Project Security Link Name | filters on the platform, writable, contract |
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. | |
cost |
varchar2 |
Cost Received | filters on the platform, writable, cost |
The received cost of this contract term. | |
cost |
varchar2 |
Cost to Receive | filters on the platform, writable, cost |
The cost to receive of this contract term. | |
created |
datetime |
Created at | filters on the platform, writable, created |
The creation date of the object in ATOM/ISO-8601 format | |
created |
int64 |
Created by ID | filters on the platform, writable, created |
The ID of the user. | |
created |
varchar2 |
Created by User Name | filters on the platform, writable, created |
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. | |
is |
char |
Is Approved | filters on the platform, writable, is |
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. | |
project |
int64 |
Project ID | filters on the platform, writable, project |
The ID of the project of this contract term. | |
project |
varchar2 |
Project Name | filters on the platform, writable, project |
The name of the project of this contract term. | |
project |
int64 |
Project Security Link ID | filters on the platform, writable, project |
The ID of the project security link of this contract term. | |
project |
varchar2 |
Project Security Link Name | filters on the platform, writable, project |
The name of the project security link of this contract term. | |
supplier |
int64 |
Supplier ID | filters on the platform, writable, supplier |
The ID of the supplier of this contract term. | |
supplier |
varchar2 |
Supplier Name | filters on the platform, writable, supplier |
The name of the supplier of this contract term. | |
updated |
datetime |
Updated At | filters on the platform, writable, updated |
The creation date of the object in ATOM/ISO-8601 format | |
updated |
int64 |
Updated by ID | filters on the platform, writable, updated |
The ID of the user. | |
updated |
varchar2 |
Updated by User Name | filters on the platform, writable, updated |
The username of the user. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: