PurchaseInvoiceLines: Bouw7 Inkoop Factuurregels |
Catalogus: Bouw7
Schema: Views
Label: Inkoop Factuurregels
Dit is een alleen-lezen view. 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.
View Kolommen
De kolommen van de view PurchaseInvoiceLines worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
approval_canApprove |
boolean |
{res:itgen_bouw7_approval_canapprove} |
☐ |
Whether or not the current authenticated user can approve the approval. |
approval_createdAt |
datetime |
{res:itgen_bouw7_approval_createdat} |
☐ |
The creation time of the entity. |
approval_createdBy |
string |
{res:itgen_bouw7_approval_createdby} |
☐ |
The user that created the entity. |
approval_currentApprover_approvalDate |
datetime |
{res:itgen_bouw7_approval_currentapprover_approvaldate} |
☐ |
The date at which the approver denied/approved the approval. |
approval_currentApprover_approvalStatus |
int64 |
{res:itgen_bouw7_approval_currentapprover_approvalstatus} |
☐ |
The approval status of this approver. |
approval_currentApprover_comment |
string |
{res:itgen_bouw7_approval_currentapprover_comment} |
☐ |
Comment left by the approver. Can be null. |
approval_currentApprover_createdAt |
datetime |
{res:itgen_bouw7_approval_currentapprover_createdat} |
☐ |
The creation time of the entity. |
approval_currentApprover_createdBy |
string |
{res:itgen_bouw7_approval_currentapprover_createdby} |
☐ |
The user that created the entity. |
approval_currentApprover_id |
int64 |
{res:itgen_bouw7_approval_currentapprover_id} |
☐ |
ID of the approver. |
approval_currentApprover_index |
int64 |
{res:itgen_bouw7_approval_currentapprover_index} |
☐ |
Current index of the approver. |
approval_currentApprover_updatedAt |
datetime |
{res:itgen_bouw7_approval_currentapprover_updatedat} |
☐ |
The last updated time of the entity. |
approval_currentApprover_updatedBy |
string |
{res:itgen_bouw7_approval_currentapprover_updatedby} |
☐ |
The user that last updated the entity. |
approval_currentIndex |
int64 |
{res:itgen_bouw7_approval_currentindex} |
☐ |
The current index of the approver which turn it is to vote on the approval. |
approval_id |
int64 |
{res:itgen_bouw7_approval_id} |
☐ |
ID of the approval. |
approval_isApproved |
boolean |
{res:itgen_bouw7_approval_isapproved} |
☐ |
Whether or not the approval has been approved. |
approval_lastActionDate |
datetime |
{res:itgen_bouw7_approval_lastactiondate} |
☐ |
Date of the last action done to this approval. Will be null when no action has been made. |
approval_updatedAt |
datetime |
{res:itgen_bouw7_approval_updatedat} |
☐ |
The last updated time of the entity. |
approval_updatedBy |
string |
{res:itgen_bouw7_approval_updatedby} |
☐ |
The user that last updated the entity. |
approval_workflowId |
int64 |
{res:itgen_bouw7_approval_workflowid} |
☐ |
The workflow that this approval is based of. |
bookNumber |
int64 |
Boeknummer |
☐ |
The booknumber of the purchase invoice. |
branch_code |
string |
Vestigingscode |
☐ |
The code for this 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_id |
int64 |
Vestiging-ID |
☐ |
The ID of the branch. |
branch_name |
string |
Filiaalnaam |
☐ |
The name of this branch |
canBeDeleted |
boolean |
Kan Verwijderd Worden |
☐ |
Whether the invoice can be deleted. |
canBeEdited |
boolean |
Kan Bewerkt Worden |
☐ |
Whether the line can be edited or removed. |
canBookToExact |
boolean |
Kan Boeken naar Exact |
☐ |
Whether it is allowed to book to Exact. |
canBookToTwinfield |
boolean |
Kan Boeken naar Twinfield |
☐ |
Whether it is allowed to book to Twinfield. |
canUseCostCenter |
boolean |
Kan Kostenplaats Gebruiken |
☐ |
True if the user can use cost center functionality. |
chainLiabilityDocumentExpirationDate |
datetime |
Vervaldatum Document Ketenaansprakelijkheid |
☐ |
The newest expiration date of the chain liability document(s) associated with the contact, in ATOM format. |
comments |
string |
Aantekeningen |
☐ |
Comment associated with the purchase invoice. |
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_email |
string |
Contact E-mail |
☐ |
The email address. |
contact_id |
int64 |
Contactpersoon ID |
☐ |
ID of contact. |
contact_isVatShifted |
boolean |
Contact is BTW Verlegd |
☐ |
Whether VAT is shifted for the contact. |
contact_name |
string |
Contactpersoon Naam |
☐ |
Name of contact. |
contact_phoneNumber |
string |
Contact Telefoonnummer |
☐ |
The phone number of the contact. |
costCenter |
string |
Kostenplaats |
☐ |
A reference to the cost center associated with the invoice line. |
createdAt_2 |
datetime |
Aangemaakt op |
☐ |
The creation time of the entity. |
createdAt |
datetime |
Aangemaakt op |
☐ |
The creation time of the entity. |
createdBy_2 |
string |
Gemaakt door |
☐ |
The user that created the entity. |
createdBy |
string |
Gemaakt door |
☐ |
The user that created the entity. |
createDeliveryTicket |
boolean |
Maak Afleverbon |
☐ |
Whether or not to create a delivery ticket. |
createDeliveryTicketForRemainingCosts_2 |
boolean |
{res:itgen_bouw7_createdeliveryticketforremainingcosts_2} |
☐ |
Whether or not to create a delivery ticket for the remaining costs. |
createDeliveryTicketForRemainingCosts |
boolean |
Leveringsbewijs Maken voor Resterende Kosten |
☐ |
Whether or not to create a delivery ticket for remaining costs between this line and the delivery ticket |
date |
datetime |
Datum |
☐ |
Purchase invoice date. |
datePaid |
string |
Datum van Betaling |
☐ |
Purchase invoice paid date. |
deliveryTicket_cost_2 |
string |
{res:itgen_bouw7_deliveryticket_cost_2} |
☐ |
The costs for this delivery ticket. |
deliveryTicket_cost |
string |
Leverbon Kosten |
☐ |
The costs for this delivery ticket. |
deliveryTicket_id_2 |
int64 |
{res:itgen_bouw7_deliveryticket_id_2} |
☐ |
The ID of delivery ticket. |
deliveryTicket_id |
int64 |
Leverbon ID |
☐ |
The ID of delivery ticket. |
deliveryTicket_initialCost_2 |
string |
{res:itgen_bouw7_deliveryticket_initialcost_2} |
☐ |
The initial costs for this delivery ticket. |
deliveryTicket_initialCost |
string |
Leverbon Initiële Kosten |
☐ |
The initial costs for this delivery ticket. |
deliveryTicket_processed_2 |
boolean |
{res:itgen_bouw7_deliveryticket_processed_2} |
☐ |
Whether the delivery ticket has been processed. |
deliveryTicket_processed |
boolean |
Leverbon Verwerkt |
☐ |
Whether the delivery ticket has been processed. |
deliveryTicket_ticketDate_2 |
datetime |
{res:itgen_bouw7_deliveryticket_ticketdate_2} |
☐ |
The date for which the delivery ticket were logged. |
deliveryTicket_ticketDate |
datetime |
Leverbon Bondatum |
☐ |
The date for which the delivery ticket were logged. |
deliveryTicket_ticketNumber_2 |
string |
{res:itgen_bouw7_deliveryticket_ticketnumber_2} |
☐ |
Ticket number of delivery ticket. |
deliveryTicket_ticketNumber |
string |
Leverbon Bonnummer |
☐ |
Ticket number of delivery ticket. |
description |
string(255) |
Omschrijving |
☐ |
The description of the purchase invoice line. |
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 |
☐ |
Purchase invoice due date. |
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 purchase invoice. |
file_createdAt |
datetime |
Bestand Gemaakt op |
☐ |
The creation time of the entity. |
file_createdBy |
string |
Bestand Gemaakt door |
☐ |
The user that created the entity. |
file_extension |
string |
Bestandsextensie |
☐ |
The extension of the file. |
file_id |
int64 |
Bestands-ID |
☐ |
The ID of this file |
file_modelId |
int64 |
Bestandsmodel-ID |
☐ |
The ID of the associated type. |
file_modelType |
string |
Bestandsmodelsoort |
☐ |
The category of the file. |
file_name |
string |
Bestandsnaam |
☐ |
The public name of the file. |
file_secureHash |
string |
{res:itgen_bouw7_file_securehash} |
☐ |
A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. |
file_size |
int64 |
Bestandsgrootte |
☐ |
The size of the file in bytes. |
file_updatedAt |
datetime |
Bestand Bijgewerkt op |
☐ |
The last updated time of the entity. |
file_updatedBy |
string |
Bestand Bijgewerkt door |
☐ |
The user that last updated the entity. |
file_uri |
string |
Bestand URI |
☐ |
The URI of the file, used to fetch the contents. |
fromBasecone |
boolean |
Van Basecone |
☐ |
Whether the invoice is imported from Basecone. |
gAccountAmount |
string |
G-Rekening Bedrag |
☐ |
The g account amount of the purchase invoice. |
grossPrice |
string |
Bruto Prijs |
☐ |
The gross price of the purchase invoice line. |
id_2 |
int64 |
ID |
☐ |
The ID of purchase invoice. |
id |
int64 |
ID |
☐ |
The ID of the purchase invoice line. Must be omitted to create a new purchase invoice line. |
invoice_branch_id |
int64 |
Vestiging-ID |
☐ |
The ID of the branch. |
invoice_branch_name |
string |
Filiaalnaam |
☐ |
The name of the branch. |
invoice_chainLiabilityDocumentExpirationDate |
datetime |
Vervaldatum Document Ketenaansprakelijkheid |
☐ |
The newest expiration date of the chain liability document(s) associated with the contact, in ATOM format. |
invoice_comment |
string |
Commentaar |
☐ |
A comment placed on this purchase invoice. |
invoice_createdAt |
datetime |
Aangemaakt op |
☐ |
The creation date of the object in ATOM/ISO-8601 format |
invoice_createdBy_id |
int64 |
Gemaakt door ID |
☐ |
The ID of the user. |
invoice_createdBy_username |
string |
Aangemaakt door Gebruikersnaam |
☐ |
The username of the user. |
invoice_currentApprover |
string |
Huidige Goedkeurder |
☐ |
The full name of the current approver. |
invoice_date |
datetime |
Datum |
☐ |
The entry date of this purchase invoice. |
invoice_datePaid |
string |
Datum van Betaling |
☐ |
The date this purchase invoice was paid. |
invoice_deliveryTicket_bookingStatus |
int64 |
Boekingsstatus Leverbon |
☐ |
The current booking status. 0 = Registered, 1 = Invoiced, 2 = Not billable, 3 = Credited. |
invoice_deliveryTicket_date |
datetime |
Leverbon Datum |
☐ |
The date of the delivery ticket, represented in ATOM-format. |
invoice_deliveryTicket_description |
string |
Leverbon Omschrijving |
☐ |
The description of this delivery ticket. May contain HTML content. |
invoice_deliveryTicket_id |
int64 |
Leverbon ID |
☐ |
The ID of this delivery ticket. |
invoice_deliveryTicket_isProcessed |
boolean |
Leverbon is Verwerkt |
☐ |
Whether this delivery ticket has been processed. |
invoice_deliveryTicket_number |
string |
Leverbonnummer |
☐ |
The ticket number of this delivery ticket. |
invoice_deliveryTicket_price |
string |
Leverbon Prijs |
☐ |
The price of this delivery ticket. |
invoice_deliveryTicket_purchaseTypeId |
int64 |
Leverbon Aankoopsoort ID |
☐ |
The ID of the purchase type of this delivery ticket. |
invoice_deliveryTicket_purchaseTypeName |
string |
Leverbon Aankoopsoortnaam |
☐ |
The name of the purchase type of this delivery ticket. |
invoice_division_description |
string |
Divisie Omschrijving |
☐ |
The description of the division. |
invoice_division_exactDivisionId |
string |
Divisie Exact Divisie-ID |
☐ |
The division ID of an Exact Online environment. |
invoice_division_glAccountCode |
string |
Administratie Grootboekrekeningcode |
☐ |
A default general ledger account code to use for sales related items. |
invoice_division_glAccountCodePurchase |
string |
Administratie Grootboekrekeningcode Inkoop |
☐ |
A default general ledger account code to use for purchase related items. |
invoice_division_id |
int64 |
Divisie ID |
☐ |
The ID of the division. |
invoice_division_journalCode |
string |
Administratie Dagboekcode |
☐ |
A default journal code to use for sales related items. |
invoice_division_journalCodePurchase |
string |
Administratie Dagboekcode Inkoop |
☐ |
A default journal code to use for purchase related items. |
invoice_dueDate |
datetime |
Vervaldatum |
☐ |
The due date of this purchase invoice. |
invoice_entryNumber |
int64 |
Boekingnummer |
☐ |
A sequential tracking number assigned to this purchase invoice. Also known as voucher number, serial number or tracking number. |
invoice_id |
int64 |
ID |
☐ |
The ID of this purchase invoice. |
invoice_invoiceNumber |
string |
Factuurnummer |
☐ |
The invoice number of this purchase invoice. |
invoice_isBookedInExact |
boolean |
Is Geboekt in Exact |
☐ |
Whether this purchase invoice is booked in Exact. |
invoice_isBookedInTwinfield |
boolean |
Is Geboekt in Twinfield |
☐ |
Whether this purchase invoice is booked in Twinfield. |
invoice_isMutable |
boolean |
{res:itgen_bouw7_ismutable} |
☐ |
Whether the purchase invoice is mutable. |
invoice_isOriginatingFromBasecone |
boolean |
Is Afkomstig van Basecone |
☐ |
Whether this purchase invoice originates from Basecone. |
invoice_orderNumber |
string |
Ordernummer |
☐ |
The order number associated with this purchase invoice. |
invoice_paymentReference |
string |
Betalingskenmerk |
☐ |
The payment reference of this purchase invoice. |
invoice_project_branchId |
int64 |
Project Filiaal-ID |
☐ |
The ID of the branch of this project. |
invoice_project_categoryId |
int64 |
Projectcategorie-ID |
☐ |
The ID of the category of this project. |
invoice_project_divisionId |
int64 |
Projectadministratie-ID |
☐ |
The ID of the division of this project. |
invoice_project_id |
int64 |
Project ID |
☐ |
The ID of the project. |
invoice_project_name |
string |
Projectnaam |
☐ |
The name of the project. |
invoice_project_number |
string |
Projectnummer |
☐ |
The number of the project. |
invoice_project_status |
string |
Projectstatus |
☐ |
The name of the current status of this project. |
invoice_project_statusId |
int64 |
Projectstatus-ID |
☐ |
The ID of the status of this project. |
invoice_status |
int64 |
Status |
☐ |
The status of this purchase invoice. (0 = New, 1 = Approved, 2 = Open, 3 = Expired, 4 = Paid, 5 = Declined) |
invoice_subTotal |
string |
Subtotaal |
☐ |
The sum of all purchase invoice line subtotals, excluding VAT. |
invoice_supplier_emailAddress |
string |
Leverancier E-mailadres |
☐ |
The email address of the contact. |
invoice_supplier_id |
int64 |
Leverancier-ID |
☐ |
The ID of the contact. |
invoice_supplier_name |
string |
Leveranciersnaam |
☐ |
The name of this contact. |
invoice_supplier_type |
string |
Leverancierssoort |
☐ |
The type of this contact. |
invoice_supplier_typeId |
int64 |
Leverancierssoort-ID |
☐ |
The type ID of this contact. |
invoice_total |
string |
Totaal |
☐ |
The sum of all purchase invoice line subtotals, including VAT. |
invoice_updatedAt |
datetime |
Bijgewerkt op |
☐ |
The creation date of the object in ATOM/ISO-8601 format |
invoice_updatedBy_id |
int64 |
Bijgewerkt door ID |
☐ |
The ID of the user. |
invoice_updatedBy_username |
string |
Bijgewerkt door Gebruikersnaam |
☐ |
The username of the user. |
invoice_vatTotal |
string |
BTW Totaal |
☐ |
The sum of all purchase invoice line VAT totals. |
invoiceNumber |
string |
Factuurnummer |
☐ |
The invoice number of purchase invoice. |
isBooked |
boolean |
Is Geboekt |
☐ |
Whether the invoice is already booked. |
isMutable |
boolean |
{res:itgen_bouw7_ismutable} |
☐ |
Whether the purchase invoice is mutable. |
ledger |
string |
Grootboek |
☐ |
A reference to the ledger of the purchase invoice line. |
modelId |
int64 |
Model ID |
☐ |
The model ID. Will be the ID of the selected modelType. |
modelType |
int64 |
Modelsoort |
☐ |
The model type, possible options: 1 = SubcontractorContract / 2 = PurchaseOrderContract / 3 = Project. |
nextPurchaseInvoiceId |
int64 |
Volgende Aankoopfactuur-ID |
☐ |
The ID of the next purchase invoice starting from this purchase invoice. Null when no next purchase invoice available. |
orderNumber |
string |
Ordernummer |
☐ |
The order number of the purchase invoice. |
paymentReference |
string |
Betalingskenmerk |
☐ |
The payment reference of the purchase invoice. |
previousPurchaseInvoiceId |
int64 |
Vorige Aankoopfactuur-ID |
☐ |
The ID of the previous purchase invoice starting from this purchase invoice. Null when no previous purchase invoice available. |
project_branch_code |
string |
{res:itgen_bouw7_project_branch_code} |
☐ |
The code for this branch |
project_branch_id |
int64 |
{res:itgen_bouw7_project_branch_id} |
☐ |
The ID of the branch. |
project_branch_name |
string |
{res:itgen_bouw7_project_branch_name} |
☐ |
The name of this branch |
project_category_code |
string |
{res:itgen_bouw7_project_category_code} |
☐ |
The code for the category. |
project_category_createdAt |
datetime |
{res:itgen_bouw7_project_category_createdat} |
☐ |
The creation time of the entity. |
project_category_createdBy |
string |
{res:itgen_bouw7_project_category_createdby} |
☐ |
The user that created the entity. |
project_category_generalCostsOrProfit |
string |
{res:itgen_bouw7_project_category_generalcostsorprofit} |
☐ |
The general costs or profit for the category. |
project_category_generalCostsPercentage |
string |
{res:itgen_bouw7_project_category_generalcostspercentage} |
☐ |
The general costs percentage for the category. |
project_category_grossProfitMargin |
string |
{res:itgen_bouw7_project_category_grossprofitmargin} |
☐ |
The gross profit margin for the category. |
project_category_id |
int64 |
{res:itgen_bouw7_project_category_id} |
☐ |
The ID of the category. |
project_category_name |
string |
{res:itgen_bouw7_project_category_name} |
☐ |
The name of the category. |
project_category_updatedAt |
datetime |
{res:itgen_bouw7_project_category_updatedat} |
☐ |
The last updated time of the entity. |
project_category_updatedBy |
string |
{res:itgen_bouw7_project_category_updatedby} |
☐ |
The user that last updated the entity. |
project_city |
string |
Project Stad |
☐ |
The city of the project. |
project_contact_email |
string |
Projectcontactpersoon E-mail |
☐ |
The email address. |
project_contact_id |
int64 |
Projectcontactpersoon-ID |
☐ |
ID of contact. |
project_contact_isVatShifted |
boolean |
{res:itgen_bouw7_project_contact_isvatshifted} |
☐ |
Whether VAT is shifted for the contact. |
project_contact_name |
string |
Project Contactnaam |
☐ |
Name of contact. |
project_contact_phoneNumber |
string |
{res:itgen_bouw7_project_contact_phonenumber} |
☐ |
The phone number of the contact. |
project_createdAt |
datetime |
Project Gemaakt op |
☐ |
The creation time of the entity. |
project_createdBy |
string |
Project Gemaakt door |
☐ |
The user that created the entity. |
project_deliveryDate |
datetime |
Project Opleverdatum |
☐ |
Delivery date for the project. |
project_endDate |
datetime |
Project Einddatum |
☐ |
End date for the project. |
project_fullProjectNumber |
string |
Volledig Projectnummer |
☐ |
The full project number including year. |
project_houseNumber |
string |
Project Huisnummer |
☐ |
The house number for the project. |
project_id |
int64 |
Project ID |
☐ |
The ID of the project. |
project_information |
string |
Projectgegevens |
☐ |
The information of the project. |
project_name |
string |
Projectnaam |
☐ |
The name of the project. |
project_projectNumber |
string |
Projectnummer |
☐ |
The project number. |
project_reference |
string |
Projectreferentie |
☐ |
The reference of the project. |
project_startDate |
datetime |
Project Startdatum |
☐ |
Start date for the project. |
project_status_closesProject |
boolean |
Projectstatus Sluit Project af |
☐ |
Whether or not this status closes a project. |
project_status_createdAt |
datetime |
Projectstatus Gemaakt op |
☐ |
The creation time of the entity. |
project_status_createdBy |
string |
Projectstatus Gemaakt door |
☐ |
The user that created the entity. |
project_status_id |
int64 |
Projectstatus-ID |
☐ |
The ID of the status. |
project_status_invoicesProject |
boolean |
Projectstatus Projectfacturen |
☐ |
Whether or not this status invoices a project. |
project_status_name |
string |
Projectstatusnaam |
☐ |
The name of the status. |
project_status_plansProject |
boolean |
Projectstatus Plannen Project |
☐ |
Whether or not this status plans a project. |
project_status_updatedAt |
datetime |
Projectstatus Bijgewerkt op |
☐ |
The last updated time of the entity. |
project_status_updatedBy |
string |
Projectstatus Bijgewerkt door |
☐ |
The user that last updated the entity. |
project_streetName |
string |
Projectstraatnaam |
☐ |
The street name for the project. |
project_updatedAt |
datetime |
Project Bijgewerkt op |
☐ |
The last updated time of the entity. |
project_updatedBy |
string |
Project Bijgewerkt door |
☐ |
The user that last updated the entity. |
project_zipCode |
string |
Project Postcode |
☐ |
The zip code for the project. |
quantity |
string |
Aantal |
☐ |
The unit quantity of the purchase invoice line. |
status |
int64 |
Status |
☐ |
Status of the purchase invoice. |
subTotal |
string |
Subtotaal |
☐ |
The sub-total price of the purchase invoice line. |
unitName |
string |
Eenheidsnaam |
☐ |
The name of the unit in the purchase invoice line. |
unitPrice |
string |
Prijs per Eenheid |
☐ |
The unit price of the purchase invoice line. |
updatedAt_2 |
datetime |
Bijgewerkt op |
☐ |
The last updated time of the entity. |
updatedAt |
datetime |
Bijgewerkt op |
☐ |
The last updated time of the entity. |
updatedBy_2 |
string |
Bijgewerkt door |
☐ |
The user that last updated the entity. |
updatedBy |
string |
Bijgewerkt door |
☐ |
The user that last updated the entity. |
vatTariffId |
int64 |
BTW-Tarief ID |
☐ |
The VAT-tariff ID used on the purchase invoice line. |
vatTariffPercentage |
string |
BTW-Tarief Percentage |
☐ |
The VAT-tariff percentage used on the purchase invoice line. Must be set to 0 if VAT is shifted. |
30-06-2025 16:22 Versie 24.1.116-BETA+5455