NameDescriptionTypeAdditional 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

Required

ready_for_multi_approval

Inform if this is a temp approval prepared for a future approval with the customer (multi approval)

boolean
is_daily_approval

Intermediate approval of full approval

boolean
contact_id

Foreign key of contact, that signed the approval

globally unique identifier
contact_name

Contact fullname that sign the approval if not already exists

string

Max length: 255

customer_remarks

Remarks of the customer during the approval

string

Max length: 4000

date_generated

Local Date+Time of the approval generation

date
additional_email

Additional emails that should receive the approval pdf

string

Max length: 4000

is_signed

Inform if a signature is available (cf db_signature)

boolean
job_status_id

Job Status that will be used to alter the jobs (WaitingFurtherAction,Completed)

globally unique identifier
rating

Rating (0,5) the quality of the jobs

integer
modified_dateutc

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

date