invantive documentation
Invantive Support ForumsLog In / Sign Up

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_id int64 Branch ID filters on the platform, writable, branch.id The ID of the branch.
branch_name varchar2 Branch Name filters on the platform, writable, branch.name The name of the branch.
chainLiabilityDocumentExpirationDate datetime This field is dynamically hydrated by the 'addChainLiabilityDocumentExpirationDate'-method in the schema factory. filters on the platform, writable, chainLiabilityDocumentExpirationDate 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.
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.
currentApprover varchar2 This field is dynamically hydrated by the 'addCurrentApprover'-method in the schema factory. filters on the platform, writable, currentApprover The full name of the current approver.
date datetime Date filters on the platform, writable, date The entry date of this purchase invoice.
datePaid varchar2 Date Paid filters on the platform, writable, datePaid The date this purchase invoice was paid.
deliveryTicket_bookingStatus int64 Delivery Ticket Booking Status filters on the platform, writable, deliveryTicket.bookingStatus The current booking status. 0 = Registered, 1 = Invoiced, 2 = Not billable, 3 = Credited.
deliveryTicket_date datetime Delivery Ticket Date filters on the platform, writable, deliveryTicket.date The date of the delivery ticket, represented in ATOM-format.
deliveryTicket_description varchar2 Delivery Ticket Description filters on the platform, writable, deliveryTicket.description The description of this delivery ticket. May contain HTML content.
deliveryTicket_id int64 Delivery Ticket ID filters on the platform, writable, deliveryTicket.id The ID of this delivery ticket.
deliveryTicket_isProcessed char Delivery Ticket Is Processed filters on the platform, writable, deliveryTicket.isProcessed Whether this delivery ticket has been processed.
deliveryTicket_number varchar2 Delivery Ticket Number filters on the platform, writable, deliveryTicket.number The ticket number of this delivery ticket.
deliveryTicket_price varchar2 Delivery Ticket Price filters on the platform, writable, deliveryTicket.price The price of this delivery ticket.
deliveryTicket_purchaseTypeId int64 Delivery Ticket Purchase Type ID filters on the platform, writable, deliveryTicket.purchaseTypeId The ID of the purchase type of this delivery ticket.
deliveryTicket_purchaseTypeName varchar2 Delivery Ticket Purchase Type Name filters on the platform, writable, deliveryTicket.purchaseTypeName The name of the purchase type of this delivery ticket.
division_description varchar2 Division Description filters on the platform, writable, division.description The description of the division.
division_exactDivisionId varchar2 Division Exact Division ID filters on the platform, writable, division.exactDivisionId The division ID of an Exact Online environment.
division_glAccountCode varchar2 Division General Ledger Account Code filters on the platform, writable, division.glAccountCode A default general ledger account code to use for sales related items.
division_glAccountCodePurchase varchar2 Division General Ledger Account Code Purchase filters on the platform, writable, division.glAccountCodePurchase A default general ledger account code to use for purchase related items.
division_id int64 Division ID filters on the platform, writable, division.id The ID of the division.
division_journalCode varchar2 Division Journal Code filters on the platform, writable, division.journalCode A default journal code to use for sales related items.
division_journalCodePurchase varchar2 Division Journal Code Purchase filters on the platform, writable, division.journalCodePurchase A default journal code to use for purchase related items.
dueDate datetime Due Date filters on the platform, writable, dueDate The due date of this purchase invoice.
entryNumber int64 Entry Number filters on the platform, writable, entryNumber 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.
invoiceNumber varchar2 Invoice Number filters on the platform, writable, invoiceNumber The invoice number of this purchase invoice.
isBookedInExact char Is Booked in Exact filters on the platform, writable, isBookedInExact Whether this purchase invoice is booked in Exact.
isBookedInTwinfield char Is Booked in Twinfield filters on the platform, writable, isBookedInTwinfield Whether this purchase invoice is booked in Twinfield.
isMutable char itgen_bouw7_ismutable filters on the platform, writable, isMutable Whether the purchase invoice is mutable.
isOriginatingFromBasecone char Is Originating from Basecone filters on the platform, writable, isOriginatingFromBasecone Whether this purchase invoice originates from Basecone.
orderNumber varchar2 Order Number filters on the platform, writable, orderNumber The order number associated with this purchase invoice.
paymentReference varchar2 Payment Reference filters on the platform, writable, paymentReference The payment reference of this purchase invoice.
project_branchId int64 Project Branch ID filters on the platform, writable, project.branchId The ID of the branch of this project.
project_categoryId int64 Project Category ID filters on the platform, writable, project.categoryId The ID of the category of this project.
project_divisionId int64 Project Division 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 Project Name filters on the platform, writable, project.name The name of the project.
project_number varchar2 Project Number filters on the platform, writable, project.number The number of the project.
project_status varchar2 Project Status filters on the platform, writable, project.status The name of the current status of this project.
project_statusId int64 Project Status ID filters on the platform, writable, project.statusId 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)
subTotal varchar2 This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. filters on the platform, writable, subTotal The sum of all purchase invoice line subtotals, excluding VAT.
supplier_emailAddress varchar2 Supplier Email Address filters on the platform, writable, supplier.emailAddress The email address of the contact.
supplier_id int64 Supplier ID filters on the platform, writable, supplier.id The ID of the contact.
supplier_name varchar2 Supplier Name filters on the platform, writable, supplier.name The name of this contact.
supplier_type varchar2 Supplier Type filters on the platform, writable, supplier.type The type of this contact.
supplier_typeId int64 Supplier Type ID filters on the platform, writable, supplier.typeId 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.
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.
vatTotal varchar2 This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. filters on the platform, writable, vatTotal 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: