NameDescriptionTypeAdditional information
id

Primary Key

globally unique identifier

Required

jobs_id

Foreign key of jobs

globally unique identifier

Required

article_id

Foreign key of article. Can be empty if user keys in manually the object

globally unique identifier
user_id

Foreign key, user that uses this part

globally unique identifier

Required

article_stock_location_id

In case of stock management enabled, the stock that has been used

globally unique identifier
working_date

Date when the part has been used

date
code

Code of the part (filled by article.code or manually by the user)

string

Max length: 255

name

Name of the part (filled by article.name or manually by the user)

string

Max length: 255

description

Description of the part (filled by article.description or manually by the user)

string

Max length: 255

quantity

Quantity

decimal number

Required

Range: inclusive between 0.1 and 1.79769313486232E+308

price

Unit price of the part. Computed with the price logic or filled via purchase_order_details.price

decimal number
remark

Remark / Line memo

string

Max length: 255

purchase_order_details_id

Foreign key of purchase_order_details, if the line was generated based on a purchase_order_details

globally unique identifier
signed_by_company

Object was included in a job approval and signed (readonly)

boolean
job_approval_id

Foreign key to the approval this lines belongs

globally unique identifier
is_under_warranty

If the system detects that line was included in the warranty, price will be 0

boolean
modified_dateutc

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

date