invantive documentation
Invantive Support ForumsLog In / Sign Up

InvoiceCompanyInfoByProject: Bouw7 Invoice Company Information by Project

read only REST

  • Catalog: Bouw7
  • Schema: Invoicing
  • Label: Invoice Company Information by Project

Returns the company information based on the given project. Returns the company information based on the given project.

Can only retrieve data.

Summary

Returns the company information based on the given project.

API Source

  • Endpoint: /invoicing-project/{project}/company-info
  • Operation: get /invoicing-project/{project}/company-info

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
project `` Project ID

Table Columns

The columns of the table InvoiceCompanyInfoByProject 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
city varchar2 City filters on the platform, writable, city The city of residence of the supplier.
cocNumber varchar2 Chamber of Commerce Number filters on the platform, writable, cocNumber The chamber of commerce number of the supplier.
country varchar2 Country filters on the platform, writable, country The country of the supplier.
emailAddress varchar2 Email Address filters on the platform, writable, emailAddress The email-address of the supplier.
expirationReminderDays int64 Expiration Reminder Days filters on the platform, writable, expirationReminderDays The number of days before a reminder is sent.
gAccountPercentage varchar2 G-Account Percentage filters on the platform, writable, gAccountPercentage The g account percentage for the customer.
gAccountText varchar2 G-Account Text filters on the platform, writable, gAccountText The g account text for the customer.
houseNumber varchar2 House Number filters on the platform, writable, houseNumber The house- or building-number of the supplier.
iban varchar2 IBAN filters on the platform, writable, iban The IBAN-account number of the supplier.
logo_createdAt datetime Logo Created at filters on the platform, writable, logo.createdAt The creation time of the entity.
logo_createdBy varchar2 Logo Created by filters on the platform, writable, logo.createdBy The user that created the entity.
logo_extension varchar2 Logo Extension filters on the platform, writable, logo.extension The extension of the file.
logo_id int64 Logo ID filters on the platform, writable, logo.id The ID of this file
logo_modelId int64 Logo Model ID filters on the platform, writable, logo.modelId The ID of the associated type.
logo_modelType varchar2 Logo Model Type filters on the platform, writable, logo.modelType The category of the file.
logo_name varchar2 Logo Name filters on the platform, writable, logo.name The public name of the file.
logo_secureHash varchar2 itgen_bouw7_logo_securehash filters on the platform, writable, logo.secureHash A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication.
logo_size int64 Logo Size filters on the platform, writable, logo.size The size of the file in bytes.
logo_updatedAt datetime Logo Updated at filters on the platform, writable, logo.updatedAt The last updated time of the entity.
logo_updatedBy varchar2 Logo Updated by filters on the platform, writable, logo.updatedBy The user that last updated the entity.
logo_uri varchar2 Logo URI filters on the platform, writable, logo.uri The URI of the file, used to fetch the contents.
nAccountText varchar2 N-Account Text filters on the platform, writable, nAccountText The n account text for the customer.
name varchar2 Name filters on the platform, writable, name The name of the supplier.
phoneNumber varchar2 Phone Number filters on the platform, writable, phoneNumber The phone number of the supplier.
shouldCopyProjectDescription char Should Copy Project Description filters on the platform, writable, shouldCopyProjectDescription Whether the project description should be copied.
showProjectNameOnInvoicePdf char Show Project Name on Invoice PDF filters on the platform, writable, showProjectNameOnInvoicePdf Whether the project name will show on the invoice.
showProjectNumberOnInvoice char Show Project Number on Invoice filters on the platform, writable, showProjectNumberOnInvoice Whether the project number will show on the invoice.
streetName varchar2 Street Name filters on the platform, writable, streetName The street name of the supplier.
vatNumber varchar2 VAT Number filters on the platform, writable, vatNumber The VAT-number of the supplier.
wageComponentPercentage varchar2 Wage Component Percentage filters on the platform, writable, wageComponentPercentage The wage component percentage for the customer.
websiteAddress varchar2 Website Address filters on the platform, writable, websiteAddress The website address of the supplier.
zipCode varchar2 ZIP Code filters on the platform, writable, zipCode The zip-code of the supplier.

Release Notes

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