{{-- Table Job Operation --}}
Table Job Operation |
|
Fix table Job Operation, sum WC fields hours |
|
Check the same sum in Jop Operation Time and Transaction Detail |
|
{{-- Table Customers --}}
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 --}}
Table Contacts |
|
Fix table Contacts, fill field Customer_Code |
|
{{-- Table Address --}}
Table Address |
|
Fix table Address, fill field Customer_Code |
|
{{-- Table Sheet --}}
Table SpecSheet |
|
Fix table sheet, fill field department_id |
|
Fill employee field in Sheets table |
|
Fill Status field in Sheets table |
|
{{-- Table Job --}}
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 --}}
Table Employee |
|
Fix table Employee, fill field user_id |
|
{{-- Table Attendance --}}
Table Transaction_Data |
|
Fix table Transaction_Data, fill field Attendance_id |
|