ProgressSheets: Bouw7 itgen_bouw7_progresssheets_plural
read only REST
- Catalog:
Bouw7 - Schema:
ProgressSheet - Label: itgen_bouw7_progresssheets_plural
Returns a list of progress sheets belonging to the organization. Returns a list of progress sheets belonging to the organization.
Can only retrieve data.
Summary
Returns a list of progress sheets belonging to the organization.
API Source
- Endpoint:
/list/progress-sheets - Operation:
get /list/progress-sheets
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 97 |
| 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 ProgressSheets 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 |
|---|---|---|---|---|---|
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. | |
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. | |
end |
datetime |
End Date | filters on the platform, writable, end |
The end date of this progress sheet. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of this progress sheet. | |
invoice |
int64 |
itgen_bouw7_invoiceid | filters on the platform, writable, invoice |
The ID of this invoice. | |
is |
char |
itgen_bouw7_isdeletable | filters on the platform, writable, is |
Whether the progress sheet is deletable. | |
is |
char |
itgen_bouw7_iseditable | filters on the platform, writable, is |
Whether the progress sheet is editable. | |
is |
char |
itgen_bouw7_isinvoiceable | filters on the platform, writable, is |
Whether the progress sheet is invoiceable. | |
mail |
varchar2 |
Mail Sent at | filters on the platform, writable, mail |
The date the contract was sent. | |
mail |
int64 |
itgen_bouw7_mailsentby_id | filters on the platform, writable, mail |
The ID of the user. | |
mail |
varchar2 |
itgen_bouw7_mailsentby_username | filters on the platform, writable, mail |
The username. The e-mail address the user uses to sign in. | |
number |
varchar2 |
Number | filters on the platform, writable, number |
The number of this progress sheet. | |
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. | |
start |
datetime |
Start Date | filters on the platform, writable, start |
The start date of this progress sheet. | |
status |
int64 |
Status | filters on the platform, writable, status |
The status of this progress sheet. | |
sub |
varchar2 |
Subtotal | filters on the platform, writable, sub |
The sub total of the progress sheet. | |
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: