NameDescriptionTypeAdditional information
id

Primary Key

 globally unique identifier

Required
_parent_id

Empty or filled with the parent

 globally unique identifier
root_parent_id

Empty of filled with the top root parent

 globally unique identifier
name

Name

 string

Max length: 255
equipment_family_id

Foreign key to equipment_family

 globally unique identifier

Optionally required : equipment_family_id, equipment_family_code or equipment_family must be provided
equipment_family_name

equipment_family.equipment_family_name

 string
company_id

The company owner of this project/installation

 globally unique identifier

Optionally required : company_id, company_code or company must be provided
description

Long description

 string
reference_back_office

The Id/Ref of the back office for this project/installation. Used by Embedded entity

 string

Max length: 255
serial_number

Serial number

 string

Max length: 255
barcode

Barcode

 string

Max length: 50
date_start_production

Date project/installation becomes active

 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: 4000
id2

Internal ID (numeric). Will be used if reference_back_office is empty

 integer
contact_id

globally unique identifier
is_mobile_installation

boolean
location

string

Max length: 255
contract_id

globally unique identifier
db_address_id

globally unique identifier
project_status_id

globally unique identifier
owner_user_id

globally unique identifier
equipment_model_id

globally unique identifier
replacement_date

date
customer_reference

string

Max length: 50
modified_dateutc

Readonly system field managed by database, filled with GetUtcDate when adding,updating

 date
has_child

boolean
udf1

string

Max length: 4000
udf2

string

Max length: 4000
udf3

string

Max length: 4000
udf4

string

Max length: 4000
udf5

string

Max length: 4000
udf6

string

Max length: 4000
udf7

string

Max length: 4000
udf8

string

Max length: 4000
udf9

string

Max length: 4000
udf10

string

Max length: 4000
udf11

string

Max length: 4000
udf12

string

Max length: 4000
udf13

string

Max length: 4000
udf14

string

Max length: 4000
udf15

string

Max length: 4000
udf16

string

Max length: 4000
udf17

string

Max length: 4000
udf18

string

Max length: 4000
udf19

string

Max length: 4000
udf20

string

Max length: 4000
udf21

string

Max length: 4000
udf22

string

Max length: 4000
udf23

string

Max length: 4000
udf24

string

Max length: 4000
udf25

string

Max length: 4000
udf26

string

Max length: 4000
udf27

string

Max length: 4000
udf28

string

Max length: 4000
udf29

string

Max length: 4000
udf30

string

Max length: 4000
udf31

string

Max length: 4000
udf32

string

Max length: 4000
udf33

string

Max length: 4000
udf34

string

Max length: 4000
udf35

string

Max length: 4000
udf36

string

Max length: 4000
udf37

string

Max length: 4000
udf38

string

Max length: 4000
udf39

string

Max length: 4000
udf40

string

Max length: 4000
udf41

string

Max length: 4000
udf42

string

Max length: 4000
udf43

string

Max length: 4000
udf44

string

Max length: 4000
udf45

string

Max length: 4000
udf46

string

Max length: 4000
udf47

string

Max length: 4000
udf48

string

Max length: 4000
udf49

string

Max length: 4000
udf50

string

Max length: 4000
udf51

string

Max length: 4000
udf52

string

Max length: 4000
udf53

string

Max length: 4000
udf54

string

Max length: 4000
udf55

string

Max length: 4000
udf56

string

Max length: 4000
udf57

string

Max length: 4000
udf58

string

Max length: 4000
udf59

string

Max length: 4000
udf60

string

Max length: 4000
udf61

string

Max length: 4000
udf62

string

Max length: 4000
udf63

string

Max length: 4000
udf64

string

Max length: 4000
udf65

string

Max length: 4000
udf66

string

Max length: 4000
udf67

string

Max length: 4000
udf68

string

Max length: 4000
udf69

string

Max length: 4000
udf70

string

Max length: 4000
udf71

string

Max length: 4000
udf72

string

Max length: 4000
udf73

string

Max length: 4000
udf74

string

Max length: 4000
udf75

string

Max length: 4000
udf76

string

Max length: 4000
udf77

string

Max length: 4000
udf78

string

Max length: 4000
udf79

string

Max length: 4000
udf80

string

Max length: 4000
udf81

string

Max length: 4000
udf82

string

Max length: 4000
udf83

string

Max length: 4000
udf84

string

Max length: 4000
udf85

string

Max length: 4000
udf86

string

Max length: 4000
udf87

string

Max length: 4000
udf88

string

Max length: 4000
udf89

string

Max length: 4000
udf90

string

Max length: 4000
udf91

string

Max length: 4000
udf92

string

Max length: 4000
udf93

string

Max length: 4000
udf94

string

Max length: 4000
udf95

string

Max length: 4000
udf96

string

Max length: 4000
udf97

string

Max length: 4000
udf98

string

Max length: 4000
udf99

string

Max length: 4000
udf100

string

Max length: 4000