invantive documentation
Invantive Support ForumsLog In / Sign Up

PurchaseInvoiceLines: Bouw7 Purchase Invoice Lines

read only

  • Catalog: Bouw7
  • Schema: Views
  • Label: Purchase Invoice Lines

Can only retrieve data.

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.

Table Columns

The columns of the table PurchaseInvoiceLines 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 Whether or not the current authenticated user can approve the approval.
approval_createdAt datetime itgen_bouw7_approval_createdat filters on the platform, writable The creation time of the entity.
approval_createdBy varchar2 itgen_bouw7_approval_createdby filters on the platform, writable The user that created the entity.
approval_currentApprover_approvalDate datetime itgen_bouw7_approval_currentapprover_approvaldate filters on the platform, writable The date at which the approver denied/approved the approval.
approval_currentApprover_approvalStatus int64 itgen_bouw7_approval_currentapprover_approvalstatus filters on the platform, writable The approval status of this approver.
approval_currentApprover_comment varchar2 itgen_bouw7_approval_currentapprover_comment filters on the platform, writable Comment left by the approver. Can be null.
approval_currentApprover_createdAt datetime itgen_bouw7_approval_currentapprover_createdat filters on the platform, writable The creation time of the entity.
approval_currentApprover_createdBy varchar2 itgen_bouw7_approval_currentapprover_createdby filters on the platform, writable The user that created the entity.
approval_currentApprover_id int64 itgen_bouw7_approval_currentapprover_id filters on the platform, writable ID of the approver.
approval_currentApprover_index int64 itgen_bouw7_approval_currentapprover_index filters on the platform, writable Current index of the approver.
approval_currentApprover_updatedAt datetime itgen_bouw7_approval_currentapprover_updatedat filters on the platform, writable The last updated time of the entity.
approval_currentApprover_updatedBy varchar2 itgen_bouw7_approval_currentapprover_updatedby filters on the platform, writable The user that last updated the entity.
approval_currentIndex int64 itgen_bouw7_approval_currentindex filters on the platform, writable 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 ID of the approval.
approval_isApproved char itgen_bouw7_approval_isapproved filters on the platform, writable Whether or not the approval has been approved.
approval_lastActionDate datetime itgen_bouw7_approval_lastactiondate filters on the platform, writable 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 The last updated time of the entity.
approval_updatedBy varchar2 itgen_bouw7_approval_updatedby filters on the platform, writable The user that last updated the entity.
approval_workflowId int64 itgen_bouw7_approval_workflowid filters on the platform, writable The workflow that this approval is based of.
bookNumber int64 Book Number filters on the platform, writable The booknumber of the purchase invoice.
branch_code varchar2 Branch Code filters on the platform, writable The code for this branch
branch_division_description varchar2 itgen_bouw7_branch_division_description filters on the platform, writable The description of the division.
branch_division_exactDivisionId varchar2 itgen_bouw7_branch_division_exactdivisionid filters on the platform, writable The division ID of an Exact Online environment.
branch_division_glAccountCode varchar2 itgen_bouw7_branch_division_glaccountcode filters on the platform, writable 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 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 The ID of the division.
branch_division_journalCode varchar2 itgen_bouw7_branch_division_journalcode filters on the platform, writable A default journal code to use for sales related items.
branch_division_journalCodePurchase varchar2 itgen_bouw7_branch_division_journalcodepurchase filters on the platform, writable 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 The prefix (3 digits) used to generate invoice number range per division.
branch_id int64 Branch ID filters on the platform, writable The ID of the branch.
branch_name varchar2 Branch Name filters on the platform, writable The name of this branch
canBeDeleted char Can Be Deleted filters on the platform, writable Whether the invoice can be deleted.
canBeEdited char Can Be Edited writable Whether the line can be edited or removed.
canBookToExact char Can Book to Exact filters on the platform, writable Whether it is allowed to book to Exact.
canBookToTwinfield char Can Book to Twinfield filters on the platform, writable Whether it is allowed to book to Twinfield.
canUseCostCenter char Can Use Cost Centre filters on the platform, writable True if the user can use cost center functionality.
chainLiabilityDocumentExpirationDate datetime Chain Liability Document Expiration Date filters on the platform, writable The newest expiration date of the chain liability document(s) associated with the contact, in ATOM format.
comments varchar2 Comments filters on the platform, writable Comment associated with the purchase invoice.
contact_contactType_id int64 Contact Contact Type ID filters on the platform, writable The ID of contact type.
contact_contactType_name varchar2 Contact Contact Type Name filters on the platform, writable The name of contact type.
contact_email varchar2 Contact Email filters on the platform, writable The email address.
contact_id int64 Contact ID filters on the platform, writable ID of contact.
contact_isVatShifted char Contact Is VAT Shifted filters on the platform, writable Whether VAT is shifted for the contact.
contact_name varchar2 Contact Name filters on the platform, writable Name of contact.
contact_phoneNumber varchar2 Contact Phone Number filters on the platform, writable The phone number of the contact.
costCenter varchar2 Cost Centre writable A reference to the cost center associated with the invoice line.
createDeliveryTicket char Create Delivery Ticket filters on the platform, writable Whether or not to create a delivery ticket.
createDeliveryTicketForRemainingCosts char Create Delivery Ticket for Remaining Costs writable Whether or not to create a delivery ticket for remaining costs between this line and the delivery ticket
createDeliveryTicketForRemainingCosts_2 char itgen_bouw7_createdeliveryticketforremainingcosts_2 filters on the platform, writable Whether or not to create a delivery ticket for the remaining costs.
createdAt datetime Created at writable The creation time of the entity.
createdAt_2 datetime Created at filters on the platform, writable The creation time of the entity.
createdBy varchar2 Created by writable The user that created the entity.
createdBy_2 varchar2 Created by filters on the platform, writable The user that created the entity.
date datetime Date filters on the platform, writable Purchase invoice date.
datePaid varchar2 Date Paid filters on the platform, writable Purchase invoice paid date.
deliveryTicket_cost varchar2 Delivery Ticket Cost writable The costs for this delivery ticket.
deliveryTicket_cost_2 varchar2 itgen_bouw7_deliveryticket_cost_2 filters on the platform, writable The costs for this delivery ticket.
deliveryTicket_id int64 Delivery Ticket ID writable The ID of delivery ticket.
deliveryTicket_id_2 int64 itgen_bouw7_deliveryticket_id_2 filters on the platform, writable The ID of delivery ticket.
deliveryTicket_initialCost varchar2 Delivery Ticket Initial Cost writable The initial costs for this delivery ticket.
deliveryTicket_initialCost_2 varchar2 itgen_bouw7_deliveryticket_initialcost_2 filters on the platform, writable The initial costs for this delivery ticket.
deliveryTicket_processed char Delivery Ticket Processed writable Whether the delivery ticket has been processed.
deliveryTicket_processed_2 char itgen_bouw7_deliveryticket_processed_2 filters on the platform, writable Whether the delivery ticket has been processed.
deliveryTicket_ticketDate datetime Delivery Ticket Ticket Date writable The date for which the delivery ticket were logged.
deliveryTicket_ticketDate_2 datetime itgen_bouw7_deliveryticket_ticketdate_2 filters on the platform, writable The date for which the delivery ticket were logged.
deliveryTicket_ticketNumber varchar2 Delivery Ticket Ticket Number writable Ticket number of delivery ticket.
deliveryTicket_ticketNumber_2 varchar2 itgen_bouw7_deliveryticket_ticketnumber_2 filters on the platform, writable Ticket number of delivery ticket.
description varchar2(255) Description writable The description of the purchase invoice line.
division_description varchar2 Division Description filters on the platform, writable The description of the division.
division_exactDivisionId varchar2 Division Exact Division ID filters on the platform, writable The division ID of an Exact Online environment.
division_glAccountCode varchar2 Division General Ledger Account Code filters on the platform, writable 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 A default general ledger account code to use for purchase related items.
division_id int64 Division ID filters on the platform, writable The ID of the division.
division_journalCode varchar2 Division Journal Code filters on the platform, writable A default journal code to use for sales related items.
division_journalCodePurchase varchar2 Division Journal Code Purchase filters on the platform, writable A default journal code to use for purchase related items.
division_salesInvoiceNumberPrefix varchar2(3) Division Sales Invoice Number Prefix filters on the platform, writable The prefix (3 digits) used to generate invoice number range per division.
dueDate datetime Due Date filters on the platform, writable Purchase invoice due date.
exactFinancialPeriod_endDate datetime itgen_bouw7_exactfinancialperiod_enddate filters on the platform, writable 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 The period of the exact financial period.
exactFinancialPeriod_financialYear int64 itgen_bouw7_exactfinancialperiod_financialyear filters on the platform, writable The year of the exact financial period.
exactFinancialPeriod_id int64 itgen_bouw7_exactfinancialperiod_id filters on the platform, writable The ID of the exact financial period.
exactFinancialPeriod_startDate datetime itgen_bouw7_exactfinancialperiod_startdate filters on the platform, writable The start date of the exact financial period in Y-m-d format.
exactPaymentCondition varchar2(255) Exact Payment Condition filters on the platform, writable The code of the Exact Online payment condition for this purchase invoice.
file_createdAt datetime File Created at filters on the platform, writable The creation time of the entity.
file_createdBy varchar2 File Created by filters on the platform, writable The user that created the entity.
file_extension varchar2 File Extension filters on the platform, writable The extension of the file.
file_id int64 File ID filters on the platform, writable The ID of this file
file_modelId int64 File Model ID filters on the platform, writable The ID of the associated type.
file_modelType varchar2 File Model Type filters on the platform, writable The category of the file.
file_name varchar2 File Name filters on the platform, writable The public name of the file.
file_secureHash varchar2 itgen_bouw7_file_securehash filters on the platform, writable 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 The size of the file in bytes.
file_updatedAt datetime File Updated at filters on the platform, writable The last updated time of the entity.
file_updatedBy varchar2 File Updated by filters on the platform, writable The user that last updated the entity.
file_uri varchar2 File URI filters on the platform, writable The URI of the file, used to fetch the contents.
fromBasecone char From Basecone filters on the platform, writable Whether the invoice is imported from Basecone.
gAccountAmount varchar2 G-Account Amount filters on the platform, writable The g account amount of the purchase invoice.
grossPrice varchar2 Gross Price writable The gross price of the purchase invoice line.
id int64 ID writable The ID of the purchase invoice line. Must be omitted to create a new purchase invoice line.
id_2 int64 ID filters on the platform, writable The ID of purchase invoice.
invoiceNumber varchar2 Invoice Number filters on the platform, writable The invoice number of purchase invoice.
invoice_branch_id int64 Branch ID filters on the platform, writable The ID of the branch.
invoice_branch_name varchar2 Branch Name filters on the platform, writable The name of the branch.
invoice_chainLiabilityDocumentExpirationDate datetime This field is dynamically hydrated by the 'addChainLiabilityDocumentExpirationDate'-method in the schema factory. filters on the platform, writable The newest expiration date of the chain liability document(s) associated with the contact, in ATOM format.
invoice_comment varchar2 Comment filters on the platform, writable A comment placed on this purchase invoice.
invoice_createdAt datetime Created at filters on the platform, writable The creation date of the object in ATOM/ISO-8601 format
invoice_createdBy_id int64 Created by ID filters on the platform, writable The ID of the user.
invoice_createdBy_username varchar2 Created by User Name filters on the platform, writable The username of the user.
invoice_currentApprover varchar2 This field is dynamically hydrated by the 'addCurrentApprover'-method in the schema factory. filters on the platform, writable The full name of the current approver.
invoice_date datetime Date filters on the platform, writable The entry date of this purchase invoice.
invoice_datePaid varchar2 Date Paid filters on the platform, writable The date this purchase invoice was paid.
invoice_deliveryTicket_bookingStatus int64 Delivery Ticket Booking Status filters on the platform, writable The current booking status. 0 = Registered, 1 = Invoiced, 2 = Not billable, 3 = Credited.
invoice_deliveryTicket_date datetime Delivery Ticket Date filters on the platform, writable The date of the delivery ticket, represented in ATOM-format.
invoice_deliveryTicket_description varchar2 Delivery Ticket Description filters on the platform, writable The description of this delivery ticket. May contain HTML content.
invoice_deliveryTicket_id int64 Delivery Ticket ID filters on the platform, writable The ID of this delivery ticket.
invoice_deliveryTicket_isProcessed char Delivery Ticket Is Processed filters on the platform, writable Whether this delivery ticket has been processed.
invoice_deliveryTicket_number varchar2 Delivery Ticket Number filters on the platform, writable The ticket number of this delivery ticket.
invoice_deliveryTicket_price varchar2 Delivery Ticket Price filters on the platform, writable The price of this delivery ticket.
invoice_deliveryTicket_purchaseTypeId int64 Delivery Ticket Purchase Type ID filters on the platform, writable The ID of the purchase type of this delivery ticket.
invoice_deliveryTicket_purchaseTypeName varchar2 Delivery Ticket Purchase Type Name filters on the platform, writable The name of the purchase type of this delivery ticket.
invoice_division_description varchar2 Division Description filters on the platform, writable The description of the division.
invoice_division_exactDivisionId varchar2 Division Exact Division ID filters on the platform, writable The division ID of an Exact Online environment.
invoice_division_glAccountCode varchar2 Division General Ledger Account Code filters on the platform, writable A default general ledger account code to use for sales related items.
invoice_division_glAccountCodePurchase varchar2 Division General Ledger Account Code Purchase filters on the platform, writable A default general ledger account code to use for purchase related items.
invoice_division_id int64 Division ID filters on the platform, writable The ID of the division.
invoice_division_journalCode varchar2 Division Journal Code filters on the platform, writable A default journal code to use for sales related items.
invoice_division_journalCodePurchase varchar2 Division Journal Code Purchase filters on the platform, writable A default journal code to use for purchase related items.
invoice_dueDate datetime Due Date filters on the platform, writable The due date of this purchase invoice.
invoice_entryNumber int64 Entry Number filters on the platform, writable A sequential tracking number assigned to this purchase invoice. Also known as voucher number, serial number or tracking number.
invoice_id int64 ID filters on the platform, writable The ID of this purchase invoice.
invoice_invoiceNumber varchar2 Invoice Number filters on the platform, writable The invoice number of this purchase invoice.
invoice_isBookedInExact char Is Booked in Exact filters on the platform, writable Whether this purchase invoice is booked in Exact.
invoice_isBookedInTwinfield char Is Booked in Twinfield filters on the platform, writable Whether this purchase invoice is booked in Twinfield.
invoice_isMutable char itgen_bouw7_ismutable filters on the platform, writable Whether the purchase invoice is mutable.
invoice_isOriginatingFromBasecone char Is Originating from Basecone filters on the platform, writable Whether this purchase invoice originates from Basecone.
invoice_orderNumber varchar2 Order Number filters on the platform, writable The order number associated with this purchase invoice.
invoice_paymentReference varchar2 Payment Reference filters on the platform, writable The payment reference of this purchase invoice.
invoice_project_branchId int64 Project Branch ID filters on the platform, writable The ID of the branch of this project.
invoice_project_categoryId int64 Project Category ID filters on the platform, writable The ID of the category of this project.
invoice_project_divisionId int64 Project Division ID filters on the platform, writable The ID of the division of this project.
invoice_project_id int64 Project ID filters on the platform, writable The ID of the project.
invoice_project_name varchar2 Project Name filters on the platform, writable The name of the project.
invoice_project_number varchar2 Project Number filters on the platform, writable The number of the project.
invoice_project_status varchar2 Project Status filters on the platform, writable The name of the current status of this project.
invoice_project_statusId int64 Project Status ID filters on the platform, writable The ID of the status of this project.
invoice_status int64 Status filters on the platform, writable The status of this purchase invoice. (0 = New, 1 = Approved, 2 = Open, 3 = Expired, 4 = Paid, 5 = Declined)
invoice_subTotal varchar2 This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. filters on the platform, writable The sum of all purchase invoice line subtotals, excluding VAT.
invoice_supplier_emailAddress varchar2 Supplier Email Address filters on the platform, writable The email address of the contact.
invoice_supplier_id int64 Supplier ID filters on the platform, writable The ID of the contact.
invoice_supplier_name varchar2 Supplier Name filters on the platform, writable The name of this contact.
invoice_supplier_type varchar2 Supplier Type filters on the platform, writable The type of this contact.
invoice_supplier_typeId int64 Supplier Type ID filters on the platform, writable The type ID of this contact.
invoice_total varchar2 This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. filters on the platform, writable The sum of all purchase invoice line subtotals, including VAT.
invoice_updatedAt datetime Updated At filters on the platform, writable The creation date of the object in ATOM/ISO-8601 format
invoice_updatedBy_id int64 Updated by ID filters on the platform, writable The ID of the user.
invoice_updatedBy_username varchar2 Updated by User Name filters on the platform, writable The username of the user.
invoice_vatTotal varchar2 This field is dynamically hydrated by the 'addPricingInformation'-method in the schema factory. filters on the platform, writable The sum of all purchase invoice line VAT totals.
isBooked char Is Booked filters on the platform, writable Whether the invoice is already booked.
isMutable char itgen_bouw7_ismutable filters on the platform, writable Whether the purchase invoice is mutable.
ledger varchar2 Ledger writable A reference to the ledger of the purchase invoice line.
modelId int64 Model ID writable The model ID. Will be the ID of the selected modelType.
modelType int64 Model Type writable The model type, possible options: 1 = SubcontractorContract / 2 = PurchaseOrderContract / 3 = Project.
nextPurchaseInvoiceId int64 Next Purchase Invoice ID filters on the platform, writable 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 The order number of the purchase invoice.
paymentReference varchar2 Payment Reference filters on the platform, writable The payment reference of the purchase invoice.
previousPurchaseInvoiceId int64 Previous Purchase Invoice ID filters on the platform, writable The ID of the previous purchase invoice starting from this purchase invoice. Null when no previous purchase invoice available.
project_branch_code varchar2 itgen_bouw7_project_branch_code filters on the platform, writable The code for this branch
project_branch_id int64 itgen_bouw7_project_branch_id filters on the platform, writable The ID of the branch.
project_branch_name varchar2 itgen_bouw7_project_branch_name filters on the platform, writable The name of this branch
project_category_code varchar2 itgen_bouw7_project_category_code filters on the platform, writable The code for the category.
project_category_createdAt datetime itgen_bouw7_project_category_createdat filters on the platform, writable The creation time of the entity.
project_category_createdBy varchar2 itgen_bouw7_project_category_createdby filters on the platform, writable The user that created the entity.
project_category_generalCostsOrProfit varchar2 itgen_bouw7_project_category_generalcostsorprofit filters on the platform, writable The general costs or profit for the category.
project_category_generalCostsPercentage varchar2 itgen_bouw7_project_category_generalcostspercentage filters on the platform, writable The general costs percentage for the category.
project_category_grossProfitMargin varchar2 itgen_bouw7_project_category_grossprofitmargin filters on the platform, writable The gross profit margin for the category.
project_category_id int64 itgen_bouw7_project_category_id filters on the platform, writable The ID of the category.
project_category_name varchar2 itgen_bouw7_project_category_name filters on the platform, writable The name of the category.
project_category_updatedAt datetime itgen_bouw7_project_category_updatedat filters on the platform, writable The last updated time of the entity.
project_category_updatedBy varchar2 itgen_bouw7_project_category_updatedby filters on the platform, writable The user that last updated the entity.
project_city varchar2 Project City filters on the platform, writable The city of the project.
project_contact_email varchar2 Project Contact Email filters on the platform, writable The email address.
project_contact_id int64 Project Contact ID filters on the platform, writable ID of contact.
project_contact_isVatShifted char itgen_bouw7_project_contact_isvatshifted filters on the platform, writable Whether VAT is shifted for the contact.
project_contact_name varchar2 Project Contact Name filters on the platform, writable Name of contact.
project_contact_phoneNumber varchar2 itgen_bouw7_project_contact_phonenumber filters on the platform, writable The phone number of the contact.
project_createdAt datetime Project Created at filters on the platform, writable The creation time of the entity.
project_createdBy varchar2 Project Created by filters on the platform, writable The user that created the entity.
project_deliveryDate datetime Project Delivery Date filters on the platform, writable Delivery date for the project.
project_endDate datetime Project End Date filters on the platform, writable End date for the project.
project_fullProjectNumber varchar2 Project Full Project Number filters on the platform, writable The full project number including year.
project_houseNumber varchar2 Project House Number filters on the platform, writable The house number for the project.
project_id int64 Project ID filters on the platform, writable The ID of the project.
project_information varchar2 Project Information filters on the platform, writable The information of the project.
project_name varchar2 Project Name filters on the platform, writable The name of the project.
project_projectNumber varchar2 Project Project Number filters on the platform, writable The project number.
project_reference varchar2 Project Reference filters on the platform, writable The reference of the project.
project_startDate datetime Project Start Date filters on the platform, writable Start date for the project.
project_status_closesProject char Project Status Closes Project filters on the platform, writable Whether or not this status closes a project.
project_status_createdAt datetime Project Status Created at filters on the platform, writable The creation time of the entity.
project_status_createdBy varchar2 Project Status Created by filters on the platform, writable The user that created the entity.
project_status_id int64 Project Status ID filters on the platform, writable The ID of the status.
project_status_invoicesProject char Project Status Invoices Project filters on the platform, writable Whether or not this status invoices a project.
project_status_name varchar2 Project Status Name filters on the platform, writable The name of the status.
project_status_plansProject char Project Status Plans Project filters on the platform, writable Whether or not this status plans a project.
project_status_updatedAt datetime Project Status Updated at filters on the platform, writable The last updated time of the entity.
project_status_updatedBy varchar2 Project Status Updated by filters on the platform, writable The user that last updated the entity.
project_streetName varchar2 Project Street Name filters on the platform, writable The street name for the project.
project_updatedAt datetime Project Updated at filters on the platform, writable The last updated time of the entity.
project_updatedBy varchar2 Project Updated by filters on the platform, writable The user that last updated the entity.
project_zipCode varchar2 Project ZIP Code filters on the platform, writable The zip code for the project.
quantity varchar2 Quantity writable The unit quantity of the purchase invoice line.
status int64 Status filters on the platform, writable Status of the purchase invoice.
subTotal varchar2 Subtotal writable The sub-total price of the purchase invoice line.
unitName varchar2 Unit Name writable The name of the unit in the purchase invoice line.
unitPrice varchar2 Unit Price writable The unit price of the purchase invoice line.
updatedAt datetime Updated At writable The last updated time of the entity.
updatedAt_2 datetime Updated at filters on the platform, writable The last updated time of the entity.
updatedBy varchar2 Updated by writable The user that last updated the entity.
updatedBy_2 varchar2 Updated by filters on the platform, writable The user that last updated the entity.
vatTariffId int64 VAT Tariff ID writable The VAT-tariff ID used on the purchase invoice line.
vatTariffPercentage varchar2 VAT Tariff Percentage writable The VAT-tariff percentage used on the purchase invoice line. Must be set to 0 if VAT is shifted.

Release Notes

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