invantive documentation
Invantive Support ForumsLog In / Sign Up

PropertyAsset_ProjectsCategoryDivisionSettings: Bouw7 itgen_bouw7_propertyasset_projectscategorydivisionsettings_plural

read only REST

  • Catalog: Bouw7
  • Schema: PropertyAsset
  • Label: itgen_bouw7_propertyasset_projectscategorydivisionsettings_plural

Returns a single property asset based on the given ID. Returns a single property asset based on the given ID.

Can only retrieve data.

Summary

Returns a single property asset based on the given ID.

API Source

  • Endpoint: /property-asset/{propertyAsset}
  • Operation: get /property-asset/{propertyAsset}

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
propertyAsset ``

Table Columns

The columns of the table PropertyAsset_ProjectsCategoryDivisionSettings 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
branch_code varchar2 Branch Code writable, ::ancestor.::ancestor.branch.code The code for this branch
branch_id int64 Branch ID writable, ::ancestor.::ancestor.branch.id The ID of the branch.
branch_name varchar2 Branch Name writable, ::ancestor.::ancestor.branch.name The name of this branch
city varchar2 City writable, ::ancestor.::ancestor.city The city of the project.
city_2 varchar2(255) itgen_bouw7_city_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.city City of the PropertyAsset.
code varchar2 Code writable, ::ancestor.code The code for the category.
contact_email varchar2 Contact Email writable, ::ancestor.::ancestor.contact.email The email address.
contact_id int64 Contact ID writable, ::ancestor.::ancestor.contact.id ID of contact.
contact_isVatShifted char Contact Is VAT Shifted writable, ::ancestor.::ancestor.contact.isVatShifted Whether VAT is shifted for the contact.
contact_name varchar2 Contact Name writable, ::ancestor.::ancestor.contact.name Name of contact.
contact_phoneNumber varchar2 Contact Phone Number writable, ::ancestor.::ancestor.contact.phoneNumber The phone number of the contact.
country varchar2(2) Country filters on the platform, writable, ::ancestor.::ancestor.::ancestor.country ISO 3166-1[alpha2] country code of the PropertyAsset.
createdAt datetime Created at writable, ::ancestor.createdAt The creation time of the entity.
createdAt_2 datetime Created at writable, ::ancestor.::ancestor.createdAt The creation time of the entity.
createdAt_3 datetime itgen_bouw7_createdat_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createdAt The creation time of the entity.
createdBy varchar2 Created by writable, ::ancestor.createdBy The user that created the entity.
createdBy_2 varchar2 Created by writable, ::ancestor.::ancestor.createdBy The user that created the entity.
createdBy_3 varchar2 itgen_bouw7_createdby_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.createdBy The user that created the entity.
deliveryDate datetime Delivery Date writable, ::ancestor.::ancestor.deliveryDate Delivery date for the project.
description varchar2 Description filters on the platform, writable, ::ancestor.::ancestor.::ancestor.description Description for the PropertyAsset.
endDate datetime End Date writable, ::ancestor.::ancestor.endDate End date for the project.
firstDeliveryDate datetime First Delivery Date filters on the platform, writable, ::ancestor.::ancestor.::ancestor.firstDeliveryDate First delivery date of the PropertyAsset.
fullProjectNumber varchar2 Full Project Number writable, ::ancestor.::ancestor.fullProjectNumber The full project number including year.
generalCostsOrProfit varchar2 General Costs or Profit writable, ::ancestor.generalCostsOrProfit The general costs or profit for the category.
generalCostsPercentage varchar2 General Costs Percentage writable, ::ancestor.generalCostsPercentage The general costs percentage for the category.
grossProfitMargin varchar2 Gross Profit Margin writable, ::ancestor.grossProfitMargin The gross profit margin for the category.
houseNumber varchar2 House Number writable, ::ancestor.::ancestor.houseNumber The house number for the project.
houseNumber_2 varchar2(50) itgen_bouw7_housenumber_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.houseNumber House number (incl. addition) of the PropertyAsset.
id int64 ID writable, ::ancestor.id The ID of the category.
id_2 int64 ID writable, ::ancestor.::ancestor.id The ID of the project.
id_3 int64 itgen_bouw7_id_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.id ID of the PropertyAsset.
information varchar2 Information writable, ::ancestor.::ancestor.information The information of the project.
invoiceContact_contactType_id int64 Invoice Contact Contact Type ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceContact.contactType.id The ID of contact type.
invoiceContact_contactType_name varchar2 Invoice Contact Contact Type Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceContact.contactType.name The name of contact type.
invoiceContact_email varchar2 Invoice Contact Email filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceContact.email The email address.
invoiceContact_id int64 Invoice Contact ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceContact.id ID of contact.
invoiceContact_isVatShifted char itgen_bouw7_invoicecontact_isvatshifted filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceContact.isVatShifted Whether VAT is shifted for the contact.
invoiceContact_name varchar2 Invoice Contact Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceContact.name Name of contact.
invoiceContact_phoneNumber varchar2 itgen_bouw7_invoicecontact_phonenumber filters on the platform, writable, ::ancestor.::ancestor.::ancestor.invoiceContact.phoneNumber The phone number of the contact.
name varchar2 Name writable, ::ancestor.name The name of the category.
name_2 varchar2 itgen_bouw7_name_2 writable, ::ancestor.::ancestor.name The name of the project.
name_3 varchar2(255) itgen_bouw7_name_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.name Name of the PropertyAsset.
number varchar2(255) Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.number Number for the PropertyAsset.
postcode varchar2(20) Post Code filters on the platform, writable, ::ancestor.::ancestor.::ancestor.postcode Postcode of the PropertyAsset.
projectNumber varchar2 Project Number writable, ::ancestor.::ancestor.projectNumber The project number.
project_branch_code varchar2 itgen_bouw7_project_branch_code filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.branch.code The code for this branch
project_branch_id int64 itgen_bouw7_project_branch_id filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.branch.id The ID of the branch.
project_branch_name varchar2 itgen_bouw7_project_branch_name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.branch.name The name of this branch
project_city varchar2 Project City filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.city The city of the project.
project_code varchar2 itgen_bouw7_project_code filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.category.code The code for the category.
project_contact_email varchar2 Project Contact Email filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.contact.email The email address.
project_contact_id int64 Project Contact ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.contact.id ID of contact.
project_contact_isVatShifted char itgen_bouw7_project_contact_isvatshifted filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.contact.isVatShifted Whether VAT is shifted for the contact.
project_contact_name varchar2 Project Contact Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.contact.name Name of contact.
project_contact_phoneNumber varchar2 itgen_bouw7_project_contact_phonenumber filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.contact.phoneNumber The phone number of the contact.
project_createdAt datetime Project Created at filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.category.createdAt The creation time of the entity.
project_createdAt_2 datetime itgen_bouw7_project_createdat_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.createdAt The creation time of the entity.
project_createdBy varchar2 Project Created by filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.category.createdBy The user that created the entity.
project_createdBy_2 varchar2 itgen_bouw7_project_createdby_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.createdBy The user that created the entity.
project_deliveryDate datetime Project Delivery Date filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.deliveryDate Delivery date for the project.
project_endDate datetime Project End Date filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.endDate End date for the project.
project_fullProjectNumber varchar2 Project Full Project Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.fullProjectNumber The full project number including year.
project_generalCostsOrProfit varchar2 itgen_bouw7_project_generalcostsorprofit filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.category.generalCostsOrProfit The general costs or profit for the category.
project_generalCostsPercentage varchar2 itgen_bouw7_project_generalcostspercentage filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.category.generalCostsPercentage The general costs percentage for the category.
project_grossProfitMargin varchar2 itgen_bouw7_project_grossprofitmargin filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.category.grossProfitMargin The gross profit margin for the category.
project_houseNumber varchar2 Project House Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.houseNumber The house number for the project.
project_id int64 Project ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.category.id The ID of the category.
project_id_2 int64 itgen_bouw7_project_id_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.id The ID of the project.
project_information varchar2 Project Information filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.information The information of the project.
project_name varchar2 Project Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.category.name The name of the category.
project_name_2 varchar2 itgen_bouw7_project_name_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.name The name of the project.
project_projectNumber varchar2 Project Project Number filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.projectNumber The project number.
project_reference varchar2 Project Reference filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.reference The reference of the project.
project_startDate datetime Project Start Date filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.startDate Start date for the project.
project_status_closesProject char Project Status Closes Project filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.status.closesProject Whether or not this status closes a project.
project_status_createdAt datetime Project Status Created at filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.status.createdAt The creation time of the entity.
project_status_createdBy varchar2 Project Status Created by filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.status.createdBy The user that created the entity.
project_status_id int64 Project Status ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.status.id The ID of the status.
project_status_invoicesProject char Project Status Invoices Project filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.status.invoicesProject Whether or not this status invoices a project.
project_status_name varchar2 Project Status Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.status.name The name of the status.
project_status_plansProject char Project Status Plans Project filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.status.plansProject Whether or not this status plans a project.
project_status_updatedAt datetime Project Status Updated at filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.status.updatedAt The last updated time of the entity.
project_status_updatedBy varchar2 Project Status Updated by filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.status.updatedBy The user that last updated the entity.
project_streetName varchar2 Project Street Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.streetName The street name for the project.
project_updatedAt datetime Project Updated at filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.category.updatedAt The last updated time of the entity.
project_updatedAt_2 datetime itgen_bouw7_project_updatedat_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.updatedAt The last updated time of the entity.
project_updatedBy varchar2 Project Updated by filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.category.updatedBy The user that last updated the entity.
project_updatedBy_2 varchar2 itgen_bouw7_project_updatedby_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.updatedBy The user that last updated the entity.
project_zipCode varchar2 Project ZIP Code filters on the platform, writable, ::ancestor.::ancestor.::ancestor.project.zipCode The zip code for the project.
reference varchar2 Reference writable, ::ancestor.::ancestor.reference The reference of the project.
residentContact_contactType_id int64 Resident Contact Contact Type ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.residentContact.contactType.id The ID of contact type.
residentContact_contactType_name varchar2 Resident Contact Contact Type Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.residentContact.contactType.name The name of contact type.
residentContact_email varchar2 Resident Contact Email filters on the platform, writable, ::ancestor.::ancestor.::ancestor.residentContact.email The email address.
residentContact_id int64 Resident Contact ID filters on the platform, writable, ::ancestor.::ancestor.::ancestor.residentContact.id ID of contact.
residentContact_isVatShifted char itgen_bouw7_residentcontact_isvatshifted filters on the platform, writable, ::ancestor.::ancestor.::ancestor.residentContact.isVatShifted Whether VAT is shifted for the contact.
residentContact_name varchar2 Resident Contact Name filters on the platform, writable, ::ancestor.::ancestor.::ancestor.residentContact.name Name of contact.
residentContact_phoneNumber varchar2 itgen_bouw7_residentcontact_phonenumber filters on the platform, writable, ::ancestor.::ancestor.::ancestor.residentContact.phoneNumber The phone number of the contact.
secondDeliveryDate datetime Second Delivery Date filters on the platform, writable, ::ancestor.::ancestor.::ancestor.secondDeliveryDate Second delivery date of the PropertyAsset.
startDate datetime Start Date writable, ::ancestor.::ancestor.startDate Start date for the project.
status_closesProject char Status Closes Project writable, ::ancestor.::ancestor.status.closesProject Whether or not this status closes a project.
status_createdAt datetime Status Created at writable, ::ancestor.::ancestor.status.createdAt The creation time of the entity.
status_createdBy varchar2 Status Created by writable, ::ancestor.::ancestor.status.createdBy The user that created the entity.
status_id int64 Status ID writable, ::ancestor.::ancestor.status.id The ID of the status.
status_invoicesProject char Status Invoices Project writable, ::ancestor.::ancestor.status.invoicesProject Whether or not this status invoices a project.
status_name varchar2 Status Name writable, ::ancestor.::ancestor.status.name The name of the status.
status_plansProject char Status Plans Project writable, ::ancestor.::ancestor.status.plansProject Whether or not this status plans a project.
status_updatedAt datetime Status Updated at writable, ::ancestor.::ancestor.status.updatedAt The last updated time of the entity.
status_updatedBy varchar2 Status Updated by writable, ::ancestor.::ancestor.status.updatedBy The user that last updated the entity.
streetName varchar2 Street Name writable, ::ancestor.::ancestor.streetName The street name for the project.
streetName_2 varchar2(255) itgen_bouw7_streetname_2 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.streetName Street name of the PropertyAsset.
updatedAt datetime Updated At writable, ::ancestor.updatedAt The last updated time of the entity.
updatedAt_2 datetime Updated at writable, ::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedAt_3 datetime itgen_bouw7_updatedat_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.updatedAt The last updated time of the entity.
updatedBy varchar2 Updated by writable, ::ancestor.updatedBy The user that last updated the entity.
updatedBy_2 varchar2 Updated by writable, ::ancestor.::ancestor.updatedBy The user that last updated the entity.
updatedBy_3 varchar2 itgen_bouw7_updatedby_3 filters on the platform, writable, ::ancestor.::ancestor.::ancestor.updatedBy The user that last updated the entity.
zipCode varchar2 ZIP Code writable, ::ancestor.::ancestor.zipCode The zip code for the project.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: