invantive documentation
Invantive Support ForumsLog In / Sign Up

PurchaseInvoice_ProjectCategoryDivisionSettings: Bouw7 itgen_bouw7_purchaseinvoice_projectcategorydivisionsettings_plural

read only REST

  • Catalog: Bouw7
  • Schema: PurchaseInvoicing
  • Label: itgen_bouw7_purchaseinvoice_projectcategorydivisionsettings_plural

Returns a single purchase invoice based on the given ID. Returns a single purchase invoice based on the given ID.

Can only retrieve data.

Summary

Returns a single purchase invoice based on the given ID.

API Source

  • Endpoint: /purchase-invoicing/purchase-invoice/{id}
  • Operation: get /purchase-invoicing/purchase-invoice/{id}

Performance Characteristics

Characteristic Value
Average access latency (ms) 90
Full scan rows per minute 241,000
Point query rows per minute 666

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
id ``

Table Columns

The columns of the table PurchaseInvoice_ProjectCategoryDivisionSettings 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
approval_canApprove char itgen_bouw7_approval_canapprove filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.canApprove Whether or not the current authenticated user can approve the approval.
approval_createdAt datetime itgen_bouw7_approval_createdat filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.createdAt The creation time of the entity.
approval_createdBy varchar2 itgen_bouw7_approval_createdby filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.createdBy The user that created the entity.
approval_currentApprover_approvalDate datetime itgen_bouw7_approval_currentapprover_approvaldate filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.currentApprover.approvalDate The date at which the approver denied/approved the approval.
approval_currentApprover_approvalStatus int64 itgen_bouw7_approval_currentapprover_approvalstatus filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.currentApprover.approvalStatus The approval status of this approver.
approval_currentApprover_comment varchar2 itgen_bouw7_approval_currentapprover_comment filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.currentApprover.comment Comment left by the approver. Can be null.
approval_currentApprover_createdAt datetime itgen_bouw7_approval_currentapprover_createdat filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.currentApprover.createdAt The creation time of the entity.
approval_currentApprover_createdBy varchar2 itgen_bouw7_approval_currentapprover_createdby filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.currentApprover.createdBy The user that created the entity.
approval_currentApprover_id int64 itgen_bouw7_approval_currentapprover_id filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.currentApprover.id ID of the approver.
approval_currentApprover_index int64 itgen_bouw7_approval_currentapprover_index filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.currentApprover.index Current index of the approver.
approval_currentApprover_updatedAt datetime itgen_bouw7_approval_currentapprover_updatedat filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.currentApprover.updatedAt The last updated time of the entity.
approval_currentApprover_updatedBy varchar2 itgen_bouw7_approval_currentapprover_updatedby filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.currentApprover.updatedBy The user that last updated the entity.
approval_currentIndex int64 itgen_bouw7_approval_currentindex filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.currentIndex The current index of the approver which turn it is to vote on the approval.
approval_id int64 itgen_bouw7_approval_id filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.id ID of the approval.
approval_isApproved char itgen_bouw7_approval_isapproved filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.isApproved Whether or not the approval has been approved.
approval_lastActionDate datetime itgen_bouw7_approval_lastactiondate filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.lastActionDate Date of the last action done to this approval. Will be null when no action has been made.
approval_updatedAt datetime itgen_bouw7_approval_updatedat filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.updatedAt The last updated time of the entity.
approval_updatedBy varchar2 itgen_bouw7_approval_updatedby filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.updatedBy The user that last updated the entity.
approval_workflowId int64 itgen_bouw7_approval_workflowid filters on the platform, writable, ::ancestor.::ancestor.::ancestor.approval.workflowId The workflow that this approval is based of.
bookNumber int64 Book Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.bookNumber The booknumber of the purchase invoice.
branch_code varchar2 Branch Code writable, ::ancestor.::ancestor.branch.code The code for this branch
branch_code_2 varchar2 itgen_bouw7_branch_code_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.code The code for this branch
branch_division_description varchar2 itgen_bouw7_branch_division_description filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.division.description The description of the division.
branch_division_exactDivisionId varchar2 itgen_bouw7_branch_division_exactdivisionid filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.division.exactDivisionId The division ID of an Exact Online environment.
branch_division_glAccountCode varchar2 itgen_bouw7_branch_division_glaccountcode filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.division.glAccountCode A default general ledger account code to use for sales related items.
branch_division_glAccountCodePurchase varchar2 itgen_bouw7_branch_division_glaccountcodepurchase filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.division.glAccountCodePurchase A default general ledger account code to use for purchase related items.
branch_division_id int64 itgen_bouw7_branch_division_id filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.division.id The ID of the division.
branch_division_journalCode varchar2 itgen_bouw7_branch_division_journalcode filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.division.journalCode A default journal code to use for sales related items.
branch_division_journalCodePurchase varchar2 itgen_bouw7_branch_division_journalcodepurchase filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.division.journalCodePurchase A default journal code to use for purchase related items.
branch_division_salesInvoiceNumberPrefix varchar2(3) itgen_bouw7_branch_division_salesinvoicenumberprefix filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.division.salesInvoiceNumberPrefix The prefix (3 digits) used to generate invoice number range per division.
branch_id int64 Branch ID writable, ::ancestor.::ancestor.branch.id The ID of the branch.
branch_id_2 int64 itgen_bouw7_branch_id_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.id The ID of the branch.
branch_name varchar2 Branch Name writable, ::ancestor.::ancestor.branch.name The name of this branch
branch_name_2 varchar2 itgen_bouw7_branch_name_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.name The name of this branch
canBeDeleted char Can Be Deleted filters on the platform, writable, ::ancestor.::ancestor.::ancestor.canBeDeleted Whether the invoice can be deleted.
canBookToExact char Can Book to Exact filters on the platform, writable, ::ancestor.::ancestor.::ancestor.canBookToExact Whether it is allowed to book to Exact.
canBookToTwinfield char Can Book to Twinfield filters on the platform, writable, ::ancestor.::ancestor.::ancestor.canBookToTwinfield Whether it is allowed to book to Twinfield.
canUseCostCenter char Can Use Cost Centre filters on the platform, writable, ::ancestor.::ancestor.::ancestor.canUseCostCenter True if the user can use cost center functionality.
chainLiabilityDocumentExpirationDate datetime Chain Liability Document Expiration Date filters on the platform, writable, ::ancestor.::ancestor.::ancestor.chainLiabilityDocumentExpirationDate The newest expiration date of the chain liability document(s) associated with the contact, in ATOM format.
city varchar2 City writable, ::ancestor.::ancestor.city The city of the project.
code varchar2 Code writable, ::ancestor.code The code for the category.
comments varchar2 Comments filters on the platform, writable, ::ancestor.::ancestor.::ancestor.comments Comment associated with the purchase invoice.
contact_contactType_id int64 Contact Contact Type ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.contactType.id The ID of contact type.
contact_contactType_name varchar2 Contact Contact Type Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.contactType.name The name of contact type.
contact_email varchar2 Contact Email writable, ::ancestor.::ancestor.contact.email The email address.
contact_email_2 varchar2 itgen_bouw7_contact_email_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.email The email address.
contact_id int64 Contact ID writable, ::ancestor.::ancestor.contact.id ID of contact.
contact_id_2 int64 itgen_bouw7_contact_id_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.id ID of contact.
contact_isVatShifted char Contact Is VAT Shifted writable, ::ancestor.::ancestor.contact.isVatShifted Whether VAT is shifted for the contact.
contact_isVatShifted_2 char itgen_bouw7_contact_isvatshifted_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.isVatShifted Whether VAT is shifted for the contact.
contact_name varchar2 Contact Name writable, ::ancestor.::ancestor.contact.name Name of contact.
contact_name_2 varchar2 itgen_bouw7_contact_name_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.name Name of contact.
contact_phoneNumber varchar2 Contact Phone Number writable, ::ancestor.::ancestor.contact.phoneNumber The phone number of the contact.
contact_phoneNumber_2 varchar2 itgen_bouw7_contact_phonenumber_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.phoneNumber The phone number of the contact.
createDeliveryTicket char Create Delivery Ticket filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createDeliveryTicket Whether or not to create a delivery ticket.
createDeliveryTicketForRemainingCosts char Create Delivery Ticket for Remaining Costs filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createDeliveryTicketForRemainingCosts Whether or not to create a delivery ticket for the remaining costs.
createdAt datetime Created at writable, ::ancestor.createdAt The creation time of the entity.
createdAt_2 datetime Created at writable, ::ancestor.::ancestor.createdAt The creation time of the entity.
createdAt_3 datetime itgen_bouw7_createdat_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Created by writable, ::ancestor.createdBy The user that created the entity.
createdBy_2 varchar2 Created by writable, ::ancestor.::ancestor.createdBy The user that created the entity.
createdBy_3 varchar2 itgen_bouw7_createdby_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createdBy The user that created the entity.
date datetime Date filters on the platform, writable, ::ancestor.::ancestor.::ancestor.date Purchase invoice date.
datePaid varchar2 Date Paid filters on the platform, writable, ::ancestor.::ancestor.::ancestor.datePaid Purchase invoice paid date.
deliveryDate datetime Delivery Date writable, ::ancestor.::ancestor.deliveryDate Delivery date for the project.
deliveryTicket_cost varchar2 Delivery Ticket Cost filters on the platform, writable, ::ancestor.::ancestor.::ancestor.deliveryTicket.cost The costs for this delivery ticket.
deliveryTicket_id int64 Delivery Ticket ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.deliveryTicket.id The ID of delivery ticket.
deliveryTicket_initialCost varchar2 Delivery Ticket Initial Cost filters on the platform, writable, ::ancestor.::ancestor.::ancestor.deliveryTicket.initialCost The initial costs for this delivery ticket.
deliveryTicket_processed char Delivery Ticket Processed filters on the platform, writable, ::ancestor.::ancestor.::ancestor.deliveryTicket.processed Whether the delivery ticket has been processed.
deliveryTicket_ticketDate datetime Delivery Ticket Ticket Date filters on the platform, writable, ::ancestor.::ancestor.::ancestor.deliveryTicket.ticketDate The date for which the delivery ticket were logged.
deliveryTicket_ticketNumber varchar2 Delivery Ticket Ticket Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.deliveryTicket.ticketNumber Ticket number of delivery ticket.
division_description varchar2 Division Description filters on the platform, writable, ::ancestor.::ancestor.::ancestor.division.description The description of the division.
division_exactDivisionId varchar2 Division Exact Division ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.division.exactDivisionId The division ID of an Exact Online environment.
division_glAccountCode varchar2 Division General Ledger Account Code filters on the platform, writable, ::ancestor.::ancestor.::ancestor.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, ::ancestor.::ancestor.::ancestor.division.glAccountCodePurchase A default general ledger account code to use for purchase related items.
division_id int64 Division ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.division.id The ID of the division.
division_journalCode varchar2 Division Journal Code filters on the platform, writable, ::ancestor.::ancestor.::ancestor.division.journalCode A default journal code to use for sales related items.
division_journalCodePurchase varchar2 Division Journal Code Purchase filters on the platform, writable, ::ancestor.::ancestor.::ancestor.division.journalCodePurchase A default journal code to use for purchase related items.
division_salesInvoiceNumberPrefix varchar2(3) Division Sales Invoice Number Prefix filters on the platform, writable, ::ancestor.::ancestor.::ancestor.division.salesInvoiceNumberPrefix The prefix (3 digits) used to generate invoice number range per division.
dueDate datetime Due Date filters on the platform, writable, ::ancestor.::ancestor.::ancestor.dueDate Purchase invoice due date.
endDate datetime End Date writable, ::ancestor.::ancestor.endDate End date for the project.
exactFinancialPeriod_endDate datetime itgen_bouw7_exactfinancialperiod_enddate filters on the platform, writable, ::ancestor.::ancestor.::ancestor.exactFinancialPeriod.endDate The end date of the exact financial period in Y-m-d format.
exactFinancialPeriod_financialPeriod int64 itgen_bouw7_exactfinancialperiod_financialperiod filters on the platform, writable, ::ancestor.::ancestor.::ancestor.exactFinancialPeriod.financialPeriod The period of the exact financial period.
exactFinancialPeriod_financialYear int64 itgen_bouw7_exactfinancialperiod_financialyear filters on the platform, writable, ::ancestor.::ancestor.::ancestor.exactFinancialPeriod.financialYear The year of the exact financial period.
exactFinancialPeriod_id int64 itgen_bouw7_exactfinancialperiod_id filters on the platform, writable, ::ancestor.::ancestor.::ancestor.exactFinancialPeriod.id The ID of the exact financial period.
exactFinancialPeriod_startDate datetime itgen_bouw7_exactfinancialperiod_startdate filters on the platform, writable, ::ancestor.::ancestor.::ancestor.exactFinancialPeriod.startDate The start date of the exact financial period in Y-m-d format.
exactPaymentCondition varchar2(255) Exact Payment Condition filters on the platform, writable, ::ancestor.::ancestor.::ancestor.exactPaymentCondition The code of the Exact Online payment condition for this purchase invoice.
file_createdAt datetime File Created at filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.createdAt The creation time of the entity.
file_createdBy varchar2 File Created by filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.createdBy The user that created the entity.
file_extension varchar2 File Extension filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.extension The extension of the file.
file_id int64 File ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.id The ID of this file
file_modelId int64 File Model ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.modelId The ID of the associated type.
file_modelType varchar2 File Model Type filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.modelType The category of the file.
file_name varchar2 File Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.name The public name of the file.
file_secureHash varchar2 itgen_bouw7_file_securehash filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.secureHash A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication.
file_size int64 File Size filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.size The size of the file in bytes.
file_updatedAt datetime File Updated at filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.updatedAt The last updated time of the entity.
file_updatedBy varchar2 File Updated by filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.updatedBy The user that last updated the entity.
file_uri varchar2 File URI filters on the platform, writable, ::ancestor.::ancestor.::ancestor.file.uri The URI of the file, used to fetch the contents.
fromBasecone char From Basecone filters on the platform, writable, ::ancestor.::ancestor.::ancestor.fromBasecone Whether the invoice is imported from Basecone.
fullProjectNumber varchar2 Full Project Number writable, ::ancestor.::ancestor.fullProjectNumber The full project number including year.
gAccountAmount varchar2 G-Account Amount filters on the platform, writable, ::ancestor.::ancestor.::ancestor.gAccountAmount The g account amount of the purchase invoice.
generalCostsOrProfit varchar2 General Costs or Profit writable, ::ancestor.generalCostsOrProfit The general costs or profit for the category.
generalCostsPercentage varchar2 General Costs Percentage writable, ::ancestor.generalCostsPercentage The general costs percentage for the category.
grossProfitMargin varchar2 Gross Profit Margin writable, ::ancestor.grossProfitMargin The gross profit margin for the category.
houseNumber varchar2 House Number writable, ::ancestor.::ancestor.houseNumber The house number for the project.
id int64 ID writable, ::ancestor.id The ID of the category.
id_2 int64 ID writable, ::ancestor.::ancestor.id The ID of the project.
id_3 int64 itgen_bouw7_id_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.id The ID of purchase invoice.
information varchar2 Information writable, ::ancestor.::ancestor.information The information of the project.
invoiceNumber varchar2 Invoice Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceNumber The invoice number of purchase invoice.
isBooked char Is Booked filters on the platform, writable, ::ancestor.::ancestor.::ancestor.isBooked Whether the invoice is already booked.
isMutable char itgen_bouw7_ismutable filters on the platform, writable, ::ancestor.::ancestor.::ancestor.isMutable Whether the purchase invoice is mutable.
name varchar2 Name writable, ::ancestor.name The name of the category.
name_2 varchar2 itgen_bouw7_name_2 writable, ::ancestor.::ancestor.name The name of the project.
nextPurchaseInvoiceId int64 Next Purchase Invoice ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.nextPurchaseInvoiceId The ID of the next purchase invoice starting from this purchase invoice. Null when no next purchase invoice available.
orderNumber varchar2 Order Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.orderNumber The order number of the purchase invoice.
paymentReference varchar2 Payment Reference filters on the platform, writable, ::ancestor.::ancestor.::ancestor.paymentReference The payment reference of the purchase invoice.
previousPurchaseInvoiceId int64 Previous Purchase Invoice ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.previousPurchaseInvoiceId The ID of the previous purchase invoice starting from this purchase invoice. Null when no previous purchase invoice available.
projectNumber varchar2 Project Number writable, ::ancestor.::ancestor.projectNumber The project number.
reference varchar2 Reference writable, ::ancestor.::ancestor.reference The reference of the project.
startDate datetime Start Date writable, ::ancestor.::ancestor.startDate Start date for the project.
status int64 Status filters on the platform, writable, ::ancestor.::ancestor.::ancestor.status Status of the purchase invoice.
status_closesProject char Status Closes Project writable, ::ancestor.::ancestor.status.closesProject Whether or not this status closes a project.
status_createdAt datetime Status Created at writable, ::ancestor.::ancestor.status.createdAt The creation time of the entity.
status_createdBy varchar2 Status Created by writable, ::ancestor.::ancestor.status.createdBy The user that created the entity.
status_id int64 Status ID writable, ::ancestor.::ancestor.status.id The ID of the status.
status_invoicesProject char Status Invoices Project writable, ::ancestor.::ancestor.status.invoicesProject Whether or not this status invoices a project.
status_name varchar2 Status Name writable, ::ancestor.::ancestor.status.name The name of the status.
status_plansProject char Status Plans Project writable, ::ancestor.::ancestor.status.plansProject Whether or not this status plans a project.
status_updatedAt datetime Status Updated at writable, ::ancestor.::ancestor.status.updatedAt The last updated time of the entity.
status_updatedBy varchar2 Status Updated by writable, ::ancestor.::ancestor.status.updatedBy The user that last updated the entity.
streetName varchar2 Street Name writable, ::ancestor.::ancestor.streetName The street name for the project.
updatedAt datetime Updated At writable, ::ancestor.updatedAt The last updated time of the entity.
updatedAt_2 datetime Updated at writable, ::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedAt_3 datetime itgen_bouw7_updatedat_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by writable, ::ancestor.updatedBy The user that last updated the entity.
updatedBy_2 varchar2 Updated by writable, ::ancestor.::ancestor.updatedBy The user that last updated the entity.
updatedBy_3 varchar2 itgen_bouw7_updatedby_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.updatedBy The user that last updated the entity.
zipCode varchar2 ZIP Code writable, ::ancestor.::ancestor.zipCode The zip code for the project.

Release Notes

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