newInvoice_ChaptersLinesLinkedBookingItems: Bouw7 Nieuwe Factuur Hoofdstukken Regels Gekoppelde Boekingsitems |
Returns the document of a new invoice.Returns the document of a new invoice.
Catalogus: Bouw7
Schema: Invoicing
Label: Nieuwe Factuur Hoofdstukken Regels Gekoppelde Boekingsitems
Dit is een alleen-lezen tabel. De Bouw7 API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive SQL-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 newInvoice_ChaptersLinesLinkedBookingItems worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
attachEquipmentList |
boolean |
Uitrustingslijst bijvoegen |
☐ |
Whether to attach the material list attachment. |
attachGarbageList |
boolean |
Afvallijst bijvoegen |
☐ |
Whether to attach the waste list attachment. |
attachMaterialList |
boolean |
Materiaallijst bijvoegen |
☐ |
Whether to attach the material list attachment. |
attachRegister |
boolean |
Register bijvoegen |
☐ |
Whether to attach the register attachment. |
branch_code |
string(255) |
Vestigingscode |
☐ |
The code of the branch. |
branch_gAccountPercentage |
string |
Tak G-rekening Percentage |
☐ |
The g account percentage of the branch. |
branch_gAccountText |
string(255) |
Tak G-rekening Tekst |
☐ |
The g account text of the branch. |
branch_id |
int64 |
Vestiging-ID |
☐ |
The ID of the branch. |
branch_nAccountText |
string(255) |
Tak N-Rekening Tekst |
☐ |
The n account text of the branch. |
branch_name |
string |
Filiaalnaam |
☐ |
The name of the branch. |
branch_useOrganizationInfo |
boolean |
Branche Gebruik Organisatie Informatie |
☐ |
If organization information should be used instead of branch information. |
branch_wageComponentPercentage |
string |
Branche Looncomponent Percentage |
☐ |
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 |
Contactpersoon KvK-nummer |
☐ |
The chamber of commerce number of the contact. |
contact_contactPersonName |
string |
Contactpersoon Naam |
☐ |
De naam van de contactpersoon. |
contact_country |
string |
Contactpersoon Land |
☐ |
The country of the contact. |
contact_debtorNumber |
string |
Contactpersoon Schuld of Nummer |
☐ |
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-rekening Percentage |
☐ |
G-account percentage. |
contact_gAccountText |
string(255) |
Contact G-rekening tekst |
☐ |
G-account text. |
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 |
contact-ID |
☐ |
The ID of the contact. |
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-Account Tekst |
☐ |
N-account text. |
contact_name |
string |
contactnaam |
☐ |
The name of the contact. |
contact_phoneNumber |
string |
Telefoonnummer contactpersoon |
☐ |
The phone number of the contact. |
contact_streetName |
string |
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 |
string |
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 Functieomschrijving |
☐ |
The contact person's job title. |
contactPerson_lastName |
string(256) |
Contactpersoon Achternaam |
☐ |
The contact person's last name. |
contactPerson_phoneNumber |
string(20) |
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 |
string |
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. |
costCenter |
string |
Kostenplaats |
☐ |
A reference to the cost center associated with the invoice line. |
createdAt |
string |
Aangemaakt op |
☐ |
The creation time of the entity. |
createdBy |
string |
Gemaakt door |
☐ |
The user that created the entity. |
date |
string |
Datum |
☐ |
The invoice date. |
datePaid |
string |
Datum van Betaling |
☐ |
The paid date. |
debtorNumber |
string |
Debiteurennummer |
☐ |
The debtor number of the contact associated with this invoice. |
description_1 |
string |
Omschrijving |
☐ |
The public description for this invoice. |
description |
string(255) |
Omschrijving |
☐ |
The name of the invoice line. |
displayWorkAddress |
boolean |
Werkadres weergeven |
☐ |
Whether the work address is displayed on the invoice. |
division_description |
string |
Divisie Omschrijving |
☐ |
The description of the division. |
division_exactDivisionId |
string |
Afdeling Exacte afdeling ID |
☐ |
The division ID of an Exact Online environment. |
division_glAccountCode |
string |
Afdeling Grootboekrekening Code |
☐ |
A default general ledger account code to use for sales related items. |
division_glAccountCodePurchase |
string |
Afdeling Grootboekrekening Code 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 |
Afdeling Tijdschriftcode |
☐ |
A default journal code to use for sales related items. |
division_journalCodePurchase |
string |
Afdeling Tijdschriftcode Aankoop |
☐ |
A default journal code to use for purchase related items. |
division_salesInvoiceNumberPrefix |
string(3) |
Afdeling Verkoopfactuurnummer Voorvoegsel |
☐ |
The prefix (3 digits) used to generate invoice number range per division. |
dueDate |
string |
Vervaldatum |
☐ |
The invoice due date. |
endDate |
string |
Einddatum |
☐ |
The end date of attached booking items in Y-m-d format. |
exactPaymentCondition |
string(255) |
Exacte 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 |
G-rekening tekst |
☐ |
G-account text. |
id_1 |
int64 |
ID |
☐ |
The ID of this chapter record. |
id_2 |
int64 |
ID |
☐ |
The ID of the invoice. Must be omitted to create a new invoice. |
id |
int64 |
ID |
☐ |
The ID of the invoice line. Must be omitted to create a new invoice. |
includeCoverSheet |
boolean |
Voeg een voorblad toe |
☐ |
Whether to include a cover sheet to the invoice PDF. |
internalNote |
string |
Interne Notitie |
☐ |
The internal note for this invoice. |
invoicedProjectStatusName |
string |
Gefactureerd Project Status Naam |
☐ |
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 Krediet |
☐ |
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 de BTW verlegd |
☐ |
Whether VAT is shifted for the invoice. |
language |
string |
Taal |
☐ |
The locale used by this invoice document, e.g.: nl-NL. |
ledger |
string |
Grootboek |
☐ |
A reference to the ledger of the invoice line. |
nAccountText |
string |
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 CoC 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 |
string |
Organisatie Logo Gemaakt op |
☐ |
The creation time of the entity. |
organization_logo_createdBy |
string |
Organisatie Logo Gemaakt door |
☐ |
The user that created the entity. |
organization_logo_extension |
string |
Uitbreiding organisatielogo |
☐ |
The extension of the file. |
organization_logo_id |
int64 |
Organisatie Logo ID |
☐ |
The ID of this file |
organization_logo_modelId |
int64 |
Organisatie Logo Model ID |
☐ |
The ID of the associated type. |
organization_logo_modelType |
string |
Organisatie Logo Model Type |
☐ |
The category of the file. |
organization_logo_name |
string |
Organisatie Logo Naam |
☐ |
The public name of the file. |
organization_logo_size |
int64 |
Organisatie Logogrootte |
☐ |
The size of the file in bytes. |
organization_logo_updatedAt |
string |
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 |
Organisatie Logo 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 projectbeschrijving 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 |
Website van de organisatie Adres |
☐ |
The website address of the supplier. |
organization_zipCode |
string |
Organisatie Postcode |
☐ |
The zip-code of the supplier. |
priceCode |
string(35) |
Prijscode |
☐ |
The price code of the invoice line. |
project_fullProjectNumber |
string |
Project 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 Werk Adres |
☐ |
The work address of the project. |
projectId |
int64 |
Project ID |
☐ |
The ID of the project associated with this invoice line. |
projectInvoiceTermId |
int64 |
Projectfactuur Termijn ID |
☐ |
The ID of the project invoice term associated with this line. |
quantity |
string |
Aantal |
☐ |
The unit quantity of the invoice line. |
reference |
string |
Referentie |
☐ |
Reference field of project (if available) from the invoice line. |
sortIndex_1 |
int64 |
Sorteerindex |
☐ |
The sort index of this chapter. |
sortIndex |
int64 |
Index sorteren |
☐ |
The sort index of this invoice line. |
startDate |
string |
Startdatum |
☐ |
The start date of attached booking items in Y-m-d format. |
status |
int64 |
Status |
☐ |
The status of the invoice. |
subTotal |
string |
Subtotaal |
☐ |
The sub-total price of the invoice line. |
surchargePercentage |
string |
Toeslagpercentage |
☐ |
The surcharge percentage of the invoice line. |
unitName |
string |
Eenheidsnaam |
☐ |
The name of the unit in the invoice line. |
unitPrice |
string |
Prijs per Eenheid |
☐ |
The unit price of the invoice line. |
updatedAt |
string |
Bijgewerkt op |
☐ |
The last updated time of the entity. |
updatedBy |
string |
Bijgewerkt door |
☐ |
The user that last updated the entity. |
vatShiftedValue |
string |
BTW verlegde waarde |
☐ |
VAT is shifted value. Usually a VAT-number of the contact. |
vatTariffId |
int64 |
BTW-tarief-ID |
☐ |
The VAT-tariff ID used on the invoice line. |
vatTariffPercentage |
string |
BTW-tariefpercentage |
☐ |
The VAT-tariff percentage used on the invoice line. Must be set to 0 if VAT is shifted. |
wageComponentAmount |
string |
Looncomponent Bedrag |
☐ |
Wage component amount. |
wageComponentPercentage |
string |
Looncomponent Percentage |
☐ |
Wage component percentage. |
workAddress |
string(255) |
Werkadres |
☐ |
The work address of the invoice. |
22-12-2022 21:20 Versie 22.1.101-BETA+3681