| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary key |
globally unique identifier | |
| id2 |
Internal ID (numeric). Will be used if reference_back_office is empty |
integer | |
| reference_back_office |
The Id/Ref of the back office for this job |
string |
Max length: 50 |
| customer_reference |
Reference of this project for the customer |
string |
Max length: 50 |
| _parent_id |
Reference to a parent project (Project hierachy Parent/Child) |
globally unique identifier | |
| root_parent_id | globally unique identifier | ||
| is_mobile_installation | boolean | ||
| project_status_id |
Foreign key of project status for this project |
globally unique identifier | |
| project_status_name |
Status of the project (project.project_status_id=>project_status.name) |
string |
Max length: 50 |
| project_status_is_closed |
Status of the project (project.project_status_id=>project_status.is_closed) |
boolean | |
| name |
Name of the project |
string |
Max length: 50 |
| description |
Description of the project |
string |
Max length: 50 |
| equipment_family_id |
Foreign key of equipment family for this project |
globally unique identifier | |
| equipment_family_name |
Equipment Family (translated) of the project (project.equipment_family_id=>equipment_family.name) |
string |
Max length: 50 |
| equipment_model_id |
Foreign key of equipment model for this project |
globally unique identifier | |
| equipment_model_name |
Equipment Model (translated) of the project (project.equipment_model_id=>equipment_model.name) |
string |
Max length: 50 |
| equipment_brand_id |
Foreign key of equipment brand for this project |
globally unique identifier | |
| equipment_brand_name |
Equipment Brand (translated) of the project (equipment_model.equipment_brand_id=>equipment_brand.name) |
string |
Max length: 50 |
| company_id |
Foreign key of company (owner of the project) |
globally unique identifier | |
| company_code |
Company code that owns the project (project.company_id=>company.code) |
string |
Max length: 50 |
| company_name |
Company name that owns the project (project.company_id=>company.name) |
string |
Max length: 50 |
| company_sales_organization_id |
Sales Organization ID of the company that own the project (project.company_id=>company.sales_organization_id) |
globally unique identifier | |
| db_address_street |
Address Street of the project |
string |
Max length: 50 |
| db_address_street2 | string |
Max length: 50 |
|
| db_address_street_number |
Address Street Number of the project |
string |
Max length: 50 |
| db_address_zip |
Address Zip code of the project |
string |
Max length: 50 |
| db_address_city |
Address City of the project |
string |
Max length: 50 |
| db_address_country_code |
Address Country code of the project |
string |
Max length: 50 |
| db_address_country_name |
Address Country name of the project |
string |
Max length: 50 |
| db_address_phone |
Address Phone number of the project |
string |
Max length: 50 |
| nb_jobs_planned |
Number of jobs with status Planned |
integer | |
| nb_jobs_tobeplanned |
Number of jobs with status ToBePlan |
integer | |
| nb_jobs_waitingfurtheraction |
Number of jobs with status WaitingFurtherAction |
integer | |
| company_db_address_id |
The main address id of the company |
globally unique identifier | |
| has_child |
Inform if this project has child (is a parent) |
boolean | |
| db_address_id |
DbAddressId of the project (if empty, will use the main address of the company) |
globally unique identifier | |
| location |
Additional text to describe the location |
string |
Max length: 50 |
| contact_id |
Main contact of the project |
globally unique identifier | |
| serial_number |
Serial Number |
string |
Max length: 50 |
| barcode |
Barcode |
string |
Max length: 50 |
| date_start_production |
Date project/installation becomes active |
date | |
| date_create |
Date create |
date | |
| date_update |
Date update |
date | |
| nb_open_jobs |
Number of jobs Open (In progress) |
integer | |
| date_next_job |
Date+Time of the next job planned |
date | |
| date_last_job |
Date+Time of the last job completed |
date | |
| warranty_date_until |
End date of the warranty (if applicable) |
date | |
| date_built |
Build date of the installation (if applicable) |
date | |
| shutdown_consequence |
Consequence of the installation is shut down (CEO has no air cooling anymore,..) |
string |
Max length: 50 |
| replacement_date | date | ||
| contract_id | globally unique identifier |
