invantive documentation
Invantive Support ForumsLog In / Sign Up

InvoiceTerms: Bouw7 Invoice Terms

popular read only REST

  • Catalog: Bouw7
  • Schema: Project
  • Label: Invoice Terms

Returns a list of project invoice terms associated with the organization. Returns a list of project invoice terms associated with the organization.

Can only retrieve data.

Summary

Returns a list of project invoice terms associated with the organization.

API Source

  • Endpoint: /list/project-invoice-terms
  • Operation: get /list/project-invoice-terms

Performance Characteristics

Characteristic Value
Average access latency (ms) 90
Full scan rows per minute 729,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 InvoiceTerms 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
createdAt datetime Created at filters on the platform, writable, createdAt The creation date of the object in ATOM/ISO-8601 format
createdBy_id int64 Created by ID filters on the platform, writable, createdBy.id The ID of the user.
createdBy_username varchar2 Created by User Name filters on the platform, writable, createdBy.username The username of the user.
description varchar2 Description filters on the platform, writable, description A description for the invoice term.
id int64 ID filters on the platform, writable, id ID of the project invoice term.
invoiceLine_id int64 Invoice Line ID filters on the platform, writable, invoiceLine.id The ID of the invoice line.
invoiceLine_invoiceId int64 Invoice Line Invoice ID filters on the platform, writable, invoiceLine.invoiceId The ID of the invoice this invoice line belongs to.
invoiceLine_invoiceStatusId int64 Invoice Line Invoice Status ID filters on the platform, writable, invoiceLine.invoiceStatusId The ID of the status of the invoice this line belongs to.
invoiceableAt varchar2 Invoiceable at filters on the platform, writable, invoiceableAt The date from which the term can be invoiced.
percentage varchar2 Percentage filters on the platform, writable, percentage The percentage of the total sum this invoice term covers.
statement_contactId int64 Statement Contact ID filters on the platform, writable, statement.contactId The ID of the contact associated with this project term statement.
statement_contactName varchar2 Statement Contact Name filters on the platform, writable, statement.contactName The name of the contact associated with this project term statement.
statement_fixedPrice varchar2 Statement Fixed Price filters on the platform, writable, statement.fixedPrice The fixed price for this project term statement.
statement_fullProjectNumber varchar2 Statement Full Project Number filters on the platform, writable, statement.fullProjectNumber The number of the project this project term statement belongs to.
statement_id int64 Statement ID filters on the platform, writable, statement.id ID of the project invoice term.
statement_projectBranchId int64 Statement Project Branch ID filters on the platform, writable, statement.projectBranchId The ID of the branch associated with the project this project term statement belongs to.
statement_projectCategoryId int64 Statement Project Category ID filters on the platform, writable, statement.projectCategoryId The ID of the category of the project this project term statement belongs to.
statement_projectId int64 Statement Project ID filters on the platform, writable, statement.projectId The ID of the project this project term statement belongs to.
statement_projectName varchar2 Statement Project Name filters on the platform, writable, statement.projectName The name of the project this project term statement belongs to.
statement_projectStatusId int64 Statement Project Status ID filters on the platform, writable, statement.projectStatusId The ID of the status of the project this project term statement belongs to.
subtotal varchar2 Subtotal filters on the platform, writable, subtotal The subtotal for this invoice term.
updatedAt datetime Updated At filters on the platform, writable, updatedAt The creation date of the object in ATOM/ISO-8601 format
updatedBy_id int64 Updated by ID filters on the platform, writable, updatedBy.id The ID of the user.
updatedBy_username varchar2 Updated by User Name filters on the platform, writable, updatedBy.username The username of the user.
vatTariffPercentage varchar2 VAT Tariff Percentage filters on the platform, writable, vatTariffPercentage The vat tariff percentage that was be applied to this term.
vatTariff_id int64 VAT Tariff ID filters on the platform, writable, vatTariff.id The ID of the vat tariff.
vatTariff_isShifted char VAT Tariff is Shifted filters on the platform, writable, vatTariff.isShifted Whether the VAT is shifted.
vatTariff_label varchar2(255) VAT Tariff Label filters on the platform, writable, vatTariff.label Display label of the VAT tariff.
vatTariff_percentage varchar2 VAT Tariff Percentage filters on the platform, writable, vatTariff.percentage The VAT percentage.

Release Notes

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