Invoice_ProjectCustomAttributeValues: Bouw7 itgen_bouw7_invoice_projectcustomattributevalues_plural
read only REST
- Catalogus:
Bouw7 - Schema:
Invoicing - Label: itgen_bouw7_invoice_projectcustomattributevalues_plural
Returns the document of an existing invoice. Returns the document of a new invoice.
Kan alleen gegevens ophalen.
Samenvatting
Returns the document of a new invoice.
API-bron
- Eindpunt:
/invoice/{invoice} - Operatie:
get /invoice/{invoice}
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 |
|---|---|---|---|---|
invoice |
`` | Factuur ID |
Tabelkolommen
De kolommen van de tabel Invoice_ProjectCustomAttributeValues 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 |
|---|---|---|---|---|---|
attach |
char |
Voeg Materieellijst bij | filters on the platform, writable, ::ancestor. |
Whether to attach the material list attachment. | |
attach |
char |
Voeg Afvallijst bij | filters on the platform, writable, ::ancestor. |
Whether to attach the waste list attachment. | |
attach |
char |
Voeg Materiaallijst bij | filters on the platform, writable, ::ancestor. |
Whether to attach the material list attachment. | |
attach |
char |
Voeg Register bij | filters on the platform, writable, ::ancestor. |
Whether to attach the register attachment. | |
branch_ |
varchar2 |
Vestigingscode | filters on the platform, writable, ::ancestor. |
The code of the branch. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_description | filters on the platform, writable, ::ancestor. |
The description of the division. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_exactdivisionid | filters on the platform, writable, ::ancestor. |
The division ID of an Exact Online environment. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_glaccountcode | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for sales related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_glaccountcodepurchase | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for purchase related items. | |
branch_ |
int64 |
itgen_bouw7_branch_division_id | filters on the platform, writable, ::ancestor. |
The ID of the division. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_journalcode | filters on the platform, writable, ::ancestor. |
A default journal code to use for sales related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_journalcodepurchase | filters on the platform, writable, ::ancestor. |
A default journal code to use for purchase related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_salesinvoicenumberprefix | filters on the platform, writable, ::ancestor. |
The prefix (3 digits) used to generate invoice number range per division. | |
branch_ |
varchar2 |
Filiaal G-Rekeningpercentage | filters on the platform, writable, ::ancestor. |
The g account percentage of the branch. | |
branch_ |
varchar2 |
Filiaal G-Rekeningtekst | filters on the platform, writable, ::ancestor. |
The g account text of the branch. | |
branch_ |
int64 |
Vestiging-ID | filters on the platform, writable, ::ancestor. |
The ID of the branch. | |
branch_ |
varchar2 |
Filiaal N-Rekeningtekst | filters on the platform, writable, ::ancestor. |
The n account text of the branch. | |
branch_ |
varchar2 |
Filiaalnaam | filters on the platform, writable, ::ancestor. |
The name of the branch. | |
branch_ |
char |
Filiaal Gebruik Organisatie-informatie | filters on the platform, writable, ::ancestor. |
If organization information should be used instead of branch information. | |
branch_ |
varchar2 |
Filiaal Looncomponentpercentage | filters on the platform, writable, ::ancestor. |
The wage component percentage of the branch. | |
can |
char |
Kan Boeken naar AFAS | filters on the platform, writable, ::ancestor. |
Whether it is allowed to book to AFAS. | |
can |
char |
Kan Boeken naar Exact | filters on the platform, writable, ::ancestor. |
Whether it is allowed to book to Exact. | |
can |
char |
Kan Boeken naar Mareon | filters on the platform, writable, ::ancestor. |
Whether it is allowed to book to Mareon. | |
can |
char |
Kan Boeken naar Twinfield | filters on the platform, writable, ::ancestor. |
Whether it is allowed to book to Twinfield. | |
can |
char |
Kan Kostenplaats Gebruiken | filters on the platform, writable, ::ancestor. |
Whether the user can use cost center functionality. | |
contact |
varchar2 |
Contactpersoonnaam | filters on the platform, writable, ::ancestor. |
The name of the contact person for this invoice. | |
contact |
varchar2 |
Contactpersoon Stad | filters on the platform, writable, ::ancestor. |
The contact person's city. | |
contact |
datetime |
Contactpersoon Aangemaakt op | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
contact |
varchar2 |
Contactpersoon Aangemaakt door | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
contact |
varchar2 |
Contactpersoon E-mail | filters on the platform, writable, ::ancestor. |
The contact person's email address. | |
contact |
varchar2 |
Contactpersoon Voornaam | filters on the platform, writable, ::ancestor. |
The contact person's first name. | |
contact |
varchar2 |
Contactpersoon Huisnummer | filters on the platform, writable, ::ancestor. |
The contact person's house number. | |
contact |
int64 |
Contactpersoon ID | filters on the platform, writable, ::ancestor. |
The ID of contact person. | |
contact |
varchar2 |
Contactpersoon Functietitel | filters on the platform, writable, ::ancestor. |
The contact person's job title. | |
contact |
varchar2 |
Contactpersoon Achternaam | filters on the platform, writable, ::ancestor. |
The contact person's last name. | |
contact |
varchar2 |
Contactpersoon Telefoonnummer | filters on the platform, writable, ::ancestor. |
The contact person's phone number. | |
contact |
varchar2 |
Contactpersoon Aanhef | filters on the platform, writable, ::ancestor. |
The contact person's salutation. | |
contact |
varchar2 |
Contactpersoon Straatnaam | filters on the platform, writable, ::ancestor. |
The contact person's street name. | |
contact |
datetime |
Contactpersoon Bijgewerkt op | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
contact |
varchar2 |
Contactpersoon Bijgewerkt door | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
contact |
varchar2 |
Contactpersoon Postcode | filters on the platform, writable, ::ancestor. |
The contact person's zip code. | |
contact_ |
varchar2 |
Contact Stad | filters on the platform, writable, ::ancestor. |
The city of residence of the contact. | |
contact_ |
varchar2 |
Contact KvK-nummer | filters on the platform, writable, ::ancestor. |
The chamber of commerce number of the contact. | |
contact_ |
varchar2 |
Contact Contactpersoon Naam | filters on the platform, writable, ::ancestor. |
The name of the contact person. | |
contact_ |
int64 |
Contact Soort ID | filters on the platform, writable, ::ancestor. |
The ID of contact type. | |
contact_ |
varchar2 |
Contact Soort Naam | filters on the platform, writable, ::ancestor. |
The name of contact type. | |
contact_ |
varchar2 |
Contactpersoon Land | filters on the platform, writable, ::ancestor. |
The country of the contact. | |
contact_ |
varchar2 |
Contact Debiteurnummer | filters on the platform, writable, ::ancestor. |
The debtor number of the contact. | |
contact_ |
varchar2 |
Contactpersoon E-mailadres | filters on the platform, writable, ::ancestor. |
The email-address of the contact. | |
contact_ |
int64 |
Contact Vervaldatum Herinneringsdagen | filters on the platform, writable, ::ancestor. |
The number of days before a reminder is sent. | |
contact_ |
varchar2 |
Contact G-Rekeningpercentage | filters on the platform, writable, ::ancestor. |
G-account percentage. | |
contact_ |
varchar2 |
Contact G-Rekeningtekst | filters on the platform, writable, ::ancestor. |
G-account text. | |
contact_ |
varchar2 |
itgen_bouw7_contact_glnnumber | filters on the platform, writable, ::ancestor. |
The Global Location Number. | |
contact_ |
varchar2 |
Contact Huisnummer | filters on the platform, writable, ::ancestor. |
The house- or building-number of the contact. | |
contact_ |
varchar2 |
Contact IBAN | filters on the platform, writable, ::ancestor. |
The IBAN-account number of the contact. | |
contact_ |
int64 |
Contactpersoon ID | filters on the platform, writable, ::ancestor. |
The ID of the contact. | |
contact_ |
varchar2 |
itgen_bouw7_contact_invoicemail | filters on the platform, writable, ::ancestor. |
The invoice mail. | |
contact_ |
varchar2 |
Contact Factuur UBL-Versie | filters on the platform, writable, ::ancestor. |
The preferred UBL invoice version for this contact. | |
contact_ |
char |
Contact is BTW Verlegd | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
contact_ |
varchar2 |
Contact N-Rekening Tekst | filters on the platform, writable, ::ancestor. |
N-account text. | |
contact_ |
varchar2 |
Contactpersoon Naam | filters on the platform, writable, ::ancestor. |
The name of the contact. | |
contact_ |
varchar2 |
Contact Telefoonnummer | filters on the platform, writable, ::ancestor. |
The phone number of the contact. | |
contact_ |
varchar2 |
Contact Straatnaam | filters on the platform, writable, ::ancestor. |
The street name of the contact. | |
contact_ |
varchar2 |
itgen_bouw7_contact_value | filters on the platform, writable, ::ancestor. |
The value of the custom attribute. | |
contact_ |
varchar2 |
Contact BTW-nummer | filters on the platform, writable, ::ancestor. |
The VAT-number of the contact. | |
contact_ |
varchar2 |
Contact Looncomponent Percentage | filters on the platform, writable, ::ancestor. |
Wage component percentage. | |
contact_ |
varchar2 |
Contactpersoon Postcode | filters on the platform, writable, ::ancestor. |
The zip-code of the contact. | |
created |
datetime |
Aangemaakt op | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
created |
varchar2 |
Gemaakt door | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
date |
datetime |
Date | filters on the platform, writable, ::ancestor. |
The invoice date. | |
date |
varchar2 |
Datum van Betaling | filters on the platform, writable, ::ancestor. |
The paid date. | |
debtor |
varchar2 |
Debiteurnummer | filters on the platform, writable, ::ancestor. |
The debtor number of the contact associated with this invoice. | |
description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
The public description for this invoice. | |
display |
char |
Weergeven Adres van Werk | filters on the platform, writable, ::ancestor. |
Whether the work address is displayed on the invoice. | |
division_ |
varchar2 |
Divisie Omschrijving | filters on the platform, writable, ::ancestor. |
The description of the division. | |
division_ |
varchar2 |
Divisie Exact Divisie-ID | filters on the platform, writable, ::ancestor. |
The division ID of an Exact Online environment. | |
division_ |
varchar2 |
Administratie Grootboekrekeningcode | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for sales related items. | |
division_ |
varchar2 |
Administratie Grootboekrekeningcode Inkoop | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for purchase related items. | |
division_ |
int64 |
Divisie ID | filters on the platform, writable, ::ancestor. |
The ID of the division. | |
division_ |
varchar2 |
Administratie Dagboekcode | filters on the platform, writable, ::ancestor. |
A default journal code to use for sales related items. | |
division_ |
varchar2 |
Administratie Dagboekcode Inkoop | filters on the platform, writable, ::ancestor. |
A default journal code to use for purchase related items. | |
division_ |
varchar2 |
Administratie Verkoopfactuurnummervoorvoegsel | filters on the platform, writable, ::ancestor. |
The prefix (3 digits) used to generate invoice number range per division. | |
due |
datetime |
Vervaldag | filters on the platform, writable, ::ancestor. |
The invoice due date. | |
end |
datetime |
Einddatum | filters on the platform, writable, ::ancestor. |
The end date of attached booking items in Y-m-d format. | |
exact |
datetime |
itgen_bouw7_exactfinancialperiod_enddate | filters on the platform, writable, ::ancestor. |
The end date of the exact financial period in Y-m-d format. | |
exact |
int64 |
itgen_bouw7_exactfinancialperiod_financialperiod | filters on the platform, writable, ::ancestor. |
The period of the exact financial period. | |
exact |
int64 |
itgen_bouw7_exactfinancialperiod_financialyear | filters on the platform, writable, ::ancestor. |
The year of the exact financial period. | |
exact |
int64 |
itgen_bouw7_exactfinancialperiod_id | filters on the platform, writable, ::ancestor. |
The ID of the exact financial period. | |
exact |
datetime |
itgen_bouw7_exactfinancialperiod_startdate | filters on the platform, writable, ::ancestor. |
The start date of the exact financial period in Y-m-d format. | |
exact |
varchar2 |
Exact Betalingsconditie | filters on the platform, writable, ::ancestor. |
The code of the Exact Online payment condition for this invoice. | |
full |
varchar2 |
Volledig Projectnummer | writable, ::ancestor. |
The full project number including year. | |
g |
varchar2 |
G-Rekening Bedrag | filters on the platform, writable, ::ancestor. |
G-account amount. | |
g |
varchar2 |
G-rekening Percentage | filters on the platform, writable, ::ancestor. |
G-account percentage. | |
g |
varchar2 |
G-Rekening Tekst | filters on the platform, writable, ::ancestor. |
G-account text. | |
id |
int64 |
ID | writable, ::ancestor. |
The ID of the project. | |
id_2 |
int64 |
ID | filters on the platform, writable, ::ancestor. |
The ID of the invoice.Must be omitted to create a new invoice. | |
include |
char |
Inclusief Voorblad | filters on the platform, writable, ::ancestor. |
Whether to include a cover sheet to the invoice PDF. | |
internal |
varchar2 |
Interne Notitie | filters on the platform, writable, ::ancestor. |
The internal note for this invoice. | |
invoice |
varchar2 |
Factuurnummer | filters on the platform, writable, ::ancestor. |
The number of this invoice. | |
invoiced |
varchar2 |
Gefactureerd Projectstatusnaam | filters on the platform, writable, ::ancestor. |
The status name of the projects if the status is going to be changed when an invoice is saved. | |
is |
char |
Is Geboekt | filters on the platform, writable, ::ancestor. |
Whether the invoice is already booked. | |
is |
char |
Is Collectief | filters on the platform, writable, ::ancestor. |
Whether the invoice is a collective invoice. | |
is |
char |
Is Credit | filters on the platform, writable, ::ancestor. |
Whether this invoice is a credit invoice. | |
is |
char |
Is Mareon geboekt | filters on the platform, writable, ::ancestor. |
Whether the invoice is already booked in mareon. | |
is |
char |
Is BTW Verlegd | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the invoice. | |
language |
varchar2 |
Language | filters on the platform, writable, ::ancestor. |
The locale used by this invoice document, e.g.: nl-NL. | |
n |
varchar2 |
N-Rekening Tekst | filters on the platform, writable, ::ancestor. |
N-account text. | |
name |
varchar2 |
Name | writable, ::ancestor. |
The name of the project. | |
organization_ |
varchar2 |
Organisatie Stad | filters on the platform, writable, ::ancestor. |
The city of residence of the supplier. | |
organization_ |
varchar2 |
Organisatie KvK-nummer | filters on the platform, writable, ::ancestor. |
The chamber of commerce number of the supplier. | |
organization_ |
varchar2 |
Organisatie Land | filters on the platform, writable, ::ancestor. |
The country of the supplier. | |
organization_ |
varchar2 |
Organisatie E-mailadres | filters on the platform, writable, ::ancestor. |
The email-address of the supplier. | |
organization_ |
int64 |
Organisatie Vervaldatum Herinneringsdagen | filters on the platform, writable, ::ancestor. |
The number of days before a reminder is sent. | |
organization_ |
varchar2 |
Organisatie G-rekening Percentage | filters on the platform, writable, ::ancestor. |
The g account percentage for the customer. | |
organization_ |
varchar2 |
Organisatie G-rekening Tekst | filters on the platform, writable, ::ancestor. |
The g account text for the customer. | |
organization_ |
varchar2 |
Organisatie Huisnummer | filters on the platform, writable, ::ancestor. |
The house- or building-number of the supplier. | |
organization_ |
varchar2 |
Organisatie IBAN | filters on the platform, writable, ::ancestor. |
The IBAN-account number of the supplier. | |
organization_ |
datetime |
Organisatielogo Gemaakt op | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
organization_ |
varchar2 |
Organisatielogo Gemaakt door | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
organization_ |
varchar2 |
Organisatielogo-extensie | filters on the platform, writable, ::ancestor. |
The extension of the file. | |
organization_ |
int64 |
Organisatielogo-ID | filters on the platform, writable, ::ancestor. |
The ID of this file | |
organization_ |
int64 |
Organisatielogo Model-ID | filters on the platform, writable, ::ancestor. |
The ID of the associated type. | |
organization_ |
varchar2 |
Organisatie Logo Modeltype | filters on the platform, writable, ::ancestor. |
The category of the file. | |
organization_ |
varchar2 |
Organisatie Logonaam | filters on the platform, writable, ::ancestor. |
The public name of the file. | |
organization_ |
varchar2 |
itgen_bouw7_organization_logo_securehash | filters on the platform, writable, ::ancestor. |
A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. | |
organization_ |
int64 |
Organisatie Logogrootte | filters on the platform, writable, ::ancestor. |
The size of the file in bytes. | |
organization_ |
datetime |
Organisatie Logo Bijgewerkt op | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
organization_ |
varchar2 |
Organisatie Logo Bijgewerkt door | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
organization_ |
varchar2 |
Organisatielogo-URI | filters on the platform, writable, ::ancestor. |
The URI of the file, used to fetch the contents. | |
organization_ |
varchar2 |
Organisatie N-Rekening Tekst | filters on the platform, writable, ::ancestor. |
The n account text for the customer. | |
organization_ |
varchar2 |
Organisatienaam | filters on the platform, writable, ::ancestor. |
The name of the supplier. | |
organization_ |
varchar2 |
Organisatie Telefoonnummer | filters on the platform, writable, ::ancestor. |
The phone number of the supplier. | |
organization_ |
char |
Organisatie moet Projectomschrijving Kopiëren | filters on the platform, writable, ::ancestor. |
Whether the project description should be copied. | |
organization_ |
char |
Organisatie Toon Projectnaam op Factuur PDF | filters on the platform, writable, ::ancestor. |
Whether the project name will show on the invoice. | |
organization_ |
char |
Organisatie Toon Projectnummer op Factuur | filters on the platform, writable, ::ancestor. |
Whether the project number will show on the invoice. | |
organization_ |
varchar2 |
Organisatie Straatnaam | filters on the platform, writable, ::ancestor. |
The street name of the supplier. | |
organization_ |
varchar2 |
Organisatie BTW-nummer | filters on the platform, writable, ::ancestor. |
The VAT-number of the supplier. | |
organization_ |
varchar2 |
Organisatie Looncomponent Percentage | filters on the platform, writable, ::ancestor. |
The wage component percentage for the customer. | |
organization_ |
varchar2 |
Organisatie Website-adres | filters on the platform, writable, ::ancestor. |
The website address of the supplier. | |
organization_ |
varchar2 |
Organisatie Postcode | filters on the platform, writable, ::ancestor. |
The zip-code of the supplier. | |
reference |
varchar2 |
Reference | writable, ::ancestor. |
The reference of the project. | |
start |
datetime |
Startdatum | filters on the platform, writable, ::ancestor. |
The start date of attached booking items in Y-m-d format. | |
status |
int64 |
Status | filters on the platform, writable, ::ancestor. |
The status of the invoice. | |
updated |
datetime |
Bijgewerkt op | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
updated |
varchar2 |
Bijgewerkt door | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
value |
varchar2 |
Value | writable, value |
The value of the custom attribute. | |
vat |
varchar2 |
BTW-verlegde Waarde | filters on the platform, writable, ::ancestor. |
VAT is shifted value.Usually a VAT-number of the contact. | |
wage |
varchar2 |
Looncomponent Bedrag | filters on the platform, writable, ::ancestor. |
Wage component amount. | |
wage |
varchar2 |
Looncomponent Percentage | filters on the platform, writable, ::ancestor. |
Wage component percentage. | |
work |
varchar2 |
Werkadres | writable, ::ancestor. |
The work address of the project. | |
work |
varchar2 |
itgen_bouw7_workaddress_2 | filters on the platform, writable, ::ancestor. |
The work address of the invoice. |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: