invantive documentation
Invantive Support ForumsLog In / Sign Up

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
acceptedAt varchar2 Accepted at filters on the platform, writable, ::ancestor.::ancestor.acceptedAt Datetime when contract was accepted.
amount varchar2 Amount writable, ::ancestor.amount The amount of the contract term.
amountOnly char Amount Only writable, ::ancestor.amountOnly Whether or not to show the amount only for the contract term.
amountReceived varchar2 Amount Received writable, ::ancestor.amountReceived The received amount of the contract term.
amountToReceive varchar2 Amount to Receive writable, ::ancestor.amountToReceive The amount to receive of the contract term.
approval_canApprove char itgen_bouw7_approval_canapprove filters on the platform, writable, ::ancestor.::ancestor.approval.canApprove Whether or not the current authenticated user can approve the approval.
approval_createdAt datetime itgen_bouw7_approval_createdat filters on the platform, writable, ::ancestor.::ancestor.approval.createdAt The creation time of the entity.
approval_createdBy varchar2 itgen_bouw7_approval_createdby filters on the platform, writable, ::ancestor.::ancestor.approval.createdBy The user that created the entity.
approval_currentApprover_approvalDate datetime itgen_bouw7_approval_currentapprover_approvaldate filters on the platform, writable, ::ancestor.::ancestor.approval.currentApprover.approvalDate The date at which the approver denied/approved the approval.
approval_currentApprover_approvalStatus int64 itgen_bouw7_approval_currentapprover_approvalstatus filters on the platform, writable, ::ancestor.::ancestor.approval.currentApprover.approvalStatus The approval status of this approver.
approval_currentApprover_comment varchar2 itgen_bouw7_approval_currentapprover_comment filters on the platform, writable, ::ancestor.::ancestor.approval.currentApprover.comment Comment left by the approver. Can be null.
approval_currentApprover_createdAt datetime itgen_bouw7_approval_currentapprover_createdat filters on the platform, writable, ::ancestor.::ancestor.approval.currentApprover.createdAt The creation time of the entity.
approval_currentApprover_createdBy varchar2 itgen_bouw7_approval_currentapprover_createdby filters on the platform, writable, ::ancestor.::ancestor.approval.currentApprover.createdBy The user that created the entity.
approval_currentApprover_id int64 itgen_bouw7_approval_currentapprover_id filters on the platform, writable, ::ancestor.::ancestor.approval.currentApprover.id ID of the approver.
approval_currentApprover_index int64 itgen_bouw7_approval_currentapprover_index filters on the platform, writable, ::ancestor.::ancestor.approval.currentApprover.index Current index of the approver.
approval_currentApprover_updatedAt datetime itgen_bouw7_approval_currentapprover_updatedat filters on the platform, writable, ::ancestor.::ancestor.approval.currentApprover.updatedAt The last updated time of the entity.
approval_currentApprover_updatedBy varchar2 itgen_bouw7_approval_currentapprover_updatedby filters on the platform, writable, ::ancestor.::ancestor.approval.currentApprover.updatedBy The user that last updated the entity.
approval_currentIndex int64 itgen_bouw7_approval_currentindex filters on the platform, writable, ::ancestor.::ancestor.approval.currentIndex The current index of the approver which turn it is to vote on the approval.
approval_id int64 itgen_bouw7_approval_id filters on the platform, writable, ::ancestor.::ancestor.approval.id ID of the approval.
approval_isApproved char itgen_bouw7_approval_isapproved filters on the platform, writable, ::ancestor.::ancestor.approval.isApproved Whether or not the approval has been approved.
approval_lastActionDate datetime itgen_bouw7_approval_lastactiondate filters on the platform, writable, ::ancestor.::ancestor.approval.lastActionDate Date of the last action done to this approval. Will be null when no action has been made.
approval_updatedAt datetime itgen_bouw7_approval_updatedat filters on the platform, writable, ::ancestor.::ancestor.approval.updatedAt The last updated time of the entity.
approval_updatedBy varchar2 itgen_bouw7_approval_updatedby filters on the platform, writable, ::ancestor.::ancestor.approval.updatedBy The user that last updated the entity.
approval_workflowId int64 itgen_bouw7_approval_workflowid filters on the platform, writable, ::ancestor.::ancestor.approval.workflowId The workflow that this approval is based of.
approved char Approved writable, ::ancestor.approved Whether or not the contract term has been approved.
calledReceipts int64 Called Receipts filters on the platform, writable, ::ancestor.::ancestor.calledReceipts The amount of called receipt documents.
contractId int64 Contract ID writable, ::ancestor.contractId The contract id of the contract term. The value is set automatically based on the parent schema.
contractNumber varchar2 Contract Number filters on the platform, writable, ::ancestor.::ancestor.contractNumber The contract number of the contract.
contractType int64 Contract Type writable, ::ancestor.contractType 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.
costReceived varchar2 Cost Received writable, ::ancestor.costReceived The received cost of the contract term.
costToReceive varchar2 Cost to Receive writable, ::ancestor.costToReceive The cost to receive of the contract term.
cost_2 varchar2 itgen_bouw7_cost_2 filters on the platform, writable, ::ancestor.::ancestor.cost The cost of the contract.
createDeliveryTicket char Create Delivery Ticket writable, ::ancestor.createDeliveryTicket Whether or not to create a delivery ticket.
createDeliveryTicket_2 char itgen_bouw7_createdeliveryticket_2 filters on the platform, writable, ::ancestor.::ancestor.createDeliveryTicket Whether or not to create a delivery ticket.
createdAt datetime Created at writable, ::ancestor.createdAt The creation time of the entity.
createdAt_2 datetime Created at filters on the platform, writable, ::ancestor.::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Created by writable, ::ancestor.createdBy The user that created the entity.
createdBy_2 varchar2 Created by filters on the platform, writable, ::ancestor.::ancestor.createdBy The user that created the entity.
deliveryAddress varchar2 Delivery Address filters on the platform, writable, ::ancestor.::ancestor.deliveryAddress Delivery address of the purchase order contract.
deliveryDate datetime Delivery Date filters on the platform, writable, ::ancestor.::ancestor.deliveryDate Delivery date of the purchase order contract.
deliveryDateText varchar2 Delivery Date Text filters on the platform, writable, ::ancestor.::ancestor.deliveryDateText Delivery date text of the purchase order contract.
deniedAt varchar2 Denied at filters on the platform, writable, ::ancestor.::ancestor.deniedAt Datetime when contract was denied.
description varchar2(255) Description writable, ::ancestor.description The description of the contract term.
description_2 varchar2 itgen_bouw7_description_2 filters on the platform, writable, ::ancestor.::ancestor.description The description of the contract.
id int64 ID writable, id The ID of delivery ticket.
id_2 int64 ID writable, ::ancestor.id The ID of the contract term.
id_3 int64 itgen_bouw7_id_3 filters on the platform, writable, ::ancestor.::ancestor.id The ID of the purchase order contract.
initialCost varchar2 Initial Cost writable, initialCost The initial costs for this delivery ticket.
internalNote varchar2 Internal Note filters on the platform, writable, ::ancestor.::ancestor.internalNote Internal note about the contract.
language varchar2 Language filters on the platform, writable, ::ancestor.::ancestor.language The locale used by this contract, e.g.: nl-NL.
linkedDeliveryTicket_cost varchar2 itgen_bouw7_linkeddeliveryticket_cost filters on the platform, writable, ::ancestor.::ancestor.linkedDeliveryTicket.cost The costs for this delivery ticket.
linkedDeliveryTicket_id int64 Linked Delivery Ticket ID filters on the platform, writable, ::ancestor.::ancestor.linkedDeliveryTicket.id The ID of delivery ticket.
linkedDeliveryTicket_initialCost varchar2 itgen_bouw7_linkeddeliveryticket_initialcost filters on the platform, writable, ::ancestor.::ancestor.linkedDeliveryTicket.initialCost The initial costs for this delivery ticket.
linkedDeliveryTicket_processed char itgen_bouw7_linkeddeliveryticket_processed filters on the platform, writable, ::ancestor.::ancestor.linkedDeliveryTicket.processed Whether the delivery ticket has been processed.
linkedDeliveryTicket_ticketDate datetime itgen_bouw7_linkeddeliveryticket_ticketdate filters on the platform, writable, ::ancestor.::ancestor.linkedDeliveryTicket.ticketDate The date for which the delivery ticket were logged.
linkedDeliveryTicket_ticketNumber varchar2 itgen_bouw7_linkeddeliveryticket_ticketnumber filters on the platform, writable, ::ancestor.::ancestor.linkedDeliveryTicket.ticketNumber Ticket number of delivery ticket.
logEntries int64 Log Entries filters on the platform, writable, ::ancestor.::ancestor.logEntries The amount of log entries.
mailSent char Mail Sent filters on the platform, writable, ::ancestor.::ancestor.mailSent Flag to indicate if mail was sent.
mailSentAt varchar2 Mail Sent at filters on the platform, writable, ::ancestor.::ancestor.mailSentAt The date the contract was sent.
mailSentBy varchar2 Mail Sent by filters on the platform, writable, ::ancestor.::ancestor.mailSentBy The user that sent the email.
name varchar2(255) Name filters on the platform, writable, ::ancestor.::ancestor.name The name of the contract.
number varchar2(255) Number writable, ::ancestor.number The number of the contract term.
number_2 varchar2 itgen_bouw7_number_2 filters on the platform, writable, ::ancestor.::ancestor.number Number of the contract.
paid char Paid writable, ::ancestor.paid Whether or not the contract term has been paid.
partiallyAmountReceived varchar2 Partially Amount Received writable, ::ancestor.partiallyAmountReceived The partially received amount of the contract term.
partiallyCostReceived varchar2 Partially Cost Received writable, ::ancestor.partiallyCostReceived The partially received cost of the contract term.
paymentAgreement varchar2 Payment Agreement filters on the platform, writable, ::ancestor.::ancestor.paymentAgreement The payment agreement of the contract.
processed char Processed writable, processed Whether the delivery ticket has been processed.
projectSecurityLink_code varchar2 Project Security Link Code writable, ::ancestor.projectSecurityLink.code The code of the security code.
projectSecurityLink_code_2 varchar2 itgen_bouw7_projectsecuritylink_code_2 filters on the platform, writable, ::ancestor.::ancestor.projectSecurityLink.code The code of the security code.
projectSecurityLink_id int64 Project Security Link ID writable, ::ancestor.projectSecurityLink.id The unique identifier of the project security link.
projectSecurityLink_id_2 int64 itgen_bouw7_projectsecuritylink_id_2 filters on the platform, writable, ::ancestor.::ancestor.projectSecurityLink.id The unique identifier of the project security link.
projectSecurityLink_name varchar2 Project Security Link Name writable, ::ancestor.projectSecurityLink.name The name of the project security link.
projectSecurityLink_name_2 varchar2 itgen_bouw7_projectsecuritylink_name_2 filters on the platform, writable, ::ancestor.::ancestor.projectSecurityLink.name The name of the project security link.
project_branch_code varchar2 itgen_bouw7_project_branch_code filters on the platform, writable, ::ancestor.::ancestor.project.branch.code The code for this branch
project_branch_id int64 itgen_bouw7_project_branch_id filters on the platform, writable, ::ancestor.::ancestor.project.branch.id The ID of the branch.
project_branch_name varchar2 itgen_bouw7_project_branch_name filters on the platform, writable, ::ancestor.::ancestor.project.branch.name The name of this branch
project_category_code varchar2 itgen_bouw7_project_category_code filters on the platform, writable, ::ancestor.::ancestor.project.category.code The code for the category.
project_category_createdAt datetime itgen_bouw7_project_category_createdat filters on the platform, writable, ::ancestor.::ancestor.project.category.createdAt The creation time of the entity.
project_category_createdBy varchar2 itgen_bouw7_project_category_createdby filters on the platform, writable, ::ancestor.::ancestor.project.category.createdBy The user that created the entity.
project_category_generalCostsOrProfit varchar2 itgen_bouw7_project_category_generalcostsorprofit filters on the platform, writable, ::ancestor.::ancestor.project.category.generalCostsOrProfit The general costs or profit for the category.
project_category_generalCostsPercentage varchar2 itgen_bouw7_project_category_generalcostspercentage filters on the platform, writable, ::ancestor.::ancestor.project.category.generalCostsPercentage The general costs percentage for the category.
project_category_grossProfitMargin varchar2 itgen_bouw7_project_category_grossprofitmargin filters on the platform, writable, ::ancestor.::ancestor.project.category.grossProfitMargin The gross profit margin for the category.
project_category_id int64 itgen_bouw7_project_category_id filters on the platform, writable, ::ancestor.::ancestor.project.category.id The ID of the category.
project_category_name varchar2 itgen_bouw7_project_category_name filters on the platform, writable, ::ancestor.::ancestor.project.category.name The name of the category.
project_category_updatedAt datetime itgen_bouw7_project_category_updatedat filters on the platform, writable, ::ancestor.::ancestor.project.category.updatedAt The last updated time of the entity.
project_category_updatedBy varchar2 itgen_bouw7_project_category_updatedby filters on the platform, writable, ::ancestor.::ancestor.project.category.updatedBy The user that last updated the entity.
project_city varchar2 Project City filters on the platform, writable, ::ancestor.::ancestor.project.city The city of the project.
project_contact_email varchar2 Project Contact Email filters on the platform, writable, ::ancestor.::ancestor.project.contact.email The email address.
project_contact_id int64 Project Contact ID filters on the platform, writable, ::ancestor.::ancestor.project.contact.id ID of contact.
project_contact_isVatShifted char itgen_bouw7_project_contact_isvatshifted filters on the platform, writable, ::ancestor.::ancestor.project.contact.isVatShifted Whether VAT is shifted for the contact.
project_contact_name varchar2 Project Contact Name filters on the platform, writable, ::ancestor.::ancestor.project.contact.name Name of contact.
project_contact_phoneNumber varchar2 itgen_bouw7_project_contact_phonenumber filters on the platform, writable, ::ancestor.::ancestor.project.contact.phoneNumber The phone number of the contact.
project_createdAt datetime Project Created at filters on the platform, writable, ::ancestor.::ancestor.project.createdAt The creation time of the entity.
project_createdBy varchar2 Project Created by filters on the platform, writable, ::ancestor.::ancestor.project.createdBy The user that created the entity.
project_deliveryDate datetime Project Delivery Date filters on the platform, writable, ::ancestor.::ancestor.project.deliveryDate Delivery date for the project.
project_endDate datetime Project End Date filters on the platform, writable, ::ancestor.::ancestor.project.endDate End date for the project.
project_fullProjectNumber varchar2 Project Full Project Number filters on the platform, writable, ::ancestor.::ancestor.project.fullProjectNumber The full project number including year.
project_houseNumber varchar2 Project House Number filters on the platform, writable, ::ancestor.::ancestor.project.houseNumber The house number for the project.
project_id int64 Project ID filters on the platform, writable, ::ancestor.::ancestor.project.id The ID of the project.
project_information varchar2 Project Information filters on the platform, writable, ::ancestor.::ancestor.project.information The information of the project.
project_name varchar2 Project Name filters on the platform, writable, ::ancestor.::ancestor.project.name The name of the project.
project_projectNumber varchar2 Project Project Number filters on the platform, writable, ::ancestor.::ancestor.project.projectNumber The project number.
project_reference varchar2 Project Reference filters on the platform, writable, ::ancestor.::ancestor.project.reference The reference of the project.
project_startDate datetime Project Start Date filters on the platform, writable, ::ancestor.::ancestor.project.startDate Start date for the project.
project_status_closesProject char Project Status Closes Project filters on the platform, writable, ::ancestor.::ancestor.project.status.closesProject Whether or not this status closes a project.
project_status_createdAt datetime Project Status Created at filters on the platform, writable, ::ancestor.::ancestor.project.status.createdAt The creation time of the entity.
project_status_createdBy varchar2 Project Status Created by filters on the platform, writable, ::ancestor.::ancestor.project.status.createdBy The user that created the entity.
project_status_id int64 Project Status ID filters on the platform, writable, ::ancestor.::ancestor.project.status.id The ID of the status.
project_status_invoicesProject char Project Status Invoices Project filters on the platform, writable, ::ancestor.::ancestor.project.status.invoicesProject Whether or not this status invoices a project.
project_status_name varchar2 Project Status Name filters on the platform, writable, ::ancestor.::ancestor.project.status.name The name of the status.
project_status_plansProject char Project Status Plans Project filters on the platform, writable, ::ancestor.::ancestor.project.status.plansProject Whether or not this status plans a project.
project_status_updatedAt datetime Project Status Updated at filters on the platform, writable, ::ancestor.::ancestor.project.status.updatedAt The last updated time of the entity.
project_status_updatedBy varchar2 Project Status Updated by filters on the platform, writable, ::ancestor.::ancestor.project.status.updatedBy The user that last updated the entity.
project_streetName varchar2 Project Street Name filters on the platform, writable, ::ancestor.::ancestor.project.streetName The street name for the project.
project_updatedAt datetime Project Updated at filters on the platform, writable, ::ancestor.::ancestor.project.updatedAt The last updated time of the entity.
project_updatedBy varchar2 Project Updated by filters on the platform, writable, ::ancestor.::ancestor.project.updatedBy The user that last updated the entity.
project_zipCode varchar2 Project ZIP Code filters on the platform, writable, ::ancestor.::ancestor.project.zipCode The zip code for the project.
purchaseType int64 Purchase Type filters on the platform, writable, ::ancestor.::ancestor.purchaseType The purchase type of the purchase order contract.
sortIndex int64 Sort Index writable, ::ancestor.sortIndex The sort index of the contract term.
status int64 Status filters on the platform, writable, ::ancestor.::ancestor.status Status of the contract.
subTotal varchar2 Subtotal writable, ::ancestor.subTotal The subtotal of the contract term.
supplier_contactType_id int64 Supplier Contact Type ID filters on the platform, writable, ::ancestor.::ancestor.supplier.contactType.id The ID of contact type.
supplier_contactType_name varchar2 Supplier Contact Type Name filters on the platform, writable, ::ancestor.::ancestor.supplier.contactType.name The name of contact type.
supplier_email varchar2 Supplier Email filters on the platform, writable, ::ancestor.::ancestor.supplier.email The email address.
supplier_id int64 Supplier ID filters on the platform, writable, ::ancestor.::ancestor.supplier.id ID of contact.
supplier_isVatShifted char itgen_bouw7_supplier_isvatshifted filters on the platform, writable, ::ancestor.::ancestor.supplier.isVatShifted Whether VAT is shifted for the contact.
supplier_name varchar2 Supplier Name filters on the platform, writable, ::ancestor.::ancestor.supplier.name Name of contact.
supplier_phoneNumber varchar2 itgen_bouw7_supplier_phonenumber filters on the platform, writable, ::ancestor.::ancestor.supplier.phoneNumber The phone number of the contact.
ticketDate datetime Ticket Date writable, ticketDate The date for which the delivery ticket were logged.
ticketNumber varchar2 Ticket Number writable, ticketNumber Ticket number of delivery ticket.
type int64 Type filters on the platform, writable, ::ancestor.::ancestor.type Type of the contract.
unit varchar2(255) Unit writable, ::ancestor.unit The contract term unit.
unitPrice varchar2 Unit Price writable, ::ancestor.unitPrice The cost of the contract term.
updatedAt datetime Updated At writable, ::ancestor.updatedAt The last updated time of the entity.
updatedAt_2 datetime Updated at filters on the platform, writable, ::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by writable, ::ancestor.updatedBy The user that last updated the entity.
updatedBy_2 varchar2 Updated by filters on the platform, writable, ::ancestor.::ancestor.updatedBy The user that last updated the entity.

Release Notes

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