InvoiceChaptersV2 |
Returns the document of a new invoice.Returns the document of a new invoice.
Catalogus: Bouw7
Schema: Invoicing
Label: {res:itgen_bouw7_invoicechaptersv2_plural}
Dit is een alleen-lezen tabel. De Bouw7 API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive UniversalSQL-stuurprogramma voor Bouw7 ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de Bouw7-API.
Tabelkolommen
De kolommen van de tabel InvoiceChaptersV2 worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
attachEquipmentList |
boolean |
Voeg Materieellijst bij |
☐ |
Whether to attach the material list attachment. |
attachGarbageList |
boolean |
Voeg Afvallijst bij |
☐ |
Whether to attach the waste list attachment. |
attachMaterialList |
boolean |
Voeg Materiaallijst bij |
☐ |
Whether to attach the material list attachment. |
attachRegister |
boolean |
Voeg Register bij |
☐ |
Whether to attach the register attachment. |
branch_code |
string(255) |
Vestigingscode |
☐ |
The code of the branch. |
branch_division_description |
string |
{res:itgen_bouw7_branch_division_description} |
☐ |
The description of the division. |
branch_division_exactDivisionId |
string |
{res:itgen_bouw7_branch_division_exactdivisionid} |
☐ |
The division ID of an Exact Online environment. |
branch_division_glAccountCode |
string |
{res:itgen_bouw7_branch_division_glaccountcode} |
☐ |
A default general ledger account code to use for sales related items. |
branch_division_glAccountCodePurchase |
string |
{res:itgen_bouw7_branch_division_glaccountcodepurchase} |
☐ |
A default general ledger account code to use for purchase related items. |
branch_division_id |
int64 |
{res:itgen_bouw7_branch_division_id} |
☐ |
The ID of the division. |
branch_division_journalCode |
string |
{res:itgen_bouw7_branch_division_journalcode} |
☐ |
A default journal code to use for sales related items. |
branch_division_journalCodePurchase |
string |
{res:itgen_bouw7_branch_division_journalcodepurchase} |
☐ |
A default journal code to use for purchase related items. |
branch_division_salesInvoiceNumberPrefix |
string(3) |
{res:itgen_bouw7_branch_division_salesinvoicenumberprefix} |
☐ |
The prefix (3 digits) used to generate invoice number range per division. |
branch_gAccountPercentage |
string |
Filiaal G-Rekeningpercentage |
☐ |
The g account percentage of the branch. |
branch_gAccountText |
string(255) |
Filiaal G-Rekeningtekst |
☐ |
The g account text of the branch. |
branch_id |
int64 |
Vestiging-ID |
☐ |
The ID of the branch. |
branch_nAccountText |
string(255) |
Filiaal N-Rekeningtekst |
☐ |
The n account text of the branch. |
branch_name |
string |
Filiaalnaam |
☐ |
The name of the branch. |
branch_useOrganizationInfo |
boolean |
Filiaal Gebruik Organisatie-informatie |
☐ |
If organization information should be used instead of branch information. |
branch_wageComponentPercentage |
string |
Filiaal Looncomponentpercentage |
☐ |
The wage component percentage of the branch. |
canBookToAfas |
boolean |
Kan Boeken naar AFAS |
☐ |
Whether it is allowed to book to AFAS. |
canBookToExact |
boolean |
Kan Boeken naar Exact |
☐ |
Whether it is allowed to book to Exact. |
canBookToMareon |
boolean |
Kan Boeken naar Mareon |
☐ |
Whether it is allowed to book to Mareon. |
canBookToTwinfield |
boolean |
Kan Boeken naar Twinfield |
☐ |
Whether it is allowed to book to Twinfield. |
canUseCostCenter |
boolean |
Kan Kostenplaats Gebruiken |
☐ |
Whether the user can use cost center functionality. |
contact_city |
string |
Contact Stad |
☐ |
The city of residence of the contact. |
contact_cocNumber |
string |
Contact KvK-nummer |
☐ |
The chamber of commerce number of the contact. |
contact_contactPersonName |
string |
Contact Contactpersoon Naam |
☐ |
The name of the contact person. |
contact_contactType_id |
int64 |
Contact Soort ID |
☐ |
The ID of contact type. |
contact_contactType_name |
string |
Contact Soort Naam |
☐ |
The name of contact type. |
contact_country |
string |
Contactpersoon Land |
☐ |
The country of the contact. |
contact_debtorNumber |
string |
Contact Debiteurnummer |
☐ |
The debtor number of the contact. |
contact_emailAddress |
string |
Contactpersoon E-mailadres |
☐ |
The email-address of the contact. |
contact_expirationReminderDays |
int64 |
Contact Vervaldatum Herinneringsdagen |
☐ |
The number of days before a reminder is sent. |
contact_gAccountPercentage |
string |
Contact G-Rekeningpercentage |
☐ |
G-account percentage. |
contact_gAccountText |
string(255) |
Contact G-Rekeningtekst |
☐ |
G-account text. |
contact_glnNumber |
string(13) |
{res:itgen_bouw7_contact_glnnumber} |
☐ |
The Global Location Number. |
contact_houseNumber |
string |
Contact Huisnummer |
☐ |
The house- or building-number of the contact. |
contact_iban |
string |
Contact IBAN |
☐ |
The IBAN-account number of the contact. |
contact_id |
int64 |
Contactpersoon ID |
☐ |
The ID of the contact. |
contact_invoiceMail |
string |
{res:itgen_bouw7_contact_invoicemail} |
☐ |
The invoice mail. |
contact_invoiceUblVersion |
string |
Contact Factuur UBL-Versie |
☐ |
The preferred UBL invoice version for this contact. |
contact_isVatShifted |
boolean |
Contact is BTW Verlegd |
☐ |
Whether VAT is shifted for the contact. |
contact_nAccountText |
string(255) |
Contact N-Rekening Tekst |
☐ |
N-account text. |
contact_name |
string |
Contactpersoon Naam |
☐ |
The name of the contact. |
contact_phoneNumber |
string |
Contact Telefoonnummer |
☐ |
The phone number of the contact. |
contact_streetName |
string |
Contact Straatnaam |
☐ |
The street name of the contact. |
contact_vatNumber |
string |
Contact BTW-nummer |
☐ |
The VAT-number of the contact. |
contact_wageComponentPercentage |
string |
Contact Looncomponent Percentage |
☐ |
Wage component percentage. |
contact_zipCode |
string |
Contactpersoon Postcode |
☐ |
The zip-code of the contact. |
contactPerson_city |
string(255) |
Contactpersoon Stad |
☐ |
The contact person's city. |
contactPerson_createdAt |
datetime |
Contactpersoon Aangemaakt op |
☐ |
The creation time of the entity. |
contactPerson_createdBy |
string |
Contactpersoon Aangemaakt door |
☐ |
The user that created the entity. |
contactPerson_email |
string(256) |
Contactpersoon E-mail |
☐ |
The contact person's email address. |
contactPerson_firstName |
string(256) |
Contactpersoon Voornaam |
☐ |
The contact person's first name. |
contactPerson_houseNumber |
string(50) |
Contactpersoon Huisnummer |
☐ |
The contact person's house number. |
contactPerson_id |
int64 |
Contactpersoon ID |
☐ |
The ID of contact person. |
contactPerson_jobTitle |
string(64) |
Contactpersoon Functietitel |
☐ |
The contact person's job title. |
contactPerson_lastName |
string(256) |
Contactpersoon Achternaam |
☐ |
The contact person's last name. |
contactPerson_phoneNumber |
string(255) |
Contactpersoon Telefoonnummer |
☐ |
The contact person's phone number. |
contactPerson_salutation |
string(32) |
Contactpersoon Aanhef |
☐ |
The contact person's salutation. |
contactPerson_streetName |
string(255) |
Contactpersoon Straatnaam |
☐ |
The contact person's street name. |
contactPerson_updatedAt |
datetime |
Contactpersoon Bijgewerkt op |
☐ |
The last updated time of the entity. |
contactPerson_updatedBy |
string |
Contactpersoon Bijgewerkt door |
☐ |
The user that last updated the entity. |
contactPerson_zipCode |
string(20) |
Contactpersoon Postcode |
☐ |
The contact person's zip code. |
contactPersonName |
string |
Contactpersoonnaam |
☐ |
The name of the contact person for this invoice. |
createdAt |
datetime |
Aangemaakt op |
☐ |
The creation time of the entity. |
createdBy |
string |
Gemaakt door |
☐ |
The user that created the entity. |
date |
datetime |
Datum |
☐ |
The invoice date. |
datePaid |
string |
Datum van Betaling |
☐ |
The paid date. |
debtorNumber |
string |
Debiteurnummer |
☐ |
The debtor number of the contact associated with this invoice. |
description |
string |
Omschrijving |
☐ |
The public description for this invoice. |
displayWorkAddress |
boolean |
Weergeven Adres van Werk |
☐ |
Whether the work address is displayed on the invoice. |
division_description |
string |
Divisie Omschrijving |
☐ |
The description of the division. |
division_exactDivisionId |
string |
Divisie Exact Divisie-ID |
☐ |
The division ID of an Exact Online environment. |
division_glAccountCode |
string |
Administratie Grootboekrekeningcode |
☐ |
A default general ledger account code to use for sales related items. |
division_glAccountCodePurchase |
string |
Administratie Grootboekrekeningcode Inkoop |
☐ |
A default general ledger account code to use for purchase related items. |
division_id |
int64 |
Divisie ID |
☐ |
The ID of the division. |
division_journalCode |
string |
Administratie Dagboekcode |
☐ |
A default journal code to use for sales related items. |
division_journalCodePurchase |
string |
Administratie Dagboekcode Inkoop |
☐ |
A default journal code to use for purchase related items. |
division_salesInvoiceNumberPrefix |
string(3) |
Administratie Verkoopfactuurnummervoorvoegsel |
☐ |
The prefix (3 digits) used to generate invoice number range per division. |
dueDate |
datetime |
Vervaldatum |
☐ |
The invoice due date. |
endDate |
datetime |
Einddatum |
☐ |
The end date of attached booking items in Y-m-d format. |
exactFinancialPeriod_endDate |
datetime |
{res:itgen_bouw7_exactfinancialperiod_enddate} |
☐ |
The end date of the exact financial period in Y-m-d format. |
exactFinancialPeriod_financialPeriod |
int64 |
{res:itgen_bouw7_exactfinancialperiod_financialperiod} |
☐ |
The period of the exact financial period. |
exactFinancialPeriod_financialYear |
int64 |
{res:itgen_bouw7_exactfinancialperiod_financialyear} |
☐ |
The year of the exact financial period. |
exactFinancialPeriod_id |
int64 |
{res:itgen_bouw7_exactfinancialperiod_id} |
☐ |
The ID of the exact financial period. |
exactFinancialPeriod_startDate |
datetime |
{res:itgen_bouw7_exactfinancialperiod_startdate} |
☐ |
The start date of the exact financial period in Y-m-d format. |
exactPaymentCondition |
string(255) |
Exact Betalingsconditie |
☐ |
The code of the Exact Online payment condition for this invoice. |
gAccountAmount |
string |
G-Rekening Bedrag |
☐ |
G-account amount. |
gAccountPercentage |
string |
G-rekening Percentage |
☐ |
G-account percentage. |
gAccountText |
string(255) |
G-Rekening Tekst |
☐ |
G-account text. |
id_2 |
int64 |
ID |
☐ |
The ID of the invoice. Must be omitted to create a new invoice. |
id |
int64 |
ID |
☐ |
The ID of this chapter record. |
includeCoverSheet |
boolean |
Inclusief Voorblad |
☐ |
Whether to include a cover sheet to the invoice PDF. |
internalNote |
string |
Interne Notitie |
☐ |
The internal note for this invoice. |
invoicedProjectStatusName |
string |
Gefactureerd Projectstatusnaam |
☐ |
The status name of the projects if the status is going to be changed when an invoice is saved. |
invoiceNumber |
string |
Factuurnummer |
☐ |
The number of this invoice. |
isBooked |
boolean |
Is Geboekt |
☐ |
Whether the invoice is already booked. |
isCollective |
boolean |
Is Collectief |
☐ |
Whether the invoice is a collective invoice. |
isCredit |
boolean |
Is Credit |
☐ |
Whether this invoice is a credit invoice. |
isMareonBooked |
boolean |
Is Mareon geboekt |
☐ |
Whether the invoice is already booked in mareon. |
isRoot |
boolean |
Is Wortel |
☐ |
Whether the chapter is the root chapter of the invoice. |
isVatShifted |
boolean |
Is BTW Verlegd |
☐ |
Whether VAT is shifted for the invoice. |
language |
string |
Taal |
☐ |
The locale used by this invoice document, e.g.: nl-NL. |
nAccountText |
string(255) |
N-Rekening Tekst |
☐ |
N-account text. |
name |
string(255) |
Naam |
☐ |
The name of the chapter. |
organization_city |
string |
Organisatie Stad |
☐ |
The city of residence of the supplier. |
organization_cocNumber |
string |
Organisatie KvK-nummer |
☐ |
The chamber of commerce number of the supplier. |
organization_country |
string |
Organisatie Land |
☐ |
The country of the supplier. |
organization_emailAddress |
string |
Organisatie E-mailadres |
☐ |
The email-address of the supplier. |
organization_expirationReminderDays |
int64 |
Organisatie Vervaldatum Herinneringsdagen |
☐ |
The number of days before a reminder is sent. |
organization_gAccountPercentage |
string |
Organisatie G-rekening Percentage |
☐ |
The g account percentage for the customer. |
organization_gAccountText |
string |
Organisatie G-rekening Tekst |
☐ |
The g account text for the customer. |
organization_houseNumber |
string |
Organisatie Huisnummer |
☐ |
The house- or building-number of the supplier. |
organization_iban |
string |
Organisatie IBAN |
☐ |
The IBAN-account number of the supplier. |
organization_logo_createdAt |
datetime |
Organisatielogo Gemaakt op |
☐ |
The creation time of the entity. |
organization_logo_createdBy |
string |
Organisatielogo Gemaakt door |
☐ |
The user that created the entity. |
organization_logo_extension |
string |
Organisatielogo-extensie |
☐ |
The extension of the file. |
organization_logo_id |
int64 |
Organisatielogo-ID |
☐ |
The ID of this file |
organization_logo_modelId |
int64 |
Organisatielogo Model-ID |
☐ |
The ID of the associated type. |
organization_logo_modelType |
string |
Organisatie Logo Modeltype |
☐ |
The category of the file. |
organization_logo_name |
string |
Organisatie Logonaam |
☐ |
The public name of the file. |
organization_logo_secureHash |
string |
{res:itgen_bouw7_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 |
☐ |
The size of the file in bytes. |
organization_logo_updatedAt |
datetime |
Organisatie Logo Bijgewerkt op |
☐ |
The last updated time of the entity. |
organization_logo_updatedBy |
string |
Organisatie Logo Bijgewerkt door |
☐ |
The user that last updated the entity. |
organization_logo_uri |
string |
Organisatielogo-URI |
☐ |
The URI of the file, used to fetch the contents. |
organization_nAccountText |
string |
Organisatie N-Rekening Tekst |
☐ |
The n account text for the customer. |
organization_name |
string |
Organisatienaam |
☐ |
The name of the supplier. |
organization_phoneNumber |
string |
Organisatie Telefoonnummer |
☐ |
The phone number of the supplier. |
organization_shouldCopyProjectDescription |
boolean |
Organisatie moet Projectomschrijving Kopiëren |
☐ |
Whether the project description should be copied. |
organization_showProjectNameOnInvoicePdf |
boolean |
Organisatie Toon Projectnaam op Factuur PDF |
☐ |
Whether the project name will show on the invoice. |
organization_showProjectNumberOnInvoice |
boolean |
Organisatie Toon Projectnummer op Factuur |
☐ |
Whether the project number will show on the invoice. |
organization_streetName |
string |
Organisatie Straatnaam |
☐ |
The street name of the supplier. |
organization_vatNumber |
string |
Organisatie BTW-nummer |
☐ |
The VAT-number of the supplier. |
organization_wageComponentPercentage |
string |
Organisatie Looncomponent Percentage |
☐ |
The wage component percentage for the customer. |
organization_websiteAddress |
string |
Organisatie Website-adres |
☐ |
The website address of the supplier. |
organization_zipCode |
string |
Organisatie Postcode |
☐ |
The zip-code of the supplier. |
project_fullProjectNumber |
string |
Volledig Projectnummer |
☐ |
The full project number including year. |
project_id |
int64 |
Project ID |
☐ |
The ID of the project. |
project_name |
string |
Projectnaam |
☐ |
The name of the project. |
project_reference |
string |
Projectreferentie |
☐ |
The reference of the project. |
project_workAddress |
string |
Project Werkadres |
☐ |
The work address of the project. |
sortIndex |
int64 |
Sorteerindex |
☐ |
The sort index of this chapter. |
startDate |
datetime |
Startdatum |
☐ |
The start date of attached booking items in Y-m-d format. |
status |
int64 |
Status |
☐ |
The status of the invoice. |
updatedAt |
datetime |
Bijgewerkt op |
☐ |
The last updated time of the entity. |
updatedBy |
string |
Bijgewerkt door |
☐ |
The user that last updated the entity. |
vatShiftedValue |
string(255) |
BTW-verlegde Waarde |
☐ |
VAT is shifted value. Usually a VAT-number of the contact. |
wageComponentAmount |
string |
Looncomponent Bedrag |
☐ |
Wage component amount. |
wageComponentPercentage |
string |
Looncomponent Percentage |
☐ |
Wage component percentage. |
workAddress |
string(255) |
Werkadres |
☐ |
The work address of the invoice. |
30-06-2025 16:22 Versie 24.1.116-BETA+5455