PurchaseInvoices: Bouw7 Purchase Invoices
popular read only REST
- Catalog:
Bouw7 - Schema:
PurchaseInvoicing - Label: Purchase Invoices
Returns a list of purchase invoices belonging to the organization. Returns a list of pruchase invoices belonging to the organization.
Can only retrieve data.
Summary
Returns a list of pruchase invoices belonging to the organization.
API Source
- Endpoint:
/list/purchase-invoices - Operation:
get /list/purchase-invoices
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 1,880 |
| Full scan rows per minute | 257,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 PurchaseInvoices 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 |
|---|---|---|---|---|---|
branch_ |
int64 |
Branch ID | filters on the platform, writable, branch. |
The ID of the branch. | |
branch_ |
varchar2 |
Branch Name | filters on the platform, writable, branch. |
The name of the branch. | |
chain |
datetime |
This field is dynamically hydrated by the 'addChainLiabilityDocumentExpirationDate'-method in the schema factory. | filters on the platform, writable, chain |
The newest expiration date of the chain liability document(s) associated with the contact, in ATOM format. | |
comment |
varchar2 |
Comment | filters on the platform, writable, comment |
A comment placed on this purchase invoice. | |
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. | |
current |
varchar2 |
This field is dynamically hydrated by the 'addCurrentApprover'-method in the schema factory. | filters on the platform, writable, current |
The full name of the current approver. | |
date |
datetime |
Date | filters on the platform, writable, date |
The entry date of this purchase invoice. | |
date |
varchar2 |
Date Paid | filters on the platform, writable, date |
The date this purchase invoice was paid. | |
delivery |
int64 |
Delivery Ticket Booking Status | filters on the platform, writable, delivery |
The current booking status. 0 = Registered, 1 = Invoiced, 2 = Not billable, 3 = Credited. | |
delivery |
datetime |
Delivery Ticket Date | filters on the platform, writable, delivery |
The date of the delivery ticket, represented in ATOM-format. | |
delivery |
varchar2 |
Delivery Ticket Description | filters on the platform, writable, delivery |
The description of this delivery ticket. May contain HTML content. | |
delivery |
int64 |
Delivery Ticket ID | filters on the platform, writable, delivery |
The ID of this delivery ticket. | |
delivery |
char |
Delivery Ticket Is Processed | filters on the platform, writable, delivery |
Whether this delivery ticket has been processed. | |
delivery |
varchar2 |
Delivery Ticket Number | filters on the platform, writable, delivery |
The ticket number of this delivery ticket. | |
delivery |
varchar2 |
Delivery Ticket Price | filters on the platform, writable, delivery |
The price of this delivery ticket. | |
delivery |
int64 |
Delivery Ticket Purchase Type ID | filters on the platform, writable, delivery |
The ID of the purchase type of this delivery ticket. | |
delivery |
varchar2 |
Delivery Ticket Purchase Type Name | filters on the platform, writable, delivery |
The name of the purchase type of this delivery ticket. | |
division_ |
varchar2 |
Division Description | filters on the platform, writable, division. |
The description of the division. | |
division_ |
varchar2 |
Division Exact Division ID | filters on the platform, writable, division. |
The division ID of an Exact Online environment. | |
division_ |
varchar2 |
Division General Ledger Account Code | filters on the platform, writable, division. |
A default general ledger account code to use for sales related items. | |
division_ |
varchar2 |
Division General Ledger Account Code Purchase | filters on the platform, writable, division. |
A default general ledger account code to use for purchase related items. | |
division_ |
int64 |
Division ID | filters on the platform, writable, division. |
The ID of the division. | |
division_ |
varchar2 |
Division Journal Code | filters on the platform, writable, division. |
A default journal code to use for sales related items. | |
division_ |
varchar2 |
Division Journal Code Purchase | filters on the platform, writable, division. |
A default journal code to use for purchase related items. | |
due |
datetime |
Due Date | filters on the platform, writable, due |
The due date of this purchase invoice. | |
entry |
int64 |
Entry Number | filters on the platform, writable, entry |
A sequential tracking number assigned to this purchase invoice. Also known as voucher number, serial number or tracking number. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of this purchase invoice. | |
invoice |
varchar2 |
Invoice Number | filters on the platform, writable, invoice |
The invoice number of this purchase invoice. | |
is |
char |
Is Booked in Exact | filters on the platform, writable, is |
Whether this purchase invoice is booked in Exact. | |
is |
char |
Is Booked in Twinfield | filters on the platform, writable, is |
Whether this purchase invoice is booked in Twinfield. | |
is |
char |
itgen_bouw7_ismutable | filters on the platform, writable, is |
Whether the purchase invoice is mutable. | |
is |
char |
Is Originating from Basecone | filters on the platform, writable, is |
Whether this purchase invoice originates from Basecone. | |
order |
varchar2 |
Order Number | filters on the platform, writable, order |
The order number associated with this purchase invoice. | |
payment |
varchar2 |
Payment Reference | filters on the platform, writable, payment |
The payment reference of this purchase invoice. | |
project_ |
int64 |
Project Branch ID | filters on the platform, writable, project. |
The ID of the branch of this project. | |
project_ |
int64 |
Project Category ID | filters on the platform, writable, project. |
The ID of the category of this project. | |
project_ |
int64 |
Project Division ID | filters on the platform, writable, project. |
The ID of the division of this project. | |
project_ |
int64 |
Project ID | filters on the platform, writable, project. |
The ID of the project. | |
project_ |
varchar2 |
Project Name | filters on the platform, writable, project. |
The name of the project. | |
project_ |
varchar2 |
Project Number | filters on the platform, writable, project. |
The number of the project. | |
project_ |
varchar2 |
Project Status | filters on the platform, writable, project. |
The name of the current status of this project. | |
project_ |
int64 |
Project Status ID | filters on the platform, writable, project. |
The ID of the status of this project. | |
status |
int64 |
Status | filters on the platform, writable, status |
The status of this purchase invoice. (0 = New, 1 = Approved, 2 = Open, 3 = Expired, 4 = Paid, 5 = Declined) | |
sub |
varchar2 |
This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | filters on the platform, writable, sub |
The sum of all purchase invoice line subtotals, excluding VAT. | |
supplier_ |
varchar2 |
Supplier Email Address | filters on the platform, writable, supplier. |
The email address of the contact. | |
supplier_ |
int64 |
Supplier ID | filters on the platform, writable, supplier. |
The ID of the contact. | |
supplier_ |
varchar2 |
Supplier Name | filters on the platform, writable, supplier. |
The name of this contact. | |
supplier_ |
varchar2 |
Supplier Type | filters on the platform, writable, supplier. |
The type of this contact. | |
supplier_ |
int64 |
Supplier Type ID | filters on the platform, writable, supplier. |
The type ID of this contact. | |
total |
varchar2 |
This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | filters on the platform, writable, total |
The sum of all purchase invoice line subtotals, including VAT. | |
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 |
This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. | filters on the platform, writable, vat |
The sum of all purchase invoice line VAT totals. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: