Utilities
{{-- Table Job Operation --}} {{-- Table Customers --}} {{-- Table Contacts --}} {{-- Table Address --}} {{-- Table Sheet --}} {{-- Table Job --}} {{-- Table Employee --}} {{-- Table Attendance --}}
Description Options
Table Job Operation  
Fix table Job Operation, sum WC fields hours
Check the same sum in Jop Operation Time and Transaction Detail
Table Customer  
Fix table Customer, fill field Customer_Code
Fix table Customer, fill field Tax_Code_id
Fix table Customer, fill field Status_id
Fix table Customer, fill field Terms_id
Table Contacts  
Fix table Contacts, fill field Customer_Code
Table Address  
Fix table Address, fill field Customer_Code
Table SpecSheet  
Fix table sheet, fill field department_id
Fill employee field in Sheets table
Fill Status field in Sheets table
Table Job  
Fix table Job, check sum Act_Total_Hrs
Fix table Job, fill field Status_id
Fix table Job, fill field Due_Date
Fix table Job, fill field Customer_Code
Update fields Pat, Fat, Pro and Note_Text from User_Values to Job
Move Promised_Date from Delivery to Job
Move data Text5 from user_value to Job to WIP_Note
Fill New Note_Text with Old Note_Text and WIP_Note in Job
Table Employee  
Fix table Employee, fill field user_id
Table Transaction_Data  
Fix table Transaction_Data, fill field Attendance_id