invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

InvoiceTermStatements: Bouw7 Invoice Term Statements

read only REST

  • Catalogus: Bouw7
  • Schema: Project
  • Label: Invoice Term Statements

Returns a list of project invoice term statements associated with the organization. Returns a list of project invoice term statements associated with the organization.

Kan alleen gegevens ophalen.

Samenvatting

Returns a list of project invoice term statements associated with the organization.

API-bron

  • Eindpunt: /list/project-invoice-term-statements
  • Operatie: get /list/project-invoice-term-statements

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 128
Aantal rijen per minuut bij volledige scan 241,000
Aantal rijen per minuut in een Query 666

Het resultaat kan op de client in de Cache worden opgeslagen.

Parameters

Name Datatype Required Default Documentation
q `` A Heimdall Query Language string

Tabelkolommen

De kolommen van de tabel InvoiceTermStatements worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
contact_emailAddress varchar2 Contactpersoon E-mailadres filters on the platform, writable, contact.emailAddress The email address of the contact.
contact_id int64 Contactpersoon ID filters on the platform, writable, contact.id The ID of the contact.
contact_name varchar2 Contactpersoon Naam filters on the platform, writable, contact.name The name of this contact.
contact_type varchar2 Contactsoort filters on the platform, writable, contact.type The type of this contact.
contact_typeId int64 Contactsoort-ID filters on the platform, writable, contact.typeId The type ID of this contact.
createdAt datetime Aangemaakt op filters on the platform, writable, createdAt The creation date of the object in ATOM/ISO-8601 format
createdBy_id int64 Gemaakt door ID filters on the platform, writable, createdBy.id The ID of the user.
createdBy_username varchar2 Aangemaakt door Gebruikersnaam filters on the platform, writable, createdBy.username The username of the user.
fixedPrice varchar2 Vaste Prijs filters on the platform, writable, fixedPrice The fixed price for this invoice term statement.
id int64 ID filters on the platform, writable, id ID of the project invoice term.
project_branchId int64 Project Filiaal-ID filters on the platform, writable, project.branchId The ID of the branch of this project.
project_categoryId int64 Projectcategorie-ID filters on the platform, writable, project.categoryId The ID of the category of this project.
project_divisionId int64 Projectadministratie-ID filters on the platform, writable, project.divisionId The ID of the division of this project.
project_id int64 Project ID filters on the platform, writable, project.id The ID of the project.
project_name varchar2 Projectnaam filters on the platform, writable, project.name The name of the project.
project_number varchar2 Projectnummer filters on the platform, writable, project.number The number of the project.
project_status varchar2 Projectstatus filters on the platform, writable, project.status The name of the current status of this project.
project_statusId int64 Projectstatus-ID filters on the platform, writable, project.statusId The ID of the status of this project.
updatedAt datetime Bijgewerkt op filters on the platform, writable, updatedAt The creation date of the object in ATOM/ISO-8601 format
updatedBy_id int64 Bijgewerkt door ID filters on the platform, writable, updatedBy.id The ID of the user.
updatedBy_username varchar2 Bijgewerkt door Gebruikersnaam filters on the platform, writable, updatedBy.username The username of the user.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: