ProjectById: Bouw7 Project by ID
read only REST
- Catalogus:
Bouw7 - Schema:
Project - Label: Project by ID
Returns a project associated with the given id. Returns a project associated with the given id.
Kan alleen gegevens ophalen.
Samenvatting
Returns a project associated with the given id.
API-bron
- Eindpunt:
/project/{project} - Operatie:
get /project/{project}
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 |
|---|---|---|---|---|
project |
`` | Project ID |
Tabelkolommen
De kolommen van de tabel ProjectById 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 |
|---|---|---|---|---|---|
additional |
varchar2 |
Extra Werk | filters on the platform, writable, additional |
Additional work amount for the project. | |
branch_ |
varchar2 |
Vestigingscode | filters on the platform, writable, branch. |
The code for this branch | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_description | filters on the platform, writable, branch. |
The description of the division. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_exactdivisionid | filters on the platform, writable, branch. |
The division ID of an Exact Online environment. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_glaccountcode | filters on the platform, writable, branch. |
A default general ledger account code to use for sales related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_glaccountcodepurchase | filters on the platform, writable, branch. |
A default general ledger account code to use for purchase related items. | |
branch_ |
int64 |
itgen_bouw7_branch_division_id | filters on the platform, writable, branch. |
The ID of the division. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_journalcode | filters on the platform, writable, branch. |
A default journal code to use for sales related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_journalcodepurchase | filters on the platform, writable, branch. |
A default journal code to use for purchase related items. | |
branch_ |
varchar2 |
itgen_bouw7_branch_division_salesinvoicenumberprefix | filters on the platform, writable, branch. |
The prefix (3 digits) used to generate invoice number range per division. | |
branch_ |
int64 |
Vestiging-ID | filters on the platform, writable, branch. |
The ID of the branch. | |
branch_ |
varchar2 |
Filiaalnaam | filters on the platform, writable, branch. |
The name of this branch | |
category_ |
varchar2 |
Categoriecode | filters on the platform, writable, category. |
The code for the category. | |
category_ |
datetime |
Categorie Aangemaakt op | filters on the platform, writable, category. |
The creation time of the entity. | |
category_ |
varchar2 |
Categorie Aangemaakt door | filters on the platform, writable, category. |
The user that created the entity. | |
category_ |
varchar2 |
Algemene Kostencategorie Percentage | filters on the platform, writable, category. |
The general costs percentage for the category. | |
category_ |
varchar2 |
Categorie Brutowinstmarge | filters on the platform, writable, category. |
The gross profit margin for the category. | |
category_ |
int64 |
Categorie ID | filters on the platform, writable, category. |
The ID of the category. | |
category_ |
varchar2 |
Categorienaam | filters on the platform, writable, category. |
The name of the category. | |
category_ |
datetime |
Categorie Bijgewerkt op | filters on the platform, writable, category. |
The last updated time of the entity. | |
category_ |
varchar2 |
Categorie Bijgewerkt door | filters on the platform, writable, category. |
The user that last updated the entity. | |
city |
varchar2 |
City | filters on the platform, writable, city |
The city of the project. | |
contact |
varchar2 |
Contactpersoon Stad | filters on the platform, writable, contact |
The contact person's city. | |
contact |
datetime |
Contactpersoon Aangemaakt op | filters on the platform, writable, contact |
The creation time of the entity. | |
contact |
varchar2 |
Contactpersoon Aangemaakt door | filters on the platform, writable, contact |
The user that created the entity. | |
contact |
varchar2 |
Contactpersoon E-mail | filters on the platform, writable, contact |
The contact person's email address. | |
contact |
varchar2 |
Contactpersoon Voornaam | filters on the platform, writable, contact |
The contact person's first name. | |
contact |
varchar2 |
Contactpersoon Huisnummer | filters on the platform, writable, contact |
The contact person's house number. | |
contact |
int64 |
Contactpersoon ID | filters on the platform, writable, contact |
The ID of contact person. | |
contact |
varchar2 |
Contactpersoon Achternaam | filters on the platform, writable, contact |
The contact person's last name. | |
contact |
varchar2 |
Contactpersoon Telefoonnummer | filters on the platform, writable, contact |
The contact person's phone number. | |
contact |
varchar2 |
Contactpersoon Straatnaam | filters on the platform, writable, contact |
The contact person's street name. | |
contact |
datetime |
Contactpersoon Bijgewerkt op | filters on the platform, writable, contact |
The last updated time of the entity. | |
contact |
varchar2 |
Contactpersoon Bijgewerkt door | filters on the platform, writable, contact |
The user that last updated the entity. | |
contact |
varchar2 |
Contactpersoon Postcode | filters on the platform, writable, contact |
The contact person's zip code. | |
contact_ |
int64 |
Contact Soort ID | filters on the platform, writable, contact. |
The ID of contact type. | |
contact_ |
varchar2 |
Contact Soort Naam | filters on the platform, writable, contact. |
The name of contact type. | |
contact_ |
varchar2 |
Contact E-mail | filters on the platform, writable, contact. |
The email address. | |
contact_ |
int64 |
Contactpersoon ID | filters on the platform, writable, contact. |
ID of contact. | |
contact_ |
char |
Contact is BTW Verlegd | filters on the platform, writable, contact. |
Whether VAT is shifted for the contact. | |
contact_ |
varchar2 |
Contactpersoon Naam | filters on the platform, writable, contact. |
Name of contact. | |
contact_ |
varchar2 |
Contact Telefoonnummer | filters on the platform, writable, contact. |
The phone number of the contact. | |
country |
varchar2 |
Landcode | filters on the platform, writable, country |
An ISO 3166-2 representation of the country. | |
created |
datetime |
Aangemaakt op | filters on the platform, writable, created |
The creation time of the entity. | |
created |
varchar2 |
Gemaakt door | filters on the platform, writable, created |
The user that created the entity. | |
delivery |
datetime |
Leveringsdatum | filters on the platform, writable, delivery |
Delivery date for the project. | |
division_ |
varchar2 |
Divisie Omschrijving | filters on the platform, writable, division. |
The description of the division. | |
division_ |
varchar2 |
Divisie Exact Divisie-ID | filters on the platform, writable, division. |
The division ID of an Exact Online environment. | |
division_ |
varchar2 |
Administratie Grootboekrekeningcode | filters on the platform, writable, division. |
A default general ledger account code to use for sales related items. | |
division_ |
varchar2 |
Administratie Grootboekrekeningcode Inkoop | filters on the platform, writable, division. |
A default general ledger account code to use for purchase related items. | |
division_ |
int64 |
Divisie ID | filters on the platform, writable, division. |
The ID of the division. | |
division_ |
varchar2 |
Administratie Dagboekcode | filters on the platform, writable, division. |
A default journal code to use for sales related items. | |
division_ |
varchar2 |
Administratie Dagboekcode Inkoop | filters on the platform, writable, division. |
A default journal code to use for purchase related items. | |
division_ |
varchar2 |
Administratie Verkoopfactuurnummervoorvoegsel | filters on the platform, writable, division. |
The prefix (3 digits) used to generate invoice number range per division. | |
end |
datetime |
Einddatum | filters on the platform, writable, end |
End date for the project in ATOM format. | |
executor_ |
varchar2 |
Executeur Voornaam | filters on the platform, writable, executor. |
First name of the employee. | |
executor_ |
int64 |
Executeur-ID | filters on the platform, writable, executor. |
ID of the employee. | |
executor_ |
varchar2 |
Executeur Achternaam | filters on the platform, writable, executor. |
Last name of the employee. | |
extra |
varchar2 |
Extra Werk | filters on the platform, writable, extra |
Extra work for the project. | |
fixed |
varchar2 |
Vaste Prijs | filters on the platform, writable, fixed |
Fixed price for the project. | |
full |
varchar2 |
Volledig Projectnummer | filters on the platform, writable, full |
The full project number including year. | |
general |
varchar2 |
Algemene Kosten Bedrag | filters on the platform, writable, general |
General costs amount for the project. | |
has |
char |
itgen_bouw7_hasafasassociation | filters on the platform, writable, has |
Whether the project has an association with AFAS. | |
has |
char |
Heeft Mare Gekoppeld | filters on the platform, writable, has |
Whether or not the project has an association with Mareon. | |
has |
char |
itgen_bouw7_hassecurityobjects | filters on the platform, writable, has |
Whether the project is security coded with security objects. | |
has |
char |
itgen_bouw7_hassubprojects | filters on the platform, writable, has |
Whether the project has subprojects. | |
hours |
varchar2 |
Urenschatting | filters on the platform, writable, hours |
Estimated hours for the project. | |
house |
varchar2 |
Huisnummer | filters on the platform, writable, house |
The house number for the project. | |
id |
int64 |
ID | filters on the platform, writable, id |
The ID of the project. | |
information |
varchar2 |
Information | filters on the platform, writable, information |
Information about the project. | |
is |
char |
Is Geboekt | filters on the platform, writable, is |
Whether or not the project has been booked to a bookkeeping system. | |
is |
char |
Is Beveiliging Gecodeerd | filters on the platform, writable, is |
Whether or not the project is security coded. | |
logged |
varchar2 |
Geregistreerde Uren | filters on the platform, writable, logged |
The amount of hours logged for the project. | |
maintenance |
varchar2 |
Onderhoudsstatuscode | filters on the platform, writable, maintenance |
The maintenance status code for the project. | |
name |
varchar2 |
Name | filters on the platform, writable, name |
The name of the project. | |
note |
varchar2 |
Note | filters on the platform, writable, note |
Notes for the project. | |
parent |
int64 |
Ouder ID | filters on the platform, writable, parent |
The ID of the parent project if this project is a subproject. | |
plan |
int64 |
Plan Artikeltelling | filters on the platform, writable, plan |
The count of plan items associated with this project. | |
planning |
varchar2 |
Planning | filters on the platform, writable, planning |
The planning for the project. | |
profit |
varchar2 |
Winst en Risico | filters on the platform, writable, profit |
Profit and risk amount for the project. | |
project |
varchar2 |
Projectleider Voornaam | filters on the platform, writable, project |
First name of the employee. | |
project |
int64 |
Projectleider-ID | filters on the platform, writable, project |
ID of the employee. | |
project |
varchar2 |
Projectleider Achternaam | filters on the platform, writable, project |
Last name of the employee. | |
project |
varchar2 |
Projectnummer | filters on the platform, writable, project |
The project number. | |
property |
varchar2 |
Vastgoed Activa Stad | filters on the platform, writable, property |
City of the PropertyAsset. | |
property |
varchar2 |
Vastgoed Activa Land | filters on the platform, writable, property |
ISO 3166-1[alpha2] country code of the PropertyAsset. | |
property |
varchar2 |
Vastgoed Activa Omschrijving | filters on the platform, writable, property |
Description for the PropertyAsset. | |
property |
datetime |
Vastgoed Activa Eerste Leveringsdatum | filters on the platform, writable, property |
First delivery date of the PropertyAsset. | |
property |
varchar2 |
Vastgoed Activa Huisnummer | filters on the platform, writable, property |
House number (incl. addition) of the PropertyAsset. | |
property |
int64 |
Vastgoed Activa-ID | filters on the platform, writable, property |
ID of the PropertyAsset. | |
property |
varchar2 |
Vastgoed Activa Factuurcontacte-mail | filters on the platform, writable, property |
The email address. | |
property |
int64 |
Vastgoed Activa Factuurcontact-ID | filters on the platform, writable, property |
ID of contact. | |
property |
char |
itgen_bouw7_propertyasset_invoicecontact_isvatshifted | filters on the platform, writable, property |
Whether VAT is shifted for the contact. | |
property |
varchar2 |
Vastgoed Activa Factuurcontactnaam | filters on the platform, writable, property |
Name of contact. | |
property |
varchar2 |
itgen_bouw7_propertyasset_invoicecontact_phonenumber | filters on the platform, writable, property |
The phone number of the contact. | |
property |
varchar2 |
Vastgoed Activanaam | filters on the platform, writable, property |
Name of the PropertyAsset. | |
property |
varchar2 |
Vastgoed Activanummer | filters on the platform, writable, property |
Number for the PropertyAsset. | |
property |
varchar2 |
Vastgoed Activa Postcode | filters on the platform, writable, property |
Postcode of the PropertyAsset. | |
property |
varchar2 |
Vastgoed Activa Projectnaam en -nummer | filters on the platform, writable, property |
The name and number of the Project the PropertyAsset belongs to. | |
property |
varchar2 |
Vastgoed Activa Ingezetene Contacte-mail | filters on the platform, writable, property |
The email address. | |
property |
int64 |
Vastgoed Activa Ingezetene Contact-ID | filters on the platform, writable, property |
ID of contact. | |
property |
char |
itgen_bouw7_propertyasset_residentcontact_isvatshifted | filters on the platform, writable, property |
Whether VAT is shifted for the contact. | |
property |
varchar2 |
Vastgoed Activa Ingezetene Contactnaam | filters on the platform, writable, property |
Name of contact. | |
property |
varchar2 |
itgen_bouw7_propertyasset_residentcontact_phonenumber | filters on the platform, writable, property |
The phone number of the contact. | |
property |
datetime |
Vastgoed Activa Tweede Leveringsdatum | filters on the platform, writable, property |
Second delivery date of the PropertyAsset. | |
property |
varchar2 |
Vastgoed Activa Straatnaam | filters on the platform, writable, property |
Street name of the PropertyAsset. | |
provisional |
varchar2 |
itgen_bouw7_provisionalcosts | filters on the platform, writable, provisional |
Provisional cost for the project. | |
reference |
varchar2 |
Reference | filters on the platform, writable, reference |
A reference for this project. | |
start |
datetime |
Startdatum | filters on the platform, writable, start |
Start date for the project in ATOM format. | |
status_ |
char |
Status Sluit Project | filters on the platform, writable, status. |
Whether or not this status closes a project. | |
status_ |
datetime |
Status Aangemaakt op | filters on the platform, writable, status. |
The creation time of the entity. | |
status_ |
varchar2 |
Status Gemaakt door | filters on the platform, writable, status. |
The user that created the entity. | |
status_ |
int64 |
Status-ID | filters on the platform, writable, status. |
The ID of the status. | |
status_ |
char |
Status Factureert Project | filters on the platform, writable, status. |
Whether or not this status invoices a project. | |
status_ |
varchar2 |
Statusnaam | filters on the platform, writable, status. |
The name of the status. | |
status_ |
char |
Status Plant Project | filters on the platform, writable, status. |
Whether or not this status plans a project. | |
status_ |
datetime |
Status geüpdatet op | filters on the platform, writable, status. |
The last updated time of the entity. | |
status_ |
varchar2 |
Status Bijgewerkt door | filters on the platform, writable, status. |
The user that last updated the entity. | |
street |
varchar2 |
Straatnaam | filters on the platform, writable, street |
The street name for the project. | |
type |
int64 |
Type | filters on the platform, writable, type |
The type of project. | |
updated |
datetime |
Bijgewerkt op | filters on the platform, writable, updated |
The last updated time of the entity. | |
updated |
varchar2 |
Bijgewerkt door | filters on the platform, writable, updated |
The user that last updated the entity. | |
work |
varchar2 |
Werkadres | filters on the platform, writable, work |
The work address for this project. | |
work |
varchar2 |
Werkvoorbereider Voornaam | filters on the platform, writable, work |
First name of the employee. | |
work |
int64 |
Werkvoorbereider-ID | filters on the platform, writable, work |
ID of the employee. | |
work |
varchar2 |
Werkvoorbereider Achternaam | filters on the platform, writable, work |
Last name of the employee. | |
zip |
varchar2 |
Postcode | filters on the platform, writable, zip |
The zip code for the project. |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: