invantive documentation
Forum di supporto InvantiveAccedi / Registrati

newInvoiceForProject_ContactCustomAttributeValues: Bouw7 itgen_bouw7_newinvoiceforproject_contactcustomattributevalues_plural

Questa pagina non è ancora disponibile nella tua lingua; viene visualizzata la versione originale.

read only REST

  • Catalog: Bouw7
  • Schema: Invoicing
  • Label: itgen_bouw7_newinvoiceforproject_contactcustomattributevalues_plural

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

Can only retrieve data.

Summary

Returns the document of a new invoice.

API Source

  • Endpoint: /project/{project}/invoice/new
  • Operation: get /project/{project}/invoice/new

Performance Characteristics

Characteristic Value
Average access latency (ms) 90
Full scan rows per minute 241,000
Point query rows per minute 666

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
project `` Project ID

Table Columns

The columns of the table newInvoiceForProject_ContactCustomAttributeValues are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
attachEquipmentList char Attach Equipment List filters on the platform, writable, ::ancestor.::ancestor.attachEquipmentList Whether to attach the material list attachment.
attachGarbageList char Attach Garbage List filters on the platform, writable, ::ancestor.::ancestor.attachGarbageList Whether to attach the waste list attachment.
attachMaterialList char Attach Material List filters on the platform, writable, ::ancestor.::ancestor.attachMaterialList Whether to attach the material list attachment.
attachRegister char Attach Register filters on the platform, writable, ::ancestor.::ancestor.attachRegister Whether to attach the register attachment.
branch_code varchar2(255) Branch Code filters on the platform, writable, ::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.branch.division.description The description of the division.
branch_division_exactDivisionId varchar2 itgen_bouw7_branch_division_exactdivisionid filters on the platform, writable, ::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.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.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.branch.division.id The ID of the division.
branch_division_journalCode varchar2 itgen_bouw7_branch_division_journalcode filters on the platform, writable, ::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.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.branch.division.salesInvoiceNumberPrefix The prefix (3 digits) used to generate invoice number range per division.
branch_gAccountPercentage varchar2 Branch G-Account Percentage filters on the platform, writable, ::ancestor.::ancestor.branch.gAccountPercentage The g account percentage of the branch.
branch_gAccountText varchar2(255) Branch G-Account Text filters on the platform, writable, ::ancestor.::ancestor.branch.gAccountText The g account text of the branch.
branch_id int64 Branch ID filters on the platform, writable, ::ancestor.::ancestor.branch.id The ID of the branch.
branch_nAccountText varchar2(255) Branch N-Account Text filters on the platform, writable, ::ancestor.::ancestor.branch.nAccountText The n account text of the branch.
branch_name varchar2 Branch Name filters on the platform, writable, ::ancestor.::ancestor.branch.name The name of the branch.
branch_useOrganizationInfo char Branch Use Organisation Info filters on the platform, writable, ::ancestor.::ancestor.branch.useOrganizationInfo If organization information should be used instead of branch information.
branch_wageComponentPercentage varchar2 Branch Wage Component Percentage filters on the platform, writable, ::ancestor.::ancestor.branch.wageComponentPercentage The wage component percentage of the branch.
canBookToAfas char Can Book to AFAS filters on the platform, writable, ::ancestor.::ancestor.canBookToAfas Whether it is allowed to book to AFAS.
canBookToExact char Can Book to Exact filters on the platform, writable, ::ancestor.::ancestor.canBookToExact Whether it is allowed to book to Exact.
canBookToMareon char Can Book to Mareon filters on the platform, writable, ::ancestor.::ancestor.canBookToMareon Whether it is allowed to book to Mareon.
canBookToTwinfield char Can Book to Twinfield filters on the platform, writable, ::ancestor.::ancestor.canBookToTwinfield Whether it is allowed to book to Twinfield.
canUseCostCenter char Can Use Cost Centre filters on the platform, writable, ::ancestor.::ancestor.canUseCostCenter Whether the user can use cost center functionality.
city varchar2 City writable, ::ancestor.city The city of residence of the contact.
cocNumber varchar2 Chamber of Commerce Number writable, ::ancestor.cocNumber The chamber of commerce number of the contact.
contactPersonName varchar2 Contact Person Name writable, ::ancestor.contactPersonName The name of the contact person.
contactPersonName_2 varchar2 itgen_bouw7_contactpersonname_2 filters on the platform, writable, ::ancestor.::ancestor.contactPersonName The name of the contact person for this invoice.
contactPerson_city varchar2(255) Contact Person City filters on the platform, writable, ::ancestor.::ancestor.contactPerson.city The contact person's city.
contactPerson_createdAt datetime Contact Person Created at filters on the platform, writable, ::ancestor.::ancestor.contactPerson.createdAt The creation time of the entity.
contactPerson_createdBy varchar2 Contact Person Created by filters on the platform, writable, ::ancestor.::ancestor.contactPerson.createdBy The user that created the entity.
contactPerson_email varchar2(256) Contact Person Email filters on the platform, writable, ::ancestor.::ancestor.contactPerson.email The contact person's email address.
contactPerson_firstName varchar2(256) Contact Person First Name filters on the platform, writable, ::ancestor.::ancestor.contactPerson.firstName The contact person's first name.
contactPerson_houseNumber varchar2(50) Contact Person House Number filters on the platform, writable, ::ancestor.::ancestor.contactPerson.houseNumber The contact person's house number.
contactPerson_id int64 Contact Person ID filters on the platform, writable, ::ancestor.::ancestor.contactPerson.id The ID of contact person.
contactPerson_jobTitle varchar2(64) Contact Person Job Title filters on the platform, writable, ::ancestor.::ancestor.contactPerson.jobTitle The contact person's job title.
contactPerson_lastName varchar2(256) Contact Person Last Name filters on the platform, writable, ::ancestor.::ancestor.contactPerson.lastName The contact person's last name.
contactPerson_phoneNumber varchar2(255) Contact Person Phone Number filters on the platform, writable, ::ancestor.::ancestor.contactPerson.phoneNumber The contact person's phone number.
contactPerson_salutation varchar2(32) Contact Person Salutation filters on the platform, writable, ::ancestor.::ancestor.contactPerson.salutation The contact person's salutation.
contactPerson_streetName varchar2(255) Contact Person Street Name filters on the platform, writable, ::ancestor.::ancestor.contactPerson.streetName The contact person's street name.
contactPerson_updatedAt datetime Contact Person Updated at filters on the platform, writable, ::ancestor.::ancestor.contactPerson.updatedAt The last updated time of the entity.
contactPerson_updatedBy varchar2 Contact Person Updated by filters on the platform, writable, ::ancestor.::ancestor.contactPerson.updatedBy The user that last updated the entity.
contactPerson_zipCode varchar2(20) Contact Person ZIP Code filters on the platform, writable, ::ancestor.::ancestor.contactPerson.zipCode The contact person's zip code.
contactType_id int64 Contact Type ID writable, ::ancestor.contactType.id The ID of contact type.
contactType_name varchar2 Contact Type Name writable, ::ancestor.contactType.name The name of contact type.
country varchar2 Country writable, ::ancestor.country The country of the contact.
createdAt datetime Created at filters on the platform, writable, ::ancestor.::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Created by filters on the platform, writable, ::ancestor.::ancestor.createdBy The user that created the entity.
date datetime Date filters on the platform, writable, ::ancestor.::ancestor.date The invoice date.
datePaid varchar2 Date Paid filters on the platform, writable, ::ancestor.::ancestor.datePaid The paid date.
debtorNumber varchar2 Debtor Number writable, ::ancestor.debtorNumber The debtor number of the contact.
debtorNumber_2 varchar2 itgen_bouw7_debtornumber_2 filters on the platform, writable, ::ancestor.::ancestor.debtorNumber The debtor number of the contact associated with this invoice.
description varchar2 Description filters on the platform, writable, ::ancestor.::ancestor.description The public description for this invoice.
displayWorkAddress char Display Work Address filters on the platform, writable, ::ancestor.::ancestor.displayWorkAddress Whether the work address is displayed on the invoice.
division_description varchar2 Division Description filters on the platform, writable, ::ancestor.::ancestor.division.description The description of the division.
division_exactDivisionId varchar2 Division Exact Division ID filters on the platform, writable, ::ancestor.::ancestor.division.exactDivisionId The division ID of an Exact Online environment.
division_glAccountCode varchar2 Division General Ledger Account Code filters on the platform, writable, ::ancestor.::ancestor.division.glAccountCode A default general ledger account code to use for sales related items.
division_glAccountCodePurchase varchar2 Division General Ledger Account Code Purchase filters on the platform, writable, ::ancestor.::ancestor.division.glAccountCodePurchase A default general ledger account code to use for purchase related items.
division_id int64 Division ID filters on the platform, writable, ::ancestor.::ancestor.division.id The ID of the division.
division_journalCode varchar2 Division Journal Code filters on the platform, writable, ::ancestor.::ancestor.division.journalCode A default journal code to use for sales related items.
division_journalCodePurchase varchar2 Division Journal Code Purchase filters on the platform, writable, ::ancestor.::ancestor.division.journalCodePurchase A default journal code to use for purchase related items.
division_salesInvoiceNumberPrefix varchar2(3) Division Sales Invoice Number Prefix filters on the platform, writable, ::ancestor.::ancestor.division.salesInvoiceNumberPrefix The prefix (3 digits) used to generate invoice number range per division.
dueDate datetime Due Date filters on the platform, writable, ::ancestor.::ancestor.dueDate The invoice due date.
emailAddress varchar2 Email Address writable, ::ancestor.emailAddress The email-address of the contact.
endDate datetime End Date filters on the platform, writable, ::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.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.exactFinancialPeriod.financialPeriod The period of the exact financial period.
exactFinancialPeriod_financialYear int64 itgen_bouw7_exactfinancialperiod_financialyear filters on the platform, writable, ::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.exactFinancialPeriod.id The ID of the exact financial period.
exactFinancialPeriod_startDate datetime itgen_bouw7_exactfinancialperiod_startdate filters on the platform, writable, ::ancestor.::ancestor.exactFinancialPeriod.startDate The start date of the exact financial period in Y-m-d format.
exactPaymentCondition varchar2(255) Exact Payment Condition filters on the platform, writable, ::ancestor.::ancestor.exactPaymentCondition The code of the Exact Online payment condition for this invoice.
expirationReminderDays int64 Expiration Reminder Days writable, ::ancestor.expirationReminderDays The number of days before a reminder is sent.
gAccountAmount varchar2 G-Account Amount filters on the platform, writable, ::ancestor.::ancestor.gAccountAmount G-account amount.
gAccountPercentage varchar2 G-Account Percentage writable, ::ancestor.gAccountPercentage G-account percentage.
gAccountPercentage_2 varchar2 itgen_bouw7_gaccountpercentage_2 filters on the platform, writable, ::ancestor.::ancestor.gAccountPercentage G-account percentage.
gAccountText varchar2(255) G-Account Text writable, ::ancestor.gAccountText G-account text.
gAccountText_2 varchar2(255) itgen_bouw7_gaccounttext_2 filters on the platform, writable, ::ancestor.::ancestor.gAccountText G-account text.
glnNumber varchar2(13) GLN Number writable, ::ancestor.glnNumber The Global Location Number.
houseNumber varchar2 House Number writable, ::ancestor.houseNumber The house- or building-number of the contact.
iban varchar2 IBAN writable, ::ancestor.iban The IBAN-account number of the contact.
id int64 ID writable, ::ancestor.id The ID of the contact.
id_2 int64 ID filters on the platform, writable, ::ancestor.::ancestor.id The ID of the invoice. Must be omitted to create a new invoice.
includeCoverSheet char Include Cover Sheet filters on the platform, writable, ::ancestor.::ancestor.includeCoverSheet Whether to include a cover sheet to the invoice PDF.
internalNote varchar2 Internal Note filters on the platform, writable, ::ancestor.::ancestor.internalNote The internal note for this invoice.
invoiceMail varchar2 Invoice Mail writable, ::ancestor.invoiceMail The invoice mail.
invoiceNumber varchar2 Invoice Number filters on the platform, writable, ::ancestor.::ancestor.invoiceNumber The number of this invoice.
invoiceUblVersion varchar2 Invoice UBL Version writable, ::ancestor.invoiceUblVersion The preferred UBL invoice version for this contact.
invoicedProjectStatusName varchar2 Invoiced Project Status Name filters on the platform, writable, ::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 Booked filters on the platform, writable, ::ancestor.::ancestor.isBooked Whether the invoice is already booked.
isCollective char Is Collective filters on the platform, writable, ::ancestor.::ancestor.isCollective Whether the invoice is a collective invoice.
isCredit char Is Credit filters on the platform, writable, ::ancestor.::ancestor.isCredit Whether this invoice is a credit invoice.
isMareonBooked char Is Mareon Booked filters on the platform, writable, ::ancestor.::ancestor.isMareonBooked Whether the invoice is already booked in mareon.
isVatShifted char Is VAT Shifted writable, ::ancestor.isVatShifted Whether VAT is shifted for the contact.
isVatShifted_2 char itgen_bouw7_isvatshifted_2 filters on the platform, writable, ::ancestor.::ancestor.isVatShifted Whether VAT is shifted for the invoice.
language varchar2 Language filters on the platform, writable, ::ancestor.::ancestor.language The locale used by this invoice document, e.g.: nl-NL.
nAccountText varchar2(255) N-Account Text writable, ::ancestor.nAccountText N-account text.
nAccountText_2 varchar2(255) itgen_bouw7_naccounttext_2 filters on the platform, writable, ::ancestor.::ancestor.nAccountText N-account text.
name varchar2 Name writable, ::ancestor.name The name of the contact.
organization_city varchar2 Organisation City filters on the platform, writable, ::ancestor.::ancestor.organization.city The city of residence of the supplier.
organization_cocNumber varchar2 Organisation CoC Number filters on the platform, writable, ::ancestor.::ancestor.organization.cocNumber The chamber of commerce number of the supplier.
organization_country varchar2 Organisation Country filters on the platform, writable, ::ancestor.::ancestor.organization.country The country of the supplier.
organization_emailAddress varchar2 Organisation Email Address filters on the platform, writable, ::ancestor.::ancestor.organization.emailAddress The email-address of the supplier.
organization_expirationReminderDays int64 Organisation Expiration Reminder Days filters on the platform, writable, ::ancestor.::ancestor.organization.expirationReminderDays The number of days before a reminder is sent.
organization_gAccountPercentage varchar2 Organisation G-Account Percentage filters on the platform, writable, ::ancestor.::ancestor.organization.gAccountPercentage The g account percentage for the customer.
organization_gAccountText varchar2 Organisation G-Account Text filters on the platform, writable, ::ancestor.::ancestor.organization.gAccountText The g account text for the customer.
organization_houseNumber varchar2 Organisation House Number filters on the platform, writable, ::ancestor.::ancestor.organization.houseNumber The house- or building-number of the supplier.
organization_iban varchar2 Organisation IBAN filters on the platform, writable, ::ancestor.::ancestor.organization.iban The IBAN-account number of the supplier.
organization_logo_createdAt datetime Organisation Logo Created at filters on the platform, writable, ::ancestor.::ancestor.organization.logo.createdAt The creation time of the entity.
organization_logo_createdBy varchar2 Organisation Logo Created by filters on the platform, writable, ::ancestor.::ancestor.organization.logo.createdBy The user that created the entity.
organization_logo_extension varchar2 Organisation Logo Extension filters on the platform, writable, ::ancestor.::ancestor.organization.logo.extension The extension of the file.
organization_logo_id int64 Organisation Logo ID filters on the platform, writable, ::ancestor.::ancestor.organization.logo.id The ID of this file
organization_logo_modelId int64 Organisation Logo Model ID filters on the platform, writable, ::ancestor.::ancestor.organization.logo.modelId The ID of the associated type.
organization_logo_modelType varchar2 Organisation Logo Model Type filters on the platform, writable, ::ancestor.::ancestor.organization.logo.modelType The category of the file.
organization_logo_name varchar2 Organisation Logo Name filters on the platform, writable, ::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.organization.logo.secureHash A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication.
organization_logo_size int64 Organisation Logo Size filters on the platform, writable, ::ancestor.::ancestor.organization.logo.size The size of the file in bytes.
organization_logo_updatedAt datetime Organisation Logo Updated at filters on the platform, writable, ::ancestor.::ancestor.organization.logo.updatedAt The last updated time of the entity.
organization_logo_updatedBy varchar2 Organisation Logo Updated by filters on the platform, writable, ::ancestor.::ancestor.organization.logo.updatedBy The user that last updated the entity.
organization_logo_uri varchar2 Organisation Logo URI filters on the platform, writable, ::ancestor.::ancestor.organization.logo.uri The URI of the file, used to fetch the contents.
organization_nAccountText varchar2 Organisation N-Account Text filters on the platform, writable, ::ancestor.::ancestor.organization.nAccountText The n account text for the customer.
organization_name varchar2 Organisation Name filters on the platform, writable, ::ancestor.::ancestor.organization.name The name of the supplier.
organization_phoneNumber varchar2 Organisation Phone Number filters on the platform, writable, ::ancestor.::ancestor.organization.phoneNumber The phone number of the supplier.
organization_shouldCopyProjectDescription char Organisation Should Copy Project Description filters on the platform, writable, ::ancestor.::ancestor.organization.shouldCopyProjectDescription Whether the project description should be copied.
organization_showProjectNameOnInvoicePdf char Organisation Show Project Name on Invoice PDF filters on the platform, writable, ::ancestor.::ancestor.organization.showProjectNameOnInvoicePdf Whether the project name will show on the invoice.
organization_showProjectNumberOnInvoice char Organisation Show Project Number on Invoice filters on the platform, writable, ::ancestor.::ancestor.organization.showProjectNumberOnInvoice Whether the project number will show on the invoice.
organization_streetName varchar2 Organisation Street Name filters on the platform, writable, ::ancestor.::ancestor.organization.streetName The street name of the supplier.
organization_vatNumber varchar2 Organisation VAT Number filters on the platform, writable, ::ancestor.::ancestor.organization.vatNumber The VAT-number of the supplier.
organization_wageComponentPercentage varchar2 Organisation Wage Component Percentage filters on the platform, writable, ::ancestor.::ancestor.organization.wageComponentPercentage The wage component percentage for the customer.
organization_websiteAddress varchar2 Organisation Website Address filters on the platform, writable, ::ancestor.::ancestor.organization.websiteAddress The website address of the supplier.
organization_zipCode varchar2 Organisation ZIP Code filters on the platform, writable, ::ancestor.::ancestor.organization.zipCode The zip-code of the supplier.
phoneNumber varchar2 Phone Number writable, ::ancestor.phoneNumber The phone number of the contact.
project_fullProjectNumber varchar2 Project Full Project Number filters on the platform, writable, ::ancestor.::ancestor.project.fullProjectNumber The full project number including year.
project_id int64 Project ID filters on the platform, writable, ::ancestor.::ancestor.project.id The ID of the project.
project_name varchar2 Project Name filters on the platform, writable, ::ancestor.::ancestor.project.name The name of the project.
project_reference varchar2 Project Reference filters on the platform, writable, ::ancestor.::ancestor.project.reference The reference of the project.
project_value varchar2 itgen_bouw7_project_value filters on the platform, writable, ::ancestor.::ancestor.project.customAttributeValues[*].value The value of the custom attribute.
project_workAddress varchar2 Project Work Address filters on the platform, writable, ::ancestor.::ancestor.project.workAddress The work address of the project.
startDate datetime Start Date filters on the platform, writable, ::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.status The status of the invoice.
streetName varchar2 Street Name writable, ::ancestor.streetName The street name of the contact.
updatedAt datetime Updated At filters on the platform, writable, ::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by filters on the platform, writable, ::ancestor.::ancestor.updatedBy The user that last updated the entity.
value varchar2 Value writable, value The value of the custom attribute.
vatNumber varchar2 VAT Number writable, ::ancestor.vatNumber The VAT-number of the contact.
vatShiftedValue varchar2(255) VAT Shifted Value filters on the platform, writable, ::ancestor.::ancestor.vatShiftedValue VAT is shifted value. Usually a VAT-number of the contact.
wageComponentAmount varchar2 Wage Component Amount filters on the platform, writable, ::ancestor.::ancestor.wageComponentAmount Wage component amount.
wageComponentPercentage varchar2 Wage Component Percentage writable, ::ancestor.wageComponentPercentage Wage component percentage.
wageComponentPercentage_2 varchar2 itgen_bouw7_wagecomponentpercentage_2 filters on the platform, writable, ::ancestor.::ancestor.wageComponentPercentage Wage component percentage.
workAddress varchar2(255) Work Address filters on the platform, writable, ::ancestor.::ancestor.workAddress The work address of the invoice.
zipCode varchar2 ZIP Code writable, ::ancestor.zipCode The zip-code of the contact.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: