| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier |
Required |
| jobs_id |
Foreign key of jobs |
globally unique identifier | |
| job_approval_id |
Job approval Id |
globally unique identifier | |
| article_stock_location_id |
In case of stock management enabled, the stock that has been used |
globally unique identifier | |
| article_id |
Foreign key of article. Can be empty if user keys in manually the object |
globally unique identifier | |
| is_dummy |
In case of dummy |
boolean | |
| article_code |
Article code |
string |
Max length: 255 |
| article_name |
Article name |
string |
Max length: 255 |
| article_description |
Article description |
string |
Max length: 255 |
| working_date |
Date when the part has been used |
date | |
| quantity |
Quantity |
decimal number | |
| serial_number |
When the article.use_serial then the serial should be saved here |
string |
Max length: 255 |
| price |
Unit price of the part. Computed with the price logic or filled via purchase_order_details.price |
decimal number | |
| is_under_warranty |
In case the logic detect that the parts was in warranty, this field will be set to true and the discount will be set equal to the price |
boolean | |
| discount |
Manual discount , in money, added by the technician |
decimal number | |
| purchase_order_details_id |
Foreign key of purchase_order_details, if the line was generated based on a purchase_order_details |
globally unique identifier | |
| user_id |
User Id |
globally unique identifier | |
| remark | string |
Max length: 255 |
|
| no_warranty_reason | string |
Max length: 255 |
|
| db_unit_of_measure_id | globally unique identifier | ||
| included_on_last_stock_compute | boolean | ||
| signed_by_company |
Needed for integration |
boolean | |
| 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 | ||
| is_customized | boolean | ||
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |