InvoiceTerms: Bouw7 Invoice Terms
Questa pagina non è ancora disponibile nella tua lingua; viene visualizzata la versione originale.
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 |
|---|---|---|---|---|---|
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. | |
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. | |
invoice |
int64 |
Invoice Line ID | filters on the platform, writable, invoice |
The ID of the invoice line. | |
invoice |
int64 |
Invoice Line Invoice ID | filters on the platform, writable, invoice |
The ID of the invoice this invoice line belongs to. | |
invoice |
int64 |
Invoice Line Invoice Status ID | filters on the platform, writable, invoice |
The ID of the status of the invoice this line belongs to. | |
invoiceable |
varchar2 |
Invoiceable at | filters on the platform, writable, invoiceable |
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_ |
int64 |
Statement Contact ID | filters on the platform, writable, statement. |
The ID of the contact associated with this project term statement. | |
statement_ |
varchar2 |
Statement Contact Name | filters on the platform, writable, statement. |
The name of the contact associated with this project term statement. | |
statement_ |
varchar2 |
Statement Fixed Price | filters on the platform, writable, statement. |
The fixed price for this project term statement. | |
statement_ |
varchar2 |
Statement Full Project Number | filters on the platform, writable, statement. |
The number of the project this project term statement belongs to. | |
statement_ |
int64 |
Statement ID | filters on the platform, writable, statement. |
ID of the project invoice term. | |
statement_ |
int64 |
Statement Project Branch ID | filters on the platform, writable, statement. |
The ID of the branch associated with the project this project term statement belongs to. | |
statement_ |
int64 |
Statement Project Category ID | filters on the platform, writable, statement. |
The ID of the category of the project this project term statement belongs to. | |
statement_ |
int64 |
Statement Project ID | filters on the platform, writable, statement. |
The ID of the project this project term statement belongs to. | |
statement_ |
varchar2 |
Statement Project Name | filters on the platform, writable, statement. |
The name of the project this project term statement belongs to. | |
statement_ |
int64 |
Statement Project Status ID | filters on the platform, writable, statement. |
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. | |
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. | |
vat |
varchar2 |
VAT Tariff Percentage | filters on the platform, writable, vat |
The vat tariff percentage that was be applied to this term. | |
vat |
int64 |
VAT Tariff ID | filters on the platform, writable, vat |
The ID of the vat tariff. | |
vat |
char |
VAT Tariff is Shifted | filters on the platform, writable, vat |
Whether the VAT is shifted. | |
vat |
varchar2 |
VAT Tariff Label | filters on the platform, writable, vat |
Display label of the VAT tariff. | |
vat |
varchar2 |
VAT Tariff Percentage | filters on the platform, writable, vat |
The VAT percentage. |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: