{{-- 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