?

UPDATE DATE

?
EMPLOYEE ID [ONLY SHOW AVAIABLE EMPLOYEES]

?
TASK ID

?
TASK NAME
?
TIME FRAME

?
START DATE AND TIME
 
END DATE AND TIME
 
DURATION
?
RESOURCES NEEDED

?
ESTIMATED COST
?
EMPLOYEE RESOURCES

?
MACHINE RESOURCES

?
MACHINE ID [ONLY SHOW MACHINE WHICH ARE AVAIABLE]

?
REMARKS [IF ANY]
.
       


 TASK_IDTASK_NAMETIME_FRAME_NOSTIME_FRAME_DAYSSTART_DATESTART_TIMEEND_DATEEND_TIMEDURATIONRESOURCES_NEEDED_NORESOURCES_NEEDED_TYPEESTIMATED_COSTEMPLOYEE_RESOURCES_NOEMPLOYEE_RESOURCES_TYPEMACHINIE_RESOUCES_NOMACHINIE_RESOUCES_TYPEREMARKSIsEngagedEmployeeId
Select CROP ROTATION0DAYS      ADVERTISING  ACCOUNTS TRACTOR YES5
Select LAND PREPARATION5DAYS2023-06-1406:00   1EQUIPMENT 2FARMHANDS3TRACTOR YES1