invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

InvoiceChapterLineLinkedBookingItemsV2ByProjectId: Bouw7 itgen_bouw7_invoicechapterlinelinkedbookingitemsv2byprojectid_plural

read only REST

  • Catalogus: Bouw7
  • Schema: Invoicing
  • Label: itgen_bouw7_invoicechapterlinelinkedbookingitemsv2byprojectid_plural

Returns the document of a new invoice. Returns the document of a new invoice.

Kan alleen gegevens ophalen.

Samenvatting

Returns the document of a new invoice.

API-bron

  • Eindpunt: /project/{project}/invoice/new
  • Operatie: get /project/{project}/invoice/new

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 90
Aantal rijen per minuut bij volledige scan 241,000
Aantal rijen per minuut in een Query 666

Het resultaat kan op de client in de Cache worden opgeslagen.

Parameters

Name Datatype Required Default Documentation
project `` Project ID

Tabelkolommen

De kolommen van de tabel InvoiceChapterLineLinkedBookingItemsV2ByProjectId worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
attachEquipmentList char Voeg Materieellijst bij filters on the platform, writable, ::ancestor.::ancestor.::ancestor.attachEquipmentList Whether to attach the material list attachment.
attachGarbageList char Voeg Afvallijst bij filters on the platform, writable, ::ancestor.::ancestor.::ancestor.attachGarbageList Whether to attach the waste list attachment.
attachMaterialList char Voeg Materiaallijst bij filters on the platform, writable, ::ancestor.::ancestor.::ancestor.attachMaterialList Whether to attach the material list attachment.
attachRegister char Voeg Register bij filters on the platform, writable, ::ancestor.::ancestor.::ancestor.attachRegister Whether to attach the register attachment.
branch_code varchar2(255) Vestigingscode filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.code The code of the 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_gAccountPercentage varchar2 Filiaal G-Rekeningpercentage filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.gAccountPercentage The g account percentage of the branch.
branch_gAccountText varchar2(255) Filiaal G-Rekeningtekst filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.gAccountText The g account text of the branch.
branch_id int64 Vestiging-ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.id The ID of the branch.
branch_nAccountText varchar2(255) Filiaal N-Rekeningtekst filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.nAccountText The n account text of the branch.
branch_name varchar2 Filiaalnaam filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.name The name of the branch.
branch_useOrganizationInfo char Filiaal Gebruik Organisatie-informatie filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.useOrganizationInfo If organization information should be used instead of branch information.
branch_wageComponentPercentage varchar2 Filiaal Looncomponentpercentage filters on the platform, writable, ::ancestor.::ancestor.::ancestor.branch.wageComponentPercentage The wage component percentage of the branch.
canBookToAfas char Kan Boeken naar AFAS filters on the platform, writable, ::ancestor.::ancestor.::ancestor.canBookToAfas Whether it is allowed to book to AFAS.
canBookToExact char Kan Boeken naar Exact filters on the platform, writable, ::ancestor.::ancestor.::ancestor.canBookToExact Whether it is allowed to book to Exact.
canBookToMareon char Kan Boeken naar Mareon filters on the platform, writable, ::ancestor.::ancestor.::ancestor.canBookToMareon Whether it is allowed to book to Mareon.
canBookToTwinfield char Kan Boeken naar Twinfield filters on the platform, writable, ::ancestor.::ancestor.::ancestor.canBookToTwinfield Whether it is allowed to book to Twinfield.
canUseCostCenter char Kan Kostenplaats Gebruiken filters on the platform, writable, ::ancestor.::ancestor.::ancestor.canUseCostCenter Whether the user can use cost center functionality.
contactPersonName varchar2 Contactpersoonnaam filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPersonName The name of the contact person for this invoice.
contactPerson_city varchar2(255) Contactpersoon Stad filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.city The contact person's city.
contactPerson_createdAt datetime Contactpersoon Aangemaakt op filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.createdAt The creation time of the entity.
contactPerson_createdBy varchar2 Contactpersoon Aangemaakt door filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.createdBy The user that created the entity.
contactPerson_email varchar2(256) Contactpersoon E-mail filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.email The contact person's email address.
contactPerson_firstName varchar2(256) Contactpersoon Voornaam filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.firstName The contact person's first name.
contactPerson_houseNumber varchar2(50) Contactpersoon Huisnummer filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.houseNumber The contact person's house number.
contactPerson_id int64 Contactpersoon ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.id The ID of contact person.
contactPerson_jobTitle varchar2(64) Contactpersoon Functietitel filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.jobTitle The contact person's job title.
contactPerson_lastName varchar2(256) Contactpersoon Achternaam filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.lastName The contact person's last name.
contactPerson_phoneNumber varchar2(255) Contactpersoon Telefoonnummer filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.phoneNumber The contact person's phone number.
contactPerson_salutation varchar2(32) Contactpersoon Aanhef filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.salutation The contact person's salutation.
contactPerson_streetName varchar2(255) Contactpersoon Straatnaam filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.streetName The contact person's street name.
contactPerson_updatedAt datetime Contactpersoon Bijgewerkt op filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.updatedAt The last updated time of the entity.
contactPerson_updatedBy varchar2 Contactpersoon Bijgewerkt door filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.updatedBy The user that last updated the entity.
contactPerson_zipCode varchar2(20) Contactpersoon Postcode filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contactPerson.zipCode The contact person's zip code.
contact_city varchar2 Contact Stad filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.city The city of residence of the contact.
contact_cocNumber varchar2 Contact KvK-nummer filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.cocNumber The chamber of commerce number of the contact.
contact_contactPersonName varchar2 Contact Contactpersoon Naam filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.contactPersonName The name of the contact person.
contact_contactType_id int64 Contact Soort ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.contactType.id The ID of contact type.
contact_contactType_name varchar2 Contact Soort Naam filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.contactType.name The name of contact type.
contact_country varchar2 Contactpersoon Land filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.country The country of the contact.
contact_debtorNumber varchar2 Contact Debiteurnummer filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.debtorNumber The debtor number of the contact.
contact_emailAddress varchar2 Contactpersoon E-mailadres filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.emailAddress The email-address of the contact.
contact_expirationReminderDays int64 Contact Vervaldatum Herinneringsdagen filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.expirationReminderDays The number of days before a reminder is sent.
contact_gAccountPercentage varchar2 Contact G-Rekeningpercentage filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.gAccountPercentage G-account percentage.
contact_gAccountText varchar2(255) Contact G-Rekeningtekst filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.gAccountText G-account text.
contact_glnNumber varchar2(13) itgen_bouw7_contact_glnnumber filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.glnNumber The Global Location Number.
contact_houseNumber varchar2 Contact Huisnummer filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.houseNumber The house- or building-number of the contact.
contact_iban varchar2 Contact IBAN filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.iban The IBAN-account number of the contact.
contact_id int64 Contactpersoon ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.id The ID of the contact.
contact_invoiceMail varchar2 itgen_bouw7_contact_invoicemail filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.invoiceMail The invoice mail.
contact_invoiceUblVersion varchar2 Contact Factuur UBL-Versie filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.invoiceUblVersion The preferred UBL invoice version for this contact.
contact_isVatShifted char Contact is BTW Verlegd filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.isVatShifted Whether VAT is shifted for the contact.
contact_nAccountText varchar2(255) Contact N-Rekening Tekst filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.nAccountText N-account text.
contact_name varchar2 Contactpersoon Naam filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.name The name of the contact.
contact_phoneNumber varchar2 Contact Telefoonnummer filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.phoneNumber The phone number of the contact.
contact_streetName varchar2 Contact Straatnaam filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.streetName The street name of the contact.
contact_vatNumber varchar2 Contact BTW-nummer filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.vatNumber The VAT-number of the contact.
contact_wageComponentPercentage varchar2 Contact Looncomponent Percentage filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.wageComponentPercentage Wage component percentage.
contact_zipCode varchar2 Contactpersoon Postcode filters on the platform, writable, ::ancestor.::ancestor.::ancestor.contact.zipCode The zip-code of the contact.
costCenter varchar2 Kostenplaats writable, ::ancestor.costCenter A reference to the cost center associated with the invoice line.
createdAt datetime Aangemaakt op filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Gemaakt door 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 The invoice date.
datePaid varchar2 Datum van Betaling filters on the platform, writable, ::ancestor.::ancestor.::ancestor.datePaid The paid date.
debtorNumber varchar2 Debiteurnummer filters on the platform, writable, ::ancestor.::ancestor.::ancestor.debtorNumber The debtor number of the contact associated with this invoice.
description varchar2(255) Description writable, ::ancestor.description The name of the invoice line.
description_2 varchar2 itgen_bouw7_description_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.description The public description for this invoice.
displayWorkAddress char Weergeven Adres van Werk filters on the platform, writable, ::ancestor.::ancestor.::ancestor.displayWorkAddress Whether the work address is displayed on the invoice.
division_description varchar2 Divisie Omschrijving filters on the platform, writable, ::ancestor.::ancestor.::ancestor.division.description The description of the division.
division_exactDivisionId varchar2 Divisie Exact Divisie-ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.division.exactDivisionId The division ID of an Exact Online environment.
division_glAccountCode varchar2 Administratie Grootboekrekeningcode 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 Administratie Grootboekrekeningcode Inkoop 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 Divisie ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.division.id The ID of the division.
division_journalCode varchar2 Administratie Dagboekcode filters on the platform, writable, ::ancestor.::ancestor.::ancestor.division.journalCode A default journal code to use for sales related items.
division_journalCodePurchase varchar2 Administratie Dagboekcode Inkoop filters on the platform, writable, ::ancestor.::ancestor.::ancestor.division.journalCodePurchase A default journal code to use for purchase related items.
division_salesInvoiceNumberPrefix varchar2(3) Administratie Verkoopfactuurnummervoorvoegsel filters on the platform, writable, ::ancestor.::ancestor.::ancestor.division.salesInvoiceNumberPrefix The prefix (3 digits) used to generate invoice number range per division.
dueDate datetime Vervaldag filters on the platform, writable, ::ancestor.::ancestor.::ancestor.dueDate The invoice due date.
endDate datetime Einddatum filters on the platform, writable, ::ancestor.::ancestor.::ancestor.endDate The end date of attached booking items in Y-m-d format.
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 Betalingsconditie filters on the platform, writable, ::ancestor.::ancestor.::ancestor.exactPaymentCondition The code of the Exact Online payment condition for this invoice.
gAccountAmount varchar2 G-Rekening Bedrag filters on the platform, writable, ::ancestor.::ancestor.::ancestor.gAccountAmount G-account amount.
gAccountPercentage varchar2 G-rekening Percentage filters on the platform, writable, ::ancestor.::ancestor.::ancestor.gAccountPercentage G-account percentage.
gAccountText varchar2(255) G-Rekening Tekst filters on the platform, writable, ::ancestor.::ancestor.::ancestor.gAccountText G-account text.
id int64 ID writable, ::ancestor.id The ID of the invoice line.Must be omitted to create a new invoice.
id_2 int64 ID writable, ::ancestor.::ancestor.id The ID of this chapter record.
id_3 int64 itgen_bouw7_id_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.id The ID of the invoice.Must be omitted to create a new invoice.
includeCoverSheet char Inclusief Voorblad filters on the platform, writable, ::ancestor.::ancestor.::ancestor.includeCoverSheet Whether to include a cover sheet to the invoice PDF.
internalNote varchar2 Interne Notitie filters on the platform, writable, ::ancestor.::ancestor.::ancestor.internalNote The internal note for this invoice.
invoiceNumber varchar2 Factuurnummer filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceNumber The number of this invoice.
invoicedProjectStatusName varchar2 Gefactureerd Projectstatusnaam filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoicedProjectStatusName The status name of the projects if the status is going to be changed when an invoice is saved.
isBooked char Is Geboekt filters on the platform, writable, ::ancestor.::ancestor.::ancestor.isBooked Whether the invoice is already booked.
isCollective char Is Collectief filters on the platform, writable, ::ancestor.::ancestor.::ancestor.isCollective Whether the invoice is a collective invoice.
isCredit char Is Credit filters on the platform, writable, ::ancestor.::ancestor.::ancestor.isCredit Whether this invoice is a credit invoice.
isMareonBooked char Is Mareon geboekt filters on the platform, writable, ::ancestor.::ancestor.::ancestor.isMareonBooked Whether the invoice is already booked in mareon.
isRoot char Is Wortel writable, ::ancestor.::ancestor.isRoot Whether the chapter is the root chapter of the invoice.
isVatShifted char Is BTW Verlegd filters on the platform, writable, ::ancestor.::ancestor.::ancestor.isVatShifted Whether VAT is shifted for the invoice.
language varchar2 Language filters on the platform, writable, ::ancestor.::ancestor.::ancestor.language The locale used by this invoice document, e.g.: nl-NL.
ledger varchar2 Ledger writable, ::ancestor.ledger A reference to the ledger of the invoice line.
nAccountText varchar2(255) N-Rekening Tekst filters on the platform, writable, ::ancestor.::ancestor.::ancestor.nAccountText N-account text.
name varchar2(255) Name writable, ::ancestor.::ancestor.name The name of the chapter.
organization_city varchar2 Organisatie Stad filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.city The city of residence of the supplier.
organization_cocNumber varchar2 Organisatie KvK-nummer filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.cocNumber The chamber of commerce number of the supplier.
organization_country varchar2 Organisatie Land filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.country The country of the supplier.
organization_emailAddress varchar2 Organisatie E-mailadres filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.emailAddress The email-address of the supplier.
organization_expirationReminderDays int64 Organisatie Vervaldatum Herinneringsdagen filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.expirationReminderDays The number of days before a reminder is sent.
organization_gAccountPercentage varchar2 Organisatie G-rekening Percentage filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.gAccountPercentage The g account percentage for the customer.
organization_gAccountText varchar2 Organisatie G-rekening Tekst filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.gAccountText The g account text for the customer.
organization_houseNumber varchar2 Organisatie Huisnummer filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.houseNumber The house- or building-number of the supplier.
organization_iban varchar2 Organisatie IBAN filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.iban The IBAN-account number of the supplier.
organization_logo_createdAt datetime Organisatielogo Gemaakt op filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.logo.createdAt The creation time of the entity.
organization_logo_createdBy varchar2 Organisatielogo Gemaakt door filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.logo.createdBy The user that created the entity.
organization_logo_extension varchar2 Organisatielogo-extensie filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.logo.extension The extension of the file.
organization_logo_id int64 Organisatielogo-ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.logo.id The ID of this file
organization_logo_modelId int64 Organisatielogo Model-ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.logo.modelId The ID of the associated type.
organization_logo_modelType varchar2 Organisatie Logo Modeltype filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.logo.modelType The category of the file.
organization_logo_name varchar2 Organisatie Logonaam filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.logo.name The public name of the file.
organization_logo_secureHash varchar2 itgen_bouw7_organization_logo_securehash filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.logo.secureHash A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication.
organization_logo_size int64 Organisatie Logogrootte filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.logo.size The size of the file in bytes.
organization_logo_updatedAt datetime Organisatie Logo Bijgewerkt op filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.logo.updatedAt The last updated time of the entity.
organization_logo_updatedBy varchar2 Organisatie Logo Bijgewerkt door filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.logo.updatedBy The user that last updated the entity.
organization_logo_uri varchar2 Organisatielogo-URI filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.logo.uri The URI of the file, used to fetch the contents.
organization_nAccountText varchar2 Organisatie N-Rekening Tekst filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.nAccountText The n account text for the customer.
organization_name varchar2 Organisatienaam filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.name The name of the supplier.
organization_phoneNumber varchar2 Organisatie Telefoonnummer filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.phoneNumber The phone number of the supplier.
organization_shouldCopyProjectDescription char Organisatie moet Projectomschrijving Kopiëren filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.shouldCopyProjectDescription Whether the project description should be copied.
organization_showProjectNameOnInvoicePdf char Organisatie Toon Projectnaam op Factuur PDF filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.showProjectNameOnInvoicePdf Whether the project name will show on the invoice.
organization_showProjectNumberOnInvoice char Organisatie Toon Projectnummer op Factuur filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.showProjectNumberOnInvoice Whether the project number will show on the invoice.
organization_streetName varchar2 Organisatie Straatnaam filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.streetName The street name of the supplier.
organization_vatNumber varchar2 Organisatie BTW-nummer filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.vatNumber The VAT-number of the supplier.
organization_wageComponentPercentage varchar2 Organisatie Looncomponent Percentage filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.wageComponentPercentage The wage component percentage for the customer.
organization_websiteAddress varchar2 Organisatie Website-adres filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.websiteAddress The website address of the supplier.
organization_zipCode varchar2 Organisatie Postcode filters on the platform, writable, ::ancestor.::ancestor.::ancestor.organization.zipCode The zip-code of the supplier.
priceCode varchar2(35) Prijscode writable, ::ancestor.priceCode The price code of the invoice line.
projectId int64 Project ID writable, ::ancestor.projectId The ID of the project associated with this invoice line.
projectInvoiceTermId int64 Projectfactuurtermijn-ID writable, ::ancestor.projectInvoiceTermId The ID of the project invoice term associated with this line.
project_fullProjectNumber varchar2 Volledig Projectnummer filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.fullProjectNumber The full project number including year.
project_id int64 Project ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.id The ID of the project.
project_name varchar2 Projectnaam filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.name The name of the project.
project_reference varchar2 Projectreferentie filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.reference The reference of the project.
project_workAddress varchar2 Project Werkadres filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.workAddress The work address of the project.
quantity varchar2 Quantity writable, ::ancestor.quantity The unit quantity of the invoice line.
reference varchar2 Reference writable, ::ancestor.reference Reference field of project (if available) from the invoice line.
sortIndex int64 Sorteerindex writable, ::ancestor.sortIndex The sort index of this invoice line.
sortIndex_2 int64 itgen_bouw7_sortindex_2 writable, ::ancestor.::ancestor.sortIndex The sort index of this chapter.
startDate datetime Startdatum filters on the platform, writable, ::ancestor.::ancestor.::ancestor.startDate The start date of attached booking items in Y-m-d format.
status int64 Status filters on the platform, writable, ::ancestor.::ancestor.::ancestor.status The status of the invoice.
subTotal varchar2 Subtotal writable, ::ancestor.subTotal The sub-total price of the invoice line.
surchargePercentage varchar2 Toeslagpercentage writable, ::ancestor.surchargePercentage The surcharge percentage of the invoice line.
unitName varchar2 Eenheidsnaam writable, ::ancestor.unitName The name of the unit in the invoice line.
unitPrice varchar2 Prijs per Eenheid writable, ::ancestor.unitPrice The unit price of the invoice line.
updatedAt datetime Bijgewerkt op filters on the platform, writable, ::ancestor.::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Bijgewerkt door filters on the platform, writable, ::ancestor.::ancestor.::ancestor.updatedBy The user that last updated the entity.
vatShiftedValue varchar2(255) BTW-verlegde Waarde filters on the platform, writable, ::ancestor.::ancestor.::ancestor.vatShiftedValue VAT is shifted value.Usually a VAT-number of the contact.
vatTariffId int64 BTW-Tarief ID writable, ::ancestor.vatTariffId The VAT-tariff ID used on the invoice line.
vatTariffLegalText varchar2 itgen_bouw7_vattarifflegaltext writable, ::ancestor.vatTariffLegalText The legal text of the VAT-tariff used on the invoice line.Only for customers from the belgian hosting.
vatTariffPercentage varchar2 BTW-Tarief Percentage writable, ::ancestor.vatTariffPercentage The VAT-tariff percentage used on the invoice line.Must be set to 0 if VAT is shifted.
wageComponentAmount varchar2 Looncomponent Bedrag filters on the platform, writable, ::ancestor.::ancestor.::ancestor.wageComponentAmount Wage component amount.
wageComponentPercentage varchar2 Looncomponent Percentage filters on the platform, writable, ::ancestor.::ancestor.::ancestor.wageComponentPercentage Wage component percentage.
workAddress varchar2(255) Werkadres filters on the platform, writable, ::ancestor.::ancestor.::ancestor.workAddress The work address of the invoice.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: