PropertyAsset_ProjectCategoryDivisionSettings: Bouw7 itgen_bouw7_propertyasset_projectcategorydivisionsettings_plural
read only REST
- Catalog:
Bouw7 - Schema:
PropertyAsset - Label: itgen_bouw7_propertyasset_projectcategorydivisionsettings_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 |
|---|---|---|---|---|
property |
`` |
Table Columns
The columns of the table PropertyAsset_ProjectCategoryDivisionSettings 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_ |
varchar2 |
Branch Code | writable, ::ancestor. |
The code for this branch | |
branch_ |
int64 |
Branch ID | writable, ::ancestor. |
The ID of the branch. | |
branch_ |
varchar2 |
Branch Name | writable, ::ancestor. |
The name of this branch | |
city |
varchar2 |
City | writable, ::ancestor. |
The city of the project. | |
city_2 |
varchar2 |
itgen_bouw7_city_2 | filters on the platform, writable, ::ancestor. |
City of the PropertyAsset. | |
code |
varchar2 |
Code | writable, ::ancestor. |
The code for the category. | |
contact_ |
varchar2 |
Contact Email | writable, ::ancestor. |
The email address. | |
contact_ |
int64 |
Contact ID | writable, ::ancestor. |
ID of contact. | |
contact_ |
char |
Contact Is VAT Shifted | writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
contact_ |
varchar2 |
Contact Name | writable, ::ancestor. |
Name of contact. | |
contact_ |
varchar2 |
Contact Phone Number | writable, ::ancestor. |
The phone number of the contact. | |
country |
varchar2 |
Country | filters on the platform, writable, ::ancestor. |
ISO 3166-1[alpha2] country code of the PropertyAsset. | |
created |
datetime |
Created at | writable, ::ancestor. |
The creation time of the entity. | |
created |
datetime |
Created at | writable, ::ancestor. |
The creation time of the entity. | |
created |
datetime |
itgen_bouw7_createdat_3 | filters on the platform, writable, ::ancestor. |
The creation time of the entity. | |
created |
varchar2 |
Created by | writable, ::ancestor. |
The user that created the entity. | |
created |
varchar2 |
Created by | writable, ::ancestor. |
The user that created the entity. | |
created |
varchar2 |
itgen_bouw7_createdby_3 | filters on the platform, writable, ::ancestor. |
The user that created the entity. | |
delivery |
datetime |
Delivery Date | writable, ::ancestor. |
Delivery date for the project. | |
description |
varchar2 |
Description | filters on the platform, writable, ::ancestor. |
Description for the PropertyAsset. | |
end |
datetime |
End Date | writable, ::ancestor. |
End date for the project. | |
first |
datetime |
First Delivery Date | filters on the platform, writable, ::ancestor. |
First delivery date of the PropertyAsset. | |
full |
varchar2 |
Full Project Number | writable, ::ancestor. |
The full project number including year. | |
general |
varchar2 |
General Costs or Profit | writable, ::ancestor. |
The general costs or profit for the category. | |
general |
varchar2 |
General Costs Percentage | writable, ::ancestor. |
The general costs percentage for the category. | |
gross |
varchar2 |
Gross Profit Margin | writable, ::ancestor. |
The gross profit margin for the category. | |
house |
varchar2 |
House Number | writable, ::ancestor. |
The house number for the project. | |
house |
varchar2 |
itgen_bouw7_housenumber_2 | filters on the platform, writable, ::ancestor. |
House number (incl. addition) of the PropertyAsset. | |
id |
int64 |
ID | writable, ::ancestor. |
The ID of the category. | |
id_2 |
int64 |
ID | writable, ::ancestor. |
The ID of the project. | |
id_3 |
int64 |
itgen_bouw7_id_3 | filters on the platform, writable, ::ancestor. |
ID of the PropertyAsset. | |
information |
varchar2 |
Information | writable, ::ancestor. |
The information of the project. | |
invoice |
int64 |
Invoice Contact Contact Type ID | filters on the platform, writable, ::ancestor. |
The ID of contact type. | |
invoice |
varchar2 |
Invoice Contact Contact Type Name | filters on the platform, writable, ::ancestor. |
The name of contact type. | |
invoice |
varchar2 |
Invoice Contact Email | filters on the platform, writable, ::ancestor. |
The email address. | |
invoice |
int64 |
Invoice Contact ID | filters on the platform, writable, ::ancestor. |
ID of contact. | |
invoice |
char |
itgen_bouw7_invoicecontact_isvatshifted | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
invoice |
varchar2 |
Invoice Contact Name | filters on the platform, writable, ::ancestor. |
Name of contact. | |
invoice |
varchar2 |
itgen_bouw7_invoicecontact_phonenumber | filters on the platform, writable, ::ancestor. |
The phone number of the contact. | |
name |
varchar2 |
Name | writable, ::ancestor. |
The name of the category. | |
name_2 |
varchar2 |
itgen_bouw7_name_2 | writable, ::ancestor. |
The name of the project. | |
name_3 |
varchar2 |
itgen_bouw7_name_3 | filters on the platform, writable, ::ancestor. |
Name of the PropertyAsset. | |
number |
varchar2 |
Number | filters on the platform, writable, ::ancestor. |
Number for the PropertyAsset. | |
postcode |
varchar2 |
Post Code | filters on the platform, writable, ::ancestor. |
Postcode of the PropertyAsset. | |
project |
varchar2 |
Project Number | writable, ::ancestor. |
The project number. | |
reference |
varchar2 |
Reference | writable, ::ancestor. |
The reference of the project. | |
resident |
int64 |
Resident Contact Contact Type ID | filters on the platform, writable, ::ancestor. |
The ID of contact type. | |
resident |
varchar2 |
Resident Contact Contact Type Name | filters on the platform, writable, ::ancestor. |
The name of contact type. | |
resident |
varchar2 |
Resident Contact Email | filters on the platform, writable, ::ancestor. |
The email address. | |
resident |
int64 |
Resident Contact ID | filters on the platform, writable, ::ancestor. |
ID of contact. | |
resident |
char |
itgen_bouw7_residentcontact_isvatshifted | filters on the platform, writable, ::ancestor. |
Whether VAT is shifted for the contact. | |
resident |
varchar2 |
Resident Contact Name | filters on the platform, writable, ::ancestor. |
Name of contact. | |
resident |
varchar2 |
itgen_bouw7_residentcontact_phonenumber | filters on the platform, writable, ::ancestor. |
The phone number of the contact. | |
second |
datetime |
Second Delivery Date | filters on the platform, writable, ::ancestor. |
Second delivery date of the PropertyAsset. | |
start |
datetime |
Start Date | writable, ::ancestor. |
Start date for the project. | |
status_ |
char |
Status Closes Project | writable, ::ancestor. |
Whether or not this status closes a project. | |
status_ |
datetime |
Status Created at | writable, ::ancestor. |
The creation time of the entity. | |
status_ |
varchar2 |
Status Created by | writable, ::ancestor. |
The user that created the entity. | |
status_ |
int64 |
Status ID | writable, ::ancestor. |
The ID of the status. | |
status_ |
char |
Status Invoices Project | writable, ::ancestor. |
Whether or not this status invoices a project. | |
status_ |
varchar2 |
Status Name | writable, ::ancestor. |
The name of the status. | |
status_ |
char |
Status Plans Project | writable, ::ancestor. |
Whether or not this status plans a project. | |
status_ |
datetime |
Status Updated at | writable, ::ancestor. |
The last updated time of the entity. | |
status_ |
varchar2 |
Status Updated by | writable, ::ancestor. |
The user that last updated the entity. | |
street |
varchar2 |
Street Name | writable, ::ancestor. |
The street name for the project. | |
street |
varchar2 |
itgen_bouw7_streetname_2 | filters on the platform, writable, ::ancestor. |
Street name of the PropertyAsset. | |
updated |
datetime |
Updated At | writable, ::ancestor. |
The last updated time of the entity. | |
updated |
datetime |
Updated at | writable, ::ancestor. |
The last updated time of the entity. | |
updated |
datetime |
itgen_bouw7_updatedat_3 | filters on the platform, writable, ::ancestor. |
The last updated time of the entity. | |
updated |
varchar2 |
Updated by | writable, ::ancestor. |
The user that last updated the entity. | |
updated |
varchar2 |
Updated by | writable, ::ancestor. |
The user that last updated the entity. | |
updated |
varchar2 |
itgen_bouw7_updatedby_3 | filters on the platform, writable, ::ancestor. |
The user that last updated the entity. | |
zip |
varchar2 |
ZIP Code | writable, ::ancestor. |
The zip code for the project. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: