PurchaseOrderContractTermDeliveryTicketsById: Bouw7 Purchase Order Contract Term Delivery Tickets by ID
read only REST
- Catalog:
Bouw7 - Schema:
Contract - Label: Purchase Order Contract Term Delivery Tickets by ID
Returns a single purchase order contract based on the given ID. Returns a single purchase order contract based on the given ID.
Can only retrieve data.
Summary
Returns a single purchase order contract based on the given ID.
API Source
- Endpoint:
/contracts/purchase-order/{id} - Operation:
get /contracts/purchase-order/{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 |
`` |
Table Columns
The columns of the table PurchaseOrderContractTermDeliveryTicketsById 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 |
|---|---|---|---|---|---|
accepted |
varchar2 |
Accepted at | filters on the platform, writable, ::ancestor. |
Datetime when contract was accepted. | |
amount |
varchar2 |
Amount | writable, ::ancestor. |
The amount of the contract term. | |
amount |
char |
Amount Only | writable, ::ancestor. |
Whether or not to show the amount only for the contract term. | |
amount |
varchar2 |
Amount Received | writable, ::ancestor. |
The received amount of the contract term. | |
amount |
varchar2 |
Amount to Receive | writable, ::ancestor. |
The amount to receive of the contract term. | |
approval_ |
char |
itgen_bouw7_approval_canapprove | filters on the platform, writable, ::ancestor. |
Whether or not the current authenticated user can approve the approval. | |
approval_ |
datetime |
itgen_bouw7_approval_createdat | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
approval_ |
varchar2 |
itgen_bouw7_approval_createdby | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
approval_ |
datetime |
itgen_bouw7_approval_currentapprover_approvaldate | filters on the platform, writable, ::ancestor. |
The date at which the approver denied/approved the approval. | |
approval_ |
int64 |
itgen_bouw7_approval_currentapprover_approvalstatus | filters on the platform, writable, ::ancestor. |
The approval status of this approver. | |
approval_ |
varchar2 |
itgen_bouw7_approval_currentapprover_comment | filters on the platform, writable, ::ancestor. |
Comment left by the approver. Can be null. | |
approval_ |
datetime |
itgen_bouw7_approval_currentapprover_createdat | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
approval_ |
varchar2 |
itgen_bouw7_approval_currentapprover_createdby | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
approval_ |
int64 |
itgen_bouw7_approval_currentapprover_id | filters on the platform, writable, ::ancestor. |
ID of the approver. | |
approval_ |
int64 |
itgen_bouw7_approval_currentapprover_index | filters on the platform, writable, ::ancestor. |
Current index of the approver. | |
approval_ |
datetime |
itgen_bouw7_approval_currentapprover_updatedat | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
approval_ |
varchar2 |
itgen_bouw7_approval_currentapprover_updatedby | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
approval_ |
int64 |
itgen_bouw7_approval_currentindex | filters on the platform, writable, ::ancestor. |
The current index of the approver which turn it is to vote on the approval. | |
approval_ |
int64 |
itgen_bouw7_approval_id | filters on the platform, writable, ::ancestor. |
ID of the approval. | |
approval_ |
char |
itgen_bouw7_approval_isapproved | filters on the platform, writable, ::ancestor. |
Whether or not the approval has been approved. | |
approval_ |
datetime |
itgen_bouw7_approval_lastactiondate | filters on the platform, writable, ::ancestor. |
Date of the last action done to this approval. Will be null when no action has been made. | |
approval_ |
datetime |
itgen_bouw7_approval_updatedat | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
approval_ |
varchar2 |
itgen_bouw7_approval_updatedby | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
approval_ |
int64 |
itgen_bouw7_approval_workflowid | filters on the platform, writable, ::ancestor. |
The workflow that this approval is based of. | |
approved |
char |
Approved | writable, ::ancestor. |
Whether or not the contract term has been approved. | |
called |
int64 |
Called Receipts | filters on the platform, writable, ::ancestor. |
The amount of called receipt documents. | |
contract |
int64 |
Contract ID | writable, ::ancestor. |
The contract id of the contract term. The value is set automatically based on the parent schema. | |
contract |
varchar2 |
Contract Number | filters on the platform, writable, ::ancestor. |
The contract number of the contract. | |
contract |
int64 |
Contract Type | writable, ::ancestor. |
The contract type of the contract term. The value is set automatically based on the parent schema. | |
cost |
varchar2 |
Cost | writable, cost |
The costs for this delivery ticket. | |
cost |
varchar2 |
Cost Received | writable, ::ancestor. |
The received cost of the contract term. | |
cost |
varchar2 |
Cost to Receive | writable, ::ancestor. |
The cost to receive of the contract term. | |
cost_2 |
varchar2 |
itgen_bouw7_cost_2 | filters on the platform, writable, ::ancestor. |
The cost of the contract. | |
create |
char |
Create Delivery Ticket | writable, ::ancestor. |
Whether or not to create a delivery ticket. | |
create |
char |
itgen_bouw7_createdeliveryticket_2 | filters on the platform, writable, ::ancestor. |
Whether or not to create a delivery ticket. | |
created |
datetime |
Created at | writable, ::ancestor. |
The creation time of the entity. | |
created |
datetime |
Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
created |
varchar2 |
Created by | writable, ::ancestor. |
The user that created the entity. | |
created |
varchar2 |
Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
delivery |
varchar2 |
Delivery Address | filters on the platform, writable, ::ancestor. |
Delivery address of the purchase order contract. | |
delivery |
datetime |
Delivery Date | filters on the platform, writable, ::ancestor. |
Delivery date of the purchase order contract. | |
delivery |
varchar2 |
Delivery Date Text | filters on the platform, writable, ::ancestor. |
Delivery date text of the purchase order contract. | |
denied |
varchar2 |
Denied at | filters on the platform, writable, ::ancestor. |
Datetime when contract was denied. | |
description |
varchar2 |
Description | writable, ::ancestor. |
The description of the contract term. | |
description_ |
varchar2 |
itgen_bouw7_description_2 | filters on the platform, writable, ::ancestor. |
The description of the contract. | |
id |
int64 |
ID | writable, id |
The ID of delivery ticket. | |
id_2 |
int64 |
ID | writable, ::ancestor. |
The ID of the contract term. | |
id_3 |
int64 |
itgen_bouw7_id_3 | filters on the platform, writable, ::ancestor. |
The ID of the purchase order contract. | |
initial |
varchar2 |
Initial Cost | writable, initial |
The initial costs for this delivery ticket. | |
internal |
varchar2 |
Internal Note | filters on the platform, writable, ::ancestor. |
Internal note about the contract. | |
language |
varchar2 |
Language | filters on the platform, writable, ::ancestor. |
The locale used by this contract, e.g.: nl-NL. | |
linked |
varchar2 |
itgen_bouw7_linkeddeliveryticket_cost | filters on the platform, writable, ::ancestor. |
The costs for this delivery ticket. | |
linked |
int64 |
Linked Delivery Ticket ID | filters on the platform, writable, ::ancestor. |
The ID of delivery ticket. | |
linked |
varchar2 |
itgen_bouw7_linkeddeliveryticket_initialcost | filters on the platform, writable, ::ancestor. |
The initial costs for this delivery ticket. | |
linked |
char |
itgen_bouw7_linkeddeliveryticket_processed | filters on the platform, writable, ::ancestor. |
Whether the delivery ticket has been processed. | |
linked |
datetime |
itgen_bouw7_linkeddeliveryticket_ticketdate | filters on the platform, writable, ::ancestor. |
The date for which the delivery ticket were logged. | |
linked |
varchar2 |
itgen_bouw7_linkeddeliveryticket_ticketnumber | filters on the platform, writable, ::ancestor. |
Ticket number of delivery ticket. | |
log |
int64 |
Log Entries | filters on the platform, writable, ::ancestor. |
The amount of log entries. | |
mail |
char |
Mail Sent | filters on the platform, writable, ::ancestor. |
Flag to indicate if mail was sent. | |
mail |
varchar2 |
Mail Sent at | filters on the platform, writable, ::ancestor. |
The date the contract was sent. | |
mail |
varchar2 |
Mail Sent by | filters on the platform, writable, ::ancestor. |
The user that sent the email. | |
name |
varchar2 |
Name | filters on the platform, writable, ::ancestor. |
The name of the contract. | |
number |
varchar2 |
Number | writable, ::ancestor. |
The number of the contract term. | |
number_ |
varchar2 |
itgen_bouw7_number_2 | filters on the platform, writable, ::ancestor. |
Number of the contract. | |
paid |
char |
Paid | writable, ::ancestor. |
Whether or not the contract term has been paid. | |
partially |
varchar2 |
Partially Amount Received | writable, ::ancestor. |
The partially received amount of the contract term. | |
partially |
varchar2 |
Partially Cost Received | writable, ::ancestor. |
The partially received cost of the contract term. | |
payment |
varchar2 |
Payment Agreement | filters on the platform, writable, ::ancestor. |
The payment agreement of the contract. | |
processed |
char |
Processed | writable, processed |
Whether the delivery ticket has been processed. | |
project |
varchar2 |
Project Security Link Code | writable, ::ancestor. |
The code of the security code. | |
project |
varchar2 |
itgen_bouw7_projectsecuritylink_code_2 | filters on the platform, writable, ::ancestor. |
The code of the security code. | |
project |
int64 |
Project Security Link ID | writable, ::ancestor. |
The unique identifier of the project security link. | |
project |
int64 |
itgen_bouw7_projectsecuritylink_id_2 | filters on the platform, writable, ::ancestor. |
The unique identifier of the project security link. | |
project |
varchar2 |
Project Security Link Name | writable, ::ancestor. |
The name of the project security link. | |
project |
varchar2 |
itgen_bouw7_projectsecuritylink_name_2 | filters on the platform, writable, ::ancestor. |
The name of the project security link. | |
project_ |
varchar2 |
itgen_bouw7_project_branch_code | filters on the platform, writable, ::ancestor. |
The code for this branch | |
project_ |
int64 |
itgen_bouw7_project_branch_id | filters on the platform, writable, ::ancestor. |
The ID of the branch. | |
project_ |
varchar2 |
itgen_bouw7_project_branch_name | filters on the platform, writable, ::ancestor. |
The name of this branch | |
project_ |
varchar2 |
itgen_bouw7_project_category_code | filters on the platform, writable, ::ancestor. |
The code for the category. | |
project_ |
datetime |
itgen_bouw7_project_category_createdat | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_createdby | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostsorprofit | filters on the platform, writable, ::ancestor. |
The general costs or profit for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_generalcostspercentage | filters on the platform, writable, ::ancestor. |
The general costs percentage for the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_grossprofitmargin | filters on the platform, writable, ::ancestor. |
The gross profit margin for the category. | |
project_ |
int64 |
itgen_bouw7_project_category_id | filters on the platform, writable, ::ancestor. |
The ID of the category. | |
project_ |
varchar2 |
itgen_bouw7_project_category_name | filters on the platform, writable, ::ancestor. |
The name of the category. | |
project_ |
datetime |
itgen_bouw7_project_category_updatedat | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
project_ |
varchar2 |
itgen_bouw7_project_category_updatedby | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
project_ |
varchar2 |
Project City | filters on the platform, writable, ::ancestor. |
The city of the project. | |
project_ |
varchar2 |
Project Contact Email | filters on the platform, writable, ::ancestor. |
The email address. | |
project_ |
int64 |
Project Contact ID | filters on the platform, writable, ::ancestor. |
ID of contact. | |
project_ |
char |
itgen_bouw7_project_contact_isvatshifted | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
project_ |
varchar2 |
Project Contact Name | filters on the platform, writable, ::ancestor. |
Name of contact. | |
project_ |
varchar2 |
itgen_bouw7_project_contact_phonenumber | filters on the platform, writable, ::ancestor. |
The phone number of the contact. | |
project_ |
datetime |
Project Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
project_ |
varchar2 |
Project Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
project_ |
datetime |
Project Delivery Date | filters on the platform, writable, ::ancestor. |
Delivery date for the project. | |
project_ |
datetime |
Project End Date | filters on the platform, writable, ::ancestor. |
End date for the project. | |
project_ |
varchar2 |
Project Full Project Number | filters on the platform, writable, ::ancestor. |
The full project number including year. | |
project_ |
varchar2 |
Project House Number | filters on the platform, writable, ::ancestor. |
The house number for the project. | |
project_ |
int64 |
Project ID | filters on the platform, writable, ::ancestor. |
The ID of the project. | |
project_ |
varchar2 |
Project Information | filters on the platform, writable, ::ancestor. |
The information of the project. | |
project_ |
varchar2 |
Project Name | filters on the platform, writable, ::ancestor. |
The name of the project. | |
project_ |
varchar2 |
Project Project Number | filters on the platform, writable, ::ancestor. |
The project number. | |
project_ |
varchar2 |
Project Reference | filters on the platform, writable, ::ancestor. |
The reference of the project. | |
project_ |
datetime |
Project Start Date | filters on the platform, writable, ::ancestor. |
Start date for the project. | |
project_ |
char |
Project Status Closes Project | filters on the platform, writable, ::ancestor. |
Whether or not this status closes a project. | |
project_ |
datetime |
Project Status Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
project_ |
varchar2 |
Project Status Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
project_ |
int64 |
Project Status ID | filters on the platform, writable, ::ancestor. |
The ID of the status. | |
project_ |
char |
Project Status Invoices Project | filters on the platform, writable, ::ancestor. |
Whether or not this status invoices a project. | |
project_ |
varchar2 |
Project Status Name | filters on the platform, writable, ::ancestor. |
The name of the status. | |
project_ |
char |
Project Status Plans Project | filters on the platform, writable, ::ancestor. |
Whether or not this status plans a project. | |
project_ |
datetime |
Project Status Updated at | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
project_ |
varchar2 |
Project Status Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
project_ |
varchar2 |
Project Street Name | filters on the platform, writable, ::ancestor. |
The street name for the project. | |
project_ |
datetime |
Project Updated at | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
project_ |
varchar2 |
Project Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
project_ |
varchar2 |
Project ZIP Code | filters on the platform, writable, ::ancestor. |
The zip code for the project. | |
purchase |
int64 |
Purchase Type | filters on the platform, writable, ::ancestor. |
The purchase type of the purchase order contract. | |
sort |
int64 |
Sort Index | writable, ::ancestor. |
The sort index of the contract term. | |
status |
int64 |
Status | filters on the platform, writable, ::ancestor. |
Status of the contract. | |
sub |
varchar2 |
Subtotal | writable, ::ancestor. |
The subtotal of the contract term. | |
supplier_ |
int64 |
Supplier Contact Type ID | filters on the platform, writable, ::ancestor. |
The ID of contact type. | |
supplier_ |
varchar2 |
Supplier Contact Type Name | filters on the platform, writable, ::ancestor. |
The name of contact type. | |
supplier_ |
varchar2 |
Supplier Email | filters on the platform, writable, ::ancestor. |
The email address. | |
supplier_ |
int64 |
Supplier ID | filters on the platform, writable, ::ancestor. |
ID of contact. | |
supplier_ |
char |
itgen_bouw7_supplier_isvatshifted | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
supplier_ |
varchar2 |
Supplier Name | filters on the platform, writable, ::ancestor. |
Name of contact. | |
supplier_ |
varchar2 |
itgen_bouw7_supplier_phonenumber | filters on the platform, writable, ::ancestor. |
The phone number of the contact. | |
ticket |
datetime |
Ticket Date | writable, ticket |
The date for which the delivery ticket were logged. | |
ticket |
varchar2 |
Ticket Number | writable, ticket |
Ticket number of delivery ticket. | |
type |
int64 |
Type | filters on the platform, writable, ::ancestor. |
Type of the contract. | |
unit |
varchar2 |
Unit | writable, ::ancestor. |
The contract term unit. | |
unit |
varchar2 |
Unit Price | writable, ::ancestor. |
The cost of the contract term. | |
updated |
datetime |
Updated At | writable, ::ancestor. |
The last updated time of the entity. | |
updated |
datetime |
Updated at | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | writable, ::ancestor. |
The user that last updated the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: