InvoiceChapterLineLinkedBookingItemsByInvoiceId: Bouw7 Invoice Chapter Line Linked Booking Items by Invoice ID
Questa pagina non è ancora disponibile nella tua lingua; viene visualizzata la versione originale.
read only REST
- Catalog:
Bouw7 - Schema:
Invoicing - Label: Invoice Chapter Line Linked Booking Items by Invoice ID
Returns the document of an existing invoice. Returns the document of a new invoice.
Can only retrieve data.
Summary
Returns the document of a new invoice.
API Source
- Endpoint:
/invoice/{invoice} - Operation:
get /invoice/{invoice}
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 |
|---|---|---|---|---|
invoice |
`` | Invoice ID |
Table Columns
The columns of the table InvoiceChapterLineLinkedBookingItemsByInvoiceId 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 |
|---|---|---|---|---|---|
attach |
char |
Attach Equipment List | filters on the platform, writable, ::ancestor. |
Whether to attach the material list attachment. | |
attach |
char |
Attach Garbage List | filters on the platform, writable, ::ancestor. |
Whether to attach the waste list attachment. | |
attach |
char |
Attach Material List | filters on the platform, writable, ::ancestor. |
Whether to attach the material list attachment. | |
attach |
char |
Attach Register | filters on the platform, writable, ::ancestor. |
Whether to attach the register attachment. | |
branch_ |
varchar2 |
Branch Code | 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 |
Branch G-Account Percentage | filters on the platform, writable, ::ancestor. |
The g account percentage of the branch. | |
branch_ |
varchar2 |
Branch G-Account Text | filters on the platform, writable, ::ancestor. |
The g account text of the branch. | |
branch_ |
int64 |
Branch ID | filters on the platform, writable, ::ancestor. |
The ID of the branch. | |
branch_ |
varchar2 |
Branch N-Account Text | filters on the platform, writable, ::ancestor. |
The n account text of the branch. | |
branch_ |
varchar2 |
Branch Name | filters on the platform, writable, ::ancestor. |
The name of the branch. | |
branch_ |
char |
Branch Use Organisation Info | filters on the platform, writable, ::ancestor. |
If organization information should be used instead of branch information. | |
branch_ |
varchar2 |
Branch Wage Component Percentage | filters on the platform, writable, ::ancestor. |
The wage component percentage of the branch. | |
can |
char |
Can Book to AFAS | filters on the platform, writable, ::ancestor. |
Whether it is allowed to book to AFAS. | |
can |
char |
Can Book to Exact | filters on the platform, writable, ::ancestor. |
Whether it is allowed to book to Exact. | |
can |
char |
Can Book to Mareon | filters on the platform, writable, ::ancestor. |
Whether it is allowed to book to Mareon. | |
can |
char |
Can Book to Twinfield | filters on the platform, writable, ::ancestor. |
Whether it is allowed to book to Twinfield. | |
can |
char |
Can Use Cost Centre | filters on the platform, writable, ::ancestor. |
Whether the user can use cost center functionality. | |
contact |
varchar2 |
Contact Person Name | filters on the platform, writable, ::ancestor. |
The name of the contact person for this invoice. | |
contact |
varchar2 |
Contact Person City | filters on the platform, writable, ::ancestor. |
The contact person's city. | |
contact |
datetime |
Contact Person Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
contact |
varchar2 |
Contact Person Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
contact |
varchar2 |
Contact Person Email | filters on the platform, writable, ::ancestor. |
The contact person's email address. | |
contact |
varchar2 |
Contact Person First Name | filters on the platform, writable, ::ancestor. |
The contact person's first name. | |
contact |
varchar2 |
Contact Person House Number | filters on the platform, writable, ::ancestor. |
The contact person's house number. | |
contact |
int64 |
Contact Person ID | filters on the platform, writable, ::ancestor. |
The ID of contact person. | |
contact |
varchar2 |
Contact Person Job Title | filters on the platform, writable, ::ancestor. |
The contact person's job title. | |
contact |
varchar2 |
Contact Person Last Name | filters on the platform, writable, ::ancestor. |
The contact person's last name. | |
contact |
varchar2 |
Contact Person Phone Number | filters on the platform, writable, ::ancestor. |
The contact person's phone number. | |
contact |
varchar2 |
Contact Person Salutation | filters on the platform, writable, ::ancestor. |
The contact person's salutation. | |
contact |
varchar2 |
Contact Person Street Name | filters on the platform, writable, ::ancestor. |
The contact person's street name. | |
contact |
datetime |
Contact Person Updated at | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
contact |
varchar2 |
Contact Person Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
contact |
varchar2 |
Contact Person ZIP Code | filters on the platform, writable, ::ancestor. |
The contact person's zip code. | |
contact_ |
varchar2 |
Contact City | filters on the platform, writable, ::ancestor. |
The city of residence of the contact. | |
contact_ |
varchar2 |
Contact CoC Number | filters on the platform, writable, ::ancestor. |
The chamber of commerce number of the contact. | |
contact_ |
varchar2 |
Contact Contact Person Name | filters on the platform, writable, ::ancestor. |
The name of the contact person. | |
contact_ |
int64 |
Contact Contact Type ID | filters on the platform, writable, ::ancestor. |
The ID of contact type. | |
contact_ |
varchar2 |
Contact Contact Type Name | filters on the platform, writable, ::ancestor. |
The name of contact type. | |
contact_ |
varchar2 |
Contact Country | filters on the platform, writable, ::ancestor. |
The country of the contact. | |
contact_ |
varchar2 |
Contact Debtor Number | filters on the platform, writable, ::ancestor. |
The debtor number of the contact. | |
contact_ |
varchar2 |
Contact Email Address | filters on the platform, writable, ::ancestor. |
The email-address of the contact. | |
contact_ |
int64 |
Contact Expiration Reminder Days | filters on the platform, writable, ::ancestor. |
The number of days before a reminder is sent. | |
contact_ |
varchar2 |
Contact G-Account Percentage | filters on the platform, writable, ::ancestor. |
G-account percentage. | |
contact_ |
varchar2 |
Contact G-Account Text | 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 House Number | 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 |
Contact 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 Invoice UBL Version | filters on the platform, writable, ::ancestor. |
The preferred UBL invoice version for this contact. | |
contact_ |
char |
Contact Is VAT Shifted | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
contact_ |
varchar2 |
Contact N-Account Text | filters on the platform, writable, ::ancestor. |
N-account text. | |
contact_ |
varchar2 |
Contact Name | filters on the platform, writable, ::ancestor. |
The name of the contact. | |
contact_ |
varchar2 |
Contact Phone Number | filters on the platform, writable, ::ancestor. |
The phone number of the contact. | |
contact_ |
varchar2 |
Contact Street Name | filters on the platform, writable, ::ancestor. |
The street name of the contact. | |
contact_ |
varchar2 |
Contact VAT Number | filters on the platform, writable, ::ancestor. |
The VAT-number of the contact. | |
contact_ |
varchar2 |
Contact Wage Component Percentage | filters on the platform, writable, ::ancestor. |
Wage component percentage. | |
contact_ |
varchar2 |
Contact ZIP Code | filters on the platform, writable, ::ancestor. |
The zip-code of the contact. | |
cost |
varchar2 |
Cost Centre | writable, ::ancestor. |
A reference to the cost center associated with the invoice line. | |
created |
datetime |
Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
created |
varchar2 |
Created by | 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 |
Date Paid | filters on the platform, writable, ::ancestor. |
The paid date. | |
debtor |
varchar2 |
Debtor Number | filters on the platform, writable, ::ancestor. |
The debtor number of the contact associated with this invoice. | |
description |
varchar2 |
Description | writable, ::ancestor. |
The name of the invoice line. | |
description_ |
varchar2 |
itgen_bouw7_description_2 | filters on the platform, writable, ::ancestor. |
The public description for this invoice. | |
display |
char |
Display Work Address | filters on the platform, writable, ::ancestor. |
Whether the work address is displayed on the invoice. | |
division_ |
varchar2 |
Division Description | filters on the platform, writable, ::ancestor. |
The description of the division. | |
division_ |
varchar2 |
Division Exact Division ID | filters on the platform, writable, ::ancestor. |
The division ID of an Exact Online environment. | |
division_ |
varchar2 |
Division General Ledger Account Code | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for sales related items. | |
division_ |
varchar2 |
Division General Ledger Account Code Purchase | filters on the platform, writable, ::ancestor. |
A default general ledger account code to use for purchase related items. | |
division_ |
int64 |
Division ID | filters on the platform, writable, ::ancestor. |
The ID of the division. | |
division_ |
varchar2 |
Division Journal Code | filters on the platform, writable, ::ancestor. |
A default journal code to use for sales related items. | |
division_ |
varchar2 |
Division Journal Code Purchase | filters on the platform, writable, ::ancestor. |
A default journal code to use for purchase related items. | |
division_ |
varchar2 |
Division Sales Invoice Number Prefix | filters on the platform, writable, ::ancestor. |
The prefix (3 digits) used to generate invoice number range per division. | |
due |
datetime |
Due Date | filters on the platform, writable, ::ancestor. |
The invoice due date. | |
end |
datetime |
End Date | 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 Payment Condition | filters on the platform, writable, ::ancestor. |
The code of the Exact Online payment condition for this invoice. | |
g |
varchar2 |
G-Account Amount | filters on the platform, writable, ::ancestor. |
G-account amount. | |
g |
varchar2 |
G-Account Percentage | filters on the platform, writable, ::ancestor. |
G-account percentage. | |
g |
varchar2 |
G-Account Text | filters on the platform, writable, ::ancestor. |
G-account text. | |
id |
int64 |
ID | writable, ::ancestor. |
The ID of the invoice line. Must be omitted to create a new invoice. | |
id_2 |
int64 |
ID | writable, ::ancestor. |
The ID of this chapter record. | |
id_3 |
int64 |
itgen_bouw7_id_3 | filters on the platform, writable, ::ancestor. |
The ID of the invoice. Must be omitted to create a new invoice. | |
include |
char |
Include Cover Sheet | filters on the platform, writable, ::ancestor. |
Whether to include a cover sheet to the invoice PDF. | |
internal |
varchar2 |
Internal Note | filters on the platform, writable, ::ancestor. |
The internal note for this invoice. | |
invoice |
varchar2 |
Invoice Number | filters on the platform, writable, ::ancestor. |
The number of this invoice. | |
invoiced |
varchar2 |
Invoiced Project Status Name | 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 Booked | filters on the platform, writable, ::ancestor. |
Whether the invoice is already booked. | |
is |
char |
Is Collective | 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 Booked | filters on the platform, writable, ::ancestor. |
Whether the invoice is already booked in mareon. | |
isRoot |
char |
Is Root | writable, ::ancestor. |
Whether the chapter is the root chapter of the invoice. | |
is |
char |
Is VAT Shifted | 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. | |
ledger |
varchar2 |
Ledger | writable, ::ancestor. |
A reference to the ledger of the invoice line. | |
n |
varchar2 |
N-Account Text | filters on the platform, writable, ::ancestor. |
N-account text. | |
name |
varchar2 |
Name | writable, ::ancestor. |
The name of the chapter. | |
organization_ |
varchar2 |
Organisation City | filters on the platform, writable, ::ancestor. |
The city of residence of the supplier. | |
organization_ |
varchar2 |
Organisation CoC Number | filters on the platform, writable, ::ancestor. |
The chamber of commerce number of the supplier. | |
organization_ |
varchar2 |
Organisation Country | filters on the platform, writable, ::ancestor. |
The country of the supplier. | |
organization_ |
varchar2 |
Organisation Email Address | filters on the platform, writable, ::ancestor. |
The email-address of the supplier. | |
organization_ |
int64 |
Organisation Expiration Reminder Days | filters on the platform, writable, ::ancestor. |
The number of days before a reminder is sent. | |
organization_ |
varchar2 |
Organisation G-Account Percentage | filters on the platform, writable, ::ancestor. |
The g account percentage for the customer. | |
organization_ |
varchar2 |
Organisation G-Account Text | filters on the platform, writable, ::ancestor. |
The g account text for the customer. | |
organization_ |
varchar2 |
Organisation House Number | filters on the platform, writable, ::ancestor. |
The house- or building-number of the supplier. | |
organization_ |
varchar2 |
Organisation IBAN | filters on the platform, writable, ::ancestor. |
The IBAN-account number of the supplier. | |
organization_ |
datetime |
Organisation Logo Created at | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
organization_ |
varchar2 |
Organisation Logo Created by | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
organization_ |
varchar2 |
Organisation Logo Extension | filters on the platform, writable, ::ancestor. |
The extension of the file. | |
organization_ |
int64 |
Organisation Logo ID | filters on the platform, writable, ::ancestor. |
The ID of this file | |
organization_ |
int64 |
Organisation Logo Model ID | filters on the platform, writable, ::ancestor. |
The ID of the associated type. | |
organization_ |
varchar2 |
Organisation Logo Model Type | filters on the platform, writable, ::ancestor. |
The category of the file. | |
organization_ |
varchar2 |
Organisation Logo Name | 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 |
Organisation Logo Size | filters on the platform, writable, ::ancestor. |
The size of the file in bytes. | |
organization_ |
datetime |
Organisation Logo Updated at | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
organization_ |
varchar2 |
Organisation Logo Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
organization_ |
varchar2 |
Organisation Logo URI | filters on the platform, writable, ::ancestor. |
The URI of the file, used to fetch the contents. | |
organization_ |
varchar2 |
Organisation N-Account Text | filters on the platform, writable, ::ancestor. |
The n account text for the customer. | |
organization_ |
varchar2 |
Organisation Name | filters on the platform, writable, ::ancestor. |
The name of the supplier. | |
organization_ |
varchar2 |
Organisation Phone Number | filters on the platform, writable, ::ancestor. |
The phone number of the supplier. | |
organization_ |
char |
Organisation Should Copy Project Description | filters on the platform, writable, ::ancestor. |
Whether the project description should be copied. | |
organization_ |
char |
Organisation Show Project Name on Invoice PDF | filters on the platform, writable, ::ancestor. |
Whether the project name will show on the invoice. | |
organization_ |
char |
Organisation Show Project Number on Invoice | filters on the platform, writable, ::ancestor. |
Whether the project number will show on the invoice. | |
organization_ |
varchar2 |
Organisation Street Name | filters on the platform, writable, ::ancestor. |
The street name of the supplier. | |
organization_ |
varchar2 |
Organisation VAT Number | filters on the platform, writable, ::ancestor. |
The VAT-number of the supplier. | |
organization_ |
varchar2 |
Organisation Wage Component Percentage | filters on the platform, writable, ::ancestor. |
The wage component percentage for the customer. | |
organization_ |
varchar2 |
Organisation Website Address | filters on the platform, writable, ::ancestor. |
The website address of the supplier. | |
organization_ |
varchar2 |
Organisation ZIP Code | filters on the platform, writable, ::ancestor. |
The zip-code of the supplier. | |
price |
varchar2 |
Price Code | writable, ::ancestor. |
The price code of the invoice line. | |
project |
int64 |
Project ID | writable, ::ancestor. |
The ID of the project associated with this invoice line. | |
project |
int64 |
Project Invoice Term ID | writable, ::ancestor. |
The ID of the project invoice term associated with this line. | |
project_ |
varchar2 |
Project Full Project Number | filters on the platform, writable, ::ancestor. |
The full project number including year. | |
project_ |
int64 |
Project ID | filters on the platform, writable, ::ancestor. |
The ID of the project. | |
project_ |
varchar2 |
Project Name | filters on the platform, writable, ::ancestor. |
The name of the project. | |
project_ |
varchar2 |
Project Reference | filters on the platform, writable, ::ancestor. |
The reference of the project. | |
project_ |
varchar2 |
Project Work Address | filters on the platform, writable, ::ancestor. |
The work address of the project. | |
quantity |
varchar2 |
Quantity | writable, ::ancestor. |
The unit quantity of the invoice line. | |
reference |
varchar2 |
Reference | writable, ::ancestor. |
Reference field of project (if available) from the invoice line. | |
sort |
int64 |
Sort Index | writable, ::ancestor. |
The sort index of this invoice line. | |
sort |
int64 |
itgen_bouw7_sortindex_2 | writable, ::ancestor. |
The sort index of this chapter. | |
start |
datetime |
Start Date | 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. | |
sub |
varchar2 |
Subtotal | writable, ::ancestor. |
The sub-total price of the invoice line. | |
surcharge |
varchar2 |
Surcharge Percentage | writable, ::ancestor. |
The surcharge percentage of the invoice line. | |
unit |
varchar2 |
Unit Name | writable, ::ancestor. |
The name of the unit in the invoice line. | |
unit |
varchar2 |
Unit Price | writable, ::ancestor. |
The unit price of the invoice line. | |
updated |
datetime |
Updated At | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
vat |
varchar2 |
VAT Shifted Value | filters on the platform, writable, ::ancestor. |
VAT is shifted value. Usually a VAT-number of the contact. | |
vat |
int64 |
VAT Tariff ID | writable, ::ancestor. |
The VAT-tariff ID used on the invoice line. | |
vat |
varchar2 |
itgen_bouw7_vattarifflegaltext | writable, ::ancestor. |
The legal text of the VAT-tariff used on the invoice line. Only for customers from the belgian hosting. | |
vat |
varchar2 |
VAT Tariff Percentage | writable, ::ancestor. |
The VAT-tariff percentage used on the invoice line. Must be set to 0 if VAT is shifted. | |
wage |
varchar2 |
Wage Component Amount | filters on the platform, writable, ::ancestor. |
Wage component amount. | |
wage |
varchar2 |
Wage Component Percentage | filters on the platform, writable, ::ancestor. |
Wage component percentage. | |
work |
varchar2 |
Work Address | filters on the platform, writable, ::ancestor. |
The work address of the invoice. |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: