ContractOrderLines: Bouw7 Contract Order Lines
popular read only REST
- Catalog:
Bouw7 - Schema:
Contract - Label: Contract Order Lines
Returns all contract order lines for the current organization. Use HQL to filter for specific items. Returns all contract order lines for the current organization.
Can only retrieve data.
Summary
Returns all contract order lines for the current organization.
API Source
- Endpoint:
/list/contract-order-lines - Operation:
get /list/contract-order-lines
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 90 |
| Full scan rows per minute | 595,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 ContractOrderLines 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 |
|---|---|---|---|---|---|
article |
varchar2 |
Article Number | filters on the platform, writable, article |
The article number of the product referenced in this contract order line. | |
contact_ |
varchar2 |
Contact Email Address | filters on the platform, writable, contact. |
The email address of the contact. | |
contact_ |
int64 |
Contact ID | filters on the platform, writable, contact. |
The ID of the contact. | |
contact_ |
varchar2 |
Contact Name | filters on the platform, writable, contact. |
The name of this contact. | |
contact_ |
varchar2 |
Contact Type | filters on the platform, writable, contact. |
The type of this contact. | |
contact_ |
int64 |
Contact Type ID | filters on the platform, writable, contact. |
The type ID of this contact. | |
cost |
int64 |
Cost Type | filters on the platform, writable, cost |
The cost type of this contract order line. | |
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 order line. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of this contract order line. | |
is |
char |
itgen_bouw7_iscreatedmanually | filters on the platform, writable, is |
Whether the contract order line was created manually. | |
project |
varchar2 |
Project Security Link Code | filters on the platform, writable, project |
The security code. | |
project |
int64 |
itgen_bouw7_projectsecuritylink_costtype | filters on the platform, writable, project |
The name of the cost type. | |
project |
int64 |
Project Security Link ID | filters on the platform, writable, project |
The ID of the project security link. | |
project |
varchar2 |
Project Security Link Name | filters on the platform, writable, project |
The name of the project security link. | |
project |
varchar2 |
itgen_bouw7_projectsecuritylink_parentname | filters on the platform, writable, project |
The name of the security code. | |
project |
int64 |
Project Security Link Project ID | filters on the platform, writable, project |
The ID of the project associated with this security code. | |
project |
int64 |
Project Security Link Status | filters on the platform, writable, project |
The status of the project security link. | |
project_ |
int64 |
Project Branch ID | filters on the platform, writable, project. |
The ID of the branch of this project. | |
project_ |
int64 |
Project Category ID | filters on the platform, writable, project. |
The ID of the category of this project. | |
project_ |
int64 |
Project Division ID | filters on the platform, writable, project. |
The ID of the division of this project. | |
project_ |
int64 |
Project ID | filters on the platform, writable, project. |
The ID of the project. | |
project_ |
varchar2 |
Project Name | filters on the platform, writable, project. |
The name of the project. | |
project_ |
varchar2 |
Project Number | filters on the platform, writable, project. |
The number of the project. | |
project_ |
varchar2 |
Project Status | filters on the platform, writable, project. |
The name of the current status of this project. | |
project_ |
int64 |
Project Status ID | filters on the platform, writable, project. |
The ID of the status of this project. | |
purchase |
int64 |
itgen_bouw7_purchaseordercontract_id | filters on the platform, writable, purchase |
The ID of the contract. | |
purchase |
varchar2 |
itgen_bouw7_purchaseordercontract_number | filters on the platform, writable, purchase |
The identification number of the contract. | |
quantity |
varchar2 |
Quantity | filters on the platform, writable, quantity |
The quantity of the product referenced in this contract order line. | |
quantity |
varchar2 |
itgen_bouw7_quantityfactor | filters on the platform, writable, quantity |
The quantity factor of the product referenced in this contract order line. | |
status |
int64 |
Status | filters on the platform, writable, status |
The status of the contract order line. | |
subcontractor |
int64 |
itgen_bouw7_subcontractorcontract_id | filters on the platform, writable, subcontractor |
The ID of the contract. | |
subcontractor |
varchar2 |
itgen_bouw7_subcontractorcontract_number | filters on the platform, writable, subcontractor |
The identification number of the contract. | |
total |
varchar2 |
Total Price | filters on the platform, writable, total |
The total price of this contract order line. | |
unit |
varchar2 |
Unit | filters on the platform, writable, unit |
The unit of quantity of this contract order line. | |
unit |
varchar2 |
Unit Price | filters on the platform, writable, unit |
The unit price of this contract order line. | |
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: