newInvoiceForProject_ContactContactDivisions |
Returns the document of a new invoice.Returns the document of a new invoice.
Catalogus: Bouw7
Schema: Invoicing
Label: {res:itgen_bouw7_newinvoiceforproject_contactcontactdivisions_plural}
Dit is een alleen-lezen tabelfunctie. 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.
Parameters van Tabelfunctie
De volgende parameters kunnen worden gebruikt om het gedrag van de tabelfunctie newInvoiceForProject_ContactContactDivisions in te stellen. Voor verplichte parameters moet altijd een waarde worden opgegeven, maar optionele parameters hoeven in het algemeen geen waarde te hebben en de uitvoering zal standaard een vooraf bepaald gedrag vertonen. Waarden kunnen worden gespecificeerd op basis van positie en naam. In beide gevallen worden alle niet-gespecificeerde parameters geëvalueerd aan de hand van hun standaardwaarden.
Waardespecificatie op positie gebeurt door alle waarden van de eerste tot de laatste benodigde waarde op te sommen. Bijvoorbeeld: een `select * uit tabel(waarde1, waarde2, waarde3)` op een tabel met vier parameters zal de standaardwaarde voor de vierde parameter gebruiken en de opgegeven waarden voor de eerste drie.
Waardespecificatie op naam gebeurt door alle waarden die een waarde vereisen op te sommen. Bijvoorbeeld met `selecteer * uit tabel(naam1 => waarde1, naam3 => waarde3)` op dezelfde tabel zullen de standaardwaarden voor de tweede en vierde parameter worden gebruikt en de opgegeven waarden voor de eerste en derde.
Naam |
Datatype |
Verplicht |
Standaardwaarde |
Documentatie |
---|---|---|---|---|
project |
int64 |
☑ |
|
Project ID |
Kolommen van Tabelfunctie
De kolommen van de tabelfunctie newInvoiceForProject_ContactContactDivisions 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. |
city |
string |
Plaats |
☐ |
The city of residence of the contact. |
cocNumber |
string |
Kamer van Koophandel-nummer |
☐ |
The chamber of commerce number of the contact. |
code |
string |
Code |
☐ |
The debtor/creditor number (code) of the contact in the associated division |
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_2 |
string |
{res:itgen_bouw7_contactpersonname_2} |
☐ |
The name of the contact person for this invoice. |
contactPersonName |
string |
Contactpersoonnaam |
☐ |
The name of the contact person. |
contactType_id |
int64 |
Contactsoort-ID |
☐ |
The ID of contact type. |
contactType_name |
string |
Contactsoortnaam |
☐ |
The name of contact type. |
country |
string |
Land |
☐ |
The country of the contact. |
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_2 |
string |
{res:itgen_bouw7_debtornumber_2} |
☐ |
The debtor number of the contact associated with this invoice. |
debtorNumber |
string |
Debiteurnummer |
☐ |
The debtor number of the contact. |
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. |
divisionId |
int64 |
Divisie ID |
☐ |
The division ID of an Exact Online environment. |
dueDate |
datetime |
Vervaldatum |
☐ |
The invoice due date. |
emailAddress |
string |
E-mailadres |
☐ |
The email-address of the contact. |
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. |
expirationReminderDays |
int64 |
Vervalherinneringsdagen |
☐ |
The number of days before a reminder is sent. |
gAccountAmount |
string |
G-Rekening Bedrag |
☐ |
G-account amount. |
gAccountPercentage_2 |
string |
{res:itgen_bouw7_gaccountpercentage_2} |
☐ |
G-account percentage. |
gAccountPercentage |
string |
G-rekening Percentage |
☐ |
G-account percentage. |
gAccountText_2 |
string(255) |
{res:itgen_bouw7_gaccounttext_2} |
☐ |
G-account text. |
gAccountText |
string(255) |
G-Rekening Tekst |
☐ |
G-account text. |
glAccountCode |
string |
Grootboekrekeningcode |
☐ |
A default general ledger account code to use for sales related items. |
glAccountCodePurchase |
string |
Grootboekrekeningcode Inkoop |
☐ |
A default general ledger account code to use for purchase related items. |
glnNumber |
string(13) |
GLN Nummer |
☐ |
The Global Location Number. |
houseNumber |
string |
Huisnummer |
☐ |
The house- or building-number of the contact. |
iban |
string |
IBAN |
☐ |
The IBAN-account number of the contact. |
id_2 |
int64 |
ID |
☐ |
The ID of the contact. |
id_3 |
int64 |
{res:itgen_bouw7_id_3} |
☐ |
The ID of the invoice. Must be omitted to create a new invoice. |
id |
int64 |
ID |
☐ |
The ID of the contact division link. |
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. |
invoiceMail |
string |
Factuurmail |
☐ |
The invoice mail. |
invoiceNumber |
string |
Factuurnummer |
☐ |
The number of this invoice. |
invoiceUblVersion |
string |
Factuur UBL-versie |
☐ |
The preferred UBL invoice version for this contact. |
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. |
isVatShifted_2 |
boolean |
{res:itgen_bouw7_isvatshifted_2} |
☐ |
Whether VAT is shifted for the invoice. |
isVatShifted |
boolean |
Is BTW Verlegd |
☐ |
Whether VAT is shifted for the contact. |
language |
string |
Taal |
☐ |
The locale used by this invoice document, e.g.: nl-NL. |
nAccountText_2 |
string(255) |
{res:itgen_bouw7_naccounttext_2} |
☐ |
N-account text. |
nAccountText |
string(255) |
N-Rekening Tekst |
☐ |
N-account text. |
name |
string |
Naam |
☐ |
The name of the contact. |
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. |
paymentConditionPurchase |
string(255) |
Betalingsvoorwaarde Inkoop |
☐ |
A default payment condition to use for purchase related items. |
paymentConditionSales |
string(255) |
Betalingsvoorwaarde Verkoop |
☐ |
A default payment condition to use for sales related items. |
phoneNumber |
string |
Telefoonnummer |
☐ |
The phone number of the contact. |
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. |
startDate |
datetime |
Startdatum |
☐ |
The start date of attached booking items in Y-m-d format. |
status |
int64 |
Status |
☐ |
The status of the invoice. |
streetName |
string |
Straatnaam |
☐ |
The street name of the contact. |
updatedAt |
datetime |
Bijgewerkt op |
☐ |
The last updated time of the entity. |
updatedBy |
string |
Bijgewerkt door |
☐ |
The user that last updated the entity. |
vatNumber |
string |
BTW-nummer |
☐ |
The VAT-number of the contact. |
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_2 |
string |
{res:itgen_bouw7_wagecomponentpercentage_2} |
☐ |
Wage component percentage. |
wageComponentPercentage |
string |
Looncomponent Percentage |
☐ |
Wage component percentage. |
workAddress |
string(255) |
Werkadres |
☐ |
The work address of the invoice. |
zipCode |
string |
Postcode |
☐ |
The zip-code of the contact. |
30-06-2025 16:22 Versie 24.1.116-BETA+5455