| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier |
Required |
| jobs_id |
Foreign key of jobs |
globally unique identifier |
Required |
| user_id |
Foreign key, user that makes the approval |
globally unique identifier | |
| source_db_table_id |
Source Table used to generate this non part usage (Car_travel or user_timesheet) |
globally unique identifier | |
| source_id_in_table |
Source Object Id used to generate this non part usage (car_travel.id or user_timesheet.id) |
globally unique identifier | |
| working_date |
Date when the object has been generated |
date |
Required |
| timesheet_date_from |
In the case of a timesheet, the date+time FROM |
date | |
| timesheet_date_to |
In the case of a timesheet, the date+time TO |
date | |
| type_code |
Type of Non part (WorkingTime or TravelTime) |
string |
Max length: 50 |
| line_code |
code generated from the hour_type.code |
string |
Max length: 50 |
| description |
description generated from the hour_type.commercial_description |
string |
Max length: 255 |
| quantity |
Quantity converted in decimal (45 minutes is 0.75) |
decimal number | |
| price |
Unit Price computed via the hour_type (without discount) |
decimal number | |
| discount | decimal number | ||
| line_memo |
Extra memo on the line filled by the User |
string |
Max length: 4000 |
| job_approval_id |
Foreign key to the approval this lines belongs In case the line was already "included" inside a job approval (daily for exemple), then that value is field and row is now readonly |
globally unique identifier | |
| hour_type_id |
Hour type id |
globally unique identifier | |
| is_under_warranty |
Checking for warranty |
boolean | |
| no_warranty_reason |
Reason of no warranty |
string | |
| company_vat_id | globally unique identifier | ||
| vat_value | decimal number | ||
| vat_rate | decimal number | ||
| invoice_id | globally unique identifier | ||
| invoice_details_id | globally unique identifier | ||
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |