| Name | Description | Type | Additional information | 
|---|---|---|---|
| id | 
                         Primary Key  | 
                    globally unique identifier | 
                                 Required  | 
                
| jobs_id | 
                         Foreign key of the jobs  | 
                    globally unique identifier | 
                                 Optionally required : jobs_id, jobs_reference_back_office or jobs must be provided  | 
                
| jobs_reference_back_office | 
                         Embedded entity "jobs" using ERP PK when adding/updating  | 
                    string | 
                                 Optionally required : jobs_id, jobs_reference_back_office or jobs must be provided  | 
                
| jobs | 
                         Embedded entity "jobs" when adding/updating  | 
                    jobs | 
                                 Optionally required : jobs_id, jobs_reference_back_office or jobs must be provided  | 
                
| work_instruction_details_id | 
                         work instruction details id  | 
                    globally unique identifier | |
| work_instruction_details_reference_back_office | 
                         Embedded code "work instruction details" when adding/updating  | 
                    string | |
| work_instruction_details | 
                         Embedded entity "work instruction details" when adding/updating  | 
                    work_instruction_details | |
| user_id | 
                         Filled by the person that completed that item on the checklist  | 
                    globally unique identifier | |
| work_instruction_action_type | 
                         Value from work_instruction_action_type.name  | 
                    string | |
| work_instruction_id | 
                         work instruction id  | 
                    globally unique identifier | 
                                 Optionally required : work_instruction_id,work_instruction_reference_back_office or work_instruction must be provided  | 
                
| work_instruction_reference_back_office | 
                         Embedded code "work instruction" when adding/updating  | 
                    string | 
                                 Optionally required : work_instruction_id,work_instruction_reference_back_office or work_instruction must be provided  | 
                
| work_instruction | 
                         Embedded entity "work instruction" when adding/updating  | 
                    work_instruction | 
                                 Optionally required : work_instruction_id,work_instruction_reference_back_office or work_instruction must be provided  | 
                
| name | 
                         The "on what"  | 
                    string | 
                                 Required Max length: 4000  | 
                
| status | 
                         Status can be Ok,NotOk,Replaced,NotApplicable  | 
                    string | 
                                 Max length: 50  | 
                
| date_done | 
                         Datetime filled when status goes to one valable status.  | 
                    date | |
| remark | 
                         Additional remark from the technician.  | 
                    string | 
                                 Max length: 255  | 
                
| advise | 
                         Additional advice from the technician.  | 
                    string | 
                                 Max length: 255  | 
                
| sequence | 
                         To order it.  | 
                    integer | |
| reference_back_office | 
                         The Id/Ref of the back office for this job work instruction. Used by Embedded entity  | 
                    string | 
                                 Max length: 255  | 
                
| group_name | 
                         Name of the group  | 
                    string | 
                                 Max length: 4000  | 
                
| group_sequence | 
                         Order of the group  | 
                    integer | |
| type | 
                         One of the possible types which are Regular, Form, Picture, UsedParts, BillableHours. Regular is the default  | 
                    string | |
| instruction_document_count | 
                         Specify how many documents/photos must be added if type is Picture  | 
                    integer | |
| db_report_type_id | 
                         When type is Form, you must specify which db_report_type must be filled  | 
                    globally unique identifier | |
| db_report_type_name | 
                         When type is Form, you must specify which db_report_type must be filled  | 
                    string | |
| modified_dateutc | 
                         Readonly system field managed by database, filled with GetUtcDate when adding,updating  | 
                    date |