| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary key |
globally unique identifier |
Required |
| id2 |
id2 |
integer |
Required |
| reference_back_office |
Backoffice reference |
string | |
| name |
Name of the contract |
string | |
| company_id |
Foreign key of the company this contract belongs to. |
globally unique identifier | |
| contract_type_id |
Foreign key of the contract's type (see ). |
globally unique identifier | |
| contract_status_id |
Foreign key of the contract's current status. |
globally unique identifier | |
| internal_remark |
Internal remark about the contract, not shown to the customer. |
string | |
| date_start |
Date and time from which the contract is valid. |
date | |
| date_end |
Date and time until which the contract remains valid. |
date | |
| hours_free_for_preventive_jobs |
Hours free for preventive jobs |
boolean | |
| feelist_id |
Feelist id |
globally unique identifier | |
| article_price_label_id |
Article price label id |
globally unique identifier | |
| travel_fee_fix_discount |
Fixed discount amount applied to travel fees billed under this contract. |
decimal number | |
| articles_free_for_preventive_jobs |
Indicates that articles used on preventive jobs are free of charge under this contract. |
boolean | |
| reference |
Free-text reference for this contract. |
string | |
| discount |
Default discount percentage applied to billable lines under this contract. |
decimal number | |
| company_discount_family_id |
Foreign key of the discount family this contract's pricing follows, when scoped by discount family. |
globally unique identifier | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |