|
<< Click to Display Table of Contents >> TSINP Import Time Sheets |
  
|
TSINP Import Time Sheets
|
<< Click to Display Table of Contents >> TSINP Import Time Sheets |
|
Imports employee time sheet transactions from a CSV (Comma delimited) file.
File format:
A. B. C. D. E. F. G. H. I. |
Employee JobCode Activity StartDate StartTime EndDate EndTime Time TranType |
U10 U10 U10 DD/MM/YYYY HH:MM DD/MM/YYYY HH:MM N4.2 U2 |
Valid employee code Valid job code Valid activity code 31/03/2006
31/03/2006
(Hours to be paid in hours) Valid Tran Type, (JL, JM, JS, GL, PR) JL = Job Labout JM = Job Material JS = Job Sub Contractor GL = General Ledger PR = Projects |
If the Time field is zero the hours input to the timesheet is computed from the Start Date & Time and the End Date & Time.
Otherwise the hours in the Time field is the hours input to the timesheet.